<h1>Debug Ledger</h1>Supplier ID: 21<br>Start: 2025-10-01<br>End Query: 2026-03-20 23:59:59<br><h2>Supplier Info</h2>Array
(
    [id] => 21
    [type] => supplier
    [name] => Fahad
    [email] => nfen@iesngis.sog
    [image] => assets/uploads/contacts/698cfc158d32a_cd6194ef.jpg
    [phone] => 01745258963
    [company_name] => nenfewdn
    [address] => oujlbnj
    [credit_limit] => 0.00
    [created_at] => 2026-02-10 16:50:41
    [opening_balance] => 5500.00
    [balance] => 1000.00
    [opening_balance_date] => 
)
<h2>Raw Purchases for Supplier 21</h2><pre>Array
(
    [0] => Array
        (
            [id] => 11
            [purchase_date] => 0000-00-00
            [total_amount] => 2100.00
        )

)
</pre><h2>Refined Query Test</h2>Query: SELECT id, purchase_date as date, reference_no as ref, 'Purchase' as type, total_amount as amount FROM purchases WHERE supplier_id = ? AND purchase_date BETWEEN ? AND ? ORDER BY purchase_date <br>Found 0 records.<br><pre>Array
(
)
</pre><h2>Payment Query Test</h2>Found 1 payments.<br><pre>Array
(
    [0] => Array
        (
            [date] => 2026-02-14
            [amount] => 1100.00
            [description] => Purchase Payment Ref: PO-20260214-8053
            [reference_no] => PO-20260214-8053
        )

)
</pre>