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

class Blog extends Public_Controller {

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

		//LOAD LANGUAGE FILES FOR BLOG
		if($this->session->userdata('site_lang') == 'english') {
			$this->lang->load('homepage', 'english');
		} else {
			$this->lang->load('homepage', 'indonesian');
		}
		$this->data_header['menus'] = $this->db->select('page_title_en, alias_en')->from('pages')->where('status', 1)->order_by('priority', 'asc')->get()->result();
		$this->load->model('menu_m');
		$this->data_header['our_team_status'] = $this->menu_m->get_management_menu()[0]->status;
	}

	public function index() {
		if($this->session->userdata('site_lang') == 'english') {
			//get all blogs
			$this->db->select('blog_en as blog, alias_en as alias, publish_date, image1, description_en as description')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC');
			$data['blogs'] = $this->db->get()->result();

		} else {
		//get all blogs
		$this->db->select('blog, alias, publish_date, image1, description')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC');
		$data['blogs'] = $this->db->get()->result();
		}

		$data['landingpage_blog'] = $this->db->select('blog_landingpage_image')->from('configuration')->where('id_configuration',1)->get()->row()->blog_landingpage_image;

		//get SEO
		$this->data_header['browser_title'] = 'Articles & News | Tax Accountants | Accounting Firm'; 
		$this->data_header['meta_description'] = 'Intelligent Accounting & Tax Services Sydney Provides Informative Articles & News Related to Accounting & Tax Services | Accounting Firm | Accountants Near Me'; 
		$this->data_header['meta_keywords'] = 'accountants near me, accountants sydney, accounting firm, accounting firm sydney, accounting services, accounting services sydney, ATO Audit, SMSF Administration, SMSF Audit, Tax Accountants'; 
   
		$this->load->view('template/header', $this->data_header);
		$this->load->view('template2/blogs', $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
		if($this->session->userdata('site_lang') == 'english') {
			//check if blog exist in english alias
			$this->db->select('id_blog')->from('blog')->where('alias_en', $alias)->where('status', 1);
			$count = $this->db->get()->num_rows(); 
			
			if ($count == 0) {
				//blog not exist in english alias. So check to indonesian
				$this->db->select('id_blog')->from('blog')->where('alias', $alias)->where('status', 1);
				$count_indonesian = $this->db->get()->num_rows(); 
				
				if ($count_indonesian == 0) { 
					show_404();	
				} else {
					//blog exist in indonesian. get blog parameter
					$this->db->select('blog, alias, publish_date, image1, image2, description')->from('blog')->where('alias', $alias);
					$data['blog'] = $this->db->get()->row();

					//change the website session language to indonesian
					$this->session->set_userdata('site_lang', 'indonesian');
					$this->load->helper('language');
					$this->lang->load('website','indonesian'); 
				}

			} else {

				//blog exist in english alias. get blog parameter
				$this->db->select('blog_en as blog, alias_en as alias, publish_date, image1, image2, description_en as description')->from('blog')->where('alias_en', $alias);
				$data['blog'] = $this->db->get()->row();

				//change the website session language to english
				$this->session->set_userdata('site_lang', 'english');
				$this->load->helper('language');
				$this->lang->load('website','english'); 
			}

		} else {

			//check if blog exist in indonesian alias
			$this->db->select('id_blog')->from('blog')->where('alias', $alias)->where('status', 1);
			$count = $this->db->get()->num_rows(); 
			
			if ($count == 0) {
				//blog not exist in indonesian alias. So check to english
				$this->db->select('id_blog')->from('blog')->where('alias_en', $alias)->where('status', 1);
				$count_english = $this->db->get()->num_rows(); 
				
				if ($count_english == 0) {
					show_404();	
				} else {
					//blog exist in english. get blog parameter
					$this->db->select('blog_en as blog, alias_en as alias, publish_date, image1, image2, description_en as description')->from('blog')->where('alias_en', $alias);
					$data['blog'] = $this->db->get()->row();

					//change the website session language to english
					$this->session->set_userdata('site_lang', 'english');
					$this->load->helper('language');
					$this->lang->load('website','english'); 

				}

			} else {
				//blog exist in indonesian alias. get blog parameter
				$this->db->select('blog, alias, publish_date, image1, image2, description')->from('blog')->where('alias', $alias);
				$data['blog'] = $this->db->get()->row();

				//change the website session language to indonesian
				$this->session->set_userdata('site_lang', 'indonesian');
				$this->load->helper('language');
				$this->lang->load('website','indonesian'); 
			}

		}

    //get all blogs with limit to 5 blogs for the side coloumn
		if($this->session->userdata('site_lang') == 'english') {
			$this->db->select('blog_en as blog, alias_en as alias, publish_date, image1, description_en as description')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC')->limit(5);
			$data['blogs'] = $this->db->get()->result();

		} else {
			$this->db->select('blog, alias, publish_date, image1, description')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC')->limit(5);
			$data['blogs'] = $this->db->get()->result();
		}

		$data['landingpage_blog'] = $this->db->select('blog_landingpage_image')->from('configuration')->where('id_configuration',1)->get()->row()->blog_landingpage_image;

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