<?php

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

class Lesson_model extends CI_Model {

    function __construct() {
        parent::__construct();
        $this->load->database();
    }
    function clear_cache() {
        $this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
        $this->output->set_header('Pragma: no-cache');
    }
    function approve_creation($date){
      $date = new DateTime($date);
      $now = (new \DateTime())->modify('-1 day');
      if($date < $now) {
          return false;//false
      }
      return true;
    }
    function approve_suppression($date){
      $date = (new \DateTime($date))->modify('+1 month');;
      //return $date;
      $now = (new \DateTime())->modify('+1 day');
      if($date < $now) {
          return false;
      }
      return true;
    }
    function check_collision($id,$date,$start,$end){
      $query = $this->db->get_where('course_scheduled_new', array('CourseID' => $id,'LessonDate' => $date));
      $query = $query->result_array();
      //return $query;
      if(empty($query)){
        return false;
      }
      foreach ($query as $row) {
        if($row['LessonStart'] >= $start && $row['LessonEnd'] <= $end){
          return true;
        }
        else if($row['LessonEnd'] > $start){
          return true;
        }
        else if($row['LessonStart'] < $end){
          return true;
        }
        else{
          //
        }
      }
      return false;
    }
    function allow_presence($dateArray){

    }
}