DEBUG [L0184] [00024ms]: GLOBAL: Handling JSON Call To API Factory: APIPayrollExportReport Method: getPayrollExportReport Message ID: 9973fce1-5060-6ea5-ced4-381ba09deb61 DEBUG [L0227] [00024ms] Array: [Function](): Arguments: (Size: 3454) array(2) { [0]=> array(8) { ["-1001-time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["-1002-columns"]=> array(7) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(11) "worked_time" [3]=> string(12) "regular_time" [4]=> string(13) "overtime_time" [5]=> string(12) "absence_time" [6]=> string(12) "premium_time" } ["-1003-user_status_id"]=> array(1) { [0]=> string(2) "10" } ["-1004-legal_entity_id"]=> array(10) { [0]=> string(36) "89a2501f-3da5-05f5-524b-000000000031" [1]=> string(36) "11e7f7dd-ffde-dd00-9096-8869537ac04f" [2]=> string(36) "11e82d5b-e3fc-c860-936f-ec48508eb4e2" [3]=> string(36) "11e7f7de-3670-0d80-9620-1cbc633b75f6" [4]=> string(36) "11e83139-8552-0900-96a3-c0e4cbb77ac3" [5]=> string(36) "11e83cd7-ca46-c0c0-94bf-a43030d4519c" [6]=> string(36) "11e83cd7-cd40-1430-987d-8609ccb3c1c0" [7]=> string(36) "11e83cd7-cff8-fcb0-be44-42f5ad223db8" [8]=> string(36) "11e83cd7-d2a6-c2d0-82f2-a83ff3d11862" [9]=> string(36) "11e83cd7-d586-66c0-9395-f5f69c0cd263" } ["-1000-template"]=> string(20) "by_employee+all_time" ["other"]=> array(8) { ["page_orientation"]=> string(1) "P" ["font_size"]=> int(0) ["auto_refresh"]=> bool(false) ["disable_grand_total"]=> bool(false) ["maximum_page_limit"]=> int(100) ["show_duplicate_values"]=> bool(false) ["report_name"]=> string(32) "Payroll Export with Legal Entity" ["report_description"]=> string(10) "01/09/2018" } ["chart"]=> array(6) { ["enable"]=> bool(false) ["display_mode"]=> int(10) ["type"]=> int(10) ["include_sub_total"]=> bool(false) ["axis_scale_static"]=> bool(false) ["combine_columns"]=> bool(true) } ["form"]=> array(2) { ["export_type"]=> string(12) "csv_advanced" ["csv_advanced"]=> array(2) { ["columns"]=> array(19) { ["pay_code:89a2501f-3da5-05f5-524b-000000000475"]=> array(1) { ["hour_code"]=> string(6) "BEREAV" } ["pay_code:89a2501f-3da5-05f5-524b-000000000466"]=> array(1) { ["hour_code"]=> string(3) "BRK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000486"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000474"]=> array(1) { ["hour_code"]=> string(4) "JURY" } ["pay_code:89a2501f-3da5-05f5-524b-000000000465"]=> array(1) { ["hour_code"]=> string(3) "LNH" } ["pay_code:89a2501f-3da5-05f5-524b-000000000467"]=> array(1) { ["hour_code"]=> string(3) "OT1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000468"]=> array(1) { ["hour_code"]=> string(3) "OT2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000480"]=> array(1) { ["hour_code"]=> string(3) "PTO" } ["pay_code:89a2501f-3da5-05f5-524b-000000000469"]=> array(1) { ["hour_code"]=> string(4) "PRE1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000470"]=> array(1) { ["hour_code"]=> string(4) "PRE2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000464"]=> array(1) { ["hour_code"]=> string(3) "REG" } ["pay_code:89a2501f-3da5-05f5-524b-000000000476"]=> array(1) { ["hour_code"]=> string(4) "SICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000477"]=> array(1) { ["hour_code"]=> string(5) "USICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000473"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000471"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000472"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000463"]=> array(1) { ["hour_code"]=> string(6) "UNPAID" } ["pay_code:89a2501f-3da5-05f5-524b-000000000479"]=> array(1) { ["hour_code"]=> string(3) "VAC" } ["pay_code:89a2501f-3da5-05f5-524b-000000000478"]=> array(1) { ["hour_code"]=> string(4) "UVAC" } } ["export_columns"]=> array(8) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" } } } } [1]=> string(14) "payroll_export" } DEBUG [L0238] [00026ms]: GLOBAL: Session ID: 9230e49cc70079647340686fa8b902ef0a506337 Source IP: 10.31.0.2 DEBUG [L0935] [00026ms]: Authentication::Check(): Session ID: 9230e49cc70079647340686fa8b902ef0a506337 IP Address: 10.31.0.2 URL: /api/json/api.php?Class=APIPayrollExportReport&Method=getPayrollExportReport&MessageID=9973fce1-5060-6ea5-ced4-381ba09de DEBUG [L0935] [00026ms]: Authentication::Check(): b61 Touch Updated Date: 1 DEBUG [L0332] [00034ms]: TTDate::setTimeZone(): TimeZone already set to: PST8PDT DEBUG [L0391] [00034ms]: TTDate::setDateFormat(): Setting Default Date Format: d-M-y DEBUG [L0409] [00034ms]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A DEBUG [L0427] [00034ms]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 20 DEBUG [L0082] [00034ms]: authenticatedInvokeService(): Locale Cookie: en_US DEBUG [L0090] [00035ms]: authenticatedInvokeService(): User Preference Language matches cookie! DEBUG [L0416] [00035ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8 DEBUG [L0105] [00036ms]: authenticatedInvokeService(): Current User: card.admin (User ID: 89a2501f-3da5-05f5-524b-000000041798) Company: Pp And Bk (Company ID: 89a2501f-3da5-05f5-524b-000000000082) DEBUG [L0763] [00057ms] Array: PayrollExportReport::getExportTypeTemplate(): Export Type Template: csv_advanced array(7) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["user_status_id"]=> array(1) { [0]=> string(2) "10" } ["legal_entity_id"]=> array(10) { [0]=> string(36) "89a2501f-3da5-05f5-524b-000000000031" [1]=> string(36) "11e7f7dd-ffde-dd00-9096-8869537ac04f" [2]=> string(36) "11e82d5b-e3fc-c860-936f-ec48508eb4e2" [3]=> string(36) "11e7f7de-3670-0d80-9620-1cbc633b75f6" [4]=> string(36) "11e83139-8552-0900-96a3-c0e4cbb77ac3" [5]=> string(36) "11e83cd7-ca46-c0c0-94bf-a43030d4519c" [6]=> string(36) "11e83cd7-cd40-1430-987d-8609ccb3c1c0" [7]=> string(36) "11e83cd7-cff8-fcb0-be44-42f5ad223db8" [8]=> string(36) "11e83cd7-d2a6-c2d0-82f2-a83ff3d11862" [9]=> string(36) "11e83cd7-d586-66c0-9395-f5f69c0cd263" } ["template"]=> string(20) "by_employee+all_time" ["other"]=> array(8) { ["page_orientation"]=> string(1) "P" ["font_size"]=> int(0) ["auto_refresh"]=> bool(false) ["disable_grand_total"]=> bool(true) ["maximum_page_limit"]=> int(100) ["show_duplicate_values"]=> bool(false) ["report_name"]=> string(32) "Payroll Export with Legal Entity" ["report_description"]=> string(10) "01/09/2018" } ["chart"]=> array(6) { ["enable"]=> bool(false) ["display_mode"]=> int(10) ["type"]=> int(10) ["include_sub_total"]=> bool(false) ["axis_scale_static"]=> bool(false) ["combine_columns"]=> bool(true) } ["form"]=> array(2) { ["export_type"]=> string(12) "csv_advanced" ["csv_advanced"]=> array(2) { ["columns"]=> array(19) { ["pay_code:89a2501f-3da5-05f5-524b-000000000475"]=> array(1) { ["hour_code"]=> string(6) "BEREAV" } ["pay_code:89a2501f-3da5-05f5-524b-000000000466"]=> array(1) { ["hour_code"]=> string(3) "BRK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000486"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000474"]=> array(1) { ["hour_code"]=> string(4) "JURY" } ["pay_code:89a2501f-3da5-05f5-524b-000000000465"]=> array(1) { ["hour_code"]=> string(3) "LNH" } ["pay_code:89a2501f-3da5-05f5-524b-000000000467"]=> array(1) { ["hour_code"]=> string(3) "OT1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000468"]=> array(1) { ["hour_code"]=> string(3) "OT2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000480"]=> array(1) { ["hour_code"]=> string(3) "PTO" } ["pay_code:89a2501f-3da5-05f5-524b-000000000469"]=> array(1) { ["hour_code"]=> string(4) "PRE1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000470"]=> array(1) { ["hour_code"]=> string(4) "PRE2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000464"]=> array(1) { ["hour_code"]=> string(3) "REG" } ["pay_code:89a2501f-3da5-05f5-524b-000000000476"]=> array(1) { ["hour_code"]=> string(4) "SICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000477"]=> array(1) { ["hour_code"]=> string(5) "USICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000473"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000471"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000472"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000463"]=> array(1) { ["hour_code"]=> string(6) "UNPAID" } ["pay_code:89a2501f-3da5-05f5-524b-000000000479"]=> array(1) { ["hour_code"]=> string(3) "VAC" } ["pay_code:89a2501f-3da5-05f5-524b-000000000478"]=> array(1) { ["hour_code"]=> string(4) "UVAC" } } ["export_columns"]=> array(8) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" } } } } DEBUG [L2836] [00059ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.42 Max: 9999 DEBUG [L0143] [00059ms]: APIReport::getReport(): Format: payroll_export DEBUG [L0588] [00059ms] Array: Report::setConfig(): setConfig(): array(7) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["user_status_id"]=> array(1) { [0]=> string(2) "10" } ["legal_entity_id"]=> array(10) { [0]=> string(36) "89a2501f-3da5-05f5-524b-000000000031" [1]=> string(36) "11e7f7dd-ffde-dd00-9096-8869537ac04f" [2]=> string(36) "11e82d5b-e3fc-c860-936f-ec48508eb4e2" [3]=> string(36) "11e7f7de-3670-0d80-9620-1cbc633b75f6" [4]=> string(36) "11e83139-8552-0900-96a3-c0e4cbb77ac3" [5]=> string(36) "11e83cd7-ca46-c0c0-94bf-a43030d4519c" [6]=> string(36) "11e83cd7-cd40-1430-987d-8609ccb3c1c0" [7]=> string(36) "11e83cd7-cff8-fcb0-be44-42f5ad223db8" [8]=> string(36) "11e83cd7-d2a6-c2d0-82f2-a83ff3d11862" [9]=> string(36) "11e83cd7-d586-66c0-9395-f5f69c0cd263" } ["template"]=> string(20) "by_employee+all_time" ["other"]=> array(8) { ["page_orientation"]=> string(1) "P" ["font_size"]=> int(0) ["auto_refresh"]=> bool(false) ["disable_grand_total"]=> bool(true) ["maximum_page_limit"]=> int(100) ["show_duplicate_values"]=> bool(false) ["report_name"]=> string(32) "Payroll Export with Legal Entity" ["report_description"]=> string(10) "01/09/2018" } ["chart"]=> array(6) { ["enable"]=> bool(false) ["display_mode"]=> int(10) ["type"]=> int(10) ["include_sub_total"]=> bool(false) ["axis_scale_static"]=> bool(false) ["combine_columns"]=> bool(true) } ["form"]=> array(2) { ["export_type"]=> string(12) "csv_advanced" ["csv_advanced"]=> array(2) { ["columns"]=> array(19) { ["pay_code:89a2501f-3da5-05f5-524b-000000000475"]=> array(1) { ["hour_code"]=> string(6) "BEREAV" } ["pay_code:89a2501f-3da5-05f5-524b-000000000466"]=> array(1) { ["hour_code"]=> string(3) "BRK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000486"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000474"]=> array(1) { ["hour_code"]=> string(4) "JURY" } ["pay_code:89a2501f-3da5-05f5-524b-000000000465"]=> array(1) { ["hour_code"]=> string(3) "LNH" } ["pay_code:89a2501f-3da5-05f5-524b-000000000467"]=> array(1) { ["hour_code"]=> string(3) "OT1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000468"]=> array(1) { ["hour_code"]=> string(3) "OT2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000480"]=> array(1) { ["hour_code"]=> string(3) "PTO" } ["pay_code:89a2501f-3da5-05f5-524b-000000000469"]=> array(1) { ["hour_code"]=> string(4) "PRE1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000470"]=> array(1) { ["hour_code"]=> string(4) "PRE2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000464"]=> array(1) { ["hour_code"]=> string(3) "REG" } ["pay_code:89a2501f-3da5-05f5-524b-000000000476"]=> array(1) { ["hour_code"]=> string(4) "SICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000477"]=> array(1) { ["hour_code"]=> string(5) "USICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000473"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000471"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000472"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000463"]=> array(1) { ["hour_code"]=> string(6) "UNPAID" } ["pay_code:89a2501f-3da5-05f5-524b-000000000479"]=> array(1) { ["hour_code"]=> string(3) "VAC" } ["pay_code:89a2501f-3da5-05f5-524b-000000000478"]=> array(1) { ["hour_code"]=> string(4) "UVAC" } } ["export_columns"]=> array(8) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" } } } } DEBUG [L2232] [00075ms]: Report::checkPermissions(): Permission Check Retval: 1 DEBUG [L1182] [00089ms]: Report::getCompanyFormConfig(): Found Company Report Setup! DEBUG [L1232] [00091ms]: Report::setOtherConfig(): Report default font: helvetica DEBUG [L0851] [00106ms]: Report::setFilterConfig(): Found TimePeriod... DEBUG [L0760] [00106ms] Array: Report::convertTimePeriodToStartEndDate(): Input: Time Period Array: array(1) { ["time_period"]=> string(15) "last_pay_period" } DEBUG [L3231] [00106ms]: TTDate::getTimePeriodDates(): Time Period for Pay Period Schedule selected... DEBUG [L3255] [00106ms]: TTDate::getTimePeriodDates(): last_pay_period DEBUG [L3267] [00120ms] Array: TTDate::getTimePeriodDates(): Pay Period IDs: array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } DEBUG [L0832] [00121ms] Array: Report::convertTimePeriodToStartEndDate(): Output: Time Period Array: array(2) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["pay_period_id"]=> array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } } DEBUG [L0866] [00121ms] Array: Report::setFilterConfig(): Filter Data: array(5) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["user_status_id"]=> array(1) { [0]=> string(2) "10" } ["legal_entity_id"]=> array(10) { [0]=> string(36) "89a2501f-3da5-05f5-524b-000000000031" [1]=> string(36) "11e7f7dd-ffde-dd00-9096-8869537ac04f" [2]=> string(36) "11e82d5b-e3fc-c860-936f-ec48508eb4e2" [3]=> string(36) "11e7f7de-3670-0d80-9620-1cbc633b75f6" [4]=> string(36) "11e83139-8552-0900-96a3-c0e4cbb77ac3" [5]=> string(36) "11e83cd7-ca46-c0c0-94bf-a43030d4519c" [6]=> string(36) "11e83cd7-cd40-1430-987d-8609ccb3c1c0" [7]=> string(36) "11e83cd7-cff8-fcb0-be44-42f5ad223db8" [8]=> string(36) "11e83cd7-d2a6-c2d0-82f2-a83ff3d11862" [9]=> string(36) "11e83cd7-d586-66c0-9395-f5f69c0cd263" } ["template"]=> string(20) "by_employee+all_time" ["pay_period_id"]=> array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } } DEBUG [L2232] [00121ms]: Report::checkPermissions(): Permission Check Retval: 1 DEBUG [L0569] [00121ms]: Report::setAMFMessageID(): AMF Message ID: 9973fce1-5060-6ea5-ced4-381ba09deb61 DEBUG [L2232] [00171ms]: Report::checkPermissions(): Permission Check Retval: 1 DEBUG [L2780] [00171ms]: Misc::getSystemMemoryInfo(): Memory Info: Free: 440131584b Cached: 800395264b DEBUG [L0378] [00172ms]: Report::setExecutionMemoryLimit(): Available memory is less than maximum, reducing to: 1040428032 Max Memory: 3221225472 DEBUG [L0382] [00172ms]: Report::setExecutionMemoryLimit(): Setting hard memory limit to: 1040428032 Soft Limit: 1040428032 Based on: 3072M DEBUG [L0113] [00172ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 2 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770326.1192) Message: Querying Database... DEBUG [L2255] [00173ms]: Report::setQueryStatementTimeout(): Setting Report DB query statement timeout to: 600000 DEBUG [L1450] [00174ms] Array: Report::getData(): Final Report Config: array(5) { ["other"]=> array(28) { ["report_name"]=> string(32) "Payroll Export with Legal Entity" ["is_embedded"]=> bool(false) ["disable_grand_total"]=> bool(true) ["page_orientation"]=> string(1) "P" ["page_format"]=> string(6) "LETTER" ["default_font"]=> string(9) "helvetica" ["maximum_page_limit"]=> int(100) ["maximum_row_limit"]=> bool(false) ["query_statement_timeout"]=> int(600000) ["maximum_memory_limit"]=> string(5) "3072M" ["maximum_execution_limit"]=> int(1800) ["font_size"]=> int(0) ["table_header_font_size"]=> int(8) ["table_row_font_size"]=> int(8) ["table_header_word_wrap"]=> int(10) ["table_data_word_wrap"]=> int(50) ["top_margin"]=> int(5) ["bottom_margin"]=> int(5) ["left_margin"]=> int(5) ["right_margin"]=> int(5) ["adjust_horizontal_position"]=> int(0) ["adjust_vertical_position"]=> int(0) ["show_blank_values"]=> bool(true) ["blank_value_placeholder"]=> string(1) "-" ["show_duplicate_values"]=> bool(false) ["duplicate_value_placeholder"]=> string(1) " " ["auto_refresh"]=> bool(false) ["report_description"]=> string(10) "01/09/2018" } ["chart"]=> array(6) { ["enable"]=> bool(false) ["display_mode"]=> int(10) ["type"]=> int(10) ["include_sub_total"]=> bool(false) ["axis_scale_static"]=> bool(false) ["combine_columns"]=> bool(true) } ["form"]=> array(2) { ["export_type"]=> string(12) "csv_advanced" ["csv_advanced"]=> array(2) { ["columns"]=> array(19) { ["pay_code:89a2501f-3da5-05f5-524b-000000000475"]=> array(1) { ["hour_code"]=> string(6) "BEREAV" } ["pay_code:89a2501f-3da5-05f5-524b-000000000466"]=> array(1) { ["hour_code"]=> string(3) "BRK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000486"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000474"]=> array(1) { ["hour_code"]=> string(4) "JURY" } ["pay_code:89a2501f-3da5-05f5-524b-000000000465"]=> array(1) { ["hour_code"]=> string(3) "LNH" } ["pay_code:89a2501f-3da5-05f5-524b-000000000467"]=> array(1) { ["hour_code"]=> string(3) "OT1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000468"]=> array(1) { ["hour_code"]=> string(3) "OT2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000480"]=> array(1) { ["hour_code"]=> string(3) "PTO" } ["pay_code:89a2501f-3da5-05f5-524b-000000000469"]=> array(1) { ["hour_code"]=> string(4) "PRE1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000470"]=> array(1) { ["hour_code"]=> string(4) "PRE2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000464"]=> array(1) { ["hour_code"]=> string(3) "REG" } ["pay_code:89a2501f-3da5-05f5-524b-000000000476"]=> array(1) { ["hour_code"]=> string(4) "SICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000477"]=> array(1) { ["hour_code"]=> string(5) "USICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000473"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000471"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000472"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000463"]=> array(1) { ["hour_code"]=> string(6) "UNPAID" } ["pay_code:89a2501f-3da5-05f5-524b-000000000479"]=> array(1) { ["hour_code"]=> string(3) "VAC" } ["pay_code:89a2501f-3da5-05f5-524b-000000000478"]=> array(1) { ["hour_code"]=> string(4) "UVAC" } } ["export_columns"]=> array(8) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" } } } ["columns_data"]=> array(0) { } ["filter"]=> array(5) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["user_status_id"]=> array(1) { [0]=> string(2) "10" } ["legal_entity_id"]=> array(10) { [0]=> string(36) "89a2501f-3da5-05f5-524b-000000000031" [1]=> string(36) "11e7f7dd-ffde-dd00-9096-8869537ac04f" [2]=> string(36) "11e82d5b-e3fc-c860-936f-ec48508eb4e2" [3]=> string(36) "11e7f7de-3670-0d80-9620-1cbc633b75f6" [4]=> string(36) "11e83139-8552-0900-96a3-c0e4cbb77ac3" [5]=> string(36) "11e83cd7-ca46-c0c0-94bf-a43030d4519c" [6]=> string(36) "11e83cd7-cd40-1430-987d-8609ccb3c1c0" [7]=> string(36) "11e83cd7-cff8-fcb0-be44-42f5ad223db8" [8]=> string(36) "11e83cd7-d2a6-c2d0-82f2-a83ff3d11862" [9]=> string(36) "11e83cd7-d586-66c0-9395-f5f69c0cd263" } ["template"]=> string(20) "by_employee+all_time" ["pay_period_id"]=> array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } } } DEBUG [L0518] [00183ms]: Report::setCurrencyObject(): Setting Report Currency to: USD DEBUG [L0650] [00950ms]: TimesheetSummaryReport::_getData(): Total Rows: 3748 DEBUG [L0113] [00950ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 3748 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770326.8974) Message: Retrieving Data... DEBUG [L0792] [01418ms]: TimesheetSummaryReport::_getData(): User Total Rows: 140 DEBUG [L0113] [01418ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 140 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770327.3657) Message: Retrieving Data... DEBUG [L0822] [01452ms]: TimesheetSummaryReport::_getData(): Branch Total Rows: 3 DEBUG [L0113] [01452ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 3 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770327.3999) Message: Retrieving Data... DEBUG [L0833] [01457ms]: TimesheetSummaryReport::_getData(): Department Total Rows: 12 DEBUG [L0113] [01457ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 12 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770327.4049) Message: Retrieving Data... DEBUG [L1455] [01473ms]: Report::getData(): Memory Usage: Current: 10603624 Peak: 10973136 DEBUG [L2255] [01473ms]: Report::setQueryStatementTimeout(): Setting Report DB query statement timeout to: 600000 DEBUG [L2836] [01475ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L0113] [01475ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 136 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770327.4221) Message: Pre-Processing Data... DEBUG [L1470] [01987ms]: Report::preProcess(): Memory Usage: Current: 19164936 Peak: 22216600 DEBUG [L2836] [01987ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L1900] [01993ms]: Report::getCustomColumnFormatOptions(): No Custom Columns... DEBUG [L2836] [01996ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L2836] [01996ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L2836] [01996ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L1495] [01996ms]: Report::group(): Memory Usage: Current: 19203288 Peak: 22216600 DEBUG [L2836] [01996ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L2836] [01996ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L2836] [01997ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L1523] [01997ms]: Report::sort(): Memory Usage: Current: 19207344 Peak: 22216600 DEBUG [L2836] [01998ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L1719] [01998ms]: Report::postProcess(): Memory Usage: Current: 19209760 Peak: 22216600 DEBUG [L1719] [01998ms]: Report::postProcess(): (): Maximum debug buffer size of: 1000 reached. Writing out buffer before continuing... Buffer ID: 5c4119d5e7dab ---------------[ 17-Jan-2019 16:12:07 -0800 [1547770327.9464] (PID: 30323) ]--------------- ---------------[ 17-Jan-2019 16:12:08 -0800 [1547770328.558] (PID: 30324) ]--------------- DEBUG [L0388] [00003ms]: GLOBAL: URI: /api/json/api.php?Class=APIProgressBar&Method=get&v=2 IP Address: 10.31.0.2 DEBUG [L0389] [00003ms]: GLOBAL: USER-AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:64.0) Gecko/20100101 Firefox/64.0 DEBUG [L0390] [00003ms]: GLOBAL: Version: 11.4.2 (PHP: v5.6.39-0+deb8u1) Edition: 25 Production: 1 Server: 192.168.11.137 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /home/csiftpadmin/www/TimeTrex/includes/../timetrex. DEBUG [L0390] [00003ms]: GLOBAL: ini.php Demo Mode: 0 DEBUG [L0337] [00029ms]: TTDate::setTimeZone(): Setting TimeZone: PST8PDT DEBUG [L0184] [00031ms]: GLOBAL: Handling JSON Call To API Factory: APIProgressBar Method: get Message ID: 74474c13a827b3550f6a353875a44a97 DEBUG [L0227] [00031ms] Array: [Function](): Arguments: (Size: 63) array(1) { [0]=> string(36) "9973fce1-5060-6ea5-ced4-381ba09deb61" } DEBUG [L0238] [00032ms]: GLOBAL: Session ID: 9230e49cc70079647340686fa8b902ef0a506337 Source IP: 10.31.0.2 DEBUG [L0242] [00032ms]: GLOBAL: SessionID set but user not authenticated! DEBUG [L0416] [00033ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8 DEBUG [L0533] [00033ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8 DEBUG [L0037] [00033ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIProgressBar Method: get Message ID: 74474c13a827b3550f6a353875a44a97 DEBUG [L0256] [00033ms]: GLOBAL: Server Response Time: 0.032685995101929 ---------------[ 17-Jan-2019 16:12:08 -0800 [1547770328.5908] (PID: 30324) ]--------------- ---------------[ 17-Jan-2019 16:12:09 -0800 [1547770329.808] (PID: 30312) ]--------------- DEBUG [L0388] [00003ms]: GLOBAL: URI: //api/time_clock/api.php?v=1.6.6&StationID=4017801260107&OEMCode=TTUS100 IP Address: 75.148.87.150 DEBUG [L0389] [00003ms]: GLOBAL: USER-AGENT: Embedded SOAP DEBUG [L0390] [00003ms]: GLOBAL: Version: 11.4.2 (PHP: v5.6.39-0+deb8u1) Edition: 25 Production: 1 Server: 192.168.11.137 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /home/csiftpadmin/www/TimeTrex/includes/../timetrex. DEBUG [L0390] [00003ms]: GLOBAL: ini.php Demo Mode: 0 DEBUG [L0337] [00027ms]: TTDate::setTimeZone(): Setting TimeZone: PST8PDT DEBUG [L0061] [00030ms]: APITimeClockUnAuthenticated::ping(): Ping: From: 75.148.87.150 Time: 17-Jan-19 4:12 PM PST V: 1.6.6 ---------------[ 17-Jan-2019 16:12:09 -0800 [1547770329.8378] (PID: 30312) ]--------------- ---------------[ 17-Jan-2019 16:12:10 -0800 [1547770325.948] (PID: 30323) ]--------------- DEBUG [L1719] [02000ms]: Report::postProcess(): (): Continuing debug output from Buffer ID: 5c4119d5e7dab DEBUG [L2836] [02000ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.48 Max: 9999 DEBUG [L0793] [02000ms]: PayrollExportReport::_outputPayrollExport(): Generating Payroll Export... Format: payroll_export DEBUG [L0796] [02000ms]: PayrollExportReport::_outputPayrollExport(): Export Type: csv_advanced DEBUG [L0801] [02000ms] Array: PayrollExportReport::_outputPayrollExport(): Setup Data: array(2) { ["export_type"]=> string(12) "csv_advanced" ["csv_advanced"]=> array(2) { ["columns"]=> array(19) { ["pay_code:89a2501f-3da5-05f5-524b-000000000475"]=> array(1) { ["hour_code"]=> string(6) "BEREAV" } ["pay_code:89a2501f-3da5-05f5-524b-000000000466"]=> array(1) { ["hour_code"]=> string(3) "BRK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000486"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000474"]=> array(1) { ["hour_code"]=> string(4) "JURY" } ["pay_code:89a2501f-3da5-05f5-524b-000000000465"]=> array(1) { ["hour_code"]=> string(3) "LNH" } ["pay_code:89a2501f-3da5-05f5-524b-000000000467"]=> array(1) { ["hour_code"]=> string(3) "OT1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000468"]=> array(1) { ["hour_code"]=> string(3) "OT2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000480"]=> array(1) { ["hour_code"]=> string(3) "PTO" } ["pay_code:89a2501f-3da5-05f5-524b-000000000469"]=> array(1) { ["hour_code"]=> string(4) "PRE1" } ["pay_code:89a2501f-3da5-05f5-524b-000000000470"]=> array(1) { ["hour_code"]=> string(4) "PRE2" } ["pay_code:89a2501f-3da5-05f5-524b-000000000464"]=> array(1) { ["hour_code"]=> string(3) "REG" } ["pay_code:89a2501f-3da5-05f5-524b-000000000476"]=> array(1) { ["hour_code"]=> string(4) "SICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000477"]=> array(1) { ["hour_code"]=> string(5) "USICK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000473"]=> array(1) { ["hour_code"]=> string(4) "STAT" } ["pay_code:89a2501f-3da5-05f5-524b-000000000471"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000472"]=> array(1) { ["hour_code"]=> string(4) "BANK" } ["pay_code:89a2501f-3da5-05f5-524b-000000000463"]=> array(1) { ["hour_code"]=> string(6) "UNPAID" } ["pay_code:89a2501f-3da5-05f5-524b-000000000479"]=> array(1) { ["hour_code"]=> string(3) "VAC" } ["pay_code:89a2501f-3da5-05f5-524b-000000000478"]=> array(1) { ["hour_code"]=> string(4) "UVAC" } } ["export_columns"]=> array(8) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" } } } DEBUG [L2442] [02002ms]: PayrollExportReport::_outputPayrollExport(): Using Job Detail Report... DEBUG [L0569] [02008ms]: Report::setAMFMessageID(): AMF Message ID: 9973fce1-5060-6ea5-ced4-381ba09deb61 DEBUG [L0588] [02008ms] Array: Report::setConfig(): setConfig(): array(3) { ["group"]=> array(27) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" [8]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000463_hourly_rate" [9]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000464_hourly_rate" [10]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000465_hourly_rate" [11]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000466_hourly_rate" [12]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000467_hourly_rate" [13]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000468_hourly_rate" [14]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000469_hourly_rate" [15]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000470_hourly_rate" [16]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000471_hourly_rate" [17]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000472_hourly_rate" [18]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000473_hourly_rate" [19]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000474_hourly_rate" [20]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000475_hourly_rate" [21]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000476_hourly_rate" [22]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000477_hourly_rate" [23]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000478_hourly_rate" [24]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000479_hourly_rate" [25]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000480_hourly_rate" [26]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000486_hourly_rate" } ["columns"]=> array(124) { [0]=> string(10) "first_name" [1]=> string(9) "last_name" [2]=> string(15) "employee_number" [3]=> string(10) "pay_period" [4]=> string(9) "other_id4" [5]=> string(9) "other_id3" [6]=> string(9) "other_id2" [7]=> string(9) "other_id1" [8]=> string(18) "absence_taken_time" [9]=> string(12) "premium_time" [10]=> string(10) "gross_time" [11]=> string(10) "lunch_time" [12]=> string(10) "break_time" [13]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000463_time" [14]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000464_time" [15]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000465_time" [16]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000466_time" [17]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000467_time" [18]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000468_time" [19]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000469_time" [20]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000470_time" [21]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000471_time" [22]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000472_time" [23]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000473_time" [24]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000474_time" [25]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000475_time" [26]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000476_time" [27]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000477_time" [28]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000478_time" [29]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000479_time" [30]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000480_time" [31]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000486_time" [32]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000463_time" [33]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000472_time" [34]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000473_time" [35]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000474_time" [36]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000475_time" [37]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000476_time" [38]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000477_time" [39]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000479_time" [40]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000480_time" [41]=> string(64) "absence_taken_pay_code:89a2501f-3da5-05f5-524b-000000000486_time" [42]=> string(10) "gross_wage" [43]=> string(12) "regular_wage" [44]=> string(13) "overtime_wage" [45]=> string(12) "absence_wage" [46]=> string(12) "premium_wage" [47]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000463_wage" [48]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000464_wage" [49]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000465_wage" [50]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000466_wage" [51]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000467_wage" [52]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000468_wage" [53]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000469_wage" [54]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000470_wage" [55]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000471_wage" [56]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000472_wage" [57]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000473_wage" [58]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000474_wage" [59]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000475_wage" [60]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000476_wage" [61]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000477_wage" [62]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000478_wage" [63]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000479_wage" [64]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000480_wage" [65]=> string(50) "pay_code:89a2501f-3da5-05f5-524b-000000000486_wage" [66]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000463_hourly_rate" [67]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000464_hourly_rate" [68]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000465_hourly_rate" [69]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000466_hourly_rate" [70]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000467_hourly_rate" [71]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000468_hourly_rate" [72]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000469_hourly_rate" [73]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000470_hourly_rate" [74]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000471_hourly_rate" [75]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000472_hourly_rate" [76]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000473_hourly_rate" [77]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000474_hourly_rate" [78]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000475_hourly_rate" [79]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000476_hourly_rate" [80]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000477_hourly_rate" [81]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000478_hourly_rate" [82]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000479_hourly_rate" [83]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000480_hourly_rate" [84]=> string(57) "pay_code:89a2501f-3da5-05f5-524b-000000000486_hourly_rate" [85]=> string(22) "gross_wage_with_burden" [86]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000463_wage_with_burden" [87]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000464_wage_with_burden" [88]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000465_wage_with_burden" [89]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000466_wage_with_burden" [90]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000467_wage_with_burden" [91]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000468_wage_with_burden" [92]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000469_wage_with_burden" [93]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000470_wage_with_burden" [94]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000471_wage_with_burden" [95]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000472_wage_with_burden" [96]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000473_wage_with_burden" [97]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000474_wage_with_burden" [98]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000475_wage_with_burden" [99]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000476_wage_with_burden" [100]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000477_wage_with_burden" [101]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000478_wage_with_burden" [102]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000479_wage_with_burden" [103]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000480_wage_with_burden" [104]=> string(62) "pay_code:89a2501f-3da5-05f5-524b-000000000486_wage_with_burden" [105]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000463_hourly_rate_with_burden" [106]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000464_hourly_rate_with_burden" [107]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000465_hourly_rate_with_burden" [108]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000466_hourly_rate_with_burden" [109]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000467_hourly_rate_with_burden" [110]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000468_hourly_rate_with_burden" [111]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000469_hourly_rate_with_burden" [112]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000470_hourly_rate_with_burden" [113]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000471_hourly_rate_with_burden" [114]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000472_hourly_rate_with_burden" [115]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000473_hourly_rate_with_burden" [116]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000474_hourly_rate_with_burden" [117]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000475_hourly_rate_with_burden" [118]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000476_hourly_rate_with_burden" [119]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000477_hourly_rate_with_burden" [120]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000478_hourly_rate_with_burden" [121]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000479_hourly_rate_with_burden" [122]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000480_hourly_rate_with_burden" [123]=> string(69) "pay_code:89a2501f-3da5-05f5-524b-000000000486_hourly_rate_with_burden" } ["sort"]=> array(8) { [0]=> array(1) { ["first_name"]=> string(3) "asc" } [1]=> array(1) { ["last_name"]=> string(3) "asc" } [2]=> array(1) { ["employee_number"]=> string(3) "asc" } [3]=> array(1) { ["pay_period"]=> string(3) "asc" } [4]=> array(1) { ["other_id4"]=> string(3) "asc" } [5]=> array(1) { ["other_id3"]=> string(3) "asc" } [6]=> array(1) { ["other_id2"]=> string(3) "asc" } [7]=> array(1) { ["other_id1"]=> string(3) "asc" } } } DEBUG [L0866] [02013ms] Array: Report::setFilterConfig(): Filter Data: array(0) { } DEBUG [L0851] [02013ms]: Report::setFilterConfig(): Found TimePeriod... DEBUG [L0760] [02013ms] Array: Report::convertTimePeriodToStartEndDate(): Input: Time Period Array: array(1) { ["time_period"]=> string(15) "last_pay_period" } DEBUG [L3231] [02013ms]: TTDate::getTimePeriodDates(): Time Period for Pay Period Schedule selected... DEBUG [L3255] [02013ms]: TTDate::getTimePeriodDates(): last_pay_period DEBUG [L3267] [02022ms] Array: TTDate::getTimePeriodDates(): Pay Period IDs: array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } DEBUG [L0832] [02022ms] Array: Report::convertTimePeriodToStartEndDate(): Output: Time Period Array: array(2) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["pay_period_id"]=> array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } } DEBUG [L0866] [02022ms] Array: Report::setFilterConfig(): Filter Data: array(5) { ["time_period"]=> array(1) { ["time_period"]=> string(15) "last_pay_period" } ["user_status_id"]=> array(1) { [0]=> string(2) "10" } ["legal_entity_id"]=> array(10) { [0]=> string(36) "89a2501f-3da5-05f5-524b-000000000031" [1]=> string(36) "11e7f7dd-ffde-dd00-9096-8869537ac04f" [2]=> string(36) "11e82d5b-e3fc-c860-936f-ec48508eb4e2" [3]=> string(36) "11e7f7de-3670-0d80-9620-1cbc633b75f6" [4]=> string(36) "11e83139-8552-0900-96a3-c0e4cbb77ac3" [5]=> string(36) "11e83cd7-ca46-c0c0-94bf-a43030d4519c" [6]=> string(36) "11e83cd7-cd40-1430-987d-8609ccb3c1c0" [7]=> string(36) "11e83cd7-cff8-fcb0-be44-42f5ad223db8" [8]=> string(36) "11e83cd7-d2a6-c2d0-82f2-a83ff3d11862" [9]=> string(36) "11e83cd7-d586-66c0-9395-f5f69c0cd263" } ["template"]=> string(20) "by_employee+all_time" ["pay_period_id"]=> array(2) { [0]=> string(36) "11e90b3f-c13f-1a80-8546-45ae7a225895" [1]=> string(36) "11e90a76-973f-5c60-af27-3a09fad23e24" } } DEBUG [L0518] [02037ms]: Report::setCurrencyObject(): Setting Report Currency to: USD DEBUG [L0880] [02692ms]: JobDetailReport::_getData(): Total Rows: 3748 DEBUG [L0113] [02692ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 3748 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770328.6394) Message: Retrieving Punch Data... DEBUG [L1004] [03260ms]: JobDetailReport::_getData(): User Total Rows: 140 DEBUG [L0113] [03260ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 140 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.2076) Message: Retrieving Employee Data... DEBUG [L1026] [03327ms]: JobDetailReport::_getData(): Branch Total Rows: 3 DEBUG [L0113] [03327ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 3 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.2741) Message: Retrieving Branches... DEBUG [L1037] [03332ms]: JobDetailReport::_getData(): Department Total Rows: 12 DEBUG [L0113] [03332ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 12 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.2794) Message: Retrieving Departments... DEBUG [L1047] [03342ms]: JobDetailReport::_getData(): User Title Total Rows: 12 DEBUG [L0113] [03342ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 1 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.2899) Message: Retrieving Titles... DEBUG [L1060] [03358ms]: JobDetailReport::_getData(): Job Total Rows: 0 DEBUG [L0113] [03358ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 0 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.3059) Message: Retrieving Jobs... DEBUG [L1075] [03368ms]: JobDetailReport::_getData(): Job Item Total Rows: 1 DEBUG [L0113] [03368ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 1 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.3156) Message: Retrieving Tasks... DEBUG [L1090] [03375ms]: JobDetailReport::_getData(): Job Item Amendment Total Rows: 0 DEBUG [L0113] [03375ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 0 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.3223) Message: Retrieving Task Amendments... DEBUG [L1103] [03512ms]: JobDetailReport::_getData(): Client Total Rows: 0 DEBUG [L0113] [03513ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 0 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.4601) Message: Retrieving Clients... DEBUG [L0113] [03514ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 136 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770329.4614) Message: Pre-Processing Data... DEBUG [L1900] [04375ms]: Report::getCustomColumnFormatOptions(): No Custom Columns... DEBUG [L0113] [04389ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 927 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770330.3366) Message: Grouping Data... DEBUG [L1495] [04552ms]: Report::group(): Memory Usage: Current: 35201384 Peak: 61053296 DEBUG [L0113] [04553ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 145 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770330.5001) Message: Sorting Data... DEBUG [L1513] [04555ms] Array: Report::sort(): Sort Config: array(8) { ["first_name"]=> string(3) "asc" ["last_name"]=> string(3) "asc" ["employee_number"]=> string(3) "asc" ["pay_period"]=> string(3) "asc" ["other_id4"]=> string(3) "asc" ["other_id3"]=> string(3) "asc" ["other_id2"]=> string(3) "asc" ["other_id1"]=> string(3) "asc" } DEBUG [L1523] [04565ms]: Report::sort(): Memory Usage: Current: 35214672 Peak: 61053296 DEBUG [L0113] [04565ms]: ProgressBar::start(): start: '9973fce1-5060-6ea5-ced4-381ba09deb61' Iterations: 145 Update Iterations: Key: 9973fce1-5060-6ea5-ced4-381ba09deb61(1547770330.5121) Message: Post-Processing Data... DEBUG [L1900] [04567ms]: Report::getCustomColumnFormatOptions(): No Custom Columns... DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: first_name DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: last_name DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: employee_number DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: pay_period DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: other_id4 DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: other_id3 DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: other_id2 DEBUG [L2493] [04601ms]: PayrollExportReport::_outputPayrollExport(): Header Row: other_id1 DEBUG [L2394] [04634ms]: Report::getOutput(): Format: payroll_export Total Time: 4.462865114212 Memory Usage: Current: 34337648 Peak: 61053296 DEBUG [L2395] [04635ms] Array: Report::getOutput(): Profile Timers: string(1069) "
============================================================================
                                                                PROFILER OUTPUT
