package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.acid.BatchCheckAcidRecordDTO;
import com.panzhihua.common.model.dtos.community.acid.ComActAcidRecordDTO;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.acid.*;
import com.panzhihua.common.model.vos.community.reserve.FiveCount;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActAcidRecord;
import org.apache.ibatis.annotations.Param;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

/**
 * (ComActAcidRecord)表数据库访问层
 * projectName 成都呐喊信息技术有限公司-智慧社区项目
 * description: 相关功能
 *
 * @author zzj
 * @since 2022-04-12 15:29:58
 */
@Mapper
public interface ComActAcidRecordDao extends BaseMapper<ComActAcidRecord> {
    /**
     * 分页查询
     * @param page
     * @param comActAcidRecordDTO
     * @return
     */
    IPage<ComActAcidRecordVO> pageList(Page page, @Param("commonPage") ComActAcidRecordDTO comActAcidRecordDTO);

    /**
     * 导出
     * @param comActAcidRecordDTO
     * @return
     */
    List<ComActAcidRecordExcelReturn> export(@Param("commonPage")ComActAcidRecordDTO comActAcidRecordDTO);

    /**
     * 导出
     * @param comActAcidRecordDTO
     * @return
     */
    List<ComActAcidRecordExcelReturn> exportNew(@Param("commonPage")ComActAcidRecordDTO comActAcidRecordDTO);

    /**
     * 导出
     * @param ids
     * @return
     */
    List<ComActAcidRecordExcelReturn> selectByIds(String ids);

    /**
     * 5项统计
     * @param localCity
     * @return
     */
    FiveCount fiveCount(String localCity);

    /**
     * 7项统计
     * @param date
     * @param localCity
     * @return
     */
    FiveCount fiveCountPlus(@Param("date") String date,@Param("localCity") String localCity,@Param("type") Integer type);

    /**
     * 统计查询
     * @param localCity
     * @param date
     * @return
     */
    ComAcidStaticVO areaStatics(@Param("localCity") String localCity, @Param("date") String date);

    /**
     * 出发地统计
     * @param departureCity
     * @param date
     * @return
     */
    Integer countryStatics(@Param("departureCity") String departureCity, @Param("date") String date,@Param("localCity")String localCity);

    /**
     * 7项统计
     * @param date
     * @param localCity
     * @return
     */
    FiveCount pushStatics(@Param("date") String date,@Param("localCity") String localCity);

    /**
     * 查询上下一条id
     * @param id
     * @return
     */
    ComActAcidRecordVO selectLastNext(@Param("id") Long id,@Param("localCity")String localCity);

    /**
     * 查询区级填报人数
     * @param date
     * @param localCity
     * @return
     */
    ComActAcidChartsVO selectAcidCount(@Param("date") String date,@Param("localCity") String localCity);

    /**
     * 查询区级风险人员，未填住址人员人数
     * @param date
     * @param localCity
     * @return
     */
    ComActAcidChartsVO selectDangerCount(@Param("date") String date,@Param("localCity") String localCity);

    /**
     * 查询区级风险人员处理情况
     * @param date
     * @param localCity
     * @return
     */
    List<ComActAcidChartsVO> selectCheck(@Param("date") String date,@Param("localCity") String localCity);

    /**
     * 批量核对防疫信息数据
     * @param batchCheckAcidRecordDTO
     * @return
     */
    void batchCheck(@Param("batchCheckAcidRecordDTO") BatchCheckAcidRecordDTO batchCheckAcidRecordDTO);

    /**
     * 统计所有红 黄 绿码
     * @return
     */
    List<ComActAcidColorChartsVO> selectColorMarkGroup();

    /**
     * 按月份统计红 黄 绿码 数量
     * @return
     */
    List<ComActAcidColorChartsVO> selectColorMarkGroupByMonth();

}