classdefs.php

<?php
class Student
{
    private $id;
    private $name;
    private $teachers;
    private $year;
    private $classes;
    private $parents;

    public function __construct(int $id)
    {
        $this->id = $id;
        //set teachers, year, classes, parents to empty arrays 
        $this->teachers = array();
        $this->classes = array();
        $this->parents = array();
    }
    public function update()
    {
        $id = $this->id;
        $classid = "";
        $teacherid = "";
        $parentid = "";
        //sql for name
        $sql = "SELECT Name FROM Student WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->name);
        $stmt->fetch();
        $stmt->close();

        //sql for classes
        $sql = "SELECT Class FROM StudentClass WHERE Student=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($classid);
        $this->classes = array();
        while ($stmt->fetch()) {
            $this->classes[] = $classid;
        }
        $stmt->close();
        //sql for teachers, where the teacher is teaching a class the student is in
        $sql = "SELECT Teacher FROM TeacherClass WHERE Class IN (SELECT Class FROM StudentClass WHERE Student=?)";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($teacherid);
        $this->teachers = array();
        while ($stmt->fetch()) {
            $this->teachers[] = $teacherid;
        }
        $stmt->close();
        //sql for parents
        $sql = "SELECT Parent FROM ParentStudent WHERE Student=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($parentid);
        $this->parents = array();
        while ($stmt->fetch()) {
            $this->parents[] = $parentid;
        }
        $stmt->close();
        //sql for year
        $sql = "SELECT YearGroup FROM Student WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->year);
        $stmt->fetch();
        $stmt->close();
    }
    public function getName()
    {
        return $this->name;
    }
    public function getClasses()
    {
        return $this->classes;
    }
    public function getTeachers()
    {
        return $this->teachers;
    }
    public function getParents()
    {
        return $this->parents;
    }
    public function getId(): int
    {
        return $this->id;
    }
    public function getYear()
    {
        return $this->year;
    }
    public function setName($name)
    {
        $this->name = $name;
    }
    public function setClasses($classes)
    {
        $this->classes = $classes;
    }
    public function addClass($class)
    {
        $this->classes[] = $class;
    }
    public function addParent($parent)
    {
        $this->parents[] = $parent;
    }
    public function addTeacher($teacher)
    {
        $this->teachers[] = $teacher;
    }
    public function setTeachers($teachers)
    {
        $this->teachers = $teachers;
    }
    public function setParents($parents)
    {
        $this->parents = $parents;
    }
    public function setYear($year)
    {
        $this->year = $year;
    }
}
class Teacher
{
    private $id;
    private $name;
    private $account;
    private $pastoral;
    private $classes;
    private $students;
    private $parents;

    public function __construct(int $id)
    {
        $this->id = $id;
        //set classes, students, parents to empty arrays
        $this->classes = array();
        $this->students = array();
        $this->parents = array();
    }
    public function update()
    {
        $id = $this->id;
        $classid = "";
        $studentid = "";
        $parentid = "";

        //sql for name
        $sql = "SELECT Name, Pastoral FROM Teacher WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->name, $this->pastoral);
        $stmt->fetch();
        $stmt->close();

        //sql for classes
        $sql = "SELECT Class FROM TeacherClass WHERE Teacher=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($classid);
        $this->classes = array();
        while ($stmt->fetch()) {
            $this->classes[] = $classid;
        }
        $stmt->close();
        //sql for students, where the student is in a class the teacher is teaching
        $sql = "SELECT Student FROM StudentClass WHERE Class IN (SELECT Class FROM TeacherClass WHERE Teacher=?)";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($studentid);
        $this->students = array();
        while ($stmt->fetch()) {
            $this->students[] = $studentid;
        }
        $stmt->close();
        //sql for parents
        $sql = "SELECT Parent FROM ParentStudent WHERE Student IN (SELECT Student FROM StudentClass WHERE Class IN (SELECT Class FROM TeacherClass WHERE Teacher=?))";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($parentid);
        $this->parents = array();
        while ($stmt->fetch()) {
            $this->parents[] = $parentid;
        }
        $stmt->close();
        //sql for accountid
        $sql = "SELECT UserID FROM Teacher WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->account);
        $stmt->fetch();
        $stmt->close();
    }
    public function getName()
    {
        return $this->name;
    }
    public function getPastoral()
    {
        return $this->pastoral;
    }
    public function getAccount()
    {
        return $this->account;
    }
    public function getClasses()
    {
        return $this->classes;
    }
    public function getStudents()
    {
        return $this->students;
    }
    public function getID()
    {
        return $this->id;
    }
    public function getParents()
    {
        return $this->parents;
    }
    public function setName($name)
    {
        $this->name = $name;
    }
    public function setPastoral($pastoral)
    {
        $this->pastoral = $pastoral;
    }
    public function setClasses($classes)
    {
        $this->classes = $classes;
    }
    public function setStudents($students)
    {
        $this->students = $students;
    }
    public function setAccount($account)
    {
        $this->account = $account;
    }
    public function addClass($class)
    {
        $this->classes[] = $class;
    }
    public function addStudent($student)
    {
        $this->students[] = $student;
    }
    public function addParent($parent)
    {
        $this->parents[] = $parent;
    }
    public function setParents($parents)
    {
        $this->parents = $parents;
    }
}
class Parent_
{
    private $id;
    private $name;
    private $students;
    private $classes;
    private $account;
    private $teachers;

