From 2a4e36d26b4e64fc165c33919b225640489bc8cb Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期二, 03 二月 2026 15:29:38 +0800
Subject: [PATCH] yys 基础数据产品维护增加下载模板接口
---
src/main/java/com/ruoyi/basic/controller/ProductController.java | 14 +++++++
src/main/java/com/ruoyi/basic/dto/ProductModelImportDto.java | 67 +++++++++++++++++++++++++++++++++
src/main/java/com/ruoyi/basic/pojo/ProductModel.java | 2
3 files changed, 82 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/ruoyi/basic/controller/ProductController.java b/src/main/java/com/ruoyi/basic/controller/ProductController.java
index 5009e2e..83b2f73 100644
--- a/src/main/java/com/ruoyi/basic/controller/ProductController.java
+++ b/src/main/java/com/ruoyi/basic/controller/ProductController.java
@@ -5,10 +5,13 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.basic.dto.ProductDto;
import com.ruoyi.basic.dto.ProductModelDto;
+import com.ruoyi.basic.dto.ProductModelImportDto;
import com.ruoyi.basic.dto.ProductTreeDto;
+import com.ruoyi.basic.pojo.Customer;
import com.ruoyi.basic.pojo.ProductModel;
import com.ruoyi.basic.service.IProductModelService;
import com.ruoyi.basic.service.IProductService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.framework.aspectj.lang.annotation.Log;
import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
import com.ruoyi.framework.web.controller.BaseController;
@@ -24,6 +27,7 @@
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletResponse;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -133,6 +137,16 @@
return AjaxResult.success(productModelService.importProduct(file));
}
+ /**
+ * 涓嬭浇妯℃澘
+ * @return
+ */
+ @PostMapping("/downloadTemplate")
+ public void downloadTemplate(HttpServletResponse response) {
+ ExcelUtil<ProductModelImportDto> util = new ExcelUtil<ProductModelImportDto>(ProductModelImportDto.class);
+ util.importTemplateExcel(response, "浜у搧瑙勬牸妯℃澘");
+ }
+
@GetMapping("listProduct")
public R listProduct() {
List<HashMap<String, Object>> list = productModelService.listProduct();
diff --git a/src/main/java/com/ruoyi/basic/dto/ProductModelImportDto.java b/src/main/java/com/ruoyi/basic/dto/ProductModelImportDto.java
new file mode 100644
index 0000000..2781922
--- /dev/null
+++ b/src/main/java/com/ruoyi/basic/dto/ProductModelImportDto.java
@@ -0,0 +1,67 @@
+package com.ruoyi.basic.dto;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDateTime;
+
+/**
+ * @author :yys
+ * @date : 2026/2/3 15:17
+ */
+@Data
+public class ProductModelImportDto {
+ /**
+ * 鍏宠仈浜у搧id
+ */
+ @Excel(name = "鍏宠仈浜у搧id")
+ private Long productId;
+
+ @TableField(exist = false)
+ @Excel(name = "浜у搧鍚嶇О")
+ private String productName;
+
+ /**
+ * 瑙勬牸鍨嬪彿
+ */
+ @Excel(name = "瑙勬牸鍨嬪彿")
+ private String model;
+
+ /**
+ * 鍗曚綅
+ */
+ @Excel(name = "鍗曚綅")
+ private String unit;
+
+
+ /**
+ * 浜у搧楂樺害
+ */
+ @Excel(name = "浜у搧楂樺害")
+ private String height;
+
+ /**
+ * 姣忎欢鏁伴噺/鏀�
+ */
+ @Excel(name = "姣忎欢鏁伴噺/鏀�")
+ private String boxNum;
+
+ /**
+ * 鍗曚环(缇庡厓)/浠�
+ */
+ @Excel(name = "鍗曚环(缇庡厓)/浠�")
+ private String dollarPrice;
+
+ /**
+ * 鍗曚环(鍏�)/浠�
+ */
+ @Excel(name = "鍗曚环(鍏�)/浠�")
+ private String taxInclusiveUnitPrice;
+
+}
diff --git a/src/main/java/com/ruoyi/basic/pojo/ProductModel.java b/src/main/java/com/ruoyi/basic/pojo/ProductModel.java
index deea960..553933b 100644
--- a/src/main/java/com/ruoyi/basic/pojo/ProductModel.java
+++ b/src/main/java/com/ruoyi/basic/pojo/ProductModel.java
@@ -45,7 +45,7 @@
/**
* 鐢熶骇鐐掓満
*/
- @Excel(name = "鐢熶骇鐐掓満")
+// @Excel(name = "鐢熶骇鐐掓満")
private String speculativeTradingName;
/**
--
Gitblit v1.9.3