public function has_activities($parents_id, $column_name1, $comparison1, $value1, $delimiter = '', $column_name2 = '', $comparison2 = '', $value2 = '')
{
$database = $_SESSION['database'];
$employees_roles_listing = '';
if (tep_not_null($parents_id)) {
$employees_roles_query = $database->query("select employees_roles_id from " . TABLE_EMPLOYEES_ROLES . " where roles_id in (" . $parents_id . ")");
while ($employees_roles_result = $database->fetch_array($employees_roles_query)) {
if (tep_not_null($employees_roles_listing)) {
$employees_roles_listing .= ',';
}
$employees_roles_listing .= '' . $employees_roles_result['employees_roles_id'];
}
} else {
$employees_roles_listing = $this->id;
}
$tariff = new tariff();
return $tariff->has_activities($employees_roles_listing, $column_name1, $comparison1, $value1, $delimiter, $column_name2, $comparison2, $value2);
}
$error_level = 8;
// Duplicate entries found
break;
}
// Do the checks
if ($administration_tariff->id != 0) {
// Existing tariff
/********************************************/
/*** First do the start date check series ***/
/********************************************/
if ($_POST['tariffs_start_date'] != $administration_tariff->start_date) {
// Start date has changed
if ($_POST['tariffs_start_date'] > $administration_tariff->start_date) {
// Start date after original start date
// Check if activities exist before new start date
if (tep_not_null($administration_tariff->has_activities(null, 'activities_date', '<', tep_strftime(DATE_FORMAT_DATABASE, $_POST['tariffs_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['tariffs_end_date'] != $administration_tariff->end_date) {
// End date has changed
if ($_POST['tariffs_end_date'] < $administration_tariff->end_date && $administration_tariff->end_date != 0 || $_POST['tariffs_end_date'] == 0) {
// End date before original end date
// Check if activities exist before new end date
