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"})};