yusijie
2025-05-07 9043b5ee12d804b5ee11622b4b868b91394723d8
WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportWorkDemandPlanBillList.html
@@ -12,6 +12,7 @@
    <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">
@@ -159,6 +160,12 @@
                            </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>
@@ -190,6 +197,8 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var HModName = "ReportWorkDemandPlanBill";
        var ins = [];
        //#endregion
        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -200,6 +209,20 @@
        //#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) {
@@ -250,7 +273,8 @@
            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});
@@ -290,7 +314,7 @@
                    j = 0;
                }
            }
            columns.push({ field: '', title: '计划明细_合计' });
            columns.push({ field: '计划明细_合计', title: '计划明细_合计' });
            option = {
                elem: '#mainTable'
@@ -332,6 +356,21 @@
            })
        }
        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();
@@ -342,7 +381,9 @@
                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 {