1

duhe

2024-11-04 d60b3a2ecaf8164efeb368eb62dacae78f18feac

 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>
@@ -332,6 +333,10 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出
                    case 'get_export':
                        get_Export();
                        break;
                };
            });
            //重置按钮
@@ -438,6 +443,7 @@
                            option.data = data1.data;

                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -472,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 = "";