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 userTripCancel()
{
$request_id = Request::segment(4);
$owner_id = Session::get('user_id');
$request = Requests::find($request_id);
if ($request->owner_id == $owner_id) {
Requests::where('id', $request_id)->update(array('is_cancelled' => 1));
RequestMeta::where('request_id', $request_id)->update(array('is_cancelled' => 1));
if ($request->confirmed_walker) {
$walker = Walker::find($request->confirmed_walker);
$walker->is_available = 1;
$walker->save();
}
if ($request->current_walker) {
$msg_array = array();
$msg_array['request_id'] = $request_id;
$msg_array['unique_id'] = 2;
$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 = "Request Cancelled";
$message = $msg_array;
send_notifications($request->current_walker, "walker", $title, $message);
}
}
// Redirect
$message = "Your Request is Cancelled.";
$type = "success";
return Redirect::to('/user/trips')->with('message', $message)->with('type', $type);
}
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 schedule_request()
{
/* Cronjob counter */
/* echo asset_url() . "/cron_count.txt"; */
$css_msg = file(asset_url() . "/cron_count.txt");
if ($css_msg[0] > '1000') {
$css_msg[0] = 0;
} else {
$css_msg[0]++;
}
/* echo $css_msg[0]; */
$t = file_put_contents(public_path() . '/cron_count.txt', $css_msg[0]);
$css_msg[0];
/* Cronjob counter END */
$time = date("Y-m-d H:i:s");
$timezone_app = Config::get('app.timezone');
date_default_timezone_set($timezone_app);
$timezone_sys = date_default_timezone_get();
$query = "SELECT request.*,TIMESTAMPDIFF(SECOND,request_start_time, '{$time}') as diff from request where status = 0 and is_cancelled = 0";
$results = DB::select(DB::raw($query));
/* SEND REFERRAL & PROMO INFO */
$settings = Settings::where('key', 'referral_code_activation')->first();
$referral_code_activation = $settings->value;
if ($referral_code_activation) {
$referral_code_activation_txt = "referral on";
} else {
$referral_code_activation_txt = "referral off";
}
$settings = Settings::where('key', 'promotional_code_activation')->first();
$promotional_code_activation = $settings->value;
if ($promotional_code_activation) {
$promotional_code_activation_txt = "promo on";
} else {
$promotional_code_activation_txt = "promo off";
}
/* SEND REFERRAL & PROMO INFO */
$driver_data = "";
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 = Requests::where('id', $result->id)->first();
$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);
$settings = Settings::where('key', 'provider_timeout')->first();
$time_left = $settings->value;
$owner = Owner::find($result->owner_id);
$msg_array = array();
$msg_array['unique_id'] = 1;
$msg_array['request_id'] = $request->id;
$msg_array['time_left_to_respond'] = $time_left;
$msg_array['payment_mode'] = $request->payment_mode;
$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;
$owner = Owner::find($result->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;
if ($request->d_latitude != NULL) {
$request_data['owner']['d_latitude'] = $request->D_latitude;
$request_data['owner']['d_longitude'] = $request->D_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(); */
$msg_array['request_data'] = $request_data;
$title = "New Request";
$message = $msg_array;
Log::info('New Request = ' . print_r($message, true));
send_notifications($request_meta->walker_id, "walker", $title, $message);
$driver_data = array();
$driver_data['unique_id'] = 1;
$driver_data['id'] = "" . $walker->id;
$driver_data['first_name'] = "" . $walker->first_name;
$driver_data['last_name'] = "" . $walker->last_name;
$driver_data['phone'] = "" . $walker->phone;
/* $driver_data['email'] = "" . $walker->email; */
$driver_data['picture'] = "" . $walker->picture;
$driver_data['bio'] = "" . $walker->bio;
/* $driver_data['address'] = "" . $walker->address;
$driver_data['state'] = "" . $walker->state;
$driver_data['country'] = "" . $walker->country;
$driver_data['zipcode'] = "" . $walker->zipcode;
$driver_data['login_by'] = "" . $walker->login_by;
$driver_data['social_unique_id'] = "" . $walker->social_unique_id;
$driver_data['is_active'] = "" . $walker->is_active;
$driver_data['is_available'] = "" . $walker->is_available; */
$driver_data['latitude'] = "" . $walker->latitude;
$driver_data['longitude'] = "" . $walker->longitude;
/* $driver_data['is_approved'] = "" . $walker->is_approved; */
$driver_data['type'] = "" . $walker->type;
$driver_data['car_model'] = "" . $walker->car_model;
$driver_data['car_number'] = "" . $walker->car_number;
$driver_data['rating'] = $walker->rate;
$driver_data['num_rating'] = $walker->rate_count;
/* $driver_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->avg('rating') ? : 0;
$driver_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->count(); */
$client_push_data = array('success' => true, 'unique_id' => 1, 'is_referral_active' => $referral_code_activation, 'is_referral_active_txt' => $referral_code_activation_txt, 'is_promo_active' => $promotional_code_activation, 'is_promo_active_txt' => $promotional_code_activation_txt, 'request_id' => $result->id, 'walker' => $driver_data);
$message1 = $client_push_data;
$owner_data = Owner::find($result->owner_id);
$title1 = "New Driver assigned";
send_notifications($owner_data->id, "owner", $title1, $message1);
} else {
$owner = Owner::find($result->owner_id);
/* CLIENT PUSH FOR GETTING DRIVER DETAILS */
$client_push_data = array('success' => false, 'unique_id' => 1, 'error' => 'No driver found around you.', 'is_referral_active' => $referral_code_activation, 'is_referral_active_txt' => $referral_code_activation_txt, 'is_promo_active' => $promotional_code_activation, 'is_promo_active_txt' => $promotional_code_activation_txt, 'request_id' => $result->id, 'error_code' => 411, 'walker' => $driver_data);
$message1 = $client_push_data;
$owner_data = Owner::find($result->owner_id);
$title1 = "Now Driver Found.";
if ($owner_data->is_deleted == 0) {
send_notifications($owner_data->id, "owner", $title1, $message1);
}
/* CLIENT PUSH FOR GETTING DRIVER DETAILS END */
// request ended
if ($result->promo_id) {
$promo_update_counter = PromoCodes::find($result->promo_id);
$promo_update_counter->uses = $promo_update_counter->uses + 1;
$promo_update_counter->save();
UserPromoUse::where('user_id', '=', $result->owner_id)->where('code_id', '=', $result->promo_id)->delete();
$owner = Owner::find($result->owner_id);
$owner->promo_count = $owner->promo_count - 1;
$owner->save();
$request = Requests::find($result->id);
$request->promo_id = 0;
$request->promo_code = "";
$request->save();
}
Requests::where('id', '=', $result->id)->update(array('current_walker' => 0, 'status' => 1));
/* $driver = Keywords::where('id', 1)->first(); */
$owne = Owner::where('id', $result->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.');
$owner = Owner::find($result->owner_id);
$settings = Settings::where('key', 'sms_request_unanswered')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $result->id, $pattern);
$pattern = str_replace('%user%', $owner->first_name, $pattern);
$pattern = str_replace('%user_mobile%', $owner->phone, $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 Unanswered";
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);
$subject = "New Request Unansweres";
email_notification(1, 'admin', $pattern, $subject, 'request_not_answered', null);
}
}
}
}
