Exemplo n.º 1
0
 /**
  * @param const $method Psc\Net\HTTP\Request::GET|POST|PUT|DELETE
  */
 public function __construct($method, $url, array $inputMeta = array(), array $concreteInput = NULL, $minLength = 2, $delay = 300, $maxResults = NULL)
 {
     parent::__construct($method, $url, $inputMeta, $concreteInput);
     $this->setMinLength($minLength);
     $this->setDelay($delay);
     if (isset($maxResults)) {
         $this->setMaxResults($maxResults);
     }
 }
 public function saveUserRequestTrip()
 {
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $type = Input::get('type');
     $owner_id = Session::get('user_id');
     $owner_data = Owner::find($owner_id);
     $settings = Settings::where('key', 'default_search_radius')->first();
     $distance = $settings->value;
     $query = "SELECT walker.id, 1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and type = {$type} and (1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) <= {$distance}  order by distance";
     $walkers = DB::select(DB::raw($query));
     $walker_list = array();
     $owner = Owner::find($owner_id);
     $owner->latitude = $latitude;
     $owner->longitude = $longitude;
     $owner->save();
     $request = new Requests();
     $request->owner_id = $owner_id;
     $request->type = $type;
     $request->request_start_time = date("Y-m-d H:i:s");
     $request->save();
     $i = 0;
     $first_walker_id = 0;
     foreach ($walkers as $walker) {
         $request_meta = new RequestMeta();
         $request_meta->request_id = $request->id;
         $request_meta->walker_id = $walker->id;
         if ($i == 0) {
             $first_walker_id = $walker->id;
             $i++;
         }
         $request_meta->save();
     }
     $req = Requests::find($request->id);
     $req->current_walker = $first_walker_id;
     $req->confirmed_walker = 0;
     $req->save();
     $settings = Settings::where('key', 'provider_timeout')->first();
     $time_left = $settings->value;
     $message = "Your Request is successful. Please wait while we are finding a nearest cab driver for you.";
     $type = "success";
     return Redirect::to('/user/request-trip')->with('message', $message)->with('type', $type);
     /*
     		// Send Notification
     		$walker = Walker::find($first_walker_id);
     		if($walker){
     		$msg_array = array();
     		$msg_array['unique_id'] = 1;
     		$msg_array['request_id'] = $request->id;
     		$msg_array['time_left_to_respond'] = $time_left;
     		$owner = Owner::find($owner_id);
     		$request_data = array();
     		$request_data['owner'] = array();
     		$request_data['owner']['name'] = $owner->first_name." ".$owner->last_name;
     		$request_data['owner']['picture'] = $owner->picture;
     		$request_data['owner']['phone'] = $owner->phone;
     		$request_data['owner']['address'] = $owner->address;
     		$request_data['owner']['latitude'] = $owner->latitude;
     		$request_data['owner']['longitude'] = $owner->longitude;
     		$request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ?: 0;
     		$request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count();
     		
     		$request_data['dog'] = array();
     		if($dog = Dog::find($owner->dog_id))
     		{
     		
     		$request_data['dog']['name'] = $dog->name;
     		$request_data['dog']['age'] = $dog->age;
     		$request_data['dog']['breed'] = $dog->breed;
     		$request_data['dog']['likes'] = $dog->likes;
     		$request_data['dog']['picture'] = $dog->image_url;
     		}
     		$msg_array['request_data'] = $request_data;
     
     		$title = "New Request";
     		$message = json_encode($msg_array);
     		send_notifications($first_walker_id,"walker",$title,$message);
     		}
     
     
     		// Send SMS 
     		$settings = Settings::where('key','sms_request_created')->first();
     		$pattern = $settings->value;
     		$pattern = str_replace('%user%', $owner_data->first_name." ".$owner_data->last_name, $pattern);
     		$pattern = str_replace('%id%', $request->id, $pattern);
     		$pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern);
     		sms_notification(1,'admin',$pattern);
     
     		// send email
     		$settings = Settings::where('key','email_new_request')->first();
     		$pattern = $settings->value;
     		$pattern = str_replace('%id%', $request->id, $pattern);
     		$pattern = str_replace('%url%', web_url()."/admin/request/map/".$request->id, $pattern);
     		$subject = "New Request Created";
     		email_notification(1,'admin',$pattern,$subject); */
 }
 public function decline_request()
 {
     $request_id = Request::segment(4);
     $walker_id = Session::get('walker_id');
     $request = Requests::find($request_id);
     if ($request->current_walker == $walker_id) {
         // Archiving Old Walker
         RequestMeta::where('request_id', '=', $request_id)->where('walker_id', '=', $walker_id)->update(array('status' => 3));
         $request_meta = RequestMeta::where('request_id', '=', $request_id)->where('status', '=', 0)->orderBy('created_at')->first();
         // update request
         if (isset($request_meta->walker_id)) {
             // assign new walker
             Requests::where('id', '=', $request_id)->update(array('current_walker' => $request_meta->walker_id, 'request_start_time' => date("Y-m-d H:i:s")));
             // Send Notification
             $walker = Walker::find($request_meta->walker_id);
             $owner_data = Owner::find($request->owner_id);
             $msg_array = array();
             $msg_array['request_id'] = $request->id;
             $msg_array['id'] = $request_meta->walker_id;
             if ($walker) {
                 $msg_array['token'] = $walker->token;
             }
             $msg_array['client_profile'] = array();
             $msg_array['client_profile']['name'] = $owner_data->first_name . " " . $owner_data->last_name;
             $msg_array['client_profile']['picture'] = $owner_data->picture;
             $msg_array['client_profile']['bio'] = $owner_data->bio;
             $msg_array['client_profile']['address'] = $owner_data->address;
             $msg_array['client_profile']['phone'] = $owner_data->phone;
             $title = "New Request";
             $message = $msg_array;
             send_notifications($request_meta->walker_id, "walker", $title, $message);
         } else {
             // request ended
             Requests::where('id', '=', $request_id)->update(array('current_walker' => 0, 'status' => 1));
         }
     }
     return Redirect::to('/provider/trips');
 }
 public function schedule_request()
 {
     $time = date("Y-m-d H:i:s");
     $query = "SELECT id,owner_id,current_walker,TIMESTAMPDIFF(SECOND,request_start_time, '{$time}') as diff from request where status = 0 and is_cancelled = 0";
     $results = DB::select(DB::raw($query));
     foreach ($results as $result) {
         $settings = Settings::where('key', 'provider_timeout')->first();
         $timeout = $settings->value;
         if ($result->diff >= $timeout) {
             // Archiving Old Walker
             RequestMeta::where('request_id', '=', $result->id)->where('walker_id', '=', $result->current_walker)->update(array('status' => 2));
             $request_meta = RequestMeta::where('request_id', '=', $result->id)->where('status', '=', 0)->orderBy('created_at')->first();
             // update request
             if (isset($request_meta->walker_id)) {
                 // assign new walker
                 Requests::where('id', '=', $result->id)->update(array('current_walker' => $request_meta->walker_id, 'request_start_time' => date("Y-m-d H:i:s")));
                 // Send Notification
                 $walker = Walker::find($request_meta->walker_id);
                 $owner_data = Owner::find($result->owner_id);
                 $msg_array = array();
                 $msg_array['request_id'] = $result->id;
                 $msg_array['id'] = $request_meta->walker_id;
                 if ($walker) {
                     $msg_array['token'] = $walker->token;
                 }
                 $msg_array['client_profile'] = array();
                 $msg_array['client_profile']['name'] = $owner_data->first_name . " " . $owner_data->last_name;
                 $msg_array['client_profile']['picture'] = $owner_data->picture;
                 $msg_array['client_profile']['bio'] = $owner_data->bio;
                 $msg_array['client_profile']['address'] = $owner_data->address;
                 $msg_array['client_profile']['phone'] = $owner_data->phone;
                 $title = "New Request";
                 $message = $msg_array;
                 send_notifications($request_meta->walker_id, "walker", $title, $message);
             } else {
                 // request ended
                 Requests::where('id', '=', $result->id)->update(array('current_walker' => 0, 'status' => 1));
                 $settings = Settings::where('key', 'sms_request_unanswered')->first();
                 $pattern = $settings->value;
                 $pattern = str_replace('%id%', $result->id, $pattern);
                 sms_notification(1, 'admin', $pattern);
                 // send email
                 $settings = Settings::where('key', 'email_request_unanswered')->first();
                 $pattern = $settings->value;
                 $pattern = str_replace('%id%', $result->id, $pattern);
                 $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $result->id, $pattern);
                 $subject = "New Request Unansweres";
                 email_notification(1, 'admin', $pattern, $subject);
             }
         }
     }
 }
