<?php 
/**********************************************************
	   Filename: Home
	Description: Chart view and Chart control logic developed, highchart integration based on role.
		 Author: Jaffer Sathik
	 Created on: 10-DEC-2018
	Reviewed by: Udhayakumar Anandhan (REVIEW PENDING)
	Reviewed on:
	Approved by:
	Approved on:
	-------------------------------------------------------
	Modification Details: HIGHCHARTS
	Modification Date: 06/12/2019
	Changed by: SVK AND NEHA
	Change Info: HIGHCHARTS
	-------------------------------------------------------
***********************************************************/
if ( ! defined('BASEPATH')) exit('No direct script access allowed');
require_once("Action_controller.php");
class Home extends Action_controller {
	public function __construct(){		
		parent::__construct();
		$this->load->model("Homemodel");		
		$this->logged_id       = $this->session->userdata('logged_id');
		$this->logged_role     = $this->session->userdata('logged_role');
		$this->collect_base_info();
	}
	
	public function logout(){
		$this->session->sess_destroy();
		redirect('login');
	}
	
	//FOR UNAUTHORIZED LOGIN !
	public function unauthorized(){
    	$logged_id          = $this->session->userdata('logged_id');
    	$random_number      = $this->GenerateRandomNumber();
		$update_qry = 'UPDATE cw_employees SET PASSWORD = "'.$random_number.'", trans_status = 0 WHERE prime_employees_id = "'.$logged_id.'"';
		$query = $this->db->query("CALL sp_a_run ('UPDATE','$update_qry')");
    	$this->logout();
	}
	//CHANGING PASSWORD FOR UNAUTHORIZED LOGIN !
	public function GenerateRandomNumber(){
	    $min = 1000; 
	    $max = 9999;
	    $gen_random 	= rand($min, $max);
	    $prefix 		= 'UNKNOWN'; 
	    $randomNumber 	= $prefix . $gen_random;
	    return $randomNumber;
	}
	public function index(){		
		if(!$this->Appconfig->isAppvalid()){			
			redirect('config');
		}		
		// $data = "";

		$dept_wise_qry  = 'select prime_department_id,department from cw_department where cw_department.trans_status = 1';
		$dept_wise_info = $this->db->query("CALL sp_a_run ('SELECT','$dept_wise_qry')");
		$dept_wise_rslt = $dept_wise_info->result();
		$dept_wise_info->next_result();
		$department_list[""] 	= "---- Select Department ----";
		foreach($dept_wise_rslt as $key => $for){
			$dept_id            = $for->prime_department_id;
			$department         = $for->department;
			$department_list[$dept_id] = $department;
		}
		$data['department_list']= $department_list;
		$this->load->view('home',$data);
	}	
	public function ticket_sts_track(){
		// $start_date 	= $this->input->post("start_date");
		// $end_date 		= $this->input->post("end_date");
		// $department 	= $this->input->post("department");

		$dept_wise_qry  = 'select * from cw_create_ticket where cw_create_ticket.trans_status = 1';
		$dept_wise_info = $this->db->query("CALL sp_a_run ('SELECT','$dept_wise_qry')");
		$dept_wise_rslt = $dept_wise_info->result_array();
		$dept_wise_info->next_result();
	}	
}

?>