Without this, invoices stay in 'draft' and don't appear in the payment
wizard (which only queries sent/partially_paid/overdue).
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- ProgramForm defaults: billing_cycle='monthly', billing_day=1
- PricingService.findBasePrice now resolves correct base price by
  participant.membership_type (member → member price, else → non_member price)
- Resolution order: branch+membership > branch+any > global+membership > global
- NULL membership_type defaults to non_member pricing
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Big red alert at the top of the dashboard showing participants who haven't
renewed their subscription. Each row links directly to the payment wizard
with participant pre-selected, auto-generating the renewal invoice.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Search now shows ALL active participants (not just those with existing invoices)
- Auto-generates renewal invoices on-the-fly when participant has overdue billing
- Radio buttons use wire:model.live for immediate state update (fixes Next button)
- Upcoming renewals section shows "Generate Invoice" button as fallback
- Next button always visible (disabled until invoice selected)
- Advances next_billing_date after generating renewal invoice
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Soft-deleted participants return null from the relationship, causing
route('participants.show', null) to throw a missing parameter exception.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- TrainerShow: period_start→date, total_amount→amount, status 'pending'→'active'
- trainer-show.blade: period_start→date, sessions_count→quantity, total_amount→amount
- AttendanceResource: actual_check_in→check_in_at, date→session.session_date
- InvoiceResource: invoice_number→number, balance_due→due_amount, remove description_ar
- ReportService: paid_amount→status check, cancellation_reason→withdrawal_reason,
  wallet status→is_active, remove frozen_amount
- SendDailySummary: Organization→Academy, is_active→status='active'
- SendParentWeeklyReport: fix morph type + join through session_date
- DeactivateExpiredEnrollments: expiry_date→end_date
- CertificateController + NotifyGuardianOfAbsence + RemoveAttendanceRecords:
  morph type 'participant'→Participant::class
- SendInvoiceCancelledNotification: cancellation_reason→notes
- DeleteParticipant: remove phantom refunded_amount reference
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The grid now also displays training_schedules that have no matching
space_reservation (orphan schedules). These appear on the grid so users
can see and cancel them. The cancelReservation method now accepts both
reservationId and scheduleId to handle both cases.

Also added cancel button column to the FacilityShow reservations tab.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Users can now cancel reservations directly from the reservations tab
inside the facility show page via a cancel button with confirmation.
Previously reservations were display-only with no way to modify them.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The enrollments table has no cancelled_at column — only update status.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The trait was appending _del_YYMMDDHHMMSS (16 chars) without respecting
column length limits, causing varchar(20) overflow on employee_number.
Now uses shorter _d{id} suffix and truncates the original value to fit
within the declared max length per field.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Employee delete: removed from list table (was broken due to row click
propagation), added as red button inside EmployeeShow with proper
wire:confirm and redirect after success.

Participant delete: removed from list table, added as red button inside
ParticipantShow that opens the DeleteParticipant modal with per-invoice
refund options. Redirects to list after deletion.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Super admin/academy owner can soft-delete participants from the list.
A modal shows all paid invoices and allows refunding each one individually
before confirming deletion. Cascading: cancels active enrollments, removes
future attendance records, cancels unpaid invoices, sets status to withdrawn.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Transfer wizard:
- Can now transfer between different programs (not just same-program)
- Program dropdown in step 2 to pick destination program
- Calculates price difference via PricingService
- If new program costs more, shows the difference and creates an invoice
- Success screen links to the created invoice

Collect payment wizard:
- Shows upcoming installments (from payment plans) with exact due dates
- Shows upcoming monthly renewal dates from enrollments
- Sorted by due_date so the most urgent appears first
- Invoices now sorted ASC by due_date (urgent first)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Siblings in the same family share a club membership number. The unique
constraint on (branch_id, membership_id) is dropped. When a receptionist
or admin enters a membership_id that already exists, a confirmation prompt
shows the existing participant's full name so staff can verify it's a
sibling before proceeding. Both the wizard and participant form are updated.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The delete method had an unused EmployeeService parameter that could
cause Livewire method resolution issues. Removed it, and added proper
cascading: deactivate trainer record, unlink+soft-delete user account,
then soft-delete the employee — all in one transaction.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Add uniqueness check for membership_id per branch in step 1 validation,
preventing the DB unique constraint violation when a membership_id is reused.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

