Edit D:\rfid\libsystem\page\export\js\exp_rdr_readerfinelist.js
function addOtherfieldComBoxData(){jsonFormatDesign.table="lib_cir_reader left join (select rdrid,sum(money) as debt from lib_cir_curfine where type in ('1','2','3','4','9','a','b','c') group by rdrid) fine on fine.rdrid=lib_cir_reader.id right join (select rdrid,sum(money) as deposit from lib_cir_curfine where type in ('0','8') group by rdrid) fine1 on fine1.rdrid=lib_cir_reader.id";jsonFormatDesign.code="E_READERFINELIST";fieldComBoxData.push({field:"lib_cir_reader.debt",code:"debt",name:"???",group:"??????",total:"1"});fieldComBoxData.push({field:"lib_cir_reader.deposit",code:"deposit",name:"???",group:"??????",total:"1"})};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de