var jsonFormatDesign={code:"E_ACQMISSINGLIST",table:"lib_holdings left join lib_bibliography on lib_holdings.bibid=lib_bibliography.id left join lib_acq_check on lib_holdings.checkid=lib_acq_check.id",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_acq_check"}]};var fieldComBoxData=[{field:"lib_acq_check.libcode",code:"libcode",name:"分馆代码"},{field:"lib_acq_check.orderno",code:"orderno",name:"订购号"},{field:"lib_acq_check.batchno",code:"batchno",name:"批号"},{field:"lib_acq_check.copies",code:"copies",name:"副本数"},{field:"lib_acq_check.ncy",code:"ncy",name:"采访币值"},{field:"lib_acq_check.price",code:"price",name:"采访价格"},{field:"lib_acq_check.totalprice",code:"totalprice",name:"采访总价"},{field:"lib_acq_check.orderncy",code:"orderncy",name:"验收币值"},{field:"lib_acq_check.orderprice",code:"orderprice",name:"验收价格"},{field:"lib_acq_check.ordertotalprice",code:"ordertotalprice",name:"验收总价"},{field:"lib_acq_check.binding",code:"binding",name:"装帧标识"},{field:"lib_acq_check.docsources",code:"docsources",name:"文献来源"},{field:"lib_acq_check.finsources",code:"finsources",name:"财经来源"},{field:"lib_acq_check.mediatype",code:"mediatype",name:"载体类型"},{field:"lib_acq_check.bookseller",code:"bookseller",name:"订购书商"},{field:"lib_acq_check.checkdate",code:"checkdate",name:"验收日期"},{field:"lib_acq_check.operid",code:"operid",name:"操作员"},{field:"lib_acq_check.volumes",code:"volumes",name:"卷数"},{field:"lib_acq_check.volinfo",code:"volinfo",name:"卷册说明"},{field:"lib_acq_check.note",code:"note",name:"备注"}];var bibFldComBoxData=bibExpFld;$(function(){fieldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="订购字段"});bibFldComBoxData.forEach(function(a,b,c){a.group="书目字段";fieldComBoxData.push(a)});fieldComBoxData.push({field:"num",code:"num",name:"催收数",group:"催收数",total:"1"});jsonFormatDesign.table="lib_bibliography left join lib_acq_check on lib_bibliography.id=lib_acq_check.bibid  left join ( select bibid lbibid,num from ( select bibid,sum(copies)-( select nvl(sum(b.copies),0)from  lib_acq_check b where  a.bibid = b.bibid group by b.bibid) num   from lib_acq_order a where a.ordstatus='0' group by  a.bibid )c where num>0  )d  on lib_bibliography.id=d.lbibid ";initSrceenDataByJson()});