2022-06-01 15:01:26.504911
INSERT INTO 0_user_login_log (user_id, remote_ip, login_date, login_time )
            VALUES ('155', '66.248.202.10', '2022-06-01', '15:01:26' )

2022-06-01 15:01:26.515102
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:01:26.877974
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:01:31.288882
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:01:34.769798
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:01:34.774471
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:01:34.788963
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:01:34.798741
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:01:34.822237
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:01:34.833076
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:01:34.841118
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:01:34.857026
SELECT COUNT(*) FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08')

2022-06-01 15:01:34.932921
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 0, 10

2022-06-01 15:01:34.968400
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:34.977729
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:01:34.987249
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:34.991449
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:34.993430
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:34.994747
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:01:34.996717
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:34.998284
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:35.193
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:35.1687
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:35.10693
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:35.19495
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:35.23460
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:35.24842
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:01:35.26562
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:35.27795
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:35.29825
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:35.31418
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:35.33420
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:35.34954
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:42.587851
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:01:42.592149
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:01:42.594067
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:01:42.595845
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:01:42.597571
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:01:42.599134
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:01:42.600631
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:01:42.602933
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 30, 10

2022-06-01 15:01:42.605518
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:42.606920
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:42.608768
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:42.610198
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:01:42.611993
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:42.613426
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:01:42.615216
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:42.617257
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:01:42.618907
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:42.620164
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:01:54.698976
SELECT next_reference FROM 0_sys_types WHERE type_id = '107'

2022-06-01 15:01:54.702938
SELECT id, value_code, value_name FROM 0_list_values  
		WHERE list_code= 'PETTY_CASH_TYPES' AND value_code='I_OWE_YOU'

2022-06-01 15:01:54.707573
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:01:54.709140
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:01:54.710781
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:01:54.712300
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:01:54.714385
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:01:54.716633
SELECT oud.*,
                    pt.task_code,
                    pt.description task_description,
                    boqg.id boq_group_id,
                    boqg.code boq_group_code,
                    boqg.description boq_group_description 
            FROM 0_i_owe_you_details oud 
                    INNER JOIN 0_project_tasks pt ON 
                            oud.task_id = pt.task_id 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
            WHERE oud.iou_id = '-1' 
            ORDER BY boqg.position, ptg.description

2022-06-01 15:01:54.723158
SELECT id, CONCAT(code, ' - ' ,description) xyz, depth 
               FROM 0_project_boq_item_groups
                WHERE project_id='' ORDER BY position

2022-06-01 15:01:54.729332
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '-1' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '-1' 
            WHERE pt.project_id = '' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:02:08.8127
SELECT next_reference FROM 0_sys_types WHERE type_id = '107'

2022-06-01 15:02:08.10389
SELECT id, value_code, value_name FROM 0_list_values  
		WHERE list_code= 'PETTY_CASH_TYPES' AND value_code='I_OWE_YOU'

2022-06-01 15:02:08.16040
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:02:08.18560
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:02:08.20363
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:08.22033
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:02:08.24081
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:02:08.26531
SELECT oud.*,
                    pt.task_code,
                    pt.description task_description,
                    boqg.id boq_group_id,
                    boqg.code boq_group_code,
                    boqg.description boq_group_description 
            FROM 0_i_owe_you_details oud 
                    INNER JOIN 0_project_tasks pt ON 
                            oud.task_id = pt.task_id 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
            WHERE oud.iou_id = '-1' 
            ORDER BY boqg.position, ptg.description

2022-06-01 15:02:08.28782
SELECT id, CONCAT(code, ' - ' ,description) xyz, depth 
               FROM 0_project_boq_item_groups
                WHERE project_id='' ORDER BY position

2022-06-01 15:02:08.30654
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '-1' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '-1' 
            WHERE pt.project_id = '' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:02:12.223946
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:02:12.238363
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:02:12.241185
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:02:12.242839
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:02:12.245101
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:02:12.247182
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:02:12.253590
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:02:12.257475
SELECT COUNT(*) FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08')

