<?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'); 
	}
		
	//this is to list all warehouse 
	public function index() {

		//Add pagination
		$this->load->helper('pagination_helper'); 
		add_pagination(base_url() . 'admin/warehouse/index', $this->warehouse_m->record_count(), 20, 4);
		
   		$this->data['warehouses'] = $this->warehouse_m->get_all_warehouse(20, 
		$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');		
    }

	public function edit($id = NULL) {

		if ($id == NULL) {
			if (($this->data['membership_type']=="starter" && $this->data['jml_gudang']>=1) || ($this->data['membership_type']=="business" && $this->data['jml_gudang']>=3) || (($this->data['membership_type']=="enterprise" || $this->data['membership_type']=="free trial") && $this->data['jml_gudang']>=5)) {
				redirect('admin/warehouses');
			}
			//create new warehouse

		} else {
			


		}

		//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');

			if($subdistrict_rajaongkir_id_array_2hourdelivery != NULL) {
				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);
				}
			}

			if($subdistrict_rajaongkir_id_array_1dayservice != NULL) {
				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();
		
		$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 add a new page 
	public function add() {
	
		$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 province data from RajaOngkir.com API
		//$this->data['provinces'] = get_rajaongkir_data('province'); //get from helper file

		//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');

			if(!empty($subdistrict_rajaongkir_id_array_2hourdelivery)) {
				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);
				}
			}
			
			if(!empty($subdistrict_rajaongkir_id_array_1dayservice)) {
				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');
			
		} 
		
		$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) {

		//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')),
			'address' => $this->security->xss_clean($this->input->post('address')),
			'phone' => $this->security->xss_clean($this->input->post('phone')),
			'warehouse_type' => $this->input->post('warehouse_type'),
			'priority' => $this->input->post('priority')
		);

		$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;  
		}
	}
		
}