- PublicEventController: pass $sections to views (navbar/footer crash without it)
- Navbar: replace href="#" with href="#section-hero" (forbidden pattern)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Complete events module with admin CRUD, public registration, and management:
- Migrations: events, event_registrations, media collections, permissions
- Domain: Event/Enums (5), Models (2), Services (EventService, EventRegistrationService)
- Admin: EventList, CreateEventWizard (4-step with form builder), EventShow, EventRegistrationList
- Public: event listing + detail pages under /site/{slug}/events with Livewire registration form
- Form builder: button-based add/remove/reorder fields stored as JSONB
- Registration: dynamic validation from form_fields, person matching, registration numbers
- Admin registrations: dynamic columns, bulk confirm/cancel, CSV export
- Livewire scripts added to website layout for public forms
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Salaried trainers now get asked for their monthly amount, which is stored
on the employee record (salary_amount + salary_frequency='monthly').
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

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

- ParticipantForm: add missing created_by when creating new guardian person
- Fix 7 route references using .index instead of .list (trainers, employees,
  enrollments, groups) and other mismatches (inventory.levels.index,
  parent.excuse-form, pricing.rules.index)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Users with 'refunds.initiate' permission see a "استرداد" button next to
each confirmed inbound payment. Confirms before executing.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

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

This was the root cause of repeated migration FK failures in production.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

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

- New tables: facility_rent_payments, expenses with double-entry transactions
- ExpenseService handles both rent and misc expenses with account resolution
- Livewire CRUD: FacilityRentForm/List, ExpenseForm/List
- Dashboard quick action buttons for recording expenses
- Facility show page: new "Rent" tab with payment history
- Sidebar nav links under Financial section
- Reports: expense_summary and facility_rent_summary added to ReportsHub
- New permission: expenses.create/list/view + seeded account 5050
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Livewire's validate([]) falls back to looking for a $rules property on
the component. Steps 6 and 7 intentionally have no validation rules, so
only call validate() when the rules array is non-empty.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

1. Participant edit: guardian section now allows creating a new guardian
   (name + phone) OR selecting existing + editing phone. Checkbox toggles
   between modes.

2. Receptionist wizard: guardian name auto-fill now takes ALL names after
   the first (was only taking 2). "محمود أحمد عبد الفتاح علي" → guardian
   gets "أحمد عبد الفتاح علي" instead of just "أحمد عبد الفتاح".

3. Receptionist wizard step 5: added enrollment_start_date field so the
   user can specify when the player actually started (for accurate
   proration). Defaults to today if left empty.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Reports: 30 business reports in 6 categories (financial, participants, attendance,
enrollments, operations, inventory) with CSV export. New ReportsHub grid page and
generic ReportViewer with date/branch filters.

Fixes: refund now creates double-entry transaction + deducts from cash session,
branch switcher properly persists "all branches" selection, trainer wizard
compensation step reactive, gender display on edit, participant edit supports
national_id and guardian phone, participant list shows membership column + searches
by national_id/membership_id.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The grid was blank because lanes and zones segments have null row_index/col_index.
The old code assumed all layouts were grid-type and collapsed to 0×0.

- Grid layouts: keep the spreadsheet-style row/col selector view
- Lanes layouts: render as horizontal strips (label + cell side by side)
- Zones/custom layouts: responsive card grid (no row/col concept)

Layout type is now read from Facility::activeLayout (new HasOne relationship)
with a null-safe fallback to row_index detection. Segment cell HTML extracted
to _segment-cell.blade.php partial to avoid triplication.
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

/facilities/space-assignment and /facilities/schedule-builder were registered
after /facilities/{facility}, so Laravel matched the wildcard first and tried
to resolve the literal slugs as UUIDs, crashing with invalid uuid syntax.
Static routes are now declared before the wildcard.
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

Adds محصّل vs إجمالي الإيرادات with a progress bar and remaining balance.
Collection is computed as a pro-rata share of invoice.paid_amount based on
the product line's fraction of the invoice total — so mixed invoices
(product + program) correctly attribute only the product's share of each
payment. Price overrides are excluded from the product's line because they
always land on the program item, leaving the product total_amount intact.
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

Products with track_inventory=false never create InventoryMovements on sale,
so the old movement-based queries always returned 0. Revenue and units sold
now come from InvoiceItem (the authoritative source for what was actually
invoiced). Stock-in (إجمالي الوارد) still uses InventoryMovement since that
genuinely is a stock-receipt concept. Added إجمالي الإيرادات KPI card.
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

