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();
|
|
}
|
