From ea0a63b59349941d90763ef54419637cb0ea53b1 Mon Sep 17 00:00:00 2001
From: “linengliang” <vanSuperEnergy@163.com>
Date: 星期二, 14 十一月 2023 17:45:20 +0800
Subject: [PATCH] 质量隐患确认，故障单
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/FaultInfoMapper.xml | 62 ++++++
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/FaultInfoServiceImpl.java | 23 ++
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/FaultInfoMapper.java | 26 ++
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IFaultInfoService.java | 17 +
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultInfoController.java | 168 ++++++++++++++++++
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/FaultInfo.java | 188 ++++++++++++++++++++
6 files changed, 484 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultInfoController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultInfoController.java
new file mode 100644
index 0000000..1bc8cc8
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultInfoController.java
@@ -0,0 +1,168 @@
+package org.jeecg.modules.eam.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.system.query.QueryGenerator;
+import org.jeecg.modules.eam.entity.FaultInfo;
+import org.jeecg.modules.eam.service.IFaultInfoService;
+
+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: 2023-11-08
+ * @Version: V1.0
+ */
+@Api(tags="璁惧浜嬫晠鐧昏")
+@RestController
+@RequestMapping("/li/faultInfo")
+@Slf4j
+public class FaultInfoController extends JeecgController<FaultInfo, IFaultInfoService> {
+ @Autowired
+ private IFaultInfoService faultInfoService;
+
+ /**
+ * 鍒嗛〉鍒楄〃鏌ヨ
+ *
+ * @param faultInfo
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ //@AutoLog(value = "璁惧浜嬫晠鐧昏-鍒嗛〉鍒楄〃鏌ヨ")
+ @ApiOperation(value="璁惧浜嬫晠鐧昏-鍒嗛〉鍒楄〃鏌ヨ", notes="璁惧浜嬫晠鐧昏-鍒嗛〉鍒楄〃鏌ヨ")
+ @GetMapping(value = "/list")
+ public Result<IPage<FaultInfo>> queryPageList(FaultInfo faultInfo,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ HttpServletRequest req) {
+ QueryWrapper<FaultInfo> queryWrapper = QueryGenerator.initQueryWrapper(faultInfo, req.getParameterMap());
+ Page<FaultInfo> page = new Page<FaultInfo>(pageNo, pageSize);
+ IPage<FaultInfo> pageList = faultInfoService.myPage(page, faultInfo);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ *
+ * @param faultInfo
+ * @return
+ */
+ @AutoLog(value = "璁惧浜嬫晠鐧昏-娣诲姞")
+ @ApiOperation(value="璁惧浜嬫晠鐧昏-娣诲姞", notes="璁惧浜嬫晠鐧昏-娣诲姞")
+ //@RequiresPermissions("org.jeecg.modules.mdc:mom_eam_fault_info:add")
+ @PostMapping(value = "/add")
+ public Result<String> add(@RequestBody FaultInfo faultInfo) {
+ faultInfoService.save(faultInfo);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ *
+ * @param faultInfo
+ * @return
+ */
+ @AutoLog(value = "璁惧浜嬫晠鐧昏-缂栬緫")
+ @ApiOperation(value="璁惧浜嬫晠鐧昏-缂栬緫", notes="璁惧浜嬫晠鐧昏-缂栬緫")
+ //@RequiresPermissions("org.jeecg.modules.mdc:mom_eam_fault_info:edit")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> edit(@RequestBody FaultInfo faultInfo) {
+ faultInfoService.updateById(faultInfo);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ *
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "璁惧浜嬫晠鐧昏-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="璁惧浜嬫晠鐧昏-閫氳繃id鍒犻櫎", notes="璁惧浜嬫晠鐧昏-閫氳繃id鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules.mdc:mom_eam_fault_info:delete")
+ @DeleteMapping(value = "/delete")
+ public Result<String> delete(@RequestParam(name="id",required=true) String id) {
+ faultInfoService.removeById(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ *
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "璁惧浜嬫晠鐧昏-鎵归噺鍒犻櫎")
+ @ApiOperation(value="璁惧浜嬫晠鐧昏-鎵归噺鍒犻櫎", notes="璁惧浜嬫晠鐧昏-鎵归噺鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules.mdc:mom_eam_fault_info:deleteBatch")
+ @DeleteMapping(value = "/deleteBatch")
+ public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
+ this.faultInfoService.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<FaultInfo> queryById(@RequestParam(name="id",required=true) String id) {
+ FaultInfo faultInfo = faultInfoService.getById(id);
+ if(faultInfo==null) {
+ return Result.error("鏈壘鍒板搴旀暟鎹�");
+ }
+ return Result.OK(faultInfo);
+ }
+
+ /**
+ * 瀵煎嚭excel
+ *
+ * @param request
+ * @param faultInfo
+ */
+ //@RequiresPermissions("org.jeecg.modules.mdc:mom_eam_fault_info:exportXls")
+ @RequestMapping(value = "/exportXls")
+ public ModelAndView exportXls(HttpServletRequest request, FaultInfo faultInfo) {
+ return super.exportXls(request, faultInfo, FaultInfo.class, "璁惧浜嬫晠鐧昏");
+ }
+
+ /**
+ * 閫氳繃excel瀵煎叆鏁版嵁
+ *
+ * @param request
+ * @param response
+ * @return
+ */
+ //@RequiresPermissions("mom_eam_fault_info:importExcel")
+ @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
+ public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
+ return super.importExcel(request, response, FaultInfo.class);
+ }
+ @PutMapping("confirm")
+ public Result<?> confirm(@RequestBody FaultInfo faultInfo){
+ faultInfo.setIsConfirm("yes");
+ faultInfoService.updateById(faultInfo);
+ return Result.OK("纭鎴愬姛");
+ }
+
+}
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/FaultInfo.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/FaultInfo.java
new file mode 100644
index 0000000..b422e8c
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/FaultInfo.java
@@ -0,0 +1,188 @@
+package org.jeecg.modules.eam.entity;
+
+import java.io.Serializable;
+import java.io.UnsupportedEncodingException;
+import java.util.Date;
+import java.math.BigDecimal;
+
+import com.baomidou.mybatisplus.annotation.*;
+import lombok.Data;
+import com.fasterxml.jackson.annotation.JsonFormat;
+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: 2023-11-08
+ * @Version: V1.0
+ */
+@Data
+@TableName("mom_eam_fault_info")
+@Accessors(chain = true)
+@EqualsAndHashCode(callSuper = false)
+@ApiModel(value="mom_eam_fault_info瀵硅薄", description="璁惧浜嬫晠鐧昏")
+public class FaultInfo implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭ID*/
+ @TableId(type = IdType.ASSIGN_ID)
+ @ApiModelProperty(value = "涓婚敭ID")
+ private java.lang.String id;
+ /**缂栫爜*/
+ @Excel(name = "缂栫爜", width = 15)
+ @ApiModelProperty(value = "缂栫爜")
+ private java.lang.String num;
+ /**璐ㄩ噺闅愭偅纭鍗旾D*/
+ @Excel(name = "璐ㄩ噺闅愭偅纭鍗旾D", width = 15)
+ @ApiModelProperty(value = "璐ㄩ噺闅愭偅纭鍗旾D")
+ @Dict(dictTable = "mom_eam_quanlity_confirm",dicText = "num",dicCode = "id")
+ private java.lang.String quanlityId;
+ /**缁翠慨璐圭敤*/
+ @Excel(name = "缁翠慨璐圭敤", width = 15)
+ @ApiModelProperty(value = "缁翠慨璐圭敤")
+ private java.lang.String cost;
+ /**鎿嶄綔鍛樻槸鍚︽湁鎿嶄綔璇�*/
+ @Excel(name = "鎿嶄綔鍛樻槸鍚︽湁鎿嶄綔璇�", width = 15)
+ @ApiModelProperty(value = "鎿嶄綔鍛樻槸鍚︽湁鎿嶄綔璇�")
+ private java.lang.String isCertificate;
+ /**鏄惁鏂數閲嶅惎*/
+ @Excel(name = "鏄惁鏂數閲嶅惎", width = 15)
+ @ApiModelProperty(value = "鏄惁鏂數閲嶅惎")
+ private java.lang.String isOutage;
+ /**鍔犲伐杩囩▼涓殑鍙樺姩鍥犵礌*/
+ @Excel(name = "鍔犲伐杩囩▼涓殑鍙樺姩鍥犵礌", width = 15)
+ @ApiModelProperty(value = "鍔犲伐杩囩▼涓殑鍙樺姩鍥犵礌")
+ private java.lang.String factor;
+ /**鍏蜂綋鏇存敼鍐呭*/
+ @Excel(name = "鍏蜂綋鏇存敼鍐呭", width = 15)
+ @ApiModelProperty(value = "鍏蜂綋鏇存敼鍐呭")
+ private java.lang.String modifyContent;
+ /**鍙戠敓浜嬫晠鏃惰澶囨墍鎵ц鐨勭▼搴�*/
+ @Excel(name = "鍙戠敓浜嬫晠鏃惰澶囨墍鎵ц鐨勭▼搴�", width = 15)
+ @ApiModelProperty(value = "鍙戠敓浜嬫晠鏃惰澶囨墍鎵ц鐨勭▼搴�")
+ private java.lang.String equipmentProcess;
+ /**鍙戠敓浜嬫晠鏃剁殑鐜拌薄*/
+ @Excel(name = "鍙戠敓浜嬫晠鏃剁殑鐜拌薄", width = 15)
+ @ApiModelProperty(value = "鍙戠敓浜嬫晠鏃剁殑鐜拌薄")
+ private java.lang.String phenomenon;
+ /**閲囧彇鎺柦1*/
+ @Excel(name = "閲囧彇鎺柦1", width = 15)
+ @ApiModelProperty(value = "閲囧彇鎺柦1")
+ private java.lang.String method1;
+ /**閲囧彇鎺柦2*/
+ @Excel(name = "閲囧彇鎺柦2", width = 15)
+ @ApiModelProperty(value = "閲囧彇鎺柦2")
+ private java.lang.String method2;
+ /**閲囧彇鎺柦3*/
+ @Excel(name = "閲囧彇鎺柦3", width = 15)
+ @ApiModelProperty(value = "閲囧彇鎺柦3")
+ private java.lang.String method3;
+ /**浜嬫晠鎵�閫犳垚鐨勭粨鏋�*/
+ @Excel(name = "浜嬫晠鎵�閫犳垚鐨勭粨鏋�", width = 15)
+ @ApiModelProperty(value = "浜嬫晠鎵�閫犳垚鐨勭粨鏋�")
+ private java.lang.String result;
+ /**寮�濮嬫鏌ユ椂闂�*/
+ @Excel(name = "寮�濮嬫鏌ユ椂闂�", width = 15, format = "yyyy-MM-dd")
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
+ @DateTimeFormat(pattern="yyyy-MM-dd")
+ @ApiModelProperty(value = "寮�濮嬫鏌ユ椂闂�")
+ private java.util.Date startCheckTime;
+ /**鍙戠敓浜嬫晠鍚庤澶囩殑鐘舵��*/
+ @Excel(name = "鍙戠敓浜嬫晠鍚庤澶囩殑鐘舵��", width = 15)
+ @ApiModelProperty(value = "鍙戠敓浜嬫晠鍚庤澶囩殑鐘舵��")
+ private java.lang.String equipmentStatus;
+ /**缁翠慨浜哄憳瀵逛簨鏁呯殑鍒嗘瀽*/
+ @Excel(name = "缁翠慨浜哄憳瀵逛簨鏁呯殑鍒嗘瀽", width = 15)
+ @ApiModelProperty(value = "缁翠慨浜哄憳瀵逛簨鏁呯殑鍒嗘瀽")
+ private java.lang.String anlysis;
+ /**缁翠慨浜哄憳妫�鏌ョ粨鏋�*/
+ @Excel(name = "缁翠慨浜哄憳妫�鏌ョ粨鏋�", width = 15)
+ @ApiModelProperty(value = "缁翠慨浜哄憳妫�鏌ョ粨鏋�")
+ private java.lang.String checkResult;
+ /**浜嬫晠鍘熷洜鍒嗘瀽杩囩▼涓墍閲囧彇鐨勭浉鍏宠涓�*/
+ @Excel(name = "浜嬫晠鍘熷洜鍒嗘瀽杩囩▼涓墍閲囧彇鐨勭浉鍏宠涓�", width = 15)
+ @ApiModelProperty(value = "浜嬫晠鍘熷洜鍒嗘瀽杩囩▼涓墍閲囧彇鐨勭浉鍏宠涓�")
+ private java.lang.String active;
+ /**寤鸿閲囧彇鐨勬帾鏂藉強鏃堕棿鑺傜偣*/
+ @Excel(name = "寤鸿閲囧彇鐨勬帾鏂藉強鏃堕棿鑺傜偣", width = 15)
+ @ApiModelProperty(value = "寤鸿閲囧彇鐨勬帾鏂藉強鏃堕棿鑺傜偣")
+ private java.lang.String suggest;
+ /**浜嬫晠鍙戠敓鍘熷洜鍒嗘瀽鐨勬牳瀵�*/
+ @Excel(name = "浜嬫晠鍙戠敓鍘熷洜鍒嗘瀽鐨勬牳瀵�", width = 15)
+ @ApiModelProperty(value = "浜嬫晠鍙戠敓鍘熷洜鍒嗘瀽鐨勬牳瀵�")
+ private java.lang.String judgment;
+ /**涓嶅悓鐨勬剰瑙佸強鍒嗘瀽*/
+ @Excel(name = "涓嶅悓鐨勬剰瑙佸強鍒嗘瀽", width = 15)
+ @ApiModelProperty(value = "涓嶅悓鐨勬剰瑙佸強鍒嗘瀽")
+ private java.lang.String differentJudgment;
+ /**鏁存敼鎺柦*/
+ @Excel(name = "鏁存敼鎺柦", width = 15)
+ @ApiModelProperty(value = "鏁存敼鎺柦")
+ private java.lang.String updateMethod;
+ /**浜嬫晠缁撹*/
+ @Excel(name = "浜嬫晠缁撹", width = 15)
+ @ApiModelProperty(value = "浜嬫晠缁撹")
+ private java.lang.String finalResult;
+ /**鎿嶄綔鑰�*/
+ @Excel(name = "鎿嶄綔鑰�", width = 15)
+ @ApiModelProperty(value = "鎿嶄綔鑰�")
+ private java.lang.String operater;
+ /**缁翠慨璐ｄ换浜�*/
+ @Excel(name = "缁翠慨璐ｄ换浜�", width = 15)
+ @ApiModelProperty(value = "缁翠慨璐ｄ换浜�")
+ private java.lang.String engineer;
+ /**鎶�鏈礋璐ｄ汉*/
+ @Excel(name = "鎶�鏈礋璐ｄ汉", width = 15)
+ @ApiModelProperty(value = "鎶�鏈礋璐ｄ汉")
+ private java.lang.String mechanic;
+ /**宸ラ暱*/
+ @Excel(name = "宸ラ暱", width = 15)
+ @ApiModelProperty(value = "宸ラ暱")
+ private java.lang.String workLeader;
+ /**涓績涓讳换*/
+ @Excel(name = "涓績涓讳换", width = 15)
+ @ApiModelProperty(value = "涓績涓讳换")
+ private java.lang.String centerLeader;
+ /**缁勯暱*/
+ @Excel(name = "缁勯暱", width = 15)
+ @ApiModelProperty(value = "缁勯暱")
+ private java.lang.String teamLeader;
+ /**缁翠慨绔欑珯闀�*/
+ @Excel(name = "缁翠慨绔欑珯闀�", width = 15)
+ @ApiModelProperty(value = "缁翠慨绔欑珯闀�")
+ private java.lang.String repairLeader;
+ /**绠＄悊瀹や笟鍔＄粡鐞�*/
+ @Excel(name = "绠＄悊瀹や笟鍔＄粡鐞�", width = 15)
+ @ApiModelProperty(value = "绠＄悊瀹や笟鍔＄粡鐞�")
+ private java.lang.String equipLeader;
+ /**杩愯淇濋殰閮ㄤ富绠￠瀵�*/
+ @Excel(name = "杩愯淇濋殰閮ㄤ富绠￠瀵�", width = 15)
+ @ApiModelProperty(value = "杩愯淇濋殰閮ㄤ富绠￠瀵�")
+ private java.lang.String guaranteeLeader;
+ private java.lang.String equipName;
+ private java.lang.String equipModel;
+ private java.lang.String equipNum;
+ private String area2;
+ @TableField(exist = false)
+ @Dict(dictTable = "sys_user",dicCode = "id",dicText = "realname")
+ private String operator;
+ @TableField(exist = false)
+ private String faultTime;
+ @TableField(exist = false)
+ @Dict(dictTable = "mom_base_area",dicText = "name",dicCode = "id")
+ private String area1;
+ @TableField(exist = false)
+ @Dict(dictTable = "sys_depart",dicCode = "id",dicText = "depart_name")
+ private String departId;
+ @TableField(exist = false)
+ private String level;
+ private String isConfirm;
+
+
+}
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/FaultInfoMapper.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/FaultInfoMapper.java
new file mode 100644
index 0000000..4f5c22d
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/FaultInfoMapper.java
@@ -0,0 +1,26 @@
+package org.jeecg.modules.eam.mapper;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Param;
+import org.jeecg.modules.eam.entity.FaultInfo;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+import java.util.List;
+
+/**
+ * @Description: 璁惧浜嬫晠鐧昏
+ * @Author: jeecg-boot
+ * @Date: 2023-11-08
+ * @Version: V1.0
+ */
+public interface FaultInfoMapper extends BaseMapper<FaultInfo> {
+ /**
+ * page
+ *
+ * @param page
+ * @param num
+ * @param isConfirm
+ * @return
+ */
+ List<FaultInfo> myPage(Page<FaultInfo> page,@Param("num") String num,@Param("isConfirm")String isConfirm);
+}
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/FaultInfoMapper.xml b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/FaultInfoMapper.xml
new file mode 100644
index 0000000..b1e85d3
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/FaultInfoMapper.xml
@@ -0,0 +1,62 @@
+<?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.eam.mapper.FaultInfoMapper">
+ <select id="myPage" resultType="org.jeecg.modules.eam.entity.FaultInfo">
+ select
+ t1.id,
+ t1.num,
+ t1.quanlity_id quanlityId,
+ t1.cost,
+ t1.is_certificate isCertificate,
+ t1.is_outage isOutage,
+ t1.factor,
+ t1.modify_content modifyContent,
+ t1.equipment_process equipmentProcess,
+ t1.phenomenon,
+ t1.method1,
+ t1.method2,
+ t1.method3,
+ t1.result,
+ t1.start_check_time startCheckTime,
+ t1.equipment_status equipmentStatus,
+ t1.anlysis,
+ t1.check_result checkResult,
+ t1.active,
+ t1.suggest,
+ t1.judgment,
+ t1.different_judgment differentJudgment,
+ t1.update_method updateMethod,
+ t1.final_result finalResult,
+ t1.operater,
+ t1.engineer,
+ t1.mechanic,
+ t1.work_leader workLeader,
+ t1.center_leader centerLeader,
+ t1.team_leader teamLeader,
+ t1.repair_leader repairLeader,
+ t1.equip_leader equipLeader,
+ t1.guarantee_leader guaranteeLeader,
+ t1.equip_name equipName,
+ t1.equip_model equipModel,
+ t1.equip_num equipNum,
+ t1.is_confirm isConfirm,
+ t1.area2,
+ t2.operator,
+ t3.fault_time faultTime,
+ t4.factory_model_id area1,
+ t4.use_id departId,
+ t5.technical_level level
+ from mom_eam_fault_info t1
+ left join mom_eam_quanlity_confirm t2 on t2.id = t1.quanlity_id
+ left join mom_eam_equipment_report_repair t3 on t3.id = t2.report_id
+ left join mom_eam_equipment t4 on t4.id = t3.equipment_id
+ left join mom_eam_operation_certificate t5 on t5.id = t2.operator
+ where 1=1
+ <if test="num != null and num != ''">
+ and t1.num like concat('%',#{num},'%')
+ </if>
+ <if test="isConfirm != null and isConfirm != ''">
+ and t1.is_confirm = #{isConfirm}
+ </if>
+ </select>
+</mapper>
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IFaultInfoService.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IFaultInfoService.java
new file mode 100644
index 0000000..1b44135
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IFaultInfoService.java
@@ -0,0 +1,17 @@
+package org.jeecg.modules.eam.service;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.jeecg.modules.eam.entity.FaultInfo;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * @Description: 璁惧浜嬫晠鐧昏
+ * @Author: jeecg-boot
+ * @Date: 2023-11-08
+ * @Version: V1.0
+ */
+public interface IFaultInfoService extends IService<FaultInfo> {
+
+ Page<FaultInfo>myPage(Page<FaultInfo> page,FaultInfo faultInfo);
+
+}
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/FaultInfoServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/FaultInfoServiceImpl.java
new file mode 100644
index 0000000..7221f77
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/FaultInfoServiceImpl.java
@@ -0,0 +1,23 @@
+package org.jeecg.modules.eam.service.impl;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.jeecg.modules.eam.entity.FaultInfo;
+import org.jeecg.modules.eam.mapper.FaultInfoMapper;
+import org.jeecg.modules.eam.service.IFaultInfoService;
+import org.springframework.stereotype.Service;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+
+/**
+ * @Description: 璁惧浜嬫晠鐧昏
+ * @Author: jeecg-boot
+ * @Date: 2023-11-08
+ * @Version: V1.0
+ */
+@Service
+public class FaultInfoServiceImpl extends ServiceImpl<FaultInfoMapper, FaultInfo> implements IFaultInfoService {
+ @Override
+ public Page<FaultInfo> myPage(Page<FaultInfo> page, FaultInfo faultInfo) {
+ return page.setRecords(baseMapper.myPage(page,faultInfo.getNum(),faultInfo.getIsConfirm()));
+ }
+}
--
Gitblit v1.9.3