var jsonFormatDesign={code:"E_ACQBEFORECHECKLIST",table:"lib_bibliography left join lib_acq_check on lib_bibliography.id=lib_acq_check.bibid ",width:"800",height:"600",top:80,left:180,groupby:" group by lib_bibliography.id ",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:"regexp_replace(listagg(lib_acq_check.batchno,';') within group (order by lib_acq_check.batchno),'([^;]+)(;\\1)*(;|$)','\\1\\3')",code:"batchno",name:"批号"},{field:"lib_acq_check.ncy",code:"ncy",name:"原币制"},{field:"lib_acq_check.price",code:"acqprice",name:"原币册价"},{field:"lib_acq_check.orderncy",code:"orderncy",name:"验收币制"},{field:"lib_acq_check.orderprice",code:"orderprice",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:"备注"},{field:"count(distinct lib_acq_check.id)",code:"checknum",name:"验收次数"},{field:"sum(lib_acq_check.copies)",code:"ccopies",name:"验收复本数"},{field:"sum(case when lib_acq_check.copies > 0 then lib_acq_check.orderprice*lib_acq_check.copies else 0 end)",code:"ordertotalprice",name:"验收总价"},];var bibFldComBoxData=bibExpFld;var holdFldComBoxData=[{field:"sum((select   count(lib_holdings.bibid)  from   lib_holdings where  lib_holdings.checkid = lib_acq_check.id))",code:"hldcopies",name:"馆藏复本数"},{field:"sum((select   sum(lib_holdings.price)  from   lib_holdings where  lib_holdings.checkid = lib_acq_check.id))",code:"hldtotalprice",name:"馆藏总价",total:"1"},{field:"min((select   listagg(lib_holdings.barcode,';') within group (order by lib_holdings.barcode)  from   lib_holdings join lib_acq_check on (lib_holdings.checkid=lib_acq_check.id) where   checkid in (select checkid from lib_holdings where  lib_holdings.bibid = lib_bibliography.id) ))",code:"listbarcode",name:"条码号"},{field:"min((select   regexp_replace(listagg(lib_holdings.callno,';') within group (order by lib_holdings.callno),'([^;]+)(;\\1)*(;|$)','\\1\\3')  from   lib_holdings join lib_acq_check on (lib_holdings.checkid=lib_acq_check.id) where   checkid in (select checkid from lib_holdings where  lib_holdings.bibid = lib_bibliography.id) ))",code:"callno",name:"索书号"}];$(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)});holdFldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="馆藏字段";fieldComBoxData.push(a)});initSrceenDataByJson()});function getSortFieldArr(){return sortFldJsonArr=[{field:"count(distinct lib_acq_check.id)",code:"checknum",name:"验收次数"},{field:"sum(lib_acq_check.copies)",code:"copies",name:"复本数"}]}function getJsonAddOtherCondtion(b,c){var a=getValue("location");if(a.length>0){b.ysazlocation=a;b.condtionIndex=c;c++}return b};