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

class Page extends Public_Controller {

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

	public function get($alias = NULL) { 

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

		if($this->session->userdata('site_lang') == 'english') {
			//website session in english
			//check if page exist 
			$this->db->select('id_pages')->from('pages')->where('alias_en', $alias)->where('status', 1);
			$count = $this->db->get()->num_rows(); 

			if($count > 0) {
				//page exist in english 
				//get page parameters 
				$this->db->select('page_title_en as page_title, alias_en as alias, body_text_en as body_text, id_pages,image, meta_description')->from('pages')->where('alias_en', $alias);
				$data['page'] = $this->db->get()->row();
			} else {
				//page not exist in english, check for indonesian
				$this->db->select('id_pages')->from('pages')->where('alias', $alias)->where('status', 1);
				$count = $this->db->get()->num_rows(); 
				if($count > 0) {
					//page exist in indonesian
					//get page parameters 
					$this->db->select('page_title, alias, body_text, id_pages,image,meta_description')->from('pages')->where('alias', $alias);
					$data['page'] = $this->db->get()->row();
				} else {
					show_404();
				}
			}

			//get current menu (English)
			$data['current_menu'] = $this->db->select('id_menus, parent_id, menu_en as menu')->from('menus')->where('menu_link_en', $this->uri->segment(1) . '/' . $this->uri->segment(2))->get()->row();
			
			if($data['current_menu']->parent_id) {
				//this is a child menu. get parent menu
				$data['parent_menu'] = $this->db->select('id_menus, parent_id, menu_en as menu')->from('menus')->where('id_menus', $data['current_menu']->parent_id)->get()->row();
			} else {
				//this is a parent menu
				$data['parent_menu'] = $data['current_menu'];
			}

			//get all child menus
			$data['child_menus'] = $this->db->select('id_menus, menu_en as menu, alias_en as alias, menu_link_en as menu_link')->from('menus')->where('parent_id', $data['parent_menu']->id_menus)->where('status', '1')->order_by('priority', 'asc')->get()->result();

		} else {
			//website session in indonesian
			//check if page exist 
			$this->db->select('id_pages')->from('pages')->where('alias', $alias)->where('status', 1);
			$count = $this->db->get()->num_rows(); 
			if($count > 0) {
				//page exist in indonesian
				//get page parameters 
				$this->db->select('page_title, alias, body_text, id_pages,image, meta_description')->from('pages')->where('alias', $alias);
				$data['page'] = $this->db->get()->row();
			} else {
				//page not exist in indonesian, check for english
				$this->db->select('id_pages')->from('pages')->where('alias_en', $alias)->where('status', 1);
				$count = $this->db->get()->num_rows(); 
				if($count > 0) {
					//page exist in english
					//get page parameters 
					$this->db->select('page_title_en as page_title, alias_en as alias, body_text_en as body_text, id_pages,image, meta_description')->from('pages')->where('alias_en', $alias);
					$data['page'] = $this->db->get()->row();
	
				} else {
					show_404();
				}
			}

			//get current menu (Indonesian)
			$data['current_menu'] = $this->db->select('id_menus, parent_id, menu')->from('menus')->where('menu_link', $this->uri->segment(1) . '/' . $this->uri->segment(2))->get()->row();
			
			if($data['current_menu']->parent_id) {
				//this is a child menu. get parent menu
				$data['parent_menu'] = $this->db->select('id_menus, parent_id, menu')->from('menus')->where('id_menus', $data['current_menu']->parent_id)->get()->row();
			} else {
				//this is a parent menu
				$data['parent_menu'] = $data['current_menu'];
			}

			//get all child menus
			$data['child_menus'] = $this->db->select('id_menus, menu, alias, menu_link')->from('menus')->where('parent_id', $data['parent_menu']->id_menus)->where('status', '1')->order_by('priority', 'asc')->get()->result();
		}

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