var jsonFormatDesign={code:"E_ACQCHALULIST",table:" lib_bibliography left join lib_acq_order  on lib_bibliography.id = lib_acq_order.bibid ",groupby:" group by  bibid ",width:"800",height:"600",top:80,left:180,tableArr:[{name:"lib_acq_order"}]};var jsonFormatDesign={code:"E_ACQCHALULIST",table:" lib_acq_order LEFT JOIN lib_acq_check on (lib_acq_check.bibid = lib_acq_order.bibid   AND lib_acq_check.batchno IN ({tablelimit}))  left join  lib_bibliography ON lib_acq_order.bibid = lib_bibliography.id  ",groupby:" group by  lib_acq_order.bibid",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_order.libcode",code:"libcode",name:globalLibName+"代码"},{field:"lib_acq_order.orderno",code:"acqorderno",name:"订购号"},{field:"lib_acq_order.batchno",code:"batchno",name:"批号"},{field:"lib_acq_order.ncy",code:"ncy",name:"原币制"},{field:"lib_acq_order.price",code:"acqprice",name:"原币册价"},{field:"lib_acq_order.totalprice",code:"acqtotalprice",name:"原币套价"},{field:"lib_acq_order.orderncy",code:"orderncy",name:"订购币制"},{field:"lib_acq_order.orderprice",code:"orderprice",name:"订购册价"},{field:"lib_acq_order.bookseller",code:"bookseller",name:"订购文献提供方"},{field:"lib_acq_order.orderdate",code:"orderdate",name:"订购日期"},{field:"lib_acq_order.volumes",code:"volumes",name:"卷数"},{field:"lib_acq_order.volinfo",code:"volinfo",name:"卷册说明"},];var fieldComBoxData=[{field:"lib_acq_order.libcode",code:"libcode",name:globalLibName+"代码"},{field:"lib_acq_order.orderno",code:"orderno",name:"订购号"},{field:"lib_acq_order.batchno",code:"batchno",name:"批号"},{field:"lib_acq_order.copies",code:"copies",name:"复本数"},{field:"lib_acq_order.ncy",code:"ncy",name:"原币制"},{field:"lib_acq_order.price",code:"acqprice",name:"原册价"},{field:"lib_acq_order.totalprice",code:"acqtotalprice",name:"原币套价"},{field:"lib_acq_order.orderncy",code:"orderncy",name:"订购币制"},{field:"lib_acq_order.orderprice",code:"orderprice",name:"订购册价"},{field:"(lib_acq_order.copies*lib_acq_order.orderprice)",code:"ordertotalprice",name:"订购总价"},{field:"lib_acq_order.binding",code:"binding",name:"装帧标识"},{field:"lib_acq_order.docsources",code:"docsources",name:"来源方式"},{field:"lib_acq_order.finsources",code:"finsources",name:"财经来源"},{field:"lib_acq_order.mediatype",code:"mediatype",name:"载体类型"},{field:"lib_acq_order.bookseller",code:"bookseller",name:"订购文献提供方"},{field:"lib_acq_order.orderdate",code:"orderdate",name:"订购日期"},{field:"to_char(lib_acq_order.operid)",code:"operid",name:"操作员"},{field:"lib_acq_order.volumes",code:"volumes",name:"卷数"},{field:"lib_acq_order.volinfo",code:"volinfo",name:"卷册说明"},{field:"lib_acq_order.note",code:"note",name:"备注"},{field:"lib_acq_order.billno",code:"billno",name:"发票号"},{field:"lib_acq_order.paydate",code:"paydate",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_order.copies is null then 0 else lib_acq_order.copies end) - sum(case when lib_acq_check.copies is null then 0 else lib_acq_check.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});_myPage.prototype.initDataOne({code:"bookseller",key:"bookseller"});initSelectBatchNoByParam("neworderbatchno",0);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){if(!c){c={}}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}function colseIframeDlg(c,a,b){initSelectBatchNoByParam("neworderbatchno",a,null,b);$("#"+c).window("close")};