Ayuda y Soporte universal feedback button

Sub-tickets

Questions

Activity

• system created · 2026-05-18
  wi cli
• system comment · 2026-05-18
  Scope (per Elazar -36578, P1 urgent). Universal 'Ayuda y Soporte' button on every authenticated page → modal/dialog with ticketTitle + ticketBody textareas + optional severity → server action createUserTicket() that: 1. INSERTs into existing tickets table (reportedRoute=window.location.pathname, createdByUserId=session.id, statusValue='open', categoryValue='user-feedback' or similar). 2. Calls sendOperatorAlertEmail (or new sendTicketAlertEmail) to elazarpimentel@gmail.com with ticket ID + title + URL + reporter. 3. UI: place button in sidebar footer or page-header utility area; modal uses shadcn Dialog + Textarea + Input + Select severity. Polling/alerting layer (out of scope for code lane; spec for nw-whey-cc + db-mars-cc): 4. nw-whey-cc cron tick (extend existing 20-min nightwatch) reads SELECT COUNT(*) FROM tickets WHERE deletedAt IS NULL AND statusValue='open'; if >0 DMs pm-mars-cc with ticket IDs. 5. systemSettings.key='hasOpenTickets' boolean flag updated on ticket insert/close trigger OR computed live in the cron. db-mars-cc per-session-tick: if hasOpenTickets=true, run the SELECT + DM pm-mars-cc the list. Existing infra reused (no schema change needed): - tickets table already has reportedRoute, statusValue, createdByUserId, severityValue, categoryValue - src/app/(protected)/administrar/tickets/ already exists for admin view - mailer.ts has typed helpers; add sendTicketAlertEmail() variant - vercel.json cron supports new entry if app-side poll wanted instead of nightwatch Pieces: (a) coder = button + modal + server action + mailer helper; (b) db-mars-cc = optional hasOpenTickets systemSettings seed + tick-time SELECT helper; (c) nightwatch maintainer (whey) = 20-min poll alerter. Sequence: (a) lands first standalone (button is independently useful); (b) + (c) layered after. Decisions needed before dispatch: 1. Category list (one 'user-feedback' or sub-categories Visual/Bug/Pregunta/Otro)? 2. Severity: optional or required? Default value? 3. Button placement (sidebar footer vs. floating fab vs. page-header)? 4. Alert email recipient: only Elazar or copy PM?
• system canceled · 2026-05-18
  dup of WI#431 (PM-owned with full design citations -36593/-36627). coderhelp-mars-cc-36619 acknowledged collision; reuse-existing-tickets-table considered + rejected (admin↔admin boundary, db -36604)