Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exp_acq_jslist.js
var jsonFormatDesign={code:"E_ACQJIASAILIST",table:" lib_bibliography left join lib_acq_check on lib_bibliography.id = lib_acq_check.bibid ",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_acq_check"}]};jsonFormatDesign={code:"E_ACQJIASAILIST",table:" lib_acq_check left JOIN lib_bibliography on lib_acq_check.bibid= lib_bibliography.id LEFT JOIN lib_acq_order ON ( lib_acq_order.bibid = lib_acq_check.bibid AND lib_acq_order.batchno in ({tablelimit}))",groupby:" group by lib_bibliography.id",having:" having (sum(lib_acq_check.copies) is null or sum(case when lib_acq_check.copies is null then 0 else lib_acq_check.copies end) > sum(case when lib_acq_order.copies is null then 0 else lib_acq_order.copies end))",width:"800",height:"600",top:80,left:180,tableArr:[]};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.copies",code:"copies",name:"?????"},{field:"lib_acq_check.ncy",code:"ncy",name:"?????"},{field:"lib_acq_check.price",code:"acqprice",name:"??????"},{field:"lib_acq_check.totalprice",code:"acqtotalprice",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:"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;var checkSetFldComBoxData=[{field:"sum(case when lib_acq_order.copies is null then 0 else lib_acq_order.copies end)",code:"ordernum",name:"?????"},{field:"sum(case when lib_acq_check.copies is null then 0 else lib_acq_check.copies end)",code:"checknum",name:"?????"},{field:"sum(case when lib_acq_check.copies is null then 0 else lib_acq_check.copies end) - sum(case when lib_acq_order.copies is null then 0 else lib_acq_order.copies end)",code:"nonum",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)});checkSetFldComBoxData.forEach(function(a,b,c){a.group="??????";a.total="1";fieldComBoxData.push(a)});initSrceenDataByJson();_myPage.prototype.initDataOne({code:"checklibcode,orderlibcode",key:"libcode",condition:"code",value:vLibcode});initBatchNoByParam("orderbacthno",0);initBatchNoByParam("checkbacthno",1);$("#orderlibcode").combobox({onChange:function(b,a){initBatchNoByParam("orderbacthno",0,b)}});$("#checklibcode").combobox({onChange:function(b,a){initBatchNoByParam("checkbacthno",1,b)}});bindEventToCurGrid()});function getSortFieldArr(){var c=[];for(var a=0;a<fieldComBoxData.length;a++){var b=JSON.parse(JSON.stringify(fieldComBoxData[a]));b.field="min("+b.field+")";c.push(b)}return c}function bindEventToCurGrid(){$("#orderbacthno").datagrid({idField:"code",onCheck:function(b,a){addCheckOrderItem(b,a)},onUncheck:function(b,a){removeSingleOrderItem(b,a)},onCheckAll:function(a){addAllOrderItem(a)},onUncheckAll:function(a){removeAllOrderItem(a)}});$("#checkbacthno").datagrid({idField:"code",onCheck:function(b,a){addCheckCheckItem(b,a)},onUncheck:function(b,a){removeSingleCheckItem(b,a)},onCheckAll:function(a){addAllCheckItem(a)},onUncheckAll:function(a){removeAllCheckItem(a)}})}function addAllOrderItem(b){for(var a=0;a<b.length;a++){addCheckOrderItem(a,b[a])}}function addCheckOrderItem(c,b){var a=getValue("orderList");a+=b.code+"\n";setValue("orderList",a)}function removeSingleOrderItem(f,e){var d=getValue("orderList");var a="";if(d.length>0){var b=d.split("\n");for(var c=0;c<b.length;c++){if(b[c]!=e.code&&b[c].length>0){a+=b[c]+"\n"}}setValue("orderList",a)}}function removeAllOrderItem(b){for(var a=0;a<b.length;a++){removeSingleOrderItem(a,b[a])}}function addAllCheckItem(b){for(var a=0;a<b.length;a++){addCheckCheckItem(a,b[a])}}function addCheckCheckItem(c,b){var a=getValue("checkList");a+=b.code+"\n";setValue("checkList",a)}function removeSingleCheckItem(f,e){var c=getValue("checkList");var b="";if(c.length>0){var a=c.split("\n");for(var d=0;d<a.length;d++){if(a[d]!=e.code&&a[d].length>0){b+=a[d]+"\n"}}setValue("checkList",b)}}function removeAllCheckItem(b){for(var a=0;a<b.length;a++){removeSingleCheckItem(a,b[a])}}function getOrderSql(e){var d=getValue(e);var a="";if(d.length>0){a="select bibid from lib_acq_order where batchno in (";var b=d.split("\n");for(var c=0;c<b.length;c++){if(b.length>0&&b[c]){a+=b[c]+","}}a=a.substr(0,a.length-1);a+=")"}return a}function getCheckList(e){var d=getValue(e);var a="";if(d.length>0){var b=d.split("\n");for(var c=0;c<b.length;c++){if(b.length>0&&b[c]){a+=b[c]+","}}a=a.substr(0,a.length-1)}return a}function getJsonAddOtherCondtion(c,d){var b=getValue("orderList");if(b.length==0){return openMessageDlg("????????????????????")}var a=getValue("checkList");if(a.length==0){return openMessageDlg("????????????????????")}c.bookmacth=getCheckList("orderList");c["limit[0].condition"]="lib_acq_check.batchno";c["limit[0].value"]=getCheckList("checkList");c["limit[0].typeHandler"]="3";return c};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de