/home/techb158/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/Manager/Inc/Process_Assignment.php (5813B)
$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;
// Query to fetch time slot details for this group
$querys = "SELECT Group_Slot_ID, Time_Slot_ID, Time_Slot, Time_From, Time_To FROM group_slot_mapping WHERE Time_Slot_ID = ?";
$stmts = $mysqli->prepare($querys);
$stmts->bind_param("s", $timeSlotid);
$stmts->execute();
$results = $stmts->get_result();
$rows = $results->fetch_assoc();
$timeSlot = $rows["Time_Slot"];
$startTime = !empty($rows['Time_From']) ? $rows['Time_From'] : null;
$endTime = !empty($rows['Time_To']) ? $rows['Time_To'] : null;
//error_log("✅ Course startTime: $startTime");
//error_log("✅ Course endTime: $endTime");
//error_log("✅ Course courseID: $courseID");
//error_log("✅ Course Group_ID: $Group_ID");
//error_log("✅ Course timeSlotid: $timeSlotid");
//error_log("✅✅✅✅✅✅✅");
// 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 = $mysqli->prepare("UPDATE course_group_schedule
SET Time_Slot_ID = ?, Reserve_Course = ?, Time_Slot = ?, Start_Date = ?, End_Date = ?, Start_Time = ?, End_Time = ?, Last_Updated = NOW()
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);
$stmt->execute();
if ($stmt->affected_rows === 0) {
//error_log("⚠️ No rows updated for Course_ID: $courseID");
set_flash_msg("⚠️ No rows updated for Course_ID: $courseID", 'warning');
header("Location: assign_course_group.php");
exit();
} elseif ($stmt->affected_rows > 0) {
// error_log("✅ Course updated: $courseID");
}
} 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()) {
set_flash_msg("Error processing Course ID $courseID: " . $stmt->error, 'warning');
header("Location: assign_course_group.php");
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();
set_flash_msg("Schedule updated successfully!", 'success');
header("Location: assign_course_group.php");
exit();
} else {
set_flash_msg("No courses selected.", 'warning');
header("Location: assign_course_group.php");
exit();
}
}
?>