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

class Mjobhistory extends CI_Model {
	var $table = 'job';	
    var $column_order = array('job_id','categories.category_name','job_date','client_name','job_address','city.name',null); //set column field database for datatable orderable
    var $column_search = array('job_id','categories.category_name','DATE_FORMAT(job_date, "%d/%m/%Y")','client_name','job_address','city.name'); //set column field database for datatable searchable just firstname , lastname , address are searchable
    var $order = array('job_id' => 'desc'); // default order 
    public function __construct() {
        parent::__construct();
    }
	private function _get_datatables_query(){
		$this->db->select('*,DATE_FORMAT(job_date, "%d/%m/%Y") job_date');
        $this->db->from($this->table);
		$this->db->join('categories','job.cat_id=categories.category_id','left');
		$this->db->join('city','job.city_id=city.city_id','left');
		$this->db->where('is_applied',0);
		$this->db->where('job_date <', date('Y-m-d'));	
        $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();
        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->where('is_applied',0);	
		$this->db->where('job_date <', date('Y-m-d'));
		//$this->db->where('role_id=1');
		//$this->db->where('admin_id='.$logged_in_admin_id);
        return $this->db->count_all_results();
    }
	
	public function get_details($job_id){
        $this->db->from($this->table);        
        $this->db->where('job_id',$job_id);
        $query=$this->db->get();
        return $query->row_array();
    }
	}