From c87e44fb1a97619711d84eecba0136f1ec88b95c Mon Sep 17 00:00:00 2001 From: 张天森 <1292933220@qq.com> Date: 星期四, 29 九月 2022 10:27:06 +0800 Subject: [PATCH] update --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 50 insertions(+), 0 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java index 18477e2..3e94911 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java @@ -3,10 +3,17 @@ 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.sanshuo.IndexDateDTO; +import com.panzhihua.common.model.vos.IndexDataVO; +import com.panzhihua.common.model.vos.sanshuo.ComEventCalculateVO; +import com.panzhihua.common.model.vos.sanshuo.EventRateVO; +import com.panzhihua.common.model.vos.sanshuo.IndexDateVO; +import com.panzhihua.common.model.vos.sanshuo.MediateTypeVO; import com.panzhihua.service_community.entity.ComEvent; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; +import java.util.Date; import java.util.List; /** * 三说会堂事件表Mapper @@ -36,4 +43,47 @@ * @date 2022-09-07 11:23:51 */ List<ComEvent> listByComEvent(@Param("comEvent") ComEvent comEvent); + + List<ComEventCalculateVO> calculate(); + + /** + * 大屏事件统计 + * @param indexDateDTO + * @return 处理结果 + * @author zhangtiansen + * */ + IndexDateVO dateAnalysis(@Param("dto") IndexDateDTO indexDateDTO,@Param("beginDate") Date beginDate, @Param("endDate")Date endDate); + + + /** + * 大屏事件统计-月新增 + * @param beginDate 开始时间 + * @param endDate 结束时间 + * @author zhangtiansen + * */ + Integer dateAnalysisY(@Param("beginDate") Date beginDate, @Param("endDate")Date endDate, @Param("dto") IndexDateDTO indexDateDTO); + + /** + * 大屏事件统计-月办结 + * @param beginDate 开始时间 + * @param endDate 结束时间 + * @author zhangtiansen + * */ + Integer dateAnalysisYTwo(@Param("beginDate")Date beginDate,@Param("endDate")Date endDate,@Param("dto") IndexDateDTO indexDateDTO); + + /** + * 大屏事件级别统计 + * */ + List<EventRateVO> eventRate(); + + /** + * 大屏统计-专家级别占比 + * */ + List<EventRateVO> expertRate(); + + /** + * 大屏统计-事件类型占比 + * */ + List<EventRateVO> mediateTypeRate(); + } -- Gitblit v1.7.1