package com.mes.device.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mes.device.entity.DeviceGroupConfig;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 设备组配置Mapper接口
 */
@Mapper
public interface DeviceGroupConfigMapper extends BaseMapper<DeviceGroupConfig> {

    /**
     * 根据项目ID和设备组类型查询设备组配置列表
     * @param projectId 项目ID
     * @param groupType 设备组类型
     * @param status 设备组状态
     * @return 设备组配置列表
     */
    @Select({
        "<script>",
        "SELECT * FROM device_group_config",
        "WHERE is_deleted = 0",
        "<when test='projectId != null'>",
        "AND project_id = #{projectId}",
        "</when>",
        "<when test='groupType != null'>",
        "AND group_type = #{groupType}",
        "</when>",
        "<when test='status != null'>",
        "AND status = #{status}",
        "</when>",
        "ORDER BY id ASC",
        "</script>"
    })
    java.util.List<DeviceGroupConfig> selectDeviceGroupConfigList(
        @Param("projectId") Long projectId,
        @Param("groupType") Integer groupType,
        @Param("status") Integer status
    );

    /**
     * 统计启用设备组数量
     * @param projectId 项目ID
     * @return 启用设备组数量
     */
    @Select({
        "<script>",
        "SELECT COUNT(*) FROM device_group_config",
        "WHERE is_deleted = 0",
        "AND status = 1",
        "<when test='projectId != null'>",
        "AND project_id = #{projectId}",
        "</when>",
        "</script>"
    })
    int countEnabledDeviceGroups(@Param("projectId") Long projectId);

    /**
     * 统计设备组状态分布
     * @param projectId 项目ID
     * @return 设备组状态分布
     */
    @Select({
        "<script>",
        "SELECT",
        "    COUNT(CASE WHEN status = 0 THEN 1 END) as disabled_count,",
        "    COUNT(CASE WHEN status = 1 THEN 1 END) as enabled_count,",
        "    COUNT(CASE WHEN status = 2 THEN 1 END) as maintenance_count",
        "FROM device_group_config",
        "WHERE is_deleted = 0",
        "<when test='projectId != null'>",
        "AND project_id = #{projectId}",
        "</when>",
        "</script>"
    })
    java.util.Map<String, Object> getDeviceGroupStatusDistribution(@Param("projectId") Long projectId);

    /**
     * 查询设备组下的设备数量统计
     * @param groupId 设备组ID
     * @return 设备数量统计
     */
    @Select({
        "SELECT",
        "    COUNT(*) as total_devices,",
        "    COUNT(CASE WHEN dgr.status = 1 THEN 1 END) as normal_devices,",
        "    COUNT(CASE WHEN dgr.status = 2 THEN 1 END) as fault_devices,",
        "    COUNT(CASE WHEN dgr.status = 3 THEN 1 END) as maintenance_devices",
        "FROM device_group_relation dgr",
        "INNER JOIN device_config dc ON dgr.device_id = dc.id",
        "WHERE dgr.is_deleted = 0",
        "AND dc.is_deleted = 0",
        "AND dgr.group_id = #{groupId}"
    })
    java.util.Map<String, Object> getDeviceGroupDeviceStatistics(@Param("groupId") Long groupId);
}