<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Dashboard extends MY_Controller
{
	public function __construct(){

		parent::__construct();
		if(empty($this->session->user_id)) {
			redirect('auth/login');
		}

		if($this->session->userdata('module') == 'fc') {
			session_destroy();
			redirect('auth/login');
		}


		$this->load->library('ion_auth');
		$this->data['footer_news']=$this->home_model->footer_news();
		$this->data['footer_gallery']=$this->home_model->footer_gallery();
		$this->data['popupImages']=$this->home_model->popupImages();
	}


	function _fnMenu() {
		return [[
			'link'=> base_url('dashboard'),
			'name'	=> 'Dashboard'
		],
		[
			'link' => base_url('beneficiary/changepassword'),
			'name'	=> 'Change Password'
		]];
	}

	public function index($menuid=0){

		print_r($this->session->userdata('module'));

		if(!empty($this->session->userdata('company')) && !empty($this->session->userdata('company')->bank_code)) {
			redirect('bank/bank');
		} else {

			$this->data['newmenu'] = $this->_fnMenu();
			$this->data['page'] = 'beneficiary';
			$this->data['fullstatus'] = $this->bank_model->status_name();
			$this->data['applications'] = $this->beneficiary_model->get_applications($this->ion_auth->user()->row()->id);
			$this->data['allstatus'] = $this->beneficiary_model->app_status($this->ion_auth->user()->row()->id);
			$app = $this->beneficiary_model->applicationDetails($this->ion_auth->user()->row()->id);
			$app_count = $this->beneficiary_model->getAppProjCount($this->ion_auth->user()->row()->id);
			$this->data['app_count']= $app_count;
			$this->data['app_status']= array_column($app,'status');
			$this->_render_page(get_template(),$this->data);
		}

	}




	public function page($page_slug) {
		$this->data['details']= $this->db->query('SELECT * FROM '.TBL_PAGES.' WHERE LOWER(page_slug) = ? AND status = ?',array(strtolower($page_slug),1))->row();
		if(empty($this->data['details'])) {
			show_404();
		}

		$page_menu_id= $this->db->query('SELECT * FROM '.TBL_PAGES.' WHERE LOWER(page_slug) = ? AND status=?',array(strtolower($page_slug),1))->row()->page_menu;
		$this->data['page_type']= $this->db->query('SELECT * FROM '.TBL_PAGES.' WHERE LOWER(page_slug) = ? AND status=?',array(strtolower($page_slug),1))->row()->page_type;
		// tabbed Menu
		$this->data['page_sidemenu']=$this->home_model->get_menus($page_menu_id);
		$this->data['parameter']=$this->home_model->allparameter();
		// sector code 
		$sector=$this->home_model->sector();
		$parent_sector=array();
		$parent_sector[]='Select Sector';
		foreach ($sector as $key => $value) {
			$parent_sector[$value['sectorid']]=$value['code']."-".$value['name'];
		}
	
		
		$this->data['zed_rating']=$this->home_model->allrating();
		$this->data['parent']=$parent_sector;
		if($page_slug=='meet-our-team')
		{
			$this->data['page']='meet-our-team';
		}
		elseif($page_slug=='list-of-ee-technology')
		{
			$this->db->select(''.TBL_EET.'.id,'.TBL_EET.'.eet_name, '.TBL_EET.'.sp_min ,'.TBL_EET.'.sp_max ,'.TBL_EET.'.status,'.TBL_EET.'.created_by,'.TBL_EET.'.modified_by, '.TBL_EET.'.investment, '.TBL_EET.'.payback, '.TBL_EET.'.saving,'.TBL_SECTOR.'.name as sectorName' );
			$this->db->from(TBL_EET);
			$this->db->join(TBL_SECTOR, ''.TBL_EET.'.sector_id ='.TBL_SECTOR.'.sectorid');
			$this->db->where(''.TBL_EET.'.status!=', 2);
			$this->db->order_by(''.TBL_EET.'.id','DESC');
			$this->data['eet_list']=$this->db->get()->result();
			$this->data['page']='list-of-ee-technology';
		}
		else{
			$this->data['page']='page';
		}
		$this->data['slug']=$page_slug;
		$this->_render_page(get_template(),$this->data);
	}
	public function posts($post_slug)
	{
		$this->data['details']= $this->db->query('SELECT * FROM '.TBL_POSTS.' WHERE LOWER(post_slug) = ? AND status = ?',array(strtolower($post_slug),1))->row();
		if(empty($this->data['details']))
		{
			//redirect(base_url());
			show_404();
		}
		$this->data['popular_news']=$this->db->select('*')->where('id !=',$this->data['details']->id)->where('status',1)->order_by('id','DESC')->limit(3)->get(TBL_POSTS)->result();
		$this->data['page']='post';
		$this->_render_page(get_template(),$this->data);
	}
	public function contactus()
	{
		if($this->input->post('submit'))
		{
			$data['contact_name']=$this->input->post('name');
			$data['contact_email']=$this->input->post('email');
			$data['contact_phone']=$this->input->post('phone');
			$data['enterprise_name']=$this->input->post('enterprise_name');
			$data['query_category']=$this->input->post('query_category');
			$data['contact_query']=$this->input->post('message');
			$data['created_on']=global_datetime();
			/*$data = $this->security->xss_clean($data);*/
			if($this->db->insert(TBL_CONTACT,$data))
			{
				$subject="Contact Details";
				$message='<p>Conatact Name:'.$data['contact_name'].'</p>';
				$message.='<p>Contact Email:'.$data['contact_email'].'</p>';
				$message.='<p>Conatact Phone:'.$data['contact_phone'].'</p>';
				$message.='<p>Enterprise Name:'.$data['enterprise_name'].'</p>';
				$message.='<p>Query Categroy:'.$data['query_category'].'</p>';
				$message.='<p>Contact Query:'.$data['contact_query'].'</p>';
				if($data['query_category']!='Training Program' && $data['query_category']!='Awareness Program')
				{
					$cc='equestsupport@qcin.org';
					$to=$data['contact_email'];
				}
				else{
					$cc='harsh.jha@geostat.in';
					$to=$data['contact_email'];
				}
				
				$success=sendEmail($subject,$message,$to,$cc);
				
				$this->session->set_flashdata('message', 'Your details submit successfully !');
				redirect(base_url().'contact-us');
				
			}


		}
		$this->data['page']='contactus';
		$this->_render_page(get_template(),$this->data);
	}
	public function video()
	{
		$this->data['page']='video';
		$this->_render_page(get_template(),$this->data);
	}
	public function gallery()
	{
		$query = $this->db->select('label, value')->get(TBL_GLOBAL)->result_array();
		foreach ($query as $row)
		{
			$details[$row['label']] = $row['value'];
		}
		$this->data['gallery_seo'] = $details;
		$this->data['details']=$this->home_model->gallery();

		$this->data['page']='gallery';
		$this->_render_page(get_template(),$this->data);

	}
	public function gallery_month()
	{
		$year=$this->uri->segment(2);
		$month=ucfirst($this->uri->segment(3));
		$this->data['details']=$this->home_model->gallery_month($year,$month);
		$query = $this->db->select('label, value')->get(TBL_GLOBAL)->result_array();
		foreach ($query as $row)
		{
			$details[$row['label']] = $row['value'];
		}
		$this->data['gallery_seo'] = $details;
		$this->data['year']=$year;
		$this->data['month']=$month;
		$this->data['page']='individual-gallery';
		$this->_render_page(get_template(),$this->data);
	}
	public function search()
	{
		if($this->input->post('search_query'))
		{
			$this->data['search']=$this->input->post('search_query');
			$search_query=$this->input->post('search_query');
			$result_array=$this->home_model->search($search_query);
			if ($result_array) {
				$this->data['details']=$result_array;
			} else {
				$this->data['error']='No Results found';
			}
			
		}
		$this->data['page']='search';
		$this->_render_page(get_template(),$this->data);
		

	}
	public function disciplineparameter()
	{
		if(isset($_POST['id']))
		{
			$sector_id=$_POST['id'];
			$discipline_parmeter=$this->home_model->disciplineresults($sector_id);
			$discipline=array();
			foreach ($discipline_parmeter as $key => $value) {
				if(!empty($discipline[$value['code']]))
					array_push($discipline[$value['code']]["data"],$value);
				else{

					$discipline[$value['code']]["para_discipline"] = $value['para_discipline'];
					$discipline[$value['code']]["data"] = array();
					array_push($discipline[$value['code']]["data"],$value);
				}
				
			}
			echo json_encode(array('success'=>FALSE,'discipline'=>$discipline,'token'=>$this->security->get_csrf_hash()));
		}
		else	
		echo json_encode(array('success'=>FALSE,'token'=>$this->security->get_csrf_hash()));
		
	}
	public function zedmatrixparameter()
	{
		if(isset($_POST['id']))
		{
			$sector_id=$_POST['id'];
			$discipline_parmeter=$this->home_model->zedmaturity($sector_id);
			echo json_encode(array('success'=>TRUE,'discipline'=>$discipline_parmeter,'token'=>$this->security->get_csrf_hash()));
		}
		else	
		echo json_encode(array('success'=>FALSE,'token'=>$this->security->get_csrf_hash()));
		
	}
	public function news()
	{
		$this->data['details']=$this->home_model->news();
		$this->data['page']='news';
		$this->_render_page(get_template(),$this->data);
	}
	public function downloadTrainingPDF()

	{
		$this->load->helper('download');
		$data = file_get_contents("https://tcb.qcin.org//uploads/upcoming-trinings-pdf/Upcoming-Training-eLearning-Program-27-Jan-2021.pdf"); // Read the file's contents
		$name = 'Upcoming-Training-eLearning-Program.pdf';
		force_download($name, $data);
	}
}