=== EMAIL SYSTEM DIAGNOSTIC ===

1. Configuration:
   ✓ Database connected
   ✓ Email config loaded
   EMAIL_METHOD: smtp
   SMTP_HOST: ssl0.ovh.net
   SMTP_PORT: 587
   FROM: contact@captaindecision.com

2. Notification Emails Helper:
   ✓ notification-emails.php loaded

3. Database Table Check:
   ✓ airport_notification_emails table exists
   Total records: 3
   ✓ ACTIVE | GMFF | fez.operations@swissport.com | fuel_slip_acknowledged
   ✓ ACTIVE | LFML | moussmerouan@gmail.com | fuel_slip_acknowledged
   ✓ ACTIVE | LFML | dutyappsolution@gmail.com | fuel_slip_acknowledged

4. Email Template Functions:
   ✓ getFuelSlipAcknowledgmentEmailTemplate() — 18 params
   ✓ getGroundInformationSlipCreatedEmailTemplate() — 11 params
   ✓ getGroundInformationSlipUpdatedEmailTemplate() — 13 params
   ✓ sendEmail() — 4 params
   ✓ getNotificationEmails() — 3 params

5. Flights Table Columns:
   ✓ flight_number exists
   ✓ flight_date exists
   ✓ origin exists
   ✓ destination exists
   ✓ aircraft_type exists
   ✓ aircraft_registration exists
   ✓ scheduled_departure_time exists

6. Fuel Slips Table Columns:
   ✓ block_fuel exists
   ✓ taxi_fuel exists
   ✓ trip_fuel exists
   ✓ fuel_type exists
   ✓ unit_price exists
   ✓ total_cost exists
   ✓ currency exists
   ✓ actual_fuel_loaded exists
   ✓ remarks exists
   ✓ rtow exists

7. Testing getNotificationEmails():
   ✓ GMFF: 1 recipients → fez.operations@swissport.com
   ⚠ GMMN: NO recipients configured
   ✓ LFML: 2 recipients → dutyappsolution@gmail.com, moussmerouan@gmail.com

8. PHPMailer Check:
   ✓ vendor/autoload.php exists
   ✓ PHPMailer class available

9. Quick Email Test (dry run):
   Testing sendEmail function with a basic message...
   ✓ Test email SENT to contact@captaindecision.com

=== DIAGNOSTIC COMPLETE ===
Date: 2026-04-15 20:58:28