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

class Bundling_m extends MY_Model { 

	protected $_table_name 	= 'bundling';
	protected $_primary_key = 'id';
	protected $_order_by 	= 'id'; 

	function __construct() {
		parent::__construct();
	}

	public $rules = array(  
		array(
			'field'   => 'bundle_code',
			'label'   => 'Bundle Code',
			'rules'   => 'trim|required|callback__cek_existing_bundle_code'
		),
		array(
			'field'   => 'bundle_name',
			'label'   => 'Bundle Name',
			'rules'   => 'trim|required|callback__cek_existing_bundle_name'
		),
		array(
			'field'   => 'warehouse_id[]',
			'label'   => 'Warehouse',
			'rules'   => 'required'
		),
		array(
			'field'   => 'bundle_stock',
			'label'   => 'Bundle Stock',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'product_type',
			'label'   => 'Product Type',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'golongan_obat',
			'label'   => 'Golongan Obat',
			'rules'   => 'required'
		),
		array(
			'field'   => 'competitor_price',
			'label'   => 'Competitor Price',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'sale_price',
			'label'   => 'Sale Price',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'shipment_id[]',
			'label'   => 'Shipment ID',
			'rules'   => 'required'
		),
		array(
			'field'   => 'dimension_weight',
			'label'   => 'Weight',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'dimension_length',
			'label'   => 'Length',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'dimension_width',
			'label'   => 'Width',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'dimension_height',
			'label'   => 'Height',
			'rules'   => 'trim|required'
		),
		array(
			'field'   => 'category_id[]',
			'label'   => 'Category ID',
			'rules'   => 'required'
		),
    );

     //function to display new product, where all fields are empty
	public function get_new() {
		$bundlings = new stdClass();
		$bundlings->id = '';	
		$bundlings->bundle_name = '';	
		$bundlings->bundle_code = '';	
		$bundlings->bundle_stock = '';	
		$bundlings->product_status = '';	
		$bundlings->description = '';
		$bundlings->description_en = '';
		$bundlings->long_description = '';
		$bundlings->long_description_en = '';
		$bundlings->additional_information = '';
		$bundlings->additional_information_en = '';
		$bundlings->new_arrival = '';
		$bundlings->best_seller = '';	
		$bundlings->popular_product = '';	
		$bundlings->image1 = '';	
		$bundlings->image2 = '';	
		$bundlings->image3 = '';	
		$bundlings->image4 = '';	
		$bundlings->image5 = '';	
		$bundlings->meta_description = '';	
		$bundlings->meta_keywords = '';	
		$bundlings->priority = '';
		$bundlings->bundling = '';
		$bundlings->dimension_weight	= '';
		$bundlings->dimension_length	= '';
		$bundlings->dimension_width	= '';
		$bundlings->dimension_height	= '';
		$bundlings->competitor_price	= '';
		$bundlings->sale_price	= '';
		$bundlings->discounted_price	= '';
		$bundlings->is_sale	= '';
		$bundlings->is_backorder = '';
		$bundlings->is_discontinue = '';
		$bundlings->is_delete = '';
		$bundlings->active_ingredients = '';
		$bundlings->text_satuan_jual = '';
		$bundlings->golongan_obat = '';
		return $bundlings;
	}

	public function cek_existing_bundle_code($str, $bundle_current_id) {
		$this->db->select('id');
		$this->db->from('bundle'); 
		$this->db->where('bundle_code', $str);

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

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

	public function cek_existing_bundle_name($str, $bundle_current_id) {
		$this->db->select('id');
		$this->db->from('bundle'); 
		$this->db->where('bundle_name', $str);

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

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