/**
* Get user generic status data for one or more .
* @param array $data filter data
* @return array
*/
function getUserGenericStatus($data = NULL, $disable_paging = FALSE)
{
$data = $this->initializeFilterAndPager($data, $disable_paging);
$user_id = $this->getCurrentUserObject()->getId();
if ($data['filter_data']['batch_id'] != '') {
$batch_id = $data['filter_data']['batch_id'];
$ugslf = TTnew('UserGenericStatusListFactory');
$ugslf->getByUserIdAndBatchId($user_id, $batch_id, $data['filter_items_per_page'], $data['filter_page'], NULL, $data['filter_sort']);
Debug::Text('Record Count: ' . $ugslf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($ugslf->getRecordCount() > 0) {
//$status_count_arr = $ugslf->getStatusCountArrayByUserIdAndBatchId( $user_id, $batch_id );
$this->getProgressBarObject()->start($this->getAMFMessageID(), $ugslf->getRecordCount());
$this->setPagerObject($ugslf);
foreach ($ugslf as $ugs_obj) {
$rows[] = array('id' => $ugs_obj->getId(), 'user_id' => $ugs_obj->getUser(), 'batch_id' => $ugs_obj->getBatchId(), 'status_id' => $ugs_obj->getStatus(), 'status' => Option::getByKey($ugs_obj->getStatus(), $ugs_obj->getOptions('status')), 'label' => $ugs_obj->getLabel(), 'description' => $ugs_obj->getDescription(), 'link' => $ugs_obj->getLink(), 'deleted' => $ugs_obj->getDeleted());
$this->getProgressBarObject()->set($this->getAMFMessageID(), $ugslf->getCurrentRow());
}
$this->getProgressBarObject()->stop($this->getAMFMessageID());
return $this->returnHandler($rows);
} else {
return $this->returnHandler(TRUE);
//No records returned.
}
} else {
return $this->returnHandler(TRUE);
//No records returned.
}
}
$day_total_time['total_time'] += $udt_obj->getTotalTime();
}
if ($filter_system_time != 1 and $udt_obj->getStatus() == 10) {
continue;
}
if ($udt_obj->getJob() != FALSE) {
$job = $job_options[$udt_obj->getJob()];
} else {
$job = 'No Job';
}
if ($udt_obj->getJobItem() != FALSE) {
$job_item = $job_item_options[$udt_obj->getJobItem()];
} else {
$job_item = TTi18n::gettext('No Task');
}
$rows[] = array('id' => $udt_obj->getId(), 'status_id' => $udt_obj->getStatus(), 'status' => Option::getByKey($udt_obj->getStatus(), $udt_obj->getOptions('status')), 'type_id' => $udt_obj->getType(), 'type' => Option::getByKey($udt_obj->getType(), $udt_obj->getOptions('type')), 'branch_id' => $udt_obj->getBranch(), 'branch' => $branch_options[$udt_obj->getBranch()], 'department_id' => $udt_obj->getDepartment(), 'department' => $department_options[$udt_obj->getDepartment()], 'job_id' => $udt_obj->getJob(), 'job' => $job, 'job_item_id' => $udt_obj->getJobItem(), 'job_item' => $job_item, 'quantity' => (int) $udt_obj->getQuantity(), 'bad_quantity' => (int) $udt_obj->getBadQuantity(), 'absence_policy_id' => $udt_obj->getAbsencePolicyID(), 'absence_policy' => $absence_policy_options[$udt_obj->getAbsencePolicyID()], 'over_time_policy_id' => $udt_obj->getOverTimePolicyID(), 'over_time_policy' => $over_time_policy_options[$udt_obj->getOverTimePolicyID()], 'premium_policy_id' => $udt_obj->getPremiumPolicyID(), 'premium_policy' => $premium_policy_options[$udt_obj->getPremiumPolicyID()], 'total_time' => $udt_obj->getTotalTime(), 'override' => $udt_obj->getOverride(), 'deleted' => $udt_obj->getDeleted());
}
$day_total_time['difference'] = $day_total_time['worked_time'] - $day_total_time['total_time'];
//var_dump($day_total_time);
$user_options = UserListFactory::getByCompanyIdArray($current_company->getId(), FALSE);
$smarty->assign_by_ref('user_options', $user_options);
$smarty->assign_by_ref('rows', $rows);
$smarty->assign_by_ref('day_total_time', $day_total_time);
$smarty->assign_by_ref('user_date_id', $user_date_id);
$smarty->assign_by_ref('filter_user_id', $user_id);
$smarty->assign_by_ref('filter_date', $filter_date);
$smarty->assign_by_ref('filter_system_time', $filter_system_time);
$smarty->assign_by_ref('sort_column', $sort_column);
$smarty->assign_by_ref('sort_order', $sort_order);
$smarty->assign_by_ref('paging_data', $pager->getPageVariables());
}
foreach ($data_a as $pay_period_id => $data_b) {
$rows[$x]['user_id'] = $user_obj->getId();
$rows[$x]['full_name'] = $user_obj->getFullName(TRUE);
$rows[$x]['employee_number'] = $user_obj->getEmployeeNumber();
$rows[$x]['status'] = Option::getByKey($user_obj->getStatus(), $user_obj->getOptions('status'));
//$rows[$x]['province'] = Option::getByKey($user_obj->getProvince(), $user_obj->getCompanyObject()->getOptions('province', $user_obj->getCountry() ) );
//$rows[$x]['country'] = Option::getByKey($user_obj->getCountry(), $user_obj->getCompanyObject()->getOptions('country') );
$rows[$x]['province'] = $user_obj->getProvince();
$rows[$x]['country'] = $user_obj->getCountry();
$rows[$x]['pay_period_id'] = $pay_period_id;
$rows[$x]['pay_period_order'] = Option::getByKey($pay_period_id, $pay_period_end_dates, NULL);
$rows[$x]['pay_period'] = Option::getByKey($pay_period_id, $pay_period_options, NULL);
$rows[$x]['title'] = Option::getByKey($user_obj->getTitle(), $title_options, NULL);
$rows[$x]['group'] = Option::getByKey($user_obj->getGroup(), $group_options, NULL);
$rows[$x]['default_branch'] = Option::getByKey($user_obj->getDefaultBranch(), $branch_options, NULL);
$rows[$x]['default_department'] = Option::getByKey($user_obj->getDefaultDepartment(), $department_options, NULL);
if ($verified_time_sheets !== NULL and isset($verified_time_sheets[$user_id][$pay_period_id])) {
if ($verified_time_sheets[$user_id][$pay_period_id] == 50) {
$rows[$x]['verified_time_sheet'] = TTi18n::gettext('Yes');
} elseif ($verified_time_sheets[$user_id][$pay_period_id] == 30 or $verified_time_sheets[$user_id][$pay_period_id] == 45) {
$rows[$x]['verified_time_sheet'] = TTi18n::gettext('Pending');
} else {
$rows[$x]['verified_time_sheet'] = TTi18n::gettext('Declined');
}
} else {
$rows[$x]['verified_time_sheet'] = TTi18n::gettext('No');
}
if (isset($pending_requests[$pay_period_id])) {
$rows[$x]['pending_request'] = $pending_requests[$pay_period_id];
} else {
$rows[$x]['pending_request'] = 0;
function getObjectAsArray($include_columns = NULL, $permission_children_ids = FALSE)
{
$uf = TTnew('UserFactory');
$variable_function_map = $this->getVariableToFunctionMap();
if (is_array($variable_function_map)) {
foreach ($variable_function_map as $variable => $function_stub) {
if ($include_columns == NULL or isset($include_columns[$variable]) and $include_columns[$variable] == TRUE) {
$function = 'get' . $function_stub;
switch ($variable) {
case 'first_name':
case 'last_name':
if ($this->getColumn('user_id') > 0) {
$data[$variable] = $this->getColumn($variable);
} else {
$data[$variable] = TTi18n::getText('OPEN');
}
break;
case 'user_id':
//Make sure getUser() returns the proper user_id, otherwise mass edit will always assign shifts to OPEN employee.
//We have to make sure the 'user_id' function map is FALSE as well, so we don't get a SQL error when getting the empty record set.
$data[$variable] = $this->tmp_data['user_id'] = $this->getColumn($variable);
break;
case 'user_status_id':
case 'group_id':
case 'group':
case 'title_id':
case 'title':
case 'default_branch_id':
case 'default_branch':
case 'default_department_id':
case 'default_department':
case 'schedule_policy_id':
case 'schedule_policy':
case 'pay_period_id':
case 'branch':
case 'department':
case 'job':
case 'job_item':
$data[$variable] = $this->getColumn($variable);
break;
case 'status':
$function = 'get' . $variable;
if (method_exists($this, $function)) {
$data[$variable] = Option::getByKey($this->{$function}(), $this->getOptions($variable));
}
break;
case 'user_status':
$data[$variable] = Option::getByKey((int) $this->getColumn('user_status_id'), $uf->getOptions('status'));
break;
case 'date_stamp':
$data[$variable] = TTDate::getAPIDate('DATE', strtotime($this->getColumn('date_stamp')));
break;
case 'start_date_stamp':
$data[$variable] = TTDate::getAPIDate('DATE', $this->getStartTime());
//Include both date+time
break;
case 'start_date':
$data[$variable] = TTDate::getAPIDate('DATE+TIME', $this->getStartTime());
//Include both date+time
break;
case 'end_date':
$data[$variable] = TTDate::getAPIDate('DATE+TIME', $this->getEndTime());
//Include both date+time
break;
case 'start_time_stamp':
$data[$variable] = $this->getStartTime();
//Include start date/time in epoch format for sorting...
break;
case 'end_time_stamp':
$data[$variable] = $this->getEndTime();
//Include end date/time in epoch format for sorting...
break;
case 'start_time':
case 'end_time':
if (method_exists($this, $function)) {
$data[$variable] = TTDate::getAPIDate('TIME', $this->{$function}());
//Just include time, so Mass Edit sees similar times without dates
}
break;
default:
if (method_exists($this, $function)) {
$data[$variable] = $this->{$function}();
}
break;
}
}
}
$this->getPermissionColumns($data, $this->getColumn('user_id'), $this->getCreatedBy(), $permission_children_ids, $include_columns);
$this->getCreatedAndUpdatedColumns($data, $include_columns);
}
return $data;
}
function getAllArray()
{
$hlf = new HelpListFactory();
$hlf->getAll();
$help_list[0] = '--';
foreach ($hlf as $help) {
$help_list[$help->getID()] = '(' . $help->getID() . ') [' . Option::getByKey($help->getType(), $help->getOptions('type')) . '] ' . $help->getHeading();
}
return $help_list;
}
$plf = new PunchListFactory();
//$plf->getByPunchControlId( $pc_obj->getId() );
$plf->getById($id);
if ($plf->getRecordCount() > 0) {
$p_obj = $plf->getCurrent();
} else {
$punch_data = NULL;
}
//Get Station data.
$station_data = FALSE;
$slf = new StationListFactory();
if ($p_obj->getStation() != FALSE) {
$slf->getById($p_obj->getStation());
if ($slf->getRecordCount() > 0) {
$s_obj = $slf->getCurrent();
$station_data = array('id' => $s_obj->getId(), 'type_id' => $s_obj->getType(), 'type' => Option::getByKey($s_obj->getType(), $s_obj->getOptions('type')), 'station_id' => $s_obj->getStation(), 'source' => $s_obj->getSource(), 'description' => Misc::TruncateString($s_obj->getDescription(), 20));
}
}
$pc_data = array('id' => $pc_obj->getId(), 'user_date_id' => $pc_obj->getUserDateId(), 'user_id' => $pc_obj->getUserDateObject()->getUser(), 'user_full_name' => $pc_obj->getUserDateObject()->getUserObject()->getFullName(), 'pay_period_id' => $pc_obj->getUserDateObject()->getPayPeriod(), 'branch_id' => $pc_obj->getBranch(), 'department_id' => $pc_obj->getDepartment(), 'job_id' => $pc_obj->getJob(), 'job_item_id' => $pc_obj->getJobItem(), 'quantity' => (double) $pc_obj->getQuantity(), 'bad_quantity' => (double) $pc_obj->getBadQuantity(), 'note' => $pc_obj->getNote(), 'other_id1' => $pc_obj->getOtherID1(), 'other_id2' => $pc_obj->getOtherID2(), 'other_id3' => $pc_obj->getOtherID3(), 'other_id4' => $pc_obj->getOtherID4(), 'other_id5' => $pc_obj->getOtherID5(), 'punch_id' => $p_obj->getId(), 'status_id' => $p_obj->getStatus(), 'type_id' => $p_obj->getType(), 'station_id' => $p_obj->getStation(), 'station_data' => $station_data, 'time_stamp' => $p_obj->getTimeStamp(), 'date_stamp' => $p_obj->getTimeStamp(), 'original_time_stamp' => $p_obj->getOriginalTimeStamp(), 'actual_time_stamp' => $p_obj->getActualTimeStamp(), 'longitude' => $p_obj->getLongitude(), 'latitude' => $p_obj->getLatitude(), 'created_date' => $p_obj->getCreatedDate(), 'created_by' => $p_obj->getCreatedBy(), 'created_by_name' => (string) $ulf->getFullNameById($p_obj->getCreatedBy()), 'updated_date' => $p_obj->getUpdatedDate(), 'updated_by' => $p_obj->getUpdatedBy(), 'updated_by_name' => (string) $ulf->getFullNameById($p_obj->getUpdatedBy()), 'deleted_date' => $p_obj->getDeletedDate(), 'deleted_by' => $p_obj->getDeletedBy());
}
} elseif ($action != 'submit') {
Debug::Text(' ID was NOT passed: ' . $id, __FILE__, __LINE__, __METHOD__, 10);
//UserID has to be set at minimum
if ($punch_control_id != '') {
Debug::Text(' Punch Control ID was passed: ' . $punch_control_id, __FILE__, __LINE__, __METHOD__, 10);
//Get previous punch, and default timestamp to that.
$plf = new PunchListFactory();
$plf->getPreviousPunchByPunchControlID($punch_control_id);
if ($plf->getRecordCount() > 0) {
$prev_punch_obj = $plf->getCurrent();
$time_stamp = $prev_punch_obj->getTimeStamp() + 3600;
function getObjectTypeDisplay()
{
$object_type_ids = $this->getObjectType();
$object_types = $this->getOptions('short_object_type');
$retval = array();
foreach ($object_type_ids as $object_type_id) {
$retval[] = Option::getByKey($object_type_id, $object_types);
}
sort($retval);
//Maintain consistent order.
return implode(',', $retval);
}
function getObjectAsArray($include_columns = NULL)
{
$variable_function_map = $this->getVariableToFunctionMap();
if (is_array($variable_function_map)) {
foreach ($variable_function_map as $variable => $function_stub) {
if ($include_columns == NULL or isset($include_columns[$variable]) and $include_columns[$variable] == TRUE) {
$function = 'get' . $function_stub;
switch ($variable) {
case 'status':
$function = 'get' . $variable;
if (method_exists($this, $function)) {
$data[$variable] = Option::getByKey($this->{$function}(), $this->getOptions($variable));
}
break;
case 'start_time':
case 'end_time':
//$data[$variable] = ( defined('TIMETREX_API') ) ? TTDate::getAPIDate( 'TIME', TTDate::strtotime( $this->$function() ) ) : $this->$function();
$data[$variable] = defined('TIMETREX_API') ? TTDate::getAPIDate('TIME', TTDate::strtotime($this->{$function}())) : $this->{$function}();
//Need to include the raw_start_time,raw_end_time columns that are in EPOCH format so getShiftsByStartDateAndEndDate() can convert them as needed.
$data['raw_' . $variable] = $this->{$function}();
break;
case 'sun':
case 'mon':
case 'tue':
case 'wed':
case 'thu':
case 'fri':
case 'sat':
//For backwards compatibility, put all days inside the "days" array, AS WELL as in their own column for the API to use.
if (method_exists($this, $function)) {
$data['days'][$variable] = $this->{$function}();
}
default:
if (method_exists($this, $function)) {
$data[$variable] = $this->{$function}();
}
break;
}
}
}
$this->getCreatedAndUpdatedColumns($data, $include_columns);
}
return $data;
}
function _getData($format = NULL)
{
$this->tmp_data = array('schedule' => array(), 'user' => array(), 'total_shift' => array());
$columns = $this->getColumnDataConfig();
$filter_data = $this->getFilterConfig();
if ($this->getPermissionObject()->Check('schedule', 'view') == FALSE or $this->getPermissionObject()->Check('wage', 'view') == FALSE) {
$hlf = TTnew('HierarchyListFactory');
$permission_children_ids = $wage_permission_children_ids = $hlf->getHierarchyChildrenByCompanyIdAndUserIdAndObjectTypeID($this->getUserObject()->getCompany(), $this->getUserObject()->getID());
Debug::Arr($permission_children_ids, 'Permission Children Ids:', __FILE__, __LINE__, __METHOD__, 10);
} else {
//Get Permission Hierarchy Children first, as this can be used for viewing, or editing.
$permission_children_ids = array();
$wage_permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('schedule', 'view') == FALSE) {
if ($this->getPermissionObject()->Check('schedule', 'view_child') == FALSE) {
$permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('schedule', 'view_own')) {
$permission_children_ids[] = $this->getUserObject()->getID();
}
$filter_data['permission_children_ids'] = $permission_children_ids;
}
//Get Wage Permission Hierarchy Children first, as this can be used for viewing, or editing.
if ($this->getPermissionObject()->Check('wage', 'view') == TRUE) {
$wage_permission_children_ids = TRUE;
} elseif ($this->getPermissionObject()->Check('wage', 'view') == FALSE) {
if ($this->getPermissionObject()->Check('wage', 'view_child') == FALSE) {
$wage_permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('wage', 'view_own')) {
$wage_permission_children_ids[] = $this->getUserObject()->getID();
}
}
//Debug::Text(' Permission Children: '. count($permission_children_ids) .' Wage Children: '. count($wage_permission_children_ids), __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($permission_children_ids, 'Permission Children: '. count($permission_children_ids), __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($wage_permission_children_ids, 'Wage Children: '. count($wage_permission_children_ids), __FILE__, __LINE__, __METHOD__,10);
if ($this->getUserObject()->getCompanyObject()->getProductEdition() >= TT_PRODUCT_CORPORATE) {
$jlf = TTnew('JobListFactory');
$job_status_options = $jlf->getOptions('status');
} else {
$job_status_options = array();
}
$pay_period_ids = array();
if (strpos($format, 'schedule') === FALSE) {
//Avoid running these queries when printing out the schedule.
$slf = TTnew('ScheduleListFactory');
$slf->getScheduleSummaryReportByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data, NULL, NULL, NULL, array('last_name' => 'asc'));
//Sort by last name mainly for the PDF schedule for printing.
Debug::Text(' Total Rows: ' . $slf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $slf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
if ($slf->getRecordCount() > 0) {
foreach ($slf as $key => $s_obj) {
$hourly_rate = 0;
if ($wage_permission_children_ids === TRUE or in_array($s_obj->getColumn('user_id'), $wage_permission_children_ids)) {
$hourly_rate = $s_obj->getColumn('user_wage_hourly_rate');
}
$date_stamp_epoch = TTDate::strtotime($s_obj->getColumn('date_stamp'));
$shift_arr = array('user_id' => $s_obj->getColumn('user_id'), 'status_id' => $s_obj->getColumn('status_id'), 'group' => $s_obj->getColumn('group'), 'default_branch' => $s_obj->getColumn('default_branch'), 'default_department' => $s_obj->getColumn('default_department'), 'branch' => $s_obj->getColumn('branch'), 'department' => $s_obj->getColumn('department'), 'job' => $s_obj->getColumn('job'), 'job_status_id' => Option::getByKey($s_obj->getColumn('job_status_id'), $job_status_options, NULL), 'job_manual_id' => $s_obj->getColumn('job_manual_id'), 'job_description' => $s_obj->getColumn('job_description'), 'job_branch' => $s_obj->getColumn('job_branch'), 'job_department' => $s_obj->getColumn('job_department'), 'job_group' => $s_obj->getColumn('job_group'), 'job_item' => $s_obj->getColumn('job_item'), 'quantity' => $s_obj->getColumn('quantity'), 'bad_quantity' => $s_obj->getColumn('bad_quantity'), 'total_time' => $s_obj->getColumn('total_time'), 'total_time_wage' => Misc::MoneyFormat(bcmul(TTDate::getHours($s_obj->getColumn('total_time')), $hourly_rate), FALSE), 'total_time_wage_burden' => Misc::MoneyFormat(bcmul(TTDate::getHours($s_obj->getColumn('total_time')), bcmul($hourly_rate, bcdiv($s_obj->getColumn('user_labor_burden_percent'), 100))), FALSE), 'total_time_wage_with_burden' => Misc::MoneyFormat(bcmul(TTDate::getHours($s_obj->getColumn('total_time')), bcmul($hourly_rate, bcadd(bcdiv($s_obj->getColumn('user_labor_burden_percent'), 100), 1))), FALSE), 'other_id1' => $s_obj->getColumn('other_id1'), 'other_id2' => $s_obj->getColumn('other_id2'), 'other_id3' => $s_obj->getColumn('other_id3'), 'other_id4' => $s_obj->getColumn('other_id4'), 'other_id5' => $s_obj->getColumn('other_id5'), 'date_stamp' => $date_stamp_epoch, 'schedule_policy' => $s_obj->getColumn('schedule_policy'), 'absence_policy' => $s_obj->getColumn('absence_policy'), 'schedule_status' => Option::getByKey($s_obj->getStatus(), $s_obj->getOptions('status'), NULL), 'start_time' => TTDate::strtotime($s_obj->getColumn('start_time')), 'end_time' => TTDate::strtotime($s_obj->getColumn('end_time')), 'user_wage_id' => $s_obj->getColumn('user_wage_id'), 'hourly_rate' => Misc::MoneyFormat($hourly_rate, FALSE), 'pay_period_start_date' => strtotime($s_obj->getColumn('pay_period_start_date')), 'pay_period_end_date' => strtotime($s_obj->getColumn('pay_period_end_date')), 'pay_period_transaction_date' => strtotime($s_obj->getColumn('pay_period_transaction_date')), 'pay_period' => strtotime($s_obj->getColumn('pay_period_transaction_date')), 'pay_period_id' => $s_obj->getColumn('pay_period_id'), 'schedule_note' => $s_obj->getColumn('note'), 'total_shift' => 1);
unset($hourly_rate);
$this->tmp_data['schedule'][$s_obj->getColumn('user_id')][] = $shift_arr;
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
}
//Debug::Arr($this->tmp_data['schedule'], 'Schedule Raw Data: ', __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($this->form_data, 'Schedule Raw Data: ', __FILE__, __LINE__, __METHOD__,10);
}
unset($filter_data['status_id']);
//This is for schedule status, not user status.
//If we're printing the schedule, make sure we include the required columns.
if (in_array($format, $this->special_output_format)) {
$this->config['columns_data']['first_name'] = TRUE;
$this->config['columns_data']['last_name'] = TRUE;
}
//Get user data for joining.
$ulf = TTnew('UserListFactory');
$ulf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Total Rows: ' . $ulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $ulf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($ulf as $key => $u_obj) {
$this->tmp_data['user'][$u_obj->getId()] = $this->form_data['user'][$u_obj->getId()] = (array) $u_obj->getObjectAsArray($this->getColumnDataConfig());
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Add OPEN user to the list so it can printed on schedules.
$this->tmp_data['user'][0] = $this->form_data['user'][0] = array('first_name' => TTi18n::getText('OPEN'), 'last_name' => '');
//Debug::Arr($this->tmp_data['user'], 'User Raw Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
}
$af->FailTransaction();
}
Redirect::Page(URLBuilder::getURL(array('refresh' => TRUE), '../CloseWindow.php'));
break;
default:
if ((int) $id > 0) {
Debug::Text(' ID was passed: ' . $id, __FILE__, __LINE__, __METHOD__, 10);
$rlf = TTnew('RequestListFactory');
$rlf->getByIDAndCompanyID($id, $current_company->getId());
if ($rlf->getRecordCount() == 1) {
foreach ($rlf as $r_obj) {
//Debug::Arr($station,'Department', __FILE__, __LINE__, __METHOD__,10);
$hierarchy_type_id = $r_obj->getHierarchyTypeID();
$type_id = $r_obj->getType();
$data = array('id' => $r_obj->getId(), 'user_date_id' => $r_obj->getId(), 'user_id' => $r_obj->getUserDateObject()->getUser(), 'user_full_name' => $r_obj->getUserDateObject()->getUserObject()->getFullName(), 'date_stamp' => $r_obj->getUserDateObject()->getDateStamp(), 'type' => Option::getByKey($r_obj->getType(), $rlf->getOptions('type')), 'type_id' => $r_obj->getType(), 'hierarchy_type_id' => $r_obj->getHierarchyTypeID(), 'status_id' => $r_obj->getStatus(), 'authorized' => $r_obj->getAuthorized(), 'created_date' => $r_obj->getCreatedDate(), 'created_by' => $r_obj->getCreatedBy(), 'updated_date' => $r_obj->getUpdatedDate(), 'updated_by' => $r_obj->getUpdatedBy(), 'deleted_date' => $r_obj->getDeletedDate(), 'deleted_by' => $r_obj->getDeletedBy());
}
//Get Next Request to authorize:
if ($permission->Check('request', 'authorize') and $selected_level != NULL and count($request_queue_ids) <= 1) {
Debug::Text('Get Request Queue: ', __FILE__, __LINE__, __METHOD__, 10);
$ulf = TTnew('UserListFactory');
$hlf = TTnew('HierarchyListFactory');
$hllf = TTnew('HierarchyLevelListFactory');
$request_levels = $hllf->getLevelsAndHierarchyControlIDsByUserIdAndObjectTypeID($current_user->getId(), $hierarchy_type_id);
//Debug::Arr( $request_levels, 'Request Levels', __FILE__, __LINE__, __METHOD__,10);
if (isset($selected_level) and isset($request_levels[$selected_level])) {
$request_selected_level = $request_levels[$selected_level];
Debug::Text(' Switching Levels to Level: ' . key($request_selected_level), __FILE__, __LINE__, __METHOD__, 10);
} elseif (isset($request_levels[1])) {
$request_selected_level = $request_levels[1];
} else {
$utlf->getByCompanyId($current_company->getId());
$title_options = $utlf->getArrayByListFactory($utlf, FALSE, TRUE);
$blf = new BranchListFactory();
$blf->getByCompanyId($current_company->getId());
$branch_options = $blf->getArrayByListFactory($blf, FALSE, TRUE);
$dlf = new DepartmentListFactory();
$dlf->getByCompanyId($current_company->getId());
$department_options = $dlf->getArrayByListFactory($dlf, FALSE, TRUE);
$uglf = new UserGroupListFactory();
$group_options = $uglf->getArrayByNodes(FastTree::FormatArray($uglf->getByCompanyIdArray($current_company->getId()), 'TEXT', TRUE));
$ulf = new UserListFactory();
$user_options = $ulf->getByCompanyIdArray($current_company->getID(), FALSE);
foreach ($plf as $p_obj) {
//Debug::Text('Status ID: '. $r_obj->getStatus() .' Status: '. $status_options[$r_obj->getStatus()], __FILE__, __LINE__, __METHOD__,10);
$user_obj = $ulf->getById($p_obj->getColumn('user_id'))->getCurrent();
$rows[] = array('id' => $p_obj->getColumn('punch_id'), 'punch_control_id' => $p_obj->getPunchControlId(), 'user_id' => $p_obj->getColumn('user_id'), 'first_name' => $user_obj->getFirstName(), 'last_name' => $user_obj->getLastName(), 'title' => Option::getByKey($user_obj->getTitle(), $title_options), 'group' => Option::getByKey($user_obj->getGroup(), $group_options), 'default_branch' => Option::getByKey($user_obj->getDefaultBranch(), $branch_options), 'default_department' => Option::getByKey($user_obj->getDefaultDepartment(), $department_options), 'branch_id' => $p_obj->getColumn('branch_id'), 'branch' => Option::getByKey($p_obj->getColumn('branch_id'), $branch_options), 'department_id' => $p_obj->getColumn('department_id'), 'department' => Option::getByKey($p_obj->getColumn('department_id'), $department_options), 'status_id' => Option::getByKey($p_obj->getStatus(), $punch_status_options), 'type_id' => Option::getByKey($p_obj->getType(), $punch_type_options), 'date_stamp' => TTDate::getDate('DATE', TTDate::strtotime($p_obj->getColumn('date_stamp'))), 'job_id' => $p_obj->getColumn('job_id'), 'job_name' => $p_obj->getColumn('job_name'), 'job_group_id' => $p_obj->getColumn('job_group_id'), 'job_item_id' => $p_obj->getColumn('job_item_id'), 'time_stamp' => TTDate::getDate('DATE+TIME', $p_obj->getTimeStamp()), 'is_owner' => $permission->isOwner($p_obj->getCreatedBy(), $current_user->getId()), 'is_child' => $permission->isChild($p_obj->getColumn('user_id'), $permission_children_ids));
}
$smarty->assign_by_ref('rows', $rows);
$all_array_option = array('-1' => TTi18n::gettext('-- Any --'));
$ulf->getSearchByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data);
$filter_data['user_options'] = Misc::prependArray($all_array_option, UserListFactory::getArrayByListFactory($ulf, FALSE, TRUE));
//Select box options;
$filter_data['branch_options'] = Misc::prependArray($all_array_option, $branch_options);
$filter_data['department_options'] = Misc::prependArray($all_array_option, $department_options);
$filter_data['title_options'] = Misc::prependArray($all_array_option, $title_options);
$filter_data['group_options'] = Misc::prependArray($all_array_option, $group_options);
$filter_data['status_options'] = Misc::prependArray($all_array_option, $ulf->getOptions('status'));
$filter_data['pay_period_options'] = Misc::prependArray($all_array_option, $pay_period_options);
$filter_data['punch_status_options'] = Misc::prependArray($all_array_option, $punch_status_options);
$filter_data['punch_type_options'] = Misc::prependArray($all_array_option, $punch_type_options);
$filter_data['saved_search_options'] = $ugdlf->getArrayByListFactory($ugdlf->getByUserIdAndScript($current_user->getId(), $_SERVER['SCRIPT_NAME']), FALSE);
function addLog($log_action)
{
$object_type = Option::getByKey($this->getObjectType(), Misc::TrimSortPrefix($this->getOptions('object_type')));
return TTLog::addEntry($this->getHierarchyControl(), $log_action, TTi18n::getText('Object') . ': ' . $object_type, NULL, $this->getTable());
}
function _getData($format = NULL)
{
$this->tmp_data = array('user' => array(), 'log' => array());
$columns = $this->getColumnDataConfig();
$filter_data = $this->getFilterConfig();
if ($this->getPermissionObject()->Check('user', 'view') == FALSE) {
$hlf = TTnew('HierarchyListFactory');
$permission_children_ids = $hlf->getHierarchyChildrenByCompanyIdAndUserIdAndObjectTypeID($this->getUserObject()->getCompany(), $this->getUserObject()->getID());
Debug::Arr($permission_children_ids, 'Permission Children Ids:', __FILE__, __LINE__, __METHOD__, 10);
} else {
//Get Permission Hierarchy Children first, as this can be used for viewing, or editing.
$permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('user', 'view') == FALSE) {
if ($this->getPermissionObject()->Check('user', 'view_child') == FALSE) {
$permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('user', 'view_own')) {
$permission_children_ids[] = $this->getUserObject()->getID();
}
$filter_data['permission_children_ids'] = $permission_children_ids;
}
//Get user data for joining.
$ulf = TTnew('UserListFactory');
$ulf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Rows: ' . $ulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $ulf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($ulf as $key => $u_obj) {
$this->tmp_data['user'][$u_obj->getId()] = (array) $u_obj->getObjectAsArray($columns);
$this->tmp_data['user'][$u_obj->getId()]['user_status'] = Option::getByKey($u_obj->getStatus(), $u_obj->getOptions('status'));
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Debug::Arr($this->tmp_data['user'], 'TMP User Data: ', __FILE__, __LINE__, __METHOD__,10);
//Get system log data for joining.
if (count($this->tmp_data['user']) > 0) {
$filter_data['user_id'] = array_keys($this->tmp_data['user']);
//Filter only selected users, otherwise too many rows can be returned that wont be displayed.
$llf = TTnew('LogListFactory');
$llf->getSearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data, 5000);
Debug::Text(' Log Rows: ' . $llf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $llf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($llf as $key => $l_obj) {
$this->tmp_data['log'][$l_obj->getUser()][] = array_merge((array) $l_obj->getObjectAsArray($columns), array('total_log' => 1));
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Debug::Arr($this->tmp_data['log'], 'TMP Log Data: ', __FILE__, __LINE__, __METHOD__,10);
}
return TRUE;
}
function getArrayByListFactory($lf, $include_blank = TRUE, $include_disabled = TRUE)
{
if (!is_object($lf)) {
return FALSE;
}
if ($include_blank == TRUE) {
$list[0] = '--';
}
foreach ($lf as $obj) {
if ($obj->getStatus() != 10) {
$status = '(' . Option::getByKey($obj->getStatus(), $obj->getOptions('status')) . ') ';
} else {
$status = NULL;
}
if ($include_disabled == TRUE or $include_disabled == FALSE and $obj->getStatus() == 10) {
$list[$obj->getID()] = $status . $obj->getName();
}
}
if (isset($list)) {
return $list;
}
return FALSE;
}
static function getMapURL($address1, $address2, $city, $province, $postal_code, $country, $service = 'google', $service_params = array())
{
if ($address1 == '' and $address2 == '') {
return FALSE;
}
$url = NULL;
//Expand the country code to the full country name?
if (strlen($country) == 2) {
$cf = TTnew('CompanyFactory');
$long_country = Option::getByKey($country, $cf->getOptions('country'));
if ($long_country != '') {
$country = $long_country;
}
}
if ($service == 'google') {
$base_url = 'maps.google.com/?z=16&q=';
$url = $base_url . urlencode($address1 . ' ' . $city . ' ' . $province . ' ' . $postal_code . ' ' . $country);
}
if ($url != '') {
return 'http://' . $url;
}
return FALSE;
}
} else {
//Delete exceptions that aren't part of the product.
Debug::Text('Deleting exception outside product edition: ' . $ep_obj->getID(), __FILE__, __LINE__, __METHOD__, 10);
$ep_obj->setDeleted(TRUE);
if ($ep_obj->isValid()) {
$ep_obj->Save();
}
}
}
}
$exceptions = array();
if (isset($type_options) and is_array($type_options) and count($type_options) > 0) {
foreach ($type_options as $exception_type => $exception_name) {
if (isset($ep_objs[$exception_type])) {
$ep_obj = $ep_objs[$exception_type];
$exceptions[$ep_obj->getType()] = array('id' => $ep_obj->getId(), 'active' => $ep_obj->getActive(), 'type_id' => $ep_obj->getType(), 'name' => Option::getByKey($ep_obj->getType(), $type_options), 'severity_id' => $ep_obj->getSeverity(), 'email_notification_id' => $ep_obj->getEmailNotification(), 'demerit' => $ep_obj->getDemerit(), 'grace' => (int) $ep_obj->getGrace(), 'is_enabled_grace' => $ep_obj->isEnabledGrace($ep_obj->getType()), 'watch_window' => (int) $ep_obj->getWatchWindow(), 'is_enabled_watch_window' => $ep_obj->isEnabledWatchWindow($ep_obj->getType()));
}
}
unset($exception_name);
}
//var_dump($type_options, $ep_objs,$exceptions);
/*
$eplf = new ExceptionPolicyListFactory();
$eplf->getByExceptionPolicyControlID( $id );
if ( $eplf->getRecordCount() > 0 ) {
foreach( $eplf as $ep_obj ) {
if ( isset($type_options[$ep_obj->getType()]) ) {
$exceptions[$ep_obj->getType()] = array(
'id' => $ep_obj->getId(),
'active' => $ep_obj->getActive(),
'type_id' => $ep_obj->getType(),
}
$punch_type_options = $plf->getOptions('type');
$plf->getLastPunchByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data);
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
//Get user info
$ulf->getById($p_obj->getColumn('user_id'));
if ($ulf->getRecordCount() > 0) {
$user_obj = $ulf->getCurrent();
/*
{if $permission->Check('punch','view') OR ( $permission->Check('punch','view_child') AND $user.is_child === TRUE ) OR ( $permission->Check('punch','view_own') AND $user.is_owner === TRUE ) }
{assign var="user_id" value=$user.id}
[ <a href="{urlbuilder script="../timesheet/ViewUserTimeSheet.php" values="filter_data[user_id]=$user_id" merge="FALSE"}">{t}View{/t}</a> ]
{/if}
*/
$view_link = $rows[] = array('id' => $user_obj->GetId(), 'first_name' => $user_obj->getFirstName(), 'last_name' => $user_obj->getLastName(), 'employee_number' => $user_obj->getEmployeeNumber(), 'title' => Option::getByKey($user_obj->getTitle(), $title_options), 'province' => $user_obj->getProvince(), 'country' => $user_obj->getCountry(), 'group' => Option::getByKey($user_obj->getGroup(), $group_options), 'default_branch' => Option::getByKey($user_obj->getDefaultBranch(), $branch_options), 'default_department' => Option::getByKey($user_obj->getDefaultDepartment(), $department_options), 'is_owner' => $permission->isOwner($user_obj->getCreatedBy(), $user_obj->getId()), 'is_child' => $permission->isChild($user_obj->getId(), $permission_children_ids), 'punch_id' => $p_obj->getId(), 'time_stamp' => $p_obj->getTimeStamp(), 'actual_time_stamp' => $p_obj->getActualTimeStamp(), 'status_id' => $p_obj->getStatus(), 'status' => Option::getByKey($p_obj->getStatus(), $p_obj->getOptions('status')), 'type_id' => $p_obj->getType(), 'type' => Option::getByKey($p_obj->getType(), $p_obj->getOptions('type')), 'branch_id' => $p_obj->getColumn('branch_id'), 'branch' => Option::getByKey($p_obj->getColumn('branch_id'), $branch_options), 'department_id' => $p_obj->getColumn('department_id'), 'department' => Option::getByKey($p_obj->getColumn('department_id'), $department_options), 'job_id' => $p_obj->getColumn('job_id'), 'job' => Option::getByKey($p_obj->getColumn('job_id'), $job_options), 'job_item_id' => $p_obj->getColumn('job_id'), 'job_item' => Option::getByKey($p_obj->getColumn('job_item_id'), $job_item_options), 'note' => $p_obj->getColumn('note'), 'station_type' => Option::getByKey($p_obj->getColumn('station_type_id'), $station_type_options), 'station_station_id' => $p_obj->getColumn('station_station_id'), 'station_source' => $p_obj->getColumn('station_source'), 'station_description' => Misc::TruncateString($p_obj->getColumn('station_description'), 30));
}
}
}
//print_r($rows);
if (isset($rows)) {
foreach ($rows as $row) {
$tmp_rows[] = $row;
}
//var_dump($tmp_rows);
$rows = Sort::Multisort($tmp_rows, Misc::trimSortPrefix($filter_data['primary_sort']), Misc::trimSortPrefix($filter_data['secondary_sort']), $filter_data['primary_sort_dir'], $filter_data['secondary_sort_dir']);
//Convert units
$tmp_rows = $rows;
unset($rows);
$trimmed_static_columns = array_keys(Misc::trimSortPrefix($static_columns));
foreach ($tmp_rows as $row) {
$pager = new Pager($mclf);
if ($mclf->getRecordCount() > 0) {
$object_name_options = $mclf->getOptions('object_name');
foreach ($mclf as $message) {
//Get user info
$user_id = NULL;
$user_full_name = NULL;
if ($filter_folder_id == 10) {
//Inbox
$user_id = $message->getColumn('from_user_id');
$user_full_name = Misc::getFullName($message->getColumn('from_first_name'), $message->getColumn('from_middle_name'), $message->getColumn('from_last_name'));
} else {
//Sent
$user_id = $message->getColumn('to_user_id');
$user_full_name = Misc::getFullName($message->getColumn('to_first_name'), $message->getColumn('to_middle_name'), $message->getColumn('to_last_name'));
}
$messages[] = array('id' => $message->getId(), 'parent_id' => $message->getParent(), 'object_type_id' => $message->getObjectType(), 'object_type' => Option::getByKey($message->getObjectType(), $object_name_options), 'object_id' => $message->getObject(), 'status_id' => $message->getStatus(), 'subject' => $message->getSubject(), 'body' => $message->getBody(), 'user_id' => $user_id, 'user_full_name' => $user_full_name, 'created_date' => $message->getCreatedDate(), 'created_by' => $message->getCreatedBy(), 'updated_date' => $message->getUpdatedDate(), 'updated_by' => $message->getUpdatedBy(), 'deleted_date' => $message->getDeletedDate(), 'deleted_by' => $message->getDeletedBy());
}
}
$smarty->assign_by_ref('messages', $messages);
$smarty->assign_by_ref('require_ack', $require_ack);
$smarty->assign_by_ref('show_ack_column', $show_ack_column);
$smarty->assign_by_ref('sort_column', $sort_column);
$smarty->assign_by_ref('sort_order', $sort_order);
$smarty->assign_by_ref('paging_data', $pager->getPageVariables());
break;
}
$smarty->assign_by_ref('mf', $mf);
$smarty->assign_by_ref('folder_options', $folder_options);
$smarty->assign_by_ref('filter_folder_id', $filter_folder_id);
$smarty->display('message/UserMessageList.tpl');
if ( $u_obj->getFingerPrint3() != '' ) {
$display_finger_print_3 = 'Yes';
}
$display_finger_print_4 = 'No';
if ( $u_obj->getFingerPrint4() != '' ) {
$display_finger_print_4 = 'Yes';
}
*/
$sin_number = NULL;
if ($permission->Check('user', 'view_sin') == TRUE) {
$sin_number = $u_obj->getSIN();
} else {
$sin_number = $u_obj->getSecureSIN();
}
$row_arr = array('id' => $u_obj->getId(), 'employee_number' => $u_obj->getEmployeeNumber(), 'status' => Option::getByKey($u_obj->getStatus(), $u_obj->getOptions('status')), 'user_name' => $u_obj->getUserName(), 'phone_id' => $u_obj->getPhoneID(), 'ibutton_id' => $u_obj->getIButtonID(), 'first_name' => $u_obj->getFirstName(), 'middle_name' => $u_obj->getMiddleName(), 'last_name' => $u_obj->getLastName(), 'full_name' => $u_obj->getFullName(TRUE), 'title' => Option::getByKey($u_obj->getTitle(), $user_titles), 'group' => Option::getByKey($u_obj->getGroup(), $group_options), 'default_branch' => Option::getByKey($u_obj->getDefaultBranch(), $branch_options), 'default_department' => Option::getByKey($u_obj->getDefaultDepartment(), $department_options), 'permission_control' => Option::getByKey($permission_control_id, $permission_control_options), 'policy_group' => Option::getByKey($policy_group_id, $policy_group_options), 'pay_period_schedule' => Option::getByKey($pay_period_schedule_id, $pay_period_schedule_options), 'sex' => Option::getByKey($u_obj->getSex(), $u_obj->getOptions('sex')), 'address1' => $u_obj->getAddress1(), 'address2' => $u_obj->getAddress2(), 'city' => $u_obj->getCity(), 'province' => $u_obj->getProvince(), 'country' => $u_obj->getCountry(), 'postal_code' => $u_obj->getPostalCode(), 'work_phone' => $u_obj->getWorkPhone(), 'work_phone_ext' => $u_obj->getWorkPhoneExt(), 'home_phone' => $u_obj->getHomePhone(), 'mobile_phone' => $u_obj->getMobilePhone(), 'fax_phone' => $u_obj->getFaxPhone(), 'home_email' => $u_obj->getHomeEmail(), 'work_email' => $u_obj->getWorkEmail(), 'birth_date' => $u_obj->getBirthDate(), 'sin' => $sin_number, 'hire_date' => $u_obj->getHireDate(), 'termination_date' => $u_obj->getTerminationDate(), 'note' => $u_obj->getNote(), 'other_id1' => $u_obj->getColumn('other_id1'), 'other_id2' => $u_obj->getColumn('other_id2'), 'other_id3' => $u_obj->getColumn('other_id3'), 'other_id4' => $u_obj->getColumn('other_id4'), 'other_id5' => $u_obj->getColumn('other_id5'), 'institution' => $u_obj->getColumn('institution'), 'transit' => $u_obj->getColumn('transit'), 'account' => $bf->getSecureAccount($u_obj->getColumn('account')), 'currency' => Option::getByKey($u_obj->getCurrency(), $currency_options), 'wage_type' => $user_wage_data['type'], 'wage' => $user_wage_data['wage'], 'effective_date' => $user_wage_data['effective_date']);
if (isset($user_deduction[$u_obj->getId()])) {
$row_arr = Misc::prependArray($row_arr, $user_deduction[$u_obj->getId()]);
}
if (isset($user_pref_data)) {
$row_arr = Misc::prependArray($row_arr, $user_pref_data);
}
$tmp_rows[] = $row_arr;
unset($user_pref_data);
}
$tmp_rows = Sort::Multisort($tmp_rows, Misc::trimSortPrefix($filter_data['primary_sort']), Misc::trimSortPrefix($filter_data['secondary_sort']), $filter_data['primary_sort_dir'], $filter_data['secondary_sort_dir']);
} else {
//No Users!
}
if (isset($tmp_rows)) {
foreach ($tmp_rows as $tmp_row) {
$filter_data['pay_period_ids'][] = Misc::trimSortPrefix($filter_pay_period_id);
}
unset($key, $tmp_filter_pay_period_ids, $filter_pay_period_id);
}
$ulf = TTnew('UserListFactory');
$llf = TTnew('LogListFactory');
$log_action_options = $llf->getOptions('action');
$log_table_name_options = $llf->getOptions('table_name');
//5000 row limit.
$llf->getSearchByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data, 5000);
if ($llf->getRecordCount() > 0) {
$x = 0;
foreach ($llf as $l_obj) {
$user_obj = $ulf->getById($l_obj->getUser())->getCurrent();
$tmp_action = Option::getByKey($l_obj->getAction(), $log_action_options);
$table_name = Option::getByKey($l_obj->getTableName(), $log_table_name_options);
if ($tmp_action != '' and $table_name != '') {
$link = $l_obj->getLink();
if ($link !== FALSE) {
$function = '<a href="' . $link . '" target="_blank">View</a>';
} else {
$function = NULL;
}
$rows[$x] = array('user_id' => $l_obj->getUser(), 'full_name' => $user_obj->getFullName(), 'action_id' => $l_obj->getAction(), 'action' => $tmp_action, 'table_name_id' => $l_obj->getTableName(), 'table_name' => $table_name, 'date' => TTDate::getDate('DATE+TIME', $l_obj->getDate()), 'description' => $l_obj->getDescription(), 'function' => $function);
} else {
Debug::Text('Skipping Action: ' . $l_obj->getAction() . ' or Table Name: ' . $l_obj->getTableName(), __FILE__, __LINE__, __METHOD__, 10);
}
unset($tmp_action);
$x++;
}
}
function getObjectAsArray($include_columns = NULL)
{
$variable_function_map = $this->getVariableToFunctionMap();
if (is_array($variable_function_map)) {
foreach ($variable_function_map as $variable => $function_stub) {
if ($include_columns == NULL or isset($include_columns[$variable]) and $include_columns[$variable] == TRUE) {
$function = 'get' . $function_stub;
switch ($variable) {
case 'type':
$function = 'get' . str_replace('_', '', $variable);
if (method_exists($this, $function)) {
$data[$variable] = Option::getByKey($this->{$function}(), $this->getOptions($variable));
}
break;
default:
if (method_exists($this, $function)) {
$data[$variable] = $this->{$function}();
}
break;
}
}
}
$this->getCreatedAndUpdatedColumns(&$data, $include_columns);
}
return $data;
}
foreach ($clf as $c_obj) {
$c_obj->setDeleted($delete);
if ($c_obj->isValid()) {
$c_obj->Save();
}
}
}
}
Redirect::Page(URLBuilder::getURL(NULL, 'CurrencyList.php'));
break;
default:
BreadCrumb::setCrumb($title);
$clf = new CurrencyListFactory();
$clf->getByCompanyId($current_company->getId(), $current_user_prefs->getItemsPerPage(), $page, NULL, $sort_array);
$pager = new Pager($clf);
$iso_code_options = $clf->getISOCodesArray();
$base_currency = FALSE;
foreach ($clf as $c_obj) {
if ($c_obj->getBase() === TRUE) {
$base_currency = TRUE;
}
$rows[] = array('id' => $c_obj->GetId(), 'status_id' => $c_obj->getStatus(), 'name' => $c_obj->getName(), 'iso_code' => $c_obj->getISOCode(), 'currency_name' => Option::getByKey($c_obj->getISOCode(), $iso_code_options), 'conversion_rate' => $c_obj->getConversionRate(), 'auto_update' => $c_obj->getAutoUpdate(), 'is_base' => $c_obj->getBase(), 'is_default' => $c_obj->getDefault(), 'deleted' => $c_obj->getDeleted());
}
$smarty->assign_by_ref('currencies', $rows);
$smarty->assign_by_ref('base_currency', $base_currency);
$smarty->assign_by_ref('sort_column', $sort_column);
$smarty->assign_by_ref('sort_order', $sort_order);
$smarty->assign_by_ref('paging_data', $pager->getPageVariables());
break;
}
$smarty->display('currency/CurrencyList.tpl');
$pdf->Cell(10, 6, $filter_data['year'], $border, 0, 'R');
$pdf->setXY(122, 47);
$pdf->Cell(45, 6, $current_company->getBusinessNumber(), $border, 0, 'R');
$pdf->setXY(40, 56);
$pdf->Cell(75, 6, $current_company->getAddress1() . ' ' . $current_company->getAddress2(), $border, 0, 'L');
$pdf->setXY(122, 56);
$pdf->Cell(45, 6, $current_company->getCity() . ', ' . $current_company->getProvince() . ' ' . $current_company->getPostalCode(), $border, 0, 'R');
if (isset($lines_arr)) {
//Line A
$pdf->setXY(173, 69);
$pdf->Cell(25, 6, Misc::getBeforeDecimal(Misc::MoneyFormat('0.00', FALSE)), $border, 0, 'R');
$pdf->setXY(198, 69);
$pdf->Cell(6, 6, Misc::getAfterDecimal(Misc::MoneyFormat('0.00', FALSE)), $border, 0, 'L');
//State
$pdf->setXY(174, 73);
$pdf->Cell(30, 6, Option::getByKey($setup_data['state_id'], $state_options), $border, 0, 'R');
//State Reporting Number
$pdf->setXY(174, 77);
$pdf->Cell(30, 6, $setup_data['state_report_number'], $border, 0, 'R');
//Part1
//Line1
$pdf->setXY(173, 94);
$pdf->Cell(25, 6, Misc::getBeforeDecimal(Misc::MoneyFormat($lines_arr['total']['p1_1'], FALSE)), $border, 0, 'R');
$pdf->setXY(198, 94);
$pdf->Cell(6, 6, Misc::getAfterDecimal(Misc::MoneyFormat($lines_arr['total']['p1_1'], FALSE)), $border, 0, 'L');
//Line2
$pdf->setXY(135, 106);
$pdf->Cell(25, 6, Misc::getBeforeDecimal(Misc::MoneyFormat($lines_arr['total']['p1_2'], FALSE)), $border, 0, 'R');
$pdf->setXY(160, 106);
$pdf->Cell(6, 6, Misc::getAfterDecimal(Misc::MoneyFormat($lines_arr['total']['p1_2'], FALSE)), $border, 0, 'L');
//Line3
//Get Permission Hierarchy Children first, as this can be used for viewing, or editing.
$hlf = new HierarchyListFactory();
$permission_children_ids = $hlf->getHierarchyChildrenByCompanyIdAndUserIdAndObjectTypeID($current_company->getId(), $current_user->getId());
$udlf = new UserDeductionListFactory();
$udlf->getByCompanyIdAndUserId($current_company->getId(), $user_id);
$pager = new Pager($udlf);
$ulf->getByIdAndCompanyId($user_id, $current_company->getId());
if ($ulf->getRecordCount() > 0) {
$user_obj = $ulf->getCurrent();
if (is_object($user_obj)) {
$is_owner = $permission->isOwner($user_obj->getCreatedBy(), $user_obj->getID());
$is_child = $permission->isChild($user_obj->getId(), $permission_children_ids);
if ($permission->Check('user_tax_deduction', 'view') or $permission->Check('user_tax_deduction', 'view_own') and $is_owner === TRUE or $permission->Check('user_tax_deduction', 'view_child') and $is_child === TRUE) {
foreach ($udlf as $ud_obj) {
$cd_obj = $ud_obj->getCompanyDeductionObject();
$rows[] = array('id' => $ud_obj->getId(), 'status_id' => $cd_obj->getStatus(), 'user_id' => $ud_obj->getUser(), 'name' => $cd_obj->getName(), 'type_id' => $cd_obj->getType(), 'type' => Option::getByKey($cd_obj->getType(), $cd_obj->getOptions('type')), 'calculation' => Option::getByKey($cd_obj->getCalculation(), $cd_obj->getOptions('calculation')), 'is_owner' => $is_owner, 'is_child' => $is_child, 'deleted' => $ud_obj->getDeleted());
}
}
}
}
$smarty->assign_by_ref('rows', $rows);
$smarty->assign_by_ref('user_id', $user_id);
$ulf = new UserListFactory();
$filter_data = NULL;
extract(UserGenericDataFactory::getSearchFormData($saved_search_id, NULL));
if ($permission->Check('user_tax_deduction', 'view') == FALSE) {
if ($permission->Check('user_tax_deduction', 'view_child')) {
$filter_data['permission_children_ids'] = $permission_children_ids;
}
if ($permission->Check('user_tax_deduction', 'view_own')) {
$filter_data['permission_children_ids'][] = $current_user->getId();
$hf = new HelpFactory();
switch ($action) {
case 'submit':
Debug::Text('Submit!', __FILE__, __LINE__, __METHOD__, 10);
default:
//Trim path off script name
$split_script = explode('/', $script);
$script = $split_script[count($split_script) - 1];
$hlf = new HelpListFactory();
//$hlf->getByScriptNameAndGroupName($script, NULL);
$hlf->getByScriptNameAndStatus($script, 'ACTIVE');
//$hlf->getById($id);
$i = 0;
foreach ($hlf as $help_obj) {
//Debug::Arr($station,'Department', __FILE__, __LINE__, __METHOD__,10);
if ($i > 0 and $prev_type != $help_obj->getType()) {
$type_change = TRUE;
} else {
$type_change = FALSE;
}
$help_entries[] = array('id' => $help_obj->GetId(), 'type_id' => $help_obj->getType(), 'type' => Option::getByKey($help_obj->getType(), $help_obj->getOptions('type')), 'type_change' => $type_change, 'status_id' => $help_obj->getStatus(), 'status' => Option::getByKey($help_obj->getStatus(), $help_obj->getOptions('status')), 'heading' => $help_obj->getHeading(), 'body' => $help_obj->getBody(), 'keywords' => $help_obj->getKeywords(), 'private' => $help_obj->getPrivate(), 'created_date' => $help_obj->getCreatedDate(), 'created_by' => $help_obj->getCreatedBy(), 'updated_date' => $help_obj->getUpdatedDate(), 'updated_by' => $help_obj->getUpdatedBy(), 'deleted_date' => $help_obj->getDeletedDate(), 'deleted_by' => $help_obj->getDeletedBy(), 'deleted' => $help_obj->getDeleted());
$prev_type = $help_obj->getType();
$i++;
}
$smarty->assign_by_ref('help_entries', $help_entries);
$smarty->assign_by_ref('title', $title);
$smarty->assign_by_ref('SCRIPT_BASE_NAME', $script);
break;
}
$smarty->assign_by_ref('hf', $hf);
$smarty->display('help/WindowViewHelp.tpl');
function _getData($format = NULL)
{
$this->tmp_data = array('user' => array(), 'exception' => array());
$columns = $this->getColumnDataConfig();
$filter_data = $this->getFilterConfig();
if ($this->getPermissionObject()->Check('punch', 'view') == FALSE) {
$hlf = TTnew('HierarchyListFactory');
$permission_children_ids = $wage_permission_children_ids = $hlf->getHierarchyChildrenByCompanyIdAndUserIdAndObjectTypeID($this->getUserObject()->getCompany(), $this->getUserObject()->getID());
Debug::Arr($permission_children_ids, 'Permission Children Ids:', __FILE__, __LINE__, __METHOD__, 10);
} else {
//Get Permission Hierarchy Children first, as this can be used for viewing, or editing.
$permission_children_ids = array();
$wage_permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('punch', 'view') == FALSE) {
if ($this->getPermissionObject()->Check('user', 'view_child') == FALSE) {
$permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('punch', 'view_own')) {
$permission_children_ids[] = $this->getUserObject()->getID();
}
$filter_data['permission_children_ids'] = $permission_children_ids;
}
//Get user data for joining.
$ulf = TTnew('UserListFactory');
$ulf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Rows: ' . $ulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $ulf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($ulf as $key => $u_obj) {
$this->tmp_data['user'][$u_obj->getId()] = (array) $u_obj->getObjectAsArray($columns);
$this->tmp_data['user'][$u_obj->getId()]['user_status'] = Option::getByKey($u_obj->getStatus(), $u_obj->getOptions('status'));
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Debug::Arr($this->tmp_data['user'], 'TMP User Data: ', __FILE__, __LINE__, __METHOD__,10);
$columns['pay_period_start_date'] = $columns['pay_period_end_date'] = $columns['pay_period_transaction_date'] = TRUE;
//Get Exception data for joining .
$elf = TTnew('ExceptionListFactory');
$elf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' Exception Rows: ' . $elf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $elf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($elf as $key => $e_obj) {
$user_id = $e_obj->getColumn('user_id');
$this->tmp_data['exception'][$user_id][$e_obj->getID()] = (array) $e_obj->getObjectAsArray(array_merge(array('date_stamp' => TRUE), $columns));
$this->tmp_data['exception'][$user_id][$e_obj->getID()]['total_exception'] = 1;
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Debug::Arr($this->tmp_data['exception'], 'TMP Exception Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
function getObjectAsArray($include_columns = NULL)
{
$variable_function_map = $this->getVariableToFunctionMap();
if (is_array($variable_function_map)) {
foreach ($variable_function_map as $variable => $function_stub) {
if ($include_columns == NULL or isset($include_columns[$variable]) and $include_columns[$variable] == TRUE) {
$function = 'get' . $function_stub;
switch ($variable) {
case 'first_name':
case 'last_name':
$data[$variable] = $this->getColumn($variable);
break;
case 'code':
$function = 'get' . $variable;
if (method_exists($this, $function)) {
$data[$variable] = Option::getByKey($this->{$function}(), $this->getOptions($variable));
}
break;
case 'pay_period_type':
$ppsf = TTnew('PayPeriodScheduleFactory');
$data[$variable] = Option::getByKey($this->getPayPeriodType(), $ppsf->getOptions('type'));
break;
case 'first_date':
$data[$variable] = TTDate::getAPIDate('DATE', $this->getFirstDate());
break;
case 'last_date':
$data[$variable] = TTDate::getAPIDate('DATE', $this->getLastDate());
break;
case 'pay_period_end_date':
$data[$variable] = TTDate::getAPIDate('DATE', $this->getPayPeriodEndDate());
break;
case 'recall_date':
$data[$variable] = TTDate::getAPIDate('DATE', $this->getRecallDate());
break;
case 'insurable_earnings':
$data[$variable] = $this->getInsurableEarnings();
break;
case 'vacation_pay':
$data[$variable] = $this->getVacationPay();
break;
default:
if (method_exists($this, $function)) {
$data[$variable] = $this->{$function}();
}
break;
}
}
}
$this->getCreatedAndUpdatedColumns($data, $include_columns);
}
return $data;
}
}
$rows[$x]['job_manual_id'] = $data_c['job_manual_id'];
$rows[$x]['job_status'] = Option::getByKey($data_c['job_status_id'], $job_status_options, NULL);
$rows[$x]['job_branch'] = Option::getByKey($data_c['job_branch_id'], $branch_options, NULL);
$rows[$x]['job_department'] = Option::getByKey($data_c['job_department_id'], $department_options, NULL);
$rows[$x]['job_group'] = Option::getByKey($data_c['job_group_id'], $job_group_options, NULL);
if (isset($job_item_options[$data_c['job_item_id']])) {
$rows[$x]['job_item'] = $job_item_options[$data_c['job_item_id']];
} else {
$rows[$x]['job_item'] = TTi18n::gettext('- No Task -');
}
$rows[$x]['type'] = Option::getByKey($data_c['type_id'], $schedule_type_options, NULL);
$rows[$x]['status'] = Option::getByKey($data_c['status_id'], $schedule_status_options, NULL);
$rows[$x]['start_time'] = $data_c['start_time'];
$rows[$x]['end_time'] = $data_c['end_time'];
$rows[$x]['absence_policy'] = Option::getByKey($data_c['absence_policy_id'], $absence_policy_options, NULL);
$rows[$x]['hourly_rate'] = $data_c['hourly_rate'];
$rows[$x]['total_time'] = $data_c['total_time'];
$rows[$x]['total_time_wage'] = $data_c['total_time_wage'];
$x++;
}
}
}
}
//var_dump($rows);
unset($tmp_rows);
if (isset($rows) and isset($filter_data['primary_group_by']) and $filter_data['primary_group_by'] != '0') {
Debug::Text('Primary Grouping Data By: ' . $filter_data['primary_group_by'], __FILE__, __LINE__, __METHOD__, 10);
$ignore_elements = array_keys($static_columns);
$filter_data['column_ids'] = array_diff($filter_data['column_ids'], $ignore_elements);
//Add the group by element back in
function _getData($format = NULL)
{
$this->tmp_data = array('user' => array(), 'user_preference' => array(), 'user_wage' => array(), 'user_bank' => array(), 'user_deduction' => array(), 'total_user' => array());
$columns = $this->getColumnDataConfig();
$filter_data = $this->getFilterConfig();
$currency_convert_to_base = $this->getCurrencyConvertToBase();
$base_currency_obj = $this->getBaseCurrencyObject();
$this->handleReportCurrency($currency_convert_to_base, $base_currency_obj, $filter_data);
$currency_options = $this->getOptions('currency');
if ($this->getPermissionObject()->Check('user', 'view') == FALSE or $this->getPermissionObject()->Check('wage', 'view') == FALSE) {
$hlf = TTnew('HierarchyListFactory');
$permission_children_ids = $wage_permission_children_ids = $hlf->getHierarchyChildrenByCompanyIdAndUserIdAndObjectTypeID($this->getUserObject()->getCompany(), $this->getUserObject()->getID());
Debug::Arr($permission_children_ids, 'Permission Children Ids:', __FILE__, __LINE__, __METHOD__, 10);
} else {
//Get Permission Hierarchy Children first, as this can be used for viewing, or editing.
$permission_children_ids = array();
$wage_permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('user', 'view') == FALSE) {
if ($this->getPermissionObject()->Check('user', 'view_child') == FALSE) {
$permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('user', 'view_own')) {
$permission_children_ids[] = $this->getUserObject()->getID();
}
$filter_data['permission_children_ids'] = $permission_children_ids;
}
//Get Wage Permission Hierarchy Children first, as this can be used for viewing, or editing.
if ($this->getPermissionObject()->Check('wage', 'view') == TRUE) {
$wage_permission_children_ids = TRUE;
} elseif ($this->getPermissionObject()->Check('wage', 'view') == FALSE) {
if ($this->getPermissionObject()->Check('wage', 'view_child') == FALSE) {
$wage_permission_children_ids = array();
}
if ($this->getPermissionObject()->Check('wage', 'view_own')) {
$wage_permission_children_ids[] = $this->getUserObject()->getID();
}
}
//Debug::Text(' Permission Children: '. count($permission_children_ids) .' Wage Children: '. count($wage_permission_children_ids), __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($permission_children_ids, 'Permission Children: '. count($permission_children_ids), __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($wage_permission_children_ids, 'Wage Children: '. count($wage_permission_children_ids), __FILE__, __LINE__, __METHOD__,10);
//Always include date columns, because 'hire-date_stamp' is not recognized by the UserFactory. This greatly slows down the report though.
$columns['effective_date'] = $columns['hire_date'] = $columns['termination_date'] = $columns['birth_date'] = $columns['created_date'] = $columns['updated_date'] = TRUE;
//Get user data for joining.
$ulf = TTnew('UserListFactory');
$ulf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Rows: ' . $ulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $ulf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($ulf as $key => $u_obj) {
//We used to just get return the entire $u_obj->data array, but this wouldn't include tags and other columns that required some additional processing.
//Not sure why this was done that way... I think because we had problems with the multiple date fields (Hire Date/Termination Date/Birth Date, etc...)
$this->tmp_data['user'][$u_obj->getId()] = (array) $u_obj->getObjectAsArray($columns);
if ($currency_convert_to_base == TRUE and is_object($base_currency_obj)) {
$this->tmp_data['user'][$u_obj->getId()]['currency_rate'] = $u_obj->getColumn('currency_rate');
}
$this->tmp_data['user'][$u_obj->getId()]['employee_number'] = isset($columns['employee_number']) ? $this->tmp_data['user'][$u_obj->getId()]['employee_number'] : $u_obj->getEmployeeNumber();
if (isset($columns['employee_number_barcode'])) {
$this->tmp_data['user'][$u_obj->getId()]['employee_number_barcode'] = new ReportCellBarcode($this, 'U' . $this->tmp_data['user'][$u_obj->getId()]['employee_number']);
}
if (isset($columns['employee_number_qrcode'])) {
$this->tmp_data['user'][$u_obj->getId()]['employee_number_qrcode'] = new ReportCellQRcode($this, 'U' . $this->tmp_data['user'][$u_obj->getId()]['employee_number']);
}
$this->tmp_data['user_preference'][$u_obj->getId()] = array();
$this->tmp_data['user_wage'][$u_obj->getId()] = array();
$this->tmp_data['user'][$u_obj->getId()]['total_user'] = 1;
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Debug::Arr($this->tmp_data['user'], 'TMP User Data: ', __FILE__, __LINE__, __METHOD__,10);
//Get user preference data for joining.
$uplf = TTnew('UserPreferenceListFactory');
$uplf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Preference Rows: ' . $ulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $uplf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($uplf as $key => $up_obj) {
$this->tmp_data['user_preference'][$up_obj->getUser()] = (array) $up_obj->getObjectAsArray($columns);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Get user wage data for joining.
$filter_data['wage_group_id'] = 0;
//Use default wage groups only.
$uwlf = TTnew('UserWageListFactory');
$uwlf->getAPILastWageSearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Wage Rows: ' . $uwlf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $ulf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($uwlf as $key => $uw_obj) {
if ($wage_permission_children_ids === TRUE or in_array($uw_obj->getUser(), $wage_permission_children_ids)) {
$this->tmp_data['user_wage'][$uw_obj->getUser()] = (array) $uw_obj->getObjectAsArray($columns);
if ($currency_convert_to_base == TRUE and is_object($base_currency_obj)) {
$this->tmp_data['user_wage'][$uw_obj->getUser()]['current_currency'] = Option::getByKey($base_currency_obj->getId(), $currency_options);
if (isset($this->tmp_data['user'][$uw_obj->getUser()]['currency_rate'])) {
$this->tmp_data['user_wage'][$uw_obj->getUser()]['hourly_rate'] = $base_currency_obj->getBaseCurrencyAmount($uw_obj->getHourlyRate(), $this->tmp_data['user'][$uw_obj->getUser()]['currency_rate'], $currency_convert_to_base);
$this->tmp_data['user_wage'][$uw_obj->getUser()]['wage'] = $base_currency_obj->getBaseCurrencyAmount($uw_obj->getWage(), $this->tmp_data['user'][$uw_obj->getUser()]['currency_rate'], $currency_convert_to_base);
}
}
$this->tmp_data['user_wage'][$uw_obj->getUser()]['effective_date'] = isset($this->tmp_data['user_wage'][$uw_obj->getUser()]['effective_date']) ? TTDate::parseDateTime($this->tmp_data['user_wage'][$uw_obj->getUser()]['effective_date']) : NULL;
}
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Get user bank data for joining.
$balf = TTnew('BankAccountListFactory');
$balf->getAPISearchByCompanyIdAndArrayCriteria($this->getUserObject()->getCompany(), $filter_data);
Debug::Text(' User Bank Rows: ' . $balf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
$this->getProgressBarObject()->start($this->getAMFMessageID(), $balf->getRecordCount(), NULL, TTi18n::getText('Retrieving Data...'));
foreach ($balf as $key => $ba_obj) {
$this->tmp_data['user_bank'][$ba_obj->getUser()] = (array) $ba_obj->getObjectAsArray($columns);
$this->getProgressBarObject()->set($this->getAMFMessageID(), $key);
}
//Debug::Arr($this->tmp_data['user_preference'], 'TMP Data: ', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
}
AccrualBalanceFactory::calcBalance($user_id, $accrual_policy_id);
}
$alf->CommitTransaction();
Redirect::Page(URLBuilder::getURL(NULL, 'ViewUserAccrualList.php'));
break;
default:
$alf = TTnew('AccrualListFactory');
$alf->getByCompanyIdAndUserIdAndAccrualPolicyID($current_company->getId(), $user_id, $accrual_policy_id, $current_user_prefs->getItemsPerPage(), $page, NULL, $sort_array);
$pager = new Pager($alf);
foreach ($alf as $a_obj) {
$date_stamp = $a_obj->getColumn('date_stamp');
if ($date_stamp != '') {
$date_stamp = TTDate::strtotime($date_stamp);
}
$accruals[] = array('id' => $a_obj->getId(), 'user_id' => $a_obj->getUser(), 'accrual_policy_id' => $a_obj->getAccrualPolicyId(), 'type_id' => $a_obj->getType(), 'type' => Option::getByKey($a_obj->getType(), $a_obj->getOptions('type')), 'user_date_total_id' => $a_obj->getUserDateTotalId(), 'user_date_total_date_stamp' => $date_stamp, 'time_stamp' => $a_obj->getTimeStamp(), 'amount' => $a_obj->getAmount(), 'system_type' => $a_obj->isSystemType(), 'deleted' => $a_obj->getDeleted());
}
$smarty->assign_by_ref('accruals', $accruals);
$ulf = TTnew('UserListFactory');
$user_obj = $ulf->getById($user_id)->getCurrent();
$aplf = TTnew('AccrualPolicyListFactory');
$accrual_policy_obj = $aplf->getById($accrual_policy_id)->getCurrent();
$smarty->assign_by_ref('user_id', $user_id);
$smarty->assign_by_ref('user_full_name', $user_obj->getFullName());
$smarty->assign_by_ref('accrual_policy_id', $accrual_policy_id);
$smarty->assign_by_ref('accrual_policy', $accrual_policy_obj->getName());
$smarty->assign_by_ref('sort_column', $sort_column);
$smarty->assign_by_ref('sort_order', $sort_order);
$smarty->assign_by_ref('paging_data', $pager->getPageVariables());
break;
}
