[28-Jul-2025 12:57:53 Asia/Manila] Session data: {"user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[],"selected_customer":null}
[28-Jul-2025 12:57:53 Asia/Manila] Getting sale details for sale_id: 3010
[28-Jul-2025 12:57:53 Asia/Manila] Branch code: m001
[28-Jul-2025 12:57:53 Asia/Manila] Sale items table: m001_sale_items
[28-Jul-2025 12:57:53 Asia/Manila] Items table: m001_items
[28-Jul-2025 12:57:53 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[28-Jul-2025 12:57:53 Asia/Manila] Found sale: {"sale_id":3010,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"100.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 12:34:24","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[28-Jul-2025 12:57:53 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[28-Jul-2025 12:57:53 Asia/Manila] Found items: [{"sale_item_id":4084,"sale_id":3010,"item_id":13,"quantity":"5.00","price":"20.00","original_price":"20.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"100.00","items_name":"2 - Budget Cuts","sell_type":"unit"}]
[28-Jul-2025 12:57:53 Asia/Manila] Found extra charges: []
[28-Jul-2025 12:57:53 Asia/Manila] Final response data for sale ID 3010:
[28-Jul-2025 12:57:53 Asia/Manila] Sale data: {"sale_id":3010,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"100.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 12:34:24","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[28-Jul-2025 12:57:53 Asia/Manila] Extra charges: []
[28-Jul-2025 12:57:57 Asia/Manila] AJAX action received: check_operation_allowed
[28-Jul-2025 12:57:57 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[28-Jul-2025 12:57:57 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[28-Jul-2025 12:57:57 Asia/Manila] Current shift behavior setting: block
[28-Jul-2025 12:57:57 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[28-Jul-2025 13:12:40 Asia/Manila] Session data: {"user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[28-Jul-2025 13:12:40 Asia/Manila] Getting sale details for sale_id: 3007
[28-Jul-2025 13:12:40 Asia/Manila] Branch code: m001
[28-Jul-2025 13:12:40 Asia/Manila] Sale items table: m001_sale_items
[28-Jul-2025 13:12:40 Asia/Manila] Items table: m001_items
[28-Jul-2025 13:12:40 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[28-Jul-2025 13:12:40 Asia/Manila] Found sale: {"sale_id":3007,"user_id":9,"customer_id":13,"subtotal":"60.00","tax":"0.00","total":"60.00","payment_method":"credit","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 12:06:51","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":13,"customer_name":"Ching Lacson","customer_balance":"3326.77","transaction_id":151,"credit_amount":"60.00","staff_name":"Cashier"}
[28-Jul-2025 13:12:40 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[28-Jul-2025 13:12:40 Asia/Manila] Found items: [{"sale_item_id":4080,"sale_id":3007,"item_id":21,"quantity":"4.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"60.00","items_name":"6 - Rice","sell_type":"unit"}]
[28-Jul-2025 13:12:40 Asia/Manila] Found extra charges: []
[28-Jul-2025 13:12:40 Asia/Manila] Final response data for sale ID 3007:
[28-Jul-2025 13:12:40 Asia/Manila] Sale data: {"sale_id":3007,"user_id":9,"customer_id":13,"subtotal":"60.00","tax":"0.00","total":"60.00","payment_method":"credit","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 12:06:51","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":13,"customer_name":"Ching Lacson","customer_balance":"3326.77","transaction_id":151,"credit_amount":"60.00","staff_name":"Cashier"}
[28-Jul-2025 13:12:40 Asia/Manila] Extra charges: []
[28-Jul-2025 13:12:41 Asia/Manila] AJAX action received: check_operation_allowed
[28-Jul-2025 13:12:41 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[28-Jul-2025 13:12:41 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[28-Jul-2025 13:12:41 Asia/Manila] Current shift behavior setting: block
[28-Jul-2025 13:12:41 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[28-Jul-2025 13:12:45 Asia/Manila] AJAX action received: check_operation_allowed
[28-Jul-2025 13:12:45 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[28-Jul-2025 13:12:45 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[28-Jul-2025 13:12:45 Asia/Manila] Current shift behavior setting: block
[28-Jul-2025 13:12:45 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[28-Jul-2025 13:12:55 Asia/Manila] Session data: {"user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[28-Jul-2025 13:12:55 Asia/Manila] Getting sale details for sale_id: 3007
[28-Jul-2025 13:12:55 Asia/Manila] Branch code: m001
[28-Jul-2025 13:12:55 Asia/Manila] Sale items table: m001_sale_items
[28-Jul-2025 13:12:55 Asia/Manila] Items table: m001_items
[28-Jul-2025 13:12:55 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[28-Jul-2025 13:12:55 Asia/Manila] Found sale: {"sale_id":3007,"user_id":9,"customer_id":13,"subtotal":"60.00","tax":"0.00","total":"60.00","payment_method":"credit","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 12:06:51","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":13,"customer_name":"Ching Lacson","customer_balance":"3326.77","transaction_id":151,"credit_amount":"60.00","staff_name":"Cashier"}
[28-Jul-2025 13:12:55 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[28-Jul-2025 13:12:55 Asia/Manila] Found items: [{"sale_item_id":4080,"sale_id":3007,"item_id":21,"quantity":"4.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"60.00","items_name":"6 - Rice","sell_type":"unit"}]
[28-Jul-2025 13:12:55 Asia/Manila] Found extra charges: []
[28-Jul-2025 13:12:55 Asia/Manila] Final response data for sale ID 3007:
[28-Jul-2025 13:12:55 Asia/Manila] Sale data: {"sale_id":3007,"user_id":9,"customer_id":13,"subtotal":"60.00","tax":"0.00","total":"60.00","payment_method":"credit","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 12:06:51","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":13,"customer_name":"Ching Lacson","customer_balance":"3326.77","transaction_id":151,"credit_amount":"60.00","staff_name":"Cashier"}
[28-Jul-2025 13:12:55 Asia/Manila] Extra charges: []
[28-Jul-2025 13:13:15 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[28-Jul-2025 13:13:15 Asia/Manila] Starting void operation for sale #3007
[28-Jul-2025 13:13:15 Asia/Manila] Getting sale snapshot for sale #3007
[28-Jul-2025 13:13:15 Asia/Manila] Sale total: 60
[28-Jul-2025 13:13:15 Asia/Manila] Updating sale status to voided
[28-Jul-2025 13:13:15 Asia/Manila] Processing credit transaction reversal
[28-Jul-2025 13:13:15 Asia/Manila] Processing stock restoration
[28-Jul-2025 13:13:15 Asia/Manila] Found 1 items to restore stock for
[28-Jul-2025 13:13:15 Asia/Manila] Processing item 21 - quantity: 4.00, sell_type: unit, track_inventory: 1
[28-Jul-2025 13:13:15 Asia/Manila] Restoring 4.00 units to regular item 21
[28-Jul-2025 13:13:15 Asia/Manila] Logging audit trail
[28-Jul-2025 13:13:15 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[28-Jul-2025 13:13:15 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[28-Jul-2025 13:13:15 Asia/Manila] Warning: Failed to log audit trail for voided sale #3007
[28-Jul-2025 13:13:15 Asia/Manila] Committing transaction
[28-Jul-2025 13:13:15 Asia/Manila] Void operation completed successfully for sale #3007
[28-Jul-2025 13:57:10 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"1"}, GET: []
[28-Jul-2025 14:13:53 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"0"}, GET: []
[28-Jul-2025 14:14:18 Asia/Manila] Session data: {"user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[28-Jul-2025 14:14:18 Asia/Manila] Getting sale details for sale_id: 3020
[28-Jul-2025 14:14:18 Asia/Manila] Branch code: m001
[28-Jul-2025 14:14:18 Asia/Manila] Sale items table: m001_sale_items
[28-Jul-2025 14:14:18 Asia/Manila] Items table: m001_items
[28-Jul-2025 14:14:18 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[28-Jul-2025 14:14:18 Asia/Manila] Found sale: {"sale_id":3020,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"90.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 14:13:57","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[28-Jul-2025 14:14:18 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[28-Jul-2025 14:14:18 Asia/Manila] Found items: [{"sale_item_id":4097,"sale_id":3020,"item_id":11,"quantity":"3.00","price":"30.00","original_price":"30.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"90.00","items_name":"1 - Value Cuts","sell_type":"unit"}]
[28-Jul-2025 14:14:18 Asia/Manila] Found extra charges: []
[28-Jul-2025 14:14:18 Asia/Manila] Final response data for sale ID 3020:
[28-Jul-2025 14:14:18 Asia/Manila] Sale data: {"sale_id":3020,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"90.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 14:13:57","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[28-Jul-2025 14:14:18 Asia/Manila] Extra charges: []
[28-Jul-2025 14:14:23 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[28-Jul-2025 14:14:23 Asia/Manila] Starting void operation for sale #3020
[28-Jul-2025 14:14:23 Asia/Manila] Getting sale snapshot for sale #3020
[28-Jul-2025 14:14:23 Asia/Manila] Sale total: 90
[28-Jul-2025 14:14:23 Asia/Manila] Updating sale status to voided
[28-Jul-2025 14:14:23 Asia/Manila] Processing stock restoration
[28-Jul-2025 14:14:23 Asia/Manila] Found 1 items to restore stock for
[28-Jul-2025 14:14:23 Asia/Manila] Processing item 11 - quantity: 3.00, sell_type: unit, track_inventory: 1
[28-Jul-2025 14:14:23 Asia/Manila] Restoring 3.00 units to regular item 11
[28-Jul-2025 14:14:23 Asia/Manila] Processing cash movement for voided sale
[28-Jul-2025 14:14:23 Asia/Manila] Target cashier ID: 9
[28-Jul-2025 14:14:23 Asia/Manila] Checking shift behavior
[28-Jul-2025 14:14:23 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[28-Jul-2025 14:14:23 Asia/Manila] Ensuring shift exists for cashier 9
[28-Jul-2025 14:14:23 Asia/Manila] Recording sale movement with amount: -90
[28-Jul-2025 14:14:23 Asia/Manila] Logging audit trail
[28-Jul-2025 14:14:23 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[28-Jul-2025 14:14:23 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[28-Jul-2025 14:14:23 Asia/Manila] Warning: Failed to log audit trail for voided sale #3020
[28-Jul-2025 14:14:23 Asia/Manila] Committing transaction
[28-Jul-2025 14:14:23 Asia/Manila] Void operation completed successfully for sale #3020
[28-Jul-2025 14:24:25 Asia/Manila] AJAX action received: get_shift_summary
[28-Jul-2025 14:24:25 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[28-Jul-2025 14:24:25 Asia/Manila] AJAX action received: get_movements
[28-Jul-2025 14:24:25 Asia/Manila] AJAX action received: get_denominations
[28-Jul-2025 14:24:26 Asia/Manila] AJAX action received: get_denominations
[28-Jul-2025 14:24:26 Asia/Manila] AJAX action received: get_shift_summary
[28-Jul-2025 14:24:26 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=2
[28-Jul-2025 14:24:26 Asia/Manila] Error in cash_flow.php: No shift found for this date
[28-Jul-2025 14:24:26 Asia/Manila] AJAX action received: get_movements
[28-Jul-2025 19:33:58 Asia/Manila] Session data: {"redirect_url":"\/pos\/items.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[28-Jul-2025 19:33:58 Asia/Manila] Getting sale details for sale_id: 3052
[28-Jul-2025 19:33:58 Asia/Manila] Branch code: m001
[28-Jul-2025 19:33:58 Asia/Manila] Sale items table: m001_sale_items
[28-Jul-2025 19:33:58 Asia/Manila] Items table: m001_items
[28-Jul-2025 19:33:58 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[28-Jul-2025 19:33:58 Asia/Manila] Found sale: {"sale_id":3052,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"80.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 19:33:47","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[28-Jul-2025 19:33:58 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[28-Jul-2025 19:33:58 Asia/Manila] Found items: [{"sale_item_id":4137,"sale_id":3052,"item_id":17,"quantity":"1.00","price":"50.00","original_price":"50.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"50.00","items_name":"Chicken Neck","sell_type":"unit"},{"sale_item_id":4138,"sale_id":3052,"item_id":11,"quantity":"1.00","price":"30.00","original_price":"30.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"30.00","items_name":"1 - Value Cuts","sell_type":"unit"}]
[28-Jul-2025 19:33:58 Asia/Manila] Found extra charges: []
[28-Jul-2025 19:33:58 Asia/Manila] Final response data for sale ID 3052:
[28-Jul-2025 19:33:58 Asia/Manila] Sale data: {"sale_id":3052,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"80.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-28 19:33:47","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[28-Jul-2025 19:33:58 Asia/Manila] Extra charges: []
[28-Jul-2025 19:34:08 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[28-Jul-2025 19:34:08 Asia/Manila] Starting void operation for sale #3052
[28-Jul-2025 19:34:08 Asia/Manila] Getting sale snapshot for sale #3052
[28-Jul-2025 19:34:08 Asia/Manila] Sale total: 80
[28-Jul-2025 19:34:08 Asia/Manila] Updating sale status to voided
[28-Jul-2025 19:34:08 Asia/Manila] Processing stock restoration
[28-Jul-2025 19:34:08 Asia/Manila] Found 2 items to restore stock for
[28-Jul-2025 19:34:08 Asia/Manila] Processing item 17 - quantity: 1.00, sell_type: unit, track_inventory: 1
[28-Jul-2025 19:34:08 Asia/Manila] Restoring 1.00 units to regular item 17
[28-Jul-2025 19:34:08 Asia/Manila] Processing item 11 - quantity: 1.00, sell_type: unit, track_inventory: 1
[28-Jul-2025 19:34:08 Asia/Manila] Restoring 1.00 units to regular item 11
[28-Jul-2025 19:34:08 Asia/Manila] Processing cash movement for voided sale
[28-Jul-2025 19:34:08 Asia/Manila] Target cashier ID: 9
[28-Jul-2025 19:34:08 Asia/Manila] Checking shift behavior
[28-Jul-2025 19:34:08 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[28-Jul-2025 19:34:08 Asia/Manila] Ensuring shift exists for cashier 9
[28-Jul-2025 19:34:08 Asia/Manila] Recording sale movement with amount: -80
[28-Jul-2025 19:34:08 Asia/Manila] Logging audit trail
[28-Jul-2025 19:34:08 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[28-Jul-2025 19:34:08 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[28-Jul-2025 19:34:08 Asia/Manila] Warning: Failed to log audit trail for voided sale #3052
[28-Jul-2025 19:34:08 Asia/Manila] Committing transaction
[28-Jul-2025 19:34:08 Asia/Manila] Void operation completed successfully for sale #3052
[28-Jul-2025 20:18:43 Asia/Manila] AJAX action received: get_denominations
[28-Jul-2025 20:18:44 Asia/Manila] AJAX action received: get_movements
[28-Jul-2025 20:18:44 Asia/Manila] AJAX action received: get_shift_summary
[28-Jul-2025 20:18:44 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[28-Jul-2025 20:19:26 Asia/Manila] AJAX action received: get_denominations
[28-Jul-2025 20:19:26 Asia/Manila] AJAX action received: get_movements
[28-Jul-2025 20:19:27 Asia/Manila] AJAX action received: get_shift_summary
[28-Jul-2025 20:19:27 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[28-Jul-2025 20:20:27 Asia/Manila] AJAX action received: get_shift_status
[28-Jul-2025 20:21:27 Asia/Manila] AJAX action received: get_shift_status
[28-Jul-2025 20:22:27 Asia/Manila] AJAX action received: get_shift_status
[28-Jul-2025 20:23:27 Asia/Manila] AJAX action received: get_shift_status
[28-Jul-2025 20:23:29 Asia/Manila] AJAX action received: save_cash_count
[28-Jul-2025 20:23:29 Asia/Manila] AJAX action received: save_cash_count
[28-Jul-2025 20:23:29 Asia/Manila] AJAX action received: close_shift
[28-Jul-2025 20:23:30 Asia/Manila] AJAX action received: close_shift
[28-Jul-2025 20:23:30 Asia/Manila] Error in cash_flow.php: No open shift found for this date
[28-Jul-2025 20:23:34 Asia/Manila] AJAX action received: get_shift_summary
[28-Jul-2025 20:23:34 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[28-Jul-2025 20:23:34 Asia/Manila] AJAX action received: get_denominations
[28-Jul-2025 20:23:34 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 05:35:35 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 05:35:35 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=2
[29-Jul-2025 05:35:35 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 05:35:35 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 05:35:35 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 05:35:50 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 05:35:50 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 05:35:50 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 05:35:50 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 05:35:50 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 05:35:55 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 05:35:55 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 05:35:55 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[29-Jul-2025 05:39:58 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 05:39:58 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=2
[29-Jul-2025 05:39:58 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 05:39:58 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 05:39:58 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:08:21 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:08:21 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[29-Jul-2025 06:08:21 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:08:33 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:08:33 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=2
[29-Jul-2025 06:08:33 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 06:08:33 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:08:34 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:08:36 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:08:36 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:08:36 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 06:08:36 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:08:36 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:08:40 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:08:40 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-28, cashier_id=9
[29-Jul-2025 06:08:40 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:14:43 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:14:43 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:14:43 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:14:43 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:14:43 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 06:17:10 Asia/Manila] AJAX action received: save_cash_count
[29-Jul-2025 06:17:10 Asia/Manila] AJAX action received: open_shift
[29-Jul-2025 06:17:11 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:17:11 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:17:11 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:17:11 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:17:47 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:17:47 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:17:47 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:17:47 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:17:58 Asia/Manila] Data Management Handler - Action: list_backups, POST: [], GET: {"action":"list_backups"}
[29-Jul-2025 06:17:59 Asia/Manila] Data Management Handler - Action: get_available_tables, POST: [], GET: {"action":"get_available_tables"}
[29-Jul-2025 06:17:59 Asia/Manila] Available tables for branch m001: ["Core Settings","Products & Inventory","Sales & Transactions","Expenses & Operations","Cash Management","Customer Management","Other Tables"]
[29-Jul-2025 06:19:29 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[29-Jul-2025 06:19:29 Asia/Manila] Getting sale details for sale_id: 3056
[29-Jul-2025 06:19:29 Asia/Manila] Branch code: m001
[29-Jul-2025 06:19:29 Asia/Manila] Sale items table: m001_sale_items
[29-Jul-2025 06:19:29 Asia/Manila] Items table: m001_items
[29-Jul-2025 06:19:29 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[29-Jul-2025 06:19:29 Asia/Manila] Found sale: {"sale_id":3056,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"240.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-29 06:18:17","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[29-Jul-2025 06:19:29 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[29-Jul-2025 06:19:29 Asia/Manila] Found items: [{"sale_item_id":4143,"sale_id":3056,"item_id":12,"quantity":"1.20","price":"200.00","original_price":"200.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"240.00","items_name":"Magnolia Breast","sell_type":"fraction"}]
[29-Jul-2025 06:19:29 Asia/Manila] Found extra charges: []
[29-Jul-2025 06:19:29 Asia/Manila] Final response data for sale ID 3056:
[29-Jul-2025 06:19:29 Asia/Manila] Sale data: {"sale_id":3056,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"240.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-29 06:18:17","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[29-Jul-2025 06:19:29 Asia/Manila] Extra charges: []
[29-Jul-2025 06:19:31 Asia/Manila] AJAX action received: check_operation_allowed
[29-Jul-2025 06:19:31 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[29-Jul-2025 06:19:31 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[29-Jul-2025 06:19:31 Asia/Manila] Current shift behavior setting: block
[29-Jul-2025 06:19:31 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[29-Jul-2025 06:19:43 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[29-Jul-2025 06:19:43 Asia/Manila] Getting sale details for sale_id: 3056
[29-Jul-2025 06:19:43 Asia/Manila] Branch code: m001
[29-Jul-2025 06:19:43 Asia/Manila] Sale items table: m001_sale_items
[29-Jul-2025 06:19:43 Asia/Manila] Items table: m001_items
[29-Jul-2025 06:19:43 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[29-Jul-2025 06:19:43 Asia/Manila] Found sale: {"sale_id":3056,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"240.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-29 06:18:17","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[29-Jul-2025 06:19:43 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[29-Jul-2025 06:19:43 Asia/Manila] Found items: [{"sale_item_id":4143,"sale_id":3056,"item_id":12,"quantity":"1.20","price":"200.00","original_price":"200.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"240.00","items_name":"Magnolia Breast","sell_type":"fraction"}]
[29-Jul-2025 06:19:43 Asia/Manila] Found extra charges: []
[29-Jul-2025 06:19:43 Asia/Manila] Final response data for sale ID 3056:
[29-Jul-2025 06:19:43 Asia/Manila] Sale data: {"sale_id":3056,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"240.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-29 06:18:17","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[29-Jul-2025 06:19:43 Asia/Manila] Extra charges: []
[29-Jul-2025 06:19:54 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[29-Jul-2025 06:19:54 Asia/Manila] Starting void operation for sale #3056
[29-Jul-2025 06:19:54 Asia/Manila] Getting sale snapshot for sale #3056
[29-Jul-2025 06:19:54 Asia/Manila] Sale total: 240
[29-Jul-2025 06:19:54 Asia/Manila] Updating sale status to voided
[29-Jul-2025 06:19:54 Asia/Manila] Processing stock restoration
[29-Jul-2025 06:19:54 Asia/Manila] Found 1 items to restore stock for
[29-Jul-2025 06:19:54 Asia/Manila] Processing item 12 - quantity: 1.20, sell_type: fraction, track_inventory: 1
[29-Jul-2025 06:19:54 Asia/Manila] Restoring 1.20 units to regular item 12
[29-Jul-2025 06:19:54 Asia/Manila] Processing cash movement for voided sale
[29-Jul-2025 06:19:54 Asia/Manila] Target cashier ID: 9
[29-Jul-2025 06:19:54 Asia/Manila] Checking shift behavior
[29-Jul-2025 06:19:54 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[29-Jul-2025 06:19:54 Asia/Manila] Ensuring shift exists for cashier 9
[29-Jul-2025 06:19:54 Asia/Manila] Recording sale movement with amount: -240
[29-Jul-2025 06:19:54 Asia/Manila] Logging audit trail
[29-Jul-2025 06:19:54 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[29-Jul-2025 06:19:54 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[29-Jul-2025 06:19:54 Asia/Manila] Warning: Failed to log audit trail for voided sale #3056
[29-Jul-2025 06:19:54 Asia/Manila] Committing transaction
[29-Jul-2025 06:19:54 Asia/Manila] Void operation completed successfully for sale #3056
[29-Jul-2025 06:20:09 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:20:09 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:20:09 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:20:10 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:20:10 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:20:10 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:20:10 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:20:10 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:21:11 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 06:22:11 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 06:25:35 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 06:25:35 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 06:25:35 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 06:25:35 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 06:26:36 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 07:04:54 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 07:18:59 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 13:31:24 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[29-Jul-2025 13:31:24 Asia/Manila] Getting sale details for sale_id: 3095
[29-Jul-2025 13:31:24 Asia/Manila] Branch code: m001
[29-Jul-2025 13:31:24 Asia/Manila] Sale items table: m001_sale_items
[29-Jul-2025 13:31:24 Asia/Manila] Items table: m001_items
[29-Jul-2025 13:31:24 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[29-Jul-2025 13:31:24 Asia/Manila] Found sale: {"sale_id":3095,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"60.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-29 13:30:50","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[29-Jul-2025 13:31:24 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[29-Jul-2025 13:31:24 Asia/Manila] Found items: [{"sale_item_id":4201,"sale_id":3095,"item_id":11,"quantity":"2.00","price":"30.00","original_price":"30.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"60.00","items_name":"1 - Value Cuts","sell_type":"unit"}]
[29-Jul-2025 13:31:24 Asia/Manila] Found extra charges: []
[29-Jul-2025 13:31:24 Asia/Manila] Final response data for sale ID 3095:
[29-Jul-2025 13:31:24 Asia/Manila] Sale data: {"sale_id":3095,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"60.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-29 13:30:50","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[29-Jul-2025 13:31:24 Asia/Manila] Extra charges: []
[29-Jul-2025 13:31:42 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[29-Jul-2025 13:31:42 Asia/Manila] Starting void operation for sale #3095
[29-Jul-2025 13:31:42 Asia/Manila] Getting sale snapshot for sale #3095
[29-Jul-2025 13:31:42 Asia/Manila] Sale total: 60
[29-Jul-2025 13:31:42 Asia/Manila] Updating sale status to voided
[29-Jul-2025 13:31:42 Asia/Manila] Processing stock restoration
[29-Jul-2025 13:31:42 Asia/Manila] Found 1 items to restore stock for
[29-Jul-2025 13:31:42 Asia/Manila] Processing item 11 - quantity: 2.00, sell_type: unit, track_inventory: 1
[29-Jul-2025 13:31:42 Asia/Manila] Restoring 2.00 units to regular item 11
[29-Jul-2025 13:31:42 Asia/Manila] Processing cash movement for voided sale
[29-Jul-2025 13:31:42 Asia/Manila] Target cashier ID: 9
[29-Jul-2025 13:31:42 Asia/Manila] Checking shift behavior
[29-Jul-2025 13:31:42 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[29-Jul-2025 13:31:42 Asia/Manila] Ensuring shift exists for cashier 9
[29-Jul-2025 13:31:42 Asia/Manila] Recording sale movement with amount: -60
[29-Jul-2025 13:31:42 Asia/Manila] Logging audit trail
[29-Jul-2025 13:31:42 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[29-Jul-2025 13:31:42 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[29-Jul-2025 13:31:42 Asia/Manila] Warning: Failed to log audit trail for voided sale #3095
[29-Jul-2025 13:31:42 Asia/Manila] Committing transaction
[29-Jul-2025 13:31:42 Asia/Manila] Void operation completed successfully for sale #3095
[29-Jul-2025 13:33:11 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 13:33:12 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 13:33:12 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 13:33:12 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 13:34:43 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 13:34:43 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 13:34:43 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 13:34:43 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 17:28:24 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 17:28:24 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=2
[29-Jul-2025 17:28:24 Asia/Manila] Error in cash_flow.php: No shift found for this date
[29-Jul-2025 17:28:24 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 17:28:24 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 17:28:29 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 17:28:29 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 17:28:29 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 17:28:29 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 20:03:39 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 20:03:39 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 20:03:40 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 20:03:40 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 20:04:07 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 20:04:07 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 20:04:07 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 20:04:07 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 20:05:07 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 20:06:07 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 20:07:07 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 20:07:32 Asia/Manila] AJAX action received: save_cash_count
[29-Jul-2025 20:07:32 Asia/Manila] AJAX action received: close_shift
[29-Jul-2025 20:07:34 Asia/Manila] AJAX action received: get_shift_summary
[29-Jul-2025 20:07:34 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[29-Jul-2025 20:07:35 Asia/Manila] AJAX action received: get_denominations
[29-Jul-2025 20:07:35 Asia/Manila] AJAX action received: get_movements
[29-Jul-2025 20:08:35 Asia/Manila] AJAX action received: get_shift_status
[29-Jul-2025 20:09:35 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:27:57 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 06:27:58 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:27:58 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:27:58 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 06:27:58 Asia/Manila] Error in cash_flow.php: No shift found for this date
[30-Jul-2025 06:30:32 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:30:32 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:30:32 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[30-Jul-2025 06:31:01 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:31:01 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=2
[30-Jul-2025 06:31:01 Asia/Manila] Error in cash_flow.php: No shift found for this date
[30-Jul-2025 06:31:02 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 06:31:02 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:31:04 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:31:04 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 06:31:04 Asia/Manila] Error in cash_flow.php: No shift found for this date
[30-Jul-2025 06:31:04 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 06:31:04 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:31:06 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:31:06 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:31:06 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-29, cashier_id=9
[30-Jul-2025 06:34:04 Asia/Manila] AJAX action received: save_cash_count
[30-Jul-2025 06:34:05 Asia/Manila] AJAX action received: open_shift
[30-Jul-2025 06:34:05 Asia/Manila] Error in cash_flow.php: Shift already opened for this date
[30-Jul-2025 06:34:19 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:34:19 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 06:34:19 Asia/Manila] Error in cash_flow.php: No shift found for this date
[30-Jul-2025 06:34:19 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:34:19 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 06:35:48 Asia/Manila] AJAX action received: save_cash_count
[30-Jul-2025 06:35:48 Asia/Manila] AJAX action received: open_shift
[30-Jul-2025 06:35:49 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:35:49 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 06:35:49 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:35:49 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 06:36:30 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 06:36:30 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 06:36:31 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 06:36:31 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 06:37:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:38:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:39:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:40:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:41:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:42:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:43:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:44:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:45:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:46:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:47:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:48:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:49:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:50:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:51:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:52:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:53:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:54:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:55:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:56:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:57:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:58:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 06:59:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:00:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:01:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:02:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:03:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:04:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:05:31 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:05:53 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 07:05:53 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 07:05:53 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 07:05:53 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 07:06:19 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 07:06:19 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=2
[30-Jul-2025 07:06:19 Asia/Manila] Error in cash_flow.php: No shift found for this date
[30-Jul-2025 07:06:19 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 07:06:19 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 07:06:53 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:07:29 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 07:07:29 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=2
[30-Jul-2025 07:07:29 Asia/Manila] Error in cash_flow.php: No shift found for this date
[30-Jul-2025 07:07:29 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 07:07:29 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 07:07:50 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 07:07:50 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 07:07:51 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 07:07:51 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 07:07:53 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 07:11:51 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 08:47:09 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 08:48:45 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 09:36:46 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 09:38:45 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 09:38:45 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 09:38:46 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 09:38:46 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 13:10:05 Asia/Manila] Session data: {"redirect_url":"\/pos\/stock_management.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[30-Jul-2025 13:10:05 Asia/Manila] Getting sale details for sale_id: 3158
[30-Jul-2025 13:10:05 Asia/Manila] Branch code: m001
[30-Jul-2025 13:10:05 Asia/Manila] Sale items table: m001_sale_items
[30-Jul-2025 13:10:05 Asia/Manila] Items table: m001_items
[30-Jul-2025 13:10:05 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[30-Jul-2025 13:10:05 Asia/Manila] Found sale: {"sale_id":3158,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"60.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-30 12:40:57","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[30-Jul-2025 13:10:05 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[30-Jul-2025 13:10:05 Asia/Manila] Found items: [{"sale_item_id":4290,"sale_id":3158,"item_id":11,"quantity":"2.00","price":"30.00","original_price":"30.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"60.00","items_name":"1 - Value Cuts","sell_type":"unit"}]
[30-Jul-2025 13:10:05 Asia/Manila] Found extra charges: []
[30-Jul-2025 13:10:05 Asia/Manila] Final response data for sale ID 3158:
[30-Jul-2025 13:10:05 Asia/Manila] Sale data: {"sale_id":3158,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"60.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-30 12:40:57","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[30-Jul-2025 13:10:05 Asia/Manila] Extra charges: []
[30-Jul-2025 14:12:05 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"1"}, GET: []
[30-Jul-2025 14:17:06 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"0"}, GET: []
[30-Jul-2025 16:38:18 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 16:38:18 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 16:38:18 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 16:38:18 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 16:39:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:40:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:41:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:42:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:43:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:44:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:45:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:46:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:47:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:48:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:49:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:50:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:51:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:52:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:53:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:54:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:55:18 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 16:56:19 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 17:11:56 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 17:11:56 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 17:11:56 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 17:11:56 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 17:12:56 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 17:13:56 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 17:14:56 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 17:15:57 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 18:54:40 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"1"}, GET: []
[30-Jul-2025 18:54:41 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"0"}, GET: []
[30-Jul-2025 18:58:26 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 18:58:26 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 18:58:27 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 18:58:27 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 18:59:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:00:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:01:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:02:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:03:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:04:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:05:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:06:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:07:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:08:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 19:11:12 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"1"}, GET: []
[30-Jul-2025 19:17:29 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"0"}, GET: []
[30-Jul-2025 20:34:27 Asia/Manila] AJAX action received: get_movements
[30-Jul-2025 20:34:27 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 20:34:27 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 20:34:27 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 20:35:27 Asia/Manila] AJAX action received: get_shift_status
[30-Jul-2025 20:36:22 Asia/Manila] AJAX action received: save_cash_count
[30-Jul-2025 20:36:22 Asia/Manila] AJAX action received: close_shift
[30-Jul-2025 20:36:26 Asia/Manila] AJAX action received: get_denominations
[30-Jul-2025 20:36:26 Asia/Manila] AJAX action received: get_shift_summary
[30-Jul-2025 20:36:26 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[30-Jul-2025 20:36:26 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:17:44 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:17:44 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 06:17:44 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 06:17:44 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 06:17:44 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:17:46 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 06:17:46 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:17:46 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 06:17:46 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 06:17:46 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:17:49 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:17:49 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:17:49 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[31-Jul-2025 06:24:32 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:24:33 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 06:24:33 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:24:33 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 06:24:33 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 06:24:44 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:24:44 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:24:44 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-30, cashier_id=9
[31-Jul-2025 06:27:55 Asia/Manila] AJAX action received: save_cash_count
[31-Jul-2025 06:27:55 Asia/Manila] AJAX action received: open_shift
[31-Jul-2025 06:27:55 Asia/Manila] Error in cash_flow.php: Shift already opened for this date
[31-Jul-2025 06:28:07 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:28:07 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:28:07 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 06:28:07 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 06:28:08 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:28:08 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 06:28:09 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:28:09 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 06:28:09 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 06:29:46 Asia/Manila] AJAX action received: save_cash_count
[31-Jul-2025 06:29:46 Asia/Manila] AJAX action received: open_shift
[31-Jul-2025 06:29:47 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:29:47 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 06:29:48 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:29:48 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 06:30:15 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 06:30:15 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 06:30:15 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 06:30:15 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 06:31:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:32:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:33:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:34:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:35:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:36:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:37:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:38:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:39:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:40:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:41:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:42:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:43:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:44:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:45:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:46:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:47:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:48:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:49:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:50:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:51:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:52:15 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 06:53:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 07:07:38 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:07:38 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 07:07:38 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 07:07:39 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:07:39 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:07:44 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:07:44 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 07:07:44 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:07:44 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:08:29 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:08:29 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 07:08:30 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:08:30 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:08:31 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:08:31 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 07:08:31 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 07:08:31 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:08:31 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:22:43 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:22:43 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 07:22:43 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 07:22:44 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:22:44 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:23:20 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:23:20 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 07:23:20 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 07:23:20 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:23:20 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:23:21 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:23:21 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 07:23:21 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 07:23:21 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:23:21 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:23:24 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:23:24 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 07:23:25 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 07:23:25 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:23:32 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 07:23:32 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 07:23:33 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 07:23:33 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 09:23:49 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 09:23:49 Asia/Manila] Getting sale details for sale_id: 3196
[31-Jul-2025 09:23:49 Asia/Manila] Branch code: m001
[31-Jul-2025 09:23:49 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 09:23:49 Asia/Manila] Items table: m001_items
[31-Jul-2025 09:23:49 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 09:23:49 Asia/Manila] Found sale: {"sale_id":3196,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"15.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 09:23:14","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 09:23:49 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 09:23:49 Asia/Manila] Found items: [{"sale_item_id":4344,"sale_id":3196,"item_id":14,"quantity":"1.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"15.00","items_name":"3 - Crispy Neck","sell_type":"unit"}]
[31-Jul-2025 09:23:49 Asia/Manila] Found extra charges: []
[31-Jul-2025 09:23:49 Asia/Manila] Final response data for sale ID 3196:
[31-Jul-2025 09:23:49 Asia/Manila] Sale data: {"sale_id":3196,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"15.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 09:23:14","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 09:23:49 Asia/Manila] Extra charges: []
[31-Jul-2025 09:23:54 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[31-Jul-2025 09:23:54 Asia/Manila] Starting void operation for sale #3196
[31-Jul-2025 09:23:54 Asia/Manila] Getting sale snapshot for sale #3196
[31-Jul-2025 09:23:54 Asia/Manila] Sale total: 15
[31-Jul-2025 09:23:54 Asia/Manila] Updating sale status to voided
[31-Jul-2025 09:23:54 Asia/Manila] Processing stock restoration
[31-Jul-2025 09:23:54 Asia/Manila] Found 1 items to restore stock for
[31-Jul-2025 09:23:54 Asia/Manila] Processing item 14 - quantity: 1.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 09:23:54 Asia/Manila] Restoring 1.00 units to regular item 14
[31-Jul-2025 09:23:54 Asia/Manila] Processing cash movement for voided sale
[31-Jul-2025 09:23:54 Asia/Manila] Target cashier ID: 9
[31-Jul-2025 09:23:54 Asia/Manila] Checking shift behavior
[31-Jul-2025 09:23:54 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[31-Jul-2025 09:23:54 Asia/Manila] Ensuring shift exists for cashier 9
[31-Jul-2025 09:23:54 Asia/Manila] Recording sale movement with amount: -15
[31-Jul-2025 09:23:54 Asia/Manila] Logging audit trail
[31-Jul-2025 09:23:54 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 09:23:54 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 09:23:54 Asia/Manila] Warning: Failed to log audit trail for voided sale #3196
[31-Jul-2025 09:23:54 Asia/Manila] Committing transaction
[31-Jul-2025 09:23:54 Asia/Manila] Void operation completed successfully for sale #3196
[31-Jul-2025 10:02:40 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 10:02:40 Asia/Manila] Getting sale details for sale_id: 3198
[31-Jul-2025 10:02:40 Asia/Manila] Branch code: m001
[31-Jul-2025 10:02:40 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 10:02:40 Asia/Manila] Items table: m001_items
[31-Jul-2025 10:02:40 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 10:02:40 Asia/Manila] Found sale: {"sale_id":3198,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"40.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:02:29","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:02:40 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 10:02:40 Asia/Manila] Found items: [{"sale_item_id":4346,"sale_id":3198,"item_id":13,"quantity":"2.00","price":"20.00","original_price":"20.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"40.00","items_name":"2 - Budget Cuts","sell_type":"unit"}]
[31-Jul-2025 10:02:40 Asia/Manila] Found extra charges: []
[31-Jul-2025 10:02:40 Asia/Manila] Final response data for sale ID 3198:
[31-Jul-2025 10:02:40 Asia/Manila] Sale data: {"sale_id":3198,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"40.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:02:29","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:02:40 Asia/Manila] Extra charges: []
[31-Jul-2025 10:02:42 Asia/Manila] AJAX action received: check_operation_allowed
[31-Jul-2025 10:02:42 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[31-Jul-2025 10:02:42 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[31-Jul-2025 10:02:42 Asia/Manila] Current shift behavior setting: block
[31-Jul-2025 10:02:42 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[31-Jul-2025 10:02:49 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 10:02:49 Asia/Manila] Getting sale details for sale_id: 3198
[31-Jul-2025 10:02:49 Asia/Manila] Branch code: m001
[31-Jul-2025 10:02:49 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 10:02:49 Asia/Manila] Items table: m001_items
[31-Jul-2025 10:02:49 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 10:02:49 Asia/Manila] Found sale: {"sale_id":3198,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"40.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:02:29","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:02:49 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 10:02:49 Asia/Manila] Found items: [{"sale_item_id":4346,"sale_id":3198,"item_id":13,"quantity":"2.00","price":"20.00","original_price":"20.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"40.00","items_name":"2 - Budget Cuts","sell_type":"unit"}]
[31-Jul-2025 10:02:49 Asia/Manila] Found extra charges: []
[31-Jul-2025 10:02:49 Asia/Manila] Final response data for sale ID 3198:
[31-Jul-2025 10:02:49 Asia/Manila] Sale data: {"sale_id":3198,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"40.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:02:29","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:02:49 Asia/Manila] Extra charges: []
[31-Jul-2025 10:02:57 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[31-Jul-2025 10:02:57 Asia/Manila] Starting void operation for sale #3198
[31-Jul-2025 10:02:57 Asia/Manila] Getting sale snapshot for sale #3198
[31-Jul-2025 10:02:57 Asia/Manila] Sale total: 40
[31-Jul-2025 10:02:57 Asia/Manila] Updating sale status to voided
[31-Jul-2025 10:02:57 Asia/Manila] Processing stock restoration
[31-Jul-2025 10:02:57 Asia/Manila] Found 1 items to restore stock for
[31-Jul-2025 10:02:57 Asia/Manila] Processing item 13 - quantity: 2.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 10:02:57 Asia/Manila] Restoring 2.00 units to regular item 13
[31-Jul-2025 10:02:57 Asia/Manila] Processing cash movement for voided sale
[31-Jul-2025 10:02:57 Asia/Manila] Target cashier ID: 9
[31-Jul-2025 10:02:57 Asia/Manila] Checking shift behavior
[31-Jul-2025 10:02:57 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[31-Jul-2025 10:02:57 Asia/Manila] Ensuring shift exists for cashier 9
[31-Jul-2025 10:02:57 Asia/Manila] Recording sale movement with amount: -40
[31-Jul-2025 10:02:57 Asia/Manila] Logging audit trail
[31-Jul-2025 10:02:57 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 10:02:57 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 10:02:57 Asia/Manila] Warning: Failed to log audit trail for voided sale #3198
[31-Jul-2025 10:02:57 Asia/Manila] Committing transaction
[31-Jul-2025 10:02:57 Asia/Manila] Void operation completed successfully for sale #3198
[31-Jul-2025 10:30:26 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 10:30:26 Asia/Manila] Getting sale details for sale_id: 3200
[31-Jul-2025 10:30:26 Asia/Manila] Branch code: m001
[31-Jul-2025 10:30:26 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 10:30:26 Asia/Manila] Items table: m001_items
[31-Jul-2025 10:30:26 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 10:30:26 Asia/Manila] Found sale: {"sale_id":3200,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"115.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:30:13","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:30:26 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 10:30:26 Asia/Manila] Found items: [{"sale_item_id":4348,"sale_id":3200,"item_id":20,"quantity":"1.00","price":"100.00","original_price":"100.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"100.00","items_name":"Chicken Adobo Cut","sell_type":"unit"},{"sale_item_id":4349,"sale_id":3200,"item_id":21,"quantity":"1.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"15.00","items_name":"6 - Rice","sell_type":"unit"}]
[31-Jul-2025 10:30:26 Asia/Manila] Found extra charges: []
[31-Jul-2025 10:30:26 Asia/Manila] Final response data for sale ID 3200:
[31-Jul-2025 10:30:26 Asia/Manila] Sale data: {"sale_id":3200,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"115.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:30:13","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:30:26 Asia/Manila] Extra charges: []
[31-Jul-2025 10:30:31 Asia/Manila] AJAX action received: check_operation_allowed
[31-Jul-2025 10:30:31 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[31-Jul-2025 10:30:31 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[31-Jul-2025 10:30:31 Asia/Manila] Current shift behavior setting: block
[31-Jul-2025 10:30:31 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[31-Jul-2025 10:30:34 Asia/Manila] AJAX action received: check_operation_allowed
[31-Jul-2025 10:30:34 Asia/Manila] Shift control settings - behavior: block, allow_sales_closed_shift: false
[31-Jul-2025 10:30:34 Asia/Manila] Operation check for sales: {"allowed":true,"message":null,"behavior":"allow"}
[31-Jul-2025 10:30:34 Asia/Manila] Current shift behavior setting: block
[31-Jul-2025 10:30:34 Asia/Manila] Operation check response: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"shift_status":"open","can_open_new_shift":true}
[31-Jul-2025 10:30:45 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 10:30:45 Asia/Manila] Getting sale details for sale_id: 3200
[31-Jul-2025 10:30:45 Asia/Manila] Branch code: m001
[31-Jul-2025 10:30:45 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 10:30:45 Asia/Manila] Items table: m001_items
[31-Jul-2025 10:30:45 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 10:30:45 Asia/Manila] Found sale: {"sale_id":3200,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"115.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:30:13","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:30:45 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 10:30:45 Asia/Manila] Found items: [{"sale_item_id":4348,"sale_id":3200,"item_id":20,"quantity":"1.00","price":"100.00","original_price":"100.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"100.00","items_name":"Chicken Adobo Cut","sell_type":"unit"},{"sale_item_id":4349,"sale_id":3200,"item_id":21,"quantity":"1.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"15.00","items_name":"6 - Rice","sell_type":"unit"}]
[31-Jul-2025 10:30:45 Asia/Manila] Found extra charges: []
[31-Jul-2025 10:30:45 Asia/Manila] Final response data for sale ID 3200:
[31-Jul-2025 10:30:45 Asia/Manila] Sale data: {"sale_id":3200,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"115.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 10:30:13","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:30:45 Asia/Manila] Extra charges: []
[31-Jul-2025 10:30:52 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[31-Jul-2025 10:30:52 Asia/Manila] Starting void operation for sale #3200
[31-Jul-2025 10:30:52 Asia/Manila] Getting sale snapshot for sale #3200
[31-Jul-2025 10:30:52 Asia/Manila] Sale total: 115
[31-Jul-2025 10:30:52 Asia/Manila] Updating sale status to voided
[31-Jul-2025 10:30:52 Asia/Manila] Processing stock restoration
[31-Jul-2025 10:30:52 Asia/Manila] Found 2 items to restore stock for
[31-Jul-2025 10:30:52 Asia/Manila] Processing item 20 - quantity: 1.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 10:30:52 Asia/Manila] Restoring 1.00 units to regular item 20
[31-Jul-2025 10:30:52 Asia/Manila] Processing item 21 - quantity: 1.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 10:30:52 Asia/Manila] Restoring 1.00 units to regular item 21
[31-Jul-2025 10:30:52 Asia/Manila] Processing cash movement for voided sale
[31-Jul-2025 10:30:52 Asia/Manila] Target cashier ID: 9
[31-Jul-2025 10:30:52 Asia/Manila] Checking shift behavior
[31-Jul-2025 10:30:52 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[31-Jul-2025 10:30:52 Asia/Manila] Ensuring shift exists for cashier 9
[31-Jul-2025 10:30:52 Asia/Manila] Recording sale movement with amount: -115
[31-Jul-2025 10:30:52 Asia/Manila] Logging audit trail
[31-Jul-2025 10:30:52 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 10:30:52 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 10:30:52 Asia/Manila] Warning: Failed to log audit trail for voided sale #3200
[31-Jul-2025 10:30:52 Asia/Manila] Committing transaction
[31-Jul-2025 10:30:52 Asia/Manila] Void operation completed successfully for sale #3200
[31-Jul-2025 10:31:14 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 10:31:14 Asia/Manila] Getting sale details for sale_id: 3197
[31-Jul-2025 10:31:14 Asia/Manila] Branch code: m001
[31-Jul-2025 10:31:14 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 10:31:14 Asia/Manila] Items table: m001_items
[31-Jul-2025 10:31:14 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 10:31:14 Asia/Manila] Found sale: {"sale_id":3197,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"30.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 09:24:03","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:31:14 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 10:31:14 Asia/Manila] Found items: [{"sale_item_id":4345,"sale_id":3197,"item_id":14,"quantity":"2.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"30.00","items_name":"3 - Crispy Neck","sell_type":"unit"}]
[31-Jul-2025 10:31:14 Asia/Manila] Found extra charges: []
[31-Jul-2025 10:31:14 Asia/Manila] Final response data for sale ID 3197:
[31-Jul-2025 10:31:14 Asia/Manila] Sale data: {"sale_id":3197,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"30.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 09:24:03","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:31:14 Asia/Manila] Extra charges: []
[31-Jul-2025 10:31:21 Asia/Manila] Session data: {"redirect_url":"\/pos\/cash_flow.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 10:31:21 Asia/Manila] Getting sale details for sale_id: 3197
[31-Jul-2025 10:31:21 Asia/Manila] Branch code: m001
[31-Jul-2025 10:31:21 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 10:31:21 Asia/Manila] Items table: m001_items
[31-Jul-2025 10:31:21 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 10:31:21 Asia/Manila] Found sale: {"sale_id":3197,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"30.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 09:24:03","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:31:21 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 10:31:21 Asia/Manila] Found items: [{"sale_item_id":4345,"sale_id":3197,"item_id":14,"quantity":"2.00","price":"15.00","original_price":"15.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"30.00","items_name":"3 - Crispy Neck","sell_type":"unit"}]
[31-Jul-2025 10:31:21 Asia/Manila] Found extra charges: []
[31-Jul-2025 10:31:21 Asia/Manila] Final response data for sale ID 3197:
[31-Jul-2025 10:31:21 Asia/Manila] Sale data: {"sale_id":3197,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"30.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 09:24:03","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 10:31:21 Asia/Manila] Extra charges: []
[31-Jul-2025 15:27:29 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"1"}, GET: []
[31-Jul-2025 17:03:33 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"0"}, GET: []
[31-Jul-2025 17:03:55 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"1"}, GET: []
[31-Jul-2025 17:04:26 Asia/Manila] Data Management Handler - Action: save_pos_setting, POST: {"action":"save_pos_setting","setting_key":"show_counter","setting_value":"0"}, GET: []
[31-Jul-2025 18:22:49 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 18:22:49 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 18:22:51 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 18:22:51 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 18:48:01 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 18:48:01 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 18:48:01 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 18:48:01 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=2
[31-Jul-2025 18:48:01 Asia/Manila] Error in cash_flow.php: No shift found for this date
[31-Jul-2025 18:48:04 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 18:48:04 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 18:48:05 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 18:48:05 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 20:06:39 Asia/Manila] Session data: {"redirect_url":"\/pos\/items.php","user_id":9,"user_name":"Cashier","user_email":"manoktokcashier@gmail.com","user_role":"cashier","branch_id":1,"branch_code":"m001","user_restrictions":[]}
[31-Jul-2025 20:06:39 Asia/Manila] Getting sale details for sale_id: 3252
[31-Jul-2025 20:06:39 Asia/Manila] Branch code: m001
[31-Jul-2025 20:06:39 Asia/Manila] Sale items table: m001_sale_items
[31-Jul-2025 20:06:39 Asia/Manila] Items table: m001_items
[31-Jul-2025 20:06:39 Asia/Manila] Sale query: 
                    SELECT 
                        s.*,
                        COALESCE(s_c.customer_id, ct_c.customer_id) as linked_customer_id,
                        COALESCE(s_c.customer_name, ct_c.customer_name) as customer_name,
                        COALESCE(s_c.credit_balance, ct_c.credit_balance) as customer_balance,
                        ct.transaction_id,
                        ct.amount as credit_amount,
                        u.name as staff_name,
                        s.payment_method
                    FROM m001_sales s 
                    LEFT JOIN m001_customers s_c ON s.customer_id = s_c.customer_id
                    LEFT JOIN m001_credit_transactions ct ON s.sale_id = ct.sale_id AND ct.type = 'sale'
                    LEFT JOIN m001_customers ct_c ON ct.customer_id = ct_c.customer_id
                    LEFT JOIN users u ON s.user_id = u.id
                    WHERE s.sale_id = ?
                
[31-Jul-2025 20:06:39 Asia/Manila] Found sale: {"sale_id":3252,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"210.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 20:06:33","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 20:06:39 Asia/Manila] Items query: 
                        SELECT si.*, i.items_name, i.sell_type 
                        FROM m001_sale_items si 
                        JOIN m001_items i ON si.item_id = i.items_id 
                        WHERE si.sale_id = ?
                    
[31-Jul-2025 20:06:39 Asia/Manila] Found items: [{"sale_item_id":4425,"sale_id":3252,"item_id":11,"quantity":"2.00","price":"30.00","original_price":"30.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"60.00","items_name":"1 - Value Cuts","sell_type":"unit"},{"sale_item_id":4426,"sale_id":3252,"item_id":18,"quantity":"2.00","price":"50.00","original_price":"50.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"100.00","items_name":"Chicken Liver","sell_type":"unit"},{"sale_item_id":4427,"sale_id":3252,"item_id":17,"quantity":"1.00","price":"50.00","original_price":"50.00","discount_type":null,"discount_value":"0.00","is_free":0,"total":"50.00","items_name":"Chicken Neck","sell_type":"unit"}]
[31-Jul-2025 20:06:39 Asia/Manila] Found extra charges: []
[31-Jul-2025 20:06:39 Asia/Manila] Final response data for sale ID 3252:
[31-Jul-2025 20:06:39 Asia/Manila] Sale data: {"sale_id":3252,"user_id":9,"customer_id":null,"subtotal":"0.00","tax":"0.00","total":"210.00","payment_method":"cash","amount_received":"0.00","amount_change":"0.00","status":"active","voided_at":null,"voided_by":null,"void_reason":null,"created_at":"2025-07-31 20:06:33","discount_type":null,"discount_value":"0.00","delivery_charge":"0.00","other_charge":"0.00","linked_customer_id":null,"customer_name":null,"customer_balance":null,"transaction_id":null,"credit_amount":null,"staff_name":"Cashier"}
[31-Jul-2025 20:06:39 Asia/Manila] Extra charges: []
[31-Jul-2025 20:06:45 Asia/Manila] Shift control settings - behavior: block, allow_void_closed_shift: false
[31-Jul-2025 20:06:45 Asia/Manila] Starting void operation for sale #3252
[31-Jul-2025 20:06:45 Asia/Manila] Getting sale snapshot for sale #3252
[31-Jul-2025 20:06:45 Asia/Manila] Sale total: 210
[31-Jul-2025 20:06:45 Asia/Manila] Updating sale status to voided
[31-Jul-2025 20:06:45 Asia/Manila] Processing stock restoration
[31-Jul-2025 20:06:45 Asia/Manila] Found 3 items to restore stock for
[31-Jul-2025 20:06:45 Asia/Manila] Processing item 11 - quantity: 2.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 20:06:45 Asia/Manila] Restoring 2.00 units to regular item 11
[31-Jul-2025 20:06:45 Asia/Manila] Processing item 18 - quantity: 2.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 20:06:45 Asia/Manila] Restoring 2.00 units to regular item 18
[31-Jul-2025 20:06:45 Asia/Manila] Processing item 17 - quantity: 1.00, sell_type: unit, track_inventory: 1
[31-Jul-2025 20:06:45 Asia/Manila] Restoring 1.00 units to regular item 17
[31-Jul-2025 20:06:45 Asia/Manila] Processing cash movement for voided sale
[31-Jul-2025 20:06:45 Asia/Manila] Target cashier ID: 9
[31-Jul-2025 20:06:45 Asia/Manila] Checking shift behavior
[31-Jul-2025 20:06:45 Asia/Manila] Shift check result: {"success":true,"allowed":true,"message":null,"behavior":"block","shift_exists":true,"is_shift_open":true}
[31-Jul-2025 20:06:45 Asia/Manila] Ensuring shift exists for cashier 9
[31-Jul-2025 20:06:45 Asia/Manila] Recording sale movement with amount: -210
[31-Jul-2025 20:06:45 Asia/Manila] Logging audit trail
[31-Jul-2025 20:06:45 Asia/Manila] Error in executeQuery: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 20:06:45 Asia/Manila] Audit log error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_data_snapshot' in 'field list'
[31-Jul-2025 20:06:45 Asia/Manila] Warning: Failed to log audit trail for voided sale #3252
[31-Jul-2025 20:06:45 Asia/Manila] Committing transaction
[31-Jul-2025 20:06:45 Asia/Manila] Void operation completed successfully for sale #3252
[31-Jul-2025 20:22:54 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 20:22:55 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 20:22:55 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 20:22:55 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 20:23:55 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 20:24:12 Asia/Manila] AJAX action received: save_cash_count
[31-Jul-2025 20:24:13 Asia/Manila] AJAX action received: close_shift
[31-Jul-2025 20:24:15 Asia/Manila] AJAX action received: get_shift_summary
[31-Jul-2025 20:24:15 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[31-Jul-2025 20:24:16 Asia/Manila] AJAX action received: get_denominations
[31-Jul-2025 20:24:16 Asia/Manila] AJAX action received: get_movements
[31-Jul-2025 20:25:16 Asia/Manila] AJAX action received: get_shift_status
[31-Jul-2025 20:26:16 Asia/Manila] AJAX action received: get_shift_status
[01-Aug-2025 03:37:15 Asia/Manila] AJAX action received: get_shift_summary
[01-Aug-2025 03:37:15 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-08-01, cashier_id=9
[01-Aug-2025 03:37:15 Asia/Manila] Error in cash_flow.php: No shift found for this date
[01-Aug-2025 03:37:16 Asia/Manila] AJAX action received: get_denominations
[01-Aug-2025 03:37:16 Asia/Manila] AJAX action received: get_movements
[01-Aug-2025 03:37:25 Asia/Manila] AJAX action received: get_movements
[01-Aug-2025 03:37:25 Asia/Manila] AJAX action received: get_shift_summary
[01-Aug-2025 03:37:25 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[01-Aug-2025 04:18:43 Asia/Manila] AJAX action received: get_shift_summary
[01-Aug-2025 04:18:43 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-08-01, cashier_id=2
[01-Aug-2025 04:18:43 Asia/Manila] Error in cash_flow.php: No shift found for this date
[01-Aug-2025 04:18:43 Asia/Manila] AJAX action received: get_denominations
[01-Aug-2025 04:18:43 Asia/Manila] AJAX action received: get_movements
[01-Aug-2025 04:18:45 Asia/Manila] AJAX action received: get_shift_summary
[01-Aug-2025 04:18:45 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-08-01, cashier_id=9
[01-Aug-2025 04:18:45 Asia/Manila] Error in cash_flow.php: No shift found for this date
[01-Aug-2025 04:18:45 Asia/Manila] AJAX action received: get_movements
[01-Aug-2025 04:18:45 Asia/Manila] AJAX action received: get_denominations
[01-Aug-2025 04:18:51 Asia/Manila] AJAX action received: get_movements
[01-Aug-2025 04:18:51 Asia/Manila] AJAX action received: get_shift_summary
[01-Aug-2025 04:18:51 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-07-31, cashier_id=9
[01-Aug-2025 06:10:03 Asia/Manila] AJAX action received: get_shift_summary
[01-Aug-2025 06:10:03 Asia/Manila] DEBUG: get_shift_summary (MAIN) called with date=2025-08-01, cashier_id=2
[01-Aug-2025 06:10:03 Asia/Manila] Error in cash_flow.php: No shift found for this date
[01-Aug-2025 06:10:04 Asia/Manila] AJAX action received: get_movements
[01-Aug-2025 06:10:04 Asia/Manila] AJAX action received: get_denominations