var jsonFormatDesign={code:"S_HLDUSECIRCOUNT",table:"lib_cir_reader",width:"900",height:"600",top:80,left:180,tableArr:[{name:"lib_holdings"},{name:"lib_cir_log"}]};var fieldComBoxData=[{field:"count(distinct lib_holdings.id)",name:"总册数"},{field:"count(distinct lib_holdings.bibid)",name:"借阅种数"},{field:"count(lib_holdings.id)",name:"借出册数"},{field:"count(lib_holdings.id)/(select count(1) from lib_cir_reader where status='0')",name:"人均持书量",format:"%.2f"},{field:"count (distinct lib_cir_log.hldid)",name:"借阅次数(去重)"},{field:"count (distinct lib_cir_log.hldid)/ case when count (lib_holdings.id) = 0 then 1 else count (lib_holdings.id) end",name:"借阅率(借阅次数/借出册数)",format:"%.2f"},{field:"count(lib_holdings.id)/count(distinct lib_holdings.id)",name:"利用率(借出册数/总册数)",format:"%.2f"}];var initJson=[{code:"lib_holdings.callno",key:"classno",name:"索书号",condition:"stattype",value:"1"},{code:"lib_holdings.doctype",key:"doctype",name:"文献类型"},{code:"lib_holdings.mediatype",key:"mediatype",name:"载体类型"},{code:"lib_holdings.bindtype",key:"bindtype",name:"装帧标识"},{code:"to_char(lib_cir_log.operid)",name:"操作员",key:"operid",condition:"libcode",value:vLibcode},{code:"lib_holdings.libcode",name:"文献馆",key:"libcode",condition:"code",value:vLibcode},{code:"to_char(lib_holdings.libcode)",name:"文献馆("+vLiblevel+"级馆)",key:"libcode",condition:"code",value:vLibcode},{code:"lib_cir_log.libcode",name:"服务馆",key:"libcode",condition:"code",value:vLibcode},{code:"lib_cir_log.loccode",name:"操作地点",key:"loccode"},{code:"substr(to_char(logdate),0,4)",key:"yyyy",name:"年"},{code:"substr(to_char(logdate),0,6)",key:"yyyymm",name:"月"},{code:"to_char(logdate)",key:"logdate",name:"日"},];var countFormatDesignFieldComBoxData=initJson;$(function(){jsonFormatDesign.table="lib_cir_log JOIN lib_holdings ON (lib_cir_log.bibid = lib_holdings.bibid) left join lib_bibliography on (lib_cir_log.bibid=lib_bibliography.id) ";var d=[{key:"libcode",condition:"code",value:vLibcode},{key:"loccode",condition:"libcode",value:vLibcode},{key:"operid",condition:"libcode",value:vLibcode},{code:"logtype",key:"cirlogtype"},];commonSetParaInit(null,"export_record",null,d);setFormatDesignFieldComBoxData();if($("#locprop").length>0){var c="";var b=base_path+"par/comcodename/list.do";var a=0;var e={};e["limit["+a+"].condition"]="type";e["limit["+a+"].typeHandler"]="0";e["limit["+a+"].value"]="3";$.post(b,e,function(g){var f=g.rows;$("#locprop").combobox({data:g.rows,valueField:"id",groupField:"group",textField:"name",panelHeight:"auto",loadFilter:function(h){var i={};i.id="";i.name="无";h.splice(0,0,i);return h},});initLoactionAtrr()},"json")}});function initLoactionAtrr(){var c="";var b=base_path+"par/location/list.do";var a=0;var d={};d["limit["+a+"].condition"]="libcode";d["limit["+a+"].typeHandler"]="3";d["limit["+a+"].value"]=getLibLimitForNoLimitLib();$.post(b,d,function(f){var e=f.rows;$("#curlocation").datagrid("loadData",e);$("#location").datagrid("loadData",e)},"json")};