generator-refresh

online update the sub  total {refresh}

0.90,payroll.grosspay,num.2,10%,10,Gross Income (a),,{currency}{readonly}{refresh}_refreshv('payroll.grosspay',parseFloat(1*_lookup('payroll.basic')+1*_lookup('payroll.payback')+1*_lookup('payroll.bonus')+1*_lookup('payroll.addothers')).toFixed(2));{/refresh}




ajax on display database information {refresh}

0.10,sys.total,text,100%:100px:100px,10,:Bank Total Amount,,{inLineStyle}text-align:right;{/inLineStyle}{currency}{refresh}s= 'http://192.168.10.80:8080/hr/tableRead?table=payroll&fields=sum(netpay)&key=bankstatus&value="B"&format=S&callback=?'; $.getJSON(s,function(data) {if (data[0]){_refreshv("sys.total",data[0][0]);}});{/refresh}

ajax on display database information {refresh} multi field

0.10,sys.mpftotal,text,100%:100px:100px,10,:MPF Amount,,{inLineStyle}text-align:right;{/inLineStyle}{currency}{refresh}s= 'http://192.168.10.80:8080/hr/tableRead?table=payroll&fields=sum(mpf),sum(mpfemployee),sum(mpfemployer)&key=mpfstatus&value="S"&format=S,S,S&callback=?'; $.getJSON(s,function(data) {if (data[0]){_refreshv("sys.mpftotal",translate(data[0][0],2));_refreshv("sys.mpfemployee",translate(data[0][1],2));_refreshv("sys.mpfemployer",translate(data[0][2],2)); }});{/refresh}