Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exp_acq_beforechecklist.js
var jsonFormatDesign={code:"E_ACQBEFORECHECKLIST",table:"lib_bibliography left join lib_acq_check on lib_bibliography.id=lib_acq_check.bibid ",width:"800",height:"600",top:80,left:180,groupby:" group by lib_bibliography.id ",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:"regexp_replace(listagg(lib_acq_check.batchno,';') within group (order by lib_acq_check.batchno),'([^;]+)(;\\1)*(;|$)','\\1\\3')",code:"batchno",name:"???"},{field:"lib_acq_check.ncy",code:"ncy",name:"?????"},{field:"lib_acq_check.price",code:"acqprice",name:"??????"},{field:"lib_acq_check.orderncy",code:"orderncy",name:"??????"},{field:"lib_acq_check.orderprice",code:"orderprice",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:"???"},{field:"count(distinct lib_acq_check.id)",code:"checknum",name:"??????"},{field:"sum(lib_acq_check.copies)",code:"ccopies",name:"????????"},{field:"sum(case when lib_acq_check.copies > 0 then lib_acq_check.orderprice*lib_acq_check.copies else 0 end)",code:"ordertotalprice",name:"??????"},];var bibFldComBoxData=bibExpFld;var holdFldComBoxData=[{field:"sum((select count(lib_holdings.bibid) from lib_holdings where lib_holdings.checkid = lib_acq_check.id))",code:"hldcopies",name:"????????"},{field:"sum((select sum(lib_holdings.price) from lib_holdings where lib_holdings.checkid = lib_acq_check.id))",code:"hldtotalprice",name:"??????",total:"1"},{field:"min((select listagg(lib_holdings.barcode,';') within group (order by lib_holdings.barcode) from lib_holdings join lib_acq_check on (lib_holdings.checkid=lib_acq_check.id) where checkid in (select checkid from lib_holdings where lib_holdings.bibid = lib_bibliography.id) ))",code:"listbarcode",name:"?????"},{field:"min((select regexp_replace(listagg(lib_holdings.callno,';') within group (order by lib_holdings.callno),'([^;]+)(;\\1)*(;|$)','\\1\\3') from lib_holdings join lib_acq_check on (lib_holdings.checkid=lib_acq_check.id) where checkid in (select checkid from lib_holdings where lib_holdings.bibid = lib_bibliography.id) ))",code:"callno",name:"?????"}];$(function(){fieldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="??????"});bibFldComBoxData.forEach(function(a,b,c){a.group="??????";fieldComBoxData.push(a)});holdFldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="??????";fieldComBoxData.push(a)});initSrceenDataByJson()});function getSortFieldArr(){return sortFldJsonArr=[{field:"count(distinct lib_acq_check.id)",code:"checknum",name:"??????"},{field:"sum(lib_acq_check.copies)",code:"copies",name:"?????"}]}function getJsonAddOtherCondtion(b,c){var a=getValue("location");if(a.length>0){b.ysazlocation=a;b.condtionIndex=c;c++}return b};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de