<?php 
class Offer_model extends CI_Model {
	public function _consruct(){
		parent::_construct();
 	}

 	function get_allusers(){
 		return $this->db->get('users')->result();
 	}

 	function get_allusers_car($data){
 		$this->db->where('car_details.user_id',$data['user_id']);
 		$this->db->select('car_details.id as car_id,car_make.car_type as car_name,car_details.car_type');
 		$this->db->from('car_details');
        $this->db->join('car_make','car_details.car_make=car_make.id','left');
        $query= $this->db->get();
        return $query->result(); 

 	}

 	function offer_departure($request){
        $request['status']=0;
        $request['is_round_trip']=0;
        $query= $this->db->insert('ride',$request);
        return $query;

 	}

 	function car_exist($request){
        $this->db->where('car_id',$request['car_id']);
        $this->db->where('departure_date',$request['departure_date']);
        $this->db->where('detour_time <=',$request['detour_time']);
        $this->db->where('reached_time >=',$request['reached_time']);
        $query= $this->db->get('ride');
        return  $query->result();

     }
     function get_offer_details(){
        $this->db->where('status!=',2);
     	return $this->db->get('ride')->result();
     }

     function view_offer_details_pop($id){
      $this->db->where('id',$id);
      return $this->db->get('ride')->row();
     }

     function offer_delete($id){
        $data=array('status'=>2);
        $this->db->where('id',$id);
        $query=$this->db->update('ride',$data);
        return $query;

     }

     function edit_offer_details($id){
        $this->db->where('id',$id);
        return $this->db->get('ride')->row();
     }

     function get_car_name($id){
        $this->db->where('car_details.id',$id);
        $this->db->select('car_details.id as car_id,car_make.car_type as car_name,car_details.car_type');
        $this->db->from('car_details');
        $this->db->join('car_make','car_details.car_make=car_make.id','left');
        $query= $this->db->get();
        return $query->row(); 

     }

     function offer_departure_update($data,$id){
        $data['status']=0;
        $data['is_round_trip']=0;
        $this->db->where('id',$id);
        $query= $this->db->update('ride',$data);
        return $query;

     }

     function car_exist_edit($request,$id){
        $this->db->where('id!=',$id);
        $this->db->where('car_id',$request['car_id']);
        $this->db->where('departure_date',$request['departure_date']);
        $this->db->where('detour_time <=',$request['detour_time']);
        $this->db->where('reached_time >=',$request['reached_time']);
        $query= $this->db->get('ride');
        return  $query->result();

     }

 	
	 
}