| | |
| | | <title>ææè®¡åæ¥è¡¨</title> |
| | | <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/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--><!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶--> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">æ¥è¯¢</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">éç½®</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导åº</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">å设置</button> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:10px;"> |
| | | <div class="layui-inline"> |
| | |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | soulTable: '../ext/soulTable', |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable','flow'], function () { |
| | | //#region å
¬ç¨åé |
| | | var $ = layui.$ |
| | |
| | | var sWhere = " where 1=1 "; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var HModName = "ReportPODemandPlanBillList_S"; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region å设置æé® |
| | | form.on('submit(bthHideColumn)', function (data) { |
| | | get_HideColumn(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³ |
| | |
| | | var columns = []; |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true}); |
| | | columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°', sort: true}); |
| | | columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼', sort: true}); |
| | | columns.push({ field: 'FNAME', title: 'ä¾åºå', sort: true }); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true, hide: true }); |
| | | columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, hide: true }); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true, hide: true }); |
| | | columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true }); |
| | | columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°', sort: true, filter: true }); |
| | | columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼', sort: true, filter: true }); |
| | | columns.push({ field: 'FNAME', title: 'ä¾åºå', sort: true, filter: true }); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true, hide: true, filter: true }); |
| | | columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, hide: true, filter: true }); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true, hide: true, filter: true }); |
| | | //columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' }); |
| | | //columns.push({ field: 'HPOOrderBillNote', title: '夿³¨' }); |
| | | //columns.push({ field: 'éè´å', title: 'éè´å' }); |
| | | columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true}); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true}); |
| | | columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true}); |
| | | columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true, filter: true }); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true, filter: true }); |
| | | columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true }); |
| | | //è·å两个ææä¹é´çç¸å·® |
| | | var time1 = Date.parse(new Date($("#HBEGINDATE").val()));//å¼å§æ¶é´ |
| | | var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´ |
| | |
| | | |
| | | var k = 0;//æ¶éå¾ªç¯æ¬¡æ° |
| | | for (var j = 0; j <= (Days - k); j++) { |
| | | columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true}) |
| | | columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: true }) |
| | | //跨年çè¯ ä¼ä»ä¸æä¸å·å¼å§ |
| | | if (MM == 12 && (HBEGINDATE + j) == 31) { |
| | | yyyy += 1; |
| | |
| | | j = 0; |
| | | } |
| | | } |
| | | columns.push({ field: '', title: 'ææè®¡åå计' }); |
| | | columns.push({ field: '', title: 'ææè®¡åå计', filter: true }); |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | |
| | | |
| | | option.data = result.data; |
| | | table.render(option); |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | |
| | | layer.close(ajaxLoad); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#region éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | var contentUrl = ""; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | colName += option.cols[0][i]["field"] + ","; |
| | | } |
| | | var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ |
| | | var urlLen = urlStr.split('/'); |
| | | for (var i = 0; i < urlLen.length - 4; i++) { |
| | | contentUrl += "../"; |
| | | } |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | |
| | | contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName; |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: [contentUrl, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | type: "GET", |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | titleData = []; |
| | | 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"; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | table.render(option); |
| | | } else { |
| | | table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |