function setPolicyGroup($id)
{
$id = trim($id);
$pglf = new PolicyGroupListFactory();
if ($this->Validator->isResultSetWithRows('policy_group', $pglf->getByID($id), TTi18n::gettext('Policy Group is invalid'))) {
$this->data['policy_group_id'] = $id;
return TRUE;
}
return FALSE;
}
function isUniqueUser($id)
{
$pglf = new PolicyGroupListFactory();
$ph = array('id' => $id);
$query = 'select a.id from ' . $this->getTable() . ' as a, ' . $pglf->getTable() . ' as b where a.policy_group_id = b.id AND a.user_id = ? AND b.deleted=0';
$user_id = $this->db->GetOne($query, $ph);
Debug::Arr($user_id, 'Unique User ID: ' . $user_id, __FILE__, __LINE__, __METHOD__, 10);
if ($user_id === FALSE) {
return TRUE;
}
return FALSE;
}
$pgf->setHolidayPolicy($data['holiday_policy_ids']);
} else {
$pgf->setHolidayPolicy(array());
}
if ($pgf->isValid()) {
$pgf->Save();
$pgf->CommitTransaction();
Redirect::Page(URLBuilder::getURL(NULL, 'PolicyGroupList.php'));
break;
}
}
$pgf->FailTransaction();
default:
if (isset($id)) {
BreadCrumb::setCrumb($title);
$pglf = new PolicyGroupListFactory();
$pglf->getByIdAndCompanyID($id, $current_company->getID());
foreach ($pglf as $pg_obj) {
//Debug::Arr($station,'Department', __FILE__, __LINE__, __METHOD__,10);
$data = array('id' => $pg_obj->getId(), 'name' => $pg_obj->getName(), 'meal_policy_ids' => $pg_obj->getMealPolicy(), 'break_policy_ids' => $pg_obj->getBreakPolicy(), 'holiday_policy_ids' => $pg_obj->getHolidayPolicy(), 'exception_policy_control_id' => $pg_obj->getExceptionPolicyControlID(), 'user_ids' => $pg_obj->getUser(), 'over_time_policy_ids' => $pg_obj->getOverTimePolicy(), 'premium_policy_ids' => $pg_obj->getPremiumPolicy(), 'round_interval_policy_ids' => $pg_obj->getRoundIntervalPolicy(), 'accrual_policy_ids' => $pg_obj->getAccrualPolicy(), 'created_date' => $pg_obj->getCreatedDate(), 'created_by' => $pg_obj->getCreatedBy(), 'updated_date' => $pg_obj->getUpdatedDate(), 'updated_by' => $pg_obj->getUpdatedBy(), 'deleted_date' => $pg_obj->getDeletedDate(), 'deleted_by' => $pg_obj->getDeletedBy());
}
}
$none_array_option = array('0' => TTi18n::gettext('-- None --'));
$ulf = new UserListFactory();
$user_options = $ulf->getByCompanyIDArray($current_company->getId(), FALSE, TRUE);
$otplf = new OverTimePolicyListFactory();
$over_time_policy_options = Misc::prependArray($none_array_option, $otplf->getByCompanyIDArray($current_company->getId(), FALSE));
$pplf = new PremiumPolicyListFactory();
$premium_policy_options = Misc::prependArray($none_array_option, $pplf->getByCompanyIDArray($current_company->getId(), FALSE));
$riplf = new RoundIntervalPolicyListFactory();
$round_interval_policy_options = Misc::prependArray($none_array_option, $riplf->getByCompanyIDArray($current_company->getId(), FALSE));
break;
case 'delete' or 'undelete':
if (strtolower($action) == 'delete') {
$delete = TRUE;
} else {
$delete = FALSE;
}
$pglf = new PolicyGroupListFactory();
foreach ($ids as $id) {
$pglf->getByIdAndCompanyId($id, $current_company->getId());
foreach ($pglf as $pg_obj) {
$pg_obj->setDeleted($delete);
$pg_obj->Save();
}
}
Redirect::Page(URLBuilder::getURL(NULL, 'PolicyGroupList.php'));
break;
default:
$pglf = new PolicyGroupListFactory();
$pglf->getByCompanyId($current_company->getId());
$pager = new Pager($pglf);
foreach ($pglf as $pg_obj) {
$policies[] = array('id' => $pg_obj->getId(), 'name' => $pg_obj->getName(), 'deleted' => $pg_obj->getDeleted());
}
$smarty->assign_by_ref('policies', $policies);
$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('policy/PolicyGroupList.tpl');
function getByCompanyIdArray($company_id, $include_blank = TRUE)
{
$pglf = new PolicyGroupListFactory();
$pglf->getByCompanyId($company_id);
if ($include_blank == TRUE) {
$list[0] = '--';
}
foreach ($pglf as $pg_obj) {
$list[$pg_obj->getID()] = $pg_obj->getName();
}
if (isset($list)) {
return $list;
}
return FALSE;
}
$dlf = new DepartmentListFactory();
$department_options = $dlf->getByCompanyIdArray($current_company->getId());
$pclf = new PermissionControlListFactory();
$pclf->getByCompanyId($current_company->getId());
$permission_control_options = $pclf->getArrayByListFactory($pclf, TRUE);
$ppslf = new PayPeriodScheduleListFactory();
$pay_period_schedule_options = $ppslf->getByCompanyIDArray($current_company->getId());
$pglf = new PolicyGroupListFactory();
$policy_group_options = $pglf->getByCompanyIDArray($current_company->getId());
$pclf = new PermissionControlListFactory();
$pclf->getByCompanyIdAndUserId($current_company->getId(), $filter_data['user_ids']);
$permission_control_user_map = $pclf->getUserToPermissionControlMapArrayByListFactory($pclf);
$ppslf = new PayPeriodScheduleListFactory();
$ppslf->getByCompanyIdAndUserId($current_company->getId(), $filter_data['user_ids']);
$pay_period_schedule_user_map = $ppslf->getUserToPayPeriodScheduleMapArrayByListFactory($ppslf);
$pglf = new PolicyGroupListFactory();
$pglf->getByCompanyIdAndUserId($current_company->getId(), $filter_data['user_ids']);
$policy_group_user_map = $pglf->getUserToPolicyGroupMapArrayByListFactory($pglf);
$crlf = new CurrencyListFactory();
$crlf->getByCompanyId($current_company->getId());
$currency_options = $crlf->getArrayByListFactory($crlf, FALSE, TRUE);
$upf = new UserPreferenceFactory();
$language_options = TTi18n::getLanguageArray();
$date_format_options = $upf->getOptions('date_format');
$time_format_options = $upf->getOptions('time_format');
$time_unit_format_options = $upf->getOptions('time_unit_format');
$timesheet_view_options = $upf->getOptions('timesheet_view');
$start_week_day_options = $upf->getOptions('start_week_day');
$time_zone_options = $upf->getOptions('time_zone');
$uwlf = new UserWageListFactory();
$uwlf->getLastWageByUserIdAndDate($filter_data['user_ids'], TTDate::getTime());
$user_data['status_options'] = $uf->getOptions('status');
$clf = new CompanyListFactory();
$user_data['country_options'] = $clf->getOptions('country');
$user_data['province_options'] = $clf->getOptions('province', $user_data['country']);
$utlf = new UserTitleListFactory();
$user_titles = $utlf->getByCompanyIdArray($company_id);
$user_data['title_options'] = $user_titles;
//Get Permission Groups
$pclf = new PermissionControlListFactory();
$pclf->getByCompanyId($company_id);
$user_data['permission_control_options'] = $pclf->getArrayByListFactory($pclf, FALSE);
//Get pay period schedules
$ppslf = new PayPeriodScheduleListFactory();
$pay_period_schedules = $ppslf->getByCompanyIDArray($company_id);
$user_data['pay_period_schedule_options'] = $pay_period_schedules;
$pglf = new PolicyGroupListFactory();
$policy_groups = $pglf->getByCompanyIDArray($company_id);
$user_data['policy_group_options'] = $policy_groups;
$uglf = new UserGroupListFactory();
$user_data['group_options'] = $uglf->getArrayByNodes(FastTree::FormatArray($uglf->getByCompanyIdArray($company_id), 'TEXT', TRUE));
//Get other field names
$oflf = new OtherFieldListFactory();
$user_data['other_field_names'] = $oflf->getByCompanyIdAndTypeIdArray($company_id, 10);
$user_data['hierarchy_object_type_options'] = $hierarchy_object_type_options;
$user_data['hierarchy_control_options'] = $hierarchy_control_options;
//Company list.
if ($permission->Check('company', 'view')) {
$user_data['company_options'] = CompanyListFactory::getAllArray();
} else {
$user_data['company_options'] = array($company_id => $current_company->getName());
}
$user_data['currency_options'] = $currency_options;
$cf = new CompanyFactory();
$user_data['country_options'] = $cf->getOptions('country');
$user_data['province_options'] = $cf->getOptions('province', $user_data['country']);
$utlf = new UserTitleListFactory();
$user_titles = $utlf->getByCompanyIdArray($current_company->getId());
$user_data['title_options'] = $user_titles;
//Get Permission Groups
$pclf = new PermissionControlListFactory();
$pclf->getByCompanyId($current_company->getId());
$user_data['permission_control_options'] = $pclf->getArrayByListFactory($pclf, FALSE);
//Get pay period schedules
$ppslf = new PayPeriodScheduleListFactory();
$pay_period_schedules = $ppslf->getByCompanyIDArray($current_company->getId());
$user_data['pay_period_schedule_options'] = $pay_period_schedules;
$pglf = new PolicyGroupListFactory();
$policy_groups = $pglf->getByCompanyIDArray($current_company->getId());
$user_data['policy_group_options'] = $policy_groups;
$user_data['company'] = $current_company->getName();
$user_data['language_options'] = TTi18n::getLanguageArray();
$user_data['date_format_options'] = $upf->getOptions('date_format');
$user_data['other_date_format_options'] = $upf->getOptions('other_date_format');
$user_data['time_format_options'] = $upf->getOptions('time_format');
$user_data['time_unit_format_options'] = $upf->getOptions('time_unit_format');
$user_data['timesheet_view_options'] = $upf->getOptions('timesheet_view');
$user_data['start_week_day_options'] = $upf->getOptions('start_week_day');
$timezone_options = Misc::prependArray(array(-1 => '---'), $upf->getOptions('time_zone'));
$user_data['time_zone_options'] = $timezone_options;
//Get all Company Deductions for drop down box.
$cdlf = new CompanyDeductionListFactory();
$user_data['company_deduction_options'] = $cdlf->getByCompanyIdAndStatusIdArray($current_company->getId(), 10, FALSE);
function addAccrualPolicyTime($epoch = NULL, $offset = 79200, $daily_total_time = NULL)
{
//22hr offset
if ($epoch == '') {
$epoch = TTDate::getTime();
}
Debug::Text('Accrual Policy ID: ' . $this->getId() . ' Current EPOCH: ' . TTDate::getDate('DATE+TIME', $epoch), __FILE__, __LINE__, __METHOD__, 10);
$pglf = new PolicyGroupListFactory();
$pglf->StartTransaction();
$pglf->getSearchByCompanyIdAndArrayCriteria($this->getCompany(), array('accrual_policy_id' => array($this->getId())));
if ($pglf->getRecordCount() > 0) {
Debug::Text('Found Policy Group...', __FILE__, __LINE__, __METHOD__, 10);
foreach ($pglf as $pg_obj) {
//Get all users assigned to this policy group.
$policy_group_users = $pg_obj->getUser();
if (is_array($policy_group_users) and count($policy_group_users) > 0) {
Debug::Text('Found Policy Group Users: ' . count($policy_group_users), __FILE__, __LINE__, __METHOD__, 10);
foreach ($policy_group_users as $user_id) {
Debug::Text('Policy Group User ID: ' . $user_id, __FILE__, __LINE__, __METHOD__, 10);
//Get User Object
$ulf = new UserListFactory();
$ulf->getByIDAndCompanyID($user_id, $this->getCompany());
if ($ulf->getRecordCount() == 1) {
$u_obj = $ulf->getCurrent();
Debug::Text('User: '******' Status: ' . $u_obj->getStatus(), __FILE__, __LINE__, __METHOD__, 10);
//Make sure only active employees accrue time. Will this negative affect
//Employees who may be on leave?
if ($u_obj->getStatus() == 10 and ($this->getMinimumEmployedDays() == 0 or TTDate::getDays($epoch - $u_obj->getHireDate()) >= $this->getMinimumEmployedDays())) {
Debug::Text(' User is active and has been employed long enough.', __FILE__, __LINE__, __METHOD__, 10);
$annual_pay_periods = 0;
$in_apply_frequency_window = FALSE;
$accrual_balance = 0;
$accrual_amount = 0;
if ($this->getType() == 30) {
Debug::Text(' Accrual policy is hour based, real-time window.', __FILE__, __LINE__, __METHOD__, 10);
//Hour based, apply frequency is real-time.
$in_apply_frequency_window = TRUE;
} else {
if ($this->getApplyFrequency() == 10) {
//Because of pay period frequencies, and users being assigned to different
//pay period schedules we need to get the last pay period of each user individually.
//This will return the pay period that just ended in the offset time.
$pplf = new PayPeriodListFactory();
$pplf->getByUserIdAndEndDate($user_id, $epoch - $offset);
if ($pplf->getRecordCount() > 0) {
foreach ($pplf as $pp_obj) {
Debug::Text(' Pay Period End Date: ' . TTDate::getDate('DATE+TIME', $pp_obj->getEndDate()), __FILE__, __LINE__, __METHOD__, 10);
if ($this->inApplyFrequencyWindow($epoch, $offset, $pp_obj->getEndDate()) == TRUE) {
$in_apply_frequency_window = TRUE;
$annual_pay_periods = $pp_obj->getPayPeriodScheduleObject()->getAnnualPayPeriods();
break;
} else {
Debug::Text(' User not in Apply Frequency Window: ', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::Text(' No Pay Period Found.', __FILE__, __LINE__, __METHOD__, 10);
}
} elseif ($this->inApplyFrequencyWindow($epoch, $offset) == TRUE) {
Debug::Text(' User IS in NON-PayPeriod Apply Frequency Window.', __FILE__, __LINE__, __METHOD__, 10);
$in_apply_frequency_window = TRUE;
} else {
Debug::Text(' User is not in Apply Frequency Window.', __FILE__, __LINE__, __METHOD__, 10);
$in_apply_frequency_window = FALSE;
}
}
if ($in_apply_frequency_window == TRUE) {
$milestone_obj = $this->getActiveMilestoneObject($u_obj, $epoch);
if (isset($milestone_obj) and is_object($milestone_obj)) {
Debug::Text(' Found Matching Milestone, Accrual Rate: (ID: ' . $milestone_obj->getId() . ') ' . $milestone_obj->getAccrualRate() . '/year', __FILE__, __LINE__, __METHOD__, 10);
$accrual_balance = $this->getCurrentAccrualBalance($user_id, $this->getId());
if ($accrual_balance < $milestone_obj->getMaximumTime()) {
$accrual_amount = $this->calcAccrualAmount($milestone_obj, 0, $annual_pay_periods);
if ($accrual_amount > 0) {
$new_accrual_balance = bcadd($accrual_balance, $accrual_amount);
//If Maximum time is set to 0, make that unlimited.
if ($milestone_obj->getMaximumTime() > 0 and $new_accrual_balance > $milestone_obj->getMaximumTime()) {
$accrual_amount = bcsub($milestone_obj->getMaximumTime(), $accrual_balance, 0);
}
Debug::Text(' Min/Max Adjusted Accrual Amount: ' . $accrual_amount . ' Limits: Min: ' . $milestone_obj->getMinimumTime() . ' Max: ' . $milestone_obj->getMaximumTime(), __FILE__, __LINE__, __METHOD__, 10);
//Check to make sure there isn't an identical entry already made.
$alf = new AccrualListFactory();
$alf->getByCompanyIdAndUserIdAndAccrualPolicyIDAndTimeStampAndAmount($u_obj->getCompany(), $user_id, $this->getId(), TTDate::getMiddleDayEpoch($epoch), $accrual_amount);
if ($alf->getRecordCount() == 0) {
//Round to nearest 1min
$af = new AccrualFactory();
$af->setUser($user_id);
$af->setType(75);
//Accrual Policy
$af->setAccrualPolicyID($this->getId());
$af->setAmount($accrual_amount);
$af->setTimeStamp(TTDate::getMiddleDayEpoch($epoch));
$af->setEnableCalcBalance(TRUE);
if ($af->isValid()) {
$af->Save();
}
} else {
Debug::Text(' Found duplicate accrual entry, skipping...', __FILE__, __LINE__, __METHOD__, 10);
}
unset($accrual_amount, $accrual_balance, $new_accrual_balance);
} else {
Debug::Text(' Accrual Amount is 0...', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::Text(' Accrual Balance is outside Milestone Range. Skipping...', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::Text(' DID NOT Find Matching Milestone.', __FILE__, __LINE__, __METHOD__, 10);
}
unset($milestone_obj);
}
} else {
Debug::Text(' User is not active (Status: ' . $u_obj->getStatus() . ') or has only been employed: ' . TTDate::getDays($epoch - $u_obj->getHireDate()) . ' Days, not enough.', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::Text('No User Found. Company ID: ' . $this->getCompany(), __FILE__, __LINE__, __METHOD__, 10);
}
}
}
}
}
$pglf->CommitTransaction();
return TRUE;
}
function postInstall()
{
global $cache;
Debug::text('postInstall: ' . $this->getVersion(), __FILE__, __LINE__, __METHOD__, 9);
//Configure currencies for Standard Edition.
if ($this->getIsUpgrade() == TRUE) {
$clf = new CompanyListFactory();
$clf->StartTransaction();
$clf->getAll();
if ($clf->getRecordCount() > 0) {
foreach ($clf as $c_obj) {
if ($c_obj->getStatus() == 10) {
//Converting to new Accrual Policy table.
Debug::text('Converting to new Accrual Policy Table: ' . $c_obj->getName() . ' ID: ' . $c_obj->getId(), __FILE__, __LINE__, __METHOD__, 9);
$pglf = new PolicyGroupListFactory();
$pglf->getByCompanyId($c_obj->getId());
if ($pglf->getRecordCount() > 0) {
foreach ($pglf as $pg_obj) {
Debug::text('Accrual Policy ID: ' . $pg_obj->getColumn('accrual_policy_id'), __FILE__, __LINE__, __METHOD__, 9);
if ($pg_obj->getColumn('accrual_policy_id') != '' and $pg_obj->getColumn('accrual_policy_id') != 0) {
$pg_obj->setAccrualPolicy(array($pg_obj->getColumn('accrual_policy_id')));
if ($pg_obj->isValid()) {
$pg_obj->Save();
}
}
}
}
Debug::text('Adding Currency Information to Company: ' . $c_obj->getName() . ' ID: ' . $c_obj->getId(), __FILE__, __LINE__, __METHOD__, 9);
$crlf = new CurrencyListFactory();
$crlf->getByCompanyId($c_obj->getId());
if ($crlf->getRecordCount() == 0) {
$cf = new CurrencyFactory();
$country_to_currency_map_arr = $cf->getOptions('country_currency');
if (isset($country_to_currency_map_arr[$c_obj->getCountry()])) {
$base_currency = $country_to_currency_map_arr[$c_obj->getCountry()];
Debug::text('Found Base Currency For Country: ' . $c_obj->getCountry() . ' Currency: ' . $base_currency, __FILE__, __LINE__, __METHOD__, 9);
} else {
Debug::text('DID NOT Find Base Currency For Country: ' . $c_obj->getCountry() . ' Using default USD.', __FILE__, __LINE__, __METHOD__, 9);
$base_currency = 'USD';
}
$cf->setCompany($c_obj->getId());
$cf->setStatus(10);
$cf->setName($base_currency);
$cf->setISOCode($base_currency);
$cf->setConversionRate('1.000000000');
$cf->setAutoUpdate(FALSE);
$cf->setBase(TRUE);
$cf->setDefault(TRUE);
if ($cf->isValid()) {
$base_currency_id = $cf->Save();
Debug::text('Base Currency ID: ' . $base_currency_id, __FILE__, __LINE__, __METHOD__, 10);
//Set Employee Hire Defaults.
$udlf = new UserDefaultListFactory();
$udlf->getByCompanyId($c_obj->getId());
if ($udlf->getRecordCount() > 0) {
$ud_obj = $udlf->getCurrent();
$ud_obj->setCurrency($base_currency_id);
$ud_obj->setLanguage('en');
if ($ud_obj->isValid()) {
$ud_obj->Save();
}
}
unset($udlf, $ud_obj);
if (is_numeric($base_currency_id)) {
$ulf = new UserListFactory();
$ulf->getByCompanyId($c_obj->getId());
if ($ulf->getRecordCount() > 0) {
foreach ($ulf as $u_obj) {
$user_id = $u_obj->getID();
Debug::text('Setting Base Currency For User: '******' ID: ' . $user_id, __FILE__, __LINE__, __METHOD__, 10);
$u_obj->setCurrency($base_currency_id);
if ($u_obj->isValid()) {
if ($u_obj->Save() == TRUE) {
//Set User Default Language
$uplf = new UserPreferenceListFactory();
$uplf->getByUserIDAndCompanyID($user_id, $c_obj->getId());
if ($uplf->getRecordCount() > 0) {
$up_obj = $uplf->getCurrent();
$up_obj->setLanguage('en');
//Englist
if ($up_obj->isValid()) {
$up_obj->Save();
}
}
unset($uplf, $up_obj);
Debug::text(' Setting Base Currency for Pay Stubs, User ID: ' . $user_id, __FILE__, __LINE__, __METHOD__, 10);
//Change all pay stubs for this user to the base currency.
//Do this in a single query for speed purposes.
$ph = array('currency_id' => $base_currency_id, 'currency_rate' => '1.000000000', 'user_id' => $user_id);
$query = 'update pay_stub set currency_id = ?, currency_rate = ? where user_id = ?';
Debug::text(' Pay Stub Currency Query: ' . $query, __FILE__, __LINE__, __METHOD__, 10);
$u_obj->db->Execute($query, $ph);
/*
$pslf = new PayStubListFactory();
$pslf->getByUserIdAndCompanyId( $user_id, $c_obj->getId() );
if ( $pslf->getRecordCount() > 0 ) {
foreach( $pslf as $ps_obj ) {
//Debug::text(' Setting Base Currency for Pay Stub ID: '. $ps_obj->getId(), __FILE__, __LINE__, __METHOD__,10);
$ps_obj->setCurrency( $base_currency_id );
if ( $ps_obj->isValid() ) {
$ps_obj->setEnableLinkedAccruals( FALSE );
$ps_obj->setEnableCalcYTD( FALSE );
$ps_obj->setEnableProcessEntries( FALSE );
$ps_obj->Save();
}
unset($ps_obj);
}
}
unset($pslf);
*/
} else {
Debug::text('Failed saving user ID: ' . $user_id, __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text('Failed saving user ID: ' . $user_id, __FILE__, __LINE__, __METHOD__, 10);
}
unset($u_obj, $user_id);
}
}
unset($ulf);
}
}
unset($cf);
}
} else {
Debug::text('Company is not active! ' . $c_obj->getId(), __FILE__, __LINE__, __METHOD__, 10);
}
unset($c_obj, $base_currency, $base_currency_id, $crlf);
}
}
//$clf->FailTransaction();
$clf->CommitTransaction();
}
//Add currency updating to cron.
$maint_base_path = Environment::getBasePath() . DIRECTORY_SEPARATOR . 'maint' . DIRECTORY_SEPARATOR;
if (PHP_OS == 'WINNT') {
$cron_job_base_command = 'php-win.exe ' . $maint_base_path;
} else {
$cron_job_base_command = 'php ' . $maint_base_path;
}
Debug::text('Cron Job Base Command: ' . $cron_job_base_command, __FILE__, __LINE__, __METHOD__, 9);
$cjf = new CronJobFactory();
$cjf->setName('UpdateCurrencyRates');
$cjf->setMinute(45);
$cjf->setHour(1);
$cjf->setDayOfMonth('*');
$cjf->setMonth('*');
$cjf->setDayOfWeek('*');
$cjf->setCommand($cron_job_base_command . 'UpdateCurrencyRates.php');
$cjf->Save();
return TRUE;
}
function postSave()
{
$this->removeCache($this->getId());
if ($this->getDeleted() == FALSE and $this->getPermissionControl() !== FALSE) {
Debug::text('Permission Group is set...', __FILE__, __LINE__, __METHOD__, 10);
$pclf = new PermissionControlListFactory();
$pclf->getByCompanyIdAndUserID($this->getCompany(), $this->getId());
if ($pclf->getRecordCount() > 0) {
Debug::text('Already assigned to a Permission Group...', __FILE__, __LINE__, __METHOD__, 10);
$pc_obj = $pclf->getCurrent();
if ($pc_obj->getId() == $this->getPermissionControl()) {
$add_permission_control = FALSE;
} else {
Debug::text('Permission Group has changed...', __FILE__, __LINE__, __METHOD__, 10);
//Remove user from current schedule.
$pulf = new PermissionUserListFactory();
$pulf->getByPermissionControlIdAndUserID($pc_obj->getId(), $this->getId());
Debug::text('Record Count: ' . $pulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($pulf->getRecordCount() > 0) {
foreach ($pulf as $pu_obj) {
Debug::text('Deleteing from Permission Group: ' . $pu_obj->getPermissionControl(), __FILE__, __LINE__, __METHOD__, 10);
$pu_obj->Delete();
}
}
$add_permission_control = TRUE;
}
} else {
Debug::text('NOT Already assigned to a Permission Group...', __FILE__, __LINE__, __METHOD__, 10);
$add_permission_control = TRUE;
}
if ($this->getPermissionControl() !== FALSE and $add_permission_control == TRUE) {
Debug::text('Adding user to Permission Group...', __FILE__, __LINE__, __METHOD__, 10);
//Add to new permission group
$puf = new PermissionUserFactory();
$puf->setPermissionControl($this->getPermissionControl());
$puf->setUser($this->getID());
if ($puf->isValid()) {
$puf->Save();
//Clear permission class for this employee.
$pf = new PermissionFactory();
$pf->clearCache($this->getID(), $this->getCompany());
}
}
unset($add_permission_control);
}
if ($this->getDeleted() == FALSE and $this->getPayPeriodSchedule() !== FALSE) {
Debug::text('Pay Period Schedule is set...', __FILE__, __LINE__, __METHOD__, 10);
$ppslf = new PayPeriodScheduleListFactory();
$ppslf->getByUserId($this->getId());
if ($ppslf->getRecordCount() > 0) {
$pps_obj = $ppslf->getCurrent();
if ($this->getPayPeriodSchedule() == $pps_obj->getId()) {
Debug::text('Already assigned to this Pay Period Schedule...', __FILE__, __LINE__, __METHOD__, 10);
$add_pay_period_schedule = FALSE;
} else {
Debug::text('Changing Pay Period Schedule...', __FILE__, __LINE__, __METHOD__, 10);
//Remove user from current schedule.
$ppsulf = new PayPeriodScheduleUserListFactory();
$ppsulf->getByPayPeriodScheduleIdAndUserID($pps_obj->getId(), $this->getId());
Debug::text('Record Count: ' . $ppsulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($ppsulf->getRecordCount() > 0) {
foreach ($ppsulf as $ppsu_obj) {
Debug::text('Deleteing from Pay Period Schedule: ' . $ppsu_obj->getPayPeriodSchedule(), __FILE__, __LINE__, __METHOD__, 10);
$ppsu_obj->Delete();
}
}
$add_pay_period_schedule = TRUE;
}
} else {
Debug::text('Not assigned to ANY Pay Period Schedule...', __FILE__, __LINE__, __METHOD__, 10);
$add_pay_period_schedule = TRUE;
}
if ($this->getPayPeriodSchedule() !== FALSE and $add_pay_period_schedule == TRUE) {
//Add to new pay period schedule
$ppsuf = new PayPeriodScheduleUserFactory();
$ppsuf->setPayPeriodSchedule($this->getPayPeriodSchedule());
$ppsuf->setUser($this->getID());
if ($ppsuf->isValid()) {
$ppsuf->Save();
}
}
unset($add_pay_period_schedule);
}
if ($this->getDeleted() == FALSE and $this->getPolicyGroup() !== FALSE) {
Debug::text('Policy Group is set...', __FILE__, __LINE__, __METHOD__, 10);
$pglf = new PolicyGroupListFactory();
$pglf->getByUserIds($this->getId());
if ($pglf->getRecordCount() > 0) {
$pg_obj = $pglf->getCurrent();
if ($this->getPolicyGroup() == $pg_obj->getId()) {
Debug::text('Already assigned to this Policy Group...', __FILE__, __LINE__, __METHOD__, 10);
$add_policy_group = FALSE;
} else {
Debug::text('Changing Policy Group...', __FILE__, __LINE__, __METHOD__, 10);
//Remove user from current schedule.
$pgulf = new PolicyGroupUserListFactory();
$pgulf->getByPolicyGroupIdAndUserId($pg_obj->getId(), $this->getId());
Debug::text('Record Count: ' . $pgulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($pgulf->getRecordCount() > 0) {
foreach ($pgulf as $pgu_obj) {
Debug::text('Deleteing from Policy Group: ' . $pgu_obj->getPolicyGroup(), __FILE__, __LINE__, __METHOD__, 10);
$pgu_obj->Delete();
}
}
$add_policy_group = TRUE;
}
} else {
Debug::text('Not assigned to ANY Policy Group...', __FILE__, __LINE__, __METHOD__, 10);
$add_policy_group = TRUE;
}
if ($this->getPolicyGroup() !== FALSE and $add_policy_group == TRUE) {
//Add to new policy group
$pguf = new PolicyGroupUserFactory();
$pguf->setPolicyGroup($this->getPolicyGroup());
$pguf->setUser($this->getID());
if ($pguf->isValid()) {
$pguf->Save();
}
}
unset($add_policy_group);
}
if ($this->getDeleted() == FALSE and $this->getHierarchyControl() !== FALSE) {
Debug::text('Hierarchies are set...', __FILE__, __LINE__, __METHOD__, 10);
$hierarchy_control_data = array_unique(array_values((array) $this->getHierarchyControl()));
//Debug::Arr($hierarchy_control_data, 'Setting hierarchy control data...', __FILE__, __LINE__, __METHOD__, 10);
if (is_array($hierarchy_control_data)) {
$hclf = new HierarchyControlListFactory();
$hclf->getObjectTypeAppendedListByCompanyIDAndUserID($this->getCompany(), $this->getID());
$existing_hierarchy_control_data = array_unique(array_values((array) $hclf->getArrayByListFactory($hclf, FALSE, TRUE, FALSE)));
//Debug::Arr($existing_hierarchy_control_data, 'Existing hierarchy control data...', __FILE__, __LINE__, __METHOD__, 10);
$hierarchy_control_delete_diff = array_diff($existing_hierarchy_control_data, $hierarchy_control_data);
//Debug::Arr($hierarchy_control_delete_diff, 'Hierarchy control delete diff: ', __FILE__, __LINE__, __METHOD__, 10);
//Remove user from existing hierarchy control
if (is_array($hierarchy_control_delete_diff)) {
foreach ($hierarchy_control_delete_diff as $hierarchy_control_id) {
if ($hierarchy_control_id != 0) {
$hulf = new HierarchyUserListFactory();
$hulf->getByHierarchyControlAndUserID($hierarchy_control_id, $this->getID());
if ($hulf->getRecordCount() > 0) {
Debug::text('Deleting user from hierarchy control ID: ' . $hierarchy_control_id, __FILE__, __LINE__, __METHOD__, 10);
$hulf->getCurrent()->Delete();
}
}
}
}
unset($hierarchy_control_delete_diff, $hulf, $hclf, $hierarchy_control_id);
$hierarchy_control_add_diff = array_diff($hierarchy_control_data, $existing_hierarchy_control_data);
//Debug::Arr($hierarchy_control_add_diff, 'Hierarchy control add diff: ', __FILE__, __LINE__, __METHOD__, 10);
if (is_array($hierarchy_control_add_diff)) {
foreach ($hierarchy_control_add_diff as $hierarchy_control_id) {
Debug::text('Hierarchy data changed...', __FILE__, __LINE__, __METHOD__, 10);
if ($hierarchy_control_id != 0) {
$huf = new HierarchyUserFactory();
$huf->setHierarchyControl($hierarchy_control_id);
$huf->setUser($this->getId());
if ($huf->isValid()) {
Debug::text('Adding user to hierarchy control ID: ' . $hierarchy_control_id, __FILE__, __LINE__, __METHOD__, 10);
$huf->Save();
}
}
}
}
unset($hierarchy_control_add, $huf, $hierarchy_control_id);
}
}
if (isset($this->is_new) and $this->is_new == TRUE) {
$udlf = new UserDefaultListFactory();
$udlf->getByCompanyId($this->getCompany());
if ($udlf->getRecordCount() > 0) {
Debug::Text('Using User Defaults', __FILE__, __LINE__, __METHOD__, 10);
$udf_obj = $udlf->getCurrent();
Debug::text('Inserting Default Deductions...', __FILE__, __LINE__, __METHOD__, 10);
$company_deduction_ids = $udf_obj->getCompanyDeduction();
if (is_array($company_deduction_ids) and count($company_deduction_ids) > 0) {
foreach ($company_deduction_ids as $company_deduction_id) {
$udf = new UserDeductionFactory();
$udf->setUser($this->getId());
$udf->setCompanyDeduction($company_deduction_id);
if ($udf->isValid()) {
$udf->Save();
}
}
}
unset($company_deduction_ids, $company_deduction_id, $udf);
Debug::text('Inserting Default Prefs...', __FILE__, __LINE__, __METHOD__, 10);
$upf = new UserPreferenceFactory();
$upf->setUser($this->getId());
$upf->setLanguage($udf_obj->getLanguage());
$upf->setDateFormat($udf_obj->getDateFormat());
$upf->setTimeFormat($udf_obj->getTimeFormat());
$upf->setTimeUnitFormat($udf_obj->getTimeUnitFormat());
$upf->setTimeZone($udf_obj->getTimeZone());
$upf->setItemsPerPage($udf_obj->getItemsPerPage());
$upf->setStartWeekDay($udf_obj->getStartWeekDay());
$upf->setEnableEmailNotificationException($udf_obj->getEnableEmailNotificationException());
$upf->setEnableEmailNotificationMessage($udf_obj->getEnableEmailNotificationMessage());
$upf->setEnableEmailNotificationHome($udf_obj->getEnableEmailNotificationHome());
if ($upf->isValid()) {
$upf->Save();
}
}
}
if ($this->getDeleted() == TRUE) {
//Remove them from the authorization hierarchy, policy group, and pay period schedule.
//Delete any accruals for them as well.
//Pay Period Schedule
$ppslf = new PayPeriodScheduleListFactory();
$ppslf->getByUserId($this->getId());
if ($ppslf->getRecordCount() > 0) {
$pps_obj = $ppslf->getCurrent();
//Remove user from current schedule.
$ppsulf = new PayPeriodScheduleUserListFactory();
$ppsulf->getByPayPeriodScheduleIdAndUserID($pps_obj->getId(), $this->getId());
Debug::text('Record Count: ' . $ppsulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($ppsulf->getRecordCount() > 0) {
foreach ($ppsulf as $ppsu_obj) {
Debug::text('Deleteing from Pay Period Schedule: ' . $ppsu_obj->getPayPeriodSchedule(), __FILE__, __LINE__, __METHOD__, 10);
$ppsu_obj->Delete();
}
}
}
//Policy Group
$pglf = new PolicyGroupListFactory();
$pglf->getByUserIds($this->getId());
if ($pglf->getRecordCount() > 0) {
$pg_obj = $pglf->getCurrent();
$pgulf = new PolicyGroupUserListFactory();
$pgulf->getByPolicyGroupIdAndUserId($pg_obj->getId(), $this->getId());
Debug::text('Record Count: ' . $pgulf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($pgulf->getRecordCount() > 0) {
foreach ($pgulf as $pgu_obj) {
Debug::text('Deleteing from Policy Group: ' . $pgu_obj->getPolicyGroup(), __FILE__, __LINE__, __METHOD__, 10);
$pgu_obj->Delete();
}
}
}
//Hierarchy
$hclf = new HierarchyControlListFactory();
$hclf->getByCompanyId($this->getCompany());
if ($hclf->getRecordCount() > 0) {
foreach ($hclf as $hc_obj) {
$hf = new HierarchyListFactory();
$hf->setUser($this->getID());
$hf->setHierarchyControl($hc_obj->getId());
$hf->Delete();
}
$hf->removeCache(NULL, $hf->getTable(TRUE));
//On delete we have to delete the entire group.
unset($hf);
}
//Accrual balances
$alf = new AccrualListFactory();
$alf->getByUserIdAndCompanyId($this->getId(), $this->getCompany());
if ($alf->getRecordCount() > 0) {
foreach ($alf as $a_obj) {
$a_obj->setDeleted(TRUE);
if ($a_obj->isValid()) {
$a_obj->Save();
}
}
}
}
return TRUE;
}
$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['sex_options'] = Misc::prependArray($all_array_option, $ulf->getOptions('sex'));
$filter_data['status_options'] = Misc::prependArray($all_array_option, $ulf->getOptions('status'));
$cf = new CompanyFactory();
$filter_data['country_options'] = Misc::prependArray($all_array_option, $cf->getOptions('country'));
if (isset($filter_data['country'])) {
$filter_data['province_options'] = Misc::prependArray($all_array_option, $cf->getOptions('province', $filter_data['country']));
} else {
$filter_data['province_options'] = $all_array_option;
}
$ppslf = new PayPeriodScheduleListFactory();
$filter_data['pay_period_schedule_options'] = Misc::prependArray($all_array_option, $ppslf->getByCompanyIDArray($current_company->getId()));
$pglf = new PolicyGroupListFactory();
$filter_data['policy_group_options'] = Misc::prependArray($all_array_option, $pglf->getByCompanyIDArray($current_company->getId()));
$filter_data['saved_search_options'] = $ugdlf->getArrayByListFactory($ugdlf->getByUserIdAndScript($current_user->getId(), $_SERVER['SCRIPT_NAME']), FALSE);
//Get column list
$filter_data['src_column_options'] = Misc::arrayDiffByKey((array) $filter_data['columns'], $columns);
$filter_data['selected_column_options'] = Misc::arrayIntersectByKey((array) $filter_data['columns'], $columns);
$filter_data['sort_options'] = Misc::trimSortPrefix($columns);
$filter_data['sort_direction_options'] = Misc::getSortDirectionArray(TRUE);
foreach ($filter_data['columns'] as $column_key) {
$filter_columns[Misc::trimSortPrefix($column_key)] = $columns[$column_key];
}
unset($column_key);
$obj_class = "TTLicense";
$obj_function = "validateLicense";
$obj_error_msg_function = "getFullErrorMessage";
@($obj = new $obj_class());