    public function __construct(int $id)
    {
        $this->id = $id;
        //set students, classes, teachers to empty arrays
        $this->students = array();
        $this->classes = array();
        $this->teachers = array();
    }
    public function update()
    {
        $id = $this->id;
        $studentid = "";
        $classid = "";
        $teacherid = "";
        //sql for name
        $sql = "SELECT Name FROM Parent WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->name);
        $stmt->fetch();
        $stmt->close();
        //sql for accountid
        $sql = "SELECT UserID FROM Parent WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->account);
        $stmt->fetch();
        $stmt->close();

        //sql for students
        $sql = "SELECT Student FROM ParentStudent WHERE Parent=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($studentid);
        $this->students = array();
        while ($stmt->fetch()) {
            $this->students[] = $studentid;
        }
        $stmt->close();
        //sql for classes
        $sql = "SELECT Class FROM StudentClass WHERE Student IN (SELECT Student FROM ParentStudent WHERE Parent=?)";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($classid);
        $this->classes = array();
        while ($stmt->fetch()) {
            $this->classes[] = $classid;
        }
        $stmt->close();
        //sql for teachers
        //some unholy sql, idk how to do it better
        $sql = "SELECT Teacher FROM TeacherClass WHERE Class IN (SELECT Class FROM StudentClass WHERE Student IN (SELECT Student FROM ParentStudent WHERE Parent=?))";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($teacherid);
        $this->teachers = array();
        while ($stmt->fetch()) {
            $this->teachers[] = $teacherid;
        }
        $stmt->close();
    }
    public function getName()
    {
        return $this->name;
    }
    public function getStudents()
    {
        return $this->students;
    }
    public function getID()
    {
        return $this->id;
    }
    public function getClasses()
    {
        return $this->classes;
    }
    public function getTeachers()
    {
        return $this->teachers;
    }
    public function getAccount()
    {
        return $this->account;
    }
    public function setName($name)
    {
        $this->name = $name;
    }
    public function setStudents($students)
    {
        $this->students = $students;
    }
    public function setClasses($classes)
    {
        $this->classes = $classes;
    }
    public function setTeachers($teachers)
    {
        $this->teachers = $teachers;
    }
    public function setAccount($account)
    {
        $this->account = $account;
    }
    public function addStudent($student)
    {
        $this->students[] = $student;
    }
    public function addClass($class)
    {
        $this->classes[] = $class;
    }
    public function addTeacher($teacher)
    {
        $this->teachers[] = $teacher;
    }
}
class Class_
{
    private $id;
    private $name;
    private $students;
    private $teachers;
    private $parents;

