/home/techb158/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/Manager/Inc/Process_Assignment - Copy.php (4233B)
$courseID) {
$courseID = mysqli_real_escape_string($mysqli, $courseID);
$timeSlotid = !empty($_POST['Time_Slot'][$index]) ? mysqli_real_escape_string($mysqli, $_POST['Time_Slot'][$index]) : null;
$startDate = !empty($_POST['Start_Date'][$index]) ? mysqli_real_escape_string($mysqli, $_POST['Start_Date'][$index]) : null;
$endDate = !empty($_POST['End_Date'][$index]) ? mysqli_real_escape_string($mysqli, $_POST['End_Date'][$index]) : null;
// Query to fetch time slot details
$querys = "SELECT Time_Slot_ID, Time_Slot, Time_From, Time_To FROM time_slot_programs WHERE Time_Slot_ID = ?";
$stmts = $mysqli->prepare($querys);
$stmts->bind_param("s", $timeSlotid);
$stmts->execute();
$results = $stmts->get_result();
$rows = $results->fetch_assoc();
//$Time_Slot_ID = $rows["Time_Slot_ID"];
$timeSlot = $rows["Time_Slot"];
$startTime = !empty($rows['Time_From']) ? $rows['Time_From'] : null;
$endTime = !empty($rows['Time_To']) ? $rows['Time_To'] : null;
// Retrieve Reserve_Course value (checkbox handling)
$reserveCourse = isset($_POST['Reserve_Course'][$courseID]) ? 1 : 0;
if ($timeSlot && $startDate && $endDate && $startTime && $endTime) {
// Check if Course_ID and Group_ID already exist
$checkStmt = $mysqli->prepare("SELECT COUNT(*) FROM course_group_schedule WHERE Program_ID = ? AND Course_ID = ? AND Group_ID = ?");
$checkStmt->bind_param('iii', $Program_ID, $courseID, $Group_ID);
$checkStmt->execute();
$checkStmt->bind_result($count);
$checkStmt->fetch();
$checkStmt->close();
if ($count > 0) {
// Update existing record
$stmt = $mysqli->prepare("UPDATE course_group_schedule
SET Time_Slot_ID = ?, Reserve_Course = ?, Time_Slot = ?, Start_Date = ?, End_Date = ?, Start_Time = ?, End_Time = ?
WHERE Program_ID = ? AND Course_ID = ? AND Group_ID = ?");
$stmt->bind_param('iissssssii', $timeSlotid, $reserveCourse, $timeSlot, $startDate, $endDate, $startTime, $endTime, $Program_ID, $courseID, $Group_ID);
} else {
// Insert new record
$stmt = $mysqli->prepare("INSERT INTO course_group_schedule
(Program_ID, Course_ID, Group_ID, Time_Slot_ID, Reserve_Course, Time_Slot, Start_Date, End_Date, Start_Time, End_Time)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->bind_param('iiiissssss', $Program_ID, $courseID, $Group_ID, $timeSlotid, $reserveCourse, $timeSlot, $startDate, $endDate, $startTime, $endTime);
}
// Execute query
if (!$stmt->execute()) {
header("Location: assign_course_group.php?error=Error processing Course ID $courseID: " . $stmt->error);
exit();
}
$stmt->close();
}
}
//echo "UPDATE course_group_schedule
// SET Time_Slot_ID = $Time_Slot_ID, Reserve_Course = $reserveCourse, Time_Slot = $timeSlot, Start_Date = $startDate, End_Date = $endDate, Start_Time = $startTime, End_Time = $endTime
// WHERE Program_ID = $Program_ID AND Course_ID = $courseID AND Group_ID = $Group_ID";
//exit();
header("Location: assign_course_group.php?error=Schedule updated successfully!");
exit();
} else {
header("Location: assign_course_group.php?error=No courses selected.");
exit();
}
}
?>