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.ComActAcidRecordDTO;
|
import com.panzhihua.common.model.dtos.property.CommonPage;
|
import com.panzhihua.common.model.vos.community.acid.ComAcidAreaVO;
|
import com.panzhihua.common.model.vos.community.acid.ComAcidStaticVO;
|
import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordExcelVO;
|
import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO;
|
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 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<ComActAcidRecordExcelVO> export(@Param("commonPage")ComActAcidRecordDTO comActAcidRecordDTO);
|
|
/**
|
* 5项统计
|
* @param localCity
|
* @return
|
*/
|
FiveCount fiveCount(String localCity);
|
|
/**
|
* 7项统计
|
* @param date
|
* @return
|
*/
|
FiveCount fiveCountPlus(String date);
|
|
/**
|
* 统计查询
|
* @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);
|
}
|
