Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exp_acq_acqcountlist.js
var jsonFormatDesign={code:"E_ACQ_COUNTLIST",table:" lib_acq_check ",groupby:"group by lib_acq_check.batchno",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_acq_check"}]};var fieldComBoxData=[{field:"lib_acq_check.libcode",code:"libcode",name:globalLibName+"???"},{field:"lib_acq_check.orderno",code:"orderno",name:"?????"},{field:"lib_acq_check.batchno",code:"batchno",name:"???"},{field:"lib_acq_check.binding",code:"binding",name:"??????"},{field:"lib_acq_check.docsources",code:"docsources",name:"??????"},{field:"lib_acq_check.finsources",code:"finsources",name:"??????"},{field:"lib_acq_check.mediatype",code:"mediatype",name:"??????"},{field:"lib_acq_check.bookseller",code:"bookseller",name:"???????????"},{field:"lib_acq_check.checkdate",code:"checkdate",name:"??????"},{field:"to_char(lib_acq_check.operid)",code:"operid",name:"?????"},{field:"lib_acq_check.volumes",code:"volumes",name:"???"},{field:"lib_acq_check.volinfo",code:"volinfo",name:"??????"},{field:"lib_acq_check.billno",code:"billno",name:"?????"},{field:"lib_acq_check.note",code:"note",name:"???"}];var bibFldComBoxData=bibExpFld;$(function(){fieldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="??????"});fieldComBoxData.push({field:"count(lib_acq_check.id)",code:"copies",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"count(distinct lib_acq_check.bibid)",code:"count",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"sum(NVL(lib_acq_check.price*lib_acq_check.copies, 0.0))",code:"checktotalprice",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"sum(NVL(lib_acq_check.orderprice*lib_acq_check.copies, 0.0))",code:"checktotalprice1",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"(select COUNT (DISTINCT lib_holdings.id) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"hldcopies",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"(select COUNT (DISTINCT lib_holdings.bibid) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"hldcount",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"(select SUM (NVL (lib_holdings.price, 0.0)) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"hldtotalprice",name:"??????",group:"??????",total:"1"});fieldComBoxData.push({field:"(select min(barcode) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"minbarcode",name:"???????",group:"??????"});fieldComBoxData.push({field:"(select max(barcode) from lib_holdings where lib_holdings.checkid in (select a.id from lib_acq_check a where a.batchno = lib_acq_check.batchno))",code:"maxbarcode",name:"???????",group:"??????"});initSrceenDataByJson()});
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de