$udtlf = new UserDateTotalListFactory();
$udtlf->getById($id);
foreach ($udtlf as $udt_obj) {
//Debug::Arr($station,'Department', __FILE__, __LINE__, __METHOD__,10);
$udt_data = array('id' => $udt_obj->getId(), 'user_date_id' => $udt_obj->getUserDateId(), 'date_stamp' => $udt_obj->getUserDateObject()->getDateStamp(), 'user_id' => $udt_obj->getUserDateObject()->getUser(), 'user_full_name' => $udt_obj->getUserDateObject()->getUserObject()->getFullName(), 'status_id' => $udt_obj->getStatus(), 'type_id' => $udt_obj->getType(), 'total_time' => $udt_obj->getTotalTime(), 'absence_policy_id' => $udt_obj->getAbsencePolicyID(), 'branch_id' => $udt_obj->getBranch(), 'department_id' => $udt_obj->getDepartment(), 'override' => $udt_obj->getOverride(), 'created_date' => $udt_obj->getCreatedDate(), 'created_by' => $udt_obj->getCreatedBy(), 'updated_date' => $udt_obj->getUpdatedDate(), 'updated_by' => $udt_obj->getUpdatedBy(), 'deleted_date' => $udt_obj->getDeletedDate(), 'deleted_by' => $udt_obj->getDeletedBy());
}
} elseif ($action != 'submit') {
Debug::Text(' ID was NOT passed: ' . $id, __FILE__, __LINE__, __METHOD__, 10);
//Get user full name
$ulf = new UserListFactory();
$user_obj = $ulf->getById($user_id)->getCurrent();
$user_date_id = UserDateFactory::getUserDateID($user_id, $date_stamp);
$udt_data = array('user_id' => $user_id, 'date_stamp' => $date_stamp, 'user_date_id' => $user_date_id, 'user_full_name' => $user_obj->getFullName(), 'branch_id' => $user_obj->getDefaultBranch(), 'department_id' => $user_obj->getDefaultDepartment(), 'total_time' => 0, 'override' => TRUE);
}
$aplf = new AbsencePolicyListFactory();
$absence_policy_options = Misc::prependArray(array(0 => TTi18n::gettext('-- Please Choose --')), $aplf->getByCompanyIdArray($current_company->getId()));
$blf = new BranchListFactory();
$branch_options = $blf->getByCompanyIdArray($current_company->getId());
$dlf = new DepartmentListFactory();
$department_options = $dlf->getByCompanyIdArray($current_company->getId());
//Select box options;
//$udt_data['status_options'] = $udtf->getOptions('status');
//$udt_data['type_options'] = $udtf->getOptions('type');
$udt_data['absence_policy_options'] = $absence_policy_options;
$udt_data['branch_options'] = $branch_options;
$udt_data['department_options'] = $department_options;
$smarty->assign_by_ref('udt_data', $udt_data);
break;
}
$smarty->assign_by_ref('udtf', $udtf);
$smarty->display('punch/EditUserAbsence.tpl');
$pay_period_is_locked = FALSE;
$time_stamp = $start_date_stamp = $end_date_stamp = TTDate::getBeginDayEpoch(TTDate::getTime()) + 3600 * 12;
//Noon
$data = array('start_date_stamp' => $start_date_stamp, 'end_date_stamp' => $end_date_stamp, 'start_time' => strtotime('08:00 AM'), 'parsed_start_time' => strtotime('08:00 AM'), 'end_time' => strtotime('05:00 PM'), 'parsed_end_time' => strtotime('05:00 PM'), 'total_time' => 3600 * 9, 'branch_id' => $user_default_branch, 'department_id' => $user_default_department, 'dow' => array(1 => TRUE, 2 => TRUE, 3 => TRUE, 4 => TRUE, 5 => TRUE));
}
//var_dump($data);
$ulf = new UserListFactory();
$ulf->getSearchByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data);
$src_user_options = UserListFactory::getArrayByListFactory($ulf, FALSE, FALSE);
$user_options = Misc::arrayDiffByKey((array) $filter_user_id, $src_user_options);
$filter_user_options = Misc::arrayIntersectByKey((array) $filter_user_id, $src_user_options);
$prepend_array_option = array(0 => '--', -1 => TTi18n::gettext('-- Default --'));
$splf = new SchedulePolicyListFactory();
$schedule_policy_options = $splf->getByCompanyIdArray($current_company->getId());
$aplf = new AbsencePolicyListFactory();
$absence_policy_options = $aplf->getByCompanyIdArray($current_company->getId());
$blf = new BranchListFactory();
$blf->getByCompanyId($current_company->getId());
$branch_options = Misc::prependArray($prepend_array_option, $blf->getArrayByListFactory($blf, FALSE, TRUE));
$dlf = new DepartmentListFactory();
$dlf->getByCompanyId($current_company->getId());
$department_options = Misc::prependArray($prepend_array_option, $dlf->getArrayByListFactory($dlf, FALSE, TRUE));
if ($current_company->getProductEdition() == 20) {
$jlf = new JobListFactory();
$jlf->getByStatusIdAndCompanyId(array(10, 20, 30, 40), $current_company->getId());
//$jlf->getByCompanyIdAndUserIdAndStatus( $current_company->getId(), $data['user_id'], array(10,20,30,40) );
$data['job_options'] = $jlf->getArrayByListFactory($jlf, TRUE, TRUE);
$data['job_manual_id_options'] = $jlf->getManualIDArrayByListFactory($jlf, TRUE);
$jilf = new JobItemListFactory();
$jilf->getByCompanyId($current_company->getId());
$data['job_item_options'] = $jilf->getArrayByListFactory($jilf, TRUE);
$uwlf->getByUserIdAndCompanyIdAndStartDateAndEndDate($filter_data['user_ids'], $current_company->getId(), $filter_data['start_date'], $filter_data['end_date']);
if ($uwlf->getRecordCount() > 0) {
foreach ($uwlf as $uw_obj) {
$user_wage_rows[$uw_obj->getUser()][] = array('type_id' => $uw_obj->getType(), 'type' => Option::getByKey($uw_obj->getType(), $uw_obj->getOptions('type')), 'wage' => $uw_obj->getWage(), 'currency_symbol' => $uw_obj->getUserObject()->getCurrencyObject()->getSymbol(), 'effective_date' => $uw_obj->getEffectiveDate(), 'effective_date_since' => TTDate::getHumanTimeSince($uw_obj->getEffectiveDate()));
}
}
}
/*
Get Attendance History
*/
if (isset($columns['attendance'])) {
//Get policy names.
$oplf = new OverTimePolicyListFactory();
$over_time_policy_arr = $oplf->getByCompanyIdArray($current_company->getId(), FALSE);
$aplf = new AbsencePolicyListFactory();
$absence_policy_arr = $aplf->getByCompanyIdArray($current_company->getId(), FALSE);
$pplf = new PremiumPolicyListFactory();
$premium_policy_arr = $pplf->getByCompanyIdArray($current_company->getId(), FALSE);
//Get stats on number of days worked per month/week
$udlf = new UserDateListFactory();
$udlf->getDaysWorkedByTimePeriodAndUserIdAndCompanyIdAndStartDateAndEndDate('month', $filter_data['user_ids'], $current_company->getId(), $filter_data['start_date'], $filter_data['end_date']);
if ($udlf->getRecordCount() > 0) {
foreach ($udlf as $ud_obj) {
//$user_days_worked[$ud_obj->getUser()]['month']
$user_attendance_rows[$ud_obj->getUser()]['days_worked']['month'] = array('avg' => round($ud_obj->getColumn('avg'), 2), 'min' => $ud_obj->getColumn('min'), 'max' => $ud_obj->getColumn('max'));
}
}
$udlf->getDaysWorkedByTimePeriodAndUserIdAndCompanyIdAndStartDateAndEndDate('week', $filter_data['user_ids'], $current_company->getId(), $filter_data['start_date'], $filter_data['end_date']);
if ($udlf->getRecordCount() > 0) {
foreach ($udlf as $ud_obj) {
$user_attendance_rows[$ud_obj->getUser()]['days_worked']['week'] = array('avg' => round($ud_obj->getColumn('avg'), 2), 'min' => $ud_obj->getColumn('min'), 'max' => $ud_obj->getColumn('max'));
