var jsonFormatDesign={code:"E_ACQ_COUNTLIST",table:" lib_acq_check ",groupby:"group by lib_acq_check.batchno",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_acq_check"}]};var fieldComBoxData=[{field:"lib_acq_check.libcode",code:"libcode",name:globalLibName+"代码"},{field:"lib_acq_check.orderno",code:"orderno",name:"订购号"},{field:"lib_acq_check.batchno",code:"batchno",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:"to_char(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.billno",code:"billno",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="验收字段"});fieldComBoxData.push({field:"count(lib_acq_check.id)",code:"copies",name:"验收册数",group:"验收字段",total:"1"});fieldComBoxData.push({field:"count(distinct lib_acq_check.bibid)",code:"count",name:"验收种数",group:"验收字段",total:"1"});fieldComBoxData.push({field:"sum(NVL(lib_acq_check.price*lib_acq_check.copies, 0.0))",code:"checktotalprice",name:"原币总价",group:"验收字段",total:"1"});fieldComBoxData.push({field:"sum(NVL(lib_acq_check.orderprice*lib_acq_check.copies, 0.0))",code:"checktotalprice1",name:"验收总价",group:"验收字段",total:"1"});fieldComBoxData.push({field:"(select COUNT (DISTINCT lib_holdings.id) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"hldcopies",name:"馆藏册数",group:"馆藏字段",total:"1"});fieldComBoxData.push({field:"(select COUNT (DISTINCT lib_holdings.bibid) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"hldcount",name:"馆藏种数",group:"馆藏字段",total:"1"});fieldComBoxData.push({field:"(select SUM (NVL (lib_holdings.price, 0.0)) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"hldtotalprice",name:"馆藏总价",group:"馆藏字段",total:"1"});fieldComBoxData.push({field:"(select min(barcode) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"minbarcode",name:"最小条码",group:"馆藏字段"});fieldComBoxData.push({field:"(select max(barcode) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"maxbarcode",name:"最大条码",group:"馆藏字段"});initSrceenDataByJson()});