    public function __construct(int $id)
    {
        $this->id = $id;
        //set students, teachers, parents to empty arrays
        $this->students = array();
        $this->teachers = array();
        $this->parents = array();
    }
    public function update()
    {
        $id = $this->id;
        $studentid = "";
        $teacherid = "";
        $parentid = "";
        //sql for name
        $sql = "SELECT Name FROM Class WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->name);
        $stmt->fetch();
        $stmt->close();

        //sql for students
        $sql = "SELECT Student FROM StudentClass WHERE Class=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($studentid);
        $this->students = array();
        while ($stmt->fetch()) {
            $this->students[] = $studentid;
        }
        $stmt->close();
        //sql for teachers
        $sql = "SELECT Teacher FROM TeacherClass WHERE Class=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($teacherid);
        $this->teachers = array();
        while ($stmt->fetch()) {
            $this->teachers[] = $teacherid;
        }
        $stmt->close();
        //sql for parents
        $sql = "SELECT Parent FROM ParentStudent WHERE Student IN (SELECT Student FROM StudentClass WHERE Class=?)";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($parentid);
        $this->parents = array();
        while ($stmt->fetch()) {
            $this->parents[] = $parentid;
        }
        $stmt->close();
    }
    public function getName()
    {
        return $this->name;
    }
    public function getStudents()
    {
        return $this->students;
    }
    public function getTeachers()
    {
        return $this->teachers;
    }
    public function getID()
    {
        return $this->id;
    }
    public function getParents()
    {
        return $this->parents;
    }
    public function setName($name)
    {
        $this->name = $name;
    }
    public function setStudents($students)
    {
        $this->students = $students;
    }
    public function setTeachers($teachers)
    {
        $this->teachers = $teachers;
    }
    public function setParents($parents)
    {
        $this->parents = $parents;
    }
    public function addStudent($student)
    {
        $this->students[] = $student;
    }
    public function addTeacher($teacher)
    {
        $this->teachers[] = $teacher;
    }
    public function addParent($parent)
    {
        $this->parents[] = $parent;
    }
}
class Account
{
    private $id;
    private $name;
    private $email;
    private $resettoken;
    private $resettokensenttime;
    private $admin;
    private $phone;
    private $password;
    private $teacherid;
    private $parentid;
    public function __construct(int $id)
    {
        $this->id = $id;
    }
    public function update()
    {
        $id = $this->id;
        //sql for username
        $sql = "SELECT Email, Password, ResetToken, ResetEmailSentTime, Admin FROM User WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->email, $this->password, $this->resettoken, $this->resettokensenttime, $this->admin);
        $stmt->fetch();
        $stmt->close();
        //sql for teacherid
        $sql = "SELECT ID FROM Teacher WHERE UserID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->teacherid);
        $stmt->fetch();
        $stmt->close();
        //sql for parentid
        $sql = "SELECT ID FROM Parent WHERE UserID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->parentid);
        $stmt->fetch();
        $stmt->close();
        //sql for phone
        $sql = "SELECT Phone FROM User WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->phone);
        $stmt->fetch();
        $stmt->close();
        //sql for name
        $sql = "SELECT Name FROM User WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->name);
        $stmt->fetch();
        $stmt->close();
    }
    public function getName()
    {
        return $this->name;
    }
    public function getEmail()
    {
        return $this->email;
    }
    public function getPassword()
    {
        return $this->password;
    }
    public function getID()
    {
        return $this->id;
    }
    public function getTeacherID()
    {
        return $this->teacherid;
    }
    public function getParentID()
    {
        return $this->parentid;
    }
    public function getPhone()
    {
        return $this->phone;
    }
    public function getAdmin()
    {
        return $this->admin;
    }
    public function getResetToken()
    {
        return $this->resettoken;
    }
    public function getResetEmailSentTime()
    {
        return $this->resettokensenttime;
    }
    public function setResetToken($token)
    {
        $this->resettoken = $token;
    }
    public function setResetEmailSentTime($time)
    {
        $this->resettokensenttime = $time;
    }
    public function setName($name)
    {
        $this->name = $name;
    }
    public function setEmail($email)
    {
        $this->email = $email;
    }
    public function setPassword($password)
    {
        $this->password = $password;
    }
    public function setTeacherID($teacherid)
    {
        $this->teacherid = $teacherid;
    }
    public function setParentID($parentid)
    {
        $this->parentid = $parentid;
    }
    public function setPhone($phone)
    {
        $this->phone = $phone;
    }
    public function setAdmin($admin)
    {
        $this->admin = $admin;
    }
}

