From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001 From: liujie <1793218484@qq.com> Date: 星期一, 09 六月 2025 11:54:00 +0800 Subject: [PATCH] 6.9新增登录失败冻结逻辑 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventMapper.java | 89 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 88 insertions(+), 1 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..b417fd3 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 @@ -27,6 +34,13 @@ * @date 2022-09-07 11:23:51 */ IPage<ComEvent> pageByComEvent(@Param("comEvent") ComEvent comEvent, Page pagination); + IPage<ComEvent> pageByComEventExpert(@Param("eventIds") List<Long> eventIds,@Param("comEvent") ComEvent comEvent, Page pagination); + /** + * + * 获取专家名下的所有事件id + * @param expertId 专家id + * */ + List<Long> listEventIds(Long expertId); /** * description 三说会堂事件表列表数据 * @@ -35,5 +49,78 @@ * @author manailin * @date 2022-09-07 11:23:51 */ - List<ComEvent> listByComEvent(@Param("comEvent") ComEvent comEvent); + List<ComEvent> listByComEvent(@Param("comEvent") ComEvent comEvent,@Param("requestUserId") Long requestUserId); + + List<ComEventCalculateVO> calculate(@Param("comEvent") ComEvent comEvent); + + int caculateSum(@Param("comEvent")ComEvent comEvent); + + /** + * 大屏事件统计 + * @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(); + + /** + * 获取用户头像 + * */ + String getUserAvatar(Long userId); + + /** + * 添加事件-专家对应记录 + * @param status 流转状态( + * 0创建时分配,只有一条记录 + * 1上报后重新分配 + * 2拒绝后重新分配 + * ) + * */ + void insertEventAndExpertRecord(@Param("eventId") Long eventId, @Param("expertId") Long experId,@Param("status")Integer status); + + void updateLog(@Param("eventId") Long id, @Param("expertId") Long specialistId); + + /** + * 社区专家受理数量 + * */ + int expertSolveCountCommunity(); + + /** + * 行业分中心专家受理数量计算 + * */ + int expertSolveCountCenter(); + + } -- Gitblit v1.7.1