From cd00884c3db8fa6808b3b5949ab1a2b1459d6bdc Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期三, 11 六月 2025 10:36:55 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/BaseToolsController.java | 180 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 180 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 022303c..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.*;
@@ -81,6 +86,57 @@
IPage<BaseTools> pageList = baseToolsService.page(page, queryWrapper);
return Result.OK(pageList);
}
+
+
+ /**
+ * 鏍规嵁鍒嗙被閫夋嫨宸ュ叿
+ *
+ * @param baseTools
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ @ApiOperation(value="鏍规嵁鍒嗙被閫夋嫨宸ュ叿", notes="鏍规嵁鍒嗙被閫夋嫨宸ュ叿")
+ @GetMapping(value = "/queryToolByClassifyId")
+ public Result<?> queryToolByClassifyId(BaseTools baseTools,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ HttpServletRequest req) {
+ Map<String, String[]> parameterMap = req.getParameterMap();
+ String[] classifyIds = parameterMap.get("classifyId");
+ if (classifyIds != null && classifyIds.length > 0) {
+ if("1".equals(classifyIds[0])){
+ Page<ParaCommonToolVo> page = new Page<ParaCommonToolVo>(pageNo, pageSize);
+ IPage<ParaCommonToolVo> pageList = baseToolsService.paraCommonToolList(page, parameterMap);
+ return Result.OK(pageList);
+ }else if("2".equals(classifyIds[0])){
+ Page<ParaHolesToolsVo> page = new Page<ParaHolesToolsVo>(pageNo, pageSize);
+ IPage<ParaHolesToolsVo> pageList = baseToolsService.paraHolesToolsList(page, parameterMap);
+ return Result.OK(pageList);
+ }else if("3".equals(classifyIds[0])){
+ Page<ParaThreadingToolVo> page = new Page<ParaThreadingToolVo>(pageNo, pageSize);
+ IPage<ParaThreadingToolVo> pageList = baseToolsService.paraThreadingToolList(page, parameterMap);
+ return Result.OK(pageList);
+ }else if("4".equals(classifyIds[0])){
+ Page<ParaMillToolVo> page = new Page<ParaMillToolVo>(pageNo, pageSize);
+ IPage<ParaMillToolVo> pageList = baseToolsService.paraMillToolList(page, parameterMap);
+ return Result.OK(pageList);
+ }else if("5".equals(classifyIds[0])){
+ Page<ParaTurningToolsVo> page = new Page<ParaTurningToolsVo>(pageNo, pageSize);
+ IPage<ParaTurningToolsVo> pageList = baseToolsService.paraTurningToolsList(page, parameterMap);
+ return Result.OK(pageList);
+ }else if("6".equals(classifyIds[0])){
+ Page<ParaBladeVo> page = new Page<ParaBladeVo>(pageNo, pageSize);
+ IPage<ParaBladeVo> pageList = baseToolsService.paraBladeList(page, parameterMap);
+ return Result.OK(pageList);
+ }else {
+ return Result.error("璇烽�夋嫨宸ュ叿鍒嗙被");
+ }
+ }else {
+ return Result.error("璇烽�夋嫨宸ュ叿鍒嗙被");
+ }
+ }
/**
* 鍒嗛〉鍒楄〃鏌ヨ
@@ -493,5 +549,129 @@
return Result.OK("");
}
}
+ @GetMapping("/listWithLedgerAndConfig")
+ public Result<IPage<StocktakingPoundVo>> listWithLedgerAndConfig(
+ StocktakingPoundVo stocktakingPoundVo,
+ @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
+ @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
+ HttpServletRequest req) {
+ // 浣跨敤 QueryGenerator 鏋勫缓 QueryWrapper
+ QueryWrapper<StocktakingPoundVo> queryWrapper = QueryGenerator.initQueryWrapper(stocktakingPoundVo, req.getParameterMap());
+
+ Page<StocktakingPoundVo> page = new Page<>(pageNo, pageSize);
+ IPage<StocktakingPoundVo> resultPage = baseToolsService.pageWithLedgerAndConfig(page, queryWrapper);
+ return Result.OK(resultPage);
+ }
+
+
+
+ @GetMapping("/listWithSharpedAndConfig")
+ public Result<IPage<SharpeeningVo>> listWithSharpedAndConfig(
+ SharpeeningVo sharpeeningVo,
+ @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
+ @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
+ HttpServletRequest req) {
+
+ // 浣跨敤 QueryGenerator 鏋勫缓 QueryWrapper
+ QueryWrapper<SharpeeningVo> queryWrapper = QueryGenerator.initQueryWrapper(sharpeeningVo, req.getParameterMap());
+
+ Page<SharpeeningVo> page = new Page<>(pageNo, pageSize);
+ 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);
+ }
+ }
+
+ }
}
--
Gitblit v1.9.3