"error", "message" => "No valid Schedule IDs"]);
exit;
}
try {
$placeholders = implode(',', array_fill(0, count($ids), '?'));
$types = str_repeat('i', count($ids));
// 1. Unassign teachers for all matching schedules
$stmt1 = $mysqli->prepare("DELETE FROM teacher_course_assignments WHERE Schedule_ID IN ($placeholders)");
$stmt1->bind_param($types, ...$ids);
$stmt1->execute();
$stmt1->close();
// 2. Update schedule_course_for_group (set Assigned = 0)
$stmt2 = $mysqli->prepare("UPDATE schedule_course_for_group SET Assigned = 0 WHERE Schedule_ID IN ($placeholders)");
$stmt2->bind_param($types, ...$ids);
$stmt2->execute();
$stmt2->close();
// 3. Delete from schedule_course_for_group
$stmt3 = $mysqli->prepare("DELETE FROM schedule_course_for_group WHERE Schedule_ID IN ($placeholders)");
$stmt3->bind_param($types, ...$ids);
$stmt3->execute();
$stmt3->close();
// 4. Delete from course_group_schedule_main
$stmt4 = $mysqli->prepare("DELETE FROM course_group_schedule_main WHERE Schedule_ID IN ($placeholders)");
$stmt4->bind_param($types, ...$ids);
$stmt4->execute();
$stmt4->close();
echo json_encode(["status" => "success", "message" => "Schedule deleted. Teachers unassigned."]);
} catch (Exception $e) {
echo json_encode(["status" => "error", "message" => $e->getMessage()]);
}
}
?>