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-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java | 33 +++++++++++++++++++++++++++++++--
1 files changed, 31 insertions(+), 2 deletions(-)
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java
index b570ded..b056875 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java
@@ -17,6 +17,7 @@
import cn.iocoder.yudao.module.mdm.dal.dataobject.category.MdmItemCategoryDO;
import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemBatchConfigDO;
import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemDO;
+import cn.iocoder.yudao.module.mdm.controller.admin.unit.vo.MdmUnitMeasurePageReqVO;
import cn.iocoder.yudao.module.mdm.dal.dataobject.unit.MdmUnitMeasureDO;
import cn.iocoder.yudao.module.mdm.enums.MdmItemTypeEnum;
import cn.iocoder.yudao.module.mdm.service.brand.MdmBrandService;
@@ -318,10 +319,38 @@
@Operation(summary = "鑾峰緱瀵煎叆鐗╂枡妯℃澘")
@PreAuthorize("@ss.hasPermission('mdm:item:import')")
public void importTemplate(HttpServletResponse response) throws IOException {
+ // 鍒嗙被缂栫爜銆佽閲忓崟浣嶇紪鐮佷负蹇呭～椤癸紝绀轰緥鍙栧綋鍓嶇郴缁熺湡瀹炵紪鐮侊紝閬垮厤鐓фā鏉垮鍏ョ洿鎺ュけ璐�
+ String sampleCategoryCode = "";
+ try {
+ List<MdmItemCategoryDO> cats = itemCategoryService.getSimpleItemList();
+ if (cats != null && !cats.isEmpty()) {
+ sampleCategoryCode = cats.get(0).getCode();
+ }
+ } catch (Exception ignored) {
+ // 鍙栦笉鍒扮暀绌猴紝涓嶅奖鍝嶆ā鏉夸笅杞�
+ }
+ String sampleUnitCode = "";
+ try {
+ MdmUnitMeasurePageReqVO unitReq = new MdmUnitMeasurePageReqVO();
+ unitReq.setPageNo(1);
+ unitReq.setPageSize(1);
+ List<MdmUnitMeasureDO> units = unitMeasureService.getUnitMeasurePage(unitReq).getList();
+ if (units != null && !units.isEmpty()) {
+ sampleUnitCode = units.get(0).getCode();
+ }
+ } catch (Exception ignored) {
+ // 鍚屼笂
+ }
+
List<MdmItemImportExcelVO> list = Arrays.asList(
- MdmItemImportExcelVO.builder().code("ITEM001").name("绀轰緥鐗╂枡").specification("瑙勬牸").status(0).isBatchManaged(false).build()
+ MdmItemImportExcelVO.builder()
+ .code("ITEM-EXAMPLE").name("绀轰緥鐗╂枡锛堣鏇挎崲锛�").specification("瑙勬牸")
+ .categoryCode(sampleCategoryCode).unitMeasureCode(sampleUnitCode)
+ .status(0).isBatchManaged(false)
+ .remark("绀轰緥鏁版嵁锛屽鍏ュ墠璇锋浛鎹紱鍒嗙被缂栫爜/鍗曚綅缂栫爜璇峰～鍐欑郴缁熶腑宸插瓨鍦ㄧ殑缂栫爜")
+ .build()
);
- ExcelUtils.write(response, "鐗╂枡瀵煎叆妯℃澘.xls", "鐗╂枡", MdmItemImportExcelVO.class, list);
+ ExcelUtils.writeTemplate(response, "鐗╂枡瀵煎叆妯℃澘.xls", "鐗╂枡", MdmItemImportExcelVO.class, list);
}
@PostMapping("/import")
--
Gitblit v1.9.3