Package com.bytedesk.service.service_statistic.view

Class ViewAgentThreadStats

java.lang.Object
com.bytedesk.service.service_statistic.view.ViewAgentThreadStats
@Entity public class ViewAgentThreadStats extends Object
客服会话统计视图实体 Agent Thread Statistics View Entity 用途：映射 bytedesk_service_view_agent_thread_stats 视图 重要： 1. 使用 @Immutable 标注视图为只读 2. 不能进行 INSERT/UPDATE/DELETE 操作 3. 只能用于查询统计数据 示例用法： 
 // 查询某个客服今天的统计
 List stats = repository
     .findByAgentUidAndStatDate("agent123", LocalDate.now());

  • Field Details

    • id

      private ViewAgentThreadStats.ViewAgentThreadStatsId id
      使用复合主键：agent_uid + org_uid + stat_date + stat_hour

    • totalThreads

      private Integer totalThreads
      会话流转指标

    • acceptedThreads

      private Integer acceptedThreads

    • abandonedThreads

      private Integer abandonedThreads

    • invitedThreads

      private Integer invitedThreads

    • autoAssignedThreads

      private Integer autoAssignedThreads

    • manualAssignedThreads

      private Integer manualAssignedThreads

    • avgWaitTime

      private Double avgWaitTime
      时间指标（秒）

    • maxWaitTime

      private Integer maxWaitTime

    • minWaitTime

      private Integer minWaitTime

    • avgResponseTime

      private Double avgResponseTime

    • maxResponseTime

      private Integer maxResponseTime

    • avgFirstResponseTime

      private Double avgFirstResponseTime

    • avgConversationTime

      private Double avgConversationTime

    • totalAgentMessages

      private Long totalAgentMessages
      消息指标

    • totalVisitorMessages

      private Long totalVisitorMessages

    • avgMessagesPerThread

      private Double avgMessagesPerThread

    • responseWithin1Min

      private Integer responseWithin1Min
      响应时间分布

    • responseWithin5Min

      private Integer responseWithin5Min

    • responseOver5Min

      private Integer responseOver5Min

    • durationWithin5Min

      private Integer durationWithin5Min
      会话时长分布

    • durationWithin15Min

      private Integer durationWithin15Min

    • durationOver15Min

      private Integer durationOver15Min

    • firstSolvedCount

      private Integer firstSolvedCount
      首次解决指标

    • viewUpdatedAt

      private LocalDateTime viewUpdatedAt
      视图更新时间

  • Constructor Details

    • ViewAgentThreadStats

      public ViewAgentThreadStats()

  • Method Details

    • getAcceptanceRate

      public Double getAcceptanceRate()
      计算接入率

    • getFirstSolveRate

      public Double getFirstSolveRate()
      计算首次解决率

    • getAvgTotalMessagesPerThread

      public Double getAvgTotalMessagesPerThread()
      计算平均每会话消息数