}
}
} else {
// Start date after original start date
// Check tariffs
if (tep_not_null($administration_employee_role->has_tariffs(null, 'tariffs_end_date', '<', tep_strftime(DATE_FORMAT_DATABASE, $_POST['employees_roles_start_date'])))) {
$_POST['action'] = 'enter_data';
$error_level = 8;
// Tariff end date before new start date
break;
} else {
if (tep_not_null($administration_employee_role->has_tariffs(null, 'tariffs_start_date', '<', tep_strftime(DATE_FORMAT_DATABASE, $_POST['employees_roles_start_date']), 'AND', 'tariffs_end_date', '>=', tep_strftime(DATE_FORMAT_DATABASE, $_POST['employees_roles_start_date'])))) {
$_POST['question_t1_answer'] = true;
// Tariffs start date will change
// Check if activities exist before new start date
if (tep_not_null($administration_employee_role->has_activities(null, 'activities_date', '<', tep_strftime(DATE_FORMAT_DATABASE, $_POST['employees_roles_start_date'])))) {
$_POST['action'] = 'enter_data';
$error_level = 9;
// Activities exist before new start date (thus between old and new start date)
break;
}
}
}
}
}
/*******************************************/
/*** Second do the end date check series ***/
/*******************************************/
if ($_POST['employees_roles_end_date'] != $administration_employee_role->end_date) {
// End date has changed
if ($_POST['employees_roles_end_date'] > $administration_employee_role->end_date && $administration_employee_role->end_date != 0 || $_POST['employees_roles_end_date'] == 0) {
public function has_activities($parents_id, $column_name1, $comparison1, $value1, $delimiter = '', $column_name2 = '', $comparison2 = '', $value2 = '')
{
$database = $_SESSION['database'];
$roles_listing = '';
if (tep_not_null($parents_id)) {
$roles_query = $database->query("select roles_id from " . TABLE_ROLES . " where projects_id in (" . $parents_id . ")");
while ($roles_result = $database->fetch_array($roles_query)) {
if (tep_not_null($roles_listing)) {
$roles_listing .= ',';
}
$roles_listing .= '' . $roles_result['roles_id'];
}
}
$employee_role = new employee_role();
return $employee_role->has_activities($roles_listing, $column_name1, $comparison1, $value1, $delimiter, $column_name2, $comparison2, $value2);
}
