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

class Category_m extends MY_Model {
	
	protected $_table_name = 'categories';
	protected $_primary_key = 'id_categories';
	protected $_order_by = 'id_categories'; 

	public $rules = array(  
			array(
					'field'   => 'category_name',
					'label'   => 'Category Name',
					'rules'   => 'trim|required',
					/* 'rules'   => 'trim|required|callback__cek_existing_category_title' */
			),
			array(
					'field'   => 'status', 
					'label'   => 'status',
					'rules'   => 'trim|required' 
			),  
			array(
				'field'   => 'can_download_catalog', 
				'label'   => 'can_download_catalog',
				'rules'   => 'trim|required' 
		),  
		array(
			'field'   => 'can_request_sample', 
			'label'   => 'can_request_sample',
			'rules'   => 'trim|required' 
	),  
			array(
				'field'   => 'min_show_qty', 
				'label'   => 'Min show qty',
				'rules'   => 'trim|required'
		),  
			array(
					'field'   => 'description', 
					'label'   => 'description',
					'rules'   => 'trim'
			),  
			array(
					'field'   => 'priority',
					'label'   => 'priority',
					'rules'   => 'trim|required|numeric'
			),   
			array(
					'field'   => 'meta_description',
					'label'   => 'meta_description',
					'rules'   => 'trim' 
			),          
	);

	function __construct() 
	{ 
			parent::__construct();	
	}	
	
	//pagination included
	function get_all_categories($limit, $start) 
	{ 
			$this->db->select('*');
			$this->db->from('categories');
			$this->db->where('id_categories !=', '0'); 
			$this->db->order_by('parent', 'ASC');
			$this->db->order_by('priority', 'ASC');
			$this->db->limit($limit, $start);
			$query = $this->db->get();		
			return $query->result();  
	}

	public function get_all_parent_categories($limit, $start) 
	{
			$this->db->select('id_categories, category, parent, priority, status');
			$this->db->from('categories');
			$this->db->where('parent', NULL); 
			$this->db->order_by('priority', 'ASC');
			$this->db->limit($limit, $start);
			$query = $this->db->get();		
			return $query->result();
	}

	//function to display new category, where all fields are empty
	public function get_new() 
	{
			$categories = new stdClass();
			$categories->category = '';	
			$categories->parent = '';	
			$categories->status = '';
			$categories->description = '';	
			$categories->priority = '';	
			$categories->meta_description = '';	
			$categories->banner_link = '';
			$categories->min_show_qty = 1;
			$categories->can_download_catalog = '';
			$categories->can_request_sample = '';
			return $categories;
	}

	//get all categories 
	function get_categories() 
	{
			$this->db->select('*');
			$this->db->from('categories');
			$this->db->order_by('id_categories asc');
			$query = $this->db->get();		
			return $query->result();
	}
	
	//function add new category
	function add_category($data) 
	{
			$this->db->insert('categories', $data);	
			return $this->db->insert_id();	 
	}
	
	//function edit category
	function edit_category($id, $data) 
	{
			$this->db->where('id_categories', $id);
			$this->db->update('categories', $data);	
	}
	
	//function count all record for category
	public function record_count() 
	{
      return $this->db->get('categories')->num_rows();
  }

  //function count if existing record exist
	public function count_exist($id) 
	{
			$this->db->select('*');
			$this->db->from('categories');
			$this->db->where('id_categories', $id);
			$query = $this->db->get();		
			return $query->num_rows();
  }

  //FOR FRONT END REGISTRATION PAGE
    
  //get all categories to display at front registration page, with status display 1 only
	function get_categories_display_on() 
	{
			$this->db->select('*');
			$this->db->from('categories');
			$this->db->where('status', '1');
			$this->db->where('id_categories !=', '0');
			$this->db->order_by('id_categories asc');
			$query = $this->db->get();		
			return $query->result();
	}

	//cek if brand title already exist
	public function cek_existing_category_title($str, $category_id) 
	{
			$this->db->select('id_categories');
			$this->db->from('categories');
			$this->db->where('category', $str);

			if ($category_id != NULL) 
			{
					$this->db->where('id_categories !=', $category_id);	
			} 

			$query = $this->db->get();
			return $query->num_rows();
	}

	public function get_parent_categories() 
	{
			$this->db->select('*')->from('categories')->where('parent', NULL);
			$query = $this->db->get();
			$parent_categories = $query->result();	
			return  $parent_categories;
	}	
}