From ffa5afb4e38d577c85813f48e41696f0c569c7a7 Mon Sep 17 00:00:00 2001
From: cuijian <cuijian@xalxzn.com>
Date: 星期二, 01 七月 2025 18:09:57 +0800
Subject: [PATCH] 质量-检验工具，检验项目
---
src/main/java/org/jeecg/modules/qms/service/impl/InspectionToolsServiceImpl.java | 19 +
src/main/java/org/jeecg/modules/base/controller/LineSideWarehouseController.java | 1
src/main/java/org/jeecg/modules/base/controller/SupplierController.java | 32 ++
src/main/java/org/jeecg/modules/qms/entity/InspectionItem.java | 91 ++++++++
src/main/java/org/jeecg/modules/qms/controller/InspectionToolsController.java | 173 +++++++++++++++
src/main/java/org/jeecg/modules/qms/mapper/InspectionToolsMapper.java | 14 +
src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionItemMapper.xml | 5
src/main/java/org/jeecg/modules/qms/entity/InspectionTools.java | 75 ++++++
src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java | 19 +
src/main/java/org/jeecg/modules/qms/service/IInspectionToolsService.java | 14 +
src/main/java/org/jeecg/modules/qms/controller/InspectionItemController.java | 179 ++++++++++++++++
src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionToolsMapper.xml | 5
src/main/java/org/jeecg/modules/qms/service/IInspectionItemService.java | 14 +
src/main/java/org/jeecg/modules/qms/mapper/InspectionItemMapper.java | 17 +
14 files changed, 658 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/jeecg/modules/base/controller/LineSideWarehouseController.java b/src/main/java/org/jeecg/modules/base/controller/LineSideWarehouseController.java
index 5b055e6..0379a86 100644
--- a/src/main/java/org/jeecg/modules/base/controller/LineSideWarehouseController.java
+++ b/src/main/java/org/jeecg/modules/base/controller/LineSideWarehouseController.java
@@ -85,6 +85,7 @@
//@RequiresPermissions("org.jeecg.modules:base_line_side_warehouse:add")
@PostMapping(value = "/add")
public Result<String> add(@RequestBody LineSideWarehouse lineSideWarehouse) {
+ lineSideWarehouse.setWarehouseStatus(CommonConstant.STATUS_1);
lineSideWarehouseService.save(lineSideWarehouse);
return Result.OK("娣诲姞鎴愬姛锛�");
}
diff --git a/src/main/java/org/jeecg/modules/base/controller/SupplierController.java b/src/main/java/org/jeecg/modules/base/controller/SupplierController.java
index 4e4a9ac..c46995b 100644
--- a/src/main/java/org/jeecg/modules/base/controller/SupplierController.java
+++ b/src/main/java/org/jeecg/modules/base/controller/SupplierController.java
@@ -1,5 +1,7 @@
package org.jeecg.modules.base.controller;
+import java.io.File;
+import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
@@ -9,6 +11,9 @@
import java.net.URLDecoder;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+
+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.constant.CommonConstant;
import org.jeecg.common.system.query.QueryGenerator;
@@ -191,4 +196,31 @@
return Result.ok("鎿嶄綔鎴愬姛锛�");
}
+ /**
+ * 瀵煎叆妯℃澘涓嬭浇
+ *
+ */
+ @RequestMapping(value = "/loadTemplate")
+ public void loadTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {
+
+ Map<String,String[]> req = request.getParameterMap();
+ 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);
+ }
+
+ }
+
}
diff --git a/src/main/java/org/jeecg/modules/qms/controller/InspectionItemController.java b/src/main/java/org/jeecg/modules/qms/controller/InspectionItemController.java
new file mode 100644
index 0000000..22d7c03
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/controller/InspectionItemController.java
@@ -0,0 +1,179 @@
+package org.jeecg.modules.qms.controller;
+
+import java.util.Arrays;
+import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
+import java.io.IOException;
+import java.io.UnsupportedEncodingException;
+import java.net.URLDecoder;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import org.jeecg.common.api.vo.Result;
+import org.jeecg.common.constant.CommonConstant;
+import org.jeecg.common.system.query.QueryGenerator;
+import org.jeecg.common.util.oConvertUtils;
+import org.jeecg.modules.qms.entity.InspectionItem;
+import org.jeecg.modules.qms.service.IInspectionItemService;
+
+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.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.jeecg.common.system.base.controller.JeecgController;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
+import org.springframework.web.multipart.MultipartHttpServletRequest;
+import org.springframework.web.servlet.ModelAndView;
+import com.alibaba.fastjson.JSON;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.jeecg.common.aspect.annotation.AutoLog;
+
+ /**
+ * @Description: 妫�楠岄」鐩�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+@Api(tags="妫�楠岄」鐩�")
+@RestController
+@RequestMapping("/qms/inspectionItem")
+@Slf4j
+public class InspectionItemController extends JeecgController<InspectionItem, IInspectionItemService> {
+ @Autowired
+ private IInspectionItemService inspectionItemService;
+
+ /**
+ * 鍒嗛〉鍒楄〃鏌ヨ
+ *
+ * @param inspectionItem
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ //@AutoLog(value = "妫�楠岄」鐩�-鍒嗛〉鍒楄〃鏌ヨ")
+ @ApiOperation(value="妫�楠岄」鐩�-鍒嗛〉鍒楄〃鏌ヨ", notes="妫�楠岄」鐩�-鍒嗛〉鍒楄〃鏌ヨ")
+ @GetMapping(value = "/list")
+ public Result<IPage<InspectionItem>> queryPageList(InspectionItem inspectionItem,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ HttpServletRequest req) {
+ QueryWrapper<InspectionItem> queryWrapper = QueryGenerator.initQueryWrapper(inspectionItem, req.getParameterMap());
+ Page<InspectionItem> page = new Page<InspectionItem>(pageNo, pageSize);
+ IPage<InspectionItem> pageList = inspectionItemService.page(page, queryWrapper);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ *
+ * @param inspectionItem
+ * @return
+ */
+ @AutoLog(value = "妫�楠岄」鐩�-娣诲姞")
+ @ApiOperation(value="妫�楠岄」鐩�-娣诲姞", notes="妫�楠岄」鐩�-娣诲姞")
+ //@RequiresPermissions("org.jeecg.modules:qms_inspection_item:add")
+ @PostMapping(value = "/add")
+ public Result<String> add(@RequestBody InspectionItem inspectionItem) {
+ inspectionItem.setItemStatus(CommonConstant.STATUS_1);
+ inspectionItemService.save(inspectionItem);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ *
+ * @param inspectionItem
+ * @return
+ */
+ @AutoLog(value = "妫�楠岄」鐩�-缂栬緫")
+ @ApiOperation(value="妫�楠岄」鐩�-缂栬緫", notes="妫�楠岄」鐩�-缂栬緫")
+ //@RequiresPermissions("org.jeecg.modules:qms_inspection_item:edit")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> edit(@RequestBody InspectionItem inspectionItem) {
+ inspectionItemService.updateById(inspectionItem);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ *
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "妫�楠岄」鐩�-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="妫�楠岄」鐩�-閫氳繃id鍒犻櫎", notes="妫�楠岄」鐩�-閫氳繃id鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules:qms_inspection_item:delete")
+ @DeleteMapping(value = "/delete")
+ public Result<String> delete(@RequestParam(name="id",required=true) String id) {
+ inspectionItemService.removeById(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ *
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "妫�楠岄」鐩�-鎵归噺鍒犻櫎")
+ @ApiOperation(value="妫�楠岄」鐩�-鎵归噺鍒犻櫎", notes="妫�楠岄」鐩�-鎵归噺鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules:qms_inspection_item:deleteBatch")
+ @DeleteMapping(value = "/deleteBatch")
+ public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
+ this.inspectionItemService.removeByIds(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鏌ヨ
+ *
+ * @param id
+ * @return
+ */
+ //@AutoLog(value = "妫�楠岄」鐩�-閫氳繃id鏌ヨ")
+ @ApiOperation(value="妫�楠岄」鐩�-閫氳繃id鏌ヨ", notes="妫�楠岄」鐩�-閫氳繃id鏌ヨ")
+ @GetMapping(value = "/queryById")
+ public Result<InspectionItem> queryById(@RequestParam(name="id",required=true) String id) {
+ InspectionItem inspectionItem = inspectionItemService.getById(id);
+ if(inspectionItem==null) {
+ return Result.error("鏈壘鍒板搴旀暟鎹�");
+ }
+ return Result.OK(inspectionItem);
+ }
+
+ /**
+ * 瀵煎嚭excel
+ *
+ * @param request
+ * @param inspectionItem
+ */
+ //@RequiresPermissions("org.jeecg.modules:qms_inspection_item:exportXls")
+ @RequestMapping(value = "/exportXls")
+ public ModelAndView exportXls(HttpServletRequest request, InspectionItem inspectionItem) {
+ return super.exportXls(request, inspectionItem, InspectionItem.class, "妫�楠岄」鐩�");
+ }
+
+ /**
+ * 閫氳繃excel瀵煎叆鏁版嵁
+ *
+ * @param request
+ * @param response
+ * @return
+ */
+ //@RequiresPermissions("qms_inspection_item:importExcel")
+ @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
+ public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
+ return super.importExcel(request, response, InspectionItem.class);
+ }
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/controller/InspectionToolsController.java b/src/main/java/org/jeecg/modules/qms/controller/InspectionToolsController.java
new file mode 100644
index 0000000..2410ad7
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/controller/InspectionToolsController.java
@@ -0,0 +1,173 @@
+package org.jeecg.modules.qms.controller;
+
+import java.util.Arrays;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import org.jeecg.common.api.vo.Result;
+import org.jeecg.common.constant.CommonConstant;
+import org.jeecg.common.system.query.QueryGenerator;
+import org.jeecg.modules.base.entity.LineSideWarehouse;
+import org.jeecg.modules.qms.entity.InspectionTools;
+import org.jeecg.modules.qms.service.IInspectionToolsService;
+
+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;
+import org.jeecg.common.aspect.annotation.AutoLog;
+
+ /**
+ * @Description: 妫�楠屽伐鍏�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+@Api(tags="妫�楠屽伐鍏�")
+@RestController
+@RequestMapping("/qms/inspectionTools")
+@Slf4j
+public class InspectionToolsController extends JeecgController<InspectionTools, IInspectionToolsService> {
+ @Autowired
+ private IInspectionToolsService inspectionToolsService;
+
+ /**
+ * 鍒嗛〉鍒楄〃鏌ヨ
+ *
+ * @param inspectionTools
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ //@AutoLog(value = "妫�楠屽伐鍏�-鍒嗛〉鍒楄〃鏌ヨ")
+ @ApiOperation(value="妫�楠屽伐鍏�-鍒嗛〉鍒楄〃鏌ヨ", notes="妫�楠屽伐鍏�-鍒嗛〉鍒楄〃鏌ヨ")
+ @GetMapping(value = "/list")
+ public Result<IPage<InspectionTools>> queryPageList(InspectionTools inspectionTools,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ HttpServletRequest req) {
+ QueryWrapper<InspectionTools> queryWrapper = QueryGenerator.initQueryWrapper(inspectionTools, req.getParameterMap());
+ Page<InspectionTools> page = new Page<InspectionTools>(pageNo, pageSize);
+ IPage<InspectionTools> pageList = inspectionToolsService.page(page, queryWrapper);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ *
+ * @param inspectionTools
+ * @return
+ */
+ @AutoLog(value = "妫�楠屽伐鍏�-娣诲姞")
+ @ApiOperation(value="妫�楠屽伐鍏�-娣诲姞", notes="妫�楠屽伐鍏�-娣诲姞")
+ @PostMapping(value = "/add")
+ public Result<String> add(@RequestBody InspectionTools inspectionTools) {
+ inspectionTools.setToolStatus(CommonConstant.STATUS_1);
+ inspectionToolsService.save(inspectionTools);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ *
+ * @param inspectionTools
+ * @return
+ */
+ @AutoLog(value = "妫�楠屽伐鍏�-缂栬緫")
+ @ApiOperation(value="妫�楠屽伐鍏�-缂栬緫", notes="妫�楠屽伐鍏�-缂栬緫")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> edit(@RequestBody InspectionTools inspectionTools) {
+ inspectionToolsService.updateById(inspectionTools);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ *
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "妫�楠屽伐鍏�-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="妫�楠屽伐鍏�-閫氳繃id鍒犻櫎", notes="妫�楠屽伐鍏�-閫氳繃id鍒犻櫎")
+ @DeleteMapping(value = "/delete")
+ public Result<String> delete(@RequestParam(name="id",required=true) String id) {
+ inspectionToolsService.removeById(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ *
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "妫�楠屽伐鍏�-鎵归噺鍒犻櫎")
+ @ApiOperation(value="妫�楠屽伐鍏�-鎵归噺鍒犻櫎", notes="妫�楠屽伐鍏�-鎵归噺鍒犻櫎")
+ @DeleteMapping(value = "/deleteBatch")
+ public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
+ this.inspectionToolsService.removeByIds(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鏌ヨ
+ *
+ * @param id
+ * @return
+ */
+ //@AutoLog(value = "妫�楠屽伐鍏�-閫氳繃id鏌ヨ")
+ @ApiOperation(value="妫�楠屽伐鍏�-閫氳繃id鏌ヨ", notes="妫�楠屽伐鍏�-閫氳繃id鏌ヨ")
+ @GetMapping(value = "/queryById")
+ public Result<InspectionTools> queryById(@RequestParam(name="id",required=true) String id) {
+ InspectionTools inspectionTools = inspectionToolsService.getById(id);
+ if(inspectionTools ==null) {
+ return Result.error("鏈壘鍒板搴旀暟鎹�");
+ }
+ return Result.OK(inspectionTools);
+ }
+
+ /**
+ * 瀵煎嚭excel
+ *
+ * @param request
+ * @param inspectionTools
+ */
+ @RequestMapping(value = "/exportXls")
+ public ModelAndView exportXls(HttpServletRequest request, InspectionTools inspectionTools) {
+ return super.exportXls(request, inspectionTools, InspectionTools.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, InspectionTools.class);
+ }
+
+ @AutoLog(value = "妫�楠屽伐鍏�-鍚敤&绂佺敤")
+ @ApiOperation(value = "妫�楠屽伐鍏�-鍚敤&绂佺敤", notes = "妫�楠屽伐鍏�-鍚敤&绂佺敤")
+ @PutMapping(value = "/active")
+ public Result<?> active(@RequestParam(name = "id", required = true) String id) {
+ InspectionTools inspectionTools = inspectionToolsService.getById(id);
+ if (CommonConstant.STATUS_1.equals(inspectionTools.getToolStatus())) {
+ inspectionTools.setToolStatus(CommonConstant.STATUS_0);
+ } else {
+ inspectionTools.setToolStatus(CommonConstant.STATUS_1);
+ }
+ inspectionToolsService.updateById(inspectionTools);
+ return Result.ok("鎿嶄綔鎴愬姛锛�");
+ }
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/entity/InspectionItem.java b/src/main/java/org/jeecg/modules/qms/entity/InspectionItem.java
new file mode 100644
index 0000000..b2be82a
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/entity/InspectionItem.java
@@ -0,0 +1,91 @@
+package org.jeecg.modules.qms.entity;
+
+import java.io.Serializable;
+import java.io.UnsupportedEncodingException;
+import java.util.Date;
+import java.math.BigDecimal;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import lombok.Data;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.jeecg.common.constant.CommonConstant;
+import org.springframework.format.annotation.DateTimeFormat;
+import org.jeecgframework.poi.excel.annotation.Excel;
+import org.jeecg.common.aspect.annotation.Dict;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.EqualsAndHashCode;
+import lombok.experimental.Accessors;
+
+/**
+ * @Description: 妫�楠岄」鐩�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+@Data
+@TableName("qms_inspection_item")
+@Accessors(chain = true)
+@EqualsAndHashCode(callSuper = false)
+@ApiModel(value="qms_inspection_item瀵硅薄", description="妫�楠岄」鐩�")
+public class InspectionItem implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭*/
+ @TableId(type = IdType.ASSIGN_ID)
+ @ApiModelProperty(value = "涓婚敭")
+ private String id;
+ /**鍒涘缓浜�*/
+ @ApiModelProperty(value = "鍒涘缓浜�")
+ private String createBy;
+ /**鍒涘缓鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
+ @DateTimeFormat(pattern="yyyy-MM-dd")
+ @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+ private Date createTime;
+ /**鏇存柊浜�*/
+ @ApiModelProperty(value = "鏇存柊浜�")
+ private String updateBy;
+ /**鏇存柊鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
+ @DateTimeFormat(pattern="yyyy-MM-dd")
+ @ApiModelProperty(value = "鏇存柊鏃堕棿")
+ private Date updateTime;
+ /**鍒犻櫎鏍囪*/
+ @Excel(name = "鍒犻櫎鏍囪", width = 15)
+ @ApiModelProperty(value = "鍒犻櫎鏍囪")
+ @TableLogic
+ private Integer delFlag = CommonConstant.DEL_FLAG_0;
+ /**椤圭洰缂栧彿*/
+ @Excel(name = "椤圭洰缂栧彿", width = 15)
+ @ApiModelProperty(value = "椤圭洰缂栧彿")
+ private String itemCode;
+ /**椤圭洰鍚嶇О*/
+ @Excel(name = "椤圭洰鍚嶇О", width = 15)
+ @ApiModelProperty(value = "椤圭洰鍚嶇О")
+ private String itemName;
+ /**椤圭洰鐘舵��*/
+ @Excel(name = "椤圭洰鐘舵��", width = 15)
+ @ApiModelProperty(value = "椤圭洰鐘舵��")
+ private String itemStatus;
+ /**椤圭洰鍒嗙被*/
+ @Excel(name = "椤圭洰鍒嗙被", width = 15)
+ @ApiModelProperty(value = "椤圭洰鍒嗙被")
+ @Dict(dicCode = "item_category")
+ private String itemCategory;
+ /**瀹氶噺/瀹氭��*/
+ @Excel(name = "瀹氶噺/瀹氭��", width = 15)
+ @ApiModelProperty(value = "瀹氶噺/瀹氭��")
+ @Dict(dicCode = "qualitative_or_quantitative")
+ private String qualitativeOrQuantitative;
+ /**娴嬮噺宸ュ叿(澶氶��)*/
+ @Excel(name = "娴嬮噺宸ュ叿(澶氶��)", width = 15)
+ @ApiModelProperty(value = "娴嬮噺宸ュ叿(澶氶��)")
+ private String inspectionTools;
+ /**澶囨敞*/
+ @Excel(name = "澶囨敞", width = 15)
+ @ApiModelProperty(value = "澶囨敞")
+ private String remark;
+}
diff --git a/src/main/java/org/jeecg/modules/qms/entity/InspectionTools.java b/src/main/java/org/jeecg/modules/qms/entity/InspectionTools.java
new file mode 100644
index 0000000..a56d53f
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/entity/InspectionTools.java
@@ -0,0 +1,75 @@
+package org.jeecg.modules.qms.entity;
+
+import java.io.Serializable;
+import java.util.Date;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import lombok.Data;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.jeecg.common.constant.CommonConstant;
+import org.springframework.format.annotation.DateTimeFormat;
+import org.jeecgframework.poi.excel.annotation.Excel;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.EqualsAndHashCode;
+import lombok.experimental.Accessors;
+
+/**
+ * @Description: 妫�楠屽伐鍏�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+@Data
+@TableName("qms_inspection_tools")
+@Accessors(chain = true)
+@EqualsAndHashCode(callSuper = false)
+@ApiModel(value="qms_inspection_tools瀵硅薄", description="妫�楠屽伐鍏�")
+public class InspectionTools implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭*/
+ @TableId(type = IdType.ASSIGN_ID)
+ @ApiModelProperty(value = "涓婚敭")
+ private String id;
+ /**鍒涘缓浜�*/
+ @ApiModelProperty(value = "鍒涘缓浜�")
+ private String createBy;
+ /**鍒涘缓鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
+ @DateTimeFormat(pattern="yyyy-MM-dd")
+ @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+ private Date createTime;
+ /**鏇存柊浜�*/
+ @ApiModelProperty(value = "鏇存柊浜�")
+ private String updateBy;
+ /**鏇存柊鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
+ @DateTimeFormat(pattern="yyyy-MM-dd")
+ @ApiModelProperty(value = "鏇存柊鏃堕棿")
+ private Date updateTime;
+ /**鍒犻櫎鏍囪*/
+ @Excel(name = "鍒犻櫎鏍囪", width = 15)
+ @ApiModelProperty(value = "鍒犻櫎鏍囪")
+ @TableLogic
+ private Integer delFlag = CommonConstant.DEL_FLAG_0;
+ /**宸ュ叿鍚嶇О*/
+ @Excel(name = "宸ュ叿鍚嶇О", width = 15)
+ @ApiModelProperty(value = "宸ュ叿鍚嶇О")
+ private String toolName;
+ /**宸ュ叿缂栫爜*/
+ @Excel(name = "宸ュ叿缂栫爜", width = 15)
+ @ApiModelProperty(value = "宸ュ叿缂栫爜")
+ private String toolCode;
+ /**宸ュ叿鐘舵��*/
+ @Excel(name = "宸ュ叿鐘舵��", width = 15)
+ @ApiModelProperty(value = "宸ュ叿鐘舵��")
+ private String toolStatus;
+ /**澶囨敞*/
+ @Excel(name = "澶囨敞", width = 15)
+ @ApiModelProperty(value = "澶囨敞")
+ private String remark;
+}
diff --git a/src/main/java/org/jeecg/modules/qms/mapper/InspectionItemMapper.java b/src/main/java/org/jeecg/modules/qms/mapper/InspectionItemMapper.java
new file mode 100644
index 0000000..45a1711
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/mapper/InspectionItemMapper.java
@@ -0,0 +1,17 @@
+package org.jeecg.modules.qms.mapper;
+
+import java.util.List;
+
+import org.apache.ibatis.annotations.Param;
+import org.jeecg.modules.qms.entity.InspectionItem;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+/**
+ * @Description: 妫�楠岄」鐩�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+public interface InspectionItemMapper extends BaseMapper<InspectionItem> {
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/mapper/InspectionToolsMapper.java b/src/main/java/org/jeecg/modules/qms/mapper/InspectionToolsMapper.java
new file mode 100644
index 0000000..4aea79a
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/mapper/InspectionToolsMapper.java
@@ -0,0 +1,14 @@
+package org.jeecg.modules.qms.mapper;
+
+import org.jeecg.modules.qms.entity.InspectionTools;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+/**
+ * @Description: 妫�楠屽伐鍏�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+public interface InspectionToolsMapper extends BaseMapper<InspectionTools> {
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionItemMapper.xml b/src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionItemMapper.xml
new file mode 100644
index 0000000..3d0f356
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionItemMapper.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="org.jeecg.modules.qms.mapper.InspectionItemMapper">
+
+</mapper>
\ No newline at end of file
diff --git a/src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionToolsMapper.xml b/src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionToolsMapper.xml
new file mode 100644
index 0000000..91f9ed6
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/mapper/xml/InspectionToolsMapper.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="org.jeecg.modules.qms.mapper.InspectionToolsMapper">
+
+</mapper>
\ No newline at end of file
diff --git a/src/main/java/org/jeecg/modules/qms/service/IInspectionItemService.java b/src/main/java/org/jeecg/modules/qms/service/IInspectionItemService.java
new file mode 100644
index 0000000..d68aa84
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/service/IInspectionItemService.java
@@ -0,0 +1,14 @@
+package org.jeecg.modules.qms.service;
+
+import org.jeecg.modules.qms.entity.InspectionItem;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * @Description: 妫�楠岄」鐩�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+public interface IInspectionItemService extends IService<InspectionItem> {
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/service/IInspectionToolsService.java b/src/main/java/org/jeecg/modules/qms/service/IInspectionToolsService.java
new file mode 100644
index 0000000..8b5cbe4
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/service/IInspectionToolsService.java
@@ -0,0 +1,14 @@
+package org.jeecg.modules.qms.service;
+
+import org.jeecg.modules.qms.entity.InspectionTools;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * @Description: 妫�楠屽伐鍏�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+public interface IInspectionToolsService extends IService<InspectionTools> {
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java b/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java
new file mode 100644
index 0000000..101beb0
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/service/impl/InspectionItemServiceImpl.java
@@ -0,0 +1,19 @@
+package org.jeecg.modules.qms.service.impl;
+
+import org.jeecg.modules.qms.entity.InspectionItem;
+import org.jeecg.modules.qms.mapper.InspectionItemMapper;
+import org.jeecg.modules.qms.service.IInspectionItemService;
+import org.springframework.stereotype.Service;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+
+/**
+ * @Description: 妫�楠岄」鐩�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+@Service
+public class InspectionItemServiceImpl extends ServiceImpl<InspectionItemMapper, InspectionItem> implements IInspectionItemService {
+
+}
diff --git a/src/main/java/org/jeecg/modules/qms/service/impl/InspectionToolsServiceImpl.java b/src/main/java/org/jeecg/modules/qms/service/impl/InspectionToolsServiceImpl.java
new file mode 100644
index 0000000..7cf875e
--- /dev/null
+++ b/src/main/java/org/jeecg/modules/qms/service/impl/InspectionToolsServiceImpl.java
@@ -0,0 +1,19 @@
+package org.jeecg.modules.qms.service.impl;
+
+import org.jeecg.modules.qms.entity.InspectionTools;
+import org.jeecg.modules.qms.mapper.InspectionToolsMapper;
+import org.jeecg.modules.qms.service.IInspectionToolsService;
+import org.springframework.stereotype.Service;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+
+/**
+ * @Description: 妫�楠屽伐鍏�
+ * @Author: jeecg-boot
+ * @Date: 2025-07-01
+ * @Version: V1.0
+ */
+@Service
+public class InspectionToolsServiceImpl extends ServiceImpl<InspectionToolsMapper, InspectionTools> implements IInspectionToolsService {
+
+}
--
Gitblit v1.9.3