/** * @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); } } } }
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; }
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); } }