Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\statistics\js\sta_rdr_circulationcount.js
var jsonFormatDesign={code:"S_RDRCIRCULATION",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_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_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)";var b=[{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,b);var a={key:"rdrfld0",condition:"parentid",value:"0"};initPageDataSingleElement("rdrfld0",a,showRdrFldName);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=$("#logtype").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 showRdrFldName(){var b=$("#rdrfld0").combobox("getData");if(b.length>0){for(var a=0;a<b.length;a++){$(".show-rdrfld"+b[a].code).html(b[a].name)}}}function getIdByCondition(a){return a.replace("export_beg_","").replace("export_end_","").replace("export_","").replace("lib_cir_log_","")};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de