| | |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | </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="HideColumn"><i class="layui-icon layui-icon-form"></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> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | |
| | | , soulTable = layui.soulTable |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "ReportWorkDemandPlanBill"; |
| | | var ins = []; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumnNoPageForPlan(HModName, option, get_FastQuery); |
| | | break; |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | }; |
| | | }); |
| | | |
| | | //#region 产åç¼ç |
| | | form.on('submit(btnHMATERIALID)', function (data) { |
| | |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'ç产ç»ç»', sort: true}); |
| | | columns.push({ field: 'é¨é¨', title: 'ç产车é´', sort: true}); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true}); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true }); |
| | | columns.push({ field: '客æ·è®¢åå·', title: '客æ·è®¢åå·', sort: true }); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼', sort: true}); |
| | | columns.push({ field: 'HICMOBillNo', title: 'ç产订åå·', sort: true}); |
| | |
| | | j = 0; |
| | | } |
| | | } |
| | | columns.push({ field: '', title: '计åæç»_å计' }); |
| | | columns.push({ field: '计åæç»_å计', title: '计åæç»_å计' }); |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | |
| | | }) |
| | | } |
| | | |
| | | function get_Export() { |
| | | var data = option.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().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | } |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | option.data = result.data; |
| | | table.render(option); |
| | | //å设置 |
| | | DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option); |
| | | ins = table.render(option); |
| | | layer.close(ajaxLoad); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |