From 444409ba734d4457f9109f0b71422b83fed60cd6 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期四, 24 九月 2026 11:14:20 +0800
Subject: [PATCH] refactor(inspect): 重构设备列表查询和报告生成逻辑
---
inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java | 15 +--------------
1 files changed, 1 insertions(+), 14 deletions(-)
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java
index 899d52c..9a3951a 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java
@@ -4,26 +4,13 @@
import com.ruoyi.inspect.pojo.InsOrderTemplateDevice;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
-import org.apache.ibatis.annotations.Select;
import java.util.List;
@Mapper
public interface InsOrderTemplateDeviceMapper extends BaseMapper<InsOrderTemplateDevice> {
- @Select({"<script>",
- "select id from device where id in",
- "<foreach collection='deviceIds' item='deviceId' open='(' separator=',' close=')'>",
- "#{deviceId}",
- "</foreach>",
- "</script>"})
List<Integer> selectExistingDeviceIds(@Param("deviceIds") List<Integer> deviceIds);
- @Select("select distinct d.management_number " +
- "from ins_order_template_device otd " +
- "join device d on d.id = otd.device_id " +
- "where otd.ins_order_id = #{orderId} " +
- "and d.management_number is not null and d.management_number <> '' " +
- "order by d.management_number")
- List<String> selectManagementNumbersByOrderId(@Param("orderId") Integer orderId);
+ List<Integer> selectDeviceIdsByOrderId(@Param("orderId") Integer orderId);
}
--
Gitblit v1.9.3