function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['pay_stub_entry']), NULL, TTi18n::getText('Pre-Processing Data...'));
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['pay_stub_entry'])) {
foreach ($this->tmp_data['pay_stub_entry'] as $user_id => $row) {
if (isset($this->tmp_data['user'][$user_id])) {
$date_columns = TTDate::getReportDates(NULL, $row['date_stamp'], FALSE, $this->getUserObject(), array('pay_period_start_date' => $row['pay_period_start_date'], 'pay_period_end_date' => $row['pay_period_end_date'], 'pay_period_transaction_date' => $row['pay_period_transaction_date']));
$processed_data = array('user_id' => $user_id);
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $date_columns, $processed_data);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
unset($this->tmp_data, $row, $date_columns, $processed_data, $level_1, $level_2, $level_3);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
$this->form_data = $this->data;
//Copy data to Form Data so group/sort doesn't affect it.
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['user']), NULL, TTi18n::getText('Pre-Processing Data...'));
$key = 0;
if (isset($this->tmp_data['user'])) {
foreach ($this->tmp_data['user'] as $user_id => $row) {
if (isset($row['hire_date'])) {
$hire_date_columns = TTDate::getReportDates('hire', TTDate::parseDateTime($row['hire_date']), FALSE, $this->getUserObject());
} else {
$hire_date_columns = array();
}
if (isset($row['termination_date'])) {
$termination_date_columns = TTDate::getReportDates('termination', TTDate::parseDateTime($row['termination_date']), FALSE, $this->getUserObject());
} else {
$termination_date_columns = array();
}
if (isset($row['birth_date'])) {
$birth_date_columns = TTDate::getReportDates('birth', TTDate::parseDateTime($row['birth_date']), FALSE, $this->getUserObject());
} else {
$birth_date_columns = array();
}
if (isset($row['created_date'])) {
$created_date_columns = TTDate::getReportDates('created', TTDate::parseDateTime($row['created_date']), FALSE, $this->getUserObject());
} else {
$created_date_columns = array();
}
if (isset($row['updated_date'])) {
$updated_date_columns = TTDate::getReportDates('updated', TTDate::parseDateTime($row['updated_date']), FALSE, $this->getUserObject());
} else {
$updated_date_columns = array();
}
$processed_data = array();
if (isset($this->tmp_data['user_preference'][$user_id])) {
$processed_data = array_merge($processed_data, $this->tmp_data['user_preference'][$user_id]);
}
if (isset($this->tmp_data['user_bank'][$user_id])) {
$processed_data = array_merge($processed_data, $this->tmp_data['user_bank'][$user_id]);
}
if (isset($this->tmp_data['user_wage'][$user_id])) {
$processed_data = array_merge($processed_data, $this->tmp_data['user_wage'][$user_id]);
}
$this->data[] = array_merge($row, $hire_date_columns, $termination_date_columns, $birth_date_columns, $created_date_columns, $updated_date_columns, $processed_data);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
unset($this->tmp_data, $row, $date_columns, $user_id, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['roe']), NULL, TTi18n::getText('Pre-Processing Data...'));
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['roe'])) {
foreach ($this->tmp_data['roe'] as $user_id => $row) {
$process_data = array();
if (isset($row['first_date'])) {
$first_date_columns = TTDate::getReportDates('first', TTDate::parseDateTime($row['first_date']), FALSE, $this->getUserObject());
} else {
$first_date_columns = array();
}
if (isset($row['last_date'])) {
$last_date_columns = TTDate::getReportDates('last', TTDate::parseDateTime($row['last_date']), FALSE, $this->getUserObject());
} else {
$last_date_columns = array();
}
if (isset($row['pay_period_end_date'])) {
$pay_period_end_date_columns = TTDate::getReportDates('pay_period_end', TTDate::parseDateTime($row['pay_period_end_date']), FALSE, $this->getUserObject());
} else {
$pay_period_end_date_columns = array();
}
if (isset($row['recall_date'])) {
$recall_date_columns = TTDate::getReportDates('recall', TTDate::parseDateTime($row['recall_date']), FALSE, $this->getUserObject());
} else {
$recall_date_columns = array();
}
if (isset($this->tmp_data['user'][$user_id])) {
if (is_array($this->tmp_data['user'][$user_id])) {
$process_data = array_merge($process_data, $this->tmp_data['user'][$user_id]);
}
if (is_array($row)) {
$process_data = array_merge($process_data, $row);
}
$this->data[] = array_merge($process_data, $first_date_columns, $last_date_columns, $pay_period_end_date_columns, $recall_date_columns);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
unset($this->tmp_data, $row, $first_date_columns, $last_date_columns, $pay_period_end_date_columns, $recall_date_columns, $process_data);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
$this->form_data = $this->data;
//Copy data to Form Data so group/sort doesn't affect it.
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['exception']), NULL, TTi18n::getText('Pre-Processing Data...'));
if (isset($this->tmp_data['user'])) {
$key = 0;
if (isset($this->tmp_data['exception'])) {
foreach ($this->tmp_data['exception'] as $user_id => $level_1) {
foreach ($level_1 as $id => $level_2) {
$date_columns = TTDate::getReportDates(NULL, TTDate::parseDateTime($level_2['date_stamp']), FALSE, $this->getUserObject(), array('pay_period_start_date' => strtotime($level_2['pay_period_start_date']), 'pay_period_end_date' => strtotime($level_2['pay_period_end_date']), 'pay_period_transaction_date' => strtotime($level_2['pay_period_transaction_date'])));
if (isset($this->tmp_data['user'][$user_id])) {
$this->data[] = array_merge($level_2, $this->tmp_data['user'][$user_id], $date_columns);
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
}
unset($this->tmp_data, $level_1);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['user_date_total']), NULL, TTi18n::getText('Pre-Processing Data...'));
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['user_date_total'])) {
foreach ($this->tmp_data['user_date_total'] as $user_id => $level_1) {
if (isset($this->tmp_data['user'][$user_id])) {
foreach ($level_1 as $date_stamp => $level_2) {
foreach ($level_2 as $branch => $level_3) {
foreach ($level_3 as $department => $row) {
$date_columns = TTDate::getReportDates(NULL, $date_stamp, FALSE, $this->getUserObject(), array('pay_period_start_date' => $row['pay_period_start_date'], 'pay_period_end_date' => $row['pay_period_end_date'], 'pay_period_transaction_date' => $row['pay_period_transaction_date']));
$processed_data = array();
if (isset($this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']])) {
$processed_data['verified_time_sheet'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['status'];
$processed_data['verified_time_sheet_date'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['created_date'];
} else {
$processed_data['verified_time_sheet'] = TTi18n::getText('No');
$processed_data['verified_time_sheet_date'] = FALSE;
}
if (!isset($row['worked_time'])) {
$row['worked_time'] = 0;
}
if (isset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working'])) {
$processed_data['schedule_working'] = $this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working'];
$processed_data['schedule_working_diff'] = $row['worked_time'] - $this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working'];
unset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working']);
} else {
$processed_data['schedule_working'] = 0;
$processed_data['schedule_working_diff'] = $row['worked_time'];
}
if (isset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_absent'])) {
$processed_data['schedule_absent'] = $this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_absent'];
unset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_absent']);
} else {
$processed_data['schedule_absent'] = 0;
}
if (isset($this->tmp_data['user'][$user_id]['default_branch_id']) and isset($this->tmp_data['default_branch'][$this->tmp_data['user'][$user_id]['default_branch_id']])) {
$tmp_default_branch = $this->tmp_data['default_branch'][$this->tmp_data['user'][$user_id]['default_branch_id']];
} else {
$tmp_default_branch = array();
}
if (isset($this->tmp_data['user'][$user_id]['default_department_id']) and isset($this->tmp_data['default_department'][$this->tmp_data['user'][$user_id]['default_department_id']])) {
$tmp_default_department = $this->tmp_data['default_department'][$this->tmp_data['user'][$user_id]['default_department_id']];
} else {
$tmp_default_department = array();
}
if (isset($this->tmp_data['branch'][$row['branch_id']])) {
$tmp_branch = $this->tmp_data['branch'][$row['branch_id']];
} else {
$tmp_branch = array();
}
if (isset($this->tmp_data['department'][$row['department_id']])) {
$tmp_department = $this->tmp_data['department'][$row['department_id']];
} else {
$tmp_department = array();
}
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $tmp_default_branch, $tmp_default_department, $tmp_branch, $tmp_department, $row, $date_columns, $processed_data);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
}
}
}
unset($this->tmp_data, $row, $date_columns, $processed_data, $level_1, $level_2, $level_3);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['pay_stub_entry']), NULL, TTi18n::getText('Pre-Processing Data...'));
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['pay_stub_entry'])) {
foreach ($this->tmp_data['pay_stub_entry'] as $user_id => $level_1) {
if (isset($this->tmp_data['user'][$user_id])) {
foreach ($level_1 as $date_stamp => $row) {
$date_columns = TTDate::getReportDates('transaction', $date_stamp, FALSE, $this->getUserObject(), array('pay_period_start_date' => $row['pay_period_start_date'], 'pay_period_end_date' => $row['pay_period_end_date'], 'pay_period_transaction_date' => $row['pay_period_transaction_date']));
$processed_data = array();
//Need to make sure PSEA IDs are strings not numeric otherwise array_merge will re-key them.
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $date_columns, $processed_data);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
}
unset($this->tmp_data, $row, $date_columns, $processed_data, $level_1);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function columnFormatter($type, $column, $value, $format = NULL)
{
if (is_array($value) and isset($value['display'])) {
//Found sorting array, use display column.
return $value['display'];
} else {
$retval = $value;
if ($format == 'csv' or $format == 'raw') {
//Force specific field formats for exporting to CSV format.
switch ($type) {
case 'report_date':
$column = strpos($column, 'custom_column') === FALSE ? $column : $column . '-' . 'date_stamp';
$retval = TTDate::getReportDates($column, $value, TRUE, $this->getUserObject());
break;
case 'currency':
case 'percent':
case 'numeric':
//Don't format above types.
break;
case 'time_unit':
$retval = TTDate::getHours($value);
//Force to hours always.
break;
case 'date_stamp':
$retval = TTDate::getDate('DATE', $value);
break;
case 'time':
$retval = TTDate::getDate('TIME', $value);
break;
case 'time_stamp':
$retval = TTDate::getDate('DATE+TIME', $value);
break;
case 'boolean':
if ($value == TRUE) {
$retval = TTi18n::getText('Yes');
} else {
$retval = TTi18n::getText('No');
}
default:
break;
}
} elseif ($format == 'xml') {
//Use standard XML formats whenever possible.
switch ($type) {
case 'report_date':
$column = strpos($column, 'custom_column') === FALSE ? $column : $column . '-' . 'date_stamp';
$retval = TTDate::getReportDates($column, $value, TRUE, $this->getUserObject());
break;
case 'currency':
case 'percent':
case 'numeric':
//Don't format above types.
break;
case 'time_unit':
$retval = TTDate::getHours($value);
//Force to hours always.
break;
case 'date_stamp':
$retval = date('Y-m-d', $value);
////type="xs:date"
break;
case 'time':
$retval = date('H:i:s', $value);
//type="xs:time"
break;
case 'time_stamp':
$retval = date('c', $value);
//type="xs:dateTime"
break;
case 'boolean':
if ($value == TRUE) {
$retval = TTi18n::getText('Yes');
} else {
$retval = TTi18n::getText('No');
}
default:
break;
}
} else {
switch ($type) {
case 'report_date':
$column = strpos($column, 'custom_column') === FALSE ? $column : $column . '-' . 'date_stamp';
$retval = TTDate::getReportDates($column, $value, TRUE, $this->getUserObject());
break;
case 'currency':
if (is_object($this->getCurrencyObject())) {
//Set MIN decimals to 2 and max to the currency rounding.
$retval = $this->getCurrencyObject()->getSymbol() . TTi18n::formatNumber($value, TRUE, 2, $this->getCurrencyObject()->getRoundDecimalPlaces());
} else {
$retval = TTi18n::formatCurrency($value);
}
break;
case 'percent':
$retval = TTi18n::formatNumber($value, TRUE) . '%';
break;
case 'numeric':
$retval = TTi18n::formatNumber($value, TRUE);
break;
case 'time_unit':
$retval = TTDate::getTimeUnit($value);
break;
case 'date_stamp':
$retval = TTDate::getDate('DATE', $value);
break;
case 'time':
$retval = TTDate::getDate('TIME', $value);
break;
case 'time_stamp':
$retval = TTDate::getDate('DATE+TIME', $value);
break;
case 'boolean':
if ($value == TRUE) {
$retval = TTi18n::getText('Yes');
} else {
$retval = TTi18n::getText('No');
}
break;
case 'time_since':
$retval = TTDate::getHumanTimeSince($value);
break;
default:
break;
}
}
//Debug::Text('Column: '. $column .' Value: '. $value .' Type: '. $type .' Retval: '. $retval, __FILE__, __LINE__, __METHOD__,10);
return $retval;
}
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['pay_stub_entry']), NULL, TTi18n::getText('Pre-Processing Data...'));
$blf = TTnew('BranchListFactory');
$branch_options = $blf->getByCompanyIdArray($this->getUserObject()->getCompany());
//Get Branch ID to Branch Code mapping
$branch_code_map = array(0 => 0);
$blf->getByCompanyId($this->getUserObject()->getCompany());
if ($blf->getRecordCount() > 0) {
foreach ($blf as $b_obj) {
$branch_code_map[$b_obj->getId()] = $b_obj;
}
}
$dlf = TTnew('DepartmentListFactory');
$department_options = $dlf->getByCompanyIdArray($this->getUserObject()->getCompany());
//Get Department ID to Branch Code mapping
$department_code_map = array(0 => 0);
$dlf->getByCompanyId($this->getUserObject()->getCompany());
if ($dlf->getRecordCount() > 0) {
foreach ($dlf as $d_obj) {
$department_code_map[$d_obj->getId()] = $d_obj;
}
}
$utlf = TTnew('UserTitleListFactory');
$title_options = $utlf->getByCompanyIdArray($this->getUserObject()->getCompany());
if (getTTProductEdition() >= TT_PRODUCT_CORPORATE) {
$jlf = TTnew('JobListFactory');
$job_options = $jlf->getByCompanyIdArray($this->getUserObject()->getCompany());
//Get Job ID to Job Code mapping
$job_code_map = array(0 => 0);
$jlf->getByCompanyId($this->getUserObject()->getCompany());
if ($jlf->getRecordCount() > 0) {
foreach ($jlf as $j_obj) {
$job_code_map[$j_obj->getId()] = $j_obj;
}
}
$jilf = TTnew('JobItemListFactory');
$job_item_options = $jlf->getByCompanyIdArray($this->getUserObject()->getCompany());
//Get Job ID to Job Code mapping
$job_item_code_map = array(0 => 0);
$jilf->getByCompanyId($this->getUserObject()->getCompany());
if ($jilf->getRecordCount() > 0) {
foreach ($jilf as $ji_obj) {
$job_item_code_map[$ji_obj->getId()] = $ji_obj;
}
}
} else {
$job_code_map = array();
$job_item_code_map = array();
}
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['pay_stub_entry'])) {
foreach ($this->tmp_data['pay_stub_entry'] as $user_id => $level_1) {
if (isset($this->tmp_data['user'][$user_id])) {
//foreach( $level_1 as $date_stamp => $row ) {
foreach ($level_1 as $date_stamp => $row) {
$replace_arr = array(is_object($branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]) ? $branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]->getManualID() : NULL, is_object($branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]) ? $branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]->getOtherID1() : NULL, is_object($branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]) ? $branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]->getOtherID2() : NULL, is_object($branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]) ? $branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]->getOtherID3() : NULL, is_object($branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]) ? $branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]->getOtherID4() : NULL, is_object($branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]) ? $branch_code_map[(int) $this->tmp_data['user'][$user_id]['default_branch_id']]->getOtherID5() : NULL, is_object($department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]) ? $department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]->getManualID() : NULL, is_object($department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]) ? $department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]->getOtherID1() : NULL, is_object($department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]) ? $department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]->getOtherID2() : NULL, is_object($department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]) ? $department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]->getOtherID3() : NULL, is_object($department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]) ? $department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]->getOtherID4() : NULL, is_object($department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]) ? $department_code_map[(int) $this->tmp_data['user'][$user_id]['default_department_id']]->getOtherID5() : NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, isset($this->tmp_data['user'][$user_id]['employee_number']) ? $this->tmp_data['user'][$user_id]['employee_number'] : NULL, isset($this->tmp_data['user'][$user_id]['other_id1']) ? $this->tmp_data['user'][$user_id]['other_id1'] : NULL, isset($this->tmp_data['user'][$user_id]['other_id2']) ? $this->tmp_data['user'][$user_id]['other_id2'] : NULL, isset($this->tmp_data['user'][$user_id]['other_id3']) ? $this->tmp_data['user'][$user_id]['other_id3'] : NULL, isset($this->tmp_data['user'][$user_id]['other_id4']) ? $this->tmp_data['user'][$user_id]['other_id4'] : NULL, isset($this->tmp_data['user'][$user_id]['other_id5']) ? $this->tmp_data['user'][$user_id]['other_id5'] : NULL);
$date_columns = TTDate::getReportDates('transaction', $date_stamp, FALSE, $this->getUserObject(), array('pay_period_start_date' => $row['pay_period_start_date'], 'pay_period_end_date' => $row['pay_period_end_date'], 'pay_period_transaction_date' => $row['pay_period_transaction_date']));
$processed_data = array();
if (isset($row['psen_ids']) and is_array($row['psen_ids'])) {
$psen_ids = $row['psen_ids'];
unset($row['psen_ids']);
foreach ($psen_ids as $psen_data) {
if ($this->enable_time_based_distribution == TRUE) {
$expanded_gl_rows = $this->expandGLAccountRows($psen_data, $this->tmp_data['pay_period_distribution'][$user_id][$row['pay_period_id']], $branch_code_map, $department_code_map, $job_code_map, $job_item_code_map, $replace_arr);
foreach ($expanded_gl_rows as $gl_row) {
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $date_columns, $processed_data, $gl_row);
}
unset($expanded_gl_rows, $psen_data);
} else {
$psen_data['account'] = $this->replaceGLAccountVariables($psen_data['account'], $replace_arr);
//Need to make sure PSEA IDs are strings not numeric otherwise array_merge will re-key them.
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $date_columns, $processed_data, $psen_data);
}
}
unset($psen_ids, $psen_id, $psen_amount);
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
}
unset($this->tmp_data, $row, $date_columns, $processed_data, $level_1);
}
$this->form_data = $this->data;
//Used for exporting.
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess($format)
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['user_date_total']), NULL, TTi18n::getText('Pre-Processing Data...'));
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['user_date_total'])) {
foreach ($this->tmp_data['user_date_total'] as $user_id => $level_1) {
if (isset($this->tmp_data['user'][$user_id])) {
foreach ($level_1 as $date_stamp => $level_2) {
foreach ($level_2 as $branch => $level_3) {
foreach ($level_3 as $department => $row) {
$date_columns = TTDate::getReportDates(NULL, $date_stamp, FALSE, $this->getUserObject(), array('pay_period_start_date' => $row['pay_period_start_date'], 'pay_period_end_date' => $row['pay_period_end_date'], 'pay_period_transaction_date' => $row['pay_period_transaction_date']));
$processed_data = array();
if (isset($this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']])) {
$processed_data['verified_time_sheet_user_verified'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['user_verified'];
$processed_data['verified_time_sheet_user_verified_date'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['user_verified_date'];
$processed_data['verified_time_sheet_status_id'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['status_id'];
$processed_data['verified_time_sheet'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['status'];
$processed_data['verified_time_sheet_date'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['updated_date'];
} else {
$processed_data['verified_time_sheet_status_id'] = $processed_data['verified_time_sheet_user_verified'] = $processed_data['verified_time_sheet_user_verified_date'] = FALSE;
$processed_data['verified_time_sheet'] = TTi18n::getText('No');
$processed_data['verified_time_sheet_date'] = FALSE;
}
if (isset($this->tmp_data['pay_period'][$row['pay_period_id']])) {
$processed_data['start_week_day'] = $this->tmp_data['pay_period'][$row['pay_period_id']]['start_week_day'];
}
if (!isset($row['worked_time'])) {
$row['worked_time'] = 0;
}
if (isset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working'])) {
$processed_data['schedule_working'] = $this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working'];
$processed_data['schedule_working_diff'] = $row['worked_time'] - $this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working'];
//We can only include scheduled_time once per user/date combination. Otherwise its duplicates the amounts and makes it incorrect.
//So once its used unset it so it can't be used again.
unset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_working']);
} else {
$processed_data['schedule_working'] = 0;
$processed_data['schedule_working_diff'] = $row['worked_time'];
}
if (isset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_absent'])) {
$processed_data['schedule_absent'] = $this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_absent'];
unset($this->tmp_data['schedule'][$user_id][$date_stamp]['schedule_absent']);
} else {
$processed_data['schedule_absent'] = 0;
}
if (strpos($format, 'pdf_') === FALSE) {
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $date_columns, $processed_data);
} else {
$this->form_data['user_date_total'][$user_id]['data'][$date_stamp] = array_merge($this->form_data['user_date_total'][$user_id]['data'][$date_stamp], $date_columns, $processed_data);
//$this->form_data[$user_id]['data'][] = array_merge( $row, $date_columns, $processed_data );
}
}
}
}
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
unset($this->tmp_data, $row, $date_columns, $processed_data, $level_1, $level_2, $level_3);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($this->form_data, 'Form Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['qualification']), NULL, TTi18n::getText('Pre-Processing Data...'));
if (isset($this->tmp_data['qualification'])) {
$key = 0;
foreach ($this->tmp_data['qualification'] as $qualification_id => $row) {
if (isset($this->tmp_data['user'])) {
foreach ($this->tmp_data['user'] as $user_id => $user) {
if (isset($user['user.hire_date'])) {
$hire_date_columns = TTDate::getReportDates('user.hire', TTDate::parseDateTime($user['user.hire_date']), FALSE, $this->getUserObject());
} else {
$hire_date_columns = array();
}
if (isset($user['user.termination_date'])) {
$termination_date_columns = TTDate::getReportDates('user.termination', TTDate::parseDateTime($user['user.termination_date']), FALSE, $this->getUserObject());
} else {
$termination_date_columns = array();
}
if (isset($user['user.birth_date'])) {
$birth_date_columns = TTDate::getReportDates('user.birth', TTDate::parseDateTime($user['user.birth_date']), FALSE, $this->getUserObject());
} else {
$birth_date_columns = array();
}
$processed_data = array();
if (isset($this->tmp_data['user_preference'][$user_id])) {
$processed_data = array_merge($processed_data, (array) $this->tmp_data['user_preference'][$user_id]);
}
if (isset($this->tmp_data['user_wage'][$user_id])) {
$processed_data = array_merge($processed_data, (array) $this->tmp_data['user_wage'][$user_id]);
}
if (isset($this->tmp_data['user_skill'][$qualification_id][$user_id])) {
foreach ($this->tmp_data['user_skill'][$qualification_id][$user_id] as $user_skill) {
if (isset($user_skill['user_skill.first_used_date'])) {
$user_skill['user_skill.first_used_date'] = array('sort' => TTDate::parseDateTime($user_skill['user_skill.first_used_date']), 'display' => $user_skill['user_skill.first_used_date']);
}
if (isset($user_skill['user_skill.last_used_date'])) {
$user_skill['user_skill.last_used_date'] = array('sort' => TTDate::parseDateTime($user_skill['user_skill.last_used_date']), 'display' => $user_skill['user_skill.last_used_date']);
}
$this->data[] = array_merge((array) $row, (array) $user, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data, (array) $user_skill);
}
}
if (isset($this->tmp_data['user_education'][$qualification_id][$user_id])) {
foreach ($this->tmp_data['user_education'][$qualification_id][$user_id] as $user_education) {
if (isset($user_education['user_education.start_date'])) {
$user_education['user_education.start_date'] = array('sort' => TTDate::parseDateTime($user_education['user_education.start_date']), 'display' => $user_education['user_education.start_date']);
}
if (isset($user_education['user_education.end_date'])) {
$user_education['user_education.end_date'] = array('sort' => TTDate::parseDateTime($user_education['user_education.end_date']), 'display' => $user_education['user_education.end_date']);
}
if (isset($user_education['user_education.graduate_date'])) {
$user_education['user_education.graduate_date'] = array('sort' => TTDate::parseDateTime($user_education['user_education.graduate_date']), 'display' => $user_education['user_education.graduate_date']);
}
$this->data[] = array_merge((array) $row, (array) $user, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data, (array) $user_education);
}
}
if (isset($this->tmp_data['user_license'][$qualification_id][$user_id])) {
foreach ($this->tmp_data['user_license'][$qualification_id][$user_id] as $user_license) {
if (isset($user_license['user_license.license_issued_date'])) {
$user_license['user_license.license_issued_date'] = array('sort' => TTDate::parseDateTime($user_license['user_license.license_issued_date']), 'display' => $user_license['user_license.license_issued_date']);
}
if (isset($user_license['user_license.license_expiry_date'])) {
$user_license['user_license.license_expiry_date'] = array('sort' => TTDate::parseDateTime($user_license['user_license.license_expiry_date']), 'display' => $user_license['user_license.license_expiry_date']);
}
$this->data[] = array_merge((array) $row, (array) $user, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data, (array) $user_license);
}
}
if (isset($this->tmp_data['user_language'][$qualification_id][$user_id])) {
foreach ($this->tmp_data['user_language'][$qualification_id][$user_id] as $user_language) {
$this->data[] = array_merge((array) $row, (array) $user, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data, (array) $user_language);
}
}
if (isset($this->tmp_data['user_membership'][$qualification_id][$user_id])) {
foreach ($this->tmp_data['user_membership'][$qualification_id][$user_id] as $user_membership) {
if (isset($user_membership['user_membership.start_date'])) {
$user_membership['user_membership.start_date'] = array('sort' => TTDate::parseDateTime($user_membership['user_membership.start_date']), 'display' => $user_membership['user_membership.start_date']);
}
if (isset($user_membership['user_membership.renewal_date'])) {
$user_membership['user_membership.renewal_date'] = array('sort' => TTDate::parseDateTime($user_membership['user_membership.renewal_date']), 'display' => $user_membership['user_membership.renewal_date']);
}
$this->data[] = array_merge((array) $row, (array) $user, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data, (array) $user_membership);
}
}
}
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
unset($this->tmp_data, $row, $date_columns, $hire_date_columns, $termination_date_columns, $birth_date_columns, $processed_data);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['punch']), NULL, TTi18n::getText('Pre-Processing Data...'));
//Merge time data with user data
$key = 0;
if (isset($this->tmp_data['punch'])) {
foreach ($this->tmp_data['punch'] as $user_id => $level_1) {
if (isset($this->tmp_data['user'][$user_id])) {
foreach ($level_1 as $punch_control_id => $row) {
$date_columns = TTDate::getReportDates(NULL, $row['date_stamp'], FALSE, $this->getUserObject(), array('pay_period_start_date' => $row['pay_period_start_date'], 'pay_period_end_date' => $row['pay_period_end_date'], 'pay_period_transaction_date' => $row['pay_period_transaction_date']));
//$date_columns1 = TTDate::getReportDates( 'in_time_stamp', $row['in_time_stamp'], FALSE, $this->getUserObject() );
//$date_columns2 = TTDate::getReportDates( 'out_time_stamp', $row['out_time_stamp'], FALSE, $this->getUserObject() );
$processed_data = array();
if (isset($this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']])) {
$processed_data['verified_time_sheet'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['status'];
$processed_data['verified_time_sheet_date'] = $this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]['created_date'];
} else {
$processed_data['verified_time_sheet'] = TTi18n::getText('No');
$processed_data['verified_time_sheet_date'] = FALSE;
}
if (isset($this->tmp_data['verified_timesheet'][$user_id][$row['pay_period_id']]) and isset($row['in_updated_date']) and isset($row['out_updated_date']) and ($processed_data['verified_time_sheet_date'] < $row['in_updated_date'] or $processed_data['verified_time_sheet_date'] < $row['out_updated_date'])) {
$processed_data['verified_time_sheet_tainted'] = TRUE;
} else {
$processed_data['verified_time_sheet_tainted'] = FALSE;
}
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $date_columns, $processed_data);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
}
unset($this->tmp_data, $row, $date_columns, $processed_data, $level_1);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['user_review_control']), NULL, TTi18n::getText('Pre-Processing Data...'));
$key = 0;
if (isset($this->tmp_data['user_review_control'])) {
foreach ($this->tmp_data['user_review_control'] as $user_review_control_id => $level_1) {
foreach ($level_1 as $user_id => $user_review_control) {
$processed_data = array();
if (isset($user_review_control['user_review_control.start_date'])) {
$start_date_columns = TTDate::getReportDates('user_review_control.start', TTDate::parseDateTime($user_review_control['user_review_control.start_date']), FALSE, $this->getUserObject());
} else {
$start_date_columns = array();
}
if (isset($user_review_control['user_review_control.end_date'])) {
$end_date_columns = TTDate::getReportDates('user_review_control.end', TTDate::parseDateTime($user_review_control['user_review_control.end_date']), FALSE, $this->getUserObject());
} else {
$end_date_columns = array();
}
if (isset($user_review_control['user_review_control.due_date'])) {
$due_date_columns = TTDate::getReportDates('user_review_control.due', TTDate::parseDateTime($user_review_control['user_review_control.due_date']), FALSE, $this->getUserObject());
} else {
$due_date_columns = array();
}
if (isset($this->tmp_data['user'][$user_id]) and is_array($this->tmp_data['user'][$user_id])) {
$processed_data = array_merge($processed_data, $this->tmp_data['user'][$user_id]);
}
if (isset($this->tmp_data['user_review'][$user_review_control_id])) {
foreach ($this->tmp_data['user_review'][$user_review_control_id] as $kpi_id => $kpi) {
if (is_array($kpi)) {
$processed_data = array_merge($processed_data, $kpi);
}
if (is_array($user_review_control)) {
$processed_data = array_merge($processed_data, $user_review_control);
}
if (isset($this->tmp_data['kpi'][$kpi_id]) and is_array($this->tmp_data['kpi'][$kpi_id])) {
$processed_data = array_merge($processed_data, $this->tmp_data['kpi'][$kpi_id]);
}
$this->data[] = array_merge($start_date_columns, $end_date_columns, $due_date_columns, $processed_data);
}
}
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
unset($this->tmp_data, $kpi, $user_review_control, $start_date_columns, $end_date_columns, $due_date_columns, $processed_data);
}
Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__, 10);
return TRUE;
}
function _preProcess()
{
$this->getProgressBarObject()->start($this->getAMFMessageID(), count($this->tmp_data['accrual']), NULL, TTi18n::getText('Pre-Processing Data...'));
if (isset($this->tmp_data['user'])) {
$key = 0;
if (isset($this->tmp_data['accrual'])) {
foreach ($this->tmp_data['accrual'] as $user_id => $level_2) {
if (isset($this->tmp_data['user'][$user_id])) {
foreach ($level_2 as $accrual_policy_id => $rows) {
foreach ($rows as $row) {
if (isset($row['date_stamp'])) {
$date_columns = TTDate::getReportDates(NULL, TTDate::strtotime($row['date_stamp']), FALSE, $this->getUserObject());
} else {
$date_columns = array();
}
$this->data[] = array_merge($this->tmp_data['user'][$user_id], $row, $this->tmp_data['accrual'][$user_id][$accrual_policy_id], $date_columns);
}
}
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
$key++;
}
}
unset($this->tmp_data, $row, $processed_data);
}
//Debug::Arr($this->data, 'preProcess Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
