Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exp_acq_countbookmacthlist.js
var jsonFormatDesign={code:"E_ACQCOUNTBOOKMACTHLIST",table:" lib_bibliography join lib_acq_order on bibid=lib_bibliography.id left join lib_acq_bookmatch on (replace(lib_bibliography.isbn,'-','') = replace(lib_acq_bookmatch.isbn,'-','') and lib_acq_bookmatch.batchno in ({tablelimit}) ) ",groupby:" group by lib_acq_order.batchno,lib_acq_bookmatch.batchno ",width:"800",height:"600",top:80,left:180,tableArr:[]};var fieldComBoxData=[{field:"lib_acq_order.batchno",code:"batchno",name:"??????"},{field:"lib_acq_bookmatch.batchno ",code:"mbatchno",name:"??????"},];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_bookmatch.matchnum is null then 0 else lib_acq_bookmatch.matchnum end)",code:"checknum",name:"?????"},{field:"sum(case when lib_acq_order.copies is null then 0 else lib_acq_order.copies end) - sum(case when lib_acq_bookmatch.matchnum is null then 0 else lib_acq_bookmatch.matchnum end) ",code:"nonum",name:"??????"},{field:"trunc((CASE WHEN SUM (CASE WHEN lib_acq_order.copies IS NULL THEN 0 ELSE lib_acq_order.copies END) = 0 THEN 0 ELSE sum(case when lib_acq_bookmatch.matchnum is null then 0 else lib_acq_bookmatch.matchnum end)/ sum(case when lib_acq_order.copies is null then 0 else lib_acq_order.copies end) end),2)*100 || '%' ",code:"rate",name:"?????"}];var bibFldComBoxData=bibExpFld;$(function(){fieldComBoxData.forEach(function(a,b,c){if(totalFld.indexOf(","+a.code+",")>-1){a.total="1"}a.group="??????"});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);$("#orderlibcode").combobox({onChange:function(b,a){initBatchNoByParam("orderbacthno",0,b)}});bindEventToCurGrid()});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)}})}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_bookmatch 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.clbookmacth=getCheckList("checkList");c["limit[0].condition"]="lib_acq_order.batchno";c["limit[0].value"]=getCheckList("orderList");c["limit[0].typeHandler"]="3";return c};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de