$filter, 'search' => $search, 'date_start' => $date_start, 'date_end' => $date_end, ]); $invoices = $zoho_data['invoices']; $has_next = $zoho_data['has_more_page'] ?? false; // ── Map Zoho IDs back to local invoice IDs (for view/PDF links) ─ $z_ids = array_filter(array_map(fn($i) => $i['invoice_id'] ?? null, $invoices)); $local_map = []; $member_map = []; if ($z_ids) { $placeholders = implode(',', array_fill(0, count($z_ids), '?')); $rows = db_all( "SELECT i.id AS local_id, i.zoho_invoice_id, i.member_id, m.first_name, m.last_name, m.business_name, m.email FROM invoices i LEFT JOIN members m ON m.id = i.member_id WHERE i.zoho_invoice_id IN ($placeholders)", array_values($z_ids) ); foreach ($rows as $r) { $local_map[$r['zoho_invoice_id']] = (int)$r['local_id']; $member_map[$r['zoho_invoice_id']] = $r; } } // Helpers function status_pill(string $st): string { $st = strtolower($st); $colors = [ 'paid' => 'background:#dcfce7;color:#166534;', 'sent' => 'background:#dbeafe;color:#1e40af;', 'viewed' => 'background:#dbeafe;color:#1e40af;', 'unpaid' => 'background:#fef3c7;color:#92400e;', 'overdue' => 'background:#fee2e2;color:#991b1b;', 'partially_paid' => 'background:#fef3c7;color:#92400e;', 'draft' => 'background:#e5e7eb;color:#374151;', 'void' => 'background:#e5e7eb;color:#374151;', ]; $style = $colors[$st] ?? 'background:#e5e7eb;color:#374151;'; $label = ucwords(str_replace('_', ' ', $st)); return '' . htmlspecialchars($label) . ''; } // Helper to build query string preserving filters but updating one or more keys function qs_with(array $overrides): string { $base = $_GET; foreach ($overrides as $k => $v) { if ($v === null || $v === '') unset($base[$k]); else $base[$k] = $v; } return http_build_query($base); } $has_active_filter = ($filter !== '' || $search !== '' || $date_start !== '' || $date_end !== ''); ?>

Invoices

Live from Zoho Books. Numbers, statuses, and totals match Zoho exactly. Zoho Books is not configured.

Connect Zoho Books to view invoices. Go to Settings → Zoho Books to configure.

All Unpaid Overdue Paid Draft result on this page 1 ? ' (page '.$page.')' : '' ?>

No invoices found.

Try widening your search or clear the filters.

Number	Date	Customer	Total	Status	Linked member
					not linked	View PDF —

Page

1): ?> ← Previous Next →