From b30e1a48f2bc5f65a0efd2e69e090fed2d7a627c Mon Sep 17 00:00:00 2001
From: yanghui <2536613402@qq.com>
Date: 星期四, 17 十一月 2022 15:56:43 +0800
Subject: [PATCH] #feat 订单退款和查询
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActReserveMapper.java | 118 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 118 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActReserveMapper.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActReserveMapper.java
index 9086176..c6c3e47 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActReserveMapper.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActReserveMapper.java
@@ -1,8 +1,24 @@
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.reserve.ComActReserveMakeStatisticsDTO;
+import com.panzhihua.common.model.dtos.community.reserve.PageReserveAdminDTO;
+import com.panzhihua.common.model.vos.community.bigscreen.IndexReserve;
+import com.panzhihua.common.model.vos.community.bigscreen.IndexReserveSub;
+import com.panzhihua.common.model.vos.community.reserve.ComActReserveListAdminVO;
+import com.panzhihua.common.model.vos.community.reserve.ComActReserveMakeLeftStatisticsAdminVO;
+import com.panzhihua.common.model.vos.community.reserve.ComActReserveMakeRightStatisticsAdminVO;
+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.common.model.vos.community.ComActReserveIndexVo;
import com.panzhihua.service_community.model.dos.ComActReserveDO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
/**
* @auther lyq
@@ -11,5 +27,107 @@
*/
@Mapper
public interface ComActReserveMapper extends BaseMapper<ComActReserveDO> {
+ /**
+ * 查询预约登记首页banner
+ * @param communityId
+ * @return 预约登记首页banner列表
+ */
+ List<ComActReserveIndexVo> indexBanner(Long communityId);
+ /**
+ * 查询预约登记应用列表
+ * @param communityId
+ * @return 预约登记应用列表
+ */
+ List<ComActReserveIndexVo> indexApplication(Long communityId);
+ /**
+ * 社区后台-分页查询预约登记列表
+ * @param pageReserveDTO 请求参数
+ * @return 预约登记列表
+ */
+ IPage<ComActReserveListAdminVO> pageReserveAdmin(Page page, @Param("pageReserveDTO") PageReserveAdminDTO pageReserveDTO);
+
+ /**
+ * 根据预约登记id删除预约登记原有题目以及题目选项
+ * @param reserveId 预约登记id
+ */
+ void deleteReserveSubAll(@Param("reserveId") Long reserveId);
+
+ /**
+ * 社区后台-根据社区id查询预约统计汇总左边数据
+ * @param communityId 社区id
+ * @return 预约统计汇总左边数据
+ */
+ List<ComActReserveMakeLeftStatisticsAdminVO> getReserveMakeLeftStatistics(@Param("communityId") Long communityId);
+
+ /**
+ * 社区后台-查询预约统计汇总右边数据
+ * @param makeStatisticsDTO 请求参数
+ * @return 预约统计汇总右边数据
+ */
+ List<ComActReserveMakeRightStatisticsAdminVO> getReserveMakeRightStatistics(@Param("makeStatisticsDTO") ComActReserveMakeStatisticsDTO makeStatisticsDTO);
+
+ /**
+ * 社区后台-根据社区id 查询开始时间到结束时间预约成功数量
+ * @param communityId 社区id
+ * @param startTime 开始时间
+ * @param endTime 结束时间
+ * @return 预约成功数量
+ */
+ Integer getReserveRecordCount(@Param("communityId") Long communityId,@Param("startTime") String startTime,@Param("endTime") String endTime);
+
+ /**
+ * 查询社区所有预约信息列表
+ * @param communityId 社区id
+ * @return 预约信息列表
+ */
+ List<ComActReserveListAdminVO> listReserveAdmin(@Param("communityId") Long communityId);
+
+ /**
+ * 取消预约时,预约登记参加人数减少
+ * @param reserveId 预约登记id
+ */
+ void addReserveCountById(@Param("reserveId") Long reserveId);
+
+ /**
+ * 小程序查询所有进行中的预约登记
+ * @param communityId 社区id
+ * @return 社区所有进行中的预约登记列表
+ */
+ List<ComActReserveIndexVo> getReserveIndexList(@Param("communityId") Long communityId);
+
+ /**
+ * 首页大屏返攀登记数据统计总数
+ * @param communityId
+ * @return
+ */
+ Integer indexBackReserve(@Param("communityId") Long communityId);
+
+ /**
+ * 首页大屏居家隔离数据统计总数
+ * @param communityId
+ * @return
+ */
+ Integer indexHomeQuarantine(@Param("communityId") Long communityId);
+
+ /**
+ * 首页大屏返攀登记数据统计选项
+ * @param communityId
+ * @return
+ */
+ List<IndexReserveSub> indexBackReserveSub(@Param("communityId") Long communityId);
+
+ /**
+ * 首页大屏居家隔离数据统计选项
+ * @param communityId
+ * @return
+ */
+ List<IndexReserveSub> IndexHomeQuarantineSub(@Param("communityId") Long communityId);
+
+ /**
+ * reserveId查询社区电话
+ * @param reserveId
+ * @return
+ */
+ String selectCommunityPhoneByReserveId(@Param("reserveId")Long reserveId);
}
--
Gitblit v1.7.1