From d76571d944a4bd1affa9434270991fb46208d813 Mon Sep 17 00:00:00 2001
From: cuijian <cuijian@xalxzn.com>
Date: 星期三, 11 六月 2025 09:26:50 +0800
Subject: [PATCH] 导入模板下载，图片上传
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaCommonToolVo.java | 3 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaHolesToolsVo.java | 3 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/BaseTools.java | 5 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaMillToolVo.java | 3 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaThreadingToolVo.java | 3 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaBladeVo.java | 3 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaTurningToolsVo.java | 3 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/BaseToolsMapper.xml | 6 ++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/BaseToolsController.java | 99 +++++++++++++++++++++++++++++++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java | 1
10 files changed, 129 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/BaseToolsController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/BaseToolsController.java
index 38db085..c259364 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/BaseToolsController.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/BaseToolsController.java
@@ -1,5 +1,8 @@
package org.jeecg.modules.tms.controller;
+import java.io.File;
+import java.io.IOException;
+import java.net.URLEncoder;
import java.util.Arrays;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
@@ -7,6 +10,8 @@
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.modules.tms.entity.*;
@@ -575,4 +580,98 @@
IPage<SharpeeningVo> resultPage = baseToolsService.pageWithSharpedAndConfig(page, queryWrapper);
return Result.OK(resultPage);
}
+
+
+ /**
+ * 瀵煎叆妯℃澘涓嬭浇
+ *
+ */
+ @RequestMapping(value = "/loadTemplate")
+ public void loadTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {
+
+ Map<String,String[]> req = request.getParameterMap();
+ String paraTypeFlag = "";
+ if(req.get("paraTypeFlag") != null){
+ paraTypeFlag = req.get("paraTypeFlag")[0];
+ }
+ if("1".equals(paraTypeFlag)){
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\鍒�鍏蜂俊鎭鍏ユā鏉�-閫氱敤鍙傛暟.xlsx"));
+ //瀵煎嚭Workbook
+ //璁剧疆鍝嶅簲澶�
+ String fileName = "鍒�鍏蜂俊鎭鍏ユā鏉�-閫氱敤鍙傛暟.xlsx";
+ // 瀵规枃浠跺悕杩涜URL缂栫爜锛岄槻姝腑鏂囦贡鐮�
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ // 灏哤orkbook鍐欏叆鍝嶅簲杈撳嚭娴�
+ try { // try-with-resources鑷姩鍏抽棴璧勬簮
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ // 寮傚父澶勭悊锛堝璁板綍鏃ュ織锛�
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+ }else if("2".equals(paraTypeFlag)){
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\鍒�鍏蜂俊鎭鍏ユā鏉�-瀛斿姞宸ュ伐鍏�.xlsx"));
+ String fileName = "鍒�鍏蜂俊鎭鍏ユā鏉�-瀛斿姞宸ュ伐鍏�.xlsx";
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ try {
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+ }else if("3".equals(paraTypeFlag)){
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\鍒�鍏蜂俊鎭鍏ユā鏉�-铻虹汗宸ュ叿.xlsx"));
+ String fileName = "鍒�鍏蜂俊鎭鍏ユā鏉�-铻虹汗宸ュ叿.xlsx";
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ try {
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+ }else if("4".equals(paraTypeFlag)){
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\鍒�鍏蜂俊鎭鍏ユā鏉�-閾ｅ墛宸ュ叿.xlsx"));
+ String fileName = "鍒�鍏蜂俊鎭鍏ユā鏉�-閾ｅ墛宸ュ叿.xlsx";
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ try {
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+ }else if("5".equals(paraTypeFlag)){
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\鍒�鍏蜂俊鎭鍏ユā鏉�-杞﹀墛宸ュ叿.xlsx"));
+ String fileName = "鍒�鍏蜂俊鎭鍏ユā鏉�-杞﹀墛宸ュ叿.xlsx";
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ try {
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+ }else if("6".equals(paraTypeFlag)){
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\鍒�鍏蜂俊鎭鍏ユā鏉�-鍒�鐗�.xlsx"));
+ String fileName = "鍒�鍏蜂俊鎭鍏ユā鏉�-鍒�鐗�.xlsx";
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ try {
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+ }
+
+ }
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/BaseTools.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/BaseTools.java
index aaa61bf..d99691d 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/BaseTools.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/BaseTools.java
@@ -108,4 +108,9 @@
@DateTimeFormat(pattern="yyyy-MM-dd")
@ApiModelProperty(value = "鏇存柊鏃堕棿")
private Date updateTime;
+
+ /**宸ュ叿鍥剧墖*/
+ @Excel(name = "宸ュ叿鍥剧墖", width = 15)
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaBladeVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaBladeVo.java
index 0ce3390..feab8e2 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaBladeVo.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaBladeVo.java
@@ -163,4 +163,7 @@
@ApiModelProperty(value = "澶囨敞")
private String remark;
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
+
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaCommonToolVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaCommonToolVo.java
index 1cfa455..a01e7d7 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaCommonToolVo.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaCommonToolVo.java
@@ -94,4 +94,7 @@
@ApiModelProperty(value = "澶囨敞")
private String remark;
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
+
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaHolesToolsVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaHolesToolsVo.java
index 59dbf3c..45ce3ff 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaHolesToolsVo.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaHolesToolsVo.java
@@ -188,4 +188,7 @@
@ApiModelProperty(value = "澶囨敞")
private String remark;
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
+
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaMillToolVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaMillToolVo.java
index 8315462..e8b4d74 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaMillToolVo.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaMillToolVo.java
@@ -191,4 +191,7 @@
@ApiModelProperty(value = "澶囨敞")
private String remark;
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
+
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaThreadingToolVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaThreadingToolVo.java
index b2a9781..ddae238 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaThreadingToolVo.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaThreadingToolVo.java
@@ -160,4 +160,7 @@
@ApiModelProperty(value = "澶囨敞")
private String remark;
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
+
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaTurningToolsVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaTurningToolsVo.java
index 304fcc5..00f3d00 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaTurningToolsVo.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/ParaTurningToolsVo.java
@@ -198,4 +198,7 @@
@ApiModelProperty(value = "澶囨敞")
private String remark;
+ @ApiModelProperty(value = "宸ュ叿鍥剧墖")
+ private String toolPicture;
+
}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/BaseToolsMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/BaseToolsMapper.xml
index 5b34e8c..c6df81e 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/BaseToolsMapper.xml
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/BaseToolsMapper.xml
@@ -13,6 +13,7 @@
t.standard_code standardCode,
t.tool_model toolModel,
t.parama_table_name paramaTableName,
+ t.tool_picture toolPicture,
t1.application_type applicationType,
t1.supplier_id supplierId,
t1.province_city provinceCity,
@@ -81,6 +82,7 @@
t.standard_code standardCode,
t.tool_model toolModel,
t.parama_table_name paramaTableName,
+ t.tool_picture toolPicture,
t1.application_type applicationType,
t1.supplier_id supplierId,
t1.province_city provinceCity,
@@ -113,6 +115,7 @@
t.standard_code standardCode,
t.tool_model toolModel,
t.parama_table_name paramaTableName,
+ t.tool_picture toolPicture,
t1.application_type applicationType,
t1.supplier_id supplierId,
t1.province_city provinceCity,
@@ -171,6 +174,7 @@
t.standard_code standardCode,
t.tool_model toolModel,
t.parama_table_name paramaTableName,
+ t.tool_picture toolPicture,
t1.application_type applicationType,
t1.supplier_id supplierId,
t1.province_city provinceCity,
@@ -238,6 +242,7 @@
t.standard_code standardCode,
t.tool_model toolModel,
t.parama_table_name paramaTableName,
+ t.tool_picture toolPicture,
t1.application_type applicationType,
t1.supplier_id supplierId,
t1.province_city provinceCity,
@@ -309,6 +314,7 @@
t.standard_code standardCode,
t.tool_model toolModel,
t.parama_table_name paramaTableName,
+ t.tool_picture toolPicture,
t1.application_type applicationType,
t1.supplier_id supplierId,
t1.province_city provinceCity,
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java
index ad52aa3..36f8868 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundOrderServiceImpl.java
@@ -262,6 +262,7 @@
num++;
//杞崲鍥炲瓧绗︿覆骞朵繚鐣欏墠瀵奸浂
String result = String.format("%0" + currentCode.length() + "d", num);
+ //鎵撳嵃浜岀淮鐮�
//淇濆瓨鍏ュ簱娴佹按
InStoreDetail inStoreDetail = new InStoreDetail();
inStoreDetail.setInboundTime(inboundTime);
--
Gitblit v1.9.3