2022-06-01 15:02:12.267578
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 0, 10

2022-06-01 15:02:12.273273
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.276051
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:02:12.278042
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.279660
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:12.281567
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.283028
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:02:12.284803
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.286456
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:12.292187
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.294533
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:12.296478
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.298075
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:12.300061
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.301535
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:02:12.303466
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.305040
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:12.306926
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.308418
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:12.310357
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:12.311934
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:28.570909
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '324'

2022-06-01 15:02:28.577071
SELECT project_id  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
            WHERE pm.project_id = '10' AND 
                    udag.user_id ='155'

2022-06-01 15:02:28.578661
SELECT id, value_code, value_name FROM 0_list_values  
		WHERE list_code= 'PETTY_CASH_TYPES' AND value_code='I_OWE_YOU'

2022-06-01 15:02:28.580238
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:02:28.581899
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:28.583464
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:02:28.585420
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:02:28.587669
SELECT pf.* 
           FROM 0_project_floats pf  
           WHERE pf.project_id='10'

2022-06-01 15:02:28.590991
SELECT oud.*,
                    pt.task_code,
                    pt.description task_description,
                    boqg.id boq_group_id,
                    boqg.code boq_group_code,
                    boqg.description boq_group_description 
            FROM 0_i_owe_you_details oud 
                    INNER JOIN 0_project_tasks pt ON 
                            oud.task_id = pt.task_id 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
            WHERE oud.iou_id = '324' 
            ORDER BY boqg.position, ptg.description

2022-06-01 15:02:28.596116
SELECT id, CONCAT(code, ' - ' ,description) xyz, depth 
               FROM 0_project_boq_item_groups
                WHERE project_id='10' ORDER BY position

2022-06-01 15:02:28.603211
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '324' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '324' 
            WHERE pt.project_id = '10' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:02:31.804157
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '324'

2022-06-01 15:02:31.806364
SELECT p.* 
            FROM 0_projects_master p 
            WHERE p.project_id ='10'

2022-06-01 15:02:31.808158
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '10' AND 
                        pap.approval_path_type = 'OU'

2022-06-01 15:02:31.814988
SELECT apc.approval_path_id,
                    apc.approval_group_id,
                    apc.position_seq_no,
                    apc.position_description,
                    apc.display_status,
                    apc.position_code,
                    apc.next_position_message,
                    ag.approval_group_description   
            FROM 0_approval_group ag,
                    0_approval_path_configuration apc 
            WHERE ag.approval_group_id = apc.approval_group_id AND 
                    apc.approval_path_id = '7' AND 
                    ag.approval_group_id = '19' 
            ORDER BY apc.position_seq_no

2022-06-01 15:02:31.828561
SELECT * FROM 0_approvers 
            WHERE approval_group_id = '19' AND user_id = '155'

2022-06-01 15:02:31.832522
SELECT approval_group_description FROM 0_approval_group 
            WHERE approval_group_id = '19'

2022-06-01 15:02:31.834031
SELECT approval_path_name FROM 0_approval_path 
            WHERE approval_path_id = '7'

2022-06-01 15:02:31.835614
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '324'

2022-06-01 15:02:31.837137
SELECT project_id  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
            WHERE pm.project_id = '10' AND 
                    udag.user_id ='155'

2022-06-01 15:02:31.838733
SELECT id, value_code, value_name FROM 0_list_values  
		WHERE list_code= 'PETTY_CASH_TYPES' AND value_code='I_OWE_YOU'

2022-06-01 15:02:31.840398
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:02:31.842002
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:31.843445
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:02:31.845359
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:02:31.847658
SELECT pf.* 
           FROM 0_project_floats pf  
           WHERE pf.project_id='10'

