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