package com.tievd.jyz.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.tievd.jyz.dto.DeviceDTO;
import com.tievd.jyz.dto.DeviceStatusStatDTO;
import com.tievd.jyz.entity.Device;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * Device
 *
 * @author cube
 * @version V2.0.0
 * @since 2023-02-27
 */
public interface DeviceMapper extends BaseMapper<Device> {

    /**
     * 自定义分页查询
     *
     * @param page
     * @param queryWrapper
     * @return
     */
    @Select("select d.*,count(c.id) cameraCount,count(if(c.status = 2, 1, null)) cameraOnlineCount from ( select * from t_device ${ew.customSqlSegment} ) d left join t_camera c on c.device_id = d.id group by d.id")
    IPage<DeviceDTO> tables(Page page, @Param("ew") QueryWrapper queryWrapper);

    /** 在线状态统计 */
    @Select("select count(if(tc.status =1,1,null)) onlineCount, count(if(tc.status =2,1,null)) offlineCount from t_device tc where tc.org_code like concat(#{orgCode},'%')")
    DeviceStatusStatDTO cameraStatusStat(String orgCode);
}