wtt
2024-12-04 e635716b36b3b4eebb5364e7579c056ad1079429
WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ErrMsgBackBillList.html
@@ -522,14 +522,33 @@
        function get_Export() {
            var data = option.data
            data.forEach((item) => {
                // å¦‚果某个字段的值太长,需要去除换行符
                if (item.详细内容.length > 0) {  // å‡è®¾å­—段名为field
                    item.详细内容 = item.详细内容.replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                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, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                    }
                    // æ ¼å¼åŒ–日期字段
                    if (itemobj === '制单日期' || itemobj === '日期' || itemobj === '签到时间' || itemobj === '处理时间' || itemobj === '验收时间') {  // æ ¹æ®ä½ çš„字段名来判断
                        let date = new Date(item[itemobj]);
                        if (!isNaN(date.getTime())) { // åˆ¤æ–­æ˜¯å¦æ˜¯æœ‰æ•ˆçš„æ—¥æœŸ
                            item[itemobj] = date.toISOString().slice(0, 10) + ' ' + date.toTimeString().slice(0, 5);  // æ ¼å¼åŒ–为 YYYY-MM-DD HH:mm
                        } else {
                            item[itemobj] = "";  // å¦‚果不是有效日期,清空该值
                        }
                    }
                    // å¤„理具体字段的替换
                    if (itemobj === '详细内容' || itemobj === '抄送人' || itemobj === '规格型号') {
                        item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                    }
                }
            });
            table.exportFile(ins.config.id, data, "xls");
        }
            //#endregion
        //#endregion
        //隐藏列设置
        function get_HideColumn() {