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