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.OperationDetailDTO;
|
import com.panzhihua.common.model.dtos.community.reserve.ComActReserveRegisterStatisticsDTO;
|
import com.panzhihua.common.model.dtos.community.reserve.PageReserveMakeAdminDTO;
|
import com.panzhihua.common.model.dtos.community.reserve.PageReserveMakeHandleAdminDTO;
|
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStaticsReserve;
|
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStaticsReserveMonth;
|
import com.panzhihua.common.model.vos.community.reserve.*;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.panzhihua.common.model.dtos.community.PageUserReserveDTO;
|
import com.panzhihua.service_community.model.dos.ComActReserveDO;
|
import com.panzhihua.service_community.model.dos.ComActReserveRecordDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* @auther lyq
|
* @create 2021-08-23 10:33:53
|
* @describe 预约登记记录表mapper类
|
*/
|
@Mapper
|
public interface ComActReserveRecordMapper extends BaseMapper<ComActReserveRecordDO> {
|
IPage<ComActReserveAppletsVO> pageReserveList(Page page, @Param("pageUserReserveDTO") PageUserReserveDTO pageUserReserveDTO);
|
|
/**
|
* 社区后台-根据预约id查询预约明细
|
* @param pageMakeDTO 请求参数
|
* @return 预约明细
|
*/
|
IPage<ComActReserveMakeListAdminVO> pageMakeAdmin(Page page, @Param("pageMakeDTO") PageReserveMakeAdminDTO pageMakeDTO);
|
|
/**
|
* 根据预约记录id查询预约记录详细信息
|
* @param reserveRecordId 预约记录id
|
* @return 预约记录详细信息
|
*/
|
ComActReserveMakeDetailAdminVO getMakeDetailAdmin(@Param("reserveRecordId") Long reserveRecordId);
|
|
/**
|
* 查询预约记录id集合中是否存在未预约成功的记录
|
* @param ids 预约记录id集合
|
* @return 未预约成功记录的数量
|
*/
|
Integer getReserveStatusById(@Param("ids") List<Long> ids);
|
|
/**
|
* 修改预约记录id集合的预约状态为已取消
|
* @param ids 预约记录id集合
|
* @return 修改结果
|
*/
|
Integer editReserveStatusById(@Param("ids") List<Long> ids);
|
|
/**
|
* 预约明细导出数据查询
|
* @param pageMakeDTO 请求参数
|
* @return 预约明细数据
|
*/
|
List<ComActReserveMakeListAdminVO> exportMakeAdmin(@Param("pageMakeDTO") PageReserveMakeAdminDTO pageMakeDTO);
|
|
/**
|
* 分页查询登记统计汇总
|
* @param registerStatisticsDTO 请求参数
|
* @return 登记统计汇总
|
*/
|
IPage<ComActReserveRegisterStatisticsAdminVO> registerStatisticsAdmin(Page page, @Param("registerStatisticsDTO") ComActReserveRegisterStatisticsDTO registerStatisticsDTO);
|
|
/**
|
* 导出登记统计汇总
|
* @param registerStatisticsDTO 请求参数
|
* @return 登记统计汇总
|
*/
|
List<ComActReserveRegisterStatisticsAdminVO> registerStatisticsExportAdmin(@Param("registerStatisticsDTO") ComActReserveRegisterStatisticsDTO registerStatisticsDTO);
|
|
/**
|
* 分页查询预约处理列表
|
* @param pageMakeHandleDTO 请求参数
|
* @return 预约处理列表
|
*/
|
IPage<ComActReserveMakeHandleListAdminVO> pageMakeHandleAdmin(Page page, @Param("pageMakeHandleDTO") PageReserveMakeHandleAdminDTO pageMakeHandleDTO);
|
|
/**
|
* 查询指定预约记录是否存在不是待处理状态的数据
|
* @param ids 预约记录id集合
|
* @return 不是待处理状态数据条数
|
*/
|
Integer getReserveListCountByIds(@Param("ids")List<Long> ids);
|
|
/**
|
* 导出预约处理列表数据查询
|
* @param pageMakeHandleDTO 请求参数
|
* @return 预约处理列表
|
*/
|
List<ComActReserveMakeHandleListAdminVO> exportMakeHandleAdmin(@Param("pageMakeHandleDTO") PageReserveMakeHandleAdminDTO pageMakeHandleDTO);
|
|
ComActReserveRegisterDetailedVO getRegisterDetailedByRecordId(@Param("reserveRecordId") Long reserveRecordId);
|
|
/**
|
* 根据reserveRecordId查询操作记录
|
* @param operationDetailDTO
|
* @return
|
*/
|
List<ComOperationListVO> queryAll(OperationDetailDTO operationDetailDTO);
|
|
/**
|
* 大屏数据统计
|
* @param communityId
|
* @return
|
*/
|
BigScreenStaticsReserve biggestScreen(@Param("communityId") Long communityId);
|
|
/**
|
* 大屏折线图
|
* @param communityId
|
* @param date
|
* @return
|
*/
|
BigScreenStaticsReserveMonth biggestScreenMonth(@Param("communityId")Long communityId,@Param("date")String date,@Param("year")String year);
|
}
|
