<?php 

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

class Report_model extends CI_Model
{
    public function __construct() {
        parent::__construct();    
    }

    public function record_count($range_arr,$search_txt) {      
		$this->db->select('*');
		$this->db->from('video_logs');  
		$this->db->join('users', 'users.id = video_logs.user_id','left');  
		$this->db->join('courses', 'courses.id = video_logs.course_id','left');  				
		if(count($range_arr)==0)	
		{
			$this->db->like('video_logs.created_at',date('Y-m-d'));      
		}
		else
		{
			if($range_arr[0]==$range_arr[1])
			{
				$this->db->like('video_logs.created_at',date('Y-m-d', strtotime($range_arr[0])));       
			}
			else
			{
				$this->db->where('video_logs.created_at BETWEEN "'. date('Y-m-d', strtotime($range_arr[0])). '" AND "'. date('Y-m-d', strtotime($range_arr[1])).'"');
			}
			
		}
		if($search_txt !='')
		{
			$this->db->where("( `users.username` LIKE '%$search_txt%' OR `courses.course` LIKE '%$search_txt%' 
			OR `video_logs.user_id` LIKE '%$search_txt%' OR `video_logs.filename` LIKE '%$search_txt%'
			OR `video_logs.size` LIKE '%$search_txt%' OR `video_logs.created_at` LIKE '%$search_txt%')");   				
		}
		$query = $this->db->get();		
        return $query->num_rows();  
    }

    public function fetch_logs($limit, $start,$range_arr,$search_txt) 
	{
		$this->db->select('video_logs.*,users.id as user_id,users.username,courses.course');   
		$this->db->from('video_logs');  
		$this->db->join('users', 'users.id = video_logs.user_id','left');  
		$this->db->join('courses', 'courses.id = video_logs.course_id','left'); 
		if(count($range_arr)==0)	
		{
			$this->db->like('video_logs.created_at',date('Y-m-d'));      			
		}
		else
		{
			if($range_arr[0]==$range_arr[1])
			{
				$this->db->like('video_logs.created_at',date('Y-m-d', strtotime($range_arr[0])));       
			}
			else
			{
				$this->db->where('video_logs.created_at BETWEEN "'. date('Y-m-d', strtotime($range_arr[0])). '" AND "'. date('Y-m-d', strtotime($range_arr[1])).'"');
			}
		}
		if($search_txt !='')
		{
			$this->db->where("( `users.username` LIKE '%$search_txt%' OR `courses.course` LIKE '%$search_txt%' 
			OR `video_logs.user_id` LIKE '%$search_txt%' OR `video_logs.filename` LIKE '%$search_txt%'
			OR `video_logs.size` LIKE '%$search_txt%' OR `video_logs.created_at` LIKE '%$search_txt%')");  				
		}
        $this->db->limit($limit, $start);
        $query = $this->db->get();  

        if ($query->num_rows() > 0) 
		{
            return $query->result();   
        }
        return false;
   }
   
    public function logs_parameters($range_arr,$search_txt) 
	{
		$this->db->select('COUNT(DISTINCT video_logs.user_id) as user_count,COUNT(video_logs.id) as log_count,SUM(video_logs.size) as data_download');   
		$this->db->from('video_logs');  
		$this->db->join('users', 'users.id = video_logs.user_id','left');  
		$this->db->join('courses', 'courses.id = video_logs.course_id','left');    
		if(count($range_arr)==0)	  
		{
			$this->db->like('video_logs.created_at',date('Y-m-d'));      			
		}
		else
		{
			if($range_arr[0]==$range_arr[1])
			{
				$this->db->like('video_logs.created_at',date('Y-m-d', strtotime($range_arr[0])));       
			}
			else
			{
				$this->db->where('video_logs.created_at BETWEEN "'. date('Y-m-d', strtotime($range_arr[0])). '" AND "'. date('Y-m-d', strtotime($range_arr[1])).'"');
			}
		}	
        if($search_txt !='')
		{
			$this->db->where("( `users.username` LIKE '%$search_txt%' OR `courses.course` LIKE '%$search_txt%' 
			OR `video_logs.user_id` LIKE '%$search_txt%' OR `video_logs.filename` LIKE '%$search_txt%'
			OR `video_logs.size` LIKE '%$search_txt%' OR `video_logs.created_at` LIKE '%$search_txt%')");  				
		}
        $query = $this->db->get();  

        if ($query->num_rows() > 0) 
		{
            return $query->result();   		
        }
        return false;  
	}   	

}