- Medical records: upload with certificate type (ممارس/أكاديمي/دولي), auto-validity
  calculation, Board of Trustees approval workflow (pending → approved/rejected)
- New /medical-approvals page for مجلس الأمناء with approve/reject actions
- Mirror (المراية): interactive grid system for facility scheduling - create grids,
  assign coaches/academies to boxes, manage trainees (max 5 per box)
- Facility dashboard: per-facility stats with day/week/month/custom date filtering
- FacilityPricingService: reads club pricing rules from system_config, integrates
  with reservation creation as rate fallback
- Pricing seed: official 2025 club ruleset for non-educational activities stored
  in system_config (member/non-member rates, entry tickets, general fees)
- Updated sidebar menu with medical approvals link
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

- Fix route URL mismatches in player show.php (card/activate, card/suspend, card/revoke, enroll/drop)
- Fix Sports module permissions (was using temp.view/temp.add, now sports.view/sports.add/sports.convert)
- Add CSRF middleware to Sports POST route
- Fix AcademyEnrollment::getForPlayer() to JOIN academy/level names
- Add NID auto-parsing API and JS to player create/edit (deduces DOB, age, gender, governorate)
- Replace raw ID inputs in enrollment form with cascading dropdowns (academy→level→schedule)
- Add profile photo upload to player create/edit/show with live preview
- Add full player history timeline (enrollments, payments, medical, attendance)
- Add sport→facility cascade filter to reservation create form
- Make all code fields optional with auto-generation (Disciplines, Academies, Facilities, Levels)
- Overhaul Sports create form with discipline dropdown and competitive level select
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The service_catalog table does not have a 'category' column — the seed was
inserting into it causing deployment to fail with "Unknown column 'category'".
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Root cause found: app.js sets opacity:0 + transform:translateY(16px) on
EVERY .card element at DOMContentLoaded, then relies on an
IntersectionObserver to reveal them. When cards are already in viewport
or content is tall, the observer fails to fire and cards stay invisible.

Zooming triggered a layout recalculation that forced the observer to
re-evaluate, making content reappear — explaining the user's symptom.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Phase_24 migration: converted to closure that checks information_schema
before adding each column (column already exists on deployed DB).

Phase_39 seed: check if permissions table exists before inserting
(table was never created — skip gracefully).
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The list disappearance was caused by multiple CSS properties creating
GPU compositing layers that Chrome fails to paint correctly for tall
content:

1. backdrop-filter on .top-header (sticky + blur = broken paint bounds)
2. animation on .page-content (creates layer on entire page)
3. transition:all on every table row (hundreds of compositing hints)
4. tableRowIn animation with transform (layer per animated row)
5. transition + hover on .card (unnecessary for a container)

Removed all these GPU-triggering properties. The visual appearance is
preserved (opacity 0.97 white background instead of blur, hover effects
still work via :hover without transition).
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

The chart_of_accounts.name_en column is VARCHAR(200) NOT NULL.
Both seeds were passing null which caused integrity constraint violations.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Root cause: transition with transform on .card promoted it to a GPU
compositing layer. Chrome miscalculates paint bounds for tall containers
with many children, causing content to clip until a zoom triggers repaint.

Fixes:
- Remove transform from .card transition (only box-shadow/border-color)
- Use transform:none instead of translateY(0)/translateX(0) in animation
  end states to release the compositing layer after animation completes
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Shows opening debit/credit, period debit/credit, closing debit/credit
columns matching standard Egyptian accounting trial balance format.
Adds CSV export endpoint with UTF-8 BOM for Arabic Excel support.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Change .card overflow from hidden to visible. The hidden overflow
caused Chrome to miscalculate paint regions for containers with
many child elements (chart of accounts, rules, etc.), resulting
in content being invisible until a repaint was triggered.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

sethderyj