Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exp_per_checklist.js
var jsonFormatDesign={code:"E_PERCHECKLIST",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_detail_check.checkid = lib_per_check.id AND lib_per_detail_check.status in ('1','2','4')) LEFT JOIN LIB_PER_ALLOCATION ON (LIB_PER_ALLOCATION.linkid = lib_per_detail_check.id AND LIB_PER_ALLOCATION.TYPE = '1')",groupby:"group by lib_per_check.id",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_per_check"}]};var fieldComBoxData=[{field:"lib_per_check.libcode",code:"libcode",name:globalLibName+"???"},{field:"lib_per_check.orderno",code:"orderno",name:"?????"},{field:"lib_per_check.batchno",code:"batchno",name:"???"},{field:"lib_per_check.copies",code:"copies",name:"?????"},{field:"lib_per_check.price",code:"totalprice",name:"??????"},{field:"lib_per_check.yearprice",code:"yearprice",name:"??????"},{field:"lib_per_check.year",code:"year",name:"?????"},{field:"lib_per_check.docsources",code:"docsources",name:"??????"},{field:"lib_per_check.mediatype",code:"mediatype",name:"??????"},{field:"lib_per_check.bookseller",code:"bookseller",name:"???????????"},{field:"lib_per_check.checkdate",code:"orderdate",name:"??????"},{field:"to_char(lib_per_check.operid)",code:"operid",name:"?????"},{field:"lib_per_check.issuenum",code:"issuenum",name:"???"},{field:"lib_per_check.frequency",code:"frequency",name:"??????"},{field:"(select count( lib_per_detail_check.id) from lib_per_detail_check where lib_per_check.id = lib_per_detail_check.checkid and lib_per_detail_check.status in ('1','2','4'))",code:"sjdqs",name:"????????"},{field:"(select sum( lib_per_detail_check.copies)from lib_per_detail_check where lib_per_check.id = lib_per_detail_check.checkid and lib_per_detail_check.status in ('1','2','4'))",code:"sjdcs",name:"????????"},{field:"(select listagg( 'no.'||lib_per_detail_check.issue||':'||lib_per_detail_check.copies ,';') within group (order by sortfld) from lib_per_detail_check where lib_per_check.id = lib_per_detail_check.checkid and lib_per_detail_check.status in ('1','2','4')and lib_per_detail_check.issue is not null group by lib_per_detail_check.checkid)",code:"sjdq",name:"??????"},{field:"lib_per_check.note",code:"note",name:"???"},{field:"LIB_PER_ALLOCATION.loccode",code:"loccode",name:"??????"}];var bibFldComBoxData=bibExpFld;bibFldComBoxData.push({field:"lib_bibliography.orderno",name:"??????",code:"biborderno"});bibFldComBoxData.push({field:"lib_bibliography.unifiedno",name:"??????",code:"unifiedno"});$(function(){fieldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="??????"});bibFldComBoxData.forEach(function(a,b,c){if(a.code=="isbn"){a.name="ISSN??"}a.group="??????";fieldComBoxData.push(a)});initSrceenDataByJson();_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