From 781c5f73033ad1ae8c350210c46b4e24925d427b Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期四, 17 九月 2026 17:29:16 +0800
Subject: [PATCH] fix:委托编号更改
---
inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 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
new file mode 100644
index 0000000..899d52c
--- /dev/null
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderTemplateDeviceMapper.java
@@ -0,0 +1,29 @@
+package com.ruoyi.inspect.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+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);
+}
--
Gitblit v1.9.3