Commit Graph

15 Commits

Author SHA1 Message Date
Abhinav Raut 7c9fac4f4a show idle agents as online instead of away
Idle agents still get auto-assigned tickets. Only the manual away
statuses skip them. The amber away dot made other agents think the
idle person would not get tickets. The agent picker, widget header
and the agents report now treat idle as online.
2026-09-19 02:26:37 +05:30
Abhinav Raut 85a404c8a0 count only sent outgoing messages in the overview volume 2026-08-22 01:31:57 +05:30
Abhinav Raut cccd2dec25 exclude private notes from the overview message volume counts 2026-08-22 01:23:57 +05:30
Abhinav Raut beb8aeafff update agents offline count to include 'away' status 2026-08-21 23:15:05 +05:30
Abhinav Raut 9626d512d8 count only away_manual agents as away 2026-08-21 05:10:34 +05:30
Abhinav Raut 3218f79169 fix away agent count, index resolved_at and clamp report days 2026-08-21 04:54:49 +05:30
Abhinav Raut 51f7bace9e fix and speed up the report overview queries
The resolved conversations chart filtered on created_at but grouped by resolved_at, so anything created before the window never showed up, and the tag list dropped tags whose conversations were all older than the window. Dropped the message volume COUNT(DISTINCT) and three of the four users table scans, and added the created_at indexes these queries need. The Pending tile is now labelled Awaiting First Reply since it counts conversations with no agent reply yet.
2026-08-21 04:19:03 +05:30
Abhinav Raut 02906ef5ba clear sla deadlines on policy delete and stop double counting next response 2026-08-21 02:21:06 +05:30
Abhinav Raut 6fa5d66b6b recompute conversation SLA deadline when next response is settled
Marking a next-response SLA event met or breached never updated
conversations.next_sla_deadline_at, so the conversation kept sorting as if
the reply was still due. Reopening a resolved conversation had the same
problem in reverse: the column stays NULL even though its deadlines are
live again.
2026-08-21 02:01:04 +05:30
Abhinav Raut 7816bd1dba filter applied slas by date range inside the latest-row cte 2026-08-19 16:24:54 +05:30
Abhinav Raut 976307d97b count only each conversation's latest applied sla in overview report 2026-08-19 16:23:21 +05:30
Abhinav Raut aa9e4cdae2 feat: add conversation status categories and update related logic.
- Introduced a new category field for conversation statuses to classify them as 'open', 'waiting', or 'resolved'. Which allows max assignment limits in team to work with custom statuses as well.
2026-04-21 16:55:09 +05:30
Abhinav Raut c62294aaef feat: Make convo panels resizable
- add new report/overview metrics
2025-12-26 04:52:30 +05:30
Abhinav Raut e567acbe59 fix(sql): overview report for days = 0 i.e. todays data 2025-06-08 01:24:01 +05:30
Abhinav Raut d532a99771 feat: new package report, move exisiting report code from conversations pkg to report package
- new sla performance overview cards.
2025-06-06 02:07:19 +05:30