refactor(inspect): 重构设备列表查询和报告生成逻辑

liding

11 小时以前 444409ba734d4457f9109f0b71422b83fed60cd6

 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);
}