function postInstall()
{
Debug::text('postInstall: ' . $this->getVersion(), __FILE__, __LINE__, __METHOD__, 9);
//Go through all pay period schedules and update the annual pay period column
$ppslf = new PayPeriodScheduleListFactory();
$ppslf->getAll();
if ($ppslf->getRecordCount() > 0) {
foreach ($ppslf as $pps_obj) {
$pps_obj->setAnnualPayPeriods($pps_obj->calcAnnualPayPeriods());
if ($pps_obj->isValid()) {
$pps_obj->Save();
}
}
}
//Go through all employee wages and update HourlyRate to the accurate annual hourly rate.
//**Handle this in 1034A postInstall() instead, as it needs to handle incorrect effective_dates properly.
/*
$uwlf = new UserWageListFactory();
$uwlf->getAll();
if ( $uwlf->getRecordCount() > 0 ) {
foreach( $uwlf as $uw_obj ) {
$uw_obj->setHourlyRate( $uw_obj->calcHourlyRate( time(), TRUE ) );
if ( $uw_obj->isValid() ) {
$uw_obj->Save();
}
}
}
*/
//Upgrade to new hierarchy format.
$clf = new CompanyListFactory();
$clf->getAll();
if ($clf->getRecordCount() > 0) {
foreach ($clf as $c_obj) {
if ($c_obj->getStatus() != 30) {
/*
if ( !($c_obj->getId() == 1052) ) { //$c_obj->getId() == 1009 OR $c_obj->getId() == 1087 OR
continue;
}
*/
$company_id = $c_obj->getId();
Debug::Text(' Company ID: ' . $company_id, __FILE__, __LINE__, __METHOD__, 10);
$hclf = new HierarchyControlListFactory();
$hclf->StartTransaction();
$hclf->getByCompanyId($company_id);
if ($hclf->getRecordCount() > 0) {
foreach ($hclf as $hc_obj) {
$paths_to_root = array();
$hierarchy_id = $hc_obj->getId();
$hlf = new HierarchyListFactory();
$hierarchy_users = $hlf->getByCompanyIdAndHierarchyControlId($company_id, $hierarchy_id);
if (is_array($hierarchy_users) and count($hierarchy_users) > 0) {
$hotlf = new HierarchyObjectTypeListFactory();
$hotlf->getByHierarchyControlId($hierarchy_id);
if ($hotlf->getRecordCount() > 0) {
foreach ($hotlf as $hot_obj) {
$object_types[$hierarchy_id][] = $hot_obj->getObjectType();
}
}
foreach ($hierarchy_users as $hierarchy_user_arr) {
Debug::Text(' Checking User ID: ' . $hierarchy_user_arr['id'], __FILE__, __LINE__, __METHOD__, 10);
$id = $hierarchy_user_arr['id'];
$tmp_id = $id;
$i = 0;
do {
Debug::Text(' Iteration...', __FILE__, __LINE__, __METHOD__, 10);
$hlf_b = new HierarchyListFactory();
$parents = $hlf_b->getParentLevelIdArrayByHierarchyControlIdAndUserId($hierarchy_id, $tmp_id);
sort($parents);
$level = $hlf_b->getFastTreeObject()->getLevel($tmp_id) - 1;
if (is_array($parents) and count($parents) > 0) {
$parent_users = array();
foreach ($parents as $user_id) {
$parent_users[] = $user_id;
unset($user);
}
$parent_groups[$level] = $parent_users;
unset($parent_users);
}
if (isset($parents[0])) {
$tmp_id = $parents[0];
}
$i++;
} while (is_array($parents) and count($parents) > 0 and $i < 100);
if (isset($parent_groups)) {
$serialized_path = serialize($parent_groups);
$paths_to_root[$serialized_path][] = $id;
unset($serialized_path);
}
unset($parent_groups, $parents);
}
}
Debug::Arr($paths_to_root, ' Paths To Root: ', __FILE__, __LINE__, __METHOD__, 10);
//Decode path_to_root array
if (isset($paths_to_root) and count($paths_to_root) > 0) {
foreach ($paths_to_root as $serialized_path => $children) {
$path_arr = unserialize($serialized_path);
$decoded_paths[] = array('hierarchy_control_id' => $hierarchy_id, 'path' => $path_arr, 'children' => $children);
}
unset($path_arr, $children);
Debug::Arr($decoded_paths, ' Decoded Paths: ', __FILE__, __LINE__, __METHOD__, 10);
if (isset($decoded_paths) and is_array($decoded_paths)) {
foreach ($decoded_paths as $decoded_path) {
Debug::Text(' Company ID: ' . $company_id, __FILE__, __LINE__, __METHOD__, 10);
//Create new hierarchy_control
$hcf = new HierarchyControlFactory();
$hcf->setCompany($company_id);
$hcf->setObjectType($object_types[$decoded_path['hierarchy_control_id']]);
//Generate meaningful name
$name = FALSE;
if (isset($decoded_path['path']) and is_array($decoded_path['path'])) {
ksort($decoded_path['path']);
//Sort by level.
foreach ($decoded_path['path'] as $level => $superior_ids) {
foreach ($superior_ids as $superior_id) {
$ulf = new UserListFactory();
$ulf->getById($superior_id);
if ($ulf->getRecordCount() > 0) {
$name[] = $level . '. ' . $ulf->getCurrent()->getFullName();
}
}
}
unset($level, $superior_ids, $superior_id);
}
if (isset($name)) {
$name = $hc_obj->getName() . ' ' . implode(', ', $name) . ' (#' . rand(1000, 9999) . ')';
} else {
$name = $hc_obj->getName() . ' (#' . rand(1000, 9999) . ')';
}
$hcf->setName(substr($name, 0, 249));
$hcf->setDescription(TTi18n::getText('Automatically created by TimeTrex'));
if ($hcf->isValid()) {
$hc_id = $hcf->Save(FALSE);
Debug::Text('Hierarchy Control ID: ' . $hc_id, __FILE__, __LINE__, __METHOD__, 10);
$hcf->setUser($decoded_path['children']);
if (isset($decoded_path['path']) and is_array($decoded_path['path'])) {
foreach ($decoded_path['path'] as $level => $superior_ids) {
foreach ($superior_ids as $superior_id) {
$hlf = new HierarchyLevelFactory();
$hlf->setHierarchyControl($hc_id);
$hlf->setLevel($level);
$hlf->setUser($superior_id);
if ($hlf->isValid()) {
$hlf->Save();
Debug::Text('Saving Level Row ID... User ID: ' . $superior_id, __FILE__, __LINE__, __METHOD__, 10);
}
}
}
unset($level, $superior_ids, $superior_id);
}
}
}
}
unset($decoded_paths);
}
//Delete existing hierarchy control.
$hc_obj->setDeleted(TRUE);
if ($hc_obj->isValid() == TRUE) {
$hc_obj->Save();
}
}
}
//$hclf->FailTransaction();
$hclf->CommitTransaction();
}
}
}
//Go through each permission group, and enable break policies for anyone who can see meal policies
$clf = new CompanyListFactory();
$clf->getAll();
if ($clf->getRecordCount() > 0) {
foreach ($clf as $c_obj) {
Debug::text('Company: ' . $c_obj->getName(), __FILE__, __LINE__, __METHOD__, 9);
if ($c_obj->getStatus() != 30) {
$pclf = new PermissionControlListFactory();
$pclf->getByCompanyId($c_obj->getId());
if ($pclf->getRecordCount() > 0) {
foreach ($pclf as $pc_obj) {
Debug::text('Permission Group: ' . $pc_obj->getName(), __FILE__, __LINE__, __METHOD__, 9);
$plf = new PermissionListFactory();
$plf->getByCompanyIdAndPermissionControlIdAndSectionAndName($c_obj->getId(), $pc_obj->getId(), 'meal_policy', 'enabled');
if ($plf->getRecordCount() > 0) {
Debug::text('Found permission group with meal policy enabled: ' . $plf->getCurrent()->getValue(), __FILE__, __LINE__, __METHOD__, 9);
$pc_obj->setPermission(array('break_policy' => array('enabled' => TRUE, 'view' => TRUE, 'add' => TRUE, 'edit' => TRUE, 'delete' => TRUE)));
} else {
Debug::text('Permission group does NOT have meal policy enabled...', __FILE__, __LINE__, __METHOD__, 9);
}
}
}
}
}
}
//Add MiscDaily cronjob to database.
$cjf = new CronJobFactory();
$cjf->setName('MiscDaily');
$cjf->setMinute(55);
$cjf->setHour(1);
$cjf->setDayOfMonth('*');
$cjf->setMonth('*');
$cjf->setDayOfWeek('*');
$cjf->setCommand('MiscDaily.php');
$cjf->Save();
//Add MiscWeekly cronjob to database.
$cjf = new CronJobFactory();
$cjf->setName('MiscWeekly');
$cjf->setMinute(55);
$cjf->setHour(1);
$cjf->setDayOfMonth('*');
$cjf->setMonth('*');
$cjf->setDayOfWeek('0');
//Sunday morning.
$cjf->setCommand('MiscWeekly.php');
$cjf->Save();
return TRUE;
}
function createAuthorizationHierarchyLevel($company_id, $hierarchy_id, $root_user_id, $level)
{
if ($hierarchy_id != '') {
//Add level
$hlf = new HierarchyLevelFactory();
$hlf->setHierarchyControl($hierarchy_id);
$hlf->setLevel($level);
$hlf->setUser($root_user_id);
if ($hlf->isValid()) {
$insert_id = $hlf->Save();
Debug::Text('Hierarchy Level ID: ' . $insert_id, __FILE__, __LINE__, __METHOD__, 10);
}
}
//Debug::Text('Failed Creating Hierarchy!', __FILE__, __LINE__, __METHOD__,10);
return TRUE;
}
$hcf->setUser($hierarchy_control_data['user_ids']);
} else {
$hcf->setUser(array());
}
if (count($hierarchy_level_data) > 0) {
//ReMap levels
$hierarchy_level_map = $hlf->ReMapHierarchyLevels($hierarchy_level_data);
Debug::Arr($hierarchy_level_map, 'Hierarchy Level Map: ', __FILE__, __LINE__, __METHOD__, 10);
foreach ($hierarchy_level_data as $hierarchy_level_id => $hierarchy_level) {
Debug::Text('Row ID: ' . $hierarchy_level_id . ' Level: ' . $hierarchy_level['level'], __FILE__, __LINE__, __METHOD__, 10);
if ($hierarchy_level['level'] != '' and $hierarchy_level['level'] >= 0 and isset($hierarchy_level_map[$hierarchy_level['level']])) {
if ($hierarchy_level_id > 0) {
$hlf->setID($hierarchy_level_id);
}
$hlf->setHierarchyControl($hc_id);
$hlf->setLevel($hierarchy_level_map[$hierarchy_level['level']]);
$hlf->setUser($hierarchy_level['user_id']);
if ($hlf->isValid()) {
Debug::Text('Saving Level Row ID: ' . $hierarchy_level_id, __FILE__, __LINE__, __METHOD__, 10);
$hlf->Save();
} else {
$redirect++;
}
} else {
//Delete level
if ($hierarchy_level_id > 0) {
$hlf->setID($hierarchy_level_id);
$hlf->setDeleted(TRUE);
$hlf->Save();
} else {
unset($hierarchy_level_data[$hierarchy_level_id]);