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