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

class Warehouses extends Admin_Controller {

	//this property is used for validating existing page title on call back edit page
	private $warehouse_current_id = NULL;
	private $warehouse_current_priority = NULL;
		
	function __construct() {
		parent::__construct();	
		$this->load->model('warehouse_m'); 

		if (!in_array('warehouses', $this->data['allowed_module'])) {
			$this->data['allowed'] = false;
		} else {
			$this->data['allowed'] = true;
		}
	}
		
	//this is to list all warehouse
	public function index() {
		
		//pagination in action. 20 results per page
		$this->load->library('pagination');
		$config['base_url'] = base_url() . 'admin/warehouse/index';
		$config['per_page'] = 20;
		$config["uri_segment"] = 4; 

		//fetch all warehouse
		$config['total_rows'] = $this->warehouse_m->record_count();  
		$this->pagination->initialize($config);
   		$this->data['warehouses'] = $this->warehouse_m->get_all_warehouse($config["per_page"], 
		$this->uri->segment(4)); 
	
		//load view
		$this->data['subview'] = 'admin/warehouse/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 page 
	public function add() {

		if($this->data['allowed'] == false) { redirect('admin/dashboard'); }
	
		$this->data['warehouse'] = $this->warehouse_m->get_new();

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

		//get all provinces data from provinces table
		$this->db->select('rajaongkir_province_id, province')->from('indonesia_provinces')->order_by('rajaongkir_province_id', 'ASC');
		$this->data['provinces'] = $this->db->get()->result();

		//get all countries data from RajaOngkir.com API
		//$this->data['countries'] = get_rajaongkir_data('v2/internationalDestination'); //get from helper file

		//get all countries data from countries table
		$this->db->select('*')->from('countries')->order_by('id_countries', 'ASC');
		$this->data['countries'] = $this->db->get()->result();
		
		//validation in action
		$config = $this->warehouse_m->rules;   

		$this->load->library('form_validation');
		$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->table_data_processing();

			$warehouse_id = $this->warehouse_m->add_warehouse($data);

			//add subdistrict_2hourdelivery for warehouse destination
			$subdistrict_rajaongkir_id_array_2hourdelivery = $this->input->post('subdistrict_2hourdelivery');
			$subdistrict_rajaongkir_id_array_1dayservice = $this->input->post('subdistrict_1dayservice');

			foreach ($subdistrict_rajaongkir_id_array_2hourdelivery as $key => $item) {
				
				$data = array(
					'warehouse_id' => $warehouse_id,
					'twohour_subdistrict_id' => $item
				);
				$this->db->insert('shipment_method_express', $data);
			}

			foreach ($subdistrict_rajaongkir_id_array_1dayservice as $key => $item) {
				
				$data = array(
					'warehouse_id' => $warehouse_id,
					'oneday_subdistrict_id' => $item
				);
				$this->db->insert('shipment_method_express', $data);
			}

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

			redirect('admin/warehouses');
			
		} 

		//get all cities
		$this->db->select('destination_city, id, destination_province')->from('indah_cargo')->order_by('destination_city', 'ASC');
		$this->data['cities'] = $this->db->get()->result();
		
		$this->data['subview'] = 'admin/warehouse/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 page in admin
	public function edit($id = NULL) {

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

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

		$this->db->select('*')->from('warehouse')->where('id', $id);
		$this->data['warehouse'] = $this->db->get()->row();

		$this->warehouse_current_priority = $this->data['warehouse']->priority;

		//get all provinces data from provinces table
		$this->db->select('rajaongkir_province_id, province')->from('indonesia_provinces')->order_by('rajaongkir_province_id', 'ASC');
		$this->data['provinces'] = $this->db->get()->result();

		//get all countries data from countries table
		$this->db->select('*')->from('countries')->order_by('id_countries', 'ASC');
		$this->data['countries'] = $this->db->get()->result();
		
		//get current province
      	$current_province_id = $this->data['warehouse']->id_province;
		$this->data['current_province_id'] = $current_province_id;
		
		//get district lists
		$this->db->select('rajaongkir_id_district, district')->from('indonesia_districts')->where('indonesia_id_province', $current_province_id);  
		$this->data['district_lists'] = $this->db->get()->result();

		$current_district_id = $this->data['warehouse']->id_district;
		$this->data['current_district_id'] = $current_district_id;

		//get all initial subdistricts lists
		$this->db->select('rajaongkir_id_subdistrict, subdistrict')->from('indonesia_subdistricts')->where('indonesia_id_district', $current_district_id);  
		$this->data['subdistrict_lists'] = $this->db->get()->result();

		$current_subdistrict_id = $this->data['warehouse']->id_subdistrict;
		$this->data['current_subdistrict_id'] = $current_subdistrict_id;
		
		$this->warehouse_current_id = (int) $id;	
		
		//validation check in action 
		$config = $this->warehouse_m->rules;

		$this->load->library('form_validation');
		$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->table_data_processing();

			$this->warehouse_m->edit_page($id, $data); 

			//add subdistrict_2hourdelivery for warehouse destination
			$subdistrict_rajaongkir_id_array_2hourdelivery = $this->input->post('subdistrict_2hourdelivery');
			$subdistrict_rajaongkir_id_array_1dayservice = $this->input->post('subdistrict_1dayservice');

			//remove all entry from database..
			$this->db->where('warehouse_id', $id);
			$this->db->delete('shipment_method_express');

			foreach ($subdistrict_rajaongkir_id_array_2hourdelivery as $key => $item) {
				
				$data1 = array(
					'warehouse_id' => $id,
					'twohour_subdistrict_id' => $item
				);
				$this->db->insert('shipment_method_express', $data1);
			}

			foreach ($subdistrict_rajaongkir_id_array_1dayservice as $key => $item) {
				
				$data2 = array(
					'warehouse_id' => $id,
					'oneday_subdistrict_id' => $item
				);
				$this->db->insert('shipment_method_express', $data2);
			}

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Warehouse Edit Successful</p>');
			
			redirect('admin/warehouses/edit/' . $id);
			
		} 

		//get current subdistricts for 2hour and 1day delivery
		$this->db->select('twohour_subdistrict_id')->from('shipment_method_express')->where('warehouse_id', $id);
		$this->data['current_2hour_subdistrict_id'] = $this->db->get()->result();

		$this->db->select('oneday_subdistrict_id')->from('shipment_method_express')->where('warehouse_id', $id);
		$this->data['current_1day_subdistrict_id'] = $this->db->get()->result();

		//get all cities
		$this->db->select('destination_city, id, destination_province')->from('indah_cargo')->order_by('destination_city', 'ASC');
		$this->data['cities'] = $this->db->get()->result();
		
		$this->data['subview'] = 'admin/warehouse/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 page
	public function delete($id) {

		if($this->data['allowed'] == false || $this->data['role'] == 'admin') { redirect('admin/dashboard'); }

		//check if id exist. If not exist, show 404.
		$count = $this->warehouse_m->count_exist($id);

		if ($count == 0) {  
			//page not exist  
			show_404();
		}		
		
		//delete page
		$this->db->where('id', $id);
		$this->db->delete('warehouse');

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

		$data = array(
			'name' => $this->security->xss_clean($this->input->post('name')),
			'alias' => $this->security->xss_clean($this->input->post('alias')),
			'location' => $this->security->xss_clean($this->input->post('location')),
			'address' => $this->security->xss_clean($this->input->post('address')),
			'phone' => $this->security->xss_clean($this->input->post('phone')),
			'email' => $this->security->xss_clean($this->input->post('email')),
			'warehouse_type' => $this->input->post('warehouse_type'),
			'priority' => $this->input->post('priority'),
			'postcode' =>  $this->security->xss_clean($this->input->post('postcode')),
			'indah_cargo_id' => $this->input->post('city')
		);

		$data['id_province'] = (int) $this->input->post('province');
		$data['id_district'] = (int) $this->input->post('district');
		$data['id_subdistrict'] = (int) $this->input->post('subdistrict');

		//$data['id_country'] =  0;
		//$data['country'] =  'Indonesia';

		//get province name
		/* $this->db->select('province')->from('indonesia_provinces')->where('rajaongkir_province_id', (int) $this->input->post('province'));
		$data['province'] = $this->db->get()->row()->province;

		//get district name
		$this->db->select('district')->from('indonesia_districts')->where('rajaongkir_id_district', (int) $this->input->post('district'));
		$data['district'] = $this->db->get()->row()->district;
		
		//get subdistrict name
		$this->db->select('subdistrict')->from('indonesia_subdistricts')->where('rajaongkir_id_subdistrict', (int) $this->input->post('subdistrict'));
		$data['subdistrict'] = $this->db->get()->row()->subdistrict; */

		return $data;
	}


	//callback function validation priority
	//make it private by adding _
	public function _cek_existing_priority($str) {

		$this->db->select('id');
		$this->db->from('warehouse');
		$this->db->where('priority', (int) $str);

		if ($this->warehouse_current_id != NULL) {
			$this->db->where('priority !=', $this->warehouse_current_priority);	
		} 
		$count_priority = $this->db->get()->num_rows(); 
		 
		if ($count_priority != 0 ) {  
			$this->form_validation->set_message('_cek_existing_priority', 'Priority must be unique!');
			return FALSE;
		} else {
			return TRUE;  
		}
	}
		
}