<?php

define('HOMEPATH', '/homepages/9/d352365589/htdocs/scheduler');
require_once(HOMEPATH.'/util/DBUtil.php');
require_once('User.php');
require_once('Course.php');

class Schedule {
	private
		$id;

	public function __construct($id) {
		$this->id = $id;
	}

	public function getID() {
		return $this->id;
	}

	public function getOwnerID() {
		$result = mysql_fetch_assoc(DBSelectSchedules("id=".$this->id));
		return $result['owner'];
	}

	public function getOwner() {
		return new User($this->getOwnerID());
	}

	public function getCourseIDs() {
		$result = DBQuery("SELECT * FROM schedule_to_course WHERE scheduleid=".$this->id);
		$courseIDs = array();
		while($row = mysql_fetch_assoc($result)) {
			$courseIDs[] = $row['courseid'];
		}
		return $courseIDs;
	}

	public function getCourses() {
		$courseIDs = $this->getCourseIDs();
		$courses = array();
		foreach($courseIDs as $courseID) {
			$courses[] = new Course($courseID);
		}
		return $courses;
	}

	public function addClass($classID) {
		DBQuery("INSERT INTO schedule_to_course VALUES (".$this->id.",".$courseID.")");
	}
}

?>