$o['name'] . ' (#' . $o['organization_id'] . ')', $orgs); $test_result = ['ok' => true, 'msg' => 'Connection works! Organisations: ' . implode(', ', $names)]; } else { $test_result = ['ok' => false, 'msg' => 'API call failed (HTTP ' . $r['status'] . '). Check log below.']; } } else { $test_result = ['ok' => false, 'msg' => 'Could not obtain access token. Check credentials in config.']; } } if (($_POST['do'] ?? '') === 'retry_invoice') { $inv_id = (int)($_POST['invoice_id'] ?? 0); if ($inv_id > 0) { $r = zoho_record_payment_full($inv_id, $_POST['gateway'] ?? 'payfast'); if ($r['ok']) { // Now that we have the Zoho invoice number, send the deferred // payment_received email that we held back when the original // ITN ran without Zoho available. $inv = db_row('SELECT * FROM invoices WHERE id=:id', ['id'=>$inv_id]); $member = $inv ? db_row('SELECT * FROM members WHERE id=:id', ['id'=>$inv['member_id']]) : null; if ($inv && $member && !empty($inv['number'])) { require_once __DIR__ . '/../includes/mailer.php'; $amount_display = 'R ' . number_format(($inv['amount_cents'] ?? 0)/100, 2, '.', ' '); $next_date = $member['renewal_date'] ? date('j F Y', strtotime($member['renewal_date'])) : date('j F Y', strtotime('+1 month')); email_enqueue('payment_received', $member['email'], trim($member['first_name'].' '.$member['last_name']), [ 'first_name' => $member['first_name'], 'business_name' => $member['business_name'], 'tier' => $member['tier'], 'amount' => $amount_display, 'invoice_number' => $inv['number'], 'next_charge_date' => $next_date, ] ); } $retry_result = ['ok'=>true, 'msg'=>"Sync OK for invoice #$inv_id (Zoho number {$r['invoice_number']})"]; } else { $retry_result = ['ok'=>false, 'msg'=>"Sync still failing: " . ($r['error'] ?? 'unknown')]; } } } } // Invoices that need Zoho attention — either a sync error was recorded, // or the invoice has been paid but has no Zoho number assigned yet. $failed_syncs = db_all( "SELECT i.*, m.email AS member_email, m.business_name FROM invoices i LEFT JOIN members m ON m.id = i.member_id WHERE i.status = 'paid' AND (i.number IS NULL OR i.zoho_sync_error IS NOT NULL) AND i.zoho_invoice_id IS NULL ORDER BY i.id DESC LIMIT 50" ); $entries = db_all( 'SELECT z.*, m.business_name, m.email AS member_email FROM zoho_log z LEFT JOIN members m ON m.id = z.member_id ORDER BY z.created_at DESC LIMIT 200' ); $counts = [ 'total' => (int)db_value('SELECT COUNT(*) FROM zoho_log'), 'fail' => (int)db_value('SELECT COUNT(*) FROM zoho_log WHERE success=0'), 'today' => (int)db_value("SELECT COUNT(*) FROM zoho_log WHERE created_at >= CURDATE()"), ]; ?>

Zoho Books

Audit trail of API calls + a test page.

Configuration: DC: · Org: · Total calls: · Today: · Failed:

⚠ Invoices that need Zoho attention

Paid by the customer locally, but Zoho automation didn't complete. The customer hasn't received their receipt email yet — that goes out automatically when the sync succeeds. Most common cause: PayFast bank account not yet configured in Settings → Payment Fees. Fix the cause, then click Retry.

Invoice	Member	Amount	Error
No number yet local id #		R

No log entries yet. Click "Test connection" or sync a member to generate activity.

When	Member	Method	Endpoint	Status	Note	Detail
	—					Response Request

Showing latest entries.