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

class Madmin extends CI_Model {

	var $table = 'admins';
    var $column_order = array('admin_id','name','phoneno','client_name','admins.date_of_creation',null); //set column field database for datatable orderable
    var $column_search = array('name','phoneno','client_name','admins.date_of_creation'); //set column field database for datatable searchable just firstname , lastname , address are searchable
    var $order = array('role_id' => 'asc'); // default order 
    public function __construct() {
        parent::__construct();
    }
    private function _get_datatables_query(){
        $this->db->from($this->table);
        $this->db->join('clients', 'clients.client_id = admins.client_id');
        //$this->db->join('branches', 'branches.branch_id = clients.branch_id');
        $i = 0;
        foreach ($this->column_search as $item){ // loop column 
            if($_POST['search']['value']){ // if datatable send POST for search
                 
                if($i===0){ // first loop
                    $this->db->group_start(); // open bracket. query Where with OR clause better with bracket. because maybe can combine with other WHERE with AND.
                    $this->db->like($item, $_POST['search']['value']);
                }
                else{
                    $this->db->or_like($item, $_POST['search']['value']);
                }
                if(count($this->column_search) - 1 == $i) //last loop
                $this->db->group_end(); //close bracket
            }
            $i++;
        }
         
        if(isset($_POST['order'])){ // here order processing
            $this->db->order_by($this->column_order[$_POST['order']['0']['column']], $_POST['order']['0']['dir']);
        }else if(isset($this->order)){
            $order = $this->order;
            $this->db->order_by(key($order), $order[key($order)]);
        }
    }
    public function get_datatables(){   
        $this->_get_datatables_query();
        if($_POST['length'] != -1)
        $this->db->limit($_POST['length'], $_POST['start']);
        $query = $this->db->get();
       // echo $this->db->last_query(); die;
        return $query->result();
    }
    public function count_filtered(){
        $this->_get_datatables_query();
        $query = $this->db->get();
        return $query->num_rows();
    }
    public function count_all(){
        $this->db->from($this->table);
        $this->db->join('clients', 'clients.client_id = admins.client_id');
        //$this->db->join('branches', 'branches.branch_id = clients.branch_id');
        return $this->db->count_all_results();
    }
    public function get_details($admin_id){
        $this->db->from($this->table);
        $this->db->join('clients', 'clients.client_id = admins.client_id');
        $this->db->where('admin_id',$admin_id);
        $query=$this->db->get();
        return $query->row_array();
    }
    public function update($condition,$data){
        $this->db->where($condition);
        $this->db->update($this->table,$data);
        return 1;
    }
    public function add($data){
        $this->db->insert($this->table,$data);
        return $this->db->insert_id();
    }
    public function delete($condition){
        $this->db->delete($this->table,$condition);
        return 1;
    }
	public function user_check($email, $password) {
		$this->db->select('admins.*,roles.*,admins.status as admin_status');
		$this->db->from('admins');
		$this->db->join('roles','roles.role_id=admins.role_id');
		$this->db->where(array('email' => $email, 'password' => sha1($password)));
		$query = $this->db->get();
		return $query->row_array();
	}
	public function user_details($user_id){
		$this->db->select('*');
		$this->db->from('admins ad');
		$this->db->join('roles rl','rl.role_id=ad.role_id');
		$this->db->where(array('admin_id' => $user_id));
		$query = $this->db->get();
		return $query->row_array();
	}
	public function user_all_details($email=null,$user_id=null){
		$this->db->select('*');
		$this->db->from('admins ad');
		$this->db->join('roles rl','rl.role_id=ad.role_id');
		if(!empty($email)){
			$this->db->where(array('email' => $email));
		}else if(!empty($user_id)){
			$this->db->where(array('admin_id' => $user_id));
		}
		$query = $this->db->get();
		return $query->row_array();
	}
	public function admin_branch_list($branch_id){
		$ids=explode(',',$branch_id);
		$this->db->select('branch_id,branch_name');
		$this->db->from('branches');
		$this->db->where_in('branch_id',$ids);
		$query=$this->db->get();
		return $query->result_array(); 
	}
	
	public function setting_value()
	{
		$this->db->select('*');
		$this->db->from('settings');	
		$query = $this->db->get();
		return $query->row_array();
	}
	
	public function update_setting($condition,$data){
        $this->db->where($condition);
        $this->db->update('settings',$data);
        return 1;
    }
}