24h Financial Report & MLM Commission Email — Diagnostic

1. Recipient for financial report email

✓ FINANCIAL_REPORT_EMAIL is set (sol…).

MLM commission paid report summary is sent to COMMISSION_REPORT_EMAIL if set, otherwise FINANCIAL_REPORT_EMAIL. COMMISSION_REPORT_EMAIL is set.

2. SMTP / email delivery

✓ SMTP_PASSWORD is set in .env. Emails can be sent via SMTP.

3. Last run result — did emails actually send?

Report date: 2026-04-16 · Written: 2026-04-17 09:00:57

• Financial report email: ✓ sent
• MLM commission emails: 10 sent
• Tsedey Bank email: ✗ not sent

4. No server-time dependency — runs at any time

Current time (Addis): 2026-04-17 20:24 EAT. Server timezone: Africa/Addis_Ababa — UTC: 2026-04-17 17:24

The end-of-day script is free from server-time dependency:

• It never checks the time of day to decide whether to run — no "only at midnight" or "skip if before 23:00" logic.
• It runs whenever invoked (cron, browser, or CLI). Report date is: explicit (URL ?date=YYYY-MM-DD or CLI arg or EOD_REPORT_DATE in .env), or else yesterday in Africa/Addis_Ababa.
• Schedule cron once per day at any fixed time (e.g. 20 0 * * * = 00:20 Addis; or 59 23 * * * = 23:59 Addis; if server is UTC use 59 20 * * * for 23:59 Addis). All 24h emails (financial, MLM paid, Tsedey Bank) are sent every run.

Last cron run (from log): 2026-04-17 09:00:57 [cron-end-of-day-compile] HTTP: background CLI — three independent email runs (financial, MLM, Tsedey; async)

Optional: server-time.php shows more timezones. If that link returns “Not found”, upload server-time.php from this project to api-backend/admin/ on the server, or use setup-end-of-day-cron.php for the exact cron line.

5. Quick tests

• Send one test email
• Send 24h financial report email (yesterday’s date; check JSON for sent and error).
• Test MLM daily commission paid report (sends to paid distributors for a chosen date).
• Run cron once (force) — runs all 5 steps now and shows whether financial and MLM commission emails were sent.

5. Success but no email received?

If the report shows sent: true but nothing arrives: (1) Send one test email to FINANCIAL_REPORT_EMAIL and check inbox + spam. (2) Add SMTP_USE_PRIMARY_FIRST=1 to api-backend/.env to use primary mailbox first, then test with primary. (3) Check mail server logs and SPF/DKIM for afrinex.shop.

6. Common causes

• Cron not scheduled — Add one cron job to run once per day (no server-time check in script). Fix: setup-end-of-day-cron.php.
• Wrong cron time — Server in UTC? Use 59 20 * * * (20:59 UTC = 23:59 Addis).
• No paid distributors for that date — MLM commission emails: one per distributor with “Paid & Transferred” for that date. If total = 0, no emails is expected.
• SMTP/API failure — Check cron-compile.log for daily-financial-report-email sent=0 error=, email-mlm-daily-commission-paid-report, or commission-report-summary sent=0 (summary is the MLM commission 24h report email to admin).

Full checklist: TROUBLESHOOT-CRON-EMAIL.md, WHY-FINANCIAL-EMAIL-NOT-SENT.md, MIDNIGHT-24H-REPORT-NOT-SENDING.md.