'error',
'message' => 'Method not allowed'
]));
}
$program_id = intval($_POST['program_id'] ?? 0);
$group_id = intval($_POST['group_id'] ?? 0);
$course_id = intval($_POST['course_id'] ?? 0);
$reserve_course = intval($_POST['reserve_course'] ?? -1);
if (!$program_id || !$group_id || !$course_id || ($reserve_course !== 0 && $reserve_course !== 1)) {
http_response_code(400);
exit(json_encode([
'status' => 'error',
'message' => 'Invalid input'
]));
}
// --- Update Schedule_Course_for_Group ---
$stmt1 = $mysqli->prepare("
UPDATE `Schedule_Course_for_Group`
SET `Reserve_Course` = ?, `Last_Updated` = NOW()
WHERE `Program_ID` = ?
AND `Group_ID` = ?
AND `Course_ID` = ?
");
$stmt1->bind_param('iiii', $reserve_course, $program_id, $group_id, $course_id);
// --- Update Course_Group_Schedule_Main ---
$stmt2 = $mysqli->prepare("
UPDATE `Course_Group_Schedule_Main`
SET `Reserve_Course` = ?, `Last_Updated` = NOW()
WHERE `Program_ID` = ?
AND `Group_ID` = ?
AND `Course_ID` = ?
");
$stmt2->bind_param('iiii', $reserve_course, $program_id, $group_id, $course_id);
// Execute both updates
$ok1 = $stmt1->execute();
$ok2 = $stmt2->execute();
if ($ok1 && $ok2) {
echo json_encode(['status'=>'success']);
} else {
http_response_code(500);
echo json_encode([
'status' => 'error',
'message' => 'Update failed: ' .
($stmt1->error ?: '') . ' ' . ($stmt2->error ?: '')
]);
}
$stmt1->close();
$stmt2->close();