Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\statistics\js\sta_per_checkcount.js
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"})});
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de