ParticipantStatus is a backed enum — concatenating it directly throws.
Use ->value to get the string value.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

The program invoice item was stored with unit_price = original programFee,
then recalculateTotals() summed items and overwrote total_amount back to
the original — so the printed invoice showed the pre-override amount.

Fix: apply the override delta directly to the item's unit_price so the item
row and invoice total are consistent. Metadata now stores original_price =
programFee (per-item, not order total) for the strikethrough display on print.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Super admin and financial admin can select up to 2 confirmed payments from
a participant's profile and refund them in a single atomic transaction.
If a refunded payment is linked to a program enrollment, the enrollment is
automatically cancelled and the group seat is freed.

Changes:
- RefundService: creates outbound refund record, marks original as refunded,
  reverses invoice paid_amount — all within the caller's DB::transaction
- ParticipantShow: checkbox selection on confirmed inbound payments, preview
  modal showing impact (including enrollment cancellation warning), reason
  field, atomic commit via DB::transaction wrapping both domains
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Passing ?participant=uuid from the participant profile button now skips
step 1 entirely — the wizard opens directly on step 2 (invoice selection)
with the participant already selected.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Adds a live summary panel above the invoices table showing total payments
broken down by method for a configurable date range (default: this month).
Includes two big comparison cards (selected method vs all others), a full
horizontal mini-bar breakdown for every method, and preset range shortcuts.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Super admins can now edit the payment method on any existing payment
directly from the invoice detail page. The change is automatically
captured in the audit log via the Auditable trait on the Payment model.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

This file contained OC Sport-specific data and does not belong in the
shared multi-tenant codebase.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Imports Team (99) and Academy (93) players from HTML sheet one at a time
using existing services (InvoiceService, PaymentService). Creates Person →
Participant → Enrollment → Invoice → Payment per player, with installment
plan attachment for partial القيد payments. Cross-sheet duplicates are
written to storage/app/july_import_duplicates.json. Idempotent by name.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Generated codes like TEAM2001-10 exceed 10 chars when there are 10+ duplicate
program names within an academy. Widen to varchar(20).
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

- Migration: add installment_amounts JSONB (nullable) to product_installment_plans
- ProductInstallmentPlan: new buildSchedule() method — uses explicit piaster amounts per slot where set, auto-calculates remainder evenly for blank slots; downPaymentAmount/regularInstallmentAmount respect slot[0] override
- ProductForm: syncInstallmentSlots() keeps slot array in sync when count changes; plan rows load/save installment_amounts (stored as piasters, shown as pounds); slot inputs appear under collapsible "تحديد مبلغ كل قسط" toggle per plan row
- Wizard confirm(): uses buildSchedule() so each Installment row gets its correct explicit or auto-calculated amount
- Wizard blade breakdown preview: renders individual amounts when slots differ, uniform "N × amount" when all regular slots match
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

- New migration: billing_cycle (one_time/annual), member_price, non_member_price on products; product_installment_plans table (per-product, per-tier plan templates)
- ProductInstallmentPlan model with scopeActive/forTier, downPaymentAmount/regularInstallmentAmount helpers
- Product model: priceForTier(), isAnnual(), installmentPlans() relationship
- ProductForm: annual billing section with member/non-member dual prices and installment plan builder (add/remove rows, upsert on save)
- Registration wizard: essentialProducts() and hotbuyResults() now return billing_cycle and plans[]; addHotbuyItem() carries plans into cart; setHotbuyPlan() selects a plan per cart item; confirm() generates PaymentPlan + Installment rows for annual items with a selected plan
- Wizard blade: annual cart items show purple "سنوي" badge, plan pills (full payment + per-plan buttons), and installment breakdown preview on selection
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Two bugs:
1. save() wrote bare key "allow_proration" but ProrationService reads
   dotted "enrollment.allow_proration" — now always writes "{group}.{key}"
2. loadAllSettings() tried to read bare keys but DB had dotted keys from
   seeder — now strips group prefix on read so UI always sees bare keys

Result: toggle saves correctly, ProrationService reads the live value,
mid-month enrollment now shows prorated fee (e.g. day 16 = 15/30 × fee).
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

