From 4958e2592279bfb1dd3e3ee9ce39999cf461c832 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期五, 11 七月 2025 14:24:23 +0800
Subject: [PATCH] art: 查询可用技术状态鉴定规范

---
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java |   20 +++++++++++++++++++-
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusEvaluationStandardService.java         |   11 +++++++++++
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusEvaluationStandardController.java    |   13 ++++++++++++-
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusEvaluationStandard.java                  |    2 ++
 4 files changed, 44 insertions(+), 2 deletions(-)

diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusEvaluationStandardController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusEvaluationStandardController.java
index 70448c1..e099e34 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusEvaluationStandardController.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusEvaluationStandardController.java
@@ -267,5 +267,16 @@
         return Result.ok("鎵�鏈夋枃浠跺鍏ユ垚鍔燂細" + response);
     }
 
-
+    /**
+     * 鏌ヨ宸插瓨鍦ㄥ彲鐢ㄧ殑鎶�鏈姸鎬侀壌瀹氳鑼冪殑璁惧
+     * @return
+     */
+    @ApiOperation(value = "鎶�鏈姸鎬侀壌瀹氳鑼�-鏌ヨ宸插瓨鍦ㄥ彲鐢ㄧ殑鎶�鏈姸鎬侀壌瀹氳鑼冪殑璁惧", notes = "鎶�鏈姸鎬侀壌瀹氳鑼�-鏌ヨ宸插瓨鍦ㄥ彲鐢ㄧ殑鎶�鏈姸鎬侀壌瀹氳鑼冪殑璁惧")
+    @GetMapping(value = "/selectEnableEquipment")
+    public Result<?> selectEnableEquipment(@RequestParam(name = "keyword", required = false) String keyword,
+                                           @RequestParam(name = "equipmentId", required = false) String equipmentId,
+                                           @RequestParam(value = "pageSize", required = false, defaultValue = "20") Integer pageSize) {
+        List<EamTechnicalStatusEvaluationStandard> list = eamTechnicalStatusEvaluationStandardService.queryListByKeyword(keyword, equipmentId, pageSize);
+        return Result.OK(list);
+    }
 }
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusEvaluationStandard.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusEvaluationStandard.java
index 070541f..de14e32 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusEvaluationStandard.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusEvaluationStandard.java
@@ -86,4 +86,6 @@
 	private String equipmentName;
 	@TableField(exist = false)
 	private String equipmentModel;
+	@TableField(exist = false)
+	private String keyword;
 }
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusEvaluationStandardService.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusEvaluationStandardService.java
index 4e1a8b7..c621279 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusEvaluationStandardService.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusEvaluationStandardService.java
@@ -8,6 +8,8 @@
 import org.jeecg.modules.eam.request.EamTechnicalStatusEvaluationStandardRequest;
 import org.springframework.web.multipart.MultipartFile;
 
+import java.util.List;
+
 /**
  * @Description: 鎶�鏈姸鎬侀壌瀹氳鑼�
  * @Author: jeecg-boot
@@ -73,4 +75,13 @@
      * @return
      */
     Result<?> importOtherCheck(MultipartFile file);
+
+    /**
+     * 鏌ヨ宸插瓨鍦ㄥ彲鐢ㄧ殑鎶�鏈姸鎬侀壌瀹氳鑼冪殑璁惧
+     * @param keyword
+     * @param equipmentId
+     * @param pageSize
+     * @return
+     */
+    List<EamTechnicalStatusEvaluationStandard> queryListByKeyword(String keyword, String equipmentId, Integer pageSize);
 }
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java
index 8bb7a21..51d0233 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java
@@ -105,9 +105,16 @@
                 queryWrapper.eq("ems.equipment_id", query.getEquipmentId());
             }
 
-            //淇濆吇鍒嗙被
+            //瑙勮寖鐘舵��
             if (StringUtils.isNotBlank(query.getStandardStatus())) {
                 queryWrapper.eq("ems.standard_status", query.getStandardStatus());
+            }
+
+            //璁惧缂栫爜
+            if (StringUtils.isNotBlank(query.getKeyword())) {
+                queryWrapper.and(wrapper -> wrapper.like("e.equipment_name", query.getKeyword())
+                        .or()
+                        .like("e.equipment_code", query.getKeyword()));
             }
         }
         queryWrapper.orderByDesc("ems.create_time");
@@ -540,6 +547,17 @@
         return Result.OK(fileName + ":瀵煎叆鎴愬姛锛�");
     }
 
+    @Override
+    public List<EamTechnicalStatusEvaluationStandard> queryListByKeyword(String keyword, String equipmentId, Integer pageSize) {
+        Page<EamTechnicalStatusEvaluationStandard> page = new Page<>(1, pageSize);
+        EamTechnicalStatusEvaluationStandard query = new EamTechnicalStatusEvaluationStandard();
+        query.setEquipmentId(equipmentId);
+        query.setKeyword(keyword);
+        query.setStandardStatus(TechnicalStatusEvaluationStandardEnum.ENABLE.name());
+        IPage<EamTechnicalStatusEvaluationStandard> pageData = this.queryPageList(page, query);
+        return pageData.getRecords();
+    }
+
     /**
      * 妫�鏌ュ鍏ユ枃浠跺垎绫绘槸鍚﹀尮閰�
      * @param title 鏍囬娈佃惤瀛楃涓�

--
Gitblit v1.9.3