package com.ruoyi.device.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ruoyi.device.dto.LineInspectionDto;
|
import com.ruoyi.device.pojo.LineInspection;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 线路巡检Mapper接口
|
*/
|
@Mapper
|
public interface LineInspectionMapper extends BaseMapper<LineInspection> {
|
|
/**
|
* 查询线路巡检列表（关联设备信息）
|
*/
|
@Select("<script>" +
|
"SELECT li.*, dl.device_name, dl.device_model " +
|
"FROM line_inspection li " +
|
"LEFT JOIN device_ledger dl ON li.device_id = dl.id " +
|
"WHERE li.deleted = 0 " +
|
"<if test='dto.taskName != null and dto.taskName != \"\"'> " +
|
"AND li.task_name LIKE CONCAT('%', #{dto.taskName}, '%') " +
|
"</if>" +
|
"<if test='dto.routeName != null and dto.routeName != \"\"'> " +
|
"AND li.route_name LIKE CONCAT('%', #{dto.routeName}, '%') " +
|
"</if>" +
|
"<if test='dto.inspector != null and dto.inspector != \"\"'> " +
|
"AND li.inspector LIKE CONCAT('%', #{dto.inspector}, '%') " +
|
"</if>" +
|
"<if test='dto.status != null and dto.status != \"\"'> " +
|
"AND li.status = #{dto.status} " +
|
"</if>" +
|
"ORDER BY li.create_time DESC" +
|
"</script>")
|
List<LineInspectionDto> selectLineInspectionList(@Param("dto") LineInspectionDto dto);
|
}
|
