public function types()
{
$types = ProviderType::where('is_visible', '=', 1)->get();
/* $setbase_price = Settings::where('key', 'base_price')->first();
$base_price = $setbase_price->value;
$setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
$distance_price = $setdistance_price->value;
$settime_price = Settings::where('key', 'price_per_unit_time')->first();
$time_price = $settime_price->value; */
$type_array = array();
$settunit = Settings::where('key', 'default_distance_unit')->first();
$unit = $settunit->value;
if ($unit == 0) {
$unit_set = 'kms';
} elseif ($unit == 1) {
$unit_set = 'miles';
}
/* $currency_selected = Keywords::find(5); */
foreach ($types as $type) {
$data = array();
$data['id'] = $type->id;
$data['name'] = $type->name;
$data['min_fare'] = $type->base_price;
$data['max_size'] = $type->max_size;
$data['icon'] = $type->icon;
$data['is_default'] = $type->is_default;
$data['price_per_unit_time'] = currency_converted($type->price_per_unit_time);
$data['price_per_unit_distance'] = currency_converted($type->price_per_unit_distance);
$data['base_price'] = currency_converted($type->base_price);
$data['base_distance'] = currency_converted($type->base_distance);
/* $data['currency'] = $currency_selected->keyword; */
$data['currency'] = Config::get('app.generic_keywords.Currency');
$data['unit'] = $unit_set;
array_push($type_array, $data);
}
$response_array = array();
$response_array['success'] = true;
$response_array['types'] = $type_array;
$response_code = 200;
$response = Response::json($response_array, $response_code);
return $response;
}
public function types()
{
$types = ProviderType::all();
$type_array = array();
foreach ($types as $type) {
$data = array();
$data['id'] = $type->id;
$data['name'] = $type->name;
$data['icon'] = $type->icon;
$data['is_default'] = $type->is_default;
$data['price_per_unit_time'] = $type->price_per_unit_time;
$data['price_per_unit_distance'] = $type->price_per_unit_distance;
$data['base_price'] = $type->base_price;
array_push($type_array, $data);
}
$response_array = array();
$response_array['success'] = true;
$response_array['types'] = $type_array;
$response_code = 200;
$response = Response::json($response_array, $response_code);
return $response;
}
public function userRequestTrip()
{
$date = date("Y-m-d H:i:s");
$time_limit = date("Y-m-d H:i:s", strtotime($date) - 3 * 60 * 60);
$owner_id = Session::get('user_id');
$current_request = Requests::where('owner_id', $owner_id)->where('is_cancelled', 0)->where('created_at', '>', $time_limit)->orderBy('created_at', 'desc')->where(function ($query) {
$query->where('status', 0)->orWhere(function ($query_inner) {
$query_inner->where('status', 1)->where('is_walker_rated', 0)->where('confirmed_walker', '>', 0);
});
})->first();
if (!$current_request || $current_request->is_walker_rated == 1) {
$payments = Payment::where('owner_id', Session::get('user_id'))->count();
if ($payments != 0) {
$types = ProviderType::all();
return View::make('web.userRequestTrip')->with('title', 'Request Trip')->with('types', $types)->with('page', 'request-trip');
} else {
$message = "You should add atleast one credit card to request a Trip.";
$type = "danger";
return Redirect::to('/user/payments')->with('message', $message)->with('type', $type);
}
} else {
$owner = Owner::find($owner_id);
$type = ProviderType::find($current_request->type);
$status = 0;
if ($current_request->is_completed) {
$status = 5;
} elseif ($current_request->is_started) {
$status = 4;
} elseif ($current_request->is_walker_arrived) {
$status = 3;
} elseif ($current_request->is_walker_started) {
$status = 2;
} elseif ($current_request->confirmed_walker) {
$status = 1;
} else {
if ($current_request->status == 1) {
$status = 6;
}
}
if ($current_request->confirmed_walker) {
$walker = Walker::find($current_request->confirmed_walker);
$rating = DB::table('review_walker')->where('walker_id', '=', $current_request->confirmed_walker)->avg('rating') ?: 0;
return View::make('web.userRequestTripStatus')->with('title', 'Trip Status')->with('page', 'trip-status')->with('request', $current_request)->with('user', $owner)->with('walker', $walker)->with('type', $type)->with('status', $status)->with('rating', $rating);
} else {
return View::make('web.userRequestTripStatus')->with('title', 'Trip Status')->with('page', 'trip-status')->with('request', $current_request)->with('user', $owner)->with('type', $type)->with('rating', 0)->with('status', $status);
}
}
}
public function run()
{
ProviderType::create(array('id' => 1, 'name' => 'Default', 'is_default' => 1));
}
public function updateProviderProfile()
{
foreach (Input::get('service') as $key) {
$serv = ProviderType::where('id', $key)->first();
$pserv[] = $serv->name;
}
$walker_id = Session::get('walker_id');
$first_name = Input::get('first_name');
$last_name = Input::get('last_name');
$phone = Input::get('phone');
$picture = Input::file('picture');
$bio = Input::get('bio');
$address = Input::get('address');
$state = Input::get('state');
$country = Input::get('country');
$zipcode = Input::get('zipcode');
$timezone = Input::get('timezone');
$car_number = trim(Input::get('car_number'));
$car_model = trim(Input::get('car_model'));
$validator = Validator::make(array('picture' => $picture), array('picture' => ''));
if ($validator->fails()) {
$error_messages = $validator->messages();
Log::info('picture type not valid. Error = ' . print_r($error_messages, true));
return Redirect::to('/provider/profile')->with('error', 'Invalid image format (Allowed formats jpeg,bmp and png)');
} else {
$walker = Walker::find($walker_id);
if (Input::hasFile('picture')) {
if ($walker->picture != "") {
$path = $walker->picture;
Log::info($path);
$filename = basename($path);
Log::info($filename);
unlink(public_path() . "/uploads/" . $filename);
}
// upload image
$file_name = time();
$file_name .= rand();
$file_name = sha1($file_name);
$ext = Input::file('picture')->getClientOriginalExtension();
Input::file('picture')->move(public_path() . "/uploads", $file_name . "." . $ext);
$local_url = $file_name . "." . $ext;
// Upload to S3
if (Config::get('app.s3_bucket') != "") {
$s3 = App::make('aws')->get('s3');
$pic = $s3->putObject(array('Bucket' => Config::get('app.s3_bucket'), 'Key' => $file_name, 'SourceFile' => public_path() . "/uploads/" . $local_url));
$s3->putObjectAcl(array('Bucket' => Config::get('app.s3_bucket'), 'Key' => $file_name, 'ACL' => 'public-read'));
$s3_url = $s3->getObjectUrl(Config::get('app.s3_bucket'), $file_name);
} else {
$s3_url = asset_url() . '/uploads/' . $local_url;
}
if (isset($walker->picture)) {
if ($walker->picture != "") {
$icon = $walker->picture;
unlink_image($icon);
}
}
$walker->picture = $s3_url;
}
if ($car_number != "") {
$walker->car_number = $car_number;
}
if ($car_model != "") {
$walker->car_model = $car_model;
}
$walker->first_name = $first_name;
$walker->last_name = $last_name;
$walker->phone = $phone;
$walker->bio = $bio;
$walker->address = $address;
$walker->state = $state;
$walker->country = $country;
$walker->zipcode = $zipcode;
$walker->timezone = $timezone;
$walker->save();
foreach (Input::get('service') as $ke) {
$proviserv = ProviderServices::where('provider_id', $walker->id)->first();
if ($proviserv != NULL) {
DB::delete("delete from walker_services where provider_id = '" . $walker->id . "';");
}
}
$base_price = Input::get('service_base_price');
$service_price_distance = Input::get('service_price_distance');
$service_price_time = Input::get('service_price_time');
Log::info('service = ' . print_r(Input::get('service'), true));
/* $cnkey = Input::get('noOfTypes'); */
$cnkey = count(Input::get('service'));
$type_id = trim(Input::get('service')[0]);
$walker->type = $type_id;
$walker->save();
Log::info('cnkey = ' . print_r($cnkey, true));
Log::info('service_base_price = ' . print_r($base_price, true));
Log::info('service_price_distance = ' . print_r($service_price_distance, true));
Log::info('service_price_time = ' . print_r($service_price_time, true));
$key = Input::get('service');
/* for ($i = 0; $i < $cnkey; $i++) { */
/* if (isset($key[$i])) {
$prserv = new ProviderServices;
$prserv->provider_id = $walker->id;
$prserv->type = $key[$i];
Log::info('key = ' . print_r($key, true));
if (Input::has('service_base_price')) {
$prserv->base_price = $base_price[$i];
} else {
$prserv->base_price = 0;
}
if (Input::has('service_price_distance')) {
$prserv->price_per_unit_distance = $service_price_distance[$i];
} else {
$prserv->price_per_unit_distance = 0;
}
if (Input::has('service_price_time')) {
$prserv->price_per_unit_time = $service_price_time[$i];
} else {
$prserv->price_per_unit_time = 0;
}
$prserv->save();
} */
/* print_r($key);
print_r($service_price_time); */
/* foreach (Input::get('service') as $key) { */
$prserv = new ProviderServices();
$prserv->provider_id = $walker->id;
$prserv->type = $type_id;
$walker->type = $type_id;
$walker->save();
/* Log::info('key = ' . print_r($key, true)); */
if (Input::has('service_base_price')) {
$prserv->base_price = $base_price[$type_id];
} else {
$prserv->base_price = 0;
}
if (Input::has('service_price_distance')) {
$prserv->price_per_unit_distance = $service_price_distance[$type_id];
} else {
$prserv->price_per_unit_distance = 0;
}
if (Input::has('service_price_time')) {
$prserv->price_per_unit_time = $service_price_time[$type_id];
} else {
$prserv->price_per_unit_time = 0;
}
$prserv->save();
/* }
} */
return Redirect::to('/provider/profile')->with('message', 'Your profile has been updated successfully')->with('type', 'success');
}
}
public function create_request()
{
$token = Input::get('token');
$owner_id = Input::get('id');
$latitude = Input::get('latitude');
$longitude = Input::get('longitude');
$type = Input::get('type');
$validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'latitude' => $latitude, 'longitude' => $longitude), array('token' => 'required', 'owner_id' => 'required|integer', 'latitude' => 'required', 'longitude' => '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 (!$type) {
// choose default type
$provider_type = ProviderType::where('is_default', 1)->first();
if (!$provider_type) {
$type = 0;
} else {
$type = $provider_type->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->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'] = 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 = $msg_array;
/* 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);
$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) {
$response_array = array('success' => false, 'error' => 'Owner 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;
}
</div>
</div>
<div class="form-group">
<label class="col-sm-2 col-sm-2 control-label">Bio</label>
<div class="col-sm-6">
<input type="text" class="form-control" name="bio" value="{{ $user->bio }}">
</div>
</div><span style="display:none;">{{$i = 0;}}</span>
<div class="form-group">
<label class="col-sm-2 col-sm-2 control-label">Services</label>
<div class="col-sm-10">
@foreach($type as $types)
<div class="col-sm-4">
<?php
foreach ($ps as $pss) {
$ser = ProviderType::where('id', $pss->type)->first();
$ar[] = $ser->name;
}
$servname = $types->name;
?>
<input id="service" name="service[]" type="radio" value="{{$types->id}}" <?php
if (!empty($ar)) {
if (in_array($servname, $ar)) {
echo "checked='checked'";
}
}
?>
>{{$types->name}}
<br>
</div>
<div class="col-sm-2">
public function add_request()
{
Log::info('add request from admin panel.');
$owner_id = Request::segment(3);
$owner = Owner::find($owner_id);
$services = ProviderType::where('is_visible', '=', 1)->get();
$total_services = ProviderType::where('is_visible', '=', 1)->count();
// Payment options allowed
$payment_options = array();
$payments = Payment::where('owner_id', $owner_id)->count();
if ($payments) {
$payment_options['stored_cards'] = 1;
} else {
$payment_options['stored_cards'] = 0;
}
$codsett = Settings::where('key', 'cod')->first();
if ($codsett->value == 1) {
$payment_options['cod'] = 1;
} else {
$payment_options['cod'] = 0;
}
$paypalsett = Settings::where('key', 'paypal')->first();
if ($paypalsett->value == 1) {
$payment_options['paypal'] = 1;
} else {
$payment_options['paypal'] = 0;
}
Log::info('payment_options = ' . print_r($payment_options, true));
// Promo code allowed
$promosett = Settings::where('key', 'promo_code')->first();
if ($promosett->value == 1) {
$promo_allow = 1;
} else {
$promo_allow = 0;
}
$settdestination = Settings::where('key', 'get_destination')->first();
$settdestination = $settdestination->value;
$title = ucwords("Add" . trans('customize.Request'));
/* 'Add Request' */
return View::make('add_request')->with('owner', $owner)->with('services', $services)->with('total_services', $total_services)->with('payment_option', $payment_options)->with('settdestination', $settdestination)->with('title', $title)->with('page', 'walks');
}
public function get_completed_requests()
{
$token = Input::get('token');
$owner_id = Input::get('id');
$from = Input::get('from_date');
// 2015-03-11 07:45:01
$to_date = Input::get('to_date') . ' 23:59:59';
//2015-03-11 07:45:01
$validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id), array('token' => 'required', 'owner_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 ($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 ($from != "" && $to_date != "") {
$request_data = DB::table('request')->where('request.owner_id', $owner_id)->where('is_completed', 1)->where('is_cancelled', 0)->whereBetween('request_start_time', array($from, $to_date))->leftJoin('walker', 'request.confirmed_walker', '=', 'walker.id')->leftJoin('walker_services', 'walker.id', '=', 'walker_services.provider_id')->leftJoin('walker_type', 'walker_type.id', '=', 'walker_services.type')->leftJoin('request_services', 'request_services.request_id', '=', 'request.id')->select('request.*', 'request.request_start_time', 'request.promo_code', 'walker.first_name', 'walker.id as walker_id', 'walker.last_name', 'walker.phone', 'walker.email', 'walker.picture', 'walker.bio', 'walker.rate', 'walker_type.name as type', 'walker_type.icon', 'request.distance', 'request.time', 'request_services.base_price as req_base_price', 'request_services.distance_cost as req_dis_cost', 'request_services.time_cost as req_time_cost', 'request_services.type as req_typ', 'request.total')->get();
} else {
$request_data = DB::table('request')->where('request.owner_id', $owner_id)->where('is_completed', 1)->where('is_cancelled', 0)->leftJoin('walker', 'request.confirmed_walker', '=', 'walker.id')->leftJoin('walker_services', 'walker.id', '=', 'walker_services.provider_id')->leftJoin('walker_type', 'walker_type.id', '=', 'walker_services.type')->leftJoin('request_services', 'request_services.request_id', '=', 'request.id')->select('request.*', 'request.request_start_time', 'request.promo_code', 'walker.first_name', 'walker.id as walker_id', 'walker.last_name', 'walker.phone', 'walker.email', 'walker.picture', 'walker.bio', 'walker.rate', 'walker_type.name as type', 'walker_type.icon', 'request.distance', 'request.time', 'request_services.base_price as req_base_price', 'request_services.distance_cost as req_dis_cost', 'request_services.time_cost as req_time_cost', 'request_services.type as req_typ', 'request.total')->get();
}
$requests = array();
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
if ($unit == 0) {
$unit_set = 'kms';
} elseif ($unit == 1) {
$unit_set = 'miles';
}
/* $currency_selected = Keywords::find(5); */
foreach ($request_data as $data) {
$request_typ = ProviderType::where('id', '=', $data->req_typ)->first();
/* $setbase_price = Settings::where('key', 'base_price')->first();
$setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
$settime_price = Settings::where('key', 'price_per_unit_time')->first(); */
$setbase_distance = $request_typ->base_distance;
$setbase_price = $request_typ->base_price;
$setdistance_price = $request_typ->price_per_unit_distance;
$settime_price = $request_typ->price_per_unit_time;
$locations = WalkLocation::where('request_id', $data->id)->orderBy('id')->get();
$start = $end = $map = "";
$id = $data->id;
if (count($locations) >= 1) {
$start = WalkLocation::where('request_id', $id)->orderBy('id')->first();
$end = WalkLocation::where('request_id', $id)->orderBy('id', 'desc')->first();
$map = "https://maps-api-ssl.google.com/maps/api/staticmap?size=249x249&scale=2&markers=shadow:true|scale:2|icon:http://d1a3f4spazzrp4.cloudfront.net/receipt-new/marker-start@2x.png|{$start->latitude},{$start->longitude}&markers=shadow:false|scale:2|icon:http://d1a3f4spazzrp4.cloudfront.net/receipt-new/marker-finish@2x.png|{$end->latitude},{$end->longitude}&path=color:0x2dbae4ff|weight:4";
foreach ($locations as $location) {
$map .= "|{$location->latitude},{$location->longitude}";
}
/* $map.="&key=" . Config::get('app.gcm_browser_key'); */
}
$request['start_lat'] = "";
if (isset($start->latitude)) {
$request['start_lat'] = $start->latitude;
}
$request['start_long'] = "";
if (isset($start->longitude)) {
$request['start_long'] = $start->longitude;
}
$request['end_lat'] = "";
if (isset($end->latitude)) {
$request['end_lat'] = $end->latitude;
}
$request['end_long'] = "";
if (isset($end->longitude)) {
$request['end_long'] = $end->longitude;
}
$request['map_url'] = $map;
$walker = Walker::where('id', $data->walker_id)->first();
if ($walker != NULL) {
$user_timezone = $walker->timezone;
} else {
$user_timezone = 'UTC';
}
$default_timezone = Config::get('app.timezone');
$date_time = get_user_time($default_timezone, $user_timezone, $data->request_start_time);
$dist = number_format($data->distance, 2, '.', '');
$request['id'] = $data->id;
$request['date'] = $date_time;
$request['distance'] = (string) $dist;
$request['unit'] = $unit_set;
$request['time'] = $data->time;
$discount = 0;
if ($data->promo_code != "") {
if ($data->promo_code != "") {
$promo_code = PromoCodes::where('id', $data->promo_code)->first();
if ($promo_code) {
$promo_value = $promo_code->value;
$promo_type = $promo_code->type;
if ($promo_type == 1) {
// Percent Discount
$discount = $data->total * $promo_value / 100;
} elseif ($promo_type == 2) {
// Absolute Discount
$discount = $promo_value;
}
}
}
}
$request['promo_discount'] = currency_converted($discount);
$is_multiple_service = Settings::where('key', 'allow_multiple_service')->first();
if ($is_multiple_service->value == 0) {
if ($data->req_base_price) {
$request['base_price'] = currency_converted($data->req_base_price);
} else {
/* $request['base_price'] = currency_converted($setbase_price->value); */
$request['base_price'] = currency_converted($setbase_price);
}
if ($data->req_dis_cost) {
$request['distance_cost'] = currency_converted($data->req_dis_cost);
} else {
/* $request['distance_cost'] = currency_converted($setdistance_price->value * $data->distance); */
if ($data->distance <= $setbase_distance) {
$request['distance_cost'] = 0;
} else {
$request['distance_cost'] = currency_converted($setdistance_price->value * ($data->distance - $setbase_distance));
}
}
if ($data->req_time_cost) {
$request['time_cost'] = currency_converted($data->req_time_cost);
} else {
/* $request['time_cost'] = currency_converted($settime_price->value * $data->time); */
$request['time_cost'] = currency_converted($settime_price * $data->time);
}
$request['setbase_distance'] = $setbase_distance;
$request['total'] = currency_converted($data->total);
$request['actual_total'] = currency_converted($data->total + $data->ledger_payment + $discount);
$request['type'] = $data->type;
$request['type_icon'] = $data->icon;
$rserv = RequestServices::where('request_id', $data->id)->get();
$typs = array();
$typi = array();
$typp = array();
$total_price = 0;
foreach ($rserv as $typ) {
$typ1 = ProviderType::where('id', $typ->type)->first();
$typ_price = ProviderServices::where('provider_id', $data->confirmed_walker)->where('type', $typ->type)->first();
if ($typ_price->base_price > 0) {
$typp1 = 0.0;
$typp1 = $typ_price->base_price;
} elseif ($typ_price->price_per_unit_distance > 0) {
$typp1 = 0.0;
foreach ($rserv as $key) {
$typp1 = $typp1 + $key->distance_cost;
}
} else {
$typp1 = 0.0;
}
$typs['name'] = $typ1->name;
$typs['price'] = currency_converted($typp1);
$total_price = $total_price + $typp1;
array_push($typi, $typs);
}
$request['type'] = $typi;
} else {
$rserv = RequestServices::where('request_id', $data->id)->get();
$typs = array();
$typi = array();
$typp = array();
$total_price = 0;
foreach ($rserv as $typ) {
$typ1 = ProviderType::where('id', $typ->type)->first();
$typ_price = ProviderServices::where('provider_id', $data->confirmed_walker)->where('type', $typ->type)->first();
if ($typ_price->base_price > 0) {
$typp1 = 0.0;
$typp1 = $typ_price->base_price;
} elseif ($typ_price->price_per_unit_distance > 0) {
$typp1 = 0.0;
foreach ($rserv as $key) {
$typp1 = $typp1 + $key->distance_cost;
}
} else {
$typp1 = 0.0;
}
$typs['name'] = $typ1->name;
$typs['price'] = currency_converted($typp1);
$total_price = $total_price + $typp1;
array_push($typi, $typs);
}
$request['type'] = $typi;
$base_price = 0;
$distance_cost = 0;
$time_cost = 0;
foreach ($rserv as $key) {
$base_price = $base_price + $key->base_price;
$distance_cost = $distance_cost + $key->distance_cost;
$time_cost = $time_cost + $key->time_cost;
}
$request['base_price'] = currency_converted($base_price);
$request['distance_cost'] = currency_converted($distance_cost);
$request['time_cost'] = currency_converted($time_cost);
$request['total'] = currency_converted($total_price);
}
$rate = WalkerReview::where('request_id', $data->id)->where('walker_id', $data->confirmed_walker)->first();
if ($rate != NULL) {
$request['walker']['rating'] = $rate->rating;
} else {
$request['walker']['rating'] = '0.0';
}
/* $request['currency'] = $currency_selected->keyword; */
$request['base_price'] = currency_converted($data->req_base_price);
$request['distance_cost'] = currency_converted($data->req_dis_cost);
$request['time_cost'] = currency_converted($data->req_time_cost);
$request['total'] = currency_converted($data->total - $data->ledger_payment - $data->promo_payment);
$request['main_total'] = currency_converted($data->total);
$request['referral_bonus'] = currency_converted($data->ledger_payment);
$request['promo_bonus'] = currency_converted($data->promo_payment);
$request['payment_type'] = $data->payment_mode;
$request['is_paid'] = $data->is_paid;
$request['promo_id'] = $data->promo_id;
$request['promo_code'] = $data->promo_code;
$request['currency'] = Config::get('app.generic_keywords.Currency');
$request['walker']['first_name'] = $data->first_name;
$request['walker']['last_name'] = $data->last_name;
$request['walker']['phone'] = $data->phone;
$request['walker']['email'] = $data->email;
$request['walker']['picture'] = $data->picture;
$request['walker']['bio'] = $data->bio;
$request['walker']['type'] = $data->type;
/* $request['walker']['rating'] = $data->rate; */
array_push($requests, $request);
}
$response_array = array('success' => true, 'requests' => $requests);
$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 services_details()
{
$walker_id = Input::get('id');
$token = Input::get('token');
$validator = Validator::make(array('walker_id' => $walker_id, 'token' => $token), array('walker_id' => 'required|integer', 'token' => '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 ($walker_data = $this->getWalkerData($walker_id, $token, $is_admin)) {
// check for token validity
if (is_token_active($walker_data->token_expiry) || $is_admin) {
$provserv = ProviderServices::where('provider_id', $walker_id)->get();
foreach ($provserv as $key) {
$type = ProviderType::where('id', $key->type)->first();
$serv_name[] = $type->name;
$serv_base_price[] = $key->base_price;
$serv_per_distance[] = $key->price_per_unit_distance;
$serv_per_time[] = $key->price_per_unit_time;
}
$response_array = array('success' => true, 'serv_name' => $serv_name, 'serv_base_price' => $serv_base_price, 'serv_per_distance' => $serv_per_distance, 'serv_per_time' => $serv_per_time);
$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 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);
}
}
public function updateProviderProfile()
{
foreach (Input::get('service') as $key) {
$serv = ProviderType::where('id', $key)->first();
$pserv[] = $serv->name;
}
$walker_id = Session::get('walker_id');
$first_name = Input::get('first_name');
$last_name = Input::get('last_name');
$email = Input::get('email');
$phone = Input::get('phone');
$picture = Input::file('picture');
$bio = Input::get('bio');
$address = Input::get('address');
$state = Input::get('state');
$country = Input::get('country');
$zipcode = Input::get('zipcode');
$walker = Walker::find($walker_id);
if (Input::hasFile('picture')) {
// upload image
$file_name = time();
$file_name .= rand();
$file_name = sha1($file_name);
$ext = Input::file('picture')->getClientOriginalExtension();
Input::file('picture')->move(public_path() . "/uploads", $file_name . "." . $ext);
$local_url = $file_name . "." . $ext;
// Upload to S3
if (Config::get('app.s3_bucket') != "") {
$s3 = App::make('aws')->get('s3');
$pic = $s3->putObject(array('Bucket' => Config::get('app.s3_bucket'), 'Key' => $file_name, 'SourceFile' => public_path() . "/uploads/" . $local_url));
$s3->putObjectAcl(array('Bucket' => Config::get('app.s3_bucket'), 'Key' => $file_name, 'ACL' => 'public-read'));
$s3_url = $s3->getObjectUrl(Config::get('app.s3_bucket'), $file_name);
} else {
$s3_url = asset_url() . '/uploads/' . $local_url;
}
$walker->picture = $s3_url;
}
$walker->first_name = $first_name;
$walker->last_name = $last_name;
$walker->email = $email;
$walker->phone = $phone;
$walker->bio = $bio;
$walker->address = $address;
$walker->state = $state;
$walker->country = $country;
$walker->zipcode = $zipcode;
$walker->save();
foreach (Input::get('service') as $ke) {
$proviserv = ProviderServices::where('provider_id', $walker->id)->first();
if ($proviserv != NULL) {
DB::delete("delete from walker_services where provider_id = '" . $walker->id . "';");
}
}
$base_price = Input::get('service_base_price');
$service_price_distance = Input::get('service_price_distance');
$service_price_time = Input::get('service_price_time');
foreach (Input::get('service') as $key) {
$prserv = new ProviderServices();
$prserv->provider_id = $walker->id;
$prserv->type = $key;
$prserv->base_price = $base_price[$key - 1];
$prserv->price_per_unit_distance = $service_price_distance[$key - 1];
$prserv->price_per_unit_time = $service_price_time[$key - 1];
$prserv->save();
}
return Redirect::to('/provider/profile')->with('message', 'Your profile has been updated successfully')->with('type', 'success');
}
public function sortpvtype()
{
$valu = $_GET['valu'];
$type = $_GET['type'];
Session::put('valu', $valu);
Session::put('type', $type);
if ($type == 'provid') {
$typename = "Providers Type ID";
$providers = ProviderType::orderBy('id', $valu)->paginate(10);
} elseif ($type == 'pvname') {
$typename = "Providers Name";
$providers = ProviderType::orderBy('name', $valu)->paginate(10);
}
return View::make('list_provider_types')->with('title', 'Provider Types | Sorted by ' . $typename . ' in ' . $valu)->with('page', 'list_provider_types')->with('types', $providers);
}
