/lenasys/trunk

<?php

class Codeviewer_model extends CI_Model {

	function __construct(){

		$this->load->database();

	}

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

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

		$this->db->join("pagesfiles", "pagesfiles.Files_fileName = files.fileName");

		$this->db->where("pagesfiles.Pages_name", $page);

		$this->db->where("pagesfiles.Pages_Examples_Name", $example);

		$this->db->where("pagesfiles.Pages_Examples_Courses_courseID", $cid);

		$this->db->not_like("pagesfiles.Files_fileName", $cid."/".$example."/".$page."/"."documentation");

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

		$output = "";

		foreach ($query->result() as $row) {

			$output .= '<div class="editorinfo">'.$row->language.'&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/merbivore");

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

			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>';

		}

		return $output;

	}

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

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

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

		$this->db->join("pagesfiles", "pagesfiles.Files_fileName = files.fileName");

		$this->db->where("pagesfiles.Pages_name", $page);

		$this->db->where("pagesfiles.Pages_Examples_Name", $example);

		$this->db->where("pagesfiles.Pages_Examples_Courses_courseID", $cid);

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

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

		$result = $query->result();

		return $result[0]->dataBlob;

	}

}