$days_check = isset($_POST['day_menu']) ? $_POST['day_menu'] : NULL; //$subject_code = $_POST['subject_menu']; //$room_no = $_POST['room_menu']; //$emp_id = $_POST['teacher_menu']; if (isset($_POST['day_menu'])) { //$days = array($_POST['day_menu']); $start_time = $times[$s_time_index]; $end_time = $times[$e_time_index]; if (strtotime($start_time) < strtotime($end_time)) { //$start_time<$end_time if (!($msg = is_faculty_loaded($class_id, $start_time, $end_time, $_POST['day_menu']))) { //!$msg = is_loaded() if (true) { //!$msg = is_teacher_max($emp_id, $subject_code) $total_hours = get_duration($start_time, $end_time) * count($_POST['day_menu']); if (!($msg = is_subj_max($class_id, $total_hours))) { //!$msg = is_subj_max($section_id, $subject_code) foreach ($_POST['day_menu'] as $day) { $sy_id = get_active_sy(); mysql_query("START TRANSACTION;"); mysql_query("INSERT INTO class_schedule_temp_t \n\t\t\t\t\t\t\t\t\t\t\t VALUES ('', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$class_id}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$day}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$start_time}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$end_time}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '101');") or die("error po {$start_time} "); mysql_query("COMMIT;"); } $msg = "Successfuly added Load"; } //else // $msg = "hello"; } //else // $msg = "Teacher has reached maximum loads available"; }
@session_start(); if (isset($_POST['add_load'])) { $load_id = ''; //$section_id = $_POST['section_menu']; $subject_code = $_POST['subject_menu']; $room_no = $_POST['room_menu']; $emp_id = $_POST['teacher_menu']; if (isset($_POST['day_menu'])) { //$days = array($_POST['day_menu']); $time_index = $_POST['time_menu']; $start_time = $start_times[$time_index] . ":00"; $end_time = $end_times[$time_index] . ":00"; if ($start_time < $end_time) { if (!($msg = is_loaded())) { if (!($msg = is_teacher_max($emp_id, $subject_code))) { if (!($msg = is_subj_max($section_id, $subject_code))) { foreach ($_POST['day_menu'] as $day) { $sy_id = get_school_yr(); mysql_query("START TRANSACTION;"); mysql_query("INSERT INTO class_schedule_temp_t \n\t\t\t\t\t\t\t\t\t\t\t VALUES ('', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$section_id}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$subject_code}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$room_no}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$emp_id}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$day}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$start_time}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$end_time}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$sy_id}');") or die("error po {$start_time} "); mysql_query("COMMIT;"); } $msg = "Successfuly added Load"; } //else //$msg = "hello"; } //else //$msg = "Teacher has reached maximum loads available"; } else { //$msg = "There is already a load for that particular time.";