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

class Menus extends Admin_Controller {

	//this property is used for validating existing menu title on call back edit menu
	private $menu_current_id = NULL;
		 
	function __construct() {
		parent::__construct();	
		$this->load->model('menu_m'); 
	}
		
	//this is to list all menus
	public function index() {
		
		//pagination in action. 50 results per page
		$this->load->library('pagination');
		$config['base_url'] = base_url() . 'admin/menus/index';
		$config['per_page'] = 50;
		$config["uri_segment"] = 4; 

		//fetch all menus
		$config['total_rows'] = $this->menu_m->record_count(); 
		$this->pagination->initialize($config);
   		$this->data['menus'] = $this->menu_m->get_all_menus($config["per_page"], 
		$this->uri->segment(4)); 
	
		//load view
		$this->data['subview'] = 'admin/menus/index';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');	
    }
	
	//to add a new menu 
	public function add() {
	
	$this->data['menus'] = $this->menu_m->get_new();  	

		//get ordering number and display at add form
		$this->db->select_max('priority')->from('menus');
		$current_priority = $this->db->get()->row()->priority;
		if($current_priority == NULL) {
			$this->data['menus']->priority = 1;	
		} else {
			$this->data['menus']->priority = $current_priority + 1;
		}  
		
		//validation in action
		//validation check in action
		$rules = $this->menu_m->rules; 

		$config = $this->check_form_validation($rules, $_POST);
		
		$this->load->library('form_validation');
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>'); //above is to add class to form validation error, to be styled
		$this->form_validation->set_rules($config); 
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>');

		if($this->form_validation->run($this) == TRUE) {
			
				$data = $this->process_data($_POST);
				
				$this->menu_m->add_menu($data); 

				$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Menu Add Successful</p>');

				redirect('admin/menus');
			
		} 
		
		$this->data['subview'] = 'admin/menus/edit';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');
	}
	
	//to edit menu in admin
	public function edit($id = NULL) {

		//check if id exist. If not exist, show 404.
		$count = $this->menu_m->count_exist($id);
		
		if ($count == 0) { 
			//page not exist
			show_404();
		}	

		$this->menu_current_id = (int) $id;	

		$this->data['menus'] = $this->menu_m->get($id);	
		
		//validation check in action
		$rules = $this->menu_m->rules;
		$config = $this->check_form_validation($rules, $_POST);

		$this->load->library('form_validation');
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>'); //above is to add class to form validation error, to be styled
		$this->form_validation->set_rules($config); 
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>');

		if($this->form_validation->run($this) == TRUE) {
			
			$data = $this->process_data($_POST);

			$this->menu_m->edit_menu($id, $data); 

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">menu Edit Successful</p>');
			
			redirect('admin/menus');
			
		} 
		
		$this->data['subview'] = 'admin/menus/edit';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');	
	}
	
	
	//to delete a menu
	public function delete($id) {

		//check if id exist. If not exist, show 404.
		$count = $this->menu_m->count_exist($id);
		
		if ($count == 0) {  
			//page not exist 
			show_404(); 
		}		
		
		//delete menu
		$this->menu_m->delete($id);

		$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Menu Delete Successful</p>');
		redirect('admin/menus');
	}

