出站汇报单导出功能替换换行符

yusijie

2024-10-11 39f54ca46fa7e941f278f7e18a8743ac786d3230

出站汇报单导出功能替换换行符

 WebTM/views/³µ¼ä¹ÜÀí/¹¤Ðò³öÕ¾»ã±¨µ¥/Cj_StationOutBillList.html

@@ -2128,13 +2128,24 @@
                        if (result.count == 1) {
                            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().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    }
                                }
                                if (item.产品名称.length > 0) {  // å‡è®¾å­—段名为field
                                    item.产品名称 = item.产品名称.replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }


                                //// å¦‚果某个字段的值太长，需要去除换行符
                                //if (item.规格型号.length > 0) {  // å‡è®¾å­—段名为field
                                //    item.规格型号 = item.规格型号.replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                //}
                                //if (item.产品名称.length > 0) {  // å‡è®¾å­—段名为field
                                //    item.产品名称 = item.产品名称.replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                //}
                            });

                            table.exportFile(ins.config.id, option.data, "xls");

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Mes_OrderProcFlowAllReport.html

@@ -126,6 +126,18 @@
                        break;
                    //导出excel
                    case '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().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                            }
                        });

                        table.exportFile(ins.config.id, option.data, "xls");
                        break;
                };