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



class Warehouse_m extends MY_Model

{



	protected $_table_name = 'warehouse';

	protected $_primary_key = 'id';

	protected $_order_by = 'id';



	public $rules = array(

		array(

			'field'   => 'name',

			'label'   => 'Warehouse Name',

			'rules'   => 'trim|required'

		),



		array(

			'field'   => 'alias',

			'label'   => 'Alias Name',

			'rules'   => 'trim|required'

		),



		array(

			'field'   => 'address',

			'label'   => 'Warehouse Address',

			'rules'   => 'trim|required'

		),



		array(

			'field'   => 'priority',

			'label'   => 'Priority',

			'rules'   => 'trim|required|callback__cek_existing_priority'

		),



		array(

			'field'   => 'phone',

			'label'   => 'Phone',

			'rules'   => 'trim|required'

		),



		'province' => array(

			'field' => 'province',

			'label' => 'Province',

			'rules' => 'trim|required'

		),



		'district' => array(

			'field' => 'district',

			'label' => 'District',

			'rules' => 'trim|required'

		),



		'subdistrict' => array(

			'field' => 'subdistrict',

			'label' => 'Subdistrict',

			'rules' => 'trim|required'

		),



	);



	function __construct()

	{

		parent::__construct();

	}



	//pagination included

	function get_all_warehouse($limit, $start)

	{

		$this->db->select('*');

		$this->db->from('warehouse');

		$this->db->order_by('id');

		$this->db->limit($limit, $start);

		$query = $this->db->get();

		return $query->result();

	}



	//function count all record for warehouse

	public function record_count()

	{

		return $this->db->get('warehouse')->num_rows();

	}



	//function count if existing record exist

	public function count_exist($id)

	{

		$this->db->select('*');

		$this->db->from('warehouse');

		$this->db->where('id', $id);

		$query = $this->db->get();

		return $query->num_rows();

	}



	function get_page($slug)

	{



		$this->db->select('*');

		$this->db->from('warehouse');

		$this->db->where('slug', $slug);

		$query = $this->db->get();

		return $query->row();

	}



	//function to display new page, where all fields are empty

	public function get_new()

	{

		$warehouse = new stdClass();

		$warehouse->name = '';

		$warehouse->alias = '';

		$warehouse->address = '';

		$warehouse->phone = '';

		$warehouse->warehouse_type = '';

		$warehouse->id_province = '';

		$warehouse->priority = '';

		$warehouse->id = '';

		return $warehouse;

	}



	//function add new page

	function add_warehouse($data)

	{

		$this->db->insert('warehouse', $data);

		return $this->db->insert_id();

	}



	//function edit page

	function edit_page($id, $data)

	{

		$this->db->where('id', $id);

		$this->db->update('warehouse', $data);

	}



	//cek if page title already exist

	public function cek_existing_page_title($str, $page_id)

	{

		$this->db->select('id');

		$this->db->from('warehouse');

		$this->db->where('page_title', $str);



		if ($page_id != NULL) {

			$this->db->where('id !=', $page_id);

		}



		$query = $this->db->get();

		return $query->num_rows();

	}





	public function get_parent_warehouse()

	{



		$this->db->select('*')->from('warehouse')->where('parent', NULL);

		$query = $this->db->get();

		$parent_warehouse = $query->result();

		return  $parent_warehouse;

	}



	// Fetch all warehouse

	public function fetch_all_warehouses()

	{

		$this->db->select('*');

		$this->db->from('warehouse');

		$this->db->order_by('priority', 'ASC');



		return $this->db->get()->result();

	}



	public function fetch_warehouse_by_id($warehouse_id)

	{

		return $this->db->get_where('warehouse', ['id' => $warehouse_id])->row();

	}

}