package com.ruoyi.device.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.device.dto.SafetyFacilityDto;
import com.ruoyi.device.pojo.SafetyFacility;
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 SafetyFacilityMapper extends BaseMapper<SafetyFacility> {

    /**
     * 查询安全设施列表（关联设备信息）
     */
    @Select("<script>" +
            "SELECT sf.*, dl.device_name, dl.device_model " +
            "FROM safety_facility sf " +
            "LEFT JOIN device_ledger dl ON sf.device_id = dl.id " +
            "WHERE sf.deleted = 0 " +
            "<if test='dto.facilityName != null and dto.facilityName != \"\"'> " +
            "AND sf.facility_name LIKE CONCAT('%', #{dto.facilityName}, '%') " +
            "</if>" +
            "<if test='dto.facilityType != null and dto.facilityType != \"\"'> " +
            "AND sf.facility_type = #{dto.facilityType} " +
            "</if>" +
            "<if test='dto.status != null and dto.status != \"\"'> " +
            "AND sf.status = #{dto.status} " +
            "</if>" +
            "<if test='dto.location != null and dto.location != \"\"'> " +
            "AND sf.location LIKE CONCAT('%', #{dto.location}, '%') " +
            "</if>" +
            "ORDER BY sf.create_time DESC" +
            "</script>")
    List<SafetyFacilityDto> selectSafetyFacilityList(@Param("dto") SafetyFacilityDto dto);
}