Frontend:
- Client-side NID parser (no API call) — extracts DOB, gender, age, governorate
- Shows green badge with parsed info (governorate, gender, age)
- Red highlight + Arabic message on every invalid field
- Validates: code, name, employment_type, payment_model (non-academy),
  academy_id (academy), NID length, email format, phone format
- Hides payment/rate fields for academy coaches (not needed)
- Shows note explaining academy coaches follow salary system
- Gender/DOB auto-locked when NID is valid, manual otherwise
- Age displayed under DOB field

Backend:
- Strips non-digits from NID input
- Uppercase code automatically
- Checks NID uniqueness against existing coaches
- Validates email with filter_var
- Academy coach requires academy_id selected
- payment_model defaults to 'salary' for academy, 'per_session' fallback
- max_groups minimum 1
- Success message includes coach name
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Tables fixed (already applied to live DB directly):
reservations, academy_settlements, achievement_definitions,
activity_subscriptions, facility_grids, facility_monthly_plans,
facility_zone_schedules, player_evaluations, player_injuries,
pool_bookings, pool_configurations, pool_schedules,
sa_player_documents, sa_pricing_rules, tournaments,
training_groups, training_sessions

Migration is idempotent — checks column existence before ALTER.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- reservations: added updated_by column (model has autoTrackAuthor=true but column didn't exist)
- sa_coaches: academy coaches now default to payment_model='salary' instead of NULL (NOT NULL column)
- Also applied column fix directly to live DB via SSH
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Each missing field shows as its own red error banner at the top of the page
instead of one long string with invisible newlines.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

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

Client-side: validates ALL mandatory DB fields before allowing next/submit
- Step 1: name, phone, gender, date_of_birth (or NID)
- Step 2: form_date, join_date
- Step 3: membership_value
- Step 5: each spouse needs name, DOB/NID, marriage_date, join_date
         each child needs name, DOB/NID, join_date
         each temp member needs name, DOB/NID, category
- Red border + Arabic error on each missing field, scrolls to first error

Server-side: full validation before any DB write
- Rejects with clear Arabic messages listing every missing field
- No more placeholder dates or fake phone numbers
- If anything bypasses JS, server still blocks with human-readable errors
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- spouses: add spouse_order, gender, classification, fallback date_of_birth
- children: add child_order, relationship, classification, fallback date_of_birth
- temporary_members: fallback date_of_birth, gender
- members: phone_mobile defaults to placeholder, date_of_birth fallback
- installment_plans: down_payment_receipt cast to string (VARCHAR column)
- All dates go through safeDate() — rejects garbage, parses valid formats
- All timestamps go through safeTimestamp() — never produces invalid datetime
- financial_year '2020/2021' extracted correctly for created_at
- bccomp amounts always cast to string to avoid type errors
- Null-safe on every optional field — zero room for SQL errors
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- phone_mobile column is NOT NULL; pass empty string instead of null
- financial_year '2020/2021' was used directly in created_at datetime; extract first year
- Add client-side step validation with red border highlights instead of alert() popups
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Run: php cli.php seed:run Phase_88_001_seed_tournament_bot_players
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The members table has date_of_birth as NOT NULL, but the wizard passed
null when no explicit DOB was entered. Now NationalIdParser extracts
DOB and gender from the 14-digit national ID for the main member,
spouses, children, and temporary members.

If no NID and no DOB provided, returns a clear validation error instead
of letting the DB constraint violation propagate.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Fix 5 support ticket bugs: AJAX errors, capacity validation, audit export, player lookup, fee display

TKT-59: ExceptionHandler now returns JSON for AJAX/XHR requests instead of
HTML error pages. Booking wizard JS improved to show actual error messages.

TKT-57: Pricing rule creation now validates group_size_max against the
facility unit's max_capacity, preventing over-capacity rules.

TKT-46: Added audit log CSV export with all current filters applied.
New route GET /audit/export and export button in the filter bar.

TKT-55: Player registration member lookup now uses only the DB id
(set by AJAX member lookup) instead of ambiguous membership_number/id
fallback. National ID field locked when auto-filled from member record.

TKT-50: Fee breakdown text now shows base amount and development fee
separately (e.g. "اشتراك سنوي: 222.00 + تنمية: 35.00 = 257.00")
instead of just the combined total.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

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

The old calculator applied a flat percentage by position (oldest=10%, next=50%,
next=100%). The correct model: each year's penalty escalates based on how long
THAT SPECIFIC year has been overdue:
- Same year past grace (3 months): 10%
- 1 year overdue: 50%
- 2 years overdue: 100%
- 3 years overdue: 200%
- 4 years overdue: 300%
- 5+ years: membership dropped

Also adds:
- Grace period rule (SUB_GRACE_MONTHS = 3, extended = 4 with trustees approval)
- YEAR_4 (200%) and YEAR_5 (300%) rules in DB
- canReinstate() method for 12-month reinstatement window
- expireReinstatements() for permanent drop after window expires
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

collectBookData() was only extracting steps for 3 hardcoded sections
(membership, sports-activity, treasury) using regex on view files.
All other sections (45 of 48) were passed without steps, rendering
only subtitle text in the PDF. Now calls TutorialRegistry::getSteps()
for every tutorial in every section.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Every tutorial now has 3-7 explicit steps with consistent format:
- Navigation step first (how to get to the page)
- Action steps in the middle (what to fill/click)
- Confirmation/result step last (with success/warning callouts)

Sections fixed: parents, medical-board, access-matrix, rules, dashboard,
family, transfers-waivers, trainer-portal, parent-portal

Also fixed forms.print-form (was 2 steps, now 3).
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Add 84 sub-page screenshots for tutorials (accounting, HR, inventory, procurement, sales, system pages)
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>