[2023-09-27 14:25:00] local.DEBUG: handle info from legacy provider [2023-09-27 14:25:00] local.DEBUG: find or create user [2023-09-27 14:25:01] local.DEBUG: user exists [2023-09-27 14:25:01] local.DEBUG: redirect to process login [2023-09-27 14:25:04] local.DEBUG: getUser ok [2023-09-27 14:25:05] local.DEBUG: redirect to / [2023-09-27 14:25:12] local.DEBUG: getUserOpenJobs [2023-09-27 14:25:13] local.DEBUG: getJobsCount2API() [2023-09-27 14:25:19] local.DEBUG: getJobsCount2API() [2023-09-27 14:25:31] local.DEBUG: show() [2023-09-27 14:25:35] local.DEBUG: getJobAPI() [2023-09-27 14:25:35] local.DEBUG: getJob() [2023-09-27 14:25:35] local.DEBUG: getJobsCount2API() [2023-09-27 14:25:35] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:25:35] local.DEBUG: {"id":50} [2023-09-27 14:25:35] local.DEBUG: job channel [2023-09-27 14:25:39] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:25:40] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 74.38, ), ) [2023-09-27 14:25:55] local.DEBUG: getUserOpenJobs [2023-09-27 14:25:55] local.DEBUG: getJobsCount2API() [2023-09-27 14:26:02] local.DEBUG: getJobsCount2API() [2023-09-27 14:26:36] local.DEBUG: show() [2023-09-27 14:26:38] local.DEBUG: getJobsCount2API() [2023-09-27 14:26:38] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:26:38] local.DEBUG: {"id":7} [2023-09-27 14:26:38] local.DEBUG: job channel [2023-09-27 14:26:38] local.DEBUG: getJobAPI() [2023-09-27 14:26:38] local.DEBUG: getJob() [2023-09-27 14:26:41] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:26:42] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1309', ), 'time' => 90.26, ), ) [2023-09-27 14:26:49] local.DEBUG: show() [2023-09-27 14:26:51] local.DEBUG: job channel [2023-09-27 14:26:51] local.DEBUG: getJobsCount2API() [2023-09-27 14:26:51] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:26:51] local.DEBUG: {"id":50} [2023-09-27 14:26:51] local.DEBUG: getJobAPI() [2023-09-27 14:26:51] local.DEBUG: getJob() [2023-09-27 14:26:55] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:26:55] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 29.55, ), ) [2023-09-27 14:37:15] local.DEBUG: show() [2023-09-27 14:37:15] local.DEBUG: job channel [2023-09-27 14:37:19] local.DEBUG: getJobsCount2API() [2023-09-27 14:37:19] local.DEBUG: job channel [2023-09-27 14:37:19] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:37:19] local.DEBUG: {"id":50} [2023-09-27 14:37:19] local.DEBUG: getJobAPI() [2023-09-27 14:37:19] local.DEBUG: getJob() [2023-09-27 14:37:20] local.DEBUG: array ( 'ID' => '1356', 'customerID' => '1200', 'complianceTypeID' => '0', 'eotID' => '0', 'eotDate' => '0000-00-00', 'parentGroupID' => '0', 'departmentID' => '8', 'is_internal' => '0', 'job_sequence' => '1', 'hodID' => '0', 'serviceTypeID' => '1', 'jobTypeID' => '1', 'revenue_driver_id' => '0', 'deadline' => '2023-05-31', 'description' => 'FY23', 'remarks' => '', 'status' => '1', 'is_pending' => '0', 'reason_pending' => '', 'createdTS' => '2023-03-27 11:54:58', 'yearEndDate' => '2023-12-31', 'complianceDate' => '0000-00-00', 'fileNo' => '', 'taxSubmissionDate' => '2024-07-31', 'submissionTS' => '0000-00-00 00:00:00', 'completedDate' => '0000-00-00', 'createdBY' => '539', 'updatedTS' => '2023-03-27 11:58:06', 'updatedBY' => '539', 'acknowledgeTS' => '2023-03-27 11:58:06', 'acknowledgeBY' => '539', 'is_delete' => '0', 'simulation_id' => NULL, 'contract_fee' => '12', 'quotation_amount' => '0', 'financial_year' => '2023', 'financial_revenue' => '0', 'financial_turnover_id' => '0', 'jobTypeName' => 'Financial Statement Audit', 'team_leader' => '275', ) [2023-09-27 14:37:22] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:37:22] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 13.85, ), ) [2023-09-27 14:38:24] local.DEBUG: show() [2023-09-27 14:38:26] local.DEBUG: job channel [2023-09-27 14:38:26] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:38:26] local.DEBUG: getJobsCount2API() [2023-09-27 14:38:26] local.DEBUG: {"id":50} [2023-09-27 14:38:26] local.DEBUG: getJobAPI() [2023-09-27 14:38:26] local.DEBUG: getJob() [2023-09-27 14:38:29] local.DEBUG: array ( 'ID' => '1356', 'customerID' => '1200', 'complianceTypeID' => '0', 'eotID' => '0', 'eotDate' => '0000-00-00', 'parentGroupID' => '0', 'departmentID' => '8', 'is_internal' => '0', 'job_sequence' => '1', 'hodID' => '0', 'serviceTypeID' => '1', 'jobTypeID' => '1', 'revenue_driver_id' => '0', 'deadline' => '2023-05-31', 'description' => 'FY23', 'remarks' => '', 'status' => '1', 'is_pending' => '0', 'reason_pending' => '', 'createdTS' => '2023-03-27 11:54:58', 'yearEndDate' => '2023-12-31', 'complianceDate' => '0000-00-00', 'fileNo' => '', 'taxSubmissionDate' => '2024-07-31', 'submissionTS' => '0000-00-00 00:00:00', 'completedDate' => '0000-00-00', 'createdBY' => '539', 'updatedTS' => '2023-03-27 11:58:06', 'updatedBY' => '539', 'acknowledgeTS' => '2023-03-27 11:58:06', 'acknowledgeBY' => '539', 'is_delete' => '0', 'simulation_id' => NULL, 'contract_fee' => '12', 'quotation_amount' => '0', 'financial_year' => '2023', 'financial_revenue' => '0', 'financial_turnover_id' => '0', 'jobTypeName' => 'Financial Statement Audit', 'team_leader' => NULL, 'customer' => NULL, ) [2023-09-27 14:38:29] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:38:29] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 11.9, ), ) [2023-09-27 14:39:06] local.DEBUG: show() [2023-09-27 14:39:09] local.DEBUG: job channel [2023-09-27 14:39:09] local.DEBUG: getJobsCount2API() [2023-09-27 14:39:09] local.DEBUG: getJobAPI() [2023-09-27 14:39:09] local.DEBUG: getJob() [2023-09-27 14:39:09] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:39:09] local.DEBUG: {"id":50} [2023-09-27 14:39:12] local.DEBUG: array ( 0 => Illuminate\Http\Client\Response::__set_state(array( 'response' => GuzzleHttp\Psr7\Response::__set_state(array( 'reasonPhrase' => 'Unauthorized', 'statusCode' => 401, 'headers' => array ( 'Date' => array ( 0 => 'Wed, 27 Sep 2023 06:39:08 GMT', ), 'Server' => array ( 0 => 'Apache', ), 'Set-Cookie' => array ( 0 => 'spserp=oere725rcjhdmspf3b0b4685migi1oci; expires=Wed, 27-Sep-2023 08:39:09 GMT; Max-Age=7200; path=/; HttpOnly', ), 'Expires' => array ( 0 => 'Thu, 19 Nov 1981 08:52:00 GMT', ), 'Cache-Control' => array ( 0 => 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', ), 'Pragma' => array ( 0 => 'no-cache', ), 'Access-Control-Allow-Origin' => array ( 0 => '*', ), 'Access-Control-Allow-Methods' => array ( 0 => 'GET, OPTIONS, POST, GET, PUT', ), 'Access-Control-Allow-Headers' => array ( 0 => 'Authorization, Content-Type, Content-Length, Accept-Encoding', ), 'Content-Length' => array ( 0 => '59', ), 'Content-Type' => array ( 0 => 'application/json; charset=UTF-8', ), ), 'headerNames' => array ( 'date' => 'Date', 'server' => 'Server', 'set-cookie' => 'Set-Cookie', 'expires' => 'Expires', 'cache-control' => 'Cache-Control', 'pragma' => 'Pragma', 'access-control-allow-origin' => 'Access-Control-Allow-Origin', 'access-control-allow-methods' => 'Access-Control-Allow-Methods', 'access-control-allow-headers' => 'Access-Control-Allow-Headers', 'content-length' => 'Content-Length', 'content-type' => 'Content-Type', ), 'protocol' => '1.1', 'stream' => GuzzleHttp\Psr7\Stream::__set_state(array( 'stream' => NULL, 'size' => NULL, 'seekable' => true, 'readable' => true, 'writable' => true, 'uri' => 'php://temp', 'customMetadata' => array ( ), )), )), 'decoded' => NULL, 'cookies' => GuzzleHttp\Cookie\CookieJar::__set_state(array( 'cookies' => array ( 0 => GuzzleHttp\Cookie\SetCookie::__set_state(array( 'data' => array ( 'Name' => 'spserp', 'Value' => 'oere725rcjhdmspf3b0b4685migi1oci', 'Domain' => 'salihin.noip.me', 'Path' => '/', 'Max-Age' => '7200', 'Expires' => 1695803949, 'Secure' => false, 'Discard' => false, 'HttpOnly' => true, ), )), ), 'strictMode' => false, )), 'transferStats' => GuzzleHttp\TransferStats::__set_state(array( 'request' => GuzzleHttp\Psr7\Request::__set_state(array( 'method' => 'POST', 'requestTarget' => NULL, 'uri' => GuzzleHttp\Psr7\Uri::__set_state(array( 'scheme' => 'https', 'userInfo' => '', 'host' => 'salihin.noip.me', 'port' => NULL, 'path' => '/spserp.dev/web-api/users/user', 'query' => '', 'fragment' => '', 'composedComponents' => 'https://salihin.noip.me/spserp.dev/web-api/users/user', )), 'headers' => array ( 'Content-Length' => array ( 0 => '11', ), 'User-Agent' => array ( 0 => 'GuzzleHttp/7', ), 'Host' => array ( 0 => 'salihin.noip.me', ), 'Authorization' => array ( 0 => 'Bearer Bearer W4yCAqqqfpPLx2KpRCpmrdeLgzSFMwqxTFK6L9gyFEKdraQD4tjUCaQBUPav6ccf', ), 'Content-Type' => array ( 0 => 'application/x-www-form-urlencoded', ), 'Accept' => array ( 0 => 'application/json', ), ), 'headerNames' => array ( 'content-length' => 'Content-Length', 'user-agent' => 'User-Agent', 'host' => 'Host', 'authorization' => 'Authorization', 'content-type' => 'Content-Type', 'accept' => 'Accept', ), 'protocol' => '1.1', 'stream' => GuzzleHttp\Psr7\Stream::__set_state(array( 'stream' => NULL, 'size' => 11, 'seekable' => true, 'readable' => true, 'writable' => true, 'uri' => 'php://temp', 'customMetadata' => array ( ), )), )), 'response' => GuzzleHttp\Psr7\Response::__set_state(array( 'reasonPhrase' => 'Unauthorized', 'statusCode' => 401, 'headers' => array ( 'Date' => array ( 0 => 'Wed, 27 Sep 2023 06:39:08 GMT', ), 'Server' => array ( 0 => 'Apache', ), 'Set-Cookie' => array ( 0 => 'spserp=oere725rcjhdmspf3b0b4685migi1oci; expires=Wed, 27-Sep-2023 08:39:09 GMT; Max-Age=7200; path=/; HttpOnly', ), 'Expires' => array ( 0 => 'Thu, 19 Nov 1981 08:52:00 GMT', ), 'Cache-Control' => array ( 0 => 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', ), 'Pragma' => array ( 0 => 'no-cache', ), 'Access-Control-Allow-Origin' => array ( 0 => '*', ), 'Access-Control-Allow-Methods' => array ( 0 => 'GET, OPTIONS, POST, GET, PUT', ), 'Access-Control-Allow-Headers' => array ( 0 => 'Authorization, Content-Type, Content-Length, Accept-Encoding', ), 'Content-Length' => array ( 0 => '59', ), 'Content-Type' => array ( 0 => 'application/json; charset=UTF-8', ), ), 'headerNames' => array ( 'date' => 'Date', 'server' => 'Server', 'set-cookie' => 'Set-Cookie', 'expires' => 'Expires', 'cache-control' => 'Cache-Control', 'pragma' => 'Pragma', 'access-control-allow-origin' => 'Access-Control-Allow-Origin', 'access-control-allow-methods' => 'Access-Control-Allow-Methods', 'access-control-allow-headers' => 'Access-Control-Allow-Headers', 'content-length' => 'Content-Length', 'content-type' => 'Content-Type', ), 'protocol' => '1.1', 'stream' => GuzzleHttp\Psr7\Stream::__set_state(array( 'stream' => NULL, 'size' => NULL, 'seekable' => true, 'readable' => true, 'writable' => true, 'uri' => 'php://temp', 'customMetadata' => array ( ), )), )), 'transferTime' => 1.267908, 'handlerStats' => array ( 'url' => 'https://salihin.noip.me/spserp.dev/web-api/users/user', 'content_type' => 'application/json; charset=UTF-8', 'http_code' => 401, 'header_size' => 594, 'request_size' => 298, 'filetime' => -1, 'ssl_verify_result' => 0, 'redirect_count' => 0, 'total_time' => 1.267908, 'namelookup_time' => 0.002323, 'connect_time' => 0.004742, 'pretransfer_time' => 0.059995, 'size_upload' => 11.0, 'size_download' => 59.0, 'speed_download' => 46.0, 'speed_upload' => 8.0, 'download_content_length' => 59.0, 'upload_content_length' => 11.0, 'starttransfer_time' => 1.267703, 'redirect_time' => 0.0, 'redirect_url' => '', 'primary_ip' => '175.143.40.245', 'certinfo' => array ( ), 'primary_port' => 443, 'local_ip' => '192.168.50.196', 'local_port' => 64921, 'http_version' => 2, 'protocol' => 2, 'ssl_verifyresult' => 0, 'scheme' => 'HTTPS', 'appconnect_time_us' => 59810, 'connect_time_us' => 4742, 'namelookup_time_us' => 2323, 'pretransfer_time_us' => 59995, 'redirect_time_us' => 0, 'starttransfer_time_us' => 1267703, 'total_time_us' => 1267908, 'appconnect_time' => 0.05981, ), 'handlerErrorData' => 0, )), )), 1 => Illuminate\Http\Client\Response::__set_state(array( 'response' => GuzzleHttp\Psr7\Response::__set_state(array( 'reasonPhrase' => 'Unauthorized', 'statusCode' => 401, 'headers' => array ( 'Date' => array ( 0 => 'Wed, 27 Sep 2023 06:39:08 GMT', ), 'Server' => array ( 0 => 'Apache', ), 'Set-Cookie' => array ( 0 => 'spserp=80rm9ofaj90oltp1e9jvrna96uqijum9; expires=Wed, 27-Sep-2023 08:39:09 GMT; Max-Age=7200; path=/; HttpOnly', ), 'Expires' => array ( 0 => 'Thu, 19 Nov 1981 08:52:00 GMT', ), 'Cache-Control' => array ( 0 => 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', ), 'Pragma' => array ( 0 => 'no-cache', ), 'Access-Control-Allow-Origin' => array ( 0 => '*', ), 'Access-Control-Allow-Methods' => array ( 0 => 'GET, OPTIONS, POST, GET, PUT', ), 'Access-Control-Allow-Headers' => array ( 0 => 'Authorization, Content-Type, Content-Length, Accept-Encoding', ), 'Content-Length' => array ( 0 => '59', ), 'Content-Type' => array ( 0 => 'application/json; charset=UTF-8', ), ), 'headerNames' => array ( 'date' => 'Date', 'server' => 'Server', 'set-cookie' => 'Set-Cookie', 'expires' => 'Expires', 'cache-control' => 'Cache-Control', 'pragma' => 'Pragma', 'access-control-allow-origin' => 'Access-Control-Allow-Origin', 'access-control-allow-methods' => 'Access-Control-Allow-Methods', 'access-control-allow-headers' => 'Access-Control-Allow-Headers', 'content-length' => 'Content-Length', 'content-type' => 'Content-Type', ), 'protocol' => '1.1', 'stream' => GuzzleHttp\Psr7\Stream::__set_state(array( 'stream' => NULL, 'size' => NULL, 'seekable' => true, 'readable' => true, 'writable' => true, 'uri' => 'php://temp', 'customMetadata' => array ( ), )), )), 'decoded' => NULL, 'cookies' => GuzzleHttp\Cookie\CookieJar::__set_state(array( 'cookies' => array ( 0 => GuzzleHttp\Cookie\SetCookie::__set_state(array( 'data' => array ( 'Name' => 'spserp', 'Value' => '80rm9ofaj90oltp1e9jvrna96uqijum9', 'Domain' => 'salihin.noip.me', 'Path' => '/', 'Max-Age' => '7200', 'Expires' => 1695803949, 'Secure' => false, 'Discard' => false, 'HttpOnly' => true, ), )), ), 'strictMode' => false, )), 'transferStats' => GuzzleHttp\TransferStats::__set_state(array( 'request' => GuzzleHttp\Psr7\Request::__set_state(array( 'method' => 'POST', 'requestTarget' => NULL, 'uri' => GuzzleHttp\Psr7\Uri::__set_state(array( 'scheme' => 'https', 'userInfo' => '', 'host' => 'salihin.noip.me', 'port' => NULL, 'path' => '/spserp.dev/web-api/crm/company', 'query' => '', 'fragment' => '', 'composedComponents' => 'https://salihin.noip.me/spserp.dev/web-api/crm/company', )), 'headers' => array ( 'Content-Length' => array ( 0 => '15', ), 'User-Agent' => array ( 0 => 'GuzzleHttp/7', ), 'Host' => array ( 0 => 'salihin.noip.me', ), 'Authorization' => array ( 0 => 'Bearer Bearer W4yCAqqqfpPLx2KpRCpmrdeLgzSFMwqxTFK6L9gyFEKdraQD4tjUCaQBUPav6ccf', ), 'Content-Type' => array ( 0 => 'application/x-www-form-urlencoded', ), 'Accept' => array ( 0 => 'application/json', ), ), 'headerNames' => array ( 'content-length' => 'Content-Length', 'user-agent' => 'User-Agent', 'host' => 'Host', 'authorization' => 'Authorization', 'content-type' => 'Content-Type', 'accept' => 'Accept', ), 'protocol' => '1.1', 'stream' => GuzzleHttp\Psr7\Stream::__set_state(array( 'stream' => NULL, 'size' => 15, 'seekable' => true, 'readable' => true, 'writable' => true, 'uri' => 'php://temp', 'customMetadata' => array ( ), )), )), 'response' => GuzzleHttp\Psr7\Response::__set_state(array( 'reasonPhrase' => 'Unauthorized', 'statusCode' => 401, 'headers' => array ( 'Date' => array ( 0 => 'Wed, 27 Sep 2023 06:39:08 GMT', ), 'Server' => array ( 0 => 'Apache', ), 'Set-Cookie' => array ( 0 => 'spserp=80rm9ofaj90oltp1e9jvrna96uqijum9; expires=Wed, 27-Sep-2023 08:39:09 GMT; Max-Age=7200; path=/; HttpOnly', ), 'Expires' => array ( 0 => 'Thu, 19 Nov 1981 08:52:00 GMT', ), 'Cache-Control' => array ( 0 => 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', ), 'Pragma' => array ( 0 => 'no-cache', ), 'Access-Control-Allow-Origin' => array ( 0 => '*', ), 'Access-Control-Allow-Methods' => array ( 0 => 'GET, OPTIONS, POST, GET, PUT', ), 'Access-Control-Allow-Headers' => array ( 0 => 'Authorization, Content-Type, Content-Length, Accept-Encoding', ), 'Content-Length' => array ( 0 => '59', ), 'Content-Type' => array ( 0 => 'application/json; charset=UTF-8', ), ), 'headerNames' => array ( 'date' => 'Date', 'server' => 'Server', 'set-cookie' => 'Set-Cookie', 'expires' => 'Expires', 'cache-control' => 'Cache-Control', 'pragma' => 'Pragma', 'access-control-allow-origin' => 'Access-Control-Allow-Origin', 'access-control-allow-methods' => 'Access-Control-Allow-Methods', 'access-control-allow-headers' => 'Access-Control-Allow-Headers', 'content-length' => 'Content-Length', 'content-type' => 'Content-Type', ), 'protocol' => '1.1', 'stream' => GuzzleHttp\Psr7\Stream::__set_state(array( 'stream' => NULL, 'size' => NULL, 'seekable' => true, 'readable' => true, 'writable' => true, 'uri' => 'php://temp', 'customMetadata' => array ( ), )), )), 'transferTime' => 1.266948, 'handlerStats' => array ( 'url' => 'https://salihin.noip.me/spserp.dev/web-api/crm/company', 'content_type' => 'application/json; charset=UTF-8', 'http_code' => 401, 'header_size' => 594, 'request_size' => 303, 'filetime' => -1, 'ssl_verify_result' => 0, 'redirect_count' => 0, 'total_time' => 1.266948, 'namelookup_time' => 0.001358, 'connect_time' => 0.027113, 'pretransfer_time' => 0.072727, 'size_upload' => 15.0, 'size_download' => 59.0, 'speed_download' => 46.0, 'speed_upload' => 11.0, 'download_content_length' => 59.0, 'upload_content_length' => 15.0, 'starttransfer_time' => 1.266664, 'redirect_time' => 0.0, 'redirect_url' => '', 'primary_ip' => '175.143.40.245', 'certinfo' => array ( ), 'primary_port' => 443, 'local_ip' => '192.168.50.196', 'local_port' => 64922, 'http_version' => 2, 'protocol' => 2, 'ssl_verifyresult' => 0, 'scheme' => 'HTTPS', 'appconnect_time_us' => 72538, 'connect_time_us' => 27113, 'namelookup_time_us' => 1358, 'pretransfer_time_us' => 72727, 'redirect_time_us' => 0, 'starttransfer_time_us' => 1266664, 'total_time_us' => 1266948, 'appconnect_time' => 0.072538, ), 'handlerErrorData' => 0, )), )), ) [2023-09-27 14:39:12] local.DEBUG: array ( 'ID' => '1356', 'customerID' => '1200', 'complianceTypeID' => '0', 'eotID' => '0', 'eotDate' => '0000-00-00', 'parentGroupID' => '0', 'departmentID' => '8', 'is_internal' => '0', 'job_sequence' => '1', 'hodID' => '0', 'serviceTypeID' => '1', 'jobTypeID' => '1', 'revenue_driver_id' => '0', 'deadline' => '2023-05-31', 'description' => 'FY23', 'remarks' => '', 'status' => '1', 'is_pending' => '0', 'reason_pending' => '', 'createdTS' => '2023-03-27 11:54:58', 'yearEndDate' => '2023-12-31', 'complianceDate' => '0000-00-00', 'fileNo' => '', 'taxSubmissionDate' => '2024-07-31', 'submissionTS' => '0000-00-00 00:00:00', 'completedDate' => '0000-00-00', 'createdBY' => '539', 'updatedTS' => '2023-03-27 11:58:06', 'updatedBY' => '539', 'acknowledgeTS' => '2023-03-27 11:58:06', 'acknowledgeBY' => '539', 'is_delete' => '0', 'simulation_id' => NULL, 'contract_fee' => '12', 'quotation_amount' => '0', 'financial_year' => '2023', 'financial_revenue' => '0', 'financial_turnover_id' => '0', 'jobTypeName' => 'Financial Statement Audit', 'team_leader' => NULL, 'customer' => NULL, ) [2023-09-27 14:39:12] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:39:12] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 12.06, ), ) [2023-09-27 14:40:16] local.DEBUG: show() [2023-09-27 14:40:19] local.DEBUG: getJobsCount2API() [2023-09-27 14:40:19] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:40:19] local.DEBUG: {"id":50} [2023-09-27 14:40:19] local.DEBUG: getJobAPI() [2023-09-27 14:40:19] local.DEBUG: getJob() [2023-09-27 14:40:19] local.DEBUG: job channel [2023-09-27 14:40:22] local.DEBUG: {"status":"error","message":"you clearly not authorized"} [2023-09-27 14:40:22] local.DEBUG: {"status":"error","message":"you clearly not authorized"} [2023-09-27 14:40:22] local.DEBUG: array ( 'ID' => '1356', 'customerID' => '1200', 'complianceTypeID' => '0', 'eotID' => '0', 'eotDate' => '0000-00-00', 'parentGroupID' => '0', 'departmentID' => '8', 'is_internal' => '0', 'job_sequence' => '1', 'hodID' => '0', 'serviceTypeID' => '1', 'jobTypeID' => '1', 'revenue_driver_id' => '0', 'deadline' => '2023-05-31', 'description' => 'FY23', 'remarks' => '', 'status' => '1', 'is_pending' => '0', 'reason_pending' => '', 'createdTS' => '2023-03-27 11:54:58', 'yearEndDate' => '2023-12-31', 'complianceDate' => '0000-00-00', 'fileNo' => '', 'taxSubmissionDate' => '2024-07-31', 'submissionTS' => '0000-00-00 00:00:00', 'completedDate' => '0000-00-00', 'createdBY' => '539', 'updatedTS' => '2023-03-27 11:58:06', 'updatedBY' => '539', 'acknowledgeTS' => '2023-03-27 11:58:06', 'acknowledgeBY' => '539', 'is_delete' => '0', 'simulation_id' => NULL, 'contract_fee' => '12', 'quotation_amount' => '0', 'financial_year' => '2023', 'financial_revenue' => '0', 'financial_turnover_id' => '0', 'jobTypeName' => 'Financial Statement Audit', 'team_leader' => NULL, 'customer' => NULL, ) [2023-09-27 14:40:22] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:40:22] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 11.77, ), ) [2023-09-27 14:41:51] local.DEBUG: show() [2023-09-27 14:41:53] local.DEBUG: job channel [2023-09-27 14:41:53] local.DEBUG: getJobAPI() [2023-09-27 14:41:53] local.DEBUG: getJob() [2023-09-27 14:41:53] local.DEBUG: getJobsCount2API() [2023-09-27 14:41:53] local.DEBUG: getJobUserPrivilegesAPI() [2023-09-27 14:41:53] local.DEBUG: {"id":50} [2023-09-27 14:41:57] local.DEBUG: {"success":true,"data":{"user_id":"275","staff_id":"SA232","email":"fahim@salihin.com.my","is_delete":"0","profiling_id":"4718","name":"MUHAMMAD FAHIM BIN ARIPIN","gender_id":"1","title":null,"file_name":null,"file_location":null,"company_id":"1","company":"SALIHIN","business_entity_id":"3","business_entity":"Aljafree Salihin Kuzaimi ","branch_id":"1","branch":"Corporate Center","division_id":"6","division":"Audit and Assurance","department_id":"8","department":"Audit and Assurance","employee_subgroup_id":"2","employee_subgroup":"Senior Management","position_id":"11","hod_for":null,"position":"Associate Director"}} [2023-09-27 14:41:57] local.DEBUG: {"success":true,"data":{"id":"1200","is_delete":"0","name":"CBG CAPITAL SDN BHD","group_company":"KUMPULAN POWERNET BERHAD","roc_no":"","profile":"","grade":null,"type":"CUSTOMER","individual":"0","status_id":"1","status":"ACTIVE","state":null,"country":null,"region":null,"address":", , ","phone":"","email":"","industries":null,"company_type":null}} [2023-09-27 14:41:57] local.DEBUG: array ( 'ID' => '1356', 'customerID' => '1200', 'complianceTypeID' => '0', 'eotID' => '0', 'eotDate' => '0000-00-00', 'parentGroupID' => '0', 'departmentID' => '8', 'is_internal' => '0', 'job_sequence' => '1', 'hodID' => '0', 'serviceTypeID' => '1', 'jobTypeID' => '1', 'revenue_driver_id' => '0', 'deadline' => '2023-05-31', 'description' => 'FY23', 'remarks' => '', 'status' => '1', 'is_pending' => '0', 'reason_pending' => '', 'createdTS' => '2023-03-27 11:54:58', 'yearEndDate' => '2023-12-31', 'complianceDate' => '0000-00-00', 'fileNo' => '', 'taxSubmissionDate' => '2024-07-31', 'submissionTS' => '0000-00-00 00:00:00', 'completedDate' => '0000-00-00', 'createdBY' => '539', 'updatedTS' => '2023-03-27 11:58:06', 'updatedBY' => '539', 'acknowledgeTS' => '2023-03-27 11:58:06', 'acknowledgeBY' => '539', 'is_delete' => '0', 'simulation_id' => NULL, 'contract_fee' => '12', 'quotation_amount' => '0', 'financial_year' => '2023', 'financial_revenue' => '0', 'financial_turnover_id' => '0', 'jobTypeName' => 'Financial Statement Audit', 'team_leader' => array ( 'user_id' => '275', 'staff_id' => 'SA232', 'email' => 'fahim@salihin.com.my', 'is_delete' => '0', 'profiling_id' => '4718', 'name' => 'MUHAMMAD FAHIM BIN ARIPIN', 'gender_id' => '1', 'title' => NULL, 'file_name' => NULL, 'file_location' => NULL, 'company_id' => '1', 'company' => 'SALIHIN', 'business_entity_id' => '3', 'business_entity' => 'Aljafree Salihin Kuzaimi ', 'branch_id' => '1', 'branch' => 'Corporate Center', 'division_id' => '6', 'division' => 'Audit and Assurance', 'department_id' => '8', 'department' => 'Audit and Assurance', 'employee_subgroup_id' => '2', 'employee_subgroup' => 'Senior Management', 'position_id' => '11', 'hod_for' => NULL, 'position' => 'Associate Director', ), 'customer' => array ( 'id' => '1200', 'is_delete' => '0', 'name' => 'CBG CAPITAL SDN BHD', 'group_company' => 'KUMPULAN POWERNET BERHAD', 'roc_no' => '', 'profile' => '', 'grade' => NULL, 'type' => 'CUSTOMER', 'individual' => '0', 'status_id' => '1', 'status' => 'ACTIVE', 'state' => NULL, 'country' => NULL, 'region' => NULL, 'address' => ', , ', 'phone' => '', 'email' => '', 'industries' => NULL, 'company_type' => NULL, ), ) [2023-09-27 14:41:58] local.DEBUG: getDbStorage [2023-09-27 14:41:58] local.DEBUG: getDbProcesses [2023-09-27 14:41:58] local.DEBUG: getProcessComponentsAPI() [2023-09-27 14:41:58] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpi`.`id` as `id`, `jpi`.`_ref__process_item_id` as `pi_id`, `jpi`.`completed`, `jpi`.`state`, `rpi`.`name`, (select group_concat(jpid.dependee_id) from job_process_item_dependencies jpid where jpid.job_process_item_id = jpi.id and jpid.status = 1) as dependencies_str, `jpi`.`requiep_ep_signoff`, `jpi`.`parent_id` as `pi_parent_id`, `jpi`.`level`, `jpi`.`sequence`, `rpi`.`icon`, `rpi`.`view_component`, `rpi`.`code`, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type = 1 and jpis.deleted_at is null) as last_prepared, (select max(jpis.created_at) from job_process_item_signoffs jpis where jpis.job_process_item_id = jpi.id and jpis.signoff_type in (2,3) and jpis.deleted_at is null) as last_reviewed from `job_process_items` as `jpi` inner join `job_processes` as `jp` on `jp`.`id` = `jpi`.`job_process_id` inner join `jobs` as `j` on `j`.`job_id` = `jp`.`job_id` inner join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` where (`jp`.`status` = ? and `jpi`.`status` = ? and `jp`.`job_id` = ?) and `j`.`deleted_at` is null and `jpi`.`deleted_at` is null and `jp`.`deleted_at` is null', 'bindings' => array ( 0 => 1, 1 => 1, 2 => '1356', ), 'time' => 27.86, ), ) [2023-09-27 14:41:58] local.DEBUG: getDbTeam [2023-09-27 14:41:58] local.DEBUG: getJobPersonnel() [2023-09-27 14:41:58] local.DEBUG: getDbStatus [2023-09-27 14:41:58] local.DEBUG: getDBIssues [2023-09-27 14:41:59] local.DEBUG: getDbActiveProcesses [2023-09-27 14:41:59] local.DEBUG: getDBLockedItems [2023-09-27 14:41:59] local.DEBUG: array ( 0 => array ( 'query' => 'select `vac`.*, `rpi`.`code`, `rpi`.`name` from `view_all_components` as `vac` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `vac`.`process_item_id` where (`vac`.`job_id` = ? and `vac`.`last_prepared_at` >= ?) or (`vac`.`job_id` = ? and `vac`.`last_reviewed_at` >= ?)', 'bindings' => array ( 0 => '1356', 1 => '2023-09-26 00:00:00', 2 => '1356', 3 => '2023-09-26 00:00:00', ), 'time' => 28.64, ), ) [2023-09-27 14:41:59] local.DEBUG: getDbActivePersonnel