/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Generate_Schedule_Script.php (29731B)
"; print_r($validDates); echo ""; // 🔄 Additional scheduling logic .... // Output valid dates //echo "
"; print_r($validDates); echo ""; $totalSessionsNeeded = array_sum($courseSessions); $availableDays = count($validDates); // Estimate sessions per day (based on number of slots) $sessionsPerDay = count($slotLabels); // Calculate how many days are needed to finish all sessions $daysRequired = ceil($totalSessionsNeeded / $sessionsPerDay); // Get expected end date $expectedEndDate = $validDates[$daysRequired - 1] ?? end($validDates); // fallback to last available if out of bounds echo "
$expectedEndDate (" . (new DateTime($expectedEndDate))->format('l') . ")
"; // Sort by course priority usort($selectedCourses, function ($a, $b) use ($priorityCourses) { $priorityA = $priorityCourses[$a] ?? PHP_INT_MAX; $priorityB = $priorityCourses[$b] ?? PHP_INT_MAX; return $priorityA <=> $priorityB; }); echo ""; print_r($selectedCourses); echo ""; // Prepare for fair scheduling (one course per slot) // Initialize $schedule = []; $remainingSessions = []; foreach ($selectedCourses as $courseID) { $remainingSessions[$courseID] = $courseSessions[$courseID] ?? 0; } // Queue of all courses $courseQueue = $selectedCourses; $currentCourses = [ 0 => null, // Slot 1 (e.g. Morning) 1 => null // Slot 2 (e.g. Afternoon) ]; // Assign initial two courses // Assign initial courses to slots without repeating $courseQueueCopy = $selectedCourses; $assignedCourses = []; foreach ([0, 1] as $slotIndex) { foreach ($courseQueueCopy as $courseID) { if (!in_array($courseID, $assignedCourses) && $remainingSessions[$courseID] > 0) { $currentCourses[$slotIndex] = $courseID; $assignedCourses[] = $courseID; break; } } } // Fetch all course names into array $courseNames = []; $courseRes = $mysqli->query("SELECT Course_ID, Course_Name FROM Courses"); while ($row = $courseRes->fetch_assoc()) { $courseNames[$row['Course_ID']] = $row['Course_Name']; } foreach ($validDates as $date) { $totalSessions = $courseSessions; // Copy of original sessions foreach ([0, 1] as $slotIndex) { $from = $timeFrom[$slotIndex] ?? null; $to = $timeTo[$slotIndex] ?? null; if (!$from || !$to || !$currentCourses[$slotIndex]) continue; $courseID = $currentCourses[$slotIndex]; $courseName = $courseNames[$courseID] ?? "Course #$courseID"; // Schedule the session $schedule[] = [ 'Date' => $date, 'Slot' => "Slot " . ($slotIndex + 1), 'Time' => format_time_slot_range($slotLabels[$slotIndex], $from, $to, (new DateTime($date))->format('l')), 'Course_ID' => $courseID ]; // Session info $scheduledSoFar = $totalSessions[$courseID] - $remainingSessions[$courseID] + 1; $total = $totalSessions[$courseID]; echo "
✅ Scheduled $courseName (Course ID: $courseID) on $date (Slot " . ($slotIndex + 1) . ") — Session $scheduledSoFar of $total
"; // Decrease remaining $remainingSessions[$courseID]--; // If finished, pull a new course if ($remainingSessions[$courseID] <= 0) { $currentCourses[$slotIndex] = null; while (!empty($courseQueue)) { $nextCourse = array_shift($courseQueue); if ($remainingSessions[$nextCourse] > 0) { $currentCourses[$slotIndex] = $nextCourse; break; } } } } // Stop if both slots are out of courses if (!$currentCourses[0] && !$currentCourses[1]) break; } // 🔍 Identify last scheduled session for each course $lastSessions = []; foreach ($schedule as $index => $entry) { $courseID = $entry['Course_ID']; $lastSessions[$courseID] = $index; // keeps overwriting until the last index } echo ""; print_r($schedule); echo ""; echo "
Group: " . htmlspecialchars($groupName) . "
"; if (!empty($schedule)) { // Collect all displayed dates: scheduled, holidays, and retakes $displayDates = []; // 1. From scheduled sessions foreach ($schedule as $row) { $displayDates[$row['Date']][] = $row; // grouped by date } // 2. Add holidays (if no course scheduled on them) foreach ($holidayDates as $hDate) { if (!isset($displayDates[$hDate])) { $displayDates[$hDate] = []; // will be handled below } } // 3. Add retakes foreach ($retakeDates as $rDate) { if (!isset($displayDates[$rDate])) { $displayDates[$rDate] = []; // will be handled below } } // Sort the dates chronologically ksort($displayDates); echo "| Date | Slot | Time | Course | Action |
|---|---|---|---|---|
| $date | $label | |||
| ($dayName) {$row['Date']} | {$slotName} | {$row['Time']} | {$courseName}" . ($isExam ? " (Exam Day)" : "") . " | "; if ($isSaturday) { echo " "; } else { echo "-"; } echo " |
🚫 No schedule generated — check if valid time slots, sessions, or dates are missing.
"; } } /* if ($_SERVER['REQUEST_METHOD'] === 'POST') { $Program_ID = intval($_POST['Program_ID']); $Group_ID = intval($_POST['Group_ID']); $Start_Date = $_POST['Start_Date']; $End_Date = $_POST['End_Date'] ?? ''; $Divide_Evenly = isset($_POST['Divide_Evenly']); $selectedCourses = $_POST['Selected_Courses'] ?? []; $courseSessions = $_POST['Course_Sessions'] ?? []; $priorityCourses = $_POST['Priority_Course'] ?? []; $group = get_group_info($mysqli, $Group_ID); if (!$group) { echo "Group info not found."; exit; } $classDays = explode(',', $group['class_days']); if (!$group['Weekend_Class'] && in_array('Saturday', $classDays)) { $classDays = array_filter($classDays, fn($day) => $day !== 'Saturday'); } $slotLabels = explode(',', $group['Time_Slot']); $managerStart = new DateTime(trim($group['Time_From'])); $managerEnd = new DateTime(trim($group['Time_To'])); list($timeFrom, $timeTo) = fetch_slot_times($mysqli, $slotLabels, $managerStart, $managerEnd); $sessionLength = calculate_session_length($timeFrom, $timeTo); $courseSessions = calculate_course_sessions($mysqli, $Program_ID, $sessionLength); $holidayDates = get_holidays($mysqli, $Start_Date); $retakeDates = get_retake_dates($mysqli, $Program_ID, $Group_ID); $validDates = generate_valid_dates($Start_Date, $End_Date, $classDays, $holidayDates, $retakeDates); echo ""; print_r($validDates); echo ""; // Continue with full scheduling logic... $totalSessionsNeeded = array_sum($courseSessions); $availableDays = count($validDates); // Estimate sessions per day (based on number of slots) $sessionsPerDay = count($slotLabels); // Calculate how many days are needed to finish all sessions $daysRequired = ceil($totalSessionsNeeded / $sessionsPerDay); // Get expected end date $expectedEndDate = $validDates[$daysRequired - 1] ?? end($validDates); // fallback to last available if out of bounds echo "
$expectedEndDate (" . (new DateTime($expectedEndDate))->format('l') . ")
"; // Sort by course priority usort($selectedCourses, function ($a, $b) use ($priorityCourses) { $priorityA = $priorityCourses[$a] ?? PHP_INT_MAX; $priorityB = $priorityCourses[$b] ?? PHP_INT_MAX; return $priorityA <=> $priorityB; }); echo ""; print_r($selectedCourses); echo ""; // Prepare for fair scheduling (one course per slot) // Initialize $schedule = []; $remainingSessions = []; foreach ($selectedCourses as $courseID) { $remainingSessions[$courseID] = $courseSessions[$courseID] ?? 0; } // Queue of all courses $courseQueue = $selectedCourses; $currentCourses = [ 0 => null, // Slot 1 (e.g. Morning) 1 => null // Slot 2 (e.g. Afternoon) ]; // Assign initial two courses // Assign initial courses to slots without repeating $courseQueueCopy = $selectedCourses; $assignedCourses = []; foreach ([0, 1] as $slotIndex) { foreach ($courseQueueCopy as $courseID) { if (!in_array($courseID, $assignedCourses) && $remainingSessions[$courseID] > 0) { $currentCourses[$slotIndex] = $courseID; $assignedCourses[] = $courseID; break; } } } // Fetch all course names into array $courseNames = []; $courseRes = $mysqli->query("SELECT Course_ID, Course_Name FROM Courses"); while ($row = $courseRes->fetch_assoc()) { $courseNames[$row['Course_ID']] = $row['Course_Name']; } foreach ($validDates as $date) { $totalSessions = $courseSessions; // Copy of original sessions foreach ([0, 1] as $slotIndex) { $from = $timeFrom[$slotIndex] ?? null; $to = $timeTo[$slotIndex] ?? null; if (!$from || !$to || !$currentCourses[$slotIndex]) continue; $courseID = $currentCourses[$slotIndex]; $courseName = $courseNames[$courseID] ?? "Course #$courseID"; // Schedule the session $schedule[] = [ 'Date' => $date, 'Slot' => "Slot " . ($slotIndex + 1), 'Time' => format_time_slot_range($slotLabels[$slotIndex], $from, $to, (new DateTime($date))->format('l')), 'Course_ID' => $courseID ]; // Session info $scheduledSoFar = $totalSessions[$courseID] - $remainingSessions[$courseID] + 1; $total = $totalSessions[$courseID]; echo "
✅ Scheduled $courseName (Course ID: $courseID) on $date (Slot " . ($slotIndex + 1) . ") — Session $scheduledSoFar of $total
"; // Decrease remaining $remainingSessions[$courseID]--; // If finished, pull a new course if ($remainingSessions[$courseID] <= 0) { $currentCourses[$slotIndex] = null; while (!empty($courseQueue)) { $nextCourse = array_shift($courseQueue); if ($remainingSessions[$nextCourse] > 0) { $currentCourses[$slotIndex] = $nextCourse; break; } } } } // Stop if both slots are out of courses if (!$currentCourses[0] && !$currentCourses[1]) break; } // 🔍 Identify last scheduled session for each course $lastSessions = []; foreach ($schedule as $index => $entry) { $courseID = $entry['Course_ID']; $lastSessions[$courseID] = $index; // keeps overwriting until the last index } echo ""; print_r($schedule); echo ""; echo "
Group: " . htmlspecialchars($groupName) . "
"; if (!empty($schedule)) { // Collect all displayed dates: scheduled, holidays, and retakes $displayDates = []; // 1. From scheduled sessions foreach ($schedule as $row) { $displayDates[$row['Date']][] = $row; // grouped by date } // 2. Add holidays (if no course scheduled on them) foreach ($holidayDates as $hDate) { if (!isset($displayDates[$hDate])) { $displayDates[$hDate] = []; // will be handled below } } // 3. Add retakes foreach ($retakeDates as $rDate) { if (!isset($displayDates[$rDate])) { $displayDates[$rDate] = []; // will be handled below } } // Sort the dates chronologically ksort($displayDates); // Full scheduling logic should calculate this displayDates array echo ""; echo "| Date | Slot | Time | Course | Action |
|---|---|---|---|---|
| $date | $label | |||
| ($dayName) {$row['Date']} | {$slotName} | {$row['Time']} | {$courseName}" . ($isExam ? " (Exam Day)" : "") . " | "; if ($isSaturday) { echo " "; } else { echo "-"; } echo " |
🚫 No schedule generated — check if valid time slots, sessions, or dates are missing.
"; } } */ /* echo ""; */ ?>