yusijie
2025-11-07 6029d9cca9e132c4ba7a64cefe3db5eeaaecdf74
WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ProdBadReasonStatistics.html
@@ -91,6 +91,7 @@
                            <div class="layui-btn-container">
                                <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="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export"><i class="layui-icon layui-icon-form"></i>导出</button>
                            </div>
                        </script>
                    </form>
@@ -181,7 +182,7 @@
                data_t.push(HBadReason_HXH);
                switch ($("#HDeptName").val()) {
                    case '线包车间':
                        HTitle = '步进电机直通率趋势图';
                        HTitle = '线包绕线直通率趋势图';
                        H_X = ["匝间不良", "电阻不良", "护线盒不良"];
                        data_t.push(HBadReason_ZJ);
@@ -332,6 +333,10 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出
                    case 'get_export':
                        get_Export();
                        break;
                };
            });
            //重置按钮
@@ -386,6 +391,7 @@
                    , toolbar: '#toolbarDemo'
                    , height: 'full-490'
                    , page: true
                    , totalRow: true
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
@@ -437,6 +443,7 @@
                            option.data = data1.data;
                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -471,6 +478,26 @@
                get_FastQuery();
            }
            //#region å¯¼å‡ºExecel
            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, '').replaceAll(",",",");  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                        }
                    }
                });
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";