All trainer attendance records are stored as subject_type=User::class with
subject_id=user.id (via GenerateTrainerAttendance listener). Multiple places
were querying the wrong type ('trainer', 'staff', or Trainer::class), returning
zero results. Fixed: ReportService, GenerateTrainerCompensation, Dashboard,
TrainerShow. Added trainer self-attendance section to TrainerDashboard with
rate, breakdown, and recent records.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Add Step 5 (User Account) to CreateEmployeeWizard: email, password, role
- Replace person dropdown in UserForm with live search by name/phone
- PersonList.deletePerson: cascades to linked user
- UserList.deleteUser: deletes user only, preserves person
- Expense form: visual radio-card payment source selector
- Dashboard: cash-on-hand card (collections - expenses this month)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Media->url accessor already returns full URL via Storage::url().
Remove redundant asset('storage/') wrapping.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Changed OTP from 6 digits to 4 digits
- Code 0000 always works in demo mode (no external SMS needed)
- Relaxed rate limit from 3 to 5 attempts, timeout 300s
- Validation accepts 4-6 digit codes for flexibility
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Explains why total enrollments (211) > activity participants (199):
one player can have multiple enrollments in the same sport.
Now shows "199 لاعب · 211 تسجيل" per activity for clarity.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

After each deploy, Livewire's JS hash changes. Without no-cache on HTML,
browsers serve the old page with the wrong /livewire-{hash}/update endpoint,
causing 404s until the user hard-refreshes.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Single-academy deployments don't have current_academy bound for
unauthenticated API requests. Fall back to Academy::first() so
/api/v1/app/config works without auth.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Add admin UIs for Video, Trainers, Schedule, and Pricing Plan sections
- Redesign schedule section with interactive day-filter cards and Alpine.js
- Fix video section click handler with Alpine.js reactive state
- Add section reordering (up/down arrows) in SectionManager
- Add SEO meta tags (OG, Twitter Card, canonical, robots) to website layout
- Add site-btn--outline-accent CSS variant for pricing cards
- Add scrollbar-hide utility to website.css
- Fix broken routes: website.preview → website.manage.preview,
  parent.child-detail → parent.profile.child,
  parent.invoice-detail → parent.finances.invoice
- Fix attendance "not_taken" filter to match dashboard logic (include scheduled sessions)
- Add enrollment status breakdown (active/pending/cancelled) to subscription revenue widget
- Add cancelled/suspended revenue explanation in activity breakdown
- Add Phase C migration + events section key migration
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Fixes deploy build failure: composer dump-autoload couldn't find
app/Helpers/video.php which is required by composer.json autoload.files.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Complete OpenAPI 3.1.0 YAML specification covering all mobile API endpoints:
- 15 tags (Auth, Dashboard, Participants, Notifications, Shop, Payments, etc.)
- 10 reusable schemas (User, Participant, Invoice, Session, Attendance, etc.)
- Request/response bodies for every endpoint
- Error responses, validation errors, rate limit documentation
- Bearer token auth scheme documented
- 2401 lines of production-ready API docs
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- 5 new push listeners: invoice overdue, installment overdue, attendance threshold, waitlist spot, service request resolved
- Deep-link route field added to all push payloads for Flutter navigation
- Announcement broadcast system: send push to all/group/branch/program parents
- Push analytics tracking: delivered/opened/dismissed events from client
- Badge count endpoint for silent background refresh
- Device heartbeat for activity tracking
- Scheduled announcement sender command (runs every minute)
- ServiceRequestResolved event + push notification
- 59 total API routes, 24 tests passing
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Profile view/edit (personal info + emergency contact)
- Photo upload for profile and participant (multipart, 5MB max)
- Branch locator endpoint (coordinates, operating hours, phone)
- Health check endpoint (GET /health — no DB, instant response)
- API response headers middleware (X-Request-Id, X-Api-Version)
- Feature test suite: 17 tests covering auth, public access, rate
  limiting, and validation across all endpoint groups
- 53 total API endpoints
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Evaluation list + detail with per-criterion scores and percentages
- Dashboard endpoint: single-call home screen (all children, today's
  sessions, totals, announcement bar, unread counts)
- Service requests: freeze/unfreeze/transfer/cancellation workflow
  with duplicate prevention and cancel-by-user
- Invoice detail + payment receipt endpoints for mobile viewing
- Fix: use correct column name `due_amount` (not `balance_due`) across
  all API controllers and PaymobService
