Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\page\export\js\exportfd.js
var totalFld=",copies,price,totalprice,orderprice,ordertotalprice,volumes,yearprice,issuenum,notifycount,renewnum,acqprice,acqtotalprice,matchnum,hldtotalprice,sjdqs,jdcopies,hldcopies,ccopies,ordertotalprice,hldtotalprice,countbib,countprice,";var dataFont=[{name:"???",code:"SimSun"},{name:"???",code:"SimHei"},{name:"??????",code:"Microsoft Yahei"},{name:"????????",code:"Microsoft JhengHei"},{name:"???",code:"KaiTi"},{name:"?????",code:"NSimSun"},{name:"???",code:"FangSong"},{name:"???",code:"PingFang SC"},{name:"??????",code:"STHeiti"},{name:"??????",code:"STKaiti"},{name:"??????",code:"STSong"},{name:"??????",code:"STFangsong"},{name:"??????",code:"STZhongsong"},{name:"??????",code:"STHupo"},{name:"??????",code:"STXinwei"},{name:"??????",code:"STLiti"},{name:"??????",code:"STXingkai"},{name:"????????",code:"Hiragino Sans GB"},{name:"?????-??",code:"Lantinghei SC"},{name:"?????-??",code:"Hanzipen SC"},{name:"?????-??",code:"Hannotate SC"},{name:"???-??",code:"Songti SC"},{name:"?????-??",code:"Wawati SC"},{name:"???-??",code:"Weibei SC"},{name:"???-??",code:"Xingkai SC"},{name:"???-??",code:"Yapi SC"},{name:"???-??",code:"Yuanti SC"},{name:"???",code:"YouYuan"},{name:"???",code:"LiSu"},{name:"??????",code:"STXihei"},{name:"??????",code:"STKaiti"},{name:"??????",code:"STSong"},{name:"??????",code:"STFangsong"},{name:"??????",code:"STZhongsong"},{name:"??????",code:"STCaiyun"},{name:"??????",code:"STHupo"},{name:"??????",code:"STXinwei"},{name:"??????",code:"STLiti"},{name:"??????",code:"STXingkai"},{name:"??????",code:"FZShuTi"},{name:"??????",code:"FZYaoti"},{name:"??????",code:"Source Han Sans CN"},{name:"??????",code:"Source Han Serif SC"},{name:"?????????",code:"WenQuanYi Micro Hei"},{name:"??????",code:"HYQihei 40S"},{name:"??????",code:"HYQihei 50S"},{name:"??????",code:"HYQihei 60S"},{name:"????????",code:"HYDaSongJ"},{name:"??????",code:"HYKaiti"},{name:"????????",code:"HYJiaShuJ"},{name:"???PP???",code:"HYPPTiJ"},{name:"?????????",code:"HYLeMiaoTi"},{name:"????????",code:"HYXiaoMaiTiJ"},{name:"????????",code:"HYChengXingJ"},{name:"????????",code:"HYHeiLiZhiTiJ"},{name:"????????",code:"HYYaKuHeiW"},{name:"????????",code:"HYDaHeiJ"},{name:"?????????W",code:"HYShangWeiShouShuW"},{name:"???????????",code:"FZYaSongS-B-GB"},{name:"??????????",code:"FZBaoSong-Z04S"},{name:"??????????",code:"FZCuYuan-M03S"},{name:"???????????",code:"FZDaBiaoSong-B06S"},{name:"??????????",code:"FZDaHei-B02S"},{name:"??????????",code:"FZFangSong-Z02S"},{name:"??????????",code:"FZHei-B01S"},{name:"??????????",code:"FZHuPo-M04S"},{name:"??????????",code:"FZKai-Z03S"},{name:"??????????",code:"FZLiBian-S02S"},{name:"??????????",code:"FZLiShu-S01S"},{name:"??????????",code:"FZMeiHei-M07S"},{name:"??????????",code:"FZShuSong-Z01S"},{name:"??????????",code:"FZShuTi-S05S"},{name:"??????????",code:"FZShuiZhu-M08S"},{name:"??????????",code:"FZSongHei-B07S"},{name:"??????????",code:"FZSong"},{name:"??????????",code:"FZWeiBei-S03S"},{name:"???????????",code:"FZXiDengXian-Z06S"},{name:"????????????",code:"FZXiHei I-Z08S"},{name:"??????????",code:"FZXiYuan-M01S"},{name:"???????????",code:"FZXiaoBiaoSong-B05S"},{name:"??????????",code:"FZXingKai-S04S"},{name:"??????????",code:"FZYaoTi-M06S"},{name:"???????????",code:"FZZhongDengXian-Z07S"},{name:"??????????",code:"FZZhunYuan-M02S"},{name:"??????????",code:"FZZongYi-M05S"},{name:"??????????",code:"FZCaiYun-M09S"},{name:"??????????",code:"FZLiShu II-S06S"},{name:"??????????",code:"FZKangTi-S07S"},{name:"???????????",code:"FZChaoCuHei-M10S"},{name:"???????????",code:"FZNew BaoSong-Z12S"},{name:"???????????",code:"FZNew ShuTi-S08S"},{name:"??????????",code:"FZHuangCao-S09S"},{name:"??????????",code:"FZShaoEr-M11S"},{name:"??????????",code:"FZZhiYi-M12S"},{name:"???????????",code:"FZXiShanHu-M13S"},{name:"??????????",code:"FZCuSong-B09S"},{name:"??????????",code:"FZPingHe-S11S"},{name:"??????????",code:"FZHuaLi-M14S"},{name:"???????????",code:"FZShouJinShu-S10S"},{name:"??????????",code:"FZXiQian-M15S"},{name:"??????????",code:"FZZhongQian-M16S"},{name:"??????????",code:"FZCuQian-M17S"},{name:"??????????",code:"FZPangWa-M18S"},{name:"??????????",code:"FZSongYi-Z13S"},{name:"??????????",code:"FZJianZhi-M23S"},{name:"???????????",code:"FZLiuXingTi-M26S"},{name:"??????????",code:"FZXiangLi-S17S"},{name:"???????????",code:"FZCuHuoYi-M25S"},{name:"???????????",code:"FZPangTouYu-M24S"},{name:"??????????",code:"FZKaTong-M19S"},{name:"??????????",code:"FZYiHei-M20S"},{name:"??????????",code:"FZShuiHei-M21S"},{name:"??????????",code:"FZGuLi-S12S"},{name:"??????????",code:"FZYouXian-Z09S"},{name:"??????????",code:"FZQiTi-S14S"},{name:"????????",code:"FZXiaoZhuanTi-S13T"},{name:"?????????????",code:"FZYingBiKaiShu-S15S"},{name:"???????????",code:"FZZhanBiHei-M22S"},{name:"?????????????",code:"FZYingBiXingShu-S16S"}];var sortTypeComBoxData=[{code:"asc",name:"???"},{code:"desc",name:"???"}];var isShowComBoxData=[{code:"1",name:"??"},{code:"0",name:"??"}];var tableUnitBoxData=[{code:"px",name:"???"},{code:"%",name:"?????"}];var alignTypeComBoxData=[{code:"left",name:"??????"},{code:"center",name:"???"},{code:"right",name:"??????"}];var fontSizeComBoxData=[{code:"12",name:"?????"},{code:"14",name:"??????"},{code:"16",name:"?????"}];$.extend($.fn.propertygrid.defaults.columns[0][1],{formatter:function(c,b,d){if(b.name=="???"){for(var a=0;a<dataFont.length;a++){if(dataFont[a].code==c){return dataFont[a].name}}}else{if(b.name=="??????"){for(var a=0;a<fontSizeComBoxData.length;a++){if(fontSizeComBoxData[a].code==c){return fontSizeComBoxData[a].name}}}else{if(b.name=="??????"){for(var a=0;a<alignTypeComBoxData.length;a++){if(alignTypeComBoxData[a].code==c){return alignTypeComBoxData[a].name}}}else{if(b.name=="??????"){if(jsonFormatDesign.code=="E_ACQJIASAILIST"||jsonFormatDesign.code=="E_ACQCHALULIST"){for(var a=0;a<fieldComBoxData.length;a++){if("min("+fieldComBoxData[a].field+")"==c){return fieldComBoxData[a].name}}}else{for(var a=0;a<fieldComBoxData.length;a++){if(fieldComBoxData[a].field==c){return fieldComBoxData[a].name}}}}else{if(b.name=="??????"){for(var a=0;a<sortTypeComBoxData.length;a++){if(sortTypeComBoxData[a].code==c){return sortTypeComBoxData[a].name}}}else{if(b.name=="??????"){for(var a=0;a<tableUnitBoxData.length;a++){if(tableUnitBoxData[a].code==c){return tableUnitBoxData[a].name}}}else{if(b.name=="?????????"||b.name=="???????????"||b.name=="?????????"){for(var a=0;a<isShowComBoxData.length;a++){if(isShowComBoxData[a].code==c){return isShowComBoxData[a].name}}}else{return c}}}}}}}}});var jsonPropertyGridData;var jsonGridColumns;$(function(){var a=[{code:"formatdesign_libcode",key:"libcode"},{code:"formatdesign_operid",key:"operid"}];for(var b in exportfdInitComboxArr){a.push(exportfdInitComboxArr[b])}_myPage.prototype.initData(a);if(fieldComBoxData){initExportFmtParam()}});function initExportFmtParam(){var b=false;var c="45%";var a="10%";if(jsonFormatDesign.total){b=true;c="55%";a="0"}var d=fieldComBoxData;if(jsonFormatDesign.code=="E_HOLDINGSCOUNTLIST"||jsonFormatDesign.code=="E_ACQBEFOREcodeECKLIST"||jsonFormatDesign.code=="E_PERNOCHECK"||jsonFormatDesign.code=="E_PERQKWDLIST"||jsonFormatDesign.code=="E_ACQJIASAILIST"||jsonFormatDesign.code=="E_ACQCHALULIST"){d=getSortFieldArr()}jsonPropertyGridData={total:12,rows:[{name:"???",code:"pageFont",value:"Microsoft Yahei",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"260px",data:dataFont}}},{name:"??????",code:"pageFontSize",value:"12",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",data:fontSizeComBoxData}}},{name:"??????",code:"pageAlignType",value:"left",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:alignTypeComBoxData}}},{name:"??????",code:"tablewidth",value:"80",group:"??????",editor:{type:"textbox"}},{name:"??????",code:"tableUnit",value:"%",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:tableUnitBoxData}}},{name:"??????(mm)",code:"pageHeight",value:"",group:"??????",editor:{type:"numberbox"}},{name:"?????????",code:"pageRows",value:"",group:"??????",editor:{type:"numberbox"}},{name:"??????",code:"sortField",value:"",group:"??????",editor:{type:"combobox",options:{valueField:"field",textField:"name",panelHeight:"200",editable:true,data:d}}},{name:"??????",code:"sortType",value:"",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:sortTypeComBoxData}}},{name:"?????????",code:"showname",value:"0",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:isShowComBoxData}}},{name:"???????????",code:"showoperator",value:"0",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:isShowComBoxData}}},{name:"?????????",code:"showtime",value:"0",group:"??????",editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:isShowComBoxData}}}]};jsonGridColumns=getInitJsonGridColumns(c,a,b);initFormatDesignGrid();bindPageFormatDesignDataGridList();setCurImportDataGridHeight(50)}function getInitJsonGridColumns(c,a,b){var d=[{field:"field",title:"??????",width:c,formatter:onShowExportJosnComBoxData,editor:{type:"combobox",options:{valueField:"field",textField:"name",panelHeight:"200",required:true,groupField:"group",groupFormatter:function(e){return'<span style="color:black">'+e+"</span>"},data:fieldComBoxData,onChange:function(h,e){if(h!=undefined&&h!=e&&eidtorGridIndex!=undefined){var j=eidtorGridObject.datagrid("getEditor",{index:eidtorGridIndex,field:"code"});if(j.target){for(var f=0;f<fieldComBoxData.length;f++){if(h==fieldComBoxData[f].field){$(j.target).textbox("setValue",fieldComBoxData[f].code)}}}var g=eidtorGridObject.datagrid("getEditor",{index:eidtorGridIndex,field:"name"});if(g.target){for(var f=0;f<fieldComBoxData.length;f++){if(h==fieldComBoxData[f].field){$(g.target).textbox("setValue",fieldComBoxData[f].name)}}}acceptEidtorGrid(h)}}}}},{field:"code",title:"??????",hidden:true,editor:{type:"textbox"}},{field:"name",title:"???",width:"30%",editor:{type:"textbox"}},{field:"width",title:"???(px)",width:"15%",editor:{type:"textbox"}},{field:"total",title:"???",width:a,hidden:b,formatter:onShowCheckBoxName,editor:{type:"combobox",options:{valueField:"code",textField:"name",panelHeight:"auto",editable:false,data:isShowComBoxData,onChange:function(h,e){if(h!=undefined&&h!=e&&eidtorGridIndex!=undefined){var j=eidtorGridObject.datagrid("getSelected");var g=eidtorGridObject.datagrid("getEditor",{index:eidtorGridIndex,field:"total"});if(g.target){for(var f=0;f<fieldComBoxData.length;f++){if(j.field==fieldComBoxData[f].field){if(!fieldComBoxData[f].total&&h=="1"){$(g.target).combobox("setValue","0");break}}}}}}}}}];return d}function setCurImportDataGridHeight(b){var a=$(window).height();var c=a-b;$(".body-div-search").css("height",c+"px");$(".easyui-panel").panel("resize");$("#labelPropertyGrid").propertygrid("loadData",jsonPropertyGridData);initEventForCondition()}function bindPageFormatDesignDataGridList(a){var b=base_path+"lib/design/list.do";var c={};c["limit[0].condition"]="code";c["limit[0].value"]=jsonFormatDesign.code;c.rows=100;c.page=1;$.post(b,c,function(d){if(d.status=="0"){initFormatDesignComboboxByCode(d,a)}else{openMessageDlg(d.message)}},"json")}function initFormatDesignComboboxByCode(b,a){$("#formatdesign_index").combobox({data:b.rows,valueField:"keycode",textField:"name",panelHeight:"auto",onChange:function(d,c){if(d!=undefined&&d!=c&&d.length>0){setValue("acceptFormatDesignIndex",d)}}});$("#acceptFormatDesignIndex").combobox({data:b.rows,valueField:"keycode",textField:"name",panelHeight:"auto",onChange:function(d,c){if(d!=undefined&&d!=c&&d.length>0){bindAcceptFormatDesignDataByKeyCode(d);setValue("formatdesign_index",d)}}});if(a){setValue("formatdesign_index",a)}else{if(b.rows.length>0){setValue("formatdesign_index",b.rows[0].keycode)}}setDefaultParam()}function setDefaultParam(){var b=mystorage.get("opcondtion");if($("#operid").length>0&&b&&b=="1"){var a=mystorage.get("operid");setValue("operid",a)}}function bindAcceptFormatDesignDataByKeyCode(a){var b=base_path+"lib/design/get.do";var c={};c.pk=a;$.post(b,c,function(d){if(d.status=="0"){var e=d.rows[0];setDataToPageElement(e)}else{openMessageDlg(d.message)}},"json")}function setDataToPageElement(e){var f=JSON.parse(e.paramjson);setJsonData("formatdesign_",e);eidtorGridObject.datagrid("loadData",f.grid);var d=jsonPropertyGridData.rows;for(var c=0;c<d.length;c++){if(f[d[c].code]){d[c].value=f[d[c].code]}else{if(f.propertygrid){var a=f.propertygrid;for(var b=0;b<a.length;b++){if(d[c].code==a[b].code){d[c].value=a[b].value}}}}}jsonPropertyGridData.rows=d;$("#labelPropertyGrid").propertygrid("loadData",jsonPropertyGridData)}function initFormatDesignGrid(){eidtorGridObject=$("#pageFormatDesignGrid");eidtorGridObject.datagrid({iconCls:"e-icon fa fa-cog",fit:true,fitColumns:true,singleSelect:true,border:false,nowrap:false,striped:true,toolbar:toolbar,onClickRow:onClickEditorRow,columns:[jsonGridColumns]})}function onOpenPageFormatDesignDlg(){$("#formatdesign_name").textbox("textbox").focus()}function onFormatDesign(){$("#pageFormatDesignDlg").dialog({title:jsonFormatDesign.title,width:jsonFormatDesign.width,height:jsonFormatDesign.height,top:jsonFormatDesign.top,left:jsonFormatDesign.left});$("#otherFormatDesignPanel").panel("setTitle",jsonFormatDesign.othertitle);var b=$(".basicFormatDesignBox").height();var a=100+b;var c=jsonFormatDesign.height-a;$(".otherFormatDesignBox").css("height",c+"px");$("#otherFormatDesignPanel").panel("resize");$("#pageFormatDesignDlg").dialog("open")}function clearFormatDesignElement(){cleanPropertyGrid();cleanJsonData("formatdesign_record");clearGridData("pageFormatDesignGrid")}function cleanPropertyGrid(){var b=jsonPropertyGridData.rows;for(var a=0;a<b.length;a++){b[a].value=""}jsonPropertyGridData.rows=b;$("#labelPropertyGrid").propertygrid("loadData",jsonPropertyGridData)}function addFormatDesignRecord(){setValue("formatdesign_keycode","");clearFormatDesignElement();onOpenPageFormatDesignDlg()}function copyFormatDesignRecord(){setValue("formatdesign_keycode","");cleanJsonData("formatdesign_record");onOpenPageFormatDesignDlg()}function saveFormatDesignRecord(){acceptEidtorGrid();var b=getJsonData("formatdesign_","record");if(!b){openMessageDlg("??????");return}if(!b.name){return openMessageDlg("????????????")}b.code=jsonFormatDesign.code;var a=eidtorGridObject.datagrid("getRows");if(a.length==0){return openMessageDlg("??????????????")}specialHandling(a);var f={grid:a,table:jsonFormatDesign.table};var d=$("#labelPropertyGrid").propertygrid("getRows");for(var e=0;e<d.length;e++){f[d[e].code]=d[e].value}f.title=b.name;if(jsonFormatDesign.groupby){f.groupby=jsonFormatDesign.groupby}if(jsonFormatDesign.having){f.having=jsonFormatDesign.having}b.paramjson=JSON.stringify(f);var c=base_path+"lib/design/insert.do";if(getValue("formatdesign_keycode").length>0){c=base_path+"lib/design/update.do"}b.paramjson=$.base64.encode(b.paramjson);$.post(c,b,function(g){if(g.status=="0"){bindPageFormatDesignDataGridList(g.rows[0].keycode);openMessageDlg(g.message,5000)}else{openMessageDlg(g.message)}},"json")}function specialHandling(a){if("E_READERFINELIST"==jsonFormatDesign.code){var c=false;var b=false;for(var d=0;d<a.length;d++){if("deposit"==a[d].code){b=true}if("debt"==a[d].code){c=true}}if(c){jsonFormatDesign.table=" ( select * from lib_cir_reader right join (select rdrid,sum(money) as debt from lib_cir_curfine where type in ('1','2','3','4','9','a','b','c') group by rdrid) fine on fine.rdrid=lib_cir_reader.id) lib_cir_reader"}if(b){jsonFormatDesign.table=" ( select * from lib_cir_reader right join (select rdrid,sum(money) as deposit from lib_cir_curfine where type in ('0','8') group by rdrid) fine1 on fine1.rdrid=lib_cir_reader.id) lib_cir_reader"}if(b&&c){jsonFormatDesign.table=" (select * from lib_cir_reader left join (select rdrid,sum(money) as debt from lib_cir_curfine where type in ('1','2','3','4','9','a','b','c') group by rdrid) fine on fine.rdrid=lib_cir_reader.id left join (select rdrid,sum(money) as deposit from lib_cir_curfine where type in ('0','8') group by rdrid) fine1 on fine1.rdrid=lib_cir_reader.id where debt>0 or deposit>0) lib_cir_reader "}}}function deleteFormatDesignRecord(){var a=getValue("formatdesign_keycode");if(a.length==0){return openMessageDlg("??????????????")}openConfirmDlg("???????????????????????",null,deleteFormatDesignRecordResult,null)}function deleteFormatDesignRecordResult(){var a=getValue("formatdesign_keycode");var c={};c.pk=a;var b=base_path+"lib/design/delete.do";$.post(b,c,function(d){if(d.status=="0"){openMessageDlg(d.message,5000);bindPageFormatDesignDataGridList()}else{openMessageDlg(d.message)}},"json")}function onSearchExportData(){var b=getJsonDataByTypeHandler();var c=getValue("acceptFormatDesignIndex");if(c.length==0){return openMessageDlg("?????????????")}b.keycode=c;b.account=mystorage.get("account");var a=getTimeFmtStatus();if(a){if(jsonFormatDesign.code=="E_BIBLOANTOP"||jsonFormatDesign.code=="E_READERLOANTOP"){if($("#count").length>0){if(parseInt(getValue("count"))>0){b.count=getValue("count")}else{b.count="500"}}if($("#jysdy").length>0){if(parseInt(getValue("jysdy"))>0){b["limit[20].condition"]="(select count(*) from lib_cir_log where lib_cir_log.hldid = lib_holdings.id)";if(jsonFormatDesign.code=="E_READERLOANTOP"){b["limit[20].condition"]="(select count(*) from lib_cir_log where lib_cir_reader.id = lib_cir_log.rdrid)"}b["limit[20].value"]=getValue("jysdy");b["limit[20].typeHandler"]="7"}}}if(!b["limit[0].condition"]){$.messager.confirm("??????","???????????????,?????????????",function(d){if(d){openPostWindow("exportlist.jsp",b)}})}else{openPostWindow("exportlist.jsp",b)}}}function acceptEidtorGrid(c){isSaveFmtDesign=false;if(endEidtorGridEditing()){eidtorGridObject.datagrid("acceptChanges")}var d=0;if(c){var a=eidtorGridObject.datagrid("getRows");for(var b=0;b<a.length;b++){if(a[b].field==c){d++}}if(d>1){return openMessageDlg("?????????,?????????????????!")}}}function onCheckEditorRow(a,b){if(b.total){$("#pageFormatDesignGrid").datagrid("checkRow",a);return false}else{$("#pageFormatDesignGrid").datagrid("uncheckRow",a);return false}};
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de