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:"汉仪雅酷黑W",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}};