Edit D:\rfid\libsystem\page\export\js\exp_acq_missinglist.js
var jsonFormatDesign={code:"E_ACQMISSINGLIST",table:"lib_holdings left join lib_bibliography on lib_holdings.bibid=lib_bibliography.id left join lib_acq_check on lib_holdings.checkid=lib_acq_check.id",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_acq_check"}]};var fieldComBoxData=[{field:"lib_acq_check.libcode",code:"libcode",name:"??????"},{field:"lib_acq_check.orderno",code:"orderno",name:"?????"},{field:"lib_acq_check.batchno",code:"batchno",name:"???"},{field:"lib_acq_check.copies",code:"copies",name:"?????"},{field:"lib_acq_check.ncy",code:"ncy",name:"???????"},{field:"lib_acq_check.price",code:"price",name:"??????"},{field:"lib_acq_check.totalprice",code:"totalprice",name:"??????"},{field:"lib_acq_check.orderncy",code:"orderncy",name:"???????"},{field:"lib_acq_check.orderprice",code:"orderprice",name:"??????"},{field:"lib_acq_check.ordertotalprice",code:"ordertotalprice",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:"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.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="??????"});bibFldComBoxData.forEach(function(a,b,c){a.group="??????";fieldComBoxData.push(a)});fieldComBoxData.push({field:"num",code:"num",name:"?????",group:"?????",total:"1"});jsonFormatDesign.table="lib_bibliography left join lib_acq_check on lib_bibliography.id=lib_acq_check.bibid left join ( select bibid lbibid,num from ( select bibid,sum(copies)-( select nvl(sum(b.copies),0)from lib_acq_check b where a.bibid = b.bibid group by b.bibid) num from lib_acq_order a where a.ordstatus='0' group by a.bibid )c where num>0 )d on lib_bibliography.id=d.lbibid ";initSrceenDataByJson()});
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de