| | |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all"> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | |
| | | <div class="layui-tab layui-tab-card" lay-filter="table"> |
| | | <ul class="layui-tab-title"> |
| | | <li class="layui-this">è®¡ä»¶æ°æ®</li> |
| | | <li>é¶æ¢¯è®¡ä»¶æ°æ®</li> |
| | | </ul> |
| | | <div class="layui-tab-content" style=""> |
| | | <div class="layui-tab-item layui-show"> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | </div> |
| | | </script> |
| | | </div> |
| | | <div class="layui-tab-item "> |
| | | <table class="" id="mainTable2" lay-filter="mainTable2"></table> |
| | | <script type="text/html" id="toolbarDemo2"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload2"><i class="layui-icon layui-icon-refresh"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export2" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn2"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | </div> |
| | | </script> |
| | | </div> |
| | | |
| | | </div> |
| | | </script> |
| | | </div> |
| | | |
| | | |
| | | </form> |
| | | </div> |
| | | </div> |
| | |
| | | var ins; |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var option2 = []; |
| | | var HModName = "Pay_PaymentEntryReport"; |
| | | var HModName2 = "Pay_PaymentEntryReport2"; |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | |
| | |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | get_FastQuery(2); |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | get_FastQuery(2); |
| | | }); |
| | | |
| | | //#region éæ©çç»æé® |
| | |
| | | |
| | | //#region 头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | var checkStatus = table.checkStatus(obj.config.id);//è·åéä¸è¡ æ°æ® |
| | | switch (obj.event) { |
| | | //å设置 |
| | | case 'set_HideColumn': |
| | | get_HideColumn(); |
| | | get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery); |
| | | break; |
| | | case 'btn-reload': |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | break; |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | | default: |
| | | break; |
| | | } |
| | | }); |
| | | |
| | | table.on('toolbar(mainTable2)', function (obj) { |
| | | switch (obj.event) { |
| | | //å设置 |
| | | case 'set_HideColumn2': |
| | | get_HideColumnNoPage(HModName2, sessionStorage["HUserName"], option2, get_FastQuery); |
| | | break; |
| | | case 'btn-reload2': |
| | | get_FastQuery(2); |
| | | break; |
| | | //导åºexcel |
| | | case 'get_export2': |
| | | get_Export2(); |
| | | break; |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | |
| | | get_Dept(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | $("#HBDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HBDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd")); |
| | | $("#HEDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(1); |
| | | get_FastQuery(2); |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-80' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , totalRow: true |
| | | , limit: 500 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | , cols: [[]] |
| | | }; |
| | | option2 = { |
| | | elem: '#mainTable2' |
| | | , toolbar: '#toolbarDemo2' |
| | | , height: 'full-80' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | |
| | | |
| | | option.cols = [col] |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | |
| | | layer.close(ajaxLoad); |
| | | |
| | | DisPlay_HideColumn(); |
| | | DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, []); |
| | | table.render(option); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | |
| | | } |
| | | }); |
| | | } |
| | | |
| | | function get_Display2(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | | |
| | | var sql = "exec h_p_Pay_PaymentEntryReportStepped " + sWhere; |
| | | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sql }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var data = [];//ååæ®µæ°æ® |
| | | var col = []; |
| | | var totalArray = []; |
| | | var titleData = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) {//循åºéåæ°ç» |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });//仿¯ä¸ªå¯¹è±¡ä¸æåæ°æ® |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); |
| | | for (var i = 0; i < data.length; i++) {//éådataæ°ç»éçæ°æ® |
| | | // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { |
| | | if ($.inArray(data[i].name, titleData) > -1) {//æ£æ¥dataãiã.nameæ¯å¦å¨æ°ç»ä¸ //计ç®å |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true, filter: true}); //éèidå |
| | | } |
| | | else if ($.inArray(data[i].name, totalArray) > -1) { //计ç®å |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120, filter: true }); |
| | | } else if (isValidDate(data[i].name)) { |
| | | col.push({ field: data[i].name, title: Format(data[i].name, 'MM-dd'), width: 70, totalRow: true, filter: true }) |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, filter: true, templet: "<div>{{d." + (data[i].name == "è¡å
³éæ¥æ" ? "è¡å
³é人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, filter: true }); |
| | | } |
| | | } |
| | | } |
| | | option2.cols = [col]; |
| | | option2.data = data1.data; |
| | | //å设置 |
| | | DisPlay_HideColumn(HModName2, sessionStorage["HUserName"], option2, []); |
| | | table.render(option2); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | layer.close(ajaxLoad); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | layer.close(ajaxLoad); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(type) { |
| | | var HBDate = $("#HBDate").val();//å¼å§æ¶é´ |
| | | var HEDate = $("#HEDate").val();//ç»ææ¶é´ |
| | | var HDeptID = $("#HDeptID").val(); |
| | | var HEmpID = $("#HEmpID").val(); |
| | | var HGroupID = $("#HGroupID").val(); |
| | | sWhere = "'" + HBDate + "','" + HEDate + "','" + HDeptID + "','" + HGroupID + "','" + HEmpID + "'"; |
| | | get_Display(sWhere); |
| | | if (type == 1) { |
| | | get_Display(sWhere); |
| | | } else { |
| | | get_Display2(sWhere); |
| | | } |
| | | |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //#endregion |
| | |
| | | } |
| | | } |
| | | }); |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | table.exportFile("mainTable", option.data, "xls"); |
| | | } else { |
| | | layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); |
| | | } |
| | |
| | | } |
| | | }); |
| | | } |
| | | function get_Export2() { |
| | | var ModRightNameCheck = "Pay_PaymentEntryReportExcel"; |
| | | |
| | | //é»è¾å®¡æ ¸æ¹æ³ |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | var data = option2.data |
| | | data.forEach((item) => { |
| | | for (let itemobj in item) { |
| | | if (item[itemobj] == null) { |
| | | item[itemobj] = ""; |
| | | } |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | item[itemobj] = item[itemobj].toString().replace(/,/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | table.exportFile("mainTable2", option2.data, "xls"); |
| | | } else { |
| | | layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region éæ©çç» |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var newCols = [[]];//å¯¹åºæ°æ®åºå顺åºcol |
| | | newCols[0].push(option.cols[0][0]);//æ¾å
¥ç¬¬ä¸ä¸ªcheckbox |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | //åè®¾ç½®åæ°ä¸é¡µé¢åæ°æ¯å¦ä¸è´ |
| | | if (dataCol.length == option.cols[0].length - 1) { |
| | | //éå寻æ¾å设置对åºåæé¡ºåºæå
¥ |
| | | for (var j = 0; j < option.cols[0].length - 1; j++) { |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | | var dataCols = dataCol[j].split('|'); |
| | | //éæ©ä¸datacolsç¸åºåè¿è¡ä¿®æ¹ |
| | | if (option.cols[0][i + 1]["field"] == dataCols[5]) { |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | //设置å宽 |
| | | if (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //ç»è®¡å |
| | | if (dataCols[6] == 1) { |
| | | option.cols[0][i + 1]["totalRow"] = true; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | //è®¾ç½®è¡¨æ ¼title屿§æ¾ç¤ºå«å |
| | | if (dataCols[4] != null && dataCols[4] != "") { |
| | | option.cols[0][i + 1]["title"] = dataCols[4]; |
| | | } |
| | | newCols[0].push(option.cols[0][i + 1]); |
| | | } |
| | | } |
| | | } |
| | | //éå循ç¯å夿坹åºåæ°æ¯å¦ä¸è´ |
| | | if (dataCol.length == newCols[0].length - 1) { |
| | | option.cols = newCols; |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i]["fixed"] != null) { |
| | | option.cols[0][i]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | ins = table.render(option); |
| | | } else { |
| | | ins = table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //#region ç¹å»è¡éä¸é«äº® |
| | | //table.on('row(mainTable)', function (obj) { |