function addAcademicAchievement(Achievement $achievement)
{
$connectionObject = Connection::getInstance();
$connection = $connectionObject->get_connection();
$student_id = $achievement->getStudentId();
$ol = $achievement->getOl();
$al = $achievement->getAl();
$achievement_case = $achievement->getAchievementCase();
$school_id = $achievement->getSchoolId();
$stmt = $connection->prepare("INSERT INTO achievement (student_id, school_id, achievement_case) VALUES (?,?,?)");
$stmt->bind_param("iis", $student_id, $school_id, $achievement_case);
echo $student_id . " " . $school_id . " " . $achievement_case;
$result = $stmt->execute();
$stmt->close();
$achievement_id = mysqli_insert_id($connection);
$stmt = $connection->prepare("INSERT INTO acadamic (achievement_id,ordinary_level,advanced_level) VALUES (?,?,?)");
$stmt->bind_param("iss", $achievement_id, $ol, $al);
$result = $stmt->execute();
$stmt->close();
return $result;
}
$ol = $_POST["ol"];
$al = $_POST["al"];
$school_id = $_SESSION['school_id'];
$achievement = new Achievement($student_id, $school_id, "Academic");
$achievement->setOl($ol);
$achievement->setAl($al);
$achievement_controller = new AchievementController();
$achievement_controller->addAcademicAchievement($achievement);
include "add_acadamic_achievement.php";
} elseif (isset($_POST['add_non_academic_achievement'])) {
$student_id = $_POST["student_id"];
$date = $_POST["date"];
$case = $_POST["case"];
$place = $_POST["place"];
$school_id = $_SESSION['school_id'];
$achievement = new Achievement($student_id, $school_id, "Non_Academic");
$achievement->setDate($date);
$achievement->setCase($case);
$achievement->setPlace($place);
$achievement_controller = new AchievementController();
$achievement_controller->addNonAcademicAchievement($achievement);
include "add_non_acadamic_achievement.php";
} elseif (isset($_POST['add_leaving_record'])) {
$school_id = $_SESSION["school_id"];
$student_id = $_POST["student_id"];
$date = $_POST["date"];
$studentController = new StudentController();
$studentController->addLeavingRecord($school_id, $student_id, $date);
include "./leaving_record.php";
} else {
include "school_index.php";
