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 | 66 ++++++++++++++++++++++++++++++-- 1 files changed, 61 insertions(+), 5 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 a3a8231..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 @@ -6,11 +6,14 @@ 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 @@ -31,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 三说会堂事件表列表数据 * @@ -39,9 +49,11 @@ * @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(); + List<ComEventCalculateVO> calculate(@Param("comEvent") ComEvent comEvent); + + int caculateSum(@Param("comEvent")ComEvent comEvent); /** * 大屏事件统计 @@ -49,7 +61,7 @@ * @return 处理结果 * @author zhangtiansen * */ - IndexDateVO dateAnalysis(@Param("dto") IndexDateDTO indexDateDTO); + IndexDateVO dateAnalysis(@Param("dto") IndexDateDTO indexDateDTO,@Param("beginDate") Date beginDate, @Param("endDate")Date endDate); /** @@ -58,7 +70,7 @@ * @param endDate 结束时间 * @author zhangtiansen * */ - Integer dateAnalysisY(@Param("beginDate")String beginDate,@Param("endDate")String endDate); + Integer dateAnalysisY(@Param("beginDate") Date beginDate, @Param("endDate")Date endDate, @Param("dto") IndexDateDTO indexDateDTO); /** * 大屏事件统计-月办结 @@ -66,5 +78,49 @@ * @param endDate 结束时间 * @author zhangtiansen * */ - Integer dateAnalysisYTwo(@Param("beginDate")String beginDate,@Param("endDate")String endDate); + 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