Subversion Repositories SmartDukaan

Rev

Rev 37729 | Rev 37749 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 37729 Rev 37737
Line 136... Line 136...
136 
    java.util.List<Object[]> ageingByDerivedStage(LocalDateTime olderThan);
 136 
    java.util.List<Object[]> ageingByDerivedStage(LocalDateTime olderThan);
137 
 
 137 
 
138 
    /** Single row of conditional-sum attention counts (see impl) for the optional region. */
 138 
    /** Single row of conditional-sum attention counts (see impl) for the optional region. */
139 
    Object[] attentionCounts(Integer regionId, LocalDateTime now, LocalDateTime nowPlus1h);
 139 
    Object[] attentionCounts(Integer regionId, LocalDateTime now, LocalDateTime nowPlus1h);
140 
 
 140 
 
- 
 
 141 
    /**
- 
 
 142 
     * Per-owner lead counters for the live board: {@code [authId, assigned, slaBreached]}.
- 
 
 143 
     * Breached = open, past its first-contact deadline, never contacted.
- 
 
 144 
     */
- 
 
 145 
    List<Object[]> selectAgentLeadCounters(LocalDateTime now);
- 
 
 146 
 
141 
    /** Lead ids for a drill-down bucket (STAGE / ATTENTION / REGION), newest first, capped at {@code limit}. */
 147 
    /** Lead ids for a drill-down bucket (STAGE / ATTENTION / REGION), newest first, capped at {@code limit}. */
142 
    java.util.List<Integer> selectLeadIdsForBucket(String bucketType, String bucketKey, Integer regionId,
 148 
    java.util.List<Integer> selectLeadIdsForBucket(String bucketType, String bucketKey, Integer regionId,
143 
                                                   LocalDateTime now, LocalDateTime nowPlus1h,
 149 
                                                   LocalDateTime now, LocalDateTime nowPlus1h,
144 
                                                   LocalDateTime from, LocalDateTime to, int limit);
 150 
                                                   LocalDateTime from, LocalDateTime to, int limit);
145 
}
 151 
}