prepare("SELECT u.* FROM user_tokens ut JOIN users u ON u.id = ut.user_id WHERE ut.token = ? AND ut.expires_at > NOW() AND u.is_active = 1"); $ts->execute([$token]); $user = $ts->fetch(); if (!$user) { http_response_code(401); die('Unauthorised'); } } else { $user = requireAuth(); } $db = getDB(); $monthId = (int)($_GET['month_id'] ?? 0); if (!$monthId) die('Month ID required.'); $mStmt = $db->prepare("SELECT * FROM cashflow_months WHERE id = ? LIMIT 1"); $mStmt->execute([$monthId]); $month = $mStmt->fetch(); if (!$month) die('Month not found.'); // Income $incStmt = $db->prepare("SELECT ci.*, c.company_name AS client_name, jc.job_number FROM cashflow_income ci LEFT JOIN clients c ON c.id=ci.client_id LEFT JOIN job_cards jc ON jc.id=ci.job_card_id WHERE ci.month_id=? ORDER BY ci.type, ci.id"); $incStmt->execute([$monthId]); $income = $incStmt->fetchAll(); // Expenses $expStmt = $db->prepare("SELECT ce.*, s.merchant AS slip_merchant FROM cashflow_expenses ce LEFT JOIN slips s ON s.id=ce.slip_id WHERE ce.month_id=? ORDER BY ce.type, ce.id"); $expStmt->execute([$monthId]); $expenses = $expStmt->fetchAll(); $co = $db->query("SELECT setting_value FROM settings WHERE setting_key='company_name' LIMIT 1")->fetchColumn(); $company = $co ?: 'Elegant Work'; function fmt($n) { return 'R '.number_format((float)$n,2); } function coalesce(...$vals) { foreach ($vals as $v) { if ($v !== null && $v !== '') return $v; } return 0; } // Single amount per line: actual_amount if set, else expected_amount $opening = (float)$month['opening_balance']; $totalIncome = array_sum(array_map(fn($r)=>(float)coalesce($r['actual_amount'],$r['expected_amount']), $income)); $totalExpenses = array_sum(array_map(fn($r)=>(float)coalesce($r['actual_amount'],$r['expected_amount']), $expenses)) + (float)$month['payroll_amount']; $pendingIncome = array_sum(array_map(fn($r)=>!$r['is_paid']?(float)coalesce($r['actual_amount'],$r['expected_amount']):0, $income)); $pendingExpenses=array_sum(array_map(fn($r)=>!$r['is_paid']?(float)coalesce($r['actual_amount'],$r['expected_amount']):0, $expenses)) + (float)$month['payroll_amount']; $net = $pendingIncome - $pendingExpenses; $closing = $opening + $net; $generated = date('d M Y H:i'); ?> <?= htmlspecialchars($month['label']) ?> — Cash Flow Report
·
⚡
Cash Flow Report —
Opening Balance:
0): ?>Payroll:
Generated:
In Bank (Opening)
Income Total
Expenses Total
Still to Receive
Still to Pay
Net Pending
Projected Balance (In Bank + Net Pending)
ℹ️ Net Pending = unpaid income minus unpaid expenses. Paid items are excluded as they are already reflected in your In Bank figure.
Income
DescriptionClientJCRecurringStatusAmount

↩ from
TOTAL INCOME
Expenses
0): ?>
DescriptionCategoryRecurringSlipStatusAmount
Payroll Salaries——

↩ from
TOTAL EXPENSES
Net P/L
Closing Balance
— Cash Flow Report — Generated