<?php
class Mbookingreport extends CI_Model {
	var $table = 'job_service_date';
    var $column_order = array('user_roaster_id','name',null); //set column field database for datatable orderable
    var $column_search = array('user_roaster_id','CONCAT(admins.first_name," ",admins.last_name)'); //set column field database for datatable searchable just firstname , lastname , address are searchable
    var $order = array('user_roaster_id' => 'desc'); // default order 
    public function __construct() {
        parent::__construct();
    }

	
	public function get_details($first_date,$last_date){


          
          $this->db->distinct();
          $this->db->select('job_service_date.service_date');
          $this->db->from("job_service_date");    
          $this->db->join('car','car.car_id=job_service_date.car_id','left');
          $this->db->join('assign_job','assign_job.job_id=job_service_date.job_id','left'); 
        //  $this->db->join('admins','admins.admin_id=assign_job.job_id','left'); 
          $this->db->where("job_service_date.service_date>=",$first_date);
          $this->db->where("job_service_date.service_date<=",$last_date);
          $query = $this->db->get();
         // $query = $this->db->last_query();
         // echo $query; die;
           return $query->result_array();
    }

      public function get_service_details($service_date){


          $this->db->select('job_service_date.service_date,car.car_no,assign_job.mechanic_id');
          $this->db->from("job_service_date");    
          $this->db->join('car','car.car_id=job_service_date.car_id','left');
          $this->db->join('assign_job','assign_job.job_id=job_service_date.job_id','left'); 
        //  $this->db->join('admins','admins.admin_id=assign_job.job_id','left'); 
          $this->db->where("job_service_date.service_date",$service_date);
          $query = $this->db->get();
          //$query = $this->db->last_query();
          //echo $query; die;
           return $query->result_array();
    }

      public function get_mechanic_details($mec_id){
          $this->db->select('*');
          $this->db->from("admins");    
          $this->db->where('admins.admin_id',$mec_id);
          $query = $this->db->get();
         // $query = $this->db->last_query();
          //echo $query; die;
           return $query->row_array();
    }

    public function getServices($job_id){
      $this->db->from("job_services");		
      $this->db->join('service','service.service_id=job_services.service_id','left');	
      $this->db->where('job_id',$job_id);		
      $this->db->where('service.status',1);
      $query=$this->db->get();
          return $query->result_array();
      
    }

    public function assignedJob($condition)
	{
		$this->db->select('*');
		$this->db->from("assign_job");		
		$this->db->join('job','job.job_id=assign_job.job_id','LEFT');			
		$this->db->where($condition);		
		$query=$this->db->get();
        return $query->result_array();
	}

 
	

}
?>