package com.mes.device.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.mes.device.entity.DeviceConfig;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* 设备配置Mapper接口
|
*/
|
@Mapper
|
public interface DeviceConfigMapper extends BaseMapper<DeviceConfig> {
|
|
/**
|
* 根据项目ID和设备类型查询设备配置列表
|
* @param projectId 项目ID
|
* @param deviceType 设备类型
|
* @param status 设备状态
|
* @return 设备配置列表
|
*/
|
@Select({
|
"<script>",
|
"SELECT * FROM device_config",
|
"WHERE is_deleted = 0",
|
"<when test='projectId != null'>",
|
"AND project_id = #{projectId}",
|
"</when>",
|
"<when test='deviceType != null'>",
|
"AND device_type = #{deviceType}",
|
"</when>",
|
"<when test='status != null'>",
|
"AND status = #{status}",
|
"</when>",
|
"ORDER BY id ASC",
|
"</script>"
|
})
|
java.util.List<DeviceConfig> selectDeviceConfigList(
|
@Param("projectId") Long projectId,
|
@Param("deviceType") String deviceType,
|
@Param("status") String status
|
);
|
|
/**
|
* 统计在线设备数量
|
* @param projectId 项目ID
|
* @return 在线设备数量
|
*/
|
@Select({
|
"<script>",
|
"SELECT COUNT(*) FROM device_config",
|
"WHERE is_deleted = 0",
|
"AND status = '在线'",
|
"<when test='projectId != null'>",
|
"AND project_id = #{projectId}",
|
"</when>",
|
"</script>"
|
})
|
int countOnlineDevices(@Param("projectId") Long projectId);
|
|
/**
|
* 统计设备状态分布
|
* @param projectId 项目ID
|
* @return 设备状态分布
|
*/
|
@Select({
|
"<script>",
|
"SELECT",
|
" COUNT(CASE WHEN status = '离线' THEN 1 END) as offline_count,",
|
" COUNT(CASE WHEN status = '在线' THEN 1 END) as online_count,",
|
" COUNT(CASE WHEN status = '维护中' THEN 1 END) as maintenance_count,",
|
" COUNT(CASE WHEN status = '故障' THEN 1 END) as fault_count",
|
"FROM device_config",
|
"WHERE is_deleted = 0",
|
"<when test='projectId != null'>",
|
"AND project_id = #{projectId}",
|
"</when>",
|
"</script>"
|
})
|
java.util.Map<String, Object> getDeviceStatusDistribution(@Param("projectId") Long projectId);
|
}
|
