var jsonFormatDesign={code:"S_RDRNLIBCIRDATACOUNT",table:"lib_cir_reader",width:"900",height:"600",top:80,left:180,tableArr:[{name:"lib_cir_log"}]};var fieldComBoxData=[{field:"count(distinct lib_cir_log.rdrid)",name:"借阅人数"},{field:"count(distinct lib_cir_log.rdrid||logdate||logtype)",name:"借阅人次"},{field:"count(distinct lib_cir_log.rdrid||trunc(logstamp/300000)||logtype)",name:"借阅人次（五分钟）"},{field:"count(distinct lib_cir_log.bibid)",name:"借阅种数"},{field:"count(distinct lib_cir_log.hldid)",name:"借阅册数"},{field:"count(lib_cir_log.id)",name:"借阅册次"},{field:"count(distinct lib_cir_log.hldid)/count(distinct lib_cir_log.rdrid)",name:"平均借阅量",format:"%.2f"},{field:"count(distinct lib_cir_log.hldid)/(select count(1) from lib_cir_reader where status='0')",name:"人均借阅量（所有读者）",format:"%.2f"}];var initJson=[{code:"rdrtype",key:"rdrtype",condition:"libcode",value:vLibcode},{code:"lib_cir_reader.libcode",key:"libcode",condition:"code",value:vLibcode},{code:"to_char(lib_cir_reader.libcode)",name:"开户馆("+vLiblevel+"级馆)",key:"libcode",condition:"code",value:vLibcode},{code:"lib_cir_log.libcode",key:"libcode",condition:"code",value:vLibcode},{code:"lib_holdings.libcode",key:"libcode",condition:"code",value:vLibcode},{code:"lib_cir_log.loccode",key:"loccode",condition:"libcode",value:vLibcode},{code:"to_char(lib_cir_log.operid)",key:"operid",condition:"libcode",value:vLibcode},{code:"gender",key:"gender"},{code:"lib_cir_reader.operaway",key:"operaway"},{code:"rdrfld1",key:"rdrfld1",condition:"parentid",value:"1"},{code:"rdrfld2",key:"rdrfld2",condition:"parentid",value:"2"},{code:"rdrfld3",key:"rdrfld3",condition:"parentid",value:"3"},{code:"rdrfld4",key:"rdrfld4",condition:"parentid",value:"4"},];var countFormatDesignFieldComBoxData=[{code:"rdrtype",name:"读者类型"},{code:"lib_cir_log.logtype",name:"操作类型"},{code:"lib_cir_reader.libcode",name:"开户馆"},{code:"to_char(lib_cir_reader.libcode)",name:"开户馆("+vLiblevel+"级馆)",key:"libcode",condition:"code",value:vLibcode},{code:"lib_cir_reader.unit",name:"工作单位"},{code:"lib_cir_log.libcode",name:"服务馆"},{code:"lib_holdings.libcode",name:"文献所在馆"},{code:"lib_cir_log.loccode",name:"操作地点"},{code:"gender",name:"读者性别"},{code:"lib_cir_reader.operaway",name:"操作方式"},{code:"to_char(lib_cir_log.operid)",name:"操作员"},{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:"日"}];exportfdInitComboxArr=[{code:"lib_cir_log_libcode",key:"libcode",condition:"code",value:vLibcode}];$(function(){jsonFormatDesign.table="lib_cir_log  left join lib_cir_reader on (rdrid=lib_cir_reader.id)";jsonFormatDesign.table=" LIB_CIR_LOG LEFT JOIN lib_cir_reader ON LIB_CIR_LOG.rdrid = lib_cir_reader.id LEFT JOIN lib_holdings ON lib_holdings.id = LIB_CIR_LOG.hldid LEFT JOIN lib_bibliography ON LIB_CIR_LOG.bibid = lib_bibliography.id  ";var a=[{key:"rdrtype",condition:"libcode",value:vLibcode},{key:"libcode",condition:"code",value:vLibcode},{key:"operid",condition:"libcode",value:vLibcode},{key:"rdrfld1",condition:"parentid",value:"1"},{key:"rdrfld2",condition:"parentid",value:"2"},{key:"rdrfld3",condition:"parentid",value:"3"},{key:"rdrfld4",condition:"parentid",value:"4"},{code:"logtype",key:"cirlogtype"},];commonSetParaInit(null,"export_record",null,a);initFormatDesignFieldComBoxData();$("#export_beg_logstamp").datetimebox("setValue",getAddYMD(null,null,null,"-")+" 00:00:00");$("#export_end_logstamp").datetimebox("setValue",getAddYMD(null,null,null,"-")+" 23:59:59")});function initFormatDesignFieldComBoxData(){var b={key:"rdrfld0",condition:"parentid",value:"0"};var a=base_path+"par/common/getInitData.do";$.post(a,b,function(f){var e=f.rows;for(var d=0;d<e.length;d++){var c={code:"rdrfld"+e[d].code,name:e[d].name};countFormatDesignFieldComBoxData.push(c)}if(countFormatDesignFieldComBoxData.length>0){setFormatDesignFieldComBoxData()}},"json")}var dataRows=[{code:"301",name:"专项借出"},{code:"302",name:"专项续借"},{code:"401",name:"专项还回"},{code:"402",name:"专项污损"},{code:"403",name:"专项丢失"}];function onInitTextLogType(c){var b="";dataRows=$("#cirlogtype").datagrid("getRows");var d=dataRows;for(var a=0;a<d.length;a++){b+=d[a].code+"|"+d[a].name+"\n"}if(c==1){setValue("formatdesign_item_value1",b)}else{if(c==2){setValue("formatdesign_item_value2",b)}}}function getIdByCondition(a){return a.replace("export_beg_","").replace("export_end_","").replace("export_","").replace("lib_cir_log_","")}function getJsonAddOtherCondtion(a,c){var b=getValue("cirlogtype");if(b.length>0){a["limit["+c+"].condition"]="lib_cir_log.logtype";a["limit["+c+"].typeHandler"]="3";a["limit["+c+"].value"]=b;c++}var d=getValue("outputType");a.sqlLimit=d;a.sqlLimitIndex=c;c++;return a};