var jsonFormatDesign={code:"S_PERCHECKCOUNT",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_check.id = lib_per_detail_check.checkid",width:"900",height:"600",top:80,left:180,tableArr:[{name:"lib_per_check"}]};var fieldComBoxData=[{field:"count(distinct lib_per_check.bibid)",name:"种数"},{field:"count(distinct lib_per_check.id)",name:"订购数"},{field:"sum(lib_per_detail_check.ORDERCOPIES)",code:"zjdcs",name:"总记到册数"},{field:"count(distinct lib_per_detail_check.id)",code:"zjdqs",name:"总记到期数"},{field:"sum(lib_per_detail_check.copies)",code:"sjdcs",name:"实记到册数"},{field:"sum(case when lib_per_detail_check.status in ('1','2','4') then 1 else 0 end )",code:"sjdqs",name:"实记到期数"},{field:"sum(nvl(lib_per_check.price,0.0)*lib_per_detail_check.copies)",name:"册价和",format:"%.2f"},];var initJson=[{code:"lib_bibliography.classno",name:"分类号"},{code:"lib_bibliography.language",name:"语种"},{code:"lib_per_check.libcode",name:"订购馆"},{code:"bookseller",name:"文献提供方"},{code:"mediatype",name:"载体类型"},{code:"docsources",name:"来源方式"},{code:"substr(to_char(checkdate),0,4)",key:"dgn",name:"订购年"},{code:"substr(to_char(lib_per_detail_check.ACTUALDATE),0,4)",key:"yyyy",name:"记到年"},{code:"substr(to_char(lib_per_detail_check.ACTUALDATE),0,6)",key:"yyyymm",name:"记到月"},{code:"to_char(lib_per_detail_check.ACTUALDATE)",key:"logdate",name:"记到日"}];var countFormatDesignFieldComBoxData;$(function(){initSrceenAndJson();_myPage.prototype.initDataOne({code:"sysid",key:"sysid",condition:"type",value:"1"})});