2022-06-01 15:02:31.849100
SELECT oud.*,
                    pt.task_code,
                    pt.description task_description,
                    boqg.id boq_group_id,
                    boqg.code boq_group_code,
                    boqg.description boq_group_description 
            FROM 0_i_owe_you_details oud 
                    INNER JOIN 0_project_tasks pt ON 
                            oud.task_id = pt.task_id 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
            WHERE oud.iou_id = '324' 
            ORDER BY boqg.position, ptg.description

2022-06-01 15:02:31.851377
SELECT id, CONCAT(code, ' - ' ,description) xyz, depth 
               FROM 0_project_boq_item_groups
                WHERE project_id='10' ORDER BY position

2022-06-01 15:02:31.858456
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '324' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '324' 
            WHERE pt.project_id = '10' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:02:34.726141
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '324'

2022-06-01 15:02:34.728415
SELECT p.* 
            FROM 0_projects_master p 
            WHERE p.project_id ='10'

2022-06-01 15:02:34.730127
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '10' AND 
                        pap.approval_path_type = 'OU'

2022-06-01 15:02:34.731694
SELECT apc.approval_path_id,
                    apc.approval_group_id,
                    apc.position_seq_no,
                    apc.position_description,
                    apc.display_status,
                    apc.position_code,
                    apc.next_position_message,
                    ag.approval_group_description   
            FROM 0_approval_group ag,
                    0_approval_path_configuration apc 
            WHERE ag.approval_group_id = apc.approval_group_id AND 
                    apc.approval_path_id = '7' AND 
                    ag.approval_group_id = '19' 
            ORDER BY apc.position_seq_no

2022-06-01 15:02:34.733433
SELECT * FROM 0_approvers 
            WHERE approval_group_id = '19' AND user_id = '155'

2022-06-01 15:02:34.734947
SELECT approval_group_description FROM 0_approval_group 
            WHERE approval_group_id = '19'

2022-06-01 15:02:34.736369
SELECT approval_path_name FROM 0_approval_path 
            WHERE approval_path_id = '7'

2022-06-01 15:02:34.737916
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '324'

2022-06-01 15:02:34.739577
SELECT project_id  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
            WHERE pm.project_id = '10' AND 
                    udag.user_id ='155'

2022-06-01 15:02:34.741109
SELECT id, value_code, value_name FROM 0_list_values  
		WHERE list_code= 'PETTY_CASH_TYPES' AND value_code='I_OWE_YOU'

2022-06-01 15:02:34.742739
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:02:34.744460
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:34.746008
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:02:34.747924
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:02:34.750200
SELECT pf.* 
           FROM 0_project_floats pf  
           WHERE pf.project_id='10'

2022-06-01 15:02:34.751688
SELECT oud.*,
                    pt.task_code,
                    pt.description task_description,
                    boqg.id boq_group_id,
                    boqg.code boq_group_code,
                    boqg.description boq_group_description 
            FROM 0_i_owe_you_details oud 
                    INNER JOIN 0_project_tasks pt ON 
                            oud.task_id = pt.task_id 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
            WHERE oud.iou_id = '324' 
            ORDER BY boqg.position, ptg.description

2022-06-01 15:02:34.754201
SELECT id, CONCAT(code, ' - ' ,description) xyz, depth 
               FROM 0_project_boq_item_groups
                WHERE project_id='10' ORDER BY position

2022-06-01 15:02:34.761045
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '324' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '324' 
            WHERE pt.project_id = '10' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:02:40.961919
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:02:40.966436
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:02:40.968707
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:02:40.970325
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:02:40.972021
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:02:40.973465
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:02:40.974788
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:02:40.977400
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 30, 10

2022-06-01 15:02:40.980398
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:40.981794
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:40.983608
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:40.985030
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:02:40.986895
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:40.988419
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:02:40.990655
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:40.991999
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:02:40.993726
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:02:40.994965
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:02:56.173295
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '352'

2022-06-01 15:02:56.181219
SELECT project_id  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
            WHERE pm.project_id = '18' AND 
                    udag.user_id ='155'

