<?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();
    }
}