Exemplo n.º 5
0
 public function delete_walker()
 {
     $id = Request::segment(4);
     $success = Input::get('success');
     RequestMeta::where('walker_id', $id)->delete();
     Walker::where('id', $id)->delete();
     return Redirect::to("/admin/providers");
 }
 public function respond_request()
 {
     $token = Input::get('token');
     $walker_id = Input::get('id');
     $request_id = Input::get('request_id');
     $accepted = Input::get('accepted');
     $validator = Validator::make(array('token' => $token, 'walker_id' => $walker_id, 'request_id' => $request_id, 'accepted' => $accepted), array('token' => 'required', 'walker_id' => 'required|integer', 'accepted' => 'required|integer', 'request_id' => 'required|integer'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($walker_data = $this->getWalkerData($walker_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($walker_data->token_expiry) || $is_admin) {
                 // Retrive and validate the Request
                 if ($request = Requests::find($request_id)) {
                     if ($request->current_walker == $walker_id) {
                         if ($accepted == 1) {
                             // request ended
                             Requests::where('id', '=', $request_id)->update(array('confirmed_walker' => $walker_id, 'status' => 1, 'request_start_time' => date('Y-m-d H:i:s')));
                             // confirm walker
                             RequestMeta::where('request_id', '=', $request_id)->where('walker_id', '=', $walker_id)->update(array('status' => 1));
                             // Update Walker availability
                             Walker::where('id', '=', $walker_id)->update(array('is_available' => 0));
                             // remove other schedule_meta
                             RequestMeta::where('request_id', '=', $request_id)->where('status', '=', 0)->delete();
                             // Send Notification
                             $walker = Walker::find($walker_id);
                             $walker_data = array();
                             $walker_data['first_name'] = $walker->first_name;
                             $walker_data['last_name'] = $walker->last_name;
                             $walker_data['phone'] = $walker->phone;
                             $walker_data['bio'] = $walker->bio;
                             $walker_data['picture'] = $walker->picture;
                             $walker_data['latitude'] = $walker->latitude;
                             $walker_data['longitude'] = $walker->longitude;
                             $walker_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->avg('rating') ?: 0;
                             $walker_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->count();
                             $settings = Settings::where('key', 'default_distance_unit')->first();
                             $unit = $settings->value;
                             $bill = array();
                             if ($request->is_completed == 1) {
                                 $bill['distance'] = convert($request->distance, $unit);
                                 $bill['time'] = $request->time;
                                 $bill['base_price'] = $request->base_price;
                                 $bill['distance_cost'] = $request->distance_cost;
                                 $bill['time_cost'] = $request->time_cost;
                                 $bill['total'] = $request->total;
                                 $bill['is_paid'] = $request->is_paid;
                             }
                             $response_array = array('success' => true, 'request_id' => $request_id, 'status' => $request->status, 'confirmed_walker' => $request->confirmed_walker, 'is_walker_started' => $request->is_walker_started, 'is_walker_arrived' => $request->is_walker_arrived, 'is_walk_started' => $request->is_started, 'is_completed' => $request->is_completed, 'is_walker_rated' => $request->is_walker_rated, 'walker' => $walker_data, 'bill' => $bill);
                             $title = "Walker Accepted";
                             $message = $response_array;
                             send_notifications($request->owner_id, "owner", $title, $message);
                             // Send SMS
                             $owner = Owner::find($request->owner_id);
                             $settings = Settings::where('key', 'sms_when_provider_accepts')->first();
                             $pattern = $settings->value;
                             $pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
                             $pattern = str_replace('%driver%', $walker->first_name . " " . $walker->last_name, $pattern);
                             $pattern = str_replace('%Driver_mobile%', $walker->phone, $pattern);
                             sms_notification($request->owner_id, 'owner', $pattern);
                             // Send SMS
                             $settings = Settings::where('key', 'sms_request_completed')->first();
                             $pattern = $settings->value;
                             $pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
                             $pattern = str_replace('%id%', $request->id, $pattern);
                             $pattern = str_replace('%user_mobile%', $owner->phone, $pattern);
                             sms_notification(1, 'admin', $pattern);
                         } else {
                             // Archiving Old Walker
                             RequestMeta::where('request_id', '=', $request_id)->where('walker_id', '=', $walker_id)->update(array('status' => 3));
                             $request_meta = RequestMeta::where('request_id', '=', $request_id)->where('status', '=', 0)->orderBy('created_at')->first();
                             // update request
                             if (isset($request_meta->walker_id)) {
                                 // assign new walker
                                 Requests::where('id', '=', $request_id)->update(array('current_walker' => $request_meta->walker_id, 'request_start_time' => date("Y-m-d H:i:s")));
                                 // Send Notification
                                 $walker = Walker::find($request_meta->walker_id);
                                 $owner_data = Owner::find($request->owner_id);
                                 $msg_array = array();
                                 $msg_array['request_id'] = $request->id;
                                 $msg_array['id'] = $request_meta->walker_id;
                                 if ($walker) {
                                     $msg_array['token'] = $walker->token;
                                 }
                                 $msg_array['client_profile'] = array();
                                 $msg_array['client_profile']['name'] = $owner_data->first_name . " " . $owner_data->last_name;
                                 $msg_array['client_profile']['picture'] = $owner_data->picture;
                                 $msg_array['client_profile']['bio'] = $owner_data->bio;
                                 $msg_array['client_profile']['address'] = $owner_data->address;
                                 $msg_array['client_profile']['phone'] = $owner_data->phone;
                                 $title = "New Request";
                                 $message = $msg_array;
                                 send_notifications($request_meta->walker_id, "walker", $title, $message);
                             } else {
                                 // request ended
                                 Requests::where('id', '=', $request_id)->update(array('current_walker' => 0, 'status' => 1));
                             }
                         }
                         $response_array = array('success' => true);
                         $response_code = 200;
                     } else {
                         $response_array = array('success' => false, 'error' => 'Request ID does not matches Walker ID', 'error_code' => 405);
                         $response_code = 200;
                     }
                 } else {
                     $response_array = array('success' => false, 'error' => 'Request ID Not Found', 'error_code' => 405);
                     $response_code = 200;
                 }
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 $response_array = array('success' => false, 'error' => 'Walker ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }
 public function respond_request()
 {
     $token = Input::get('token');
     $walker_id = Input::get('id');
     $request_id = Input::get('request_id');
     $accepted = Input::get('accepted');
     $date_time = Input::get('datetime');
     $validator = Validator::make(array('token' => $token, 'walker_id' => $walker_id, 'request_id' => $request_id, 'accepted' => $accepted), array('token' => 'required', 'walker_id' => 'required|integer', 'accepted' => 'required|integer', 'request_id' => 'required|integer'));
     /* $driver = Keywords::where('id', 1)->first(); */
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($walker_data = $this->getWalkerData($walker_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($walker_data->token_expiry) || $is_admin) {
                 // Retrive and validate the Request
                 if ($request = Requests::find($request_id)) {
                     if ($request->current_walker == $walker_id) {
                         if ($accepted == 1) {
                             if ($request->later == 1) {
                                 // request ended
                                 Requests::where('id', '=', $request_id)->update(array('confirmed_walker' => $walker_id, 'status' => 1));
                             } else {
                                 Requests::where('id', '=', $request_id)->update(array('confirmed_walker' => $walker_id, 'status' => 1, 'request_start_time' => date('Y-m-d H:i:s')));
                             }
                             // confirm walker
                             RequestMeta::where('request_id', '=', $request_id)->where('walker_id', '=', $walker_id)->update(array('status' => 1));
                             // Update Walker availability
                             Walker::where('id', '=', $walker_id)->update(array('is_available' => 0));
                             // remove other schedule_meta
                             RequestMeta::where('request_id', '=', $request_id)->where('status', '=', 0)->delete();
                             // Send Notification
                             $walker = Walker::find($walker_id);
                             $walker_data = array();
                             $walker_data['first_name'] = $walker->first_name;
                             $walker_data['last_name'] = $walker->last_name;
                             $walker_data['phone'] = $walker->phone;
                             $walker_data['bio'] = $walker->bio;
                             $walker_data['picture'] = $walker->picture;
                             $walker_data['latitude'] = $walker->latitude;
                             $walker_data['longitude'] = $walker->longitude;
                             $walker_data['type'] = $walker->type;
                             $walker_data['rating'] = $walker->rate;
                             $walker_data['num_rating'] = $walker->rate_count;
                             $walker_data['car_model'] = $walker->car_model;
                             $walker_data['car_number'] = $walker->car_number;
                             /* $walker_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->avg('rating') ? : 0;
                                $walker_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->count(); */
                             $settings = Settings::where('key', 'default_distance_unit')->first();
                             $unit = $settings->value;
                             if ($unit == 0) {
                                 $unit_set = 'kms';
                             } elseif ($unit == 1) {
                                 $unit_set = 'miles';
                             }
                             $bill = array();
                             if ($request->is_completed == 1) {
                                 $bill['distance'] = (string) convert($request->distance, $unit);
                                 $bill['unit'] = $unit_set;
                                 $bill['time'] = $request->time;
                                 $bill['base_price'] = $request->base_price;
                                 $bill['distance_cost'] = $request->distance_cost;
                                 $bill['time_cost'] = $request->time_cost;
                                 $bill['total'] = $request->total;
                                 $bill['is_paid'] = $request->is_paid;
                             }
                             /* $setting = Settings::where('key', 'allow_calendar')->first();
                             
                                                               if ($request->later == 1 && $setting->value == 1) { */
                             if ($request->later == 1) {
                                 $date_time = $request->request_start_time;
                                 $datewant = new DateTime($date_time);
                                 $datetime = $datewant->format('Y-m-d H:i:s');
                                 $end_time = $datewant->add(new DateInterval('P0Y0M0DT2H0M0S'))->format('Y-m-d H:i:s');
                                 $provavail = ProviderAvail::where('provider_id', $walker_id)->where('start', '<=', $datetime)->where('end', '>=', $end_time)->first();
                                 $starttime = $provavail->start;
                                 $endtime = $provavail->end;
                                 $provavail->delete();
                                 if ($starttime == $datetime) {
                                     $provavail1 = new ProviderAvail();
                                     $provavail1->provider_id = $walker_id;
                                     $provavail1->start = $end_time;
                                     $provavail1->end = $endtime;
                                     $provavail1->save();
                                 } elseif ($endtime == $end_time) {
                                     $provavail1 = new ProviderAvail();
                                     $provavail1->provider_id = $walker_id;
                                     $provavail1->start = $starttime;
                                     $provavail1->end = $datetime;
                                     $provavail1->save();
                                 } else {
                                     $provavail1 = new ProviderAvail();
                                     $provavail1->provider_id = $walker_id;
                                     $provavail1->start = $starttime;
                                     $provavail1->end = $datetime;
                                     $provavail1->save();
                                     $provavail2 = new ProviderAvail();
                                     $provavail2->provider_id = $walker_id;
                                     $provavail2->start = $end_time;
                                     $provavail2->end = $endtime;
                                     $provavail2->save();
                                 }
                             }
                             $response_array = array('success' => true, 'request_id' => $request_id, 'status' => $request->status, 'confirmed_walker' => $request->confirmed_walker, 'is_walker_started' => $request->is_walker_started, 'is_walker_arrived' => $request->is_walker_arrived, 'is_walk_started' => $request->is_started, 'is_completed' => $request->is_completed, 'is_walker_rated' => $request->is_walker_rated, 'walker' => $walker_data, 'bill' => $bill);
                             /* $driver = Keywords::where('id', 1)->first(); */
                             /* $trip = Keywords::where('id', 4)->first(); */
                             /* $title = '' . $driver->keyword . ' has accepted the ' . $trip->keyword; */
                             $title = '' . Config::get('app.generic_keywords.Provider') . ' has accepted the ' . Config::get('app.generic_keywords.Trip');
                             $message = $response_array;
                             send_notifications($request->owner_id, "owner", $title, $message);
                             // Send SMS
                             $owner = Owner::find($request->owner_id);
                             $settings = Settings::where('key', 'sms_when_provider_accepts')->first();
                             $pattern = $settings->value;
                             $pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
                             $pattern = str_replace('%driver%', $walker->first_name . " " . $walker->last_name, $pattern);
                             $pattern = str_replace('%driver_mobile%', $walker->phone, $pattern);
                             sms_notification($request->owner_id, 'owner', $pattern);
                             // Send SMS
                             $owner = Owner::find($request->owner_id);
                             $src_address = get_address($owner->latitude, $owner->longitude);
                             $pattern = Config::get('app.generic_keywords.User') . " Pickup Address : " . $src_address;
                             sms_notification($walker_id, 'walker', $pattern);
                             // Send SMS
                             $settings = Settings::where('key', 'sms_request_completed')->first();
                             $pattern = $settings->value;
                             $pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
                             $pattern = str_replace('%id%', $request->id, $pattern);
                             $pattern = str_replace('%user_mobile%', $owner->phone, $pattern);
                             sms_notification(1, 'admin', $pattern);
                             //email to client for accept the request
                             $settings = Settings::where('key', 'admin_email_address')->first();
                             $admin_email = $settings->value;
                             $pattern = array('admin_eamil' => $admin_email, 'client_name' => ucwords($owner->first_name . " " . $owner->last_name), 'web_url' => web_url(), 'driver_name' => ucwords($walker->first_name . " " . $walker->last_name), 'driver_contact' => $walker->phone, 'driver_car_model' => $walker->car_model, 'driver_licence' => $walker->car_number);
                             $subject = "Get Ready For Ride";
                             email_notification($owner->id, 'owner', $pattern, $subject, 'accept_request', null);
                         } else {
                             $time = date("Y-m-d H:i:s");
                             $query = "SELECT id,owner_id,current_walker,TIMESTAMPDIFF(SECOND,request_start_time, '{$time}') as diff from request where id = '{$request_id}'";
                             $results = DB::select(DB::raw($query));
                             $settings = Settings::where('key', 'provider_timeout')->first();
                             $timeout = $settings->value;
                             // Archiving Old Walker
                             RequestMeta::where('request_id', '=', $request_id)->where('walker_id', '=', $walker_id)->update(array('status' => 3));
                             $request_meta = RequestMeta::where('request_id', '=', $request_id)->where('status', '=', 0)->orderBy('created_at')->first();
                             // update request
                             if (isset($request_meta->walker_id)) {
                                 Requests::where('id', '=', $request_id)->update(array('current_walker' => $request_meta->walker_id, 'request_start_time' => date("Y-m-d H:i:s")));
                                 // Send Notification
                                 $walker = Walker::find($request_meta->walker_id);
                                 $settings = Settings::where('key', 'provider_timeout')->first();
                                 $time_left = $settings->value;
                                 $owner = Owner::find($request->owner_id);
                                 $msg_array = array();
                                 $msg_array['unique_id'] = 1;
                                 $msg_array['request_id'] = $request->id;
                                 $msg_array['id'] = $request_meta->walker_id;
                                 if ($walker) {
                                     $msg_array['token'] = $walker->token;
                                 }
                                 $msg_array['time_left_to_respond'] = $time_left;
                                 $msg_array['payment_mode'] = $request->payment_mode;
                                 $msg_array['payment_type'] = $request->payment_mode;
                                 $msg_array['time_left_to_respond'] = $timeout;
                                 $msg_array['client_profile'] = array();
                                 $msg_array['client_profile']['name'] = $owner->first_name . " " . $owner->last_name;
                                 $msg_array['client_profile']['picture'] = $owner->picture;
                                 $msg_array['client_profile']['bio'] = $owner->bio;
                                 $msg_array['client_profile']['address'] = $owner->address;
                                 $msg_array['client_profile']['phone'] = $owner->phone;
                                 $request_data = array();
                                 $request_data['owner'] = array();
                                 $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name;
                                 $request_data['owner']['picture'] = $owner->picture;
                                 $request_data['owner']['phone'] = $owner->phone;
                                 $request_data['owner']['address'] = $owner->address;
                                 $request_data['owner']['latitude'] = $owner->latitude;
                                 $request_data['owner']['longitude'] = $owner->longitude;
                                 if ($request->d_latitude != NULL) {
                                     $request_data['owner']['d_latitude'] = $request->D_latitude;
                                     $request_data['owner']['d_longitude'] = $request->D_longitude;
                                 }
                                 $request_data['owner']['owner_dist_lat'] = $request->D_latitude;
                                 $request_data['owner']['owner_dist_long'] = $request->D_longitude;
                                 $request_data['owner']['dest_latitude'] = $request->D_latitude;
                                 $request_data['owner']['dest_longitude'] = $request->D_longitude;
                                 $request_data['owner']['payment_type'] = $request->payment_mode;
                                 $request_data['owner']['rating'] = $owner->rate;
                                 $request_data['owner']['num_rating'] = $owner->rate_count;
                                 /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0;
                                    $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */
                                 $request_data['dog'] = array();
                                 if ($dog = Dog::find($owner->dog_id)) {
                                     $request_data['dog']['name'] = $dog->name;
                                     $request_data['dog']['age'] = $dog->age;
                                     $request_data['dog']['breed'] = $dog->breed;
                                     $request_data['dog']['likes'] = $dog->likes;
                                     $request_data['dog']['picture'] = $dog->image_url;
                                 }
                                 $msg_array['request_data'] = $request_data;
                                 $title = "New Request";
                                 $message = $msg_array;
                                 send_notifications($request_meta->walker_id, "walker", $title, $message);
                             } else {
                                 // request ended
                                 Requests::where('id', '=', $request_id)->update(array('current_walker' => 0, 'status' => 1));
                                 /* $driver = Keywords::where('id', 1)->first(); */
                                 $owne = Owner::where('id', $request->owner_id)->first();
                                 /* $driver_keyword = $driver->keyword; */
                                 $driver_keyword = Config::get('app.generic_keywords.Provider');
                                 $owner_data_id = $owne->id;
                                 send_notifications($owner_data_id, "owner", 'No ' . $driver_keyword . ' Found', 'No ' . $driver_keyword . ' are available right now in your area. Kindly try after sometime.');
                             }
                         }
                         $response_array = array('success' => true);
                         $response_code = 200;
                     } else {
                         /* $response_array = array('success' => false, 'error' => 'Request ID does not matches' . $driver->keyword . ' ID', 'error_code' => 472); */
                         $response_array = array('success' => false, 'error' => 'Request ID does not matches' . Config::get('app.generic_keywords.Provider') . ' ID', 'error_code' => 472);
                         $response_code = 200;
                     }
                 } else {
                     $response_array = array('success' => false, 'error' => 'Request ID Not Found', 'error_code' => 405);
                     $response_code = 200;
                 }
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 /* $response_array = array('success' => false, 'error' => '' . $driver->keyword . ' ID not Found', 'error_code' => 410); */
                 $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.Provider') . ' ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }
Exemplo n.º 8
0
 public function create_request_later()
 {
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $date_time = Input::get('datetime');
     // dd(date('Y-m-d h:i:s', strtotime("$date_time + 2 hours")));
     $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'latitude' => $latitude, 'longitude' => $longitude, 'datetime' => $date_time), array('token' => 'required', 'owner_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required', 'datetime' => 'required'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 // Do necessary operations
                 if ($owner_data->debt > 0) {
                     $response_array = array('success' => false, 'error' => "You are already in \${$owner->debt} debt", 'error_code' => 417);
                     $response_code = 200;
                     $response = Response::json($response_array, $response_code);
                     return $response;
                 }
                 if (Input::has('type')) {
                     $type = Input::get('type');
                     if (!$type) {
                         // choose default type
                         $provider_type = ProviderType::where('is_default', 1)->first();
                         if (!$provider_type) {
                             $type = 1;
                         } else {
                             $type = $provider_type->id;
                         }
                     }
                     $typequery = "SELECT distinct provider_id from walker_services where type IN({$type})";
                     $typewalkers = DB::select(DB::raw($typequery));
                     Log::info('typewalkers = ' . print_r($typewalkers, true));
                     foreach ($typewalkers as $key) {
                         $types[] = $key->provider_id;
                     }
                     $typestring = implode(",", $types);
                     Log::info('typestring = ' . print_r($typestring, true));
                     if ($typestring == '') {
                         /* $driver = Keywords::where('id', 1)->first();
                            $response_array = array('success' => false, 'error' => 'No ' . $driver->keyword . ' found matching the service type.', 'error_code' => 405); */
                         $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found matching the service type.', 'error_code' => 405);
                         $response_code = 200;
                         return Response::json($response_array, $response_code);
                     }
                     $settings = Settings::where('key', 'default_search_radius')->first();
                     $distance = $settings->value;
                     $settings = Settings::where('key', 'default_distance_unit')->first();
                     $unit = $settings->value;
                     if ($unit == 0) {
                         $multiply = 1.609344;
                     } elseif ($unit == 1) {
                         $multiply = 1;
                     }
                     $query1 = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.id IN({$typestring});";
                     $ssstrings = DB::select(DB::raw($query1));
                     foreach ($ssstrings as $ssstrin) {
                         $ssstri[] = $ssstrin->id;
                     }
                     $ssstring = implode(",", $ssstri);
                     $datewant = new DateTime($date_time);
                     $datetime = $datewant->format('Y-m-d H:i:s');
                     $dategiven = $datewant->sub(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     $end_time = $datewant->add(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     /* $setting = Settings::where('key', 'allow_calendar')->first();
                        if ($setting->value == 1)
                        $pvquery = "SELECT distinct provider_id from provider_availability where start <= '" . $datetime . "' and end >= '" . $datetime . "' and provider_id IN($ssstring) and provider_id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                        else */
                     $pvquery = "SELECT id from walker where id IN({$ssstring}) and id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                     $pvques = DB::select(DB::raw($pvquery));
                     //  dd($pvques);
                     $ssstr = array();
                     foreach ($pvques as $ssstn) {
                         $ssstr[] = $ssstn->provider_id;
                     }
                     $pvque = implode(",", $ssstr);
                     $walkers = array();
                     if ($pvque) {
                         $settings = Settings::where('key', 'default_distance_unit')->first();
                         $unit = $settings->value;
                         if ($unit == 0) {
                             $multiply = 1.609344;
                         } elseif ($unit == 1) {
                             $multiply = 1;
                         }
                         $query = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.id IN({$typestring}) and id IN({$pvque}) order by distance;";
                         $walkers = DB::select(DB::raw($query));
                     }
                     $walker_list = array();
                     $owner = Owner::find($owner_id);
                     $owner->latitude = $latitude;
                     $owner->longitude = $longitude;
                     $owner->save();
                     $request = new Requests();
                     $request->owner_id = $owner_id;
                     $request->request_start_time = $datetime;
                     $request->later = 1;
                     if (Input::has('cod')) {
                         if (Input::get('cod') == 1) {
                             $request->cod = 1;
                         } else {
                             $request->cod = 0;
                         }
                     }
                     $request->save();
                     $reqserv = new RequestServices();
                     $reqserv->request_id = $request->id;
                     $reqserv->type = $type;
                     $reqserv->save();
                 } else {
                     $settings = Settings::where('key', 'default_search_radius')->first();
                     $distance = $settings->value;
                     $settings = Settings::where('key', 'default_distance_unit')->first();
                     $unit = $settings->value;
                     if ($unit == 0) {
                         $multiply = 1.609344;
                     } elseif ($unit == 1) {
                         $multiply = 1;
                     }
                     $query1 = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance};";
                     $ssstrings = DB::select(DB::raw($query1));
                     foreach ($ssstrings as $ssstrin) {
                         $ssstri[] = $ssstrin->id;
                     }
                     $ssstring = implode(",", $ssstri);
                     $datewant = new DateTime($date_time);
                     $datetime = $datewant->format('Y-m-d H:i:s');
                     $dategiven = $datewant->sub(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     $end_time = $datewant->add(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     /* $setting = Settings::where('key', 'allow_calendar')->first();
                        if ($setting->value == 1)
                        $pvquery = "SELECT distinct provider_id from provider_availability where start <= '" . $datetime . "' and end >= '" . $datetime . "' and provider_id IN($ssstring) and provider_id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                        else */
                     $pvquery = "SELECT id from walker where id IN({$ssstring}) and id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                     $pvques = DB::select(DB::raw($pvquery));
                     $ssstr = array();
                     foreach ($pvques as $ssstn) {
                         $ssstr[] = $ssstn->provider_id;
                     }
                     $pvque = implode(",", $ssstr);
                     $walkers = array();
                     if ($pvque) {
                         $settings = Settings::where('key', 'default_distance_unit')->first();
                         $unit = $settings->value;
                         if ($unit == 0) {
                             $multiply = 1.609344;
                         } elseif ($unit == 1) {
                             $multiply = 1;
                         }
                         $query = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and id IN({$pvque}) order by distance;";
                         $walkers = DB::select(DB::raw($query));
                     }
                     $walker_list = array();
                     $owner = Owner::find($owner_id);
                     $owner->latitude = $latitude;
                     $owner->longitude = $longitude;
                     $owner->save();
                     $request = new Requests();
                     $request->owner_id = $owner_id;
                     $request->request_start_time = $datetime;
                     $request->save();
                     $reqserv = new RequestServices();
                     $reqserv->request_id = $request->id;
                     $reqserv->save();
                 }
                 $i = 0;
                 $first_walker_id = 0;
                 if ($walkers) {
                     foreach ($walkers as $walker) {
                         $request_meta = new RequestMeta();
                         $request_meta->request_id = $request->id;
                         $request_meta->walker_id = $walker->id;
                         if ($i == 0) {
                             $first_walker_id = $walker->id;
                             $i++;
                         }
                         $request_meta->save();
                     }
                     $req = Requests::find($request->id);
                     $req->current_walker = $first_walker_id;
                     $req->save();
                 }
                 $settings = Settings::where('key', 'provider_timeout')->first();
                 $time_left = $settings->value;
                 // Send Notification
                 $walker = Walker::find($first_walker_id);
                 if ($walker) {
                     $msg_array = array();
                     $msg_array['unique_id'] = 3;
                     $msg_array['request_id'] = $request->id;
                     $msg_array['time_left_to_respond'] = $time_left;
                     $owner = Owner::find($owner_id);
                     $request_data = array();
                     $request_data['owner'] = array();
                     $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name;
                     $request_data['owner']['picture'] = $owner->picture;
                     $request_data['owner']['phone'] = $owner->phone;
                     $request_data['owner']['address'] = $owner->address;
                     $request_data['owner']['latitude'] = $owner->latitude;
                     $request_data['owner']['longitude'] = $owner->longitude;
                     $request_data['owner']['rating'] = $owner->rate;
                     $request_data['owner']['num_rating'] = $owner->rate_count;
                     /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0;
                        $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */
                     $date_want = new DateTime($date_time);
                     $datetime1 = $date_want->format('Y-m-d H:i:s');
                     $request_data['datetime'] = $datetime1;
                     $request_data['dog'] = array();
                     if ($dog = Dog::find($owner->dog_id)) {
                         $request_data['dog']['name'] = $dog->name;
                         $request_data['dog']['age'] = $dog->age;
                         $request_data['dog']['breed'] = $dog->breed;
                         $request_data['dog']['likes'] = $dog->likes;
                         $request_data['dog']['picture'] = $dog->image_url;
                     }
                     $msg_array['request_data'] = $request_data;
                     $title = "New Request";
                     $message = $msg_array;
                     Log::info('first_walker_id = ' . print_r($first_walker_id, true));
                     Log::info('New request = ' . print_r($message, true));
                     /* don't do json_encode in above line because if */
                     send_notifications($first_walker_id, "walker", $title, $message);
                 }
                 // Send SMS
                 $settings = Settings::where('key', 'sms_request_created')->first();
                 $pattern = $settings->value;
                 $pattern = str_replace('%user%', $owner_data->first_name . " " . $owner_data->last_name, $pattern);
                 $pattern = str_replace('%id%', $request->id, $pattern);
                 $pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern);
                 sms_notification(1, 'admin', $pattern);
                 // send email
                 /* $settings = Settings::where('key', 'email_new_request')->first();
                    $pattern = $settings->value;
                    $pattern = str_replace('%id%', $request->id, $pattern);
                    $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern);
                    $subject = "New Request Created";
                    email_notification(1, 'admin', $pattern, $subject); */
                 $settings = Settings::where('key', 'admin_email_address')->first();
                 $admin_email = $settings->value;
                 $follow_url = web_url() . "/user/signin";
                 $pattern = array('admin_eamil' => $admin_email, 'trip_id' => $request->id, 'follow_url' => $follow_url);
                 $subject = "Ride Booking Request";
                 email_notification(1, 'admin', $pattern, $subject, 'new_request', null);
                 $response_array = array('success' => true, 'request_id' => $request->id);
                 $response_code = 200;
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 /* $var = Keywords::where('id', 2)->first();
                    $response_array = array('success' => false, 'error' => '' . $var->keyword . ' ID not Found', 'error_code' => 410); */
                 $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.User') . ' ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }
 public function saveUserRequestTrip()
 {
     Session::forget('skipReview');
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $d_latitude = Input::get('d_latitude');
     $d_longitude = Input::get('d_longitude');
     $type = Input::get('type');
     $owner_id = Session::get('user_id');
     $payment_type = Input::get('payment_type');
     if ($type == "") {
         $message = "Please Select the Service Type";
         $type = "warning";
         return Redirect::route('userrequestTrip')->with('message', $message)->with('type', $type);
     } else {
         if (Input::has('promo_code')) {
             $promo_code = Input::get('promo_code');
             $code_check = PromoCodes::where('coupon_code', $promo_code)->first();
             if ($code_check == NULL) {
                 $message = "Invalid Promo Code";
                 $type = "error";
                 return Redirect::route('userrequestTrip')->with('message', $message)->with('type', $type);
             } else {
                 if ($code_check->state == 1 && date('Y-m-d H:i:s', strtotime($code_check->expiry)) > date('Y-m-d H:i:s')) {
                     $code_id = $code_check->id;
                 } else {
                     $message = "Invalid Promo Code";
                     $type = "error";
                     return Redirect::route('userrequestTrip')->with('message', $message)->with('type', $type);
                 }
             }
         } else {
             $code_id = NULL;
         }
         $owner_data = Owner::find($owner_id);
         $settings = Settings::where('key', 'default_search_radius')->first();
         $distance = $settings->value;
         if (Input::has('type')) {
             $type = Input::get('type');
             if (!$type) {
                 // choose default type
                 $provider_type = ProviderType::where('is_default', 1)->first();
                 if (!$provider_type) {
                     $type = 1;
                 } else {
                     $type = $provider_type->id;
                 }
             }
         }
         $typequery = "SELECT distinct provider_id from walker_services where type IN({$type})";
         $typewalkers = DB::select(DB::raw($typequery));
         /* $var = Keywords::where('id', 1)->first(); */
         if (empty($typewalkers)) {
             /* $message = "No " . $var->keyword . " found matching the service type."; */
             $message = "No " . Config::get('app.generic_keywords.Provider') . " found matching the service type.";
         } else {
             Log::info('typewalkers = ' . print_r($typewalkers, true));
             foreach ($typewalkers as $key) {
                 $types[] = $key->provider_id;
             }
             $typestring = implode(",", $types);
             Log::info('typestring = ' . print_r($typestring, true));
             if ($typestring == '') {
                 /* $message = "No " . $var->keyword . " found matching the service type."; */
                 $message = "No " . Config::get('app.generic_keywords.Provider') . " found matching the service type.";
             }
             $settings = Settings::where('key', 'default_search_radius')->first();
             $distance = $settings->value;
             $settings = Settings::where('key', 'default_distance_unit')->first();
             $unit = $settings->value;
             if ($unit == 0) {
                 $multiply = 1.609344;
             } elseif ($unit == 1) {
                 $multiply = 1;
             }
             $query = "SELECT walker.*, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.deleted_at IS NULL and walker.id IN({$typestring}) order by distance";
             $walkers = DB::select(DB::raw($query));
             $walker_list = array();
             $owner = Owner::find($owner_id);
             $owner->latitude = $latitude;
             $owner->longitude = $longitude;
             $owner->save();
             $user_timezone = $owner->timezone;
             $default_timezone = Config::get('app.timezone');
             $offset = $this->get_timezone_offset($default_timezone, $user_timezone);
             $request = new Requests();
             $request->owner_id = $owner_id;
             if ($d_longitude != '' && $d_latitude != '') {
                 $request->D_latitude = $d_latitude;
                 $request->D_longitude = $d_longitude;
             }
             $request->request_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d H:i:s")) + $offset);
             $request->save();
             $request_service = new RequestServices();
             $request_service->type = $type;
             $request_service->request_id = $request->id;
             $request_service->save();
             $i = 0;
             $first_walker_id = 0;
             foreach ($walkers as $walker) {
                 $request_meta = new RequestMeta();
                 $request_meta->request_id = $request->id;
                 $request_meta->walker_id = $walker->id;
                 if ($i == 0) {
                     $first_walker_id = $walker->id;
                     $i++;
                 }
                 $request_meta->save();
             }
             $req = Requests::find($request->id);
             $req->current_walker = $first_walker_id;
             $req->confirmed_walker = 0;
             $req->payment_mode = $payment_type;
             $req->promo_code = $code_id;
             $req->save();
             $settings = Settings::where('key', 'provider_timeout')->first();
             $time_left = $settings->value;
             /* $var = Keywords::where('id', 1)->first();
             
                               $message = "Your Request is successful. Please wait while we are finding a nearest " . $var->keyword . " for you."; */
             $message = "Your Request is successful. Please wait while we are finding a nearest " . Config::get('app.generic_keywords.Provider') . " for you.";
             $type = "success";
         }
         return Redirect::to('/user/request-trip')->with('message', $message)->with('type', $type);
         // Send Notification
         $walker = Walker::find($first_walker_id);
         if ($walker) {
             $msg_array = array();
             $msg_array['unique_id'] = 1;
             $msg_array['request_id'] = $request->id;
             $msg_array['time_left_to_respond'] = $time_left;
             $owner = Owner::find($owner_id);
             $request_data = array();
             $request_data['owner'] = array();
             $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name;
             $request_data['owner']['picture'] = $owner->picture;
             $request_data['owner']['phone'] = $owner->phone;
             $request_data['owner']['address'] = $owner->address;
             $request_data['owner']['latitude'] = $owner->latitude;
             $request_data['owner']['longitude'] = $owner->longitude;
             /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0; */
             $request_data['owner']['rating'] = $owner->rate;
             /* $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */
             $request_data['owner']['num_rating'] = $owner->rate_count;
             $request_data['dog'] = array();
             if ($dog = Dog::find($owner->dog_id)) {
                 $request_data['dog']['name'] = $dog->name;
                 $request_data['dog']['age'] = $dog->age;
                 $request_data['dog']['breed'] = $dog->breed;
                 $request_data['dog']['likes'] = $dog->likes;
                 $request_data['dog']['picture'] = $dog->image_url;
             }
             $msg_array['request_data'] = $request_data;
             $title = "New Request";
             $message = json_encode($msg_array);
             send_notifications($first_walker_id, "walker", $title, $message);
         }
         // Send SMS
         $settings = Settings::where('key', 'sms_request_created')->first();
         $pattern = $settings->value;
         $pattern = str_replace('%user%', $owner_data->first_name . " " . $owner_data->last_name, $pattern);
         $pattern = str_replace('%id%', $request->id, $pattern);
         $pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern);
         sms_notification(1, 'admin', $pattern);
         // send email
         /* $settings = Settings::where('key', 'email_new_request')->first();
            $pattern = $settings->value;
            $pattern = str_replace('%id%', $request->id, $pattern);
            $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern);
            $subject = "New Request Created";
            email_notification(1, 'admin', $pattern, $subject); */
         $settings = Settings::where('key', 'admin_email_address')->first();
         $admin_email = $settings->value;
         $follow_url = web_url() . "/user/signin";
         $pattern = array('admin_eamil' => $admin_email, 'trip_id' => $request->id, 'follow_url' => $follow_url);
         $subject = "Ride Booking Request";
         email_notification(1, 'admin', $pattern, $subject, 'new_request', null);
         return Redirect::to('/user/request-trip')->with('message', $message)->with('type', $type);
     }
 }