<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Overview extends NS_Controller
{
    public 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();
    }

    public 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);
    }

    public function courseOverview()
    {
        $this->continueIfAllowed(array('allowed' => array('admin','teacher','parent','student','group')));
        $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']."\",\"Locked\":\"".$row['LessonLocked']."\",\"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;
    }
}