/lenasys/trunk

<?php

	Class filetree extends CI_Model

	{

		/*

		 *	Loads categories

		 */

		 function getCategories($activeCourse) {

			$this -> db -> select('categoryName');

			$this -> db -> from('Categories'); 

			$this -> db -> where('courseID', $activeCourse);

			$this -> db -> order_by('orderNr');

			$query = $this -> db -> get();

			return $query->result();

		}

		 /*

		 *	Loads subcategories

		 */

		 function getSubCategories($categoryName, $activeCourse) {

			$this -> db -> select('subCategoryName');

			$this -> db -> from('SubCategories'); 

			$this -> db -> where('categoryName', $categoryName); 

			$this -> db -> where('courseID', $activeCourse); 

			$query = $this -> db -> get();

			return $query->result();

		}

		/*

		 *	Loads examples

		 */

		 function getExamples($subCategoryName, $categoryName, $activeCourse) {

			$this -> db -> select('exampleName');

			$this -> db -> from('Examples'); 

			$this -> db -> where('subCategoryName', $subCategoryName); 

			$this -> db -> where('categoryName', $categoryName);

			$this -> db -> where('courseID', $activeCourse);

			$query = $this -> db -> get();

			return $query->result();

		}

		/*

		 *	Loads quizzes

		 */

		 function getQuizzes($subCategoryName, $categoryName, $activeCourse) {

			$this -> db -> select('quizNr');

			$this -> db -> from('Quizzes'); 

			$this -> db -> where('subCategoryName', $subCategoryName);

			$this -> db -> where('categoryName', $categoryName);

			$this -> db -> where('courseID', $activeCourse);

			$query = $this -> db -> get();

			return $query->result();

		}

		/* TODO: OLD STUFF BELOW! -------------------------------------------------------------------------------------------*/

		/* Loads category names for menu 

		function getTitles($user)

		{

			$this -> db -> select('Categories.categoryName, Categories.courseID');

			$this -> db -> from('Categories');

			$this -> db -> join('StudentCourseRegistrations', 'Categories.courseID = StudentCourseRegistrations.courseID'); 

			$this -> db -> where('StudentCourseRegistrations.username', $user); 

			$this -> db -> order_by("orderNr", "asc"); 

		/* 	$this -> db -> where('StudentCourseRegistrations.courseID', 'd1popcrn');  

		* 	Line is disabled for now because of testing purposes.

		*	Will be modified to be used with parameter in function.

		*//*

			$query = $this -> db -> get();

			return $query->result();

		}*/

		/* Loads categorys & subcategorys for body 

		function getBody($categoryName)

		{

			$this -> db -> select('subCategoryName');

			$this -> db -> from('SubCategories'); 

			$this -> db -> where('categoryName', $categoryName); 

			$query = $this -> db -> get();

			return $query->result();

		}*/

		/* Loads examples for categorys 

		function getExamples($subCategoryName)

		{

			$this -> db -> select('exampleName');

			$this -> db -> from('Examples'); 

			$this -> db -> where('subCategoryName', $subCategoryName); 

			$query = $this -> db -> get();

			return $query->result();

		}*/

	}

?>