class Event
{
    private $id;
    private $name;
    private $openTime;
    private $closeTime;
    private $startTime;
    private $endTime;
    private $slotDuration;
    private $year;
    private $classes;
    private $teachers;
    private $status;
    private $ParentBounds;
    public function __construct(int $id)
    {
        $this->id = $id;
    }
    public function update()
    {
        $id = $this->id;
        $classid = -1;
        $teacherid = -1;
        //sql for name
        $sql = "SELECT Name, StartTime, EndTime, OpenTime, CloseTime, SlotDuration, YearGroup, CStatus, ParentBounds FROM Event WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($this->name, $this->startTime, $this->endTime, $this->openTime, $this->closeTime, $this->slotDuration, $this->year, $this->status, $this->ParentBounds);
        $stmt->fetch();
        $stmt->close();
        //sql for classes get class IDs from EventClass
        $sql = "SELECT Class, Teacher FROM EventClass WHERE EventID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->bind_result($classid, $teacherid);
        $this->classes = array();
        while ($stmt->fetch()) {
            $this->classes[] = $classid;
            $this->teachers[] = $teacherid;
        }
        $stmt->close();
    }
    public function getName()
    {
        return $this->name;
    }
    public function getStartTime()
    {
        return $this->startTime;
    }
    public function getEndTime()
    {
        return $this->endTime;
    }
    public function getOpenTime()
    {
        return $this->openTime;
    }
    public function getCloseTime()
    {
        return $this->closeTime;
    }
    public function getSlotDuration()
    {
        return $this->slotDuration;
    }
    public function getYear()
    {
        return $this->year;
    }
    public function getClasses()
    {
        return $this->classes;
    }
    public function getTeachers()
    {
        return $this->teachers;
    }
    public function getID()
    {
        return $this->id;
    }
    public function getStatus()
    {
        return $this->status;
    }
    public function getParentBounds()
    {
        return $this->ParentBounds;
    }
    public function isBookOpen()
    {
        $ttime = new DateTime($this->openTime);
        $ctime = new DateTime($this->closeTime);
        $ntime = new DateTime();
        if ($ntime > $ttime && $ntime < $ctime && ($this->status == null || $this->status == 0)) {
            return true;
        }
        return false;
    }
    public function isBooked(){
        return $this->status == 4;
    }
    public function setName($name)
    {
        $this->name = $name;
    }
    public function setClasses($classes)
    {
        $this->classes = $classes;
    }
    public function setTeachers($teachers)
    {
        $this->teachers = $teachers;
    }
    public function addClass($class)
    {
        $this->classes[] = $class;
    }
    public function setStartTime($startTime)
    {
        $this->startTime = $startTime;
    }
    public function setEndTime($endTime)
    {
        $this->endTime = $endTime;
    }
    public function setOpenTime($openTime)
    {
        $this->openTime = $openTime;
    }
    public function setCloseTime($closeTime)
    {
        $this->closeTime = $closeTime;
    }
    public function setSlotDuration($slotDuration)
    {
        $this->slotDuration = $slotDuration;
    }
    public function setYear($year)
    {
        $this->year = $year;
    }
}
class PrefSlot
{
    private $id;
    private $StartTime;
    private $EndTime;
    private $Teacher;
    private $Event;
    private $Class;
    private $Student;
    private $Parent;

