From 89ffb9fded4da0fbac9a14d4979aa7623b0a78f0 Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期一, 28 七月 2025 20:47:00 +0800
Subject: [PATCH] 工装管理基础代码
---
src/main/java/org/jeecg/modules/tms/controller/TmsToolStocktakingController.java | 304 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 304 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/jeecg/modules/tms/controller/TmsToolStocktakingController.java b/src/main/java/org/jeecg/modules/tms/controller/TmsToolStocktakingController.java
new file mode 100644
index 0000000..c072004
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/tms/controller/TmsToolStocktakingController.java
@@ -0,0 +1,304 @@
+package org.jeecg.modules.tms.controller;
+
+import org.jeecg.common.system.query.QueryGenerator;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import lombok.extern.slf4j.Slf4j;
+import org.jeecg.common.system.base.controller.JeecgController;
+import org.jeecg.common.api.vo.Result;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import org.springframework.web.servlet.ModelAndView;
+import java.util.Arrays;
+import org.jeecg.common.util.oConvertUtils;
+import org.jeecg.modules.tms.entity.TmsToolStocktakingDetail;
+import org.jeecg.modules.tms.entity.TmsToolStocktaking;
+import org.jeecg.modules.tms.service.ITmsToolStocktakingService;
+import org.jeecg.modules.tms.service.ITmsToolStocktakingDetailService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.jeecg.common.aspect.annotation.AutoLog;
+import org.apache.shiro.SecurityUtils;
+import org.jeecg.common.system.vo.LoginUser;
+import org.jeecgframework.poi.excel.ExcelImportUtil;
+import org.jeecgframework.poi.excel.def.NormalExcelConstants;
+import org.jeecgframework.poi.excel.entity.ExportParams;
+import org.jeecgframework.poi.excel.entity.ImportParams;
+import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
+import org.springframework.web.multipart.MultipartFile;
+import org.springframework.web.multipart.MultipartHttpServletRequest;
+import java.io.IOException;
+import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
+
+ /**
+ * @Description: 宸ヨ鐩樼偣
+ * @Author: jeecg-boot
+ * @Date: 2025-07-28
+ * @Version: V1.0
+ */
+@Api(tags="宸ヨ鐩樼偣")
+@RestController
+@RequestMapping("/tms/tmsToolStocktaking")
+@Slf4j
+public class TmsToolStocktakingController extends JeecgController<TmsToolStocktaking, ITmsToolStocktakingService> {
+
+ @Autowired
+ private ITmsToolStocktakingService tmsToolStocktakingService;
+
+ @Autowired
+ private ITmsToolStocktakingDetailService tmsToolStocktakingDetailService;
+
+
+ /*---------------------------------涓昏〃澶勭悊-begin-------------------------------------*/
+
+ /**
+ * 鍒嗛〉鍒楄〃鏌ヨ
+ * @param tmsToolStocktaking
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ //@AutoLog(value = "宸ヨ鐩樼偣-鍒嗛〉鍒楄〃鏌ヨ")
+ @ApiOperation(value="宸ヨ鐩樼偣-鍒嗛〉鍒楄〃鏌ヨ", notes="宸ヨ鐩樼偣-鍒嗛〉鍒楄〃鏌ヨ")
+ @GetMapping(value = "/list")
+ public Result<IPage<TmsToolStocktaking>> queryPageList(TmsToolStocktaking tmsToolStocktaking,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ HttpServletRequest req) {
+ QueryWrapper<TmsToolStocktaking> queryWrapper = QueryGenerator.initQueryWrapper(tmsToolStocktaking, req.getParameterMap());
+ Page<TmsToolStocktaking> page = new Page<TmsToolStocktaking>(pageNo, pageSize);
+ IPage<TmsToolStocktaking> pageList = tmsToolStocktakingService.page(page, queryWrapper);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ * @param tmsToolStocktaking
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣-娣诲姞")
+ @ApiOperation(value="宸ヨ鐩樼偣-娣诲姞", notes="宸ヨ鐩樼偣-娣诲姞")
+ //@RequiresPermissions("org.jeecg.modules:tms_tool_stocktaking:add")
+ @PostMapping(value = "/add")
+ public Result<String> add(@RequestBody TmsToolStocktaking tmsToolStocktaking) {
+ tmsToolStocktakingService.save(tmsToolStocktaking);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ * @param tmsToolStocktaking
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣-缂栬緫")
+ @ApiOperation(value="宸ヨ鐩樼偣-缂栬緫", notes="宸ヨ鐩樼偣-缂栬緫")
+ //@RequiresPermissions("org.jeecg.modules:tms_tool_stocktaking:edit")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> edit(@RequestBody TmsToolStocktaking tmsToolStocktaking) {
+ tmsToolStocktakingService.updateById(tmsToolStocktaking);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="宸ヨ鐩樼偣-閫氳繃id鍒犻櫎", notes="宸ヨ鐩樼偣-閫氳繃id鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules:tms_tool_stocktaking:delete")
+ @DeleteMapping(value = "/delete")
+ public Result<String> delete(@RequestParam(name="id",required=true) String id) {
+ tmsToolStocktakingService.delMain(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣-鎵归噺鍒犻櫎")
+ @ApiOperation(value="宸ヨ鐩樼偣-鎵归噺鍒犻櫎", notes="宸ヨ鐩樼偣-鎵归噺鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules:tms_tool_stocktaking:deleteBatch")
+ @DeleteMapping(value = "/deleteBatch")
+ public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
+ this.tmsToolStocktakingService.delBatchMain(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 瀵煎嚭
+ * @return
+ */
+ //@RequiresPermissions("org.jeecg.modules:tms_tool_stocktaking:exportXls")
+ @RequestMapping(value = "/exportXls")
+ public ModelAndView exportXls(HttpServletRequest request, TmsToolStocktaking tmsToolStocktaking) {
+ return super.exportXls(request, tmsToolStocktaking, TmsToolStocktaking.class, "宸ヨ鐩樼偣");
+ }
+
+ /**
+ * 瀵煎叆
+ * @return
+ */
+ //@RequiresPermissions("org.jeecg.modules:tms_tool_stocktaking:importExcel")
+ @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
+ public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
+ return super.importExcel(request, response, TmsToolStocktaking.class);
+ }
+ /*---------------------------------涓昏〃澶勭悊-end-------------------------------------*/
+
+
+ /*--------------------------------瀛愯〃澶勭悊-宸ヨ鐩樼偣鏄庣粏-begin----------------------------------------------*/
+ /**
+ * 閫氳繃涓昏〃ID鏌ヨ
+ * @return
+ */
+ //@AutoLog(value = "宸ヨ鐩樼偣鏄庣粏-閫氳繃涓昏〃ID鏌ヨ")
+ @ApiOperation(value="宸ヨ鐩樼偣鏄庣粏-閫氳繃涓昏〃ID鏌ヨ", notes="宸ヨ鐩樼偣鏄庣粏-閫氳繃涓昏〃ID鏌ヨ")
+ @GetMapping(value = "/listTmsToolStocktakingDetailByMainId")
+ public Result<IPage<TmsToolStocktakingDetail>> listTmsToolStocktakingDetailByMainId(TmsToolStocktakingDetail tmsToolStocktakingDetail,
+ @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
+ @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
+ HttpServletRequest req) {
+ QueryWrapper<TmsToolStocktakingDetail> queryWrapper = QueryGenerator.initQueryWrapper(tmsToolStocktakingDetail, req.getParameterMap());
+ Page<TmsToolStocktakingDetail> page = new Page<TmsToolStocktakingDetail>(pageNo, pageSize);
+ IPage<TmsToolStocktakingDetail> pageList = tmsToolStocktakingDetailService.page(page, queryWrapper);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ * @param tmsToolStocktakingDetail
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣鏄庣粏-娣诲姞")
+ @ApiOperation(value="宸ヨ鐩樼偣鏄庣粏-娣诲姞", notes="宸ヨ鐩樼偣鏄庣粏-娣诲姞")
+ @PostMapping(value = "/addTmsToolStocktakingDetail")
+ public Result<String> addTmsToolStocktakingDetail(@RequestBody TmsToolStocktakingDetail tmsToolStocktakingDetail) {
+ tmsToolStocktakingDetailService.save(tmsToolStocktakingDetail);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ * @param tmsToolStocktakingDetail
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣鏄庣粏-缂栬緫")
+ @ApiOperation(value="宸ヨ鐩樼偣鏄庣粏-缂栬緫", notes="宸ヨ鐩樼偣鏄庣粏-缂栬緫")
+ @RequestMapping(value = "/editTmsToolStocktakingDetail", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> editTmsToolStocktakingDetail(@RequestBody TmsToolStocktakingDetail tmsToolStocktakingDetail) {
+ tmsToolStocktakingDetailService.updateById(tmsToolStocktakingDetail);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣鏄庣粏-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="宸ヨ鐩樼偣鏄庣粏-閫氳繃id鍒犻櫎", notes="宸ヨ鐩樼偣鏄庣粏-閫氳繃id鍒犻櫎")
+ @DeleteMapping(value = "/deleteTmsToolStocktakingDetail")
+ public Result<String> deleteTmsToolStocktakingDetail(@RequestParam(name="id",required=true) String id) {
+ tmsToolStocktakingDetailService.removeById(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "宸ヨ鐩樼偣鏄庣粏-鎵归噺鍒犻櫎")
+ @ApiOperation(value="宸ヨ鐩樼偣鏄庣粏-鎵归噺鍒犻櫎", notes="宸ヨ鐩樼偣鏄庣粏-鎵归噺鍒犻櫎")
+ @DeleteMapping(value = "/deleteBatchTmsToolStocktakingDetail")
+ public Result<String> deleteBatchTmsToolStocktakingDetail(@RequestParam(name="ids",required=true) String ids) {
+ this.tmsToolStocktakingDetailService.removeByIds(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 瀵煎嚭
+ * @return
+ */
+ @RequestMapping(value = "/exportTmsToolStocktakingDetail")
+ public ModelAndView exportTmsToolStocktakingDetail(HttpServletRequest request, TmsToolStocktakingDetail tmsToolStocktakingDetail) {
+ // Step.1 缁勮鏌ヨ鏉′欢
+ QueryWrapper<TmsToolStocktakingDetail> queryWrapper = QueryGenerator.initQueryWrapper(tmsToolStocktakingDetail, request.getParameterMap());
+ LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();
+
+ // Step.2 鑾峰彇瀵煎嚭鏁版嵁
+ List<TmsToolStocktakingDetail> pageList = tmsToolStocktakingDetailService.list(queryWrapper);
+ List<TmsToolStocktakingDetail> exportList = null;
+
+ // 杩囨护閫変腑鏁版嵁
+ String selections = request.getParameter("selections");
+ if (oConvertUtils.isNotEmpty(selections)) {
+ List<String> selectionList = Arrays.asList(selections.split(","));
+ exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList());
+ } else {
+ exportList = pageList;
+ }
+
+ // Step.3 AutoPoi 瀵煎嚭Excel
+ ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
+ //姝ゅ璁剧疆鐨刦ilename鏃犳晥,鍓嶇浼氶噸鏇存柊璁剧疆涓�涓�
+ mv.addObject(NormalExcelConstants.FILE_NAME, "宸ヨ鐩樼偣鏄庣粏");
+ mv.addObject(NormalExcelConstants.CLASS, TmsToolStocktakingDetail.class);
+ mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("宸ヨ鐩樼偣鏄庣粏鎶ヨ〃", "瀵煎嚭浜�:" + sysUser.getRealname(), "宸ヨ鐩樼偣鏄庣粏"));
+ mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
+ return mv;
+ }
+
+ /**
+ * 瀵煎叆
+ * @return
+ */
+ @RequestMapping(value = "/importTmsToolStocktakingDetail/{mainId}")
+ public Result<?> importTmsToolStocktakingDetail(HttpServletRequest request, HttpServletResponse response, @PathVariable("mainId") String mainId) {
+ MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
+ Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
+ for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
+ // 鑾峰彇涓婁紶鏂囦欢瀵硅薄
+ MultipartFile file = entity.getValue();
+ ImportParams params = new ImportParams();
+ params.setTitleRows(2);
+ params.setHeadRows(1);
+ params.setNeedSave(true);
+ try {
+ List<TmsToolStocktakingDetail> list = ExcelImportUtil.importExcel(file.getInputStream(), TmsToolStocktakingDetail.class, params);
+ for (TmsToolStocktakingDetail temp : list) {
+ temp.setOrderId(mainId);
+ }
+ long start = System.currentTimeMillis();
+ tmsToolStocktakingDetailService.saveBatch(list);
+ log.info("娑堣�楁椂闂�" + (System.currentTimeMillis() - start) + "姣");
+ return Result.OK("鏂囦欢瀵煎叆鎴愬姛锛佹暟鎹鏁帮細" + list.size());
+ } catch (Exception e) {
+ log.error(e.getMessage(), e);
+ return Result.error("鏂囦欢瀵煎叆澶辫触:" + e.getMessage());
+ } finally {
+ try {
+ file.getInputStream().close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+ }
+ return Result.error("鏂囦欢瀵煎叆澶辫触锛�");
+ }
+
+ /*--------------------------------瀛愯〃澶勭悊-宸ヨ鐩樼偣鏄庣粏-end----------------------------------------------*/
+
+
+
+
+}
--
Gitblit v1.9.3