[2024-05-10 12:10:29] local.DEBUG: find or create user [2024-05-10 12:10:30] local.DEBUG: user exists [2024-05-10 12:10:33] local.DEBUG: role id: 7 [2024-05-10 12:10:33] local.DEBUG: getInternalRoles2 mode 2 [2024-05-10 12:10:33] local.DEBUG: array ( 0 => array ( 'query' => 'select distinct pa.provider_id, ps.using_default_moderators from `providers_accesses` as `pa` inner join `providers_settings` as `ps` on `ps`.`provider_id` = `pa`.`provider_id` and `ps`.`status` = ? where `pa`.`status` = ? and case when pa.entity_type = "business-entity" then pa.entity_id = ? when pa.entity_type = "department" then pa.entity_id = ? when pa.entity_type = "user" then pa.entity_id = ? end and `pa`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '13', 3 => '1', 4 => '539', ), 'time' => 12.78, ), ) [2024-05-10 12:10:33] local.DEBUG: {"user_id":"539","staff_id":"SA352","email":"syazwanarif@salihin.com.my","is_delete":"0","profiling_id":"4593","name":"MUHD SYAZWAN ARIF BIN NEAMAT","gender_id":"1","title":"Senior Programmer","file_name":null,"file_location":null,"company_id":"1","company":"SALIHIN","business_entity_id":"13","business_entity":"SALIHIN IT Curation Sdn Bhd (formerly known as SALIHIN GST Services Sdn Bhd)","branch_id":"1","branch":"Corporate Center","division_id":"10","division":"IT","department_id":"1","department":"IT","employee_subgroup_id":"4","employee_subgroup":"Executive","position_id":"30","hod_for":null,"position":"Senior Executive II"} [2024-05-10 12:10:33] local.DEBUG: [{"provider_id":13,"using_default_moderators":0},{"provider_id":3,"using_default_moderators":1},{"provider_id":4,"using_default_moderators":1}] [2024-05-10 12:10:33] local.DEBUG: p id: 13 [2024-05-10 12:10:33] local.DEBUG: role id: 12 [2024-05-10 12:10:33] local.DEBUG: is in 1: 1 [2024-05-10 12:10:33] local.DEBUG: is in 2: 1 [2024-05-10 12:10:33] local.DEBUG: is in 3: 1 [2024-05-10 12:10:33] local.DEBUG: is in 4: 1 [2024-05-10 12:10:33] local.DEBUG: role id: 1 [2024-05-10 12:10:33] local.DEBUG: is in 1: 1 [2024-05-10 12:10:33] local.DEBUG: is in 2: 1 [2024-05-10 12:10:33] local.DEBUG: is in 3: 1 [2024-05-10 12:10:33] local.DEBUG: is in 4: [2024-05-10 12:10:33] local.DEBUG: p id: 3 [2024-05-10 12:10:33] local.DEBUG: role id: 12 [2024-05-10 12:10:33] local.DEBUG: is in 1: 1 [2024-05-10 12:10:33] local.DEBUG: is in 2: 1 [2024-05-10 12:10:33] local.DEBUG: is in 3: 1 [2024-05-10 12:10:33] local.DEBUG: is in 4: 1 [2024-05-10 12:10:33] local.DEBUG: role id: 1 [2024-05-10 12:10:33] local.DEBUG: is in 1: 1 [2024-05-10 12:10:33] local.DEBUG: is in 2: 1 [2024-05-10 12:10:33] local.DEBUG: is in 3: 1 [2024-05-10 12:10:33] local.DEBUG: is in 4: [2024-05-10 12:10:33] local.DEBUG: role id: 2 [2024-05-10 12:10:33] local.DEBUG: p id: 4 [2024-05-10 12:10:33] local.DEBUG: role id: 12 [2024-05-10 12:10:33] local.DEBUG: is in 1: 1 [2024-05-10 12:10:33] local.DEBUG: is in 2: 1 [2024-05-10 12:10:33] local.DEBUG: is in 3: 1 [2024-05-10 12:10:33] local.DEBUG: is in 4: 1 [2024-05-10 12:10:33] local.DEBUG: role id: 1 [2024-05-10 12:10:33] local.DEBUG: is in 1: 1 [2024-05-10 12:10:33] local.DEBUG: is in 2: 1 [2024-05-10 12:10:33] local.DEBUG: is in 3: 1 [2024-05-10 12:10:33] local.DEBUG: is in 4: [2024-05-10 12:10:33] local.DEBUG: role id: 2 [2024-05-10 12:11:24] local.DEBUG: {"id":"3","company_id":"1","name":"Aljafree Salihin Kuzaimi ","short_name":"ASK","description":"Auditing and assurance services","roc_no":"AF1522"} [2024-05-10 12:11:37] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:11:37] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 12:11:38] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:33:37] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:33:37] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 12:33:37] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:36:01] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:36:01] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 12:36:02] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:38:53] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:38:53] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 12:38:54] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:39:21] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:39:21] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 12:39:22] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:41:01] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:41:01] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 12:41:01] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:46:22] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '3', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 12:46:26] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '2', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 14:39:40] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 14:39:40] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"} [2024-05-10 14:39:40] local.DEBUG: array ( 'filter_status' => '2', 'filter_date' => '9999', 'filter_payment' => '1', 'filter_submission' => '1', 'filter_view' => '1', 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 16:27:47] local.DEBUG: array ( 'filter_status' => NULL, 'filter_date' => NULL, 'filter_payment' => NULL, 'filter_submission' => NULL, 'filter_view' => NULL, 'custom_start_date' => NULL, 'custom_end_date' => NULL, ) [2024-05-10 16:27:47] local.DEBUG: {"total_unpaid":"2876100.5900","total_paid":"38421074.6000","total_overdue":"2853042.5900","total_notdue":"23058.0000","currencies":"EUR,MYR,USD"}