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

class Reseller_m extends MY_Model
{

	protected $_table_name = 'resellers';
	protected $_primary_key = 'id_resellers';
	protected $_order_by = 'id_resellers';

	public $admin_rules = array(

		'reseller_name' => array(
			'field' => 'reseller_name',
			'label' => 'reseller_name',
			'rules' => 'trim|required|callback_cek_reseller_name'
		),

		'global_discount' => array(
			'field' => 'global_discount',
			'label' => 'global_discount',
			'rules' => 'trim'
		),




	);


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

	//get reseller by id reseller
	function get_reseller($id_reseller)
	{
		$this->db->select('name, email, phone');
		$this->db->from('resellers');
		$this->db->where('id_resellers', $id_reseller);
		$query = $this->db->get();
		return $query->row();
	}

	//update reseller profile
	function update_profile($id, $data)
	{
		$this->db->where('id_resellers', $id);
		$this->db->update('resellers', $data);
	}

	//get shipping
	function get_shipping($id_reseller)
	{
		$this->db->select('*');
		$this->db->from('resellers');
		$this->db->where('id_resellers', $id_reseller);
		$query = $this->db->get();
		return $query->row();
	}

	//update shipping
	function update_shipping($id, $data)
	{
		$this->db->where('id_resellers', $id);
		$this->db->update('resellers', $data);
	}

	//function to return a new user
	public function get_new()
	{
		$user = new stdClass();
		$user->reseller_name = '';
		$user->global_discount = '';
		$user->minimum_order = '';
		$user->target_point = '';
		$user->voucher_valid = '';
		$user->pointrewards_valid = '';
		$user->active = '';
		return $user;
	}

	//function count all record for resellers
	public function record_count()
	{
		return $this->db->get('resellers')->num_rows();
	}

	//get all reseller with pagination included
	function get_all_resellers($limit, $start)
	{
		$this->db->select('*');
		$this->db->from('resellers');
		$this->db->limit($limit, $start);
		$query = $this->db->get();
		return $query->result();
	}

	//count existing email
	function cek_existing_reseller($reseller_name, $reseller_id)
	{

		$this->db->select('id_resellers');
		$this->db->from('resellers');
		$this->db->where('reseller_name', $reseller_name);
		if ($reseller_id != NULL) {
			$this->db->where('id_resellers !=', $reseller_id);
		}
		$query = $this->db->get();
		return $query->num_rows();
	}
}