From 68317d44b233f28150336bbf3aa3a32400552437 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期一, 02 十一月 2026 11:02:08 +0800
Subject: [PATCH] fix(excel): 导入模板日期改为文本显示,修复显示为 Excel 序列号
---
yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/contract/CrmContractController.java | 18 +++++++++++++++++-
1 files changed, 17 insertions(+), 1 deletions(-)
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/contract/CrmContractController.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/contract/CrmContractController.java
index b083943..303a062 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/contract/CrmContractController.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/contract/CrmContractController.java
@@ -146,6 +146,22 @@
return contractVO;
}
+ @GetMapping("/download-document")
+ @Operation(summary = "鎸夎喘閿�鍚堝悓妯℃澘涓嬭浇鍚堝悓 Word 鏂囦欢")
+ @PreAuthorize("@ss.hasPermission('crm:contract:query')")
+ public void downloadDocument(@RequestParam("id") Long id, HttpServletResponse response) throws IOException {
+ // getContract 鍖呭惈鍚堝悓鏁版嵁鏉冮檺鏍¢獙锛涙部鐢ㄨ鎯呴〉鐨勪骇鍝併�佸崟浣嶅拰瀹㈡埛淇℃伅銆�
+ CrmContractRespVO contract = buildContractDetail(contractService.getContract(id));
+ Assert.notNull(contract, "鍚堝悓涓嶅瓨鍦�");
+ byte[] content = cn.iocoder.yudao.module.crm.service.contract.CrmContractDocumentRenderer.render(contract);
+ String filename = "璐攢鍚堝悓-" + contract.getNo() + ".docx";
+ response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document");
+ response.setHeader("Cache-Control", "no-store");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + java.net.URLEncoder.encode(filename, java.nio.charset.StandardCharsets.UTF_8).replace("+", "%20"));
+ response.setContentLength(content.length);
+ response.getOutputStream().write(content);
+ }
+
@GetMapping("/page")
@Operation(summary = "鑾峰緱鍚堝悓鍒嗛〉")
@PreAuthorize("@ss.hasPermission('crm:contract:query')")
@@ -205,7 +221,7 @@
.productCode("ITEM001").productName("绀轰緥浜у搧A")
.count(new BigDecimal("100")).contractPrice(new BigDecimal("20.00")).remark("绀轰緥鏁版嵁锛屽鍏ュ墠璇锋浛鎹�")
.build());
- ExcelUtils.write(response, "鍚堝悓瀵煎叆妯℃澘.xls", "鍚堝悓", CrmContractImportExcelVO.class, list);
+ ExcelUtils.writeTemplate(response, "鍚堝悓瀵煎叆妯℃澘.xls", "鍚堝悓", CrmContractImportExcelVO.class, list);
}
@PostMapping("/import")
--
Gitblit v1.9.3