From ca511301d30594decf86b1a53eed3bbfc0b60ead Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期二, 03 六月 2025 17:11:01 +0800
Subject: [PATCH] 工具管理-工具出库流水查询、导出接口调整
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java | 27 ++++++++++++++++++++++++---
1 files changed, 24 insertions(+), 3 deletions(-)
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java
index 11f95c5..68bf76b 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java
@@ -9,8 +9,11 @@
import java.net.URLDecoder;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+
+import org.apache.shiro.SecurityUtils;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
+import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.tms.entity.OutStoreDetail;
import org.jeecg.modules.tms.entity.vo.OutStoreDetailVo;
@@ -155,12 +158,30 @@
* 瀵煎嚭excel
*
* @param request
- * @param outStoreDetail
*/
//@RequiresPermissions("org.jeecg.modules:tms_out_store_detail:exportXls")
@RequestMapping(value = "/exportXls")
- public ModelAndView exportXls(HttpServletRequest request, OutStoreDetail outStoreDetail) {
- return super.exportXls(request, outStoreDetail, OutStoreDetail.class, "宸ュ叿鍑哄簱娴佹按");
+ public ModelAndView exportXls(HttpServletRequest request) {
+ // Step.1 缁勮鏌ヨ鏉′欢
+ Map<String, String[]> parameterMap = request.getParameterMap();
+ Page<OutStoreDetailVo> page = new Page<>(1, 1000000);
+ LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();
+
+ // Step.2 鑾峰彇瀵煎嚭鏁版嵁
+ IPage<OutStoreDetailVo> pageList = outStoreDetailService.queryPageList(page, parameterMap);
+ List<OutStoreDetailVo> exportList = pageList.getRecords();
+
+ // Step.3 AutoPoi 瀵煎嚭Excel
+ ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
+ //姝ゅ璁剧疆鐨刦ilename鏃犳晥 ,鍓嶇浼氶噸鏇存柊璁剧疆涓�涓�
+ mv.addObject(NormalExcelConstants.FILE_NAME, "宸ュ叿鍑哄簱娴佹按");
+ mv.addObject(NormalExcelConstants.CLASS, OutStoreDetailVo.class);
+ //update-begin--Author:liusq Date:20210126 for锛氬浘鐗囧鍑烘姤閿欙紝ImageBasePath鏈缃�--------------------
+ ExportParams exportParams=new ExportParams("宸ュ叿鍑哄簱娴佹按" + "鎶ヨ〃", "瀵煎嚭浜�:" + sysUser.getRealname(), "宸ュ叿鍑哄簱娴佹按");
+ //update-end--Author:liusq Date:20210126 for锛氬浘鐗囧鍑烘姤閿欙紝ImageBasePath鏈缃�----------------------
+ mv.addObject(NormalExcelConstants.PARAMS,exportParams);
+ mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
+ return mv;
}
/**
--
Gitblit v1.9.3