<?php
/*********************
 *********************
Template : "overview.php"
Controller : "Overview.php"
 => Show course detail
 => Show lesson detail
    -> add confirm lesson
    -> add assign student
    -> add student presence
 Creation 06/05/2019
 Aernout Guillaume
 http://codes.solutions
 *********************
 *********************/
 if (!defined('BASEPATH'))
   exit('No direct script access allowed');

  class Overview extends NS_Controller {

    function __construct() {
      parent::__construct(array('no_cache'=>1));

      if ($this->session->userdata('admin_login') != 1){
        $this->error('restricted admin');
        //$this->redirect(base_url(), 'refresh');
      }
       $this->load->helper('generator');
      $this->load->model('crud_model');
       $this->load->database();
    }
    ////////////////////////
    // Fonction controller
    ////////////////////////
    function index($arg) {
        $data['page_name'] = 'overview';
        $data['page_title'] = get_phrase('overview');
        $data['course_list'] = $this->crud_model->get_courses();
        if(isset($arg)){
 				 $data['course_from_dash'] = $arg;
 			 }
        $this->load->view('backend/index', $data);
    }

    function courseOverview(){
      $this->continueIfAllowed(array('allowed'=>array('admin','teacher','parent','student')));
      $id = $this->input->post('id');
      $data = $this->crud_model->get_course($id);
      $hours = $this->crud_model->get_course_scheduled($id);

      $hourTotal = $this->crud_model->get_course_hours_total($id);
      $hourRemain = $this->crud_model->get_course_hours_remain($id);
      $hourContract = $data[0]['CourseContract'];
      $courseStart = $this->crud_model->get_course_start($id);
      $courseEnd = $this->crud_model->get_course_end($id);

      $courseStudentNb = $this->crud_model->get_students_count($id);
      $courseStundentAge = $this->crud_model->get_students_age_interval($id);

      $jsonHours = "";
      foreach ($hours as $key => $row) {
        $id = $row['ID'];
        $jsonHours = $jsonHours . "\"". $key ."\":{\"id\":\"".$id."\",".$this->crud_model->get_json_lesson_teacher($id).",".$this->crud_model->get_json_lesson_students($id).",\"studentCount\":\"".$this->crud_model->get_students_count_lesson($id)."\",\"studentAge\":\"".$this->crud_model->get_students_age_interval_lesson($id)."\",\"date\":\"".$row['LessonDate']."\",\"start\":\"".$row['LessonStart']."\",\"end\":\"".$row['LessonEnd']."\",\"name\":\"".$row['LessonName']."\",\"done\":\"".$row['CourseDone']."\",\"comment\":\"".$row['CourseComment']."\"},";
      }
      $jsonHours = "\"hours\" : {".rtrim($jsonHours,',')."}";
      $jsonData = "{ \"id\":".$id.",\"courseStart\" :\"".$courseStart."\",\"courseEnd\" :\"".$courseEnd."\"";
      $jsonData = $jsonData .", \"courseTotal\" : \"".$hourTotal."\", \"courseContract\" : \"".$hourContract."\"";
      $jsonData = $jsonData .", \"courseRemain\" : \"".$hourRemain."\",\"courseStudentNb\" : \"".$courseStudentNb."\",\"courseStudentAge\" : \"".$courseStundentAge."\"";
      $jsonData = $jsonData .",".$jsonHours."}";
      print_r($jsonData);
      //echo $jsonHours;
    }
}