<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Session_audit  extends Action_controller{	
	public function __construct(){
		parent::__construct('session_audit');
	}
	

	// LOAD PAGE QUICK LINK,FILTERS AND TABLE HEADERS
	public function index(){
		$this->page_info();
		$data['encKey']          = $this->generateKey();
		$this->load->view("$this->control_name/manage",$data);
	}
	
	public function get_employee_list(){
		$encString         = file_get_contents('php://input');
		$_POST             = $this->cryptoDecrypt($encString);
		if(!$_POST){
			echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
			exit(0);
		}
		$category      = $this->input->post('category');
		$search_term   = $this->input->post_get('term');
		// $emp_query  = 'SELECT emp_name,employee_code FROM cw_employees WHERE trans_status =1 and termination_status = 0';

		$emp_query   ='SELECT cw_employees.employee_code as value,CONCAT(cw_employees.employee_code," - ",cw_employees.emp_name) as label,CONCAT(cw_employees.employee_code," - ",cw_employees.emp_name) as display_name FROM cw_employees WHERE cw_employees.trans_status = 1  AND(cw_employees.employee_code LIKE "%'.$search_term.'%" OR cw_employees.emp_name LIKE "%'.$search_term.'%" OR cw_employees.emp_pf_no LIKE "%'.$search_term.'%") limit 0,50';
		$emp_info   = $this->db->query("CALL sp_a_run ('SELECT','$emp_query')");
		$emp_result = $emp_info->result_array();
		$emp_info->next_result();
		if($emp_result[0]){
			echo json_encode($emp_result);
		}else{
			echo json_encode(array('success' => false, 'message' => "No Data Found..!"));
		}
	}

	public function session_data(){
		$encString         = file_get_contents('php://input');
		$_POST             = $this->cryptoDecrypt($encString);
		if(!$_POST){
			echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
			exit(0);
		}
		$employee_code    = $this->input->post('emp_code');
		$emp_name_query   = 'select emp_name from cw_employees where employee_code="'.$employee_code .'" and trans_status=1';
		$emp_name_info    = $this->db->query("CALL sp_a_run ('SELECT','$emp_name_query')");
		$emp_name_rslt    = $emp_name_info->result_array();
		$emp_name_info->next_result();
		$emp_name         = $emp_name_rslt[0]["emp_name"];
		$session_data_qry ='SELECT ip_address,timestamp FROM cw_sessions WHERE DATA LIKE "%'.$employee_code.'%"  AND TIMESTAMP < DATE_SUB(NOW(),INTERVAL 1 YEAR)';
		$session_info     = $this->db->query("CALL sp_a_run ('SELECT','$session_data_qry')");
		$session_rslt     = $session_info->result_array();
		$session_info->next_result();
		if(!$session_rslt){
			echo json_encode(array('success' => false, 'message' => "No Data Available for This Employee..!"));
			exit(0);
		}
		$session_arr  = array();
		$i=0;
		foreach($session_rslt as $val){
			$timestamp_date  = date('d-m-Y H:i:s',$val['timestamp']);
			$session_arr[$i] = array("Employee Code" => $employee_code,"Employee Name"=>$emp_name,"Ip Address"=>$val["ip_address"],"Timestamp"=>$timestamp_date);
			$i++;
		}
		echo json_encode(array('success' => TRUE, 'message' => "Success..!",'session_data'=>$session_arr));
	}
}
?>