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

class Inspiration extends Public_Controller {

	public function __construct() {
		parent::__construct();
	}

	public function index() {  

		//PRODUCTS
		//pagination in action. 

		//get no. of products per page (pagination) from configuration table
		$this->db->select('products_displayed')->from('configuration')->where('id_configuration', 1);
		$per_page = $this->db->get()->row();
		
		$this->load->library('pagination');
		$config['base_url'] = base_url() . 'inspiration/index'; 

		$this->db->select('*')->from('inspiration')->where('status', '1');
		$count_inspiration = $this->db->get()->num_rows();	
		$config['total_rows'] = $count_inspiration;  

		$config['per_page'] = $per_page->products_displayed;  
		$config['uri_segment'] = 3;
		$config['num_tag_open'] = '<span style="padding-left:10px; padding-right:10px">';
		$config['num_tag_close'] = '</span>';

		$this->pagination->initialize($config);

		$this->db->select('*');
		$this->db->from('inspiration');
		$this->db->where('status', '1');
		$this->db->order_by('priority', 'ASC');
		$this->db->limit($config['per_page'], $this->uri->segment(3));
		$data['inspirations'] = $this->db->get()->result();		
	

		//get SEO
		$this->db->select('website_name, meta_keywords')->from('configuration')->where('id_configuration', 1);
		$website_name = $this->db->get()->row();
		$this->data_header['browser_title'] =  ucwords($website_name->website_name) . ' - Inspiration'; 
		$this->data_header['meta_description'] = ucwords($website_name->website_name) . ' - Inspiration';
		$this->data_header['meta_keywords'] = $website_name->meta_keywords;

		$this->load->view('template/header', $this->data_header);
		$this->load->view('inspiration', $data);
		$this->load->view('template/footer', $this->data_footer);

	}

	public function get($inspiration = NULL) {  

		if($inspiration == NULL) {show_404();}

		$inspiration_trim = str_replace('-', ' ', $inspiration);

		//get inspiration for specific cateogory only
		$this->db->select('*');
		$this->db->from('inspiration');
		$this->db->where('type', $inspiration_trim);
		$this->db->where('status', '1');
		$this->db->order_by('priority', 'ASC');
		$data['inspirations'] = $this->db->get()->result();	

		$data['inspiration_title'] = $inspiration_trim;

		//get SEO
		$this->db->select('website_name, meta_keywords')->from('configuration')->where('id_configuration', 1);
		$website_name = $this->db->get()->row();
		$this->data_header['browser_title'] =  ucwords($website_name->website_name) . ' - Inspiration'; 
		$this->data_header['meta_description'] = ucwords($website_name->website_name) . ' - Inspiration';
		$this->data_header['meta_keywords'] = $website_name->meta_keywords;

		$this->load->view('template/header', $this->data_header);
		$this->load->view('inspiration_detail', $data);
		$this->load->view('template/footer', $this->data_footer);	
	}


}