2022-06-01 15:02:56.182869
SELECT p.* 
            FROM 0_projects_master p 
            WHERE p.project_id ='18'

2022-06-01 15:03:22.232522
SELECT name, value FROM 0_sys_prefs

2022-06-01 15:03:29.721126
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:03:29.726053
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:03:29.728376
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:03:29.730249
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:03:29.732261
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:03:29.734064
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:03:29.735725
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:03:29.738995
SELECT COUNT(*) FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08')

2022-06-01 15:03:29.741886
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 0, 10

2022-06-01 15:03:29.744679
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.746207
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:29.748099
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.749588
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:29.751365
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.752804
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:29.754677
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.756229
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:29.758669
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.761551
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:29.763492
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.765131
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:29.766875
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.768298
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:29.770223
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.771723
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:29.773557
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.775038
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:29.777056
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:29.778526
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:32.633054
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:03:32.635273
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:03:32.637340
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:03:32.639143
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:03:32.640853
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:03:32.642427
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:03:32.643887
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:03:32.646284
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 30, 10

2022-06-01 15:03:32.649293
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:32.653336
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:32.655741
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:32.657218
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:32.659093
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:32.660522
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:32.662438
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:32.663698
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:32.665480
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:32.666925
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:39.537504
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '350'

2022-06-01 15:03:39.544049
SELECT project_id  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
            WHERE pm.project_id = '10' AND 
                    udag.user_id ='155'

2022-06-01 15:03:39.545853
SELECT id, value_code, value_name FROM 0_list_values  
		WHERE list_code= 'PETTY_CASH_TYPES' AND value_code='I_OWE_YOU'

2022-06-01 15:03:39.547446
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:03:39.549319
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:39.550671
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:03:39.552771
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:03:39.555229
SELECT pf.* 
           FROM 0_project_floats pf  
           WHERE pf.project_id='10'

2022-06-01 15:03:39.556845
SELECT oud.*,
                    pt.task_code,
                    pt.description task_description,
                    boqg.id boq_group_id,
                    boqg.code boq_group_code,
                    boqg.description boq_group_description 
            FROM 0_i_owe_you_details oud 
                    INNER JOIN 0_project_tasks pt ON 
                            oud.task_id = pt.task_id 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
            WHERE oud.iou_id = '350' 
            ORDER BY boqg.position, ptg.description

2022-06-01 15:03:39.559852
SELECT id, CONCAT(code, ' - ' ,description) xyz, depth 
               FROM 0_project_boq_item_groups
                WHERE project_id='10' ORDER BY position

2022-06-01 15:03:39.566949
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '350' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '350' 
            WHERE pt.project_id = '10' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:03:42.396781
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '350'

2022-06-01 15:03:42.399126
SELECT p.* 
            FROM 0_projects_master p 
            WHERE p.project_id ='10'

2022-06-01 15:03:42.401048
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '10' AND 
                        pap.approval_path_type = 'OU'

2022-06-01 15:03:42.402910
SELECT apc.approval_path_id,
                    apc.approval_group_id,
                    apc.position_seq_no,
                    apc.position_description,
                    apc.display_status,
                    apc.position_code,
                    apc.next_position_message,
                    ag.approval_group_description   
            FROM 0_approval_group ag,
                    0_approval_path_configuration apc 
            WHERE ag.approval_group_id = apc.approval_group_id AND 
                    apc.approval_path_id = '7' AND 
                    ag.approval_group_id = '13' 
            ORDER BY apc.position_seq_no

2022-06-01 15:03:42.404733
SELECT * FROM 0_approvers 
            WHERE approval_group_id = '13' AND user_id = '155'

2022-06-01 15:03:42.406785
BEGIN

2022-06-01 15:03:42.408525
UPDATE 0_i_owe_you 
                SET                     
                    amount='5720',
                    float_id='6',     
                    company_code='UKE',   
                    employee_code='037',  
                    type='951',
                    tran_date ='2022-06-01',
                    comments ='Ws petty cash expenses for BIA job ',                  
                    updated_by='155',
                    updated_on='2022-06-01 15:03:42',
                    row_state=3  
                WHERE id='350' AND row_state='2'

