[08-Mar-2026 22:06:42 Europe/Nicosia] Branch ID: 18
[08-Mar-2026 22:06:42 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[08-Mar-2026 22:06:42 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[08-Mar-2026 22:06:42 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[08-Mar-2026 22:06:42 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[08-Mar-2026 22:06:42 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[08-Mar-2026 22:06:42 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[08-Mar-2026 22:06:42 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND e.close = 1 AND e.status = 1
[08-Mar-2026 22:06:42 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 13587
    [count] => 23
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[08-Mar-2026 22:06:42 Europe/Nicosia] Total Inflow: 13587, Total Outflow: 0, Net Cash: 13587
[09-Mar-2026 00:04:00 Europe/Nicosia] Branch ID: 18
[09-Mar-2026 00:04:00 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[09-Mar-2026 00:04:00 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[09-Mar-2026 00:04:00 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[09-Mar-2026 00:04:00 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[09-Mar-2026 00:04:00 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[09-Mar-2026 00:04:00 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[09-Mar-2026 00:04:00 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-08 08:00' AND '2026-03-09 03:00'
    AND e.close = 1 AND e.status = 1
[09-Mar-2026 00:04:00 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 19491
    [count] => 28
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 00:04:00 Europe/Nicosia] Total Inflow: 19491, Total Outflow: 0, Net Cash: 19491
[09-Mar-2026 23:47:24 Europe/Nicosia] Branch ID: 18
[09-Mar-2026 23:47:24 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[09-Mar-2026 23:47:24 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[09-Mar-2026 23:47:24 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[09-Mar-2026 23:47:24 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[09-Mar-2026 23:47:24 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[09-Mar-2026 23:47:24 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[09-Mar-2026 23:47:24 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-09 08:00' AND '2026-03-10 03:00'
    AND e.close = 1 AND e.status = 1
[09-Mar-2026 23:47:24 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 24571
    [count] => 28
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 700
    [count] => 2
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[09-Mar-2026 23:47:24 Europe/Nicosia] Total Inflow: 25271, Total Outflow: 0, Net Cash: 25271
[10-Mar-2026 12:46:26 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 12:46:26 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 12:46:26 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 12:46:26 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 12:46:26 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 12:46:26 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 12:46:26 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 12:46:26 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 12:46:26 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 125
    [count] => 1
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:46:26 Europe/Nicosia] Total Inflow: 125, Total Outflow: 0, Net Cash: 125
[10-Mar-2026 12:55:52 Europe/Nicosia] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'branch_name' in 'field list' in /home/gjcorder/gloung.com/branch/close_register/close_register_process.php:26
Stack trace:
#0 /home/gjcorder/gloung.com/branch/close_register/close_register_process.php(26): mysqli->prepare('SELECT branch_n...')
#1 /home/gjcorder/gloung.com/branch/close_register/close_register_process.php(396): sendCloseRegisterEmails(Object(mysqli), 26, Array)
#2 {main}
  thrown in /home/gjcorder/gloung.com/branch/close_register/close_register_process.php on line 26
[10-Mar-2026 12:56:37 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 12:56:37 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 12:56:37 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 12:56:37 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 12:56:37 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 12:56:37 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 12:56:37 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 12:56:37 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 12:56:37 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 225
    [count] => 2
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 12:56:37 Europe/Nicosia] Total Inflow: 225, Total Outflow: 0, Net Cash: 225
[10-Mar-2026 16:19:31 Europe/Nicosia] Email sending status for report 28: Success
[10-Mar-2026 16:19:31 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 16:19:31 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 16:19:31 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 16:19:31 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:19:31 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 16:19:31 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 16:19:31 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:19:31 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 16:19:31 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 4002
    [count] => 11
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:19:31 Europe/Nicosia] Total Inflow: 4002, Total Outflow: 0, Net Cash: 4002
[10-Mar-2026 16:25:40 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 16:25:40 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 16:25:40 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 16:25:40 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:25:40 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 16:25:40 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 16:25:40 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:25:40 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 16:25:40 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 4242
    [count] => 12
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:25:40 Europe/Nicosia] Total Inflow: 4242, Total Outflow: 0, Net Cash: 4242
[10-Mar-2026 16:32:56 Europe/Nicosia] PHP Warning:  Undefined variable $closed_by_name in /home/gjcorder/gloung.com/branch/close_register/close_register_process.php on line 125
[10-Mar-2026 16:32:57 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 16:32:57 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 16:32:57 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 16:32:57 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:32:57 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 16:32:57 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 16:32:57 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:32:57 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 16:32:57 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 4842
    [count] => 13
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:32:57 Europe/Nicosia] Total Inflow: 4842, Total Outflow: 0, Net Cash: 4842
[10-Mar-2026 16:36:09 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 16:36:09 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 16:36:09 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 16:36:09 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:36:09 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 16:36:09 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 16:36:09 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:36:09 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 16:36:09 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 4842
    [count] => 13
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:36:09 Europe/Nicosia] Total Inflow: 4842, Total Outflow: 0, Net Cash: 4842
[10-Mar-2026 16:38:43 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 16:38:43 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 16:38:43 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 16:38:43 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:38:43 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 16:38:43 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 16:38:43 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:38:43 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 16:38:43 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 4842
    [count] => 13
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:38:43 Europe/Nicosia] Total Inflow: 4842, Total Outflow: 0, Net Cash: 4842
[10-Mar-2026 16:41:20 Europe/Nicosia] Branch ID: 18
[10-Mar-2026 16:41:20 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[10-Mar-2026 16:41:20 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[10-Mar-2026 16:41:20 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:41:20 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[10-Mar-2026 16:41:20 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[10-Mar-2026 16:41:20 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[10-Mar-2026 16:41:20 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[10-Mar-2026 16:41:20 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 4842
    [count] => 13
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[10-Mar-2026 16:41:20 Europe/Nicosia] Total Inflow: 4842, Total Outflow: 0, Net Cash: 4842
[11-Mar-2026 00:13:06 Europe/Nicosia] Branch ID: 18
[11-Mar-2026 00:13:06 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[11-Mar-2026 00:13:06 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[11-Mar-2026 00:13:06 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[11-Mar-2026 00:13:06 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[11-Mar-2026 00:13:06 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[11-Mar-2026 00:13:06 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[11-Mar-2026 00:13:06 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-10 08:00' AND '2026-03-11 03:00'
    AND e.close = 1 AND e.status = 1
[11-Mar-2026 00:13:06 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 22173
    [count] => 44
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 1470
    [count] => 2
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[11-Mar-2026 00:13:06 Europe/Nicosia] Total Inflow: 23643, Total Outflow: 0, Net Cash: 23643
[12-Mar-2026 00:23:01 Europe/Nicosia] Branch ID: 18
[12-Mar-2026 00:23:01 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[12-Mar-2026 00:23:01 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[12-Mar-2026 00:23:01 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[12-Mar-2026 00:23:01 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[12-Mar-2026 00:23:01 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[12-Mar-2026 00:23:01 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[12-Mar-2026 00:23:01 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-11 08:00' AND '2026-03-12 03:00'
    AND e.close = 1 AND e.status = 1
[12-Mar-2026 00:23:01 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 33336
    [count] => 48
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 400
    [count] => 2
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 00:23:01 Europe/Nicosia] Total Inflow: 33736, Total Outflow: 0, Net Cash: 33736
[12-Mar-2026 23:52:41 Europe/Nicosia] Branch ID: 18
[12-Mar-2026 23:52:41 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[12-Mar-2026 23:52:41 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[12-Mar-2026 23:52:41 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[12-Mar-2026 23:52:41 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[12-Mar-2026 23:52:41 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[12-Mar-2026 23:52:41 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[12-Mar-2026 23:52:41 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-12 08:00' AND '2026-03-13 03:00'
    AND e.close = 1 AND e.status = 1
[12-Mar-2026 23:52:41 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 33077.5
    [count] => 50
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[12-Mar-2026 23:52:41 Europe/Nicosia] Total Inflow: 33077.5, Total Outflow: 0, Net Cash: 33077.5
[14-Mar-2026 01:11:28 Europe/Nicosia] Branch ID: 18
[14-Mar-2026 01:11:28 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[14-Mar-2026 01:11:28 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[14-Mar-2026 01:11:28 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[14-Mar-2026 01:11:28 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[14-Mar-2026 01:11:28 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[14-Mar-2026 01:11:28 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[14-Mar-2026 01:11:28 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-13 08:00' AND '2026-03-14 03:00'
    AND e.close = 1 AND e.status = 1
[14-Mar-2026 01:11:28 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 56813.5
    [count] => 85
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 1160
    [count] => 4
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[14-Mar-2026 01:11:28 Europe/Nicosia] Total Inflow: 57973.5, Total Outflow: 0, Net Cash: 57973.5
[15-Mar-2026 01:00:48 Europe/Nicosia] Branch ID: 18
[15-Mar-2026 01:00:48 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[15-Mar-2026 01:00:48 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[15-Mar-2026 01:00:48 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[15-Mar-2026 01:00:48 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[15-Mar-2026 01:00:48 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[15-Mar-2026 01:00:48 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[15-Mar-2026 01:00:48 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-14 08:00' AND '2026-03-15 03:00'
    AND e.close = 1 AND e.status = 1
[15-Mar-2026 01:00:48 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 36983
    [count] => 54
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 6245
    [count] => 6
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 01:00:48 Europe/Nicosia] Total Inflow: 43228, Total Outflow: 0, Net Cash: 43228
[15-Mar-2026 23:54:57 Europe/Nicosia] Branch ID: 18
[15-Mar-2026 23:54:57 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[15-Mar-2026 23:54:57 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[15-Mar-2026 23:54:57 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[15-Mar-2026 23:54:57 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[15-Mar-2026 23:54:57 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[15-Mar-2026 23:54:57 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[15-Mar-2026 23:54:57 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-15 08:00' AND '2026-03-16 03:00'
    AND e.close = 1 AND e.status = 1
[15-Mar-2026 23:54:57 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 15910.5
    [count] => 30
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[15-Mar-2026 23:54:57 Europe/Nicosia] Total Inflow: 15910.5, Total Outflow: 0, Net Cash: 15910.5
[18-Mar-2026 00:31:19 Europe/Nicosia] Branch ID: 18
[18-Mar-2026 00:31:19 Europe/Nicosia] Sales Inflow Query: SELECT 
    COALESCE(SUM(s.sale_prod_paid), 0) as total,
    COUNT(DISTINCT s.sale_prod_id) as count
    FROM sale_products s
    WHERE s.sale_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
    AND s.sale_prod_paid > 0
[18-Mar-2026 00:31:19 Europe/Nicosia] Sale Pay Inflow Query: SELECT 
    COALESCE(SUM(sp.sale_pay_amount), 0) as total,
    COUNT(DISTINCT sp.sale_pay_id) as count
    FROM sale_payment sp
    JOIN sale_products s ON sp.sale_pay_sale_prod_id = s.sale_prod_id
    WHERE sp.sale_payment_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND sp.close = 1 AND sp.status = 1
    AND s.close = 1 AND s.status = 1
    AND s.sale_prod_status = 'Sold'
[18-Mar-2026 00:31:19 Europe/Nicosia] Purchase Returns Inflow Query: SELECT 
    COALESCE(SUM(pr.purchase_return_qty * pr.purchase_return_unit_price), 0) as total,
    COUNT(DISTINCT pr.purchase_return_id) as count
    FROM purchase_return pr
    JOIN purchase p ON pr.purchase_return_purchase_id = p.purchase_id
    WHERE pr.purchase_return_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND pr.close = 1 AND pr.status = 1
    AND p.close = 1 AND p.status = 1
[18-Mar-2026 00:31:19 Europe/Nicosia] Sales Returns Outflow Query: SELECT 
    COALESCE(SUM(sr.sale_return_qty * sr.sale_return_unit_price), 0) as total,
    COUNT(DISTINCT sr.sale_return_id) as count
    FROM sale_return sr
    JOIN sale_products s ON sr.sale_return_reference = s.sale_prod_id
    WHERE sr.sale_return_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND sr.close = 1 AND sr.status = 1
    AND s.close = 1 AND s.status = 1
[18-Mar-2026 00:31:19 Europe/Nicosia] Purchase Outflow Query: SELECT 
    COALESCE(SUM(p.purchase_paid_amount), 0) as total,
    COUNT(DISTINCT p.purchase_id) as count
    FROM purchase p
    WHERE p.purchase_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND p.close = 1 AND p.status = 1
    AND p.purchase_paid_amount > 0
[18-Mar-2026 00:31:19 Europe/Nicosia] Purchase Pay Outflow Query: SELECT 
    COALESCE(SUM(pp.purchase_pay_amount), 0) as total,
    COUNT(DISTINCT pp.purchase_pay_id) as count
    FROM purchase_payments pp
    JOIN purchase p ON pp.purchase_pay_purchase_id = p.purchase_id
    WHERE pp.purchase_payment_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND pp.close = 1 AND pp.status = 1
    AND p.close = 1 AND p.status = 1
[18-Mar-2026 00:31:19 Europe/Nicosia] Expense Outflow Query: SELECT 
    COALESCE(SUM(e.exp_amount), 0) as total,
    COUNT(DISTINCT e.exp_id) as count
    FROM expenses e
    WHERE e.expense_created_at BETWEEN '2026-03-17 08:00' AND '2026-03-18 03:00'
    AND e.close = 1 AND e.status = 1
[18-Mar-2026 00:31:19 Europe/Nicosia] Sales Inflow: Array
(
    [total] => 30640
    [count] => 34
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Sale Pay Inflow: Array
(
    [total] => 125
    [count] => 2
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Purchase Returns Inflow: Array
(
    [total] => 0
    [count] => 0
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Sales Returns Outflow: Array
(
    [total] => 0
    [count] => 0
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Purchase Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Purchase Pay Outflow: Array
(
    [total] => 0.00
    [count] => 0
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Expense Outflow: Array
(
    [total] => 0
    [count] => 0
)

[18-Mar-2026 00:31:19 Europe/Nicosia] Total Inflow: 30765, Total Outflow: 0, Net Cash: 30765
