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

class User extends MY_Controller {

	
    
    public function login()
	{
                $this->load->view('temp/header');
                $this->load->view('temp/login_view');
		$this->load->view('temp/footer');
	}

	public function savelogin()
	{
		$userid = $this->input->post('userid');
		$password = $this->input->post('password');
		
		$this->db->select('*');
		$this->db->where('id',$userid);
		$this->db->where('password',$password);
		$this->db->where('registered','1');
		$query = $this->db->get('users');
		
		//print_r($query->num_rows());exit;
		if($query->num_rows()>0)
		{
			$result = $query->row();
			$data = array(
					'id' =>$result->id,
					'admin_id' =>$result->admin_id,
					'username' =>$result->username,
					'email' =>$result->email,
					'registration_code' =>$result->registration_code,
					'logged_in'=>true
				);

			$this->session->set_userdata($data);
			redirect('user/video');
		}else{
			$this->session->set_flashdata('msg','<div class="alert alert-danger">Invalid Credintials</div>');
			redirect('user/login');
		}
	}

	public function video()
	{
		if(empty($_SESSION['id']))
		{
			redirect('user/login');
		}

		$_new_arr = array();
		// print_r($_SESSION);exit;
		$admin_id = $_SESSION['admin_id'];
		$id = $_SESSION['id'];
		// SELECT d.id,l.file_name,l.drobbox_video_id,d.name,d.size,d.path_lower FROM `regfiles` as r INNER JOIN lectures as l on l.id = r.lecture_id INNER JOIN dropbox_album as d on d.id = l.drobbox_video_id WHERE r.user_id = '.$id.' and l.admin_id ='.$admin_id.' AND l.e_type = "video"
		 $date = date('Y-m-d');
		$query = $this->db->query('SELECT l.file_name,l.drobbox_video_id FROM `regfiles` as r INNER JOIN lectures as l on l.id = r.lecture_id  WHERE r.user_id = '.$id.' and l.admin_id ='.$admin_id.' AND l.e_type = "video" AND DATE(r.str_dt) <="'.$date.'" AND DATE(r.end_dt) >="'.$date.'"');
		//print_r($this->db->last_query());exit;
		if($query->num_rows()>0)
		{
			$dropbox_albums= $query->result();
			foreach($dropbox_albums as $dropbox_album)
			{
				$this->db->select('filename as name,etag as id,path as path_lower,size');
		        $this->db->where('path',$dropbox_album->drobbox_video_id);
		        $query1 = $this->db->get('s3bucket');
		        if($query1->num_rows()>0)
		        {
		            $result1 = $query1->result();
		           	$new_arr = array(
		           			'file_name'=>$dropbox_album->file_name,
		           			'id'=>$result1[0]->id,
		           			'path_lower'=>$result1[0]->path_lower,
		           			'size'=>$result1[0]->size,
		           			'name'=>$result1[0]->name,
		           			// 'file_name'=>$dropbox_album->file_name,
		           	);

		           	array_push($_new_arr,$new_arr);
		        }

			}
			
			// echo "<pre>";print_r($_new_arr);exit;
		}
		$data['dropbox_albums'] = $_new_arr;
		$data['p_type'] = 'list';
		$this->load->view('videolist',$data);
	}

	public function logout()
	{
		session_destroy();
		redirect('user/login');

	}
}