[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_erp_alert_log WHERE is_read=0
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT \'message\' as type, id, subject, from_user as from_name, 
                    trigger_user as trigger_name, sent_at as timestamp
             FROM 0_messaging
             WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
             ORDER BY sent_at DESC LIMIT 5
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT \'alert\' as type, id, title as subject, \'System\' as from_name, 
                      \'System\' as trigger_name, triggered_at as timestamp
               FROM 0_erp_alert_log
               WHERE is_read=0
               ORDER BY triggered_at DESC LIMIT 5
[2026-04-08 17:24:21] Company:0 | Prefix:'0_' | SQL:SELECT \'post\' as type, trans_no as id, reference as subject, 
                      \'\' as from_name, \'\' as trigger_name, tran_date as timestamp
               FROM 0_debtor_trans
               WHERE (type=12) AND trans_no > \'6907\'
               ORDER BY trans_no DESC LIMIT 3
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'sales.revenue\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'sales.gross_profit\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'sales.gross_margin_pct\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'sales.orders_pending\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'sales.ar_overdue\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'purchase.total_spend\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'purchase.ap_overdue\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'purchase.po_pending\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'manufacturing.wip_value\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'manufacturing.orders_active\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'banking.cash_balance\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'gl.net_profit\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'hr.payroll_total\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:28] Company:0 | Prefix:'0_' | SQL:
            SELECT value, computed_at FROM `0_erp_kpi_snapshots`
            WHERE kpi_key     = \'hr.active_employees\'
            AND   period      = \'2026-04\'
            AND   dimension_id = 0
            LIMIT 1
        
[2026-04-08 17:24:29] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'\'&TB_PREF&sales_orders\'\'
[2026-04-08 17:24:29] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'0_useronline\'
[2026-04-08 17:24:29] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_useronline (timestamp, ip, file) VALUES (\'1775648369\',\'::1\',\'/DB Company/modules/erp_unified_dashboard.php\')
[2026-04-08 17:24:29] Company:0 | Prefix:'0_' | SQL:DELETE FROM 0_useronline WHERE timestamp<1775648249
[2026-04-08 17:24:29] Company:0 | Prefix:'0_' | SQL:SELECT DISTINCT ip FROM 0_useronline
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_erp_alert_log WHERE is_read=0
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT \'message\' as type, id, subject, from_user as from_name, 
                    trigger_user as trigger_name, sent_at as timestamp
             FROM 0_messaging
             WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
             ORDER BY sent_at DESC LIMIT 5
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT \'alert\' as type, id, title as subject, \'System\' as from_name, 
                      \'System\' as trigger_name, triggered_at as timestamp
               FROM 0_erp_alert_log
               WHERE is_read=0
               ORDER BY triggered_at DESC LIMIT 5
[2026-04-08 17:24:41] Company:0 | Prefix:'0_' | SQL:SELECT \'post\' as type, trans_no as id, reference as subject, 
                      \'\' as from_name, \'\' as trigger_name, tran_date as timestamp
               FROM 0_debtor_trans
               WHERE (type=12) AND trans_no > \'6907\'
               ORDER BY trans_no DESC LIMIT 3
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_bank_accounts
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_bank_accounts WHERE id=\'5\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT SUM(amount)
		FROM 0_bank_trans
		WHERE bank_act=\'5\'
			AND trans_date < \'2026-04-09\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_bank_accounts WHERE id=\'5\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT SUM(amount)
		FROM 0_bank_trans
		WHERE bank_act=\'5\'
			AND trans_date < \'2026-04-09\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_reflines WHERE trans_type=\'1\' AND CHAR_LENGTH(`prefix`) AND LEFT(\'82/83~BP~01~0975\', CHAR_LENGTH(`prefix`)) = `prefix` UNION SELECT * FROM 0_reflines WHERE trans_type=\'1\' AND `prefix`=\'\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_reflines WHERE `id`=\'33\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT `ref` 
				FROM `0_bank_trans` tbl
					LEFT JOIN 0_voided v ON 
				tbl.`trans_no`=v.id AND v.type=\'1\' WHERE ISNULL(v.id) AND tbl.`type`=\'1\' AND tbl.`ref`=\'82/83~BP~01~0975\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_fiscal_year WHERE \'2026-04-08\' >= begin AND \'2026-04-08\' <= end AND closed=0
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'5\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT count(*) FROM 0_reflines WHERE trans_type=\'1\' AND !inactive
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT id, prefix, inactive FROM 0_reflines WHERE (`trans_type`=\'1\') ORDER BY prefix
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT id, description FROM 0_quick_entries WHERE type=1 ORDER BY description
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_quick_entries WHERE id=\'9\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT id, bank_account_name, bank_curr_code, inactive
		FROM 0_bank_accounts ORDER BY bank_account_name
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT SUM(amount)
		FROM 0_bank_trans
		WHERE bank_act=\'5\'
			AND trans_date < \'2026-04-09\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'5\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'5\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'7\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
			FROM (0_chart_master chart,0_chart_types type) LEFT JOIN 0_bank_accounts acc ON chart.account_code=acc.account_code
				WHERE acc.account_code  IS NULL
			AND chart.account_type=type.id ORDER BY type.class_id,type.id,account_code
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT id, CONCAT(reference,\'  \',name) as ref FROM 0_dimensions WHERE (closed=0 AND type_=\'1\') ORDER BY reference
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT id, CONCAT(reference,\'  \',name) as ref FROM 0_dimensions WHERE (closed=0 AND type_=\'2\') ORDER BY reference
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'5\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'0_useronline\'
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_useronline (timestamp, ip, file) VALUES (\'1775648387\',\'::1\',\'/DB Company/gl/gl_bank.php\')
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:DELETE FROM 0_useronline WHERE timestamp<1775648267
[2026-04-08 17:24:47] Company:0 | Prefix:'0_' | SQL:SELECT DISTINCT ip FROM 0_useronline
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_bank_accounts
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT count(*) FROM 0_reflines WHERE trans_type=\'1\' AND !inactive
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT id, prefix, inactive FROM 0_reflines WHERE (`trans_type`=\'1\') ORDER BY prefix
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT id, description FROM 0_quick_entries WHERE type=1 ORDER BY description
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_quick_entries WHERE id=\'9\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT id, bank_account_name, bank_curr_code, inactive
		FROM 0_bank_accounts ORDER BY bank_account_name
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT SUM(amount)
		FROM 0_bank_trans
		WHERE bank_act=\'31\'
			AND trans_date < \'2026-04-09\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'5\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'7\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
			FROM (0_chart_master chart,0_chart_types type) LEFT JOIN 0_bank_accounts acc ON chart.account_code=acc.account_code
				WHERE acc.account_code  IS NULL
			AND chart.account_type=type.id ORDER BY type.class_id,type.id,account_code
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT id, CONCAT(reference,\'  \',name) as ref FROM 0_dimensions WHERE (closed=0 AND type_=\'1\') ORDER BY reference
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT id, CONCAT(reference,\'  \',name) as ref FROM 0_dimensions WHERE (closed=0 AND type_=\'2\') ORDER BY reference
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'0_useronline\'
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_useronline (timestamp, ip, file) VALUES (\'1775648396\',\'::1\',\'/DB Company/gl/gl_bank.php\')
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:DELETE FROM 0_useronline WHERE timestamp<1775648276
[2026-04-08 17:24:56] Company:0 | Prefix:'0_' | SQL:SELECT DISTINCT ip FROM 0_useronline
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_bank_accounts
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT SUM(amount)
		FROM 0_bank_trans
		WHERE bank_act=\'31\'
			AND trans_date < \'2026-04-09\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT SUM(amount)
		FROM 0_bank_trans
		WHERE bank_act=\'31\'
			AND trans_date < \'2026-04-09\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT sum(amount) as amount, trans_date, trans_no, type
			FROM 0_bank_trans
			WHERE bank_act=\'31\' AND trans_date > \'2026-04-08\' GROUP BY trans_date ORDER BY trans_date ASC
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_reflines WHERE trans_type=\'1\' AND CHAR_LENGTH(`prefix`) AND LEFT(\'82/83~BP~01~0975\', CHAR_LENGTH(`prefix`)) = `prefix` UNION SELECT * FROM 0_reflines WHERE trans_type=\'1\' AND `prefix`=\'\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_reflines WHERE `id`=\'33\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT `ref` 
				FROM `0_bank_trans` tbl
					LEFT JOIN 0_voided v ON 
				tbl.`trans_no`=v.id AND v.type=\'1\' WHERE ISNULL(v.id) AND tbl.`type`=\'1\' AND tbl.`ref`=\'82/83~BP~01~0975\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_fiscal_year WHERE \'2026-04-08\' >= begin AND \'2026-04-08\' <= end AND closed=0
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:BEGIN
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT account_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT max(last_no) last_no FROM (SELECT MAX(`trans_no`) as last_no FROM 0_bank_trans WHERE `type`=\'1\' UNION SELECT MAX(`id`) as last_no FROM 0_voided WHERE `type`=\'1\') a
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT max(last_no) last_no FROM (SELECT MAX(`trans_no`) as last_no FROM 0_journal WHERE `type`=\'0\' UNION SELECT MAX(`id`) as last_no FROM 0_voided WHERE `type`=\'0\') a
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT bank_curr_code FROM 0_bank_accounts WHERE id=\'31\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_bank_trans (type, trans_no, bank_act, ref,
		trans_date, amount, person_type_id, person_id) VALUES (1, 3565, \'31\', \'82/83~BP~01~0975\', \'2026-04-08\',
		\'-20000\', \'4\', \'9\')
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT id FROM 0_bank_accounts WHERE account_code=\'2110000103\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT 1 
		FROM 0_cust_branch
		WHERE receivables_account=\'2110000103\' UNION
		SELECT -1 
		FROM 0_suppliers 
		WHERE payable_account=\'2110000103\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_gl_trans ( type, type_no, tran_date,
		account, dimension_id, dimension2_id, memo_, amount) VALUES (\'1\', \'3565\', \'2026-04-08\',
		\'2110000103\', \'5\', \'7\', \'Admin - Cash Given To Ramjeet By Bikash\', \'20000\') 
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT id FROM 0_tax_types WHERE 
		sales_gl_code=\'2110000103\' OR purchasing_gl_code=\'2110000103\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT 1 
		FROM 0_cust_branch
		WHERE receivables_account=\'11012005\' UNION
		SELECT -1 
		FROM 0_suppliers 
		WHERE payable_account=\'11012005\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_gl_trans ( type, type_no, tran_date,
		account, dimension_id, dimension2_id, memo_, amount) VALUES (\'1\', \'3565\', \'2026-04-08\',
		\'11012005\', \'5\', \'7\', \'Admin - Cash Given To Ramjeet By Bikash\', \'-20000\') 
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_comments (type, id, date_, memo_)
    		VALUES (\'1\', \'3565\', \'2026-04-08\', \'Cash Given To Ramjeet By Bikash\')
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:REPLACE 0_refs SET reference=\'82/83~BP~01~0975\', type=\'1\', id=\'3565\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_reflines WHERE trans_type=\'1\' AND CHAR_LENGTH(`prefix`) AND LEFT(\'82/83~BP~01~0975\', CHAR_LENGTH(`prefix`)) = `prefix` UNION SELECT * FROM 0_reflines WHERE trans_type=\'1\' AND `prefix`=\'\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_reflines WHERE `id`=\'33\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_audit_trail (type, trans_no, user, gl_date, description, stamp)
			VALUES(\'1\', \'3565\',1,\'2026-04-08\',\'\', CURRENT_TIMESTAMP)
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:UPDATE 0_audit_trail audit LEFT JOIN 0_fiscal_year year ON year.begin<=\'2026-04-08\' AND year.end>=\'2026-04-08\'
		SET audit.gl_seq = IF(audit.id=51814, 0, NULL),audit.fiscal_year=year.id WHERE type=\'1\' AND trans_no=\'3565\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT user_id FROM 0_users WHERE id=1
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:COMMIT
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT user_id FROM 0_users WHERE id=1
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SHOW TABLES
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'0_messaging\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging 
            WHERE from_user = \'SYSTEM\' 
            AND subject LIKE \'Daily ERP Alerts%\' 
            AND DATE(sent_at) = \'2026-04-08\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_bank_accounts
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'0_useronline\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:INSERT INTO 0_useronline (timestamp, ip, file) VALUES (\'1775648397\',\'::1\',\'/DB Company/gl/gl_bank.php\')
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:DELETE FROM 0_useronline WHERE timestamp<1775648277
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT DISTINCT ip FROM 0_useronline
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_erp_alert_log WHERE is_read=0
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT \'message\' as type, id, subject, from_user as from_name, 
                    trigger_user as trigger_name, sent_at as timestamp
             FROM 0_messaging
             WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
             ORDER BY sent_at DESC LIMIT 5
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT \'alert\' as type, id, title as subject, \'System\' as from_name, 
                      \'System\' as trigger_name, triggered_at as timestamp
               FROM 0_erp_alert_log
               WHERE is_read=0
               ORDER BY triggered_at DESC LIMIT 5
[2026-04-08 17:24:57] Company:0 | Prefix:'0_' | SQL:SELECT \'post\' as type, trans_no as id, reference as subject, 
                      \'\' as from_name, \'\' as trigger_name, tran_date as timestamp
               FROM 0_debtor_trans
               WHERE (type=12) AND trans_no > \'6907\'
               ORDER BY trans_no DESC LIMIT 3
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT user_id FROM 0_users WHERE id=1
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SHOW TABLES
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SHOW TABLES LIKE \'0_messaging\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging 
            WHERE from_user = \'SYSTEM\' 
            AND subject LIKE \'Daily ERP Alerts%\' 
            AND DATE(sent_at) = \'2026-04-08\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT gl.*, cm.account_name, IFNULL(refs.reference, \'\') AS reference, user.real_name, 
			COALESCE(st.tran_date, dt.tran_date, bt.trans_date, grn.delivery_date, gl.tran_date) as doc_date,
			IF(ISNULL(st.supp_reference), \'\', st.supp_reference) AS supp_reference
	FROM 0_gl_trans as gl
		LEFT JOIN 0_chart_master as cm ON gl.account = cm.account_code
		LEFT JOIN 0_refs as refs ON (gl.type=refs.type AND gl.type_no=refs.id)
		LEFT JOIN 0_audit_trail as audit ON (gl.type=audit.type AND gl.type_no=audit.trans_no AND NOT ISNULL(gl_seq))
		LEFT JOIN 0_users as user ON (audit.user=user.id)
	# all this below just to retrieve doc_date :>
		LEFT JOIN 0_supp_trans st ON gl.type_no=st.trans_no AND st.type=gl.type AND (gl.type!=0 OR gl.person_id=st.supplier_id)
		LEFT JOIN 0_grn_batch grn ON grn.id=gl.type_no AND gl.type=25 AND gl.person_id=grn.supplier_id
		LEFT JOIN 0_debtor_trans dt ON gl.type_no=dt.trans_no AND dt.type=gl.type AND (gl.type!=0 OR gl.person_id=dt.debtor_no)
		LEFT JOIN 0_bank_trans bt ON bt.type=gl.type AND bt.trans_no=gl.type_no AND bt.amount!=0
			 AND bt.person_type_id=gl.person_type_id AND bt.person_id=gl.person_id
		LEFT JOIN 0_journal j ON j.type=gl.type AND j.trans_no=gl.type_no WHERE gl.type= \'1\' AND gl.type_no = \'3565\' AND gl.amount <> 0 ORDER BY tran_date, counter
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT	MAX(gl_seq) as gl_seq  FROM 0_audit_trail WHERE type=\'1\' AND trans_no=\'3565\' AND gl_date<=\'2025-01-07\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT trans.debtor_no as person_id, debtor.name as name
			FROM 0_debtor_trans trans, 0_debtors_master debtor
			WHERE trans_no=\'3565\' AND type=\'1\' AND trans.debtor_no=debtor.debtor_no
			UNION
				SELECT trans.supplier_id as person_id, supp.supp_name as name
			FROM 0_supp_trans trans, 0_suppliers supp
			WHERE trans_no=\'3565\' AND type=\'1\' AND trans.supplier_id=supp.supplier_id
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT debtor_ref as ref
		FROM 0_cust_branch branch
			LEFT JOIN 0_debtors_master d ON branch.debtor_no = d.debtor_no
		WHERE branch.receivables_account=\'2110000103\' AND d.debtor_no=\'\' UNION SELECT supp_ref as ref
			FROM 0_suppliers supp
			WHERE payable_account=\'2110000103\' 
				AND supplier_id=\'\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'5\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'7\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT debtor_ref as ref
		FROM 0_cust_branch branch
			LEFT JOIN 0_debtors_master d ON branch.debtor_no = d.debtor_no
		WHERE branch.receivables_account=\'11012005\' AND d.debtor_no=\'\' UNION SELECT supp_ref as ref
			FROM 0_suppliers supp
			WHERE payable_account=\'11012005\' 
				AND supplier_id=\'\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'5\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_dimensions	WHERE id=\'7\'
[2026-04-08 17:24:59] Company:0 | Prefix:'0_' | SQL:SELECT * FROM 0_voided WHERE type=\'1\' AND id=\'3565\'
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_erp_alert_log WHERE is_read=0
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT \'message\' as type, id, subject, from_user as from_name, 
                    trigger_user as trigger_name, sent_at as timestamp
             FROM 0_messaging
             WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
             ORDER BY sent_at DESC LIMIT 5
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT \'alert\' as type, id, title as subject, \'System\' as from_name, 
                      \'System\' as trigger_name, triggered_at as timestamp
               FROM 0_erp_alert_log
               WHERE is_read=0
               ORDER BY triggered_at DESC LIMIT 5
[2026-04-08 17:25:04] Company:0 | Prefix:'0_' | SQL:SELECT \'post\' as type, trans_no as id, reference as subject, 
                      \'\' as from_name, \'\' as trigger_name, tran_date as timestamp
               FROM 0_debtor_trans
               WHERE (type=12) AND trans_no > \'6907\'
               ORDER BY trans_no DESC LIMIT 3
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_erp_alert_log WHERE is_read=0
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT \'message\' as type, id, subject, from_user as from_name, 
                    trigger_user as trigger_name, sent_at as timestamp
             FROM 0_messaging
             WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
             ORDER BY sent_at DESC LIMIT 5
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT \'alert\' as type, id, title as subject, \'System\' as from_name, 
                      \'System\' as trigger_name, triggered_at as timestamp
               FROM 0_erp_alert_log
               WHERE is_read=0
               ORDER BY triggered_at DESC LIMIT 5
[2026-04-08 17:25:18] Company:0 | Prefix:'0_' | SQL:SELECT \'post\' as type, trans_no as id, reference as subject, 
                      \'\' as from_name, \'\' as trigger_name, tran_date as timestamp
               FROM 0_debtor_trans
               WHERE (type=12) AND trans_no > \'6907\'
               ORDER BY trans_no DESC LIMIT 3
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SET sql_mode = \'STRICT_ALL_TABLES\'
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT value FROM 0_sys_prefs WHERE name=\'version_id\'
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT name, value FROM 0_sys_prefs
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_messaging WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT COUNT(*) FROM 0_erp_alert_log WHERE is_read=0
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT \'message\' as type, id, subject, from_user as from_name, 
                    trigger_user as trigger_name, sent_at as timestamp
             FROM 0_messaging
             WHERE to_user=\'Admin\' AND is_read=0 AND deleted_to=0
             ORDER BY sent_at DESC LIMIT 5
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT \'alert\' as type, id, title as subject, \'System\' as from_name, 
                      \'System\' as trigger_name, triggered_at as timestamp
               FROM 0_erp_alert_log
               WHERE is_read=0
               ORDER BY triggered_at DESC LIMIT 5
[2026-04-08 17:25:38] Company:0 | Prefix:'0_' | SQL:SELECT \'post\' as type, trans_no as id, reference as subject, 
                      \'\' as from_name, \'\' as trigger_name, tran_date as timestamp
               FROM 0_debtor_trans
               WHERE (type=12) AND trans_no > \'6907\'
               ORDER BY trans_no DESC LIMIT 3