2022-06-01 15:03:42.410299
SELECT pt.task_id, pt.project_id, pt.description, pt.budget, pt.budget_used, pt.budget_allocated, 
                    oud.id, oud.iou_id, oud.amount, oud.required_date, oud.comments, oud.row_state  
            FROM 0_project_tasks pt 
                    INNER JOIN 0_project_task_groups ptg ON 
                            pt.task_group_id = ptg.id 
                    LEFT JOIN 0_project_boq_item_groups boqg ON 
                            ptg.boq_group_id = boqg.id 
                    LEFT JOIN 0_i_owe_you_details oud ON 
                            pt.task_id = oud.task_id AND 
                            oud.iou_id = '350' 
                    LEFT JOIN 0_i_owe_you ou ON oud.iou_id = ou.id AND 
                            ou.project_id = pt.project_id AND 
                            ou.id = '350' 
            WHERE pt.project_id = '10' AND 
                    ptg.boq_group_id = '0' 
            ORDER BY pt.task_id

2022-06-01 15:03:42.412735
COMMIT

2022-06-01 15:03:42.418037
SELECT SUM(amount) details_total   
            FROM 0_i_owe_you_details oud 
            WHERE oud.iou_id = '350'

2022-06-01 15:03:42.419888
SELECT oud.*  
            FROM 0_i_owe_you_details oud 
            WHERE oud.iou_id = '350'

2022-06-01 15:03:42.421511
SELECT pt.* 
            FROM 0_project_tasks pt  
            WHERE pt.task_id ='6'

2022-06-01 15:03:42.423116
SELECT pt.* 
            FROM 0_project_tasks pt  
            WHERE pt.task_id ='10'

2022-06-01 15:03:42.424700
SELECT pt.* 
            FROM 0_project_tasks pt  
            WHERE pt.task_id ='11'

2022-06-01 15:03:42.426469
BEGIN

2022-06-01 15:03:42.428003
SELECT  ou.*, 
                pm.description project_name   
            FROM 0_i_owe_you ou 
                    LEFT JOIN 0_projects_master pm ON
                            ou.project_id = pm.project_id 
            WHERE id = '350'

2022-06-01 15:03:42.429714
SELECT p.* 
            FROM 0_projects_master p 
            WHERE p.project_id ='10'

2022-06-01 15:03:42.431500
SELECT  ap.* 
                FROM 0_project_approval_paths pap, 
                        0_approval_path ap 
                WHERE pap.approval_path_id = ap.approval_path_id AND 
                        pap.project_id = '10' AND 
                        pap.approval_path_type = 'OU'

2022-06-01 15:03:42.433162
SELECT apc.approval_path_id,
                    apc.approval_group_id,
                    apc.position_seq_no,
                    apc.position_description,
                    apc.display_status,
                    apc.position_code,
                    apc.next_position_message,
                    ag.approval_group_description   
            FROM 0_approval_group ag,
                    0_approval_path_configuration apc 
            WHERE ag.approval_group_id = apc.approval_group_id AND 
                    apc.approval_path_id = '7' AND 
                    ag.approval_group_id = '13' 
            ORDER BY apc.position_seq_no

2022-06-01 15:03:42.435117
SELECT * FROM 0_approvers 
            WHERE approval_group_id = '13' AND user_id = '155'

2022-06-01 15:03:42.436826
SELECT pt.* 
            FROM 0_project_tasks pt  
            WHERE pt.task_id ='6'

2022-06-01 15:03:42.438297
SELECT pt.* 
            FROM 0_project_tasks pt  
            WHERE pt.task_id ='10'

2022-06-01 15:03:42.442348
SELECT pt.* 
            FROM 0_project_tasks pt  
            WHERE pt.task_id ='11'

