function preInstall()
{
Debug::text('preInstall: ' . $this->getVersion(), __FILE__, __LINE__, __METHOD__, 9);
/*
Permission System Upgrade.
- Use direct query to get current permission data and store in memory for postInstall.
*/
$query = 'select company_id,user_id,section,name,value from permission where deleted = 0 order by company_id, user_id, section, name';
$rs = $this->getDatabaseConnection()->Execute($query);
foreach ($rs as $row) {
$user_permission_data[$row['company_id']][$row['user_id']][$row['section']][$row['name']] = $row['value'];
//If employee has Punch In/Out permission enabled, add individual punch permission too.
if ($row['section'] == 'punch' and $row['name'] == 'punch_in_out' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_transfer'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_branch'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_department'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_note'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_other_id1'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_other_id2'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_other_id3'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_other_id4'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_other_id5'] = 1;
if (isset($user_permission_data[$row['company_id']][$row['user_id']]['job']['enabled']) and $user_permission_data[$row['company_id']][$row['user_id']]['job']['enabled'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_job'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_job_item'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_quantity'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['punch']['edit_bad_quantity'] = 1;
}
}
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['enabled'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['view_own'] = 1;
//We added the "Absence" permission section, so we need to copy punch permissions to this.
if ($row['section'] == 'punch' and $row['name'] == 'view_child' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['view_child'] = 1;
}
if ($row['section'] == 'punch' and $row['name'] == 'edit_child' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['edit_child'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['add'] = 1;
}
if ($row['section'] == 'punch' and $row['name'] == 'delete_child' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['delete_child'] = 1;
}
if ($row['section'] == 'punch' and $row['name'] == 'view' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['view'] = 1;
}
if ($row['section'] == 'punch' and $row['name'] == 'edit' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['edit'] = 1;
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['add'] = 1;
}
if ($row['section'] == 'punch' and $row['name'] == 'delete' and $row['value'] == 1) {
$user_permission_data[$row['company_id']][$row['user_id']]['absence']['delete'] = 1;
}
}
//Group Permissions together
if (isset($user_permission_data)) {
foreach ($user_permission_data as $company_id => $user_ids) {
//Get default employee permissions to start from.
if (isset($user_permission_data[$company_id]['-1'])) {
$this->permission_groups[$company_id]['default'] = $user_permission_data[$company_id]['-1'];
} else {
$this->permission_groups[$company_id]['default'] = array();
}
unset($user_permission_data[$company_id]['-1']);
$x = 1;
foreach ($user_ids as $user_id => $permission_user_data) {
$permission_no_differences_found = FALSE;
foreach ($this->permission_groups[$company_id] as $group_name => $permission_group_data) {
Debug::text('Company ID: ' . $company_id . ' Checking Permission Differences Between User ID: ' . $user_id . ' AND Group: ' . $group_name, __FILE__, __LINE__, __METHOD__, 10);
//Need to diff the arrays both directions, because the diff function only checks in one direction on its own.
$forward_permission_diff_arr = Misc::array_diff_assoc_recursive($permission_user_data, $permission_group_data);
$reverse_permission_diff_arr = Misc::array_diff_assoc_recursive($permission_group_data, $permission_user_data);
Debug::text('Permission User Data Count: ' . count($permission_user_data, COUNT_RECURSIVE) . ' Permission Group Data Count: ' . count($permission_group_data, COUNT_RECURSIVE), __FILE__, __LINE__, __METHOD__, 10);
if ($forward_permission_diff_arr == FALSE and $reverse_permission_diff_arr == FALSE) {
Debug::text('No Differences Found in Permissions! ', __FILE__, __LINE__, __METHOD__, 10);
$permission_no_differences_found = TRUE;
if ($user_id != -1) {
$this->permission_group_users[$company_id][$group_name][] = $user_id;
}
break;
} else {
Debug::text('Differences Found in Permissions! ', __FILE__, __LINE__, __METHOD__, 10);
//Debug::Arr($forward_permission_diff_arr, 'Forward Permission Differences:', __FILE__, __LINE__, __METHOD__, 10);
//Debug::Arr($reverse_permission_diff_arr, 'Reverse Permission Differences:', __FILE__, __LINE__, __METHOD__, 10);
}
}
unset($forward_permission_diff_arr, $reverse_permission_diff_arr);
if ($permission_no_differences_found == FALSE) {
Debug::text('Creating New Permission Group...: ' . $x, __FILE__, __LINE__, __METHOD__, 10);
$pf = new PermissionFactory();
$preset_arr = array(10, 18, 20, 30, 40);
foreach ($preset_arr as $preset) {
$tmp_preset_permissions = $pf->getPresetPermissions($preset, array());
$preset_permission_diff_arr = Misc::array_diff_assoc_recursive($permission_user_data, $tmp_preset_permissions);
$preset_permission_diff_count = count($preset_permission_diff_arr, COUNT_RECURSIVE);
Debug::text('Preset Permission Diff Count...: ' . $preset_permission_diff_count . ' Preset ID: ' . $preset, __FILE__, __LINE__, __METHOD__, 10);
$preset_match[$preset] = $preset_permission_diff_count;
}
unset($preset_arr, $tmp_preset_permissions);
krsort($preset_match);
//Flip the array so if there are more then one preset with the same match_count, we use the smallest preset value.
$preset_match = array_flip($preset_match);
//Flip the array back so the key is the match_preset again.
$preset_match = array_flip($preset_match);
foreach ($preset_match as $best_match_preset => $match_value) {
break;
}
//Debug::Arr($preset_match, 'zPreset Match Array: ', __FILE__, __LINE__, __METHOD__, 10);
//Create new group name, based on closest preset match
$preset_name_options = $pf->getOptions('preset');
if (isset($preset_name_options[$best_match_preset])) {
$group_name = $preset_name_options[$best_match_preset] . ' (' . $match_value . ') #' . $x;
} else {
$group_name = 'Group #' . $x;
}
Debug::text('Group Name: ' . $group_name, __FILE__, __LINE__, __METHOD__, 10);
$this->permission_groups[$company_id][$group_name] = $permission_user_data;
if ($user_id != -1) {
$this->permission_group_users[$company_id][$group_name][] = $user_id;
}
unset($pf, $best_match_preset, $match_value);
$x++;
}
}
ksort($this->permission_group_users[$company_id]);
ksort($this->permission_groups[$company_id]);
unset($permission_user_data, $permission_group_data, $group_name, $company_id, $user_id);
}
unset($user_permission_data);
}
return TRUE;
}
