generator-example-sql-enquiry {setConstrain}

0.22,query.datefrom,date,5,100,Date From,,{setConstrain}_c1=_lookup('query.datefrom');if(_c1){_c01='datestart>:`'+_c1+'`'} {/setConstrain}
0.22,query.dateto,date,5,100,:Date To,,{setConstrain}_c2=_lookup('query.dateto');if(_c2){_c02='dateend<:`'+_c2+'`'} {/setConstrain}
0.24,query.employeeNumber,combo,20%:200px:400px,40,Employee Name,,{setConstrain}_c3=_lookup('query.employeeNumber');if(_c3){_c03='employeeNumber:`'+_c3+'`'}{/setConstrain}{events}onchange="keyValue=this.value; retrieval();"{/events} {getJson}tableRead?table=employee&fields=alias,employeenumber&where=where status:`A` or status:`T` &format=S,S&callback=?{/getJson} 
0.26,query.Create,button,0,0,:Go,,{onclick}retrieval();{/onclick}{inLineStyle}font-size:16px;height:23px; magin-top:0px;padding-top:0px;{/inLineStyle}
0.6,payrollListConfirm.batchName,text:GRID,5,100,payroll
0.6,payrollListConfirm.datestart,text:GRID,6,100,date start
0.6,payrollListConfirm.dateend,text:GRID,6,100,date end
0.6,payrollListConfirm.ContractType,text:GRID,6,100,Type
0.6,payrollListConfirm.alias,text:GRID,6,150,Name
0.6,payrollListConfirm.Surname,text:GRID,6,150,F.Name
0.6,payrollListConfirm.DepartmentName,text:GRID,10,15,Dept
0.6,payrollListConfirm.NetPay,text:GRID,6,15,Net,,{inLineStyle}text-align:right;{/inLineStyle}{currency}
0.6,payrollListConfirm.remark,text:GRID,10,15,Remark
0.6,payrollListConfirm.recordID,hidden:GRID,0,18,