2022-06-01 15:03:42.444595
UPDATE 0_i_owe_you
                SET next_approval_group_id = '0',  
                        approval_status = '30',  
                        display_status = '', 
                        approved_by = '155',
                        approved_on = '2022-06-01 15:03:42', row_state = '4' 
                WHERE id = '350' AND row_state = '3' AND approval_status NOT IN ('30', '40')

2022-06-01 15:03:42.446505
INSERT INTO 0_approval_log(
                        project_id, tran_type, 
                        tran_no, approval_status, next_approval_group_id,
                        display_status, position_code,
                        comment, 
                        approved_by, approved_on)
    		VALUES ('10', '107', '350', '30', '0', '', '', 'I Owe You #350 has been approved', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.452242
SELECT * 
            FROM 0_task_cost_allocations 
            WHERE tran_type = '107' AND 
                    tran_no = '350' AND 
                    task_id = '6'

2022-06-01 15:03:42.463224
SELECT SUM(amount) total 
                FROM 0_task_cost_allocations 
                WHERE task_id = '6'

2022-06-01 15:03:42.465429
UPDATE 0_project_tasks 
                SET budget_allocated = '2584909.97',  
                    row_state = 344 
                WHERE task_id = '6' AND 
                    row_state = 343

2022-06-01 15:03:42.467321
INSERT INTO 0_task_cost_allocation_log(
                        task_id, tran_type, 
                        tran_no, amount, 
                        allocated_by, allocated_on)
    		VALUES ('6', '107', '350', '2584909.97', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.471525
INSERT INTO 0_task_cost_allocations(
                        task_id, tran_type, 
                        tran_no, amount, 
                        total_allocation,
                        updated_by, updated_on)
    		VALUES ('6', '107', '350', '200.00', '2584909.97', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.474146
INSERT INTO 0_task_cost_allocation_log(
                        task_id, tran_type, 
                        tran_no, amount, 
                        allocated_by, allocated_on)
    		VALUES ('6', '107', '350', '200.00', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.475927
SELECT * 
            FROM 0_task_cost_allocations 
            WHERE tran_type = '107' AND 
                    tran_no = '350' AND 
                    task_id = '10'

2022-06-01 15:03:42.477840
SELECT SUM(amount) total 
                FROM 0_task_cost_allocations 
                WHERE task_id = '10'

2022-06-01 15:03:42.479611
UPDATE 0_project_tasks 
                SET budget_allocated = '3342707',  
                    row_state = 55 
                WHERE task_id = '10' AND 
                    row_state = 54

2022-06-01 15:03:42.481291
INSERT INTO 0_task_cost_allocation_log(
                        task_id, tran_type, 
                        tran_no, amount, 
                        allocated_by, allocated_on)
    		VALUES ('10', '107', '350', '3342707', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.482824
INSERT INTO 0_task_cost_allocations(
                        task_id, tran_type, 
                        tran_no, amount, 
                        total_allocation,
                        updated_by, updated_on)
    		VALUES ('10', '107', '350', '3500.00', '3342707', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.484574
INSERT INTO 0_task_cost_allocation_log(
                        task_id, tran_type, 
                        tran_no, amount, 
                        allocated_by, allocated_on)
    		VALUES ('10', '107', '350', '3500.00', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.486068
SELECT * 
            FROM 0_task_cost_allocations 
            WHERE tran_type = '107' AND 
                    tran_no = '350' AND 
                    task_id = '11'

2022-06-01 15:03:42.487901
SELECT SUM(amount) total 
                FROM 0_task_cost_allocations 
                WHERE task_id = '11'

2022-06-01 15:03:42.489424
UPDATE 0_project_tasks 
                SET budget_allocated = '1203454',  
                    row_state = 195 
                WHERE task_id = '11' AND 
                    row_state = 194

2022-06-01 15:03:42.490946
INSERT INTO 0_task_cost_allocation_log(
                        task_id, tran_type, 
                        tran_no, amount, 
                        allocated_by, allocated_on)
    		VALUES ('11', '107', '350', '1203454', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.492512
INSERT INTO 0_task_cost_allocations(
                        task_id, tran_type, 
                        tran_no, amount, 
                        total_allocation,
                        updated_by, updated_on)
    		VALUES ('11', '107', '350', '2020.00', '1203454', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.494022
INSERT INTO 0_task_cost_allocation_log(
                        task_id, tran_type, 
                        tran_no, amount, 
                        allocated_by, allocated_on)
    		VALUES ('11', '107', '350', '2020.00', '155', '2022-06-01 15:03:42')

2022-06-01 15:03:42.495434
COMMIT

2022-06-01 15:03:50.124549
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:03:50.129262
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:03:50.131464
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:03:50.133162
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:03:50.135022
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:03:50.136780
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:03:50.138491
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:03:50.140786
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 0, 10

2022-06-01 15:03:50.143691
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.145109
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:50.146936
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.148409
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:50.150217
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.151688
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:50.153550
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.155036
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:50.156843
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.159348
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:50.161222
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.165035
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:50.167152
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.168805
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:50.170597
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.172054
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:50.173863
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.175324
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:50.177047
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:50.178426
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:53.650336
SELECT * FROM 0_lists  
		WHERE 
              list_code= 'PETTY_CASH_TYPES'

2022-06-01 15:03:53.652493
SELECT id, value_name, list_code, value_code,  value_description  FROM 0_list_values WHERE inactive = 0 AND list_code = 'PETTY_CASH_TYPES' ORDER BY value_name

2022-06-01 15:03:53.654396
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =155 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 15:03:53.656154
SELECT id, name  FROM 0_petty_cash_floats  ORDER BY name

2022-06-01 15:03:53.658013
SELECT company_code, CONCAT(company_code, ' - ', company_name) company_name 
            FROM group_companies  ORDER BY default_company DESC

2022-06-01 15:03:53.659644
SELECT db_name FROM group_companies 
                WHERE default_company = 1 LIMIT 1

2022-06-01 15:03:53.665306
SELECT employee_code, 
                    CONCAT(employee_code, ' - ', initials, ' ', last_name) name 
            FROM uke_db.0_employee_master  ORDER BY name

2022-06-01 15:03:53.668308
SELECT 
                ou.id,
                ou.batch_no,
                ou.company_code,
                pm.description project_description,                
                pf.name float_name,
                pctn.value_name type_name,
                ou.amount,
                ou.tran_date,
                ou.comments,    
                ou.approval_status,
                ou.batch_complete,
                ou.employee_code,
                ou.closed_for_payments,
                b.approval_status batch_approval_status,
                b.complete 
            FROM 0_i_owe_you ou 
                    INNER JOIN 0_projects_master pm ON 
                            ou.project_id = pm.project_id 
                    INNER JOIN 0_petty_cash_floats pf ON    
                            ou.float_id = pf.id 
                    INNER JOIN 0_list_values pctn ON 
                            ou.type = pctn.id AND pctn.list_code = 'PETTY_CASH_TYPES' 
                    LEFT JOIN 0_i_owe_you_batches b ON 
                            ou.batch_no = b.batch_no 
                    LEFT JOIN group_companies gc ON 
                            ou.company_code = gc.company_code 
             WHERE (1=1  AND ou.tran_date >='2022-05-18'AND ou.tran_date <='2022-06-08') ORDER BY ou.id, tran_date LIMIT 30, 10

2022-06-01 15:03:53.671147
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:53.672556
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:53.674400
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:53.675821
SELECT * FROM uke_db.0_employee_master WHERE employee_code='014'

2022-06-01 15:03:53.677732
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:53.679196
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:53.680953
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:53.682363
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

2022-06-01 15:03:53.684229
SELECT db_name FROM group_companies 
                WHERE company_code = 'UKE'

2022-06-01 15:03:53.685607
SELECT * FROM uke_db.0_employee_master WHERE employee_code='037'

