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

class Blog extends Public_Controller {

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

	public function index() {

		//SEO get browser title and meta details
		$this->db->select('browser_title, meta_description, meta_keywords')->from('configuration')->where('id_configuration', 1);
		$website_name = $this->db->get()->row();
		$this->data_header['browser_title'] = $website_name->browser_title;
		$this->data_header['meta_description'] = $website_name->meta_description;
		$this->data_header['meta_keywords'] = $website_name->meta_keywords;

		$this->load->library('pagination');
		$config = array();
		$this->load->helper('pagination_helper');
		$config = pagination_format();
		$config['base_url'] = base_url() . 'blog/index/' ; 
		$config['total_rows'] = $this->db->get('blog')->num_rows();
		$config['per_page'] = 12; 
		$config['uri_segment'] = 3; 
		$this->pagination->initialize($config);

		$this->db->order_by('publish_date','desc')->limit($config['per_page'], $this->uri->segment($config['uri_segment']))->where('status', '1');
		$data['blogs'] = $this->db->get('blog')->result();

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

	public function get($alias = NULL) { 

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

		//the script belows account if user share a link to outside user. to find the blog article in different language, to avoid 404 page not found in different language

		$this->db->select('*')->from('blog')->where('alias', $alias)->where('status', 1);
		$count = $this->db->get()->num_rows();

		if($count == 0){
			show_404();
		}
		else{
			//blog exist. get blog parameter
			$this->db->select('*')->from('blog')->where('alias', $alias);
			$data['blog'] = $this->db->get()->row();
		}

		// --------------------------------------

		//get blog
		$this->db->select('*')
		->from('blog')
		->where("alias<>'$alias'")
		->order_by('publish_date', 'DESC')
		->limit(8);
		$data['blogs'] = $this->db->get()->result();

		//get SEO
		$this->data_header['browser_title'] = 'Blog - ' . ucwords($data['blog']->blog); 
		$this->data_header['meta_description'] = 'Blog - ' . ucwords($data['blog']->blog); 
		$this->data_header['meta_keywords'] = 'Blog - ' . ucwords($data['blog']->blog); 
   
		$this->load->view('template/header', $this->data_header);
		$this->load->view('blog_detail', $data);
		$this->load->view('template/footer', $this->data_footer);
	}


}