=== Z-REPORT DEBUG TOOL ===

Test Date: 2026-08-22
Date Range: 2026-08-22 00:00:00 to 2026-08-22 23:59:59

1. TESTING PAYMENTS QUERY:
Total payments on 2026-08-22: 0
Total amount (all):  cents = 0 TL
Successful payments (status=1): 0
Successful amount (status=1):  cents = 0 TL
Payment types found: 

2. FILTERED PAYMENTS (card types only, status=1):
Filtered payments (status=1): 0
Filtered amount:  cents = 0 TL

⚠️  WARNING: No successful payments found for date 2026-08-22
Checking last 7 days of successful payments:

3. GENDER DISTRIBUTION:
Gender values in database:
  'male': 1779 users → Will be counted as: MALE
  'female': 974 users → Will be counted as: FEMALE
  'E': 1 users → Will be counted as: FEMALE
  'other': 1 users → Will be counted as: FEMALE

4. LAST 5 PAYMENTS (including status):
Payment #57959: 1500 cents (15 TL), Type: capture, Status: ✓ SUCCESS (1), Date: 2025-11-30 17:56:45, User: 3626
Payment #57958: 4000 cents (40 TL), Type: capture, Status: ✓ SUCCESS (1), Date: 2025-11-30 17:53:54, User: 252
Payment #57957: 2500 cents (25 TL), Type: bonus, Status: ✓ SUCCESS (1), Date: 2025-11-30 17:53:19, User: 339
Payment #57956: 3000 cents (30 TL), Type: bonus, Status: ✓ SUCCESS (1), Date: 2025-11-30 17:52:07, User: 3343
Payment #57955: 2500 cents (25 TL), Type: bonus, Status: ✓ SUCCESS (1), Date: 2025-11-30 17:51:32, User: 3350

5. PAYMENT STATUS BREAKDOWN:
No payments found for 2026-08-22

=== DEBUG COMPLETE ===

Now run: php zReport.php
Then check logs: tail -f /var/log/php_errors.log