/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 ,

			'courseName' => $name

			);

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

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

	}

	function getExamples($cid) {

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

		return $query->result();

	}

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

		$data = array(

			'Courses_courseID' => $cid ,

			'Name' => $example,

			'description' => $description

			);

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

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

	}

	function getPages($cid, $example) {

		$query = $this->db->get_where('pages', array("Examples_Courses_courseID" => $cid, "Examples_Name" => $example));

		return $query->result();

	}

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

		$data = array(

			'Examples_Courses_courseID' => $cid ,

			'Examples_Name' => $example,

			'name' => $page

			);

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

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

		$data = array(

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

			'language' => $file->lang,

			'fileType' => $file->type,

			'dataBlob' => $output

			);

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

		$data = array(

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

			'Pages_name' => $page,

			'Pages_Examples_Name' => $example,

			'Pages_Examples_Courses_courseID' => $cid

			);

		$this->db->insert('pagesfiles', $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 ,

				'language' => $file->lang,

				'fileType' => $file->type,

				'dataBlob' => $output

				);

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

			$data = array(

				'Files_fileName' =>  $file->filename  ,

				'Pages_name' => $page,

				'Pages_Examples_Name' => $example,

				'Pages_Examples_Courses_courseID' => $cid

				);

			$this->db->insert('pagesfiles', $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!'));

		}	

	}

}