[2023-04-18 15:27:34] local.DEBUG: handle info from legacy provider [2023-04-18 15:27:34] local.DEBUG: find or create user [2023-04-18 15:27:34] local.DEBUG: user exists [2023-04-18 15:27:34] local.DEBUG: redirect to process login [2023-04-18 15:27:36] local.DEBUG: getUser ok [2023-04-18 15:27:37] local.DEBUG: redirect to / [2023-04-18 15:27:41] local.DEBUG: getUserOpenJobs [2023-04-18 15:27:42] local.DEBUG: getJobsCount2API() [2023-04-18 15:27:48] local.DEBUG: getJobsCount2API() [2023-04-18 15:27:49] local.DEBUG: show() [2023-04-18 15:27:51] local.DEBUG: getJobsCount2API() [2023-04-18 15:27:51] local.DEBUG: getJob() [2023-04-18 15:27:51] local.DEBUG: getJobUserPrivilegesAPI() [2023-04-18 15:27:51] local.DEBUG: {"id":40} [2023-04-18 15:27:51] local.DEBUG: job channel [2023-04-18 15:27:55] local.DEBUG: getDbStorage [2023-04-18 15:27:55] local.DEBUG: getDbProcesses [2023-04-18 15:27:55] local.DEBUG: getDbTeam [2023-04-18 15:27:55] local.DEBUG: getProcessComponentsAPI() [2023-04-18 15:27:55] local.DEBUG: getJobPersonnel() [2023-04-18 15:27:55] local.DEBUG: getDbStatus [2023-04-18 15:27:55] local.DEBUG: getDBIssues [2023-04-18 15:27:55] local.DEBUG: getDBLockedItems [2023-04-18 15:27:55] local.DEBUG: getDbActiveProcesses [2023-04-18 15:27: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 => '1309', ), 'time' => 66.79, ), ) [2023-04-18 15:27:55] 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 => '1309', 1 => '2023-04-17 00:00:00', 2 => '1309', 3 => '2023-04-17 00:00:00', ), 'time' => 12.95, ), ) [2023-04-18 15:27:55] local.DEBUG: getDbActivePersonnel [2023-04-18 15:27:58] local.DEBUG: process channel [2023-04-18 15:27:58] local.DEBUG: getProcessDataAPI() [2023-04-18 15:27:58] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:27:58] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:27:58] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:27:58] local.DEBUG: Array ( [job_process_item_id] => 723 ) [2023-04-18 15:27:59] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpif`.*, `fv`.*, `fst`.`name` as `file_status`, `rpi`.`name` as `process_name`, `rpi`.`code` as `process_code`, `rpi`.`id` as `process_id` from `job_process_item_files` as `jpif` inner join `file_status_types` as `fst` on `fst`.`id` = `jpif`.`file_status_type_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `jpif`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join (select `fv`.`file_name`, `fv`.`file_location`, `fv`.`file_id`, `fv`.`version_number`, `fv`.`status`, `fv`.`name`, `fv`.`code`, `fv`.`size_kb`, `fv`.`id` as `version_id`, `fv`.`extension`, `fv`.`updated_at` as `version_updated_at`, `fv`.`description` from `file_versions` as `fv` where (`fv`.`status` = ?) order by `fv`.`version_number` desc) as `fv` on `jpif`.`id` = `fv`.`file_id` where (`jpif`.`job_id` = ? and `jpif`.`job_process_item_id` = ?) and `jpif`.`file_status` in (?) order by `jpif`.`is_main_documents` desc, `jpif`.`updated_at` desc', 'bindings' => array ( 0 => 2, 1 => '1309', 2 => 723, 3 => 3, ), 'time' => 7.25, ), ) [2023-04-18 15:28:09] local.DEBUG: uploadJobDocument [2023-04-18 15:28:09] local.DEBUG: array ( 'job_id' => '1309', 'job_process_item_id' => 723, 'document_data' => '{"name":"05_Spesifikasi-1.pdf","size":57319,"type":"application/pdf","extension":".pdf","hash":"bed233c96e862507a01662dc4297634fd3971b43287d1f91e31cb86875fc406c"}', ) [2023-04-18 15:28:09] local.DEBUG: Array ( [job.setup.edit] => -1 [job.dashboard.user.view] => 1 [job.dashboard.main.view] => -1 [job.settings.view] => 1 [job.settings.edit] => -1 [job.settings.menu.edit] => -1 [job.settings.menu.delete] => -1 [job.settings.archive-initiate] => 1 [job.settings.archive-approve] => -1 [job.personnel.view] => 1 [job.personnel.logs.view] => 1 [job.personnel.edit] => -1 [job.personnel.external.add] => -1 [job.personnel.external.delete] => -1 [job.issues.view] => 1 [job.issues.add] => -1 [job.issues.edit] => -1 [job.issues.delete] => -1 [job.issues.details.add] => 1 [job.issues.details.edit] => 1 [job.issues.details.delete] => 1 [job.documents.view] => 1 [job.documents.upload] => 1 [job.documents.download] => 1 [job.documents.trash] => 1 [job.documents.purge] => -1 [job.documents.move] => 1 [job.documents.logs.view] => 1 [job.documents.versions.view] => 1 [job.documents.versions.activate] => -1 [job.documents.versions.purge] => -1 [job.documents.comments.view] => 1 [job.documents.comments.add] => 1 [job.documents.comments.edit] => 1 [job.documents.comments.delete] => -1 [job.processes.view] => 1 [job.processes.edit] => 1 [job.processes.review] => -1 [job.processes.approve] => -1 [job.processes.print] => 1 [job.processes.email] => 1 [job.processes.export] => 1 [job.processes.comments.view] => 1 [job.processes.comments.add] => 1 [job.processes.comments.delete] => -1 [job.processes.comments.edit] => 1 [job.processes.logs.view] => 1 [job.processes.lock] => 1 [job.processes.lock-all] => -1 [job.processes.approve.ep] => -1 [job.documents.versions.pin] => 1 ) [2023-04-18 15:28:09] local.DEBUG: stdClass Object ( [name] => 05_Spesifikasi-1.pdf [size] => 57319 [type] => application/pdf [extension] => .pdf [hash] => bed233c96e862507a01662dc4297634fd3971b43287d1f91e31cb86875fc406c ) [2023-04-18 15:28:09] local.DEBUG: f: .pdf 05_Spesifikasi-1.pdf 57319 application/pdf bed233c96e862507a01662dc4297634fd3971b43287d1f91e31cb86875fc406c [2023-04-18 15:28:09] local.DEBUG: creating file [2023-04-18 15:28:09] local.DEBUG: creating version [2023-04-18 15:28:09] local.DEBUG: deleting all versions if any [2023-04-18 15:29:41] local.DEBUG: getProcessDataAPI() [2023-04-18 15:29:41] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:29:41] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:29:41] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:29:41] local.DEBUG: Array ( [job_process_item_id] => 723 ) [2023-04-18 15:29:41] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpif`.*, `fv`.*, `fst`.`name` as `file_status`, `rpi`.`name` as `process_name`, `rpi`.`code` as `process_code`, `rpi`.`id` as `process_id` from `job_process_item_files` as `jpif` inner join `file_status_types` as `fst` on `fst`.`id` = `jpif`.`file_status_type_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `jpif`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join (select `fv`.`file_name`, `fv`.`file_location`, `fv`.`file_id`, `fv`.`version_number`, `fv`.`status`, `fv`.`name`, `fv`.`code`, `fv`.`size_kb`, `fv`.`id` as `version_id`, `fv`.`extension`, `fv`.`updated_at` as `version_updated_at`, `fv`.`description` from `file_versions` as `fv` where (`fv`.`status` = ?) order by `fv`.`version_number` desc) as `fv` on `jpif`.`id` = `fv`.`file_id` where (`jpif`.`job_id` = ? and `jpif`.`job_process_item_id` = ?) and `jpif`.`file_status` in (?) order by `jpif`.`is_main_documents` desc, `jpif`.`updated_at` desc', 'bindings' => array ( 0 => 2, 1 => '1309', 2 => 723, 3 => 3, ), 'time' => 6.01, ), ) [2023-04-18 15:30:00] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:30:00] local.DEBUG: Array ( [file_id] => 0c55c5bc-a040-4198-8a8b-829103d96e0c ) [2023-04-18 15:30:00] local.DEBUG: getFile [2023-04-18 15:30:00] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:30:00] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:30:10] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:30:10] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:30:10] local.DEBUG: Array ( [file_id] => d4cd3c02-bee5-4bb7-9c81-c834d700490a ) [2023-04-18 15:30:10] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:30:10] local.DEBUG: getFile [2023-04-18 15:32:38] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:32:38] local.DEBUG: Array ( [include_archive] => 0 [trashed_only] => 0 ) [2023-04-18 15:32:38] local.DEBUG: getJobDocumentsSummaryAPI 1309 [2023-04-18 15:32:38] local.DEBUG: Array ( ) [2023-04-18 15:32:38] local.DEBUG: job process item id: [2023-04-18 15:32:38] local.DEBUG: array ( 0 => array ( 'query' => 'select `fst`.`id` as `status_type`, `fst`.`name` as `status_type_name`, count(jpif.job_id) as doc_count from `file_status_types` as `fst` left join `job_process_item_files` as `jpif` on `jpif`.`file_status_type_id` = `fst`.`id` and `jpif`.`job_id` = \'1309\' where (`fst`.`deleted_at` is null) group by `fst`.`id`, `fst`.`name`', 'bindings' => array ( ), 'time' => 3.98, ), ) [2023-04-18 15:32:38] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpif`.*, `fv`.*, `fst`.`name` as `file_status`, `rpi`.`name` as `process_name`, `rpi`.`code` as `process_code`, `rpi`.`id` as `process_id` from `job_process_item_files` as `jpif` inner join `file_status_types` as `fst` on `fst`.`id` = `jpif`.`file_status_type_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `jpif`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join (select `fv`.`file_name`, `fv`.`file_location`, `fv`.`file_id`, `fv`.`version_number`, `fv`.`status`, `fv`.`name`, `fv`.`code`, `fv`.`size_kb`, `fv`.`id` as `version_id`, `fv`.`extension`, `fv`.`updated_at` as `version_updated_at`, `fv`.`description` from `file_versions` as `fv` where (`fv`.`status` = ?) order by `fv`.`version_number` desc) as `fv` on `jpif`.`id` = `fv`.`file_id` where (`jpif`.`job_id` = ?) and `jpif`.`file_status` in (?) order by `jpif`.`is_main_documents` desc, `jpif`.`updated_at` desc', 'bindings' => array ( 0 => 2, 1 => '1309', 2 => 3, ), 'time' => 19.12, ), ) [2023-04-18 15:32:40] local.DEBUG: array ( 0 => array ( 'query' => 'select `ul`.`id`, `ul`.`created_at`, `ul`.`job_process_item_id` as `process_id`, `rpi`.`code` as `process_code`, `rpi`.`name` as `process`, `ul`.`activity` as `activity_name`, `u`.`name` as `activity_user`, `u`.`provider_id` as `activity_user_id`, `ui`.`initial` as `activity_user_initial` from `job_logs` as `ul` left join `jobs` as `j` on `j`.`job_id` = `ul`.`job_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `ul`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join `user_sessions` as `us` on `us`.`id` = `ul`.`created_by` left join `users` as `u` on `u`.`id` = `us`.`user_id` left join `users__initials` as `ui` on `ui`.`user_id` = `u`.`id` and `ui`.`status` = ? where (`ul`.`job_id` = ?) order by `ul`.`created_at` desc', 'bindings' => array ( 0 => 1, 1 => '1309', ), 'time' => 119.82, ), ) [2023-04-18 15:36:09] local.DEBUG: process channel [2023-04-18 15:36:09] local.DEBUG: getProcessDataAPI() [2023-04-18 15:36:09] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:36:09] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:36:09] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:36:09] local.DEBUG: Array ( [job_process_item_id] => 723 ) [2023-04-18 15:36:09] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpif`.*, `fv`.*, `fst`.`name` as `file_status`, `rpi`.`name` as `process_name`, `rpi`.`code` as `process_code`, `rpi`.`id` as `process_id` from `job_process_item_files` as `jpif` inner join `file_status_types` as `fst` on `fst`.`id` = `jpif`.`file_status_type_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `jpif`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join (select `fv`.`file_name`, `fv`.`file_location`, `fv`.`file_id`, `fv`.`version_number`, `fv`.`status`, `fv`.`name`, `fv`.`code`, `fv`.`size_kb`, `fv`.`id` as `version_id`, `fv`.`extension`, `fv`.`updated_at` as `version_updated_at`, `fv`.`description` from `file_versions` as `fv` where (`fv`.`status` = ?) order by `fv`.`version_number` desc) as `fv` on `jpif`.`id` = `fv`.`file_id` where (`jpif`.`job_id` = ? and `jpif`.`job_process_item_id` = ?) and `jpif`.`file_status` in (?) order by `jpif`.`is_main_documents` desc, `jpif`.`updated_at` desc', 'bindings' => array ( 0 => 2, 1 => '1309', 2 => 723, 3 => 3, ), 'time' => 4.35, ), ) [2023-04-18 15:36:12] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:36:12] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:36:12] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:36:12] local.DEBUG: Array ( [file_id] => d4cd3c02-bee5-4bb7-9c81-c834d700490a ) [2023-04-18 15:36:12] local.DEBUG: getFile [2023-04-18 15:36:17] local.DEBUG: downloadCheckAPI [2023-04-18 15:36:18] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:36:18] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:36:18] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:36:18] local.DEBUG: Array ( [file_id] => d4cd3c02-bee5-4bb7-9c81-c834d700490a ) [2023-04-18 15:36:18] local.DEBUG: getFile [2023-04-18 15:36:18] local.DEBUG: download [2023-04-18 15:36:18] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:36:18] local.DEBUG: Array ( [job_process_item_id] => 723 ) [2023-04-18 15:36:18] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpif`.*, `fv`.*, `fst`.`name` as `file_status`, `rpi`.`name` as `process_name`, `rpi`.`code` as `process_code`, `rpi`.`id` as `process_id` from `job_process_item_files` as `jpif` inner join `file_status_types` as `fst` on `fst`.`id` = `jpif`.`file_status_type_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `jpif`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join (select `fv`.`file_name`, `fv`.`file_location`, `fv`.`file_id`, `fv`.`version_number`, `fv`.`status`, `fv`.`name`, `fv`.`code`, `fv`.`size_kb`, `fv`.`id` as `version_id`, `fv`.`extension`, `fv`.`updated_at` as `version_updated_at`, `fv`.`description` from `file_versions` as `fv` where (`fv`.`status` = ?) order by `fv`.`version_number` desc) as `fv` on `jpif`.`id` = `fv`.`file_id` where (`jpif`.`job_id` = ? and `jpif`.`job_process_item_id` = ?) and `jpif`.`file_status` in (?) order by `jpif`.`is_main_documents` desc, `jpif`.`updated_at` desc', 'bindings' => array ( 0 => 2, 1 => '1309', 2 => 723, 3 => 3, ), 'time' => 4.99, ), ) [2023-04-18 15:36:20] local.DEBUG: getUserOpenJobs [2023-04-18 15:36:21] local.DEBUG: getJobsCount2API() [2023-04-18 15:36:23] local.DEBUG: singleUpdate2API [2023-04-18 15:36:23] local.DEBUG: array ( 'batch_option' => '6', 'document_id' => 'd4cd3c02-bee5-4bb7-9c81-c834d700490a', ) [2023-04-18 15:36:23] local.DEBUG: array ( 'job.setup.edit' => -1, 'job.dashboard.user.view' => 1, 'job.dashboard.main.view' => -1, 'job.settings.view' => 1, 'job.settings.edit' => -1, 'job.settings.menu.edit' => -1, 'job.settings.menu.delete' => -1, 'job.settings.archive-initiate' => 1, 'job.settings.archive-approve' => -1, 'job.personnel.view' => 1, 'job.personnel.logs.view' => 1, 'job.personnel.edit' => -1, 'job.personnel.external.add' => -1, 'job.personnel.external.delete' => -1, 'job.issues.view' => 1, 'job.issues.add' => -1, 'job.issues.edit' => -1, 'job.issues.delete' => -1, 'job.issues.details.add' => 1, 'job.issues.details.edit' => 1, 'job.issues.details.delete' => 1, 'job.documents.view' => 1, 'job.documents.upload' => 1, 'job.documents.download' => 1, 'job.documents.trash' => 1, 'job.documents.purge' => -1, 'job.documents.move' => 1, 'job.documents.logs.view' => 1, 'job.documents.versions.view' => 1, 'job.documents.versions.activate' => -1, 'job.documents.versions.purge' => -1, 'job.documents.comments.view' => 1, 'job.documents.comments.add' => 1, 'job.documents.comments.edit' => 1, 'job.documents.comments.delete' => -1, 'job.processes.view' => 1, 'job.processes.edit' => 1, 'job.processes.review' => -1, 'job.processes.approve' => -1, 'job.processes.print' => 1, 'job.processes.email' => 1, 'job.processes.export' => 1, 'job.processes.comments.view' => 1, 'job.processes.comments.add' => 1, 'job.processes.comments.delete' => -1, 'job.processes.comments.edit' => 1, 'job.processes.logs.view' => 1, 'job.processes.lock' => 1, 'job.processes.lock-all' => -1, 'job.processes.approve.ep' => -1, 'job.documents.versions.pin' => 1, ) [2023-04-18 15:36:23] local.DEBUG: last updated by user id: 92acd5c9-18ea-4044-9faf-1195d41bb77e [2023-04-18 15:36:23] local.DEBUG: current user id: 92acd5c9-18ea-4044-9faf-1195d41bb77e [2023-04-18 15:36:23] local.DEBUG: unlocking document [2023-04-18 15:36:24] local.DEBUG: getProcessDataA2PI() [2023-04-18 15:36:24] local.DEBUG: array ( 'job_process_item_id' => 723, ) [2023-04-18 15:36:24] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:36:24] local.DEBUG: Array ( [file_id] => d4cd3c02-bee5-4bb7-9c81-c834d700490a ) [2023-04-18 15:36:24] local.DEBUG: getFile [2023-04-18 15:36:24] local.DEBUG: getJobDocuments2API 1309 [2023-04-18 15:36:24] local.DEBUG: Array ( [job_process_item_id] => 723 ) [2023-04-18 15:36:24] local.DEBUG: array ( 0 => array ( 'query' => 'select `jpif`.*, `fv`.*, `fst`.`name` as `file_status`, `rpi`.`name` as `process_name`, `rpi`.`code` as `process_code`, `rpi`.`id` as `process_id` from `job_process_item_files` as `jpif` inner join `file_status_types` as `fst` on `fst`.`id` = `jpif`.`file_status_type_id` left join `job_process_items` as `jpi` on `jpi`.`id` = `jpif`.`job_process_item_id` left join `_ref__process_items` as `rpi` on `rpi`.`id` = `jpi`.`_ref__process_item_id` left join (select `fv`.`file_name`, `fv`.`file_location`, `fv`.`file_id`, `fv`.`version_number`, `fv`.`status`, `fv`.`name`, `fv`.`code`, `fv`.`size_kb`, `fv`.`id` as `version_id`, `fv`.`extension`, `fv`.`updated_at` as `version_updated_at`, `fv`.`description` from `file_versions` as `fv` where (`fv`.`status` = ?) order by `fv`.`version_number` desc) as `fv` on `jpif`.`id` = `fv`.`file_id` where (`jpif`.`job_id` = ? and `jpif`.`job_process_item_id` = ?) and `jpif`.`file_status` in (?) order by `jpif`.`is_main_documents` desc, `jpif`.`updated_at` desc', 'bindings' => array ( 0 => 2, 1 => '1309', 2 => 723, 3 => 3, ), 'time' => 8.07, ), ) [2023-04-18 16:11:11] local.DEBUG: getDBLockedItems [2023-04-18 16:11:11] local.DEBUG: getDBIssues [2023-04-18 16:11:11] local.DEBUG: getDbProcesses [2023-04-18 16:11:11] local.DEBUG: getDbStorage [2023-04-18 16:11:11] local.DEBUG: getJobPersonnel() [2023-04-18 16:11:11] local.DEBUG: getDbActiveProcesses [2023-04-18 16:11:11] 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 => '1309', 1 => '2023-04-17 00:00:00', 2 => '1309', 3 => '2023-04-17 00:00:00', ), 'time' => 21.03, ), ) [2023-04-18 16:11:11] local.DEBUG: getDbStatus [2023-04-18 16:11:11] local.DEBUG: getDbActivePersonnel [2023-04-18 16:11:19] local.DEBUG: getDbActiveProcesses [2023-04-18 16:11:19] 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 => '1309', 1 => '2023-03-19 00:00:00', 2 => '1309', 3 => '2023-03-19 00:00:00', ), 'time' => 8.85, ), ) [2023-04-18 16:11:22] local.DEBUG: getDbActivePersonnel [2023-04-18 16:11:26] local.DEBUG: getDbActivePersonnel [2023-04-18 16:19:47] local.DEBUG: handle info from legacy provider [2023-04-18 16:19:47] local.DEBUG: find or create user [2023-04-18 16:19:47] local.DEBUG: user exists [2023-04-18 16:19:47] local.DEBUG: redirect to process login [2023-04-18 16:19:49] local.DEBUG: getUser ok [2023-04-18 16:19:49] local.DEBUG: redirect to / [2023-04-18 16:19:52] local.DEBUG: getUserOpenJobs [2023-04-18 16:19:52] local.DEBUG: getJobsCount2API() [2023-04-18 16:20:27] local.DEBUG: array ( 0 => array ( 'Key' => '22580234-1063-4585-a3e0-cdd065285735', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 08:42:45.837000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 1 => array ( 'Key' => '245aade1-072f-48bc-96c9-ac72a55e4def', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.634000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"f4e02cb69bcb7dd195f3d33cc602be61"', 'Size' => '99264', 'StorageClass' => 'STANDARD', ), 2 => array ( 'Key' => '246e3a3a-6ce0-42ab-9314-2d5bf8a15eb7', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.573000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 3 => array ( 'Key' => '29deb2ef-c719-40c1-8e2c-ea020a8f9049', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:04:32.648000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 4 => array ( 'Key' => '2add66f9-65ea-4cda-8bf4-d30cde2beb47', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.963000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 5 => array ( 'Key' => '2f33c765-7150-403a-97e9-2f1307db79d1', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.322000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"89019f9dca64d9ae6e76ce00223d0e69"', 'Size' => '99110', 'StorageClass' => 'STANDARD', ), 6 => array ( 'Key' => '322a2969-27b1-4b98-87ca-f0fc4cd69fa1', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 02:45:04.535000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"6d2dd7c1da6f05965fd8ee5f1d248209"', 'Size' => '274720', 'StorageClass' => 'STANDARD', ), 7 => array ( 'Key' => '327d3cd6-1c2d-4fc8-96b4-aee78e71c709/d1ed8a2e-de2b-47db-87d6-8d6bb64c34b2', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 04:32:33.177000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"d984ce42634195427cbd8a4d14d1e3e2"', 'Size' => '96066', 'StorageClass' => 'STANDARD', ), 8 => array ( 'Key' => '34cb6567-a9ae-4d6c-a412-998fe59ec064', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:09:15.879000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 9 => array ( 'Key' => '35c913fd-9a6c-4ea4-ac7a-7f3efe95079d', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 08:29:48.157000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 10 => array ( 'Key' => '393321e2-d754-4e5a-9586-b4ebf9794443', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:56.093000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 11 => array ( 'Key' => '439adf62-3fb8-4c47-b532-8cb8fe706c1e', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.608000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"d984ce42634195427cbd8a4d14d1e3e2"', 'Size' => '96066', 'StorageClass' => 'STANDARD', ), 12 => array ( 'Key' => '48828639-34e9-4181-a1de-3e3454e00801', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:07:23.938000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 13 => array ( 'Key' => '4a703360-d649-45a2-9d9a-10e574a19695', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.503000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 14 => array ( 'Key' => '52f8fabd-43dd-40bd-90a7-b15050029b56', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 08:44:20.286000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 15 => array ( 'Key' => '555f2d4c-222b-4be3-9ab2-5be8e0ee02ac', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 08:57:55.769000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 16 => array ( 'Key' => '55b30526-619d-4b1c-8f5a-97044cb84474/82fb8d34-2c6a-401b-9eb7-5e61d6f93421', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:24:04.242000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"ac02010d470b6e1aaf7a7f8860999a86"', 'Size' => '864216', 'StorageClass' => 'STANDARD', ), 17 => array ( 'Key' => '55b30526-619d-4b1c-8f5a-97044cb84474/8999bb11-bde9-4a11-ab76-21ec78c185dc', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:24:05.013000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"357768dc7fe0ddb799a89195255543d6"', 'Size' => '3704463', 'StorageClass' => 'STANDARD', ), 18 => array ( 'Key' => '55b30526-619d-4b1c-8f5a-97044cb84474/b1c393ca-9544-460b-9ab1-6721b82c86f7', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:24:04.291000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"aefe172625c82ca36f0aed9275e43993"', 'Size' => '1184698', 'StorageClass' => 'STANDARD', ), 19 => array ( 'Key' => '55b30526-619d-4b1c-8f5a-97044cb84474/b5fdd460-813b-4da8-a822-138282fea2ec', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:24:04.802000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"f7ce8125323b0f2a77d5c6621c635fd7"', 'Size' => '3978583', 'StorageClass' => 'STANDARD', ), 20 => array ( 'Key' => '55b30526-619d-4b1c-8f5a-97044cb84474/d228fd89-6089-44bb-bdd3-e3e67c67693a', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:24:06.216000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"ff3e50a378557c3920c80fcca9a32d77"', 'Size' => '20072751', 'StorageClass' => 'STANDARD', ), 21 => array ( 'Key' => '5adf7d6c-9bc0-4d06-9b0f-11aa8a97ea8c', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.226000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"f4e02cb69bcb7dd195f3d33cc602be61"', 'Size' => '99264', 'StorageClass' => 'STANDARD', ), 22 => array ( 'Key' => '5b257094-8d7b-4b45-ae02-6bb5da4ce2b8', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 08:59:18.909000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 23 => array ( 'Key' => '5feaa213-2573-4bda-aaa2-12ffb517dc4a', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 08:49:05.180000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 24 => array ( 'Key' => '6a23708a-7e49-44ff-926b-6a14bd53a6bb/93c3762f-f2c3-489d-83f7-bab7b1c24713', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 08:13:02.157000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 25 => array ( 'Key' => '6f999952-daea-4d67-ae52-89705f30a0a8', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.107000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 26 => array ( 'Key' => '769ef623-e707-449c-83c1-5c414dbe02f0', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:18:51.862000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 27 => array ( 'Key' => '85cffb75-c54f-435b-a21f-53f21bda6e54', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 07:10:10.853000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 28 => array ( 'Key' => '86c83edd-237c-4825-875a-d30afc0eab19', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:03:44.202000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"f4e02cb69bcb7dd195f3d33cc602be61"', 'Size' => '99264', 'StorageClass' => 'STANDARD', ), 29 => array ( 'Key' => '99e2387b-dfd7-4462-bfac-3a733086d835', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 08:40:24.405000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 30 => array ( 'Key' => '9d6d0c70-d344-40f3-897e-34e829241f7d', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.846000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 31 => array ( 'Key' => '', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 02:28:11.279000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"5d6aefb630c62821683c3ad211e31a19"', 'Size' => '28694921', 'StorageClass' => 'STANDARD', ), 32 => array ( 'Key' => 'a65024a7-1523-4263-8244-a4fd093f4bd8', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:04.262000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 33 => array ( 'Key' => 'a8bd8086-b3bb-4bf4-bc5b-e965f571284d', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 09:01:00.730000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 34 => array ( 'Key' => 'ab4ae3e6-c3ca-4650-83d2-27baff3a2e06', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.273000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 35 => array ( 'Key' => 'ad3fe249-7783-444f-987b-bc8218b32353', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 02:29:28.000000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"5d6aefb630c62821683c3ad211e31a19"', 'Size' => '28694921', 'StorageClass' => 'STANDARD', ), 36 => array ( 'Key' => 'ae8316f4-8cad-415a-a4d2-4321e73f313b', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:08:03.108000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"ff3e50a378557c3920c80fcca9a32d77"', 'Size' => '20072751', 'StorageClass' => 'STANDARD', ), 37 => array ( 'Key' => 'b1520d98-b9c5-4ced-aca0-8f6cc8df87f0', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-13 09:04:22.554000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"d41d8cd98f00b204e9800998ecf8427e"', 'Size' => '0', 'StorageClass' => 'STANDARD', ), 38 => array ( 'Key' => 'b75a9e07-0dea-4ffd-9199-08f8cf3ffacf', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.681000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 39 => array ( 'Key' => 'ba4f1e93-d3e6-4c86-bba6-77ca0ef572c4', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 02:32:12.987000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"2144cb2ec4ebbc8cd508d8cf02c04bd2"', 'Size' => '83418', 'StorageClass' => 'STANDARD', ), 40 => array ( 'Key' => 'bb60ee48-5de9-4179-bdaf-aee001c3c179', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:02.874000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"89019f9dca64d9ae6e76ce00223d0e69"', 'Size' => '99110', 'StorageClass' => 'STANDARD', ), 41 => array ( 'Key' => 'c53006e2-f725-4838-9f4b-3fad719d22db/09eecc71-e4e0-4120-92ee-8814c1d99912', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:14:58.291000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"414b35ce943d78bba6138e5f0035cadd"', 'Size' => '10783', 'StorageClass' => 'STANDARD', ), 42 => array ( 'Key' => 'c53006e2-f725-4838-9f4b-3fad719d22db/63880d87-a1e5-4fe4-986a-20a6803b76a4', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:14:58.386000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"3b54177d7df2b876f780d1f28041daba"', 'Size' => '13057', 'StorageClass' => 'STANDARD', ), 43 => array ( 'Key' => 'c53006e2-f725-4838-9f4b-3fad719d22db/6bbc2907-d9ca-4490-a2ac-c66009566151', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:14:58.250000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"a24d0e34f50ebfe65a31073197d11559"', 'Size' => '10725', 'StorageClass' => 'STANDARD', ), 44 => array ( 'Key' => 'c53006e2-f725-4838-9f4b-3fad719d22db/6c6948af-c5a5-48a6-843a-226d1ba607ef', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:14:58.404000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"e6b636c6144f322da51859dff042beca"', 'Size' => '9176', 'StorageClass' => 'STANDARD', ), 45 => array ( 'Key' => 'c53006e2-f725-4838-9f4b-3fad719d22db/79d68da3-a99f-4b75-bab9-c6b7a59c1581', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 09:14:58.642000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"198e10c0518675b2f89960aa448522a3"', 'Size' => '9469', 'StorageClass' => 'STANDARD', ), 46 => array ( 'Key' => 'c71c70b2-46c1-4eb1-8cd2-0454dda0545e', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.839000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 47 => array ( 'Key' => 'cbd05a0a-2eed-43bf-8d09-55b2f8a56996', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:19:16.023000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 48 => array ( 'Key' => 'd2035ccd-863f-4e83-9eb7-23c9a1d75f8e/eb9cb895-aed6-42c3-8789-18f1aa62db0b', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 04:58:26.905000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"ba57ceb7e2a87449cabc2a33f35be566"', 'Size' => '8940', 'StorageClass' => 'STANDARD', ), 49 => array ( 'Key' => 'd27579aa-4f4b-4233-9a3d-0cc6e310f27f', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:19:44.441000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"871dbe5b4391a25fd108e460b0e2bc1b"', 'Size' => '14279989', 'StorageClass' => 'STANDARD', ), 50 => array ( 'Key' => 'dc0c52a1-ba08-494a-a97a-54d0447d80bb', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:18:16.242000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"d984ce42634195427cbd8a4d14d1e3e2"', 'Size' => '96066', 'StorageClass' => 'STANDARD', ), 51 => array ( 'Key' => 'dc6905f5-a0b4-41b7-9f04-f178d4ddcd3a', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:19:43.590000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"1e5a87fa2b5e339e7bc8f785e966d782"', 'Size' => '2294904', 'StorageClass' => 'STANDARD', ), 52 => array ( 'Key' => 'def235e2-e064-4463-91ff-1783d941a350', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:29:55.968000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"d984ce42634195427cbd8a4d14d1e3e2"', 'Size' => '96066', 'StorageClass' => 'STANDARD', ), 53 => array ( 'Key' => 'e5d806ce-a424-409b-879b-ae5db700c718', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:07:37.598000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 54 => array ( 'Key' => 'e9ce2b83-11d4-4519-9474-3af3b169487b', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:07:38.094000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"81c467c32182a491b471ba74fb662728"', 'Size' => '98872', 'StorageClass' => 'STANDARD', ), 55 => array ( 'Key' => 'ec296d91-92ea-4d66-a302-b0fd9e34564c', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 09:07:37.609000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 56 => array ( 'Key' => 'f1425d01-1647-40a0-bdb0-95a5d411100d', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:32:03.149000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 57 => array ( 'Key' => 'f60f7799-ba5e-4046-9a6c-7b6624735b79', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 00:59:38.074000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"9d989843342ad138e841b9e8295cd264"', 'Size' => '103110', 'StorageClass' => 'STANDARD', ), 58 => array ( 'Key' => 'fbeda910-26dc-4e8a-85ee-67f470d67789', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-14 01:19:42.861000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"898c8d1583882ceb19eca8802222d294"', 'Size' => '108384', 'StorageClass' => 'STANDARD', ), 59 => array ( 'Key' => 'guidebook-full-11jan12-en.pdf', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 08:39:39.332000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"ae161561eb169e9486d454c7ea4894fa"', 'Size' => '3978827', 'StorageClass' => 'STANDARD', ), 60 => array ( 'Key' => 'internal-auditors-guide-to-blockchain.pdf', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 08:39:39.704000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"5b448ab44939da1a356e1aab09e5e2a2"', 'Size' => '3704721', 'StorageClass' => 'STANDARD', ), 61 => array ( 'Key' => 'testkey', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-12 08:42:44.704000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"d984ce42634195427cbd8a4d14d1e3e2"', 'Size' => '96066', 'StorageClass' => 'STANDARD', ), 62 => array ( 'Key' => 'ubs-broschuere-schritt-fuer-schritt-en.pdf', 'LastModified' => Aws\Api\DateTimeResult::__set_state(array( 'date' => '2023-04-11 08:48:41.798000', 'timezone_type' => 2, 'timezone' => 'Z', )), 'ETag' => '"6ae6c5405436f3da5617835239874d0e"', 'Size' => '7313461', 'StorageClass' => 'STANDARD', ), ) [2023-04-18 16:20:29] local.DEBUG: getJobTeamAPI [2023-04-18 16:20:29] local.DEBUG: getJobPersonnel() [2023-04-18 16:20:31] local.DEBUG: array ( 0 => array ( 'query' => 'select `ur`.`id`, `u`.`provider_id` as `user_id`, `ui`.`initial` as `user_initial`, `u`.`id` as `app_user_id`, `rr`.`name` as `job_role`, (select login_at from user_sessions where user_id = u.id order by login_at desc limit 1) as last_login, (select ul.created_at from user_logs ul inner join user_sessions us on us.id = ul.user_session_id where us.user_id = u.id and ul.url like ? order by ul.id desc limit 1) as last_access from `users__roles` as `ur` inner join `_ref__roles` as `rr` on `rr`.`id` = `ur`.`role_id` left join `users` as `u` on `u`.`id` = `ur`.`user_id` left join `users__initials` as `ui` on `ui`.`user_id` = `u`.`id` and `ui`.`status` = ? where (`ur`.`job_id` = ? and `ur`.`status` = ?)', 'bindings' => array ( 0 => '%jobs/1309%', 1 => 1, 2 => '1309', 3 => 1, ), 'time' => 283.06, ), ) [2023-04-18 16:20:31] local.DEBUG: user app info count: 4 [2023-04-18 16:20:45] local.DEBUG: getDocumentSignedUrlAPI [2023-04-18 16:20:45] local.DEBUG: op: upload [2023-04-18 16:20:45] local.DEBUG: key: 170c1270-4d64-4406-8f2f-d23adfaf061f [2023-04-18 16:20:45] local.DEBUG: https://salnoaudito.301b33aa497f05b241b2b1c41f152ecb.r2.cloudflarestorage.com/170c1270-4d64-4406-8f2f-d23adfaf061f?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=5fdc327c77c6eb93f34f810f014542a8%2F20230418%2Fauto%2Fs3%2Faws4_request&X-Amz-Date=20230418T082045Z&X-Amz-SignedHeaders=host&X-Amz-Expires=180&X-Amz-Signature=489eb469139a4e469c74347b5bf2d93b66aa4f0359047f473a2185451c74b8e9