a5fcecb3f6
This PR adds a Captain Assistant **Overview** page to show some KPI metrics (conversations handled, auto-resolution, handoff, hours saved, reopen-after-resolve, conversation depth) with trend deltas vs the previous window, a real knowledge card, and a lazily-loaded, cached LLM welcome summary. ### Highlights - **Two contextual banners** on the overview: - **Inbox banner** — prompts the user to connect an inbox when the assistant has none, so it can actually do work. - **Coverage banner** — warns when FAQ coverage is below 85% with more than 100 responses pending review, linking straight to the pending queue. Dismissal persists per-assistant for 24h via localStorage. - **Batched stats builder** (`Captain::AssistantStatsBuilder`) computes both windows in single FILTER-aggregated scans to cut round trips, behind new `stats`/`summary` endpoints. - **Cards included but intentionally left dummy / not rendered yet:** `ResponseQualityCard` (flagged responses) and `CreditUsageCard` (credit usage + daily chart). Credits are an account-wide counter with no per-assistant or daily history, so there is no real data to back them yet; they ship in the codebase but are not wired into the page. ### Index migration - Replaces `index_messages_on_sender_type_and_sender_id` with `index_messages_on_sender_and_created` `(sender_type, sender_id, created_at)`. - **Why it helps:** the per-assistant windowed lookups filter `sender_*` *and* a `created_at` range. The old 2-column index matched every lifetime row for the assistant and filtered the time slice at the heap (~89% of rows discarded); adding `created_at` as a range column lets Postgres scan only the window, and fixes the row-count estimate so the planner picks a hash join over a nested loop on `reporting_events`. - **Why dropping the old index is safe:** the new index is a left-prefix superset `(sender_type, sender_id, ...)`, so every query the old one served is still served. No code references it by name, and dropping it keeps write amplification on `messages` neutral. Built/dropped with `CONCURRENTLY` and `if_not_exists`/`if_exists` guards. ## Preview <img width="2572" height="1754" alt="CleanShot 2026-06-29 at 22 38 51@2x" src="https://github.com/user-attachments/assets/3798d09e-7850-48e4-b2cd-508533f15cea" /> ## Banners #### Inbox connect alert <img width="2178" height="612" alt="CleanShot 2026-06-30 at 14 26 55@2x" src="https://github.com/user-attachments/assets/373c371c-bb7d-4291-a0f9-620673078302" /> #### Coverage alert <img width="2178" height="612" alt="CleanShot 2026-06-30 at 14 25 41@2x" src="https://github.com/user-attachments/assets/e12d6308-11b6-4ba2-88a2-8a3077dd3e8f" /> --------- Co-authored-by: Sivin Varghese <64252451+iamsivin@users.noreply.github.com>
97 lines
2.8 KiB
Vue
97 lines
2.8 KiB
Vue
<script setup>
|
|
import { computed, ref, watch } from 'vue';
|
|
import { useRoute, useRouter } from 'vue-router';
|
|
import { LocalStorage } from 'shared/helpers/localStorage';
|
|
|
|
const props = defineProps({
|
|
knowledge: {
|
|
type: Object,
|
|
default: () => ({ approved: 0, pending: 0, documents: 0, coverage: 0 }),
|
|
},
|
|
});
|
|
|
|
const route = useRoute();
|
|
const router = useRouter();
|
|
|
|
// Dismissal is remembered per assistant for 24 hours (setFlag's default expiry).
|
|
const DISMISS_STORE = 'captain_overview_coverage_banner';
|
|
|
|
const accountId = computed(() => route.params.accountId);
|
|
const assistantId = computed(() => route.params.assistantId);
|
|
|
|
// Re-read the stored flag whenever the assistant changes, otherwise the banner
|
|
// would keep the first assistant's dismissed state after switching.
|
|
const dismissed = ref(false);
|
|
|
|
watch(
|
|
[accountId, assistantId],
|
|
([account, assistant]) => {
|
|
dismissed.value = LocalStorage.getFlag(DISMISS_STORE, account, assistant);
|
|
},
|
|
{ immediate: true }
|
|
);
|
|
|
|
// Thin coverage paired with a large review backlog: approving the pending FAQs
|
|
// is the quickest lever to lift auto-resolution, so nudge the team to act.
|
|
const COVERAGE_THRESHOLD = 85;
|
|
const PENDING_THRESHOLD = 100;
|
|
|
|
const showBanner = computed(
|
|
() =>
|
|
!dismissed.value &&
|
|
(props.knowledge?.coverage ?? 0) < COVERAGE_THRESHOLD &&
|
|
(props.knowledge?.pending ?? 0) > PENDING_THRESHOLD
|
|
);
|
|
|
|
const dismiss = () => {
|
|
LocalStorage.setFlag(DISMISS_STORE, accountId.value, assistantId.value);
|
|
dismissed.value = true;
|
|
};
|
|
|
|
const goToPending = () => {
|
|
router.push({
|
|
name: 'captain_assistants_responses_pending',
|
|
params: {
|
|
accountId: route.params.accountId,
|
|
assistantId: route.params.assistantId,
|
|
},
|
|
});
|
|
};
|
|
</script>
|
|
|
|
<template>
|
|
<div
|
|
v-if="showBanner"
|
|
class="flex items-center justify-between gap-3 px-3 py-2 text-sm border rounded-xl bg-n-amber-3 border-n-amber-4 text-n-amber-11"
|
|
>
|
|
<div class="flex items-center gap-2 min-w-0">
|
|
<span class="shrink-0 i-lucide-triangle-alert size-4" />
|
|
<span class="truncate">
|
|
{{
|
|
$t('CAPTAIN.OVERVIEW.COVERAGE_BANNER.TEXT', {
|
|
count: knowledge.pending,
|
|
coverage: knowledge.coverage,
|
|
})
|
|
}}
|
|
</span>
|
|
</div>
|
|
<div class="flex items-center gap-1 shrink-0">
|
|
<button
|
|
type="button"
|
|
class="px-3 py-1 rounded-lg bg-n-amber-4 hover:bg-n-amber-5"
|
|
@click="goToPending"
|
|
>
|
|
{{ $t('CAPTAIN.OVERVIEW.COVERAGE_BANNER.ACTION') }}
|
|
</button>
|
|
<button
|
|
type="button"
|
|
class="grid rounded-lg size-7 place-content-center hover:bg-n-amber-4"
|
|
:aria-label="$t('CAPTAIN.OVERVIEW.COVERAGE_BANNER.DISMISS')"
|
|
@click="dismiss"
|
|
>
|
|
<span class="i-lucide-x size-4" />
|
|
</button>
|
|
</div>
|
|
</div>
|
|
</template>
|