var jsonFormatDesign={code:"E_PERCHECKLIST",table:"lib_bibliography right join lib_per_check on lib_bibliography.id=lib_per_check.bibid   LEFT JOIN lib_per_detail_check ON (lib_per_detail_check.checkid = lib_per_check.id AND lib_per_detail_check.status in ('1','2','4')) LEFT JOIN LIB_PER_ALLOCATION ON (LIB_PER_ALLOCATION.linkid = lib_per_detail_check.id AND LIB_PER_ALLOCATION.TYPE = '1')",groupby:"group by lib_per_check.id",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_per_check"}]};var fieldComBoxData=[{field:"lib_per_check.libcode",code:"libcode",name:globalLibName+"代码"},{field:"lib_per_check.orderno",code:"orderno",name:"记到号"},{field:"lib_per_check.batchno",code:"batchno",name:"批号"},{field:"lib_per_check.copies",code:"copies",name:"复本数"},{field:"lib_per_check.price",code:"totalprice",name:"记到价格"},{field:"lib_per_check.yearprice",code:"yearprice",name:"记到年价"},{field:"lib_per_check.year",code:"year",name:"记到年"},{field:"lib_per_check.docsources",code:"docsources",name:"来源方式"},{field:"lib_per_check.mediatype",code:"mediatype",name:"载体类型"},{field:"lib_per_check.bookseller",code:"bookseller",name:"记到文献提供方"},{field:"lib_per_check.checkdate",code:"orderdate",name:"记到日期"},{field:"to_char(lib_per_check.operid)",code:"operid",name:"操作员"},{field:"lib_per_check.issuenum",code:"issuenum",name:"期数"},{field:"lib_per_check.frequency",code:"frequency",name:"出版周期"},{field:"(select count( lib_per_detail_check.id) from lib_per_detail_check where lib_per_check.id = lib_per_detail_check.checkid and lib_per_detail_check.status in ('1','2','4'))",code:"sjdqs",name:"实记到期数"},{field:"(select sum( lib_per_detail_check.copies)from lib_per_detail_check where lib_per_check.id = lib_per_detail_check.checkid and lib_per_detail_check.status in ('1','2','4'))",code:"sjdcs",name:"实记到册数"},{field:"(select listagg( 'no.'||lib_per_detail_check.issue||':'||lib_per_detail_check.copies ,';') within group (order by sortfld) from lib_per_detail_check where lib_per_check.id = lib_per_detail_check.checkid and lib_per_detail_check.status in ('1','2','4')and lib_per_detail_check.issue is not null   group by lib_per_detail_check.checkid)",code:"sjdq",name:"实记到期"},{field:"lib_per_check.note",code:"note",name:"备注"},{field:"LIB_PER_ALLOCATION.loccode",code:"loccode",name:"馆藏地点"}];var bibFldComBoxData=bibExpFld;bibFldComBoxData.push({field:"lib_bibliography.orderno",name:"订购刊号",code:"biborderno"});bibFldComBoxData.push({field:"lib_bibliography.unifiedno",name:"统一刊号",code:"unifiedno"});$(function(){fieldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="记到字段"});bibFldComBoxData.forEach(function(a,b,c){if(a.code=="isbn"){a.name="ISSN号"}a.group="书目字段";fieldComBoxData.push(a)});initSrceenDataByJson();_myPage.prototype.initDataOne({code:"sysid",key:"sysid",condition:"type",value:"1"})});