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