/lenasys/trunk

<?php

/**

* This is a model. It holds the logic.

* It's loaded like this in the controllers: $this->load->model("path/to/model");

* This specific model is: $this->load->model("admin/admin_model")

*

* This model is the logic behind the admin panel. It let's you manage courses, pages etc

*/

class Admin_model extends CI_Model {

	function __construct() {

		$this->load->database();

	}

	function getCourses() {

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

		return $query->result();

	}

	function addCourse($cid, $name){

		$data = array(

			'courseID' => $cid ,

			'name' => $name

			);

		$this->db->insert('Courses', $data); 

		mkdir("../courses/".$cid);

	}

	function getMenu(){

		$menu = array();

		$courses = $this->db->get("courses");

		foreach ($courses->result() as $course) {

			$menu[$course->name] = array();

			$menu[$course->name]['CID'] = $course->courseID;

			$categories = $this->db->get_where("categories", array("courseID" => $course->courseID));

			foreach($categories->result() as $category){

				$menu[$course->name][$category->categoryName] = array();

				$subcategories = $this->db->get_where("subcategories", array("courseID" => $course->courseID, "categoryName" => $category->categoryName));

				foreach($subcategories->result() as $subcategory){

					$menu[$course->name][$category->categoryName][$subcategory->subCategoryName] = array();

				}

			}

		}

		return $menu;

	}

	function getCategories($cid) {

		$query = $this->db->get_where('Categories', array("courseID" => $cid));

		return $query->result();

	}

	function addCategory($cid, $categoryName){

		$this->db->select_max("orderNr");

		$query = $this->db->get_where('Categories', array("courseID" => $cid));

		$result = $query->result();

		$data = array(

			'courseID' => $cid ,

			'categoryName' => $categoryName,

			'orderNr' => $result[0]->orderNr+1

			);

		$this->db->insert('Categories', $data); 

		//mkdir("../courses/".$cid."/".$example);

	}

	function getSubCategories($cid, $categoryName) {

		$query = $this->db->get_where('subcategories', array("courseID" => $cid, "categoryName" => $categoryName));

		return $query->result();

	}

	function addSubCategory($cid, $categoryName, $subCategoryName){

		$this->db->select_max("orderNr");

		$query = $this->db->get_where('subcategories', array("courseID" => $cid, "categoryName" => $categoryName));

		$result = $query->result();

		$data = array(

			'courseID' => $cid ,

			'subCategoryName' => $subCategoryName,

			'categoryName' => $categoryName,

			'orderNr' => $result[0]->orderNr+1

			);

		$this->db->insert('subcategories', $data); 

		//mkdir("../courses/".$cid."/".$example);

	}

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

		$query = $this->db->get_where('Examples', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName));

		return $query->result();

	}

	function addExample($cid, $categoryName, $subCategoryName, $example, $description){

		$this->db->select_max("orderNr");

		$query = $this->db->get_where('examples', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName));

		$result = $query->result();

		$data = array(

			'courseID' => $cid ,

			'exampleName' => $example,

			'description' => $description,

			'categoryName' => $categoryName,

			'subCategoryName' => $subCategoryName,

			'orderNr' => $result[0]->orderNr+1

			);

		$this->db->insert('Examples', $data); 

		mkdir("../courses/".$cid."/".$example);

	}

	function getPages($cid, $example) {

		$query = $this->db->get_where('Pages', array("courseID" => $cid, "exampleName" => $example));

		return $query->result();

	}

	function addPage($cid, $example, $page){

		$data = array(

			'courseID' => $cid ,

			'exampleName' => $example,

			'pageName' => $page

			);

		$this->db->insert('Pages', $data); 

		mkdir("../courses/".$cid."/".$example."/".$page);

		$data = array(

			'fileName' => $cid."/".$example."/".$page."/documentation",

			'codeLanguage' => $file->lang,

			'fileType' => $file->type,

			'dataBlob' => $output

			);

		$this->db->insert('Files', $data); 

		$data = array(

			'fileName' =>  $cid."/".$example."/".$page."/documentation"  ,

			'pageName' => $page,

			'exampleName' => $example,

			'courseID' => $cid

			);

		$this->db->insert('PageFiles', $data); 

	}

	function updatePage($cid, $example, $page, $documentation, $files){

		$filearr = json_decode($files);

		foreach ($filearr as $file) {

			$output = "";

			$handle = @fopen("../courses/".$cid."/".$example."/".$page."/".$file->filename, "r");

			if ($handle) {

				while (($buffer = fgets($handle, 4096)) !== false) {

					$buffer = str_replace("&", "&", $buffer);

					$buffer = str_replace("<", "&lt;", $buffer);

					$buffer = str_replace(">", ">", $buffer);

					$output .= $buffer;

				}

				if (!feof($handle)) {

					$output .= "Error: unexpected fgets() fail\n";

				}

				fclose($handle);

			}

			$data = array(

				'fileName' => $file->filename ,

				'codeLanguage' => $file->lang,

				'fileType' => $file->type,

				'dataBlob' => $output

				);

			$this->db->insert('Files', $data); 

			$data = array(

				'fileName' =>  $file->filename  ,

				'pageName' => $page,

				'exampleName' => $example,

				'courseID' => $cid

				);

			$this->db->insert('PageFiles', $data); 

		}

		$data = array(

			'dataBlob' => $documentation

			);

		$this->db->where("fileName",$cid."/".$example."/".$page."/"."documentation" );

		$this->db->update('Files', $data); 

	}

	function uploadFile($files, $cid, $example, $page){

		if(move_uploaded_file($files['tmp_name'], "../courses/".$cid."/".$example."/".$page."/".$files['name'])){

			echo json_encode(array('status'=>'File was uploaded successfuly!'));

		}	

	}

}