============================================================================
Calls                                    Time  Routine
-----------------------------------------------------------------------------
  1     5.2421 ms (0.11 %)       Authentication::Check()
  1     121.7542 ms (2.63 %)     Group()
  1     7.6580 ms (0.17 %)       Sort()
 91     287.7855 ms (6.21 %)     __autoload
  4     0.0627 ms (0.00 %)       calculateCustomColumnFilters
  6     0.0916 ms (0.00 %)       calculateCustomColumns
  2     2280.2989 ms (49.22 %)   currencyConvertToBase
  1     1290.4887 ms (27.86 %)   getData
 38     17.6094 ms (0.38 %)      getEmptyRecordSet()
  2     41.2939 ms (0.89 %)      group
  1     0.0131 ms (0.00 %)       postProcess
  1     512.6350 ms (11.07 %)    preProcess
  2     3.4931 ms (0.08 %)       sort
  1     23.1493 ms (0.50 %)      unprofiled

                41.0047 ms (0.89 %)      Missed
============================================================================
                4632.5800 ms (100.00 %)  OVERALL TIME
============================================================================
" DEBUG [L0128] [04635ms]: authenticatedInvokeService(): NULL return value, not JSON encoding any additional data. DEBUG [L0256] [04635ms]: GLOBAL: Server Response Time: 4.6345219612122 ---------------[ 17-Jan-2019 16:12:10 -0800 [1547770330.584] (PID: 30323) ]--------------- ---------------[ 17-Jan-2019 16:12:11 -0800 [1547770331.551] (PID: 30324) ]--------------- DEBUG [L0388] [00003ms]: GLOBAL: URI: /api/json/api.php?Class=APIProgressBar&Method=get&v=2 IP Address: 10.31.0.2 DEBUG [L0389] [00003ms]: GLOBAL: USER-AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:64.0) Gecko/20100101 Firefox/64.0 DEBUG [L0390] [00003ms]: GLOBAL: Version: 11.4.2 (PHP: v5.6.39-0+deb8u1) Edition: 25 Production: 1 Server: 192.168.11.137 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /home/csiftpadmin/www/TimeTrex/includes/../timetrex. DEBUG [L0390] [00003ms]: GLOBAL: ini.php Demo Mode: 0 DEBUG [L0337] [00021ms]: TTDate::setTimeZone(): Setting TimeZone: PST8PDT DEBUG [L0184] [00022ms]: GLOBAL: Handling JSON Call To API Factory: APIProgressBar Method: get Message ID: ddb76ab1e1d9f7994722549248ebce28 DEBUG [L0227] [00022ms] Array: [Function](): Arguments: (Size: 63) array(1) { [0]=> string(36) "9973fce1-5060-6ea5-ced4-381ba09deb61" }