RestroAI POS SaaS Phase 10
Reports + AI

Reports And AI Intelligence Pro

Phase 10 adds tenant-local reporting, durable snapshots, JSON/CSV exports, operational anomaly checks, and optional evidence-backed AI insights.

Reports

  • /r/{tenant}/reports opens the Visual Intelligence Studio with animated KPIs, comparison chips, chart widgets, heatmaps, anomaly rails, snapshot status, exports, saved views, and report links.
  • /r/{tenant}/reports/studio is an explicit studio alias; /reports/widgets, /reports/visual-feed, /reports/drilldowns, and /reports/heatmaps/tables provide service-generated JSON payloads.
  • Detail pages cover sales, tax, stock, kitchen, staff, branches, customers, profit leakage, menu engineering, and anomalies.
  • Snapshots persist report metrics, chart payloads, filters, findings, comparison data, visual widget payloads, and heatmap payloads in report_snapshots.
  • Exports create auditable report_exports rows for JSON and CSV-first workflows.
  • Saved views, user widget density preferences, and drilldown audits are stored in report_saved_views, report_widget_preferences, and report_drilldown_events.

Graphs, Graphics, And Motion

  • Local Chart.js renders revenue trend, sales mix, tender stack, tax bars, staff leaderboard, menu quadrant, and customer segment charts.
  • Blade/CSS widgets render table revenue heatmaps, kitchen delay lanes, stock risk timelines, profit leakage flow, anomaly rails, AI credit meters, and evidence drawers.
  • Animations include KPI count-up, chart entrance, heatmap fade, anomaly pulse, skeleton shimmer, fullscreen studio mode, and slide-in drilldown drawers.
  • Motion respects prefers-reduced-motion; no CDN or new frontend dependency is required.

AI Intelligence

  • AI is disabled by default and requires SaaS ai_credits, tenant AI enablement, and an env-configured provider.
  • Supported insight types are daily briefing, anomalies, purchase suggestions, menu engineering, customer segments, and kitchen delay.
  • Every AI call writes to ai_usage_logs with feature key, target snapshot, prompt/input hash, credit cost, provider status, and error metadata.
  • Resolve, dismiss, export, manager note, and convert-to-task actions are audited in ai_insight_actions.
  • Insights cite stored evidence payloads; recommendations are advisory and never change POS, menu, inventory, or staff records automatically.

Commands

php artisan reports:snapshots:build --tenant=* --range=yesterday
php artisan ai:insights:generate --tenant=* --type=daily_briefing --range=yesterday

Testing

  • Use HTTP fakes for OpenAI, Anthropic, and Gemini-style provider calls.
  • Run php artisan test, php artisan route:list --path='r/', and npm run build.
  • Verify pages use shared headers, table patterns, local Chart.js payloads, data-swal-submit, and appToast results.