	public function ajax_get_menutype() { 

		$this->load->helper('form');

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

		$menu_type = $this->input->post('menu_type');
		$current_menu_id = $this->input->post('current_menu_id');

		switch ($menu_type) {
			
			case 'category':

				//get all parent categories
				$this->db->select('*')->from('categories')->where('status', 1)->where('parent', NULL)->order_by('id_categories', 'ASC');
				$data['categories'] = $this->db->get()->result(); 

				if ($current_menu_id == NULL) { 
					$data['current_category_id'] = NULL;
				} else {
					//get current active category_id
					$this->db->select('category_id, menu_link')->from('menus')->where('id_menus', 
					(int) $current_menu_id);
					$category_id = $this->db->get()->row();	

					if ($category_id->category_id == NULL) {
						
						if ($category_id->menu_link == 'all') {
							$data['current_category_id'] = 'all';
						} elseif ($category_id->menu_link == 'new_arrivals') {
							$data['current_category_id'] = 'new';
						} elseif ($category_id->menu_link == 'sale') {
							$data['current_category_id'] = 'sale';
						} elseif ($category_id->menu_link == 'bestseller') {
							$data['current_category_id'] = 'bestseller';
						} 	 

					} else {
						$data['current_category_id'] = $category_id->category_id;
					}
				}
				$this->load->view('admin/menus/ajax_get_category', $data); 

			break;
			
			case 'brand':  

				//get all brands
				$this->db->select('*')->from('brands')->where('status', 1)->order_by('id_brands', 'ASC');
				$data['brands'] = $this->db->get()->result(); 

				if ($current_menu_id == NULL) { 
					
					$data['current_brand_id'] = NULL;
				
				} else {

					//get current active brand_id
					$this->db->select('brand_id, menu_link')->from('menus')->where('id_menus', (int) $current_menu_id);
					$brand_id = $this->db->get()->row();	

					if ($brand_id->brand_id == NULL) {
						
						if ($brand_id->menu_link == 'brand/all') {
							$data['current_brand_id'] = 'all';
						}

					} else {

						$data['current_brand_id'] = $brand_id->brand_id; 
					}
				}

				$this->load->view('admin/menus/ajax_get_brands', $data);

			break;	

			
			case 'page':

				//get all pages
				$this->db->select('*')->from('pages')->where('status', 1)->order_by('id_pages', 'ASC');
				$data['pages'] = $this->db->get()->result(); 

				if ($current_menu_id == NULL) {
					
					$data['current_page_id'] = NULL;
				
				} else { 

					//get current active page_id
					$this->db->select('page_id')->from('menus')->where('id_menus', 
					(int) $current_menu_id);
					$data['current_page_id'] = $this->db->get()->row();	 
				}

				$this->load->view('admin/menus/ajax_get_pages', $data);

			break;		

			case 'external':

				if ($current_menu_id == NULL) {
					
					$this->load->view('admin/menus/ajax_get_external'); 				
	
				} else { 

					//get current external link
					$this->db->select('menu_link')->from('menus')->where('id_menus', 
					(int) $current_menu_id);
					$data['current_external_link'] = $this->db->get()->row();

					$this->load->view('admin/menus/ajax_get_external', $data); 	 
				}
			break;		
		}
	}

	//callback function validation add new menu
	public function _cek_existing_menu_title($str) {

		$num_rows = $this->menu_m->cek_existing_menu_title($str, $this->menu_current_id);   
		if ($num_rows != 0 ) { 
			$this->form_validation->set_message('_cek_existing_menu_title', 'Menu name already exist !'); 
			return FALSE;
		} else {
			return TRUE;    
		}
	}

	private function check_form_validation($config, $post_data) {

		if (isset($post_data['category'])) {

			$config[] = array(
				'field'   => 'category', 
                'label'   => 'category',
                'rules'   => 'trim|required'
			);
		}

		if (isset($post_data['brand'])) {
			
			$config[] = array(
				'field'   => 'brand',  
                'label'   => 'brand',
                'rules'   => 'trim|required'
			);
		}

		if (isset($post_data['page'])) {
			
			$config[] = array(
				'field'   => 'page', 
                'label'   => 'page',
                'rules'   => 'trim|required'
			);
		}

		if (isset($post_data['external_link'])) {
			
			$config[] = array(
				'field'   => 'external_link', 
                'label'   => 'External Link',
                'rules'   => 'trim|required'
			);
		}
		return $config;
	}

