From 35d9446131124e12616c7b6b9dfd79e23d20e1c9 Mon Sep 17 00:00:00 2001
From: cuijian <cuijian@xalxzn.com>
Date: 星期五, 06 六月 2025 17:23:11 +0800
Subject: [PATCH] 工具台账功能
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java | 47 ++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 44 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..1871876 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,10 +9,14 @@
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.ToolLedger;
import org.jeecg.modules.tms.entity.vo.OutStoreDetailVo;
import org.jeecg.modules.tms.service.IOutStoreDetailService;
@@ -155,12 +159,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;
}
/**
@@ -176,4 +198,23 @@
return super.importExcel(request, response, OutStoreDetail.class);
}
+ /**
+ * 宸ュ叿鍙拌处-鍑哄簱瀛愰〉闈㈠垪琛ㄦ煡璇�
+ *
+ * @param outStoreDetail
+ * @param pageNo
+ * @param pageSize
+ * @param query
+ * @return
+ */
+ @ApiOperation(value="宸ュ叿鍙拌处-鍑哄簱瀛愰〉闈㈠垪琛ㄦ煡璇�", notes="宸ュ叿鍙拌处-鍑哄簱瀛愰〉闈㈠垪琛ㄦ煡璇�")
+ @GetMapping(value = "/outStoreDetailList")
+ public Result<?> outStoreDetailList(OutStoreDetail outStoreDetail,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ @RequestParam Map<String, String> query) {
+ IPage<Map<String, Object>> pageList = outStoreDetailService.outStoreDetailList(pageNo,pageSize, query);
+ return Result.OK(pageList);
+ }
+
}
--
Gitblit v1.9.3