Store Audit Tracking System

An offline-first PWA that tracks 12 inspection types across 9 stores, built as the digital counterpart of an Excel-based monthly activity process. All frequency/period/status logic runs through a unit-tested 'target engine' of pure functions (monthly types, weekly count slots, bi-monthly and quarterly periods). It separates auditor and admin roles at the database level via Supabase RLS, versions frequency changes with valid_from, and preserves deactivated stores/types as 'corporate memory' through soft deletes. Offline, records are queued in localStorage and synced with client_id idempotency once back online. It includes paper-faithful Excel export/import and ApexCharts dashboards.