	private function process_data($post_data) {

		$menu_type = $post_data['menu_type'];

		$data = array(
			'menu' => $post_data['menu'],
			'alias' => url_title($post_data['menu']),
			'menu_type' => $menu_type,
			'status' => $post_data['status'],
			'priority' => (int) $post_data['priority'],
		);

		if ($menu_type == 'category') {

			if ($post_data['category'] == 'all') { 
				
				$data['menu_link'] = 'all';
				$data['category_id'] = NULL;
				$data['brand_id'] = NULL;
				$data['page_id'] = NULL;

			} elseif ($post_data['category'] == 'new') {
				
				$data['menu_link'] = 'new_arrivals';
				$data['category_id'] = NULL;
				$data['brand_id'] = NULL;
				$data['page_id'] = NULL;

			} elseif ($post_data['category'] == 'sale') {
			
				$data['menu_link'] = 'sale';	
				$data['category_id'] = NULL;
				$data['brand_id'] = NULL;
				$data['page_id'] = NULL;	

			} elseif ($post_data['category'] == 'bestseller') {

				$data['menu_link'] = 'bestseller';	
				$data['category_id'] = NULL;
				$data['brand_id'] = NULL;
				$data['page_id'] = NULL;	

			} else {
				
				//individual category item..
				$category_id = (int) $post_data['category'];
				$this->db->select('parent')->from('categories')->where('id_categories', $category_id);
				$parent_id = $this->db->get()->row()->parent;

				//check parent_id
				if($parent_id === NULL) {

					$this->db->select('alias')->from('categories')->where('id_categories', $category_id);
					$alias = $this->db->get()->row()->alias;
					//this category is level 1 category
					$data['menu_link'] = 'category/' .$alias;

				} elseif($parent_id !== NULL) {

					$this->db->select('parent')->from('categories')->where('id_categories', $parent_id);
					$parent2_id = $this->db->get()->row()->parent;

					if($parent2_id == NULL) {  

						//this is level 2 category..
						//get level 1 alias
						$this->db->select('alias')->from('categories')->where('id_categories', $parent_id);
						$alias_level1 = $this->db->get()->row()->alias;

						//get level 2 alias
						$this->db->select('alias')->from('categories')->where('id_categories', $category_id);
						$alias_level2 = $this->db->get()->row()->alias;

						$data['menu_link'] = 'category/' .$alias_level1 . '/' . $alias_level2;
						
					} else {

						//this is level 3 category..
						//get level 3 alias
						$this->db->select('alias')->from('categories')->where('id_categories', $category_id);
						$alias_level3 = $this->db->get()->row()->alias;

						//get level 2 alias
						$this->db->select('alias')->from('categories')->where('id_categories', $parent_id);
						$alias_level2 = $this->db->get()->row()->alias;

						//get level 1 alias
						$this->db->select('parent')->from('categories')->where('id_categories', $parent_id);
						$level1_id = $this->db->get()->row()->parent;

						$this->db->select('alias')->from('categories')->where('id_categories', $level1_id);
						$alias_level1 = $this->db->get()->row()->alias;

						$data['menu_link'] = 'category/' .$alias_level1 . '/' . $alias_level2 . '/' . $alias_level3;
						
					}
				}

				$data['category_id'] = $category_id;
				$data['brand_id'] = NULL;
				$data['page_id'] = NULL;
			}
		}

		if ($menu_type == 'brand') {
			if ($post_data['brand'] == 'all') {
				$data['menu_link'] = 'brand/all';
				$data['category_id'] = NULL;
				$data['brand_id'] = NULL;
				$data['page_id'] = NULL;
			} else {
				$brand_id = (int) $post_data['brand'];
				$this->db->select('alias')->from('brands')->where('id_brands', $brand_id);
				$brand_alias = $this->db->get()->row();
				$data['menu_link'] = 'brand/' . $brand_alias->alias;
				$data['brand_id'] = $brand_id;
				$data['category_id'] = NULL;
				$data['page_id'] = NULL; 
			}
		}

		if ($menu_type == 'page') {
			$page_id = (int) $post_data['page'];
			$this->db->select('alias')->from('pages')->where('id_pages', $page_id);
			$page_alias = $this->db->get()->row();
			$data['menu_link'] = 'page/' . $page_alias->alias;
			$data['page_id'] = $page_id;
			$data['category_id'] = NULL;
			$data['brand_id'] = NULL;		
		}

		if ($menu_type == 'external') { 
			$data['menu_link'] = $post_data['external_link'];
			$data['category_id'] = NULL;
			$data['brand_id'] = NULL;
			$data['page_id'] = NULL; 
		}

		return $data;		

	}
	
		
}