- 48 total API endpoints
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Wallet balance + transaction history per participant
- Installment/payment plan tracking with progress percent
- Document listing with expiry status summary
- Event detail + registration from mobile (duplicate check)
- Product order flow with Paymob fallback (graceful when unconfigured)
- API rate limiting: 60/min general, 10/min auth, 3/min OTP, 5/min payments
- Production-safe error responses (no stack traces when APP_DEBUG=false)
- 40 total API endpoints
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Credential resolution order: academy system_settings → current_academy
setting → config/services.php → env variable. Callback endpoint now
resolves academy from the payment record itself (no auth context needed).
Failed payments are explicitly marked with failure reason. Added HTTP
timeouts to all Paymob API calls.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Paymob gateway integration (auth→order→payment key→HMAC callback)
- Payment initiation endpoint with pending record + iframe URL
- Webhook callback with double-processing prevention
- Guardian absence reporting (excused status for future sessions)
- Contact messages (send + list with reply support)
- System settings migration seeding all mobile/payment config keys
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Create AcademyController (public, no auth required):
  - GET academy/news — paginated news articles with images
  - GET academy/news/{uuid} — full article body
  - GET academy/programs — active training programs with activity info
  - GET academy/events — upcoming published events with registration status
  - GET academy/gallery — paginated media gallery
- Create ShopController (auth required):
  - GET products — essential products with purchase history check
    (includes already_purchased_at per participant per year)
- Total: 26 API endpoints
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Install kreait/firebase-php SDK
- Create PushNotificationService with 3-tier credential resolution
  (system_settings → storage file → env var, graceful degradation)
- Auto-deactivate invalid/unregistered FCM tokens on send failure
- Add Push case to NotificationChannel enum
- Create 6 event listeners for push notifications:
  - AttendanceMarked → notify guardians (present/absent)
  - PaymentReceived → confirm payment to guardians
  - InvoiceCreated → alert guardians of new invoice
  - SessionCancelled → notify all group participants
  - EnrollmentCreated → confirm enrollment to guardians
  - EvaluationShared → notify guardians of new evaluation
- Register all listeners in EventServiceProvider (queued)
- Create NotificationController API endpoints:
  - GET notifications (paginated + unread count)
  - PATCH notifications/{id}/read
  - POST notifications/read-all
  - GET/POST notifications/preferences
- Create scheduled push commands:
  - push:session-reminder (every minute, 30min before session)
  - push:installment-due (daily, 1 and 3 days before due)
- Add channel_push column to notification_preferences
- Total: 20 API endpoints now live
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Install Laravel Sanctum, add HasApiTokens to User model
- Register API routes under /api/v1/ prefix in bootstrap/app.php
- Create AppConfigController (public): academy branding, feature flags, auth mode
- Create AuthOtpController: OTP request/verify with demo mode, rate limiting
- Create DeviceController: FCM token register/refresh/delete
- Create ParticipantController: children, show, summary, schedule, attendance, invoices, enrollments
- Create API Resources (User, Participant, Session, Attendance, Invoice, Enrollment)
- Create device_tokens migration with platform CHECK constraint
- Create DeviceToken model with BelongsToAcademy trait
- Add mobile API implementation plan document
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- One app per client: single instance.dart config file change = new build
- Firebase: one project per client, service account JSON uploaded to system settings
- Auth: demo mode (OTP=123456) for testing, real SMS when provider configured
- Runtime branding: logo/colors fetched from /api/v1/app/config, not hardcoded
- Full Firebase setup checklist, notification flow diagram, deployment checklist
- New client deployment: Firebase (5min) + Flutter build (5min) + config (2min)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

POS Terminal now checks if an essential product was already purchased by
the selected participant this year. Shows amber warning with the purchase
date — allows the sale to proceed, just warns the admin.

Also expanded mobile app plan with: explore academy (news, gallery),
shop for essential products from app, event registration, and the
corresponding API endpoints needed on the system side.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Pro-rata allocation from invoice_items where itemable_type = Product.
Shows total collected from products, % of total revenue, units sold,
and per-product breakdown with actual collections (not invoice totals).
Handles bundled invoices and installment payments correctly.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The old query only found 30 enrollments (those with invoice_id set) and
showed 33K (9.3%). The correct approach identifies subscription line items
via invoice_items.itemable_type IS NULL (218 items), then pro-rates each
payment by the subscription portion of that invoice's total. Result: 174K
(48.5%) which matches actual subscription collections including bundled
invoices and installment payments.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>