    public function __construct(int $id)
    {
        $this->id = $id;
    }
    public function update()
    {
        $id = $this->id;
        //sql for start time
        $sql = "SELECT StartTime, EndTime, Teacher, EventID, Class, Student, Parent FROM PrefferedTime WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        //bind results to variables
        $stmt->bind_result($this->StartTime, $this->EndTime, $this->Teacher, $this->Event, $this->Class, $this->Student, $this->Parent);
        $stmt->fetch();
        $stmt->close();
    }
    public function getStartTime()
    {
        return $this->StartTime;
    }
    public function getEndTime()
    {
        return $this->EndTime;
    }
    public function getTeacher()
    {
        return $this->Teacher;
    }
    public function getEvent()
    {
        return $this->Event;
    }
    public function getClass()
    {
        return $this->Class;
    }
    public function getStudent()
    {
        return $this->Student;
    }
    public function getParent()
    {
        return $this->Parent;
    }
    public function getID()
    {
        return $this->id;
    }
    public function setStartTime($StartTime)
    {
        $this->StartTime = $StartTime;
    }
    public function setEndTime($EndTime)
    {
        $this->EndTime = $EndTime;
    }
    public function setTeacher($Teacher)
    {
        $this->Teacher = $Teacher;
    }
    public function setEvent($Event)
    {
        $this->Event = $Event;
    }
    public function setClass($Class)
    {
        $this->Class = $Class;
    }
    public function setStudent($Student)
    {
        $this->Student = $Student;
    }
    public function setParent($Parent)
    {
        $this->Parent = $Parent;
    }
}

class Slot
{
    private $id;
    private $StartTime;
    private $Year;
    private $Duration;
    private $Teacher;
    private $Event;
    private $Class;
    private $Student;
    private $Parent;
    private $TeacherName;
    private $ClassName;

    public function __construct(int $id)
    {
        $this->id = $id;
    }
    public function update()
    {
        $id = $this->id;
        //sql for start time
        $sql = "SELECT StartTime, YearGroup, Duration, Teacher, EventID, Class, Student, Parent, TeacherName, ClassName FROM Slot WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $id);
        $stmt->execute();
        //bind results to variables
        $stmt->bind_result($this->StartTime, $this->Year, $this->Duration, $this->Teacher, $this->Event, $this->Class, $this->Student, $this->Parent, $this->TeacherName, $this->ClassName);
        $stmt->fetch();
        $stmt->close();
        //sql for teacher name
        $tempTeacherName = null;
        $sql = "SELECT Name FROM Teacher WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $this->Teacher);
        $stmt->execute();
        $stmt->bind_result($tempTeacherName);
        $stmt->fetch();
        $stmt->close();
        //if teacher name is null leave as 
        if ($tempTeacherName != null) {
            $this->TeacherName = $tempTeacherName;
        }
        //sql for class name
        $tempClassName = null;
        $sql = "SELECT Name FROM Class WHERE ID=?";
        $stmt = $GLOBALS['db']->prepare($sql);
        $stmt->bind_param("i", $this->Class);
        $stmt->execute();
        $stmt->bind_result($tempClassName);
        $stmt->fetch();
        $stmt->close();
        //if class name is null leave as
        if ($tempClassName != null) {
            $this->ClassName = $tempClassName;
        }
    }
    public function getStartTime()
    {
        return $this->StartTime;
    }
    public function getYear()
    {
        return $this->Year;
    }
    public function getDuration()
    {
        return $this->Duration;
    }
    public function getTeacher()
    {
        return $this->Teacher;
    }
    public function getEventID()
    {
        return $this->Event;
    }
    public function getClass()
    {
        return $this->Class;
    }
    public function getStudent()
    {
        return $this->Student;
    }
    public function getParent()
    {
        return $this->Parent;
    }
    public function getID()
    {
        return $this->id;
    }
    public function getTeacherName()
    {
        return $this->TeacherName;
    }
    public function getClassName()
    {
        return $this->ClassName;
    }
    public function setStartTime($StartTime)
    {
        $this->StartTime = $StartTime;
    }
    public function setYear($Year)
    {
        $this->Year = $Year;
    }
    public function setDuration($Duration)
    {
        $this->Duration = $Duration;
    }
    public function setTeacher($Teacher)
    {
        $this->Teacher = $Teacher;
    }
    public function setEventID($Event)
    {
        $this->Event = $Event;
    }
    public function setClass($Class)
    {
        $this->Class = $Class;
    }
    public function setStudent($Student)
    {
        $this->Student = $Student;
    }
    public function setParent($Parent)
    {
        $this->Parent = $Parent;
    }
    public function setTeacherName($TeacherName)
    {
        $this->TeacherName = $TeacherName;
    }
    public function setClassName($ClassName)
    {
        $this->ClassName = $ClassName;
    }
}