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

class Project extends Public_Controller {

	public function __construct() {
		parent::__construct();
		$this->session->set_userdata('site_lang','indonesian');
	}

	public function index(){

		//get this project data
		$this->db->select('*')->from('project')->where('project_status', 1)->order_by('priority');
		$data['projects'] = $this->db->get()->result(); 

		$this->db->select('*');
		$this->db->from('configuration');
		$data['config'] = $this->db->get()->result();

		foreach ($data['config'] as $item) {
			$this->data_header['image'] = $item->logo;
			$this->data_header['icon'] = $item->website_icon;
			$this->data['fax'] = $item->fax;
			$this->data['hp'] = $item->hp;
			$this->data['company_address'] = $item->company_address;
			$this->data_footer['twitter']= $item->twitter;
			$this->data_header['instagram']= $item->instagram;
			$this->data_header['facebook']= $item->facebook;
			$this->data_footer['website_name']= $item->website_name;
		}

		//get SEO
		$this->data_header['browser_title'] = 'Project'; 
		$this->data_header['meta_description'] = 'Project';
		$this->data_header['meta_keywords'] = 'Project';
		
		$this->load->view('template/header', $this->data_header);
		$this->load->view('project', $data);
		$this->load->view('template/footer', $this->data_footer);
	}

	public function get() {

		if(!$this->input->post('category')) {
			redirect('project');
		}

		//get category from view
		$categories_arr = $this->input->post('category');

		//check id there is content inside category array
		$categories_count = count($categories_arr);

		$categories = '';

		if ($categories_count > 0) {
			foreach ($categories_arr as $category) {

				if($categories == '') {
					$categories = $category; 
				} else {
					$categories = $categories . ',' . $category;
				}
			}
		}

		//get filtered projects data
		$data['projects'] = $this->db->select('*')->from('project')->where('project_status', 1)->like('category_product', $categories)->order_by('priority')->get()->result();
	
		$item = $this->db->select('*')->from('configuration')->where('id_configuration', 1)->get()->row();

		$this->data_header['image'] = $item->logo;
		$this->data_header['icon'] = $item->website_icon;
		$this->data['fax'] = $item->fax;
		$this->data['hp'] = $item->hp;
		$this->data['company_address'] = $item->company_address;
		$this->data_footer['twitter']= $item->twitter;
		$this->data_header['instagram']= $item->instagram;
		$this->data_header['facebook']= $item->facebook;
		$this->data_footer['website_name']= $item->website_name;

		//get SEO
		$this->data_header['browser_title'] = 'Project'; 
		$this->data_header['meta_description'] = 'Project';
		$this->data_header['meta_keywords'] = 'Project';
		
		$this->load->view('template/header', $this->data_header);
		$this->load->view('project', $data);
		$this->load->view('template/footer', $this->data_footer);

	}

	public function search_by_type(){

		$project_types = $this->input->post('project_type');
		var_dump($project_types);exit;
		$type_count = count($project_type);

		$type = '';

		if ($type_count > 0) {
			foreach ($project_types as $project_type) {
				$type = $project_type;
			}
		}

		$data['projects_type'] = $this->db->select('*')->from('project')->where('project_status',1)->like('project_type',$type)->order_by('priority')->get()->result();


		$item = $this->db->select('*')->from('configuration')->where('id_configuration', 1)->get()->row();

		$this->data_header['image'] = $item->logo;
		$this->data_header['icon'] = $item->website_icon;
		$this->data['fax'] = $item->fax;
		$this->data['hp'] = $item->hp;
		$this->data['company_address'] = $item->company_address;
		$this->data_footer['twitter']= $item->twitter;
		$this->data_header['instagram']= $item->instagram;
		$this->data_header['facebook']= $item->facebook;
		$this->data_footer['website_name']= $item->website_name;

		//get SEO
		$this->data_header['browser_title'] = 'Project'; 
		$this->data_header['meta_description'] = 'Project';
		$this->data_header['meta_keywords'] = 'Project';
		
		$this->load->view('template/header', $this->data_header);
		$this->load->view('project', $data);
		$this->load->view('template/footer', $this->data_footer);


	}

	public function ajax_get_projects() {
		//test if ajax call to prevent direct access
		if (!$this->input->is_ajax_request()) {
			exit('No direct script access allowed'); 
		 } 
		 
		 $project_year = $this->input->post('project_year');

		 $data['projects'] = $this->db->select('project_name, city, year')->from('project')->where('year', $project_year)->where('project_status', '1')->order_by('priority', 'ASC')->get()->result();

		 $this->load->view('ajax/ajax_get_projects', $data); 
	}
}
?>