JSONB column has NOT NULL constraint — pass empty array instead of null
when no price override metadata exists.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Fields already existed on the guardians table (occupation, workplace) but
had no UI. Now:
- Registration wizard step 2 shows المهنة + جهة العمل fields (optional)
- Saved to Guardian on create; updates existing guardian if already found
- Pre-populated when selecting an existing guardian via search
- Participant show → أولياء الأمور tab adds المهنة / جهة العمل column
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Add allow_proration (boolean) and renewal_day (number, 1-28) to the
enrollment settings schema with descriptive hints so admins can find and
toggle partial monthly payment from the UI.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

- Add is_essential boolean to products (migration + model + form toggle)
- Essential products appear as quick-add buttons in registration wizard step 5 (no search needed), highlighted when added to cart
- New EssentialDeliveries page (/inventory/essential-deliveries): lists all players who bought essential products, mark استلم/لم يستلم per item with who delivered and when
- Delivery tracking: add is_delivered, delivered_at, delivered_by to invoice_items; hotbuy cart items now store itemable_type/id for proper morph link
- Admin price override now stored in invoice item metadata (original_price, overridden_price, override_reason) and displayed on invoice print with crossed-out original price
- "أساسي" badge on product list; "تسليم الأساسيات" button on product list header and sidebar
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Payment modes:
- Full (default): pays entire invoice amount
- Partial: enter amount paid now, remainder stays as balance due on invoice
- Split: two methods, amount1 + calculated remainder, both recorded as payments

All 7 PaymentMethod values now available:
- cash: no extra fields
- card: transaction_reference (required)
- bank_transfer: transaction_reference (required), bank_name (optional)
- online (Instapay/digital wallets): transaction_reference (required)
- wallet (club wallet): deducts from member balance
- cheque: cheque_number (required), bank_name (optional)
- other: notes field

Each payment recorded with gateway_data JSON (ref, cheque_number, bank_name)
Enrollment payment_status only set to 'paid' when full amount covered
Validation rules built dynamically from active mode + method combination
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

- EnrollmentSettingsSeeder: fix Organization → Academy class name
- ReceiptTemplate: add defaultInvoiceFields/Settings + defaultPaymentFields/Settings
- ReceiptSettings: rewritten with pos/invoice/payment tabs; each tab loads
  its own ReceiptTemplate (type='invoice'|'payment') and saves independently
- receipt-settings.blade.php: 3-tab UI with field toggles + appearance settings
  per document type; link to branding page for logo/colors
- print/invoice.blade.php: all 15 fields now gated by invoice template flags
  (logo, academy name, branch, tax number, client details, items table,
  subtotal, discount, tax, service fee, paid amount, payments history,
  signature, terms & conditions, footer text)
- print/payment-receipt.blade.php: all 11 fields gated by payment template;
  footer text pulled from template settings instead of hardcoded string
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

CapRover volume remounts can override build-time chown, leaving
storage/logs owned by root. Explicitly touch + chown the log file
at container start before php-fpm runs.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

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

- AuthService: accepts email or phone for login (identifier-based lookup)
- Login UI: updated to text input with Arabic labels
- EgyptianNidDecoder: decodes 14-digit NID → birth date, gender, governorate
- ProrationResult DTO + ProrationService: mid-month enrollment fee proration (x/30 of remaining days based on configurable renewal day)
- EnrollmentSettingsSeeder: seeds enrollment.allow_proration and enrollment.renewal_day per academy
- NewRegistrationWizard: rewritten — player-first flow, NID auto-decode locks birth/gender/governorate, foreign player toggle, guardian name deduced from player name, phone-only guardian, super admin price override, proration display
- EnrollmentService: applies proration to invoice creation
- EnrollExistingWizard: adds proratedProgramFee computed property, review step shows original vs prorated fee
- Migration: adds governorate column to people table
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

Every entity list now has clickable rows that navigate to rich detail
pages with KPIs, tabbed content, and related data. New show pages:

- TrainerShow: groups, schedule, attendance, financial, qualifications
- EmployeeShow: personal info, team hierarchy, documents, timeline
- GroupShow: enrollments, schedule, sessions, attendance stats
- ProgramShow: groups, enrollments, settings, requirements
- FacilityShow: layouts, segments, reservations, schedule
- ProductShow: stock levels, movements, analytics
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The old 'inventory.adjustments.wizard' route was removed — now just
'inventory.adjustments'.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>