var jsonFormatDesign={code:"E_PERQKWDLIST",table:"lib_cir_reader",groupby:"group by lib_per_detail_check.id,a.loccode",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_per_check"},{name:"lib_per_detail_check"}]};var fieldComBoxData=[{field:"lib_per_check.year",code:"year",name:"记到年"},{field:"lib_per_check.frequency",code:"frequency",name:"出版周期"},{field:"lib_per_check.issuenum",code:"issuenum",name:"期数"},{field:"lib_per_check.batchno",code:"batchno",name:"批号"},{field:"sum(lib_per_check.copies)",code:"copies",name:"复本数"},{field:"lib_per_check.price",code:"price",name:"册价"},{field:"lib_per_check.yearprice",code:"yearprice",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_detail_check.expectdate",code:"expectdate",name:"预计日期"},{field:"a.loccode",code:"loccode",name:"馆藏地点"},{field:"sum(a.copies - nvl(b.copies,0))",code:"cnt",name:"未到数量"}];$(function(){fieldComBoxData.forEach(function(b,c,d){if(totalFld.indexOf(","+b.code+",")>-1){b.total="1"}b.group="记到字段"});jsonFormatDesign.table="lib_per_check JOIN lib_per_detail_check ON ( lib_per_detail_check.checkid = lib_per_check.id AND lib_per_detail_check.status IN (0, 2) )JOIN lib_bibliography ON lib_per_detail_check.bibid = lib_bibliography.id left JOIN lib_per_allocation a ON (lib_per_detail_check.checkid = a.linkid and a.type='2') left JOIN lib_per_allocation b ON (lib_per_detail_check.id = b.linkid and b.type='1' and a.loccode = b.loccode )";fieldComBoxData.push({field:"lib_bibliography.title",code:"title",name:"题名",group:"书目字段"});fieldComBoxData.push({field:"lib_bibliography.author",code:"author",name:"责任者",group:"书目字段"});fieldComBoxData.push({field:"lib_bibliography.publish",code:"publish",name:"出版社",group:"书目字段"});fieldComBoxData.push({field:"lib_bibliography.unifiedno",code:"unifiedno",name:"统一刊号",group:"书目字段"});fieldComBoxData.push({field:"lib_bibliography.orderno",code:"orderno",name:"订购刊号",group:"书目字段"});var a=[{key:"libcode",condition:"code",value:vLibcode},];commonSetParaInit(null,"export_record",null,a);_myPage.prototype.initDataOne({code:"sysid",key:"sysid",condition:"type",value:"1"})});function getSortFieldArr(){return sortFldJsonArr=[{field:"sum(a.copies - nvl(b.copies,0))",code:"cnt",name:"未到数量"}]}function getJsonAddOtherCondtion(a,b){a["limit["+b+"].condition"]="nvl(b.copies,0)";a["limit["+b+"].typeHandler"]=5;a["limit["+b+"].value"]="a.copies-1";a["limit["+b+"].valueflag"]="1";b++;return a};