prepare("SELECT payment_method, SUM(amount) as total FROM payments p JOIN invoices i ON p.invoice_id = i.id WHERE i.register_session_id = ? AND i.status = 'paid' AND i.is_pos = 1 GROUP BY payment_method");
$breakdown->execute([$s['id']]);
$methods = $breakdown->fetchAll();
$cash_sales = 0;
$card_sales = 0;
$credit_sales = 0;
$bank_transfer_sales = 0;
foreach ($methods as $m) {
$method = strtolower($m['payment_method']);
if ($method === 'cash') $cash_sales = $m['total'];
elseif ($method === 'card' || strpos($method, 'card') !== false) $card_sales = $m['total'];
elseif ($method === 'credit') $credit_sales = $m['total'];
elseif (strpos($method, 'transfer') !== false || strpos($method, 'bank') !== false) $bank_transfer_sales = $m['total'];
else $cash_sales += $m['total'];
}
$total_sales = $cash_sales + $card_sales + $credit_sales + $bank_transfer_sales;
$expected_cash_total = (float)$s['opening_balance'] + $cash_sales;
$total_all = (float)$s['opening_balance'] + $total_sales;
?>
Sales Summary
Opening Balance:
OMR
prepare("SELECT SUM(vat_amount) as total_tax, SUM(discount_amount) as total_discount, SUM(total_with_vat) as total_net FROM invoices WHERE register_session_id = ? AND status = 'paid' AND is_pos = 1");
$extra_stmt->execute([$s['id']]);
$extra = $extra_stmt->fetch();
?>
Tax Amount:
OMR
Discount:
OMR
Cash Sale:
OMR
Credit Card:
OMR
Credit:
OMR
Bank Transfer:
OMR
Total Sale:
OMR
Cash Reconciliation
Opening Balance:
OMR
(+) Cash Sale:
OMR
Expected Cash:
OMR
Actual Cash:
OMR
Balance:
OMR
Expected Cash: OMR
Actual Cash: OMR
Notes: