Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exp_per_qkwdlist.js
var jsonFormatDesign={code:"E_PERQKFENPEIWDLIST",table:"lib_cir_reader",groupby:"group by lib_per_detail_check.id",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_per_check"},{name:"lib_per_detail_check"}]};var fieldComBoxData=[{field:"lib_per_check.year",code:"year",name:"?????"},{field:"lib_per_check.frequency",code:"frequency",name:"??????"},{field:"lib_per_check.issuenum",code:"issuenum",name:"???"},{field:"lib_per_check.batchno",code:"batchno",name:"???"},{field:"sum(lib_per_check.copies)",code:"copies",name:"?????"},{field:"lib_per_check.price",code:"price",name:"???"},{field:"lib_per_check.yearprice",code:"yearprice",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_detail_check.expectdate",code:"expectdate",name:"??????"},{field:"listagg(case when lib_per_detail_check.issue is not null then 'no.'||lib_per_detail_check.issue end,';') within group (order by sortfld)",code:"issue",name:"?????"},{field:"listagg(case when lib_per_detail_check.totalissue is not null then 'no.'||lib_per_detail_check.totalissue end,';') within group (order by sortfld)",code:"totalissue",name:"??????"},];$(function(){fieldComBoxData.forEach(function(b,c,d){if(totalFld.indexOf(","+b.code+",")>-1){b.total="1"}b.group="??????"});jsonFormatDesign.table="lib_per_check JOIN lib_per_detail_check ON ( lib_per_detail_check.checkid = lib_per_check.id AND lib_per_detail_check.status IN (0, 2) )JOIN lib_bibliography ON lib_per_detail_check.bibid = lib_bibliography.id";fieldComBoxData.push({field:"lib_bibliography.title",code:"title",name:"???",group:"??????"});fieldComBoxData.push({field:"lib_bibliography.author",code:"author",name:"?????",group:"??????"});fieldComBoxData.push({field:"lib_bibliography.publish",code:"publish",name:"?????",group:"??????"});fieldComBoxData.push({field:"lib_bibliography.unifiedno",code:"unifiedno",name:"??????",group:"??????"});fieldComBoxData.push({field:"lib_bibliography.orderno",code:"orderno",name:"??????",group:"??????"});var a=[{key:"libcode",condition:"code",value:vLibcode},];commonSetParaInit(null,"export_record",null,a);_myPage.prototype.initDataOne({code:"sysid",key:"sysid",condition:"type",value:"1"})});function getSortFieldArr(){return sortFldJsonArr=[{field:"sum(a.copies - nvl(b.copies,0))",code:"cnt",name:"??????"}]};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de