$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.";
