| | |
| | | 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() { |