function addTransferredTeacher(Teacher $teacher)
{
$connectionObject = Connection::getInstance();
$connection = $connectionObject->get_connection();
$teacher_id = $teacher->getTeacherId();
$registered_date = $teacher->getRegisteredDate();
$distance = $teacher->getDistance();
$school_id = $_SESSION['school_id'];
$stmt = $connection->prepare("INSERT INTO teacher_school (teacher_id,school_id,start_of_working_date,distance_from_permanent_residence) VALUES (?,?,?,?)");
echo "INSERT INTO teacher_school (teacher_id,school_id,start_of_working_date,distance_from_permanent_residence) VALUES ({$teacher_id},{$school_id},{$registered_date},{$distance})";
$stmt->bind_param("iisi", $teacher_id, $school_id, $registered_date, $distance);
$result = $stmt->execute();
$stmt->close();
return $result;
}
$address = $_POST['address'];
$distance = $_POST['distance'];
$contact_number = $_POST['contact_number'];
$teacher = new Teacher($address, $distance, $name, $contact_number, $registered_date, $subject);
$teacherController = new TeacherController();
$teacherController->addTeacher($teacher);
include "add_transferred_student.php";
} elseif (isset($_POST['add_transferred_teacher'])) {
$teacher_id = $_POST['teachersforschool'];
$name = "";
$registered_date = $_POST['date'];
$subject = "";
$address = "";
$contact_number = "";
$distance = $_POST['distance'];
$teacher = new Teacher($address, $distance, $name, $contact_number, $registered_date, $subject);
$teacher->setTeacherId($teacher_id);
$teacherController = new TeacherController();
$teacherController->addTransferredTeacher($teacher);
include "add_transferred_teacher.php";
} elseif (isset($_POST['addAcademicAchievement'])) {
$student_id = $_POST["student_id"];
$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";
