From 23855599412c4d61b38d78f0f3abd3430a48b5b1 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 25 六月 2025 11:51:38 +0800
Subject: [PATCH] Merge branch 'mdc_hyjs_master'
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java | 160 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 160 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java
new file mode 100644
index 0000000..377f682
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java
@@ -0,0 +1,160 @@
+package org.jeecg.modules.eam.controller;
+
+import java.util.Arrays;
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.jeecg.common.api.vo.Result;
+import org.jeecg.common.system.query.QueryGenerator;
+import org.jeecg.common.aspect.annotation.AutoLog;
+import org.jeecg.modules.eam.entity.EamSparePartInventory;
+import org.jeecg.modules.eam.entity.EamSpareParts;
+import org.jeecg.modules.eam.service.IEamSparePartInventoryService;
+import org.jeecg.modules.eam.service.IEamSparePartsService;
+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.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+import org.springframework.web.servlet.ModelAndView;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+
+/**
+ * @Description: 澶囧搧澶囦欢绠＄悊
+ * @Author: Lius
+ * @Date: 2025-03-19
+ * @Version: V1.0
+ */
+@Slf4j
+@Api(tags = "澶囧搧澶囦欢绠＄悊")
+@RestController
+@RequestMapping("/eam/eamSpareParts")
+public class EamSparePartsController extends JeecgController<EamSpareParts, IEamSparePartsService> {
+
+ @Resource
+ private IEamSparePartsService eamSparePartsService;
+
+ @Autowired
+ private IEamSparePartInventoryService eamSparePartInventoryService;
+
+ /**
+ * 鍒嗛〉鍒楄〃鏌ヨ
+ *
+ * @param eamSpareParts
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ @ApiOperation(value = "澶囧搧澶囦欢绠＄悊-鍒嗛〉鍒楄〃鏌ヨ", notes = "澶囧搧澶囦欢绠＄悊-鍒嗛〉鍒楄〃鏌ヨ")
+ @GetMapping(value = "/list")
+ public Result<?> queryPageList(EamSpareParts eamSpareParts,
+ @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
+ @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
+ HttpServletRequest req) {
+ QueryWrapper<EamSpareParts> queryWrapper = QueryGenerator.initQueryWrapper(eamSpareParts, req.getParameterMap());
+ Page<EamSpareParts> page = new Page<EamSpareParts>(pageNo, pageSize);
+ IPage<EamSpareParts> pageList = eamSparePartsService.page(page, queryWrapper);
+ for (EamSpareParts record : pageList.getRecords()) {
+ QueryWrapper<EamSparePartInventory> wrapper = new QueryWrapper<>();
+ wrapper.eq("spare_part_id",record.getId()).select("sum(inventory) as inventory");
+ EamSparePartInventory one = eamSparePartInventoryService.getOne(wrapper);
+ record.setTotalQuantity(one.getInventory().toString());
+ }
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ *
+ * @param eamSpareParts
+ * @return
+ */
+ @ApiOperation(value = "澶囧搧澶囦欢绠＄悊-娣诲姞", notes = "澶囧搧澶囦欢绠＄悊-娣诲姞")
+ @PostMapping(value = "/add")
+ public Result<?> add(@RequestBody EamSpareParts eamSpareParts) {
+ eamSparePartsService.save(eamSpareParts);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ *
+ * @param eamSpareParts
+ * @return
+ */
+ @ApiOperation(value = "澶囧搧澶囦欢绠＄悊-缂栬緫", notes = "澶囧搧澶囦欢绠＄悊-缂栬緫")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT, RequestMethod.POST})
+ public Result<?> edit(@RequestBody EamSpareParts eamSpareParts) {
+ eamSparePartsService.updateById(eamSpareParts);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ *
+ * @param id
+ * @return
+ */
+ @ApiOperation(value = "澶囧搧澶囦欢绠＄悊-閫氳繃id鍒犻櫎", notes = "澶囧搧澶囦欢绠＄悊-閫氳繃id鍒犻櫎")
+ @DeleteMapping(value = "/delete")
+ public Result<?> delete(@RequestParam(name = "id", required = true) String id) {
+ eamSparePartsService.removeById(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ *
+ * @param ids
+ * @return
+ */
+ @ApiOperation(value = "澶囧搧澶囦欢绠＄悊-鎵归噺鍒犻櫎", notes = "澶囧搧澶囦欢绠＄悊-鎵归噺鍒犻櫎")
+ @DeleteMapping(value = "/deleteBatch")
+ public Result<?> deleteBatch(@RequestParam(name = "ids", required = true) String ids) {
+ this.eamSparePartsService.removeByIds(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛锛�");
+ }
+
+ /**
+ * 閫氳繃id鏌ヨ
+ *
+ * @param id
+ * @return
+ */
+ @ApiOperation(value = "澶囧搧澶囦欢绠＄悊-閫氳繃id鏌ヨ", notes = "澶囧搧澶囦欢绠＄悊-閫氳繃id鏌ヨ")
+ @GetMapping(value = "/queryById")
+ public Result<?> queryById(@RequestParam(name = "id", required = true) String id) {
+ EamSpareParts eamSpareParts = eamSparePartsService.getById(id);
+ return Result.OK(eamSpareParts);
+ }
+
+ /**
+ * 瀵煎嚭excel
+ *
+ * @param request
+ * @param eamSpareParts
+ */
+ @RequestMapping(value = "/exportXls")
+ public ModelAndView exportXls(HttpServletRequest request, EamSpareParts eamSpareParts) {
+ return super.exportXls(request, eamSpareParts, EamSpareParts.class, "澶囧搧澶囦欢绠＄悊");
+ }
+
+ /**
+ * 閫氳繃excel瀵煎叆鏁版嵁
+ *
+ * @param request
+ * @param response
+ * @return
+ */
+ @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
+ public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
+ return super.importExcel(request, response, EamSpareParts.class);
+ }
+
+}
--
Gitblit v1.9.3