/lenasys/trunk

<?php

class Codeviewer_model extends CI_Model {

	function __construct(){

		$this->load->database();

	}

	function getCode($cid, $category, $subcategory, $example) {

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

		$this->db->join("Containers", "Containers.fileName = Files.fileName");

		$this->db->where("Containers.categoryName", $category);

		$this->db->where("Containers.subcategoryName", $subcategory);

		$this->db->where("Containers.exampleName", $example);

		$this->db->where("Containers.courseID", $cid);

		//$this->db->not_like("Containers.fileName", $cid."/".$category."/".$subcategory."/".$example."/documentation");

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

		$outarr = array();

		foreach ($query->result() as $row) { //creats array with array consisting of columnNr and code file.

			$output = "";

			if($row->fileType == 'Code') {

				$output .= '<div class="editorinfo">'.$row->codeLanguage.'&nbsp;&nbsp;&nbsp;&nbsp;'.$row->fileName.'</div>';

				$output .= '<div id="ace_'.str_replace(".", "", $row->fileName).'" class="ace">';

				$output .= $row->dataBlob;

				$output .= '</div>';

				$output .=  '<script type="text/javascript">

				var Range = require("ace/range").Range;

				var editor = ace.edit("ace_'.str_replace(".", "", $row->fileName).'");

				editor.setTheme("ace/theme/eclipse");

				editor.getSession().setMode("ace/mode/'.$row->codeLanguage.'");

				editor.setReadOnly(true);

				editor.setShowPrintMargin(false);

				editor.setDisplayIndentGuides(false);

				editor.setHighlightSelectedWord(true);

				lines = editor.getSession().getLength();

				$("#ace_'.str_replace(".", "", $row->fileName).'").height(Math.min(500,lines*16));

				aceeditors.push("ace_'.str_replace(".", "", $row->fileName).'");';

				/*

				for($i = 0; $i < count($interestingrows); $i++) {

				$output .= 'editor.getSession().addMarker(new Range('.$interestingrows[$i][0].', 0, '

					.$interestingrows[$i][1].', Number.POSITIVE_INFINITY), "interesting", "text",false);';

				}

				*/

				$output .= '</script>';

				$outarr[] = array($row->columnNr,$output);

			} else if($row->fileType == 'Text') {

				$output .= $row->dataBlob;

				$outarr[] = array($row->columnNr,$output);

			}

		}

		return $outarr;

	}

	/*

	function getDoc($cid, $category, $subcategory, $example){

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

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

		$this->db->join("Containers", "Containers.fileName = Files.fileName");

		$this->db->where("Containers.categoryName", $category);

		$this->db->where("Containers.subcategoryName", $subcategory);

		$this->db->where("Containers.exampleName", $example);

		$this->db->where("Containers.courseID", $cid);

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

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

		$result = $query->result();

		return $result[0]->dataBlob;

	}*/

}