" placeholder="Price per unit distance" >
                        <br>
                    </div>
                    <div class="col-sm-2">
                        <?php 
$counter++;
?>
                        <span id="no_amount_error<?php 
echo $counter;
?>
" style="display: none"></span>
                        <input id="time_price" name="service_price_time[{{$types->id}}]" type="text" onkeypress="return Isamount(event,<?php 
echo $counter;
?>
);" value="<?php 
$proviserv = ProviderServices::where('provider_id', $user->id)->where('type', $types->id)->first();
if (empty($proviserv)) {
    echo "";
} else {
    echo sprintf2($proviserv->price_per_unit_time, 2);
}
?>
" placeholder="Price per unit time" ><br>
                        <br><span style="display:none;">{{$i = $i+1;}}</span><div><input name="noOfTypes" type="hidden" value="{{$i}}"></div> 
                    </div>
                    <?php 
$counter++;
?>
                    @endforeach
                </div>
            </div>
 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 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 update_walker()
 {
     if (Input::get('id') != 0) {
         $walker = Walker::find(Input::get('id'));
     } else {
         $findWalker = Walker::where('email', Input::get('email'))->first();
         if ($findWalker) {
             Session::put('new_walker', 0);
             $error_messages = "This Email Id is already registered.";
             Session::put('msg', $error_messages);
             $title = ucwords("Add" . trans('customize.Provider'));
             /* 'Add Provider' */
             return View::make('add_walker')->with('title', $title)->with('page', 'walkers');
         } else {
             Session::put('new_walker', 1);
             $walker = new Walker();
         }
     }
     if (Input::has('service') != NULL) {
         foreach (Input::get('service') as $key) {
             $serv = ProviderType::where('id', $key)->first();
             $pserv[] = $serv->name;
         }
     }
     $first_name = Input::get('first_name');
     $last_name = Input::get('last_name');
     $email = Input::get('email');
     $phone = Input::get('phone');
     $bio = Input::get('bio');
     $address = Input::get('address');
     $state = Input::get('state');
     $country = Input::get('country');
     $zipcode = Input::get('zipcode');
     $validator = Validator::make(array('first_name' => $first_name, 'last_name' => $last_name, 'email' => $email, 'phone' => $phone, 'bio' => $bio, 'state' => $state, 'country' => $country, 'zipcode' => $zipcode), array('first_name' => 'required', 'last_name' => 'required', 'email' => 'required|email', 'phone' => 'required', 'bio' => 'required', 'state' => 'required', 'country' => 'required', 'zipcode' => 'required|integer'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->first();
         Session::put('msg', $error_messages);
         $title = ucwords("Add" . trans('customize.Provider'));
         /* 'Add Provider' */
         return View::make('add_walker')->with('title', $title)->with('page', 'walkers');
     } else {
         $walker->first_name = Input::get('first_name');
         $walker->last_name = Input::get('last_name');
         $walker->email = Input::get('email');
         $walker->phone = Input::get('phone');
         $walker->bio = Input::get('bio');
         $walker->address = Input::get('address');
         $walker->state = Input::get('state');
         // adding password to new provider
         $new_password = time();
         $new_password .= rand();
         $new_password = sha1($new_password);
         $new_password = substr($new_password, 0, 8);
         /* $walker->password = Hash::make($new_password); */
         $walker->country = Input::get('country');
         $walker->zipcode = Input::get('zipcode');
         $walker->is_approved = 1;
         $walker->email_activation = 1;
         $car_number = trim(Input::get('car_number'));
         if ($car_number != "") {
             $walker->car_number = $car_number;
         }
         $car_model = trim(Input::get('car_model'));
         if ($car_model != "") {
             $walker->car_model = $car_model;
         }
         if (Input::hasFile('pic')) {
             /* if ($walker->picture != "") {
                               $path = $walker->picture;
                               Log::info($path);
                               $filename = basename($path);
                               Log::info($filename);
                               try {
                               unlink(public_path() . "/uploads/" . $filename);
                               } catch (Exception $e) {
             
                               }
                               } */
             // Upload File
             $file_name = time();
             $file_name .= rand();
             $ext = Input::file('pic')->getClientOriginalExtension();
             Input::file('pic')->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;
         }
         $walker->save();
         if (Session::get('new_walker') == 1) {
             // send email
             $settings = Settings::where('key', 'email_forgot_password')->first();
             $pattern = $settings->value;
             $pattern = "Hi, " . Config::get('app.website_title') . " is Created a New Account for you , Your Username is:" . Input::get('email') . " and Your Password is " . $new_password . ". Please dont forget to change the password once you log in next time.";
             $subject = "Welcome On Board";
             /* email_notification($walker->id, 'walker', $pattern, $subject); */
         }
         if (Input::has('service') != NULL) {
             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 = count(Input::get('service'));
             $type_id = trim(Input::get('service')[0]);
             Log::info('cnkey = ' . print_r($cnkey, true));
             /* for ($i = 1; $i <= $cnkey; $i++) { */
             /* 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_distance')) {
                 $prserv->price_per_unit_time = $service_price_time[$type_id];
             } else {
                 $prserv->price_per_unit_distance = 0;
             }
             $prserv->save();
             /* } */
             /* } */
         }
         return Redirect::to("/admin/providers");
     }
 }
 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 get_provider_list()
 {
     $latitude = Input::get('usr_lat');
     $longitude = Input::get('user_long');
     $validator = Validator::make(array('usr_lat' => $latitude, 'user_long' => $longitude), array('usr_lat' => 'required', 'user_long' => '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 {
         $setbase_price = Settings::where('key', 'base_price')->first();
         $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 *, " . "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} " . "order by distance " . "LIMIT 5";
         $walkers_list = DB::select(DB::raw($query));
         $walker_data = array();
         if ($walkers_list) {
             foreach ($walkers_list as $walkers) {
                 $walker_list = array();
                 $walker_list['id'] = $walkers->id;
                 $walker_list['first_name'] = $walkers->first_name;
                 $walker_list['last_name'] = $walkers->last_name;
                 $walker_list['phone'] = $walkers->phone;
                 $walker_list['email'] = $walkers->email;
                 $walker_list['bio'] = $walkers->bio;
                 $walker_list['address'] = $walkers->address;
                 $walker_list['state'] = $walkers->state;
                 $walker_list['country'] = $walkers->country;
                 $walker_list['zipcode'] = $walkers->zipcode;
                 $walker_list['latitude'] = $walkers->latitude;
                 $walker_list['longitude'] = $walkers->longitude;
                 $walker_list['type'] = $walkers->type;
                 $walker_list['car_model'] = $walkers->car_model;
                 $walker_list['car_number'] = $walkers->car_number;
                 $walker_list['bearing'] = $walkers->bearing;
                 $walker_list['rate'] = $walkers->rate;
                 $walker_list['num_rating'] = $walkers->rate_count;
                 $walker_list['picture'] = $walkers->picture;
                 $typ_price = ProviderServices::where('provider_id', $walkers->id)->get();
                 $base = '';
                 foreach ($typ_price as $key) {
                     $base = $base + $key->base_price;
                 }
                 $walker_list['base_price'] = $base;
                 array_push($walker_data, $walker_list);
             }
             if (!empty($walker_data)) {
                 $response_array = array('success' => true, 'walker_list' => $walker_data);
             } else {
                 $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found around you.', 'error_code' => 411, 'walker_list' => $walker_data);
             }
             $response_code = 200;
         } else {
             $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found around you.', 'error_code' => 411, 'walker_list' => $walker_data);
             $response_code = 201;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }
 public function request_fare()
 {
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $d_latitude = Input::get('d_latitude');
     $d_longitude = Input::get('d_longitude');
     $type = Input::get('type');
     $provider = Input::get('provider');
     $promo_code = trim(Input::get('promo_code'));
     $time = 0;
     $distance = 0;
     $request_typ = ProviderType::where('id', '=', $type)->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;
     /* $json_resp = file_get_contents('http://maps.googleapis.com/maps/api/distancematrix/json?origins=' . $latitude . ',' . $longitude . '&destinations=' . $d_latitude . ',' . $d_longitude); */
     /* $data = json_decode($json_resp);
               Log::info('data = ' . print_r($data, true));
     
     
               $distance = $data->rows[0]->elements[0]->distance->value;
     
               $time = $data->rows[0]->elements[0]->duration->value; */
     $settings = Settings::where('key', 'default_distance_unit')->first();
     $unit = $settings->value;
     $distance = get_dist($latitude, $longitude, $d_latitude, $d_longitude);
     Log::info('data = ' . print_r($distance, true));
     if ($unit == 0) {
         $distanceNew = $distance * 0.001;
         /* $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
            $price_per_unit_distance = $setdistance_price->value * $distanceNew; */
         if ($distanceNew <= $setbase_distance) {
             $price_per_unit_distance = 0;
         } else {
             $price_per_unit_distance = $setdistance_price->value * ($distanceNew - $setbase_distance);
         }
     } else {
         $distanceNew = $distance * 0.000621371;
         /* $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
            $price_per_unit_distance = $setdistance_price->value * $distanceNew; */
         if ($distanceNew <= $setbase_distance) {
             $price_per_unit_distance = 0;
         } else {
             $price_per_unit_distance = $setdistance_price->value * ($distanceNew - $setbase_distance);
         }
     }
     $timeMinutes = $time * 0.0166667;
     /* $settime_price = Settings::where('key', 'price_per_unit_time')->first();
        $price_per_unit_time = $settime_price->value * $timeMinutes; */
     $price_per_unit_time = $settime_price * $timeMinutes;
     $total = 0;
     $base_price = 0;
     if (Input::has('provider')) {
         $pt = ProviderServices::where('provider_id', $provider)->where('type', $type)->first();
         $base_price = $pt->base_price;
         if ($distanceNew <= $setbase_distance) {
             $price_per_unit_distance = 0;
         } else {
             $price_per_unit_distance = $pt->price_per_unit_distance * ($distanceNew - $setbase_distance);
         }
         $total = $base_price + $price_per_unit_distance + $price_per_unit_time;
     } else {
         /* $setbase_price = Settings::where('key', 'base_price')->first();
            $base_price = $setbase_price->value; */
         $base_price = $setbase_price;
         /* $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
            $price_per_unit_distance = $setdistance_price->value * $distanceNew; */
         if ($distanceNew <= $setbase_distance) {
             $price_per_unit_distance = 0;
         } else {
             $price_per_unit_distance = $setdistance_price->value * ($distanceNew - $setbase_distance);
         }
         $total = $base_price + $price_per_unit_distance + $price_per_unit_time;
     }
     if ($promo_code) {
         $promosett = Settings::where('key', 'promotional_code_activation')->first();
         $promo_discount = 0;
         $total_amount = $total;
         if ($promosett->value == 1) {
             /* if ($request->promo_code != "") { */
             $promo_code = PromoCodes::where('coupon_code', $promo_code)->first();
             if (isset($promo_code->id)) {
                 $promo_value = $promo_code->value;
                 $promo_type = $promo_code->type;
                 if ($promo_type == 1) {
                     $discount = $total_amount * ($promo_value / 100);
                 } elseif ($promo_type == 2) {
                     $discount = $promo_value;
                 }
                 $promo_discount = $discount;
                 /* } */
                 $total = $total_amount - $promo_discount;
             }
         }
     }
     /* $currency_selected = Keywords::find(5);
        if ($currency_selected->keyword == '$') { */
     if (Config::get('app.generic_keywords.Currency') == '$') {
         $currency_sel = "USD";
     } else {
         /* $currency_sel = $currency_selected->keyword; */
         $currency_sel = Config::get('app.generic_keywords.Currency');
     }
     if ($currency_sel != 'USD') {
         $httpAdapter = new \Ivory\HttpAdapter\FileGetContentsHttpAdapter();
         // Create the Yahoo Finance provider
         $yahooProvider = new \Swap\Provider\YahooFinanceProvider($httpAdapter);
         // Create Swap with the provider
         $swap = new \Swap\Swap($yahooProvider);
         $rate = $swap->quote("USD/" . $currency_sel);
         $rate = json_decode($rate, true);
         Log::info($rate);
         $total = $total * $rate;
     }
     $status = 1;
     /* return Response::json(array('success' => true, 'total' => $currency_selected->keyword . " " . $total)); */
     return Response::json(array('success' => true, 'total' => Config::get('app.generic_keywords.Currency') . " " . sprintf2($total, 2)));
 }
 public function get_request()
 {
     $request_id = Input::get('request_id');
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'owner_id' => $owner_id), array('request_id' => 'required|integer', 'token' => 'required', 'owner_id' => 'required|integer'));
     /* $var = Keywords::where('id', 2)->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);
         $walker_data = "";
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 /* 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 */
                 // Do necessary operations
                 if ($request = Requests::find($request_id)) {
                     if ($request->owner_id == $owner_data->id) {
                         if ($request->current_walker != 0) {
                             if ($request->confirmed_walker != 0) {
                                 $walker = Walker::where('id', $request->confirmed_walker)->first();
                                 $walker_data = array();
                                 $walker_data['unique_id'] = 1;
                                 $walker_data['id'] = $walker->id;
                                 $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;
                                 if ($request->D_latitude != NULL) {
                                     $walker_data['d_latitude'] = $request->D_latitude;
                                     $walker_data['d_longitude'] = $request->D_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['bearing'] = $walker->bearing;
                                 /* $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';
                                 }
                                 $requestserv = RequestServices::where('request_id', $request->id)->first();
                                 $bill = array();
                                 $request_typ = ProviderType::where('id', '=', $requestserv->type)->first();
                                 /* $currency_selected = Keywords::find(5);
                                    $cur_symb = $currency_selected->keyword; */
                                 $cur_symb = Config::get('app.generic_keywords.Currency');
                                 if ($request->is_completed == 1) {
                                     $bill['unit'] = $unit_set;
                                     $bill['payment_mode'] = $request->payment_mode;
                                     $bill['distance'] = (string) $request->distance;
                                     $bill['time'] = $request->time;
                                     if ($requestserv->base_price != 0) {
                                         $bill['base_distance'] = $request_typ->base_distance;
                                         $bill['base_price'] = currency_converted($requestserv->base_price);
                                         $bill['distance_cost'] = currency_converted($requestserv->distance_cost);
                                         $bill['time_cost'] = currency_converted($requestserv->time_cost);
                                     } else {
                                         /* $setbase_price = Settings::where('key', 'base_price')->first();
                                            $bill['base_price'] = currency_converted($setbase_price->value);
                                            $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
                                            $bill['distance_cost'] = currency_converted($setdistance_price->value);
                                            $settime_price = Settings::where('key', 'price_per_unit_time')->first();
                                            $bill['time_cost'] = currency_converted($settime_price->value); */
                                         $bill['base_distance'] = $request_typ->base_distance;
                                         $bill['base_price'] = currency_converted($request_typ->base_price);
                                         $bill['distance_cost'] = currency_converted($request_typ->price_per_unit_distance);
                                         $bill['time_cost'] = currency_converted($request_typ->price_per_unit_time);
                                     }
                                     if ($request->payment_mode == 2) {
                                         $bill['walker']['email'] = $walker->email;
                                         $bill['walker']['amount'] = currency_converted($request->transfer_amount);
                                         $admins = Admin::first();
                                         $bill['admin']['email'] = $admins->username;
                                         $bill['admin']['amount'] = currency_converted($request->total - $request->transfer_amount);
                                     }
                                     $bill['currency'] = $cur_symb;
                                     /* $bill['total'] = currency_converted($request->total); */
                                     $bill['main_total'] = currency_converted($request->total);
                                     $bill['total'] = currency_converted($request->total - $request->ledger_payment - $request->promo_payment);
                                     $bill['referral_bonus'] = currency_converted($request->ledger_payment);
                                     $bill['promo_bonus'] = currency_converted($request->promo_payment);
                                     $bill['payment_type'] = $request->payment_mode;
                                     $bill['is_paid'] = $request->is_paid;
                                     $discount = 0;
                                     if ($request->promo_code != "") {
                                         if ($request->promo_code != "") {
                                             $promo_code = PromoCodes::where('id', $request->promo_code)->first();
                                             if ($promo_code) {
                                                 $promo_value = $promo_code->value;
                                                 $promo_type = $promo_code->type;
                                                 if ($promo_type == 1) {
                                                     // Percent Discount
                                                     $discount = $request->total * $promo_value / 100;
                                                 } elseif ($promo_type == 2) {
                                                     // Absolute Discount
                                                     $discount = $promo_value;
                                                 }
                                             }
                                         }
                                     }
                                     $bill['promo_discount'] = currency_converted($discount);
                                     $bill['actual_total'] = currency_converted($request->total + $request->ledger_payment + $discount);
                                 }
                                 $cards = "";
                                 /* $cards['none'] = ""; */
                                 $dif_card = 0;
                                 $cardlist = Payment::where('owner_id', $owner_id)->where('is_default', 1)->first();
                                 /* $cardlist = Payment::where('id', $owner_data->default_card_id)->first(); */
                                 if (count($cardlist) >= 1) {
                                     $cards = array();
                                     $default = $cardlist->is_default;
                                     if ($default == 1) {
                                         $dif_card = $cardlist->id;
                                         $cards['is_default_text'] = "default";
                                     } else {
                                         $cards['is_default_text'] = "not_default";
                                     }
                                     $cards['card_id'] = $cardlist->id;
                                     $cards['owner_id'] = $cardlist->owner_id;
                                     $cards['customer_id'] = $cardlist->customer_id;
                                     $cards['last_four'] = $cardlist->last_four;
                                     $cards['card_token'] = $cardlist->card_token;
                                     $cards['card_type'] = $cardlist->card_type;
                                     $cards['is_default'] = $default;
                                 }
                                 $code_data = Ledger::where('owner_id', '=', $owner_data->id)->first();
                                 $owner = array();
                                 $owner['owner_lat'] = $owner_data->latitude;
                                 $owner['owner_long'] = $owner_data->longitude;
                                 $owner['owner_dist_lat'] = $request->D_latitude;
                                 $owner['owner_dist_long'] = $request->D_longitude;
                                 $owner['payment_type'] = $request->payment_mode;
                                 $owner['default_card'] = $dif_card;
                                 $owner['dest_latitude'] = $request->D_latitude;
                                 $owner['dest_longitude'] = $request->D_longitude;
                                 $owner['referral_code'] = $code_data->referral_code;
                                 $owner['is_referee'] = $owner_data->is_referee;
                                 $owner['promo_count'] = $owner_data->promo_count;
                                 $charge = array();
                                 $settings = Settings::where('key', 'default_distance_unit')->first();
                                 $unit = $settings->value;
                                 if ($unit == 0) {
                                     $unit_set = 'kms';
                                 } elseif ($unit == 1) {
                                     $unit_set = 'miles';
                                 }
                                 $charge['unit'] = $unit_set;
                                 if ($requestserv->base_price != 0) {
                                     $charge['base_distance'] = $request_typ->base_distance;
                                     $charge['base_price'] = currency_converted($requestserv->base_price);
                                     $charge['distance_price'] = currency_converted($requestserv->distance_cost);
                                     $charge['price_per_unit_time'] = currency_converted($requestserv->time_cost);
                                 } else {
                                     /* $setbase_price = Settings::where('key', 'base_price')->first();
                                        $charge['base_price'] = currency_converted($setbase_price->value);
                                        $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
                                        $charge['distance_price'] = currency_converted($setdistance_price->value);
                                        $settime_price = Settings::where('key', 'price_per_unit_time')->first();
                                        $charge['price_per_unit_time'] = currency_converted($settime_price->value); */
                                     $charge['base_distance'] = $request_typ->base_distance;
                                     $charge['base_price'] = currency_converted($request_typ->base_price);
                                     $charge['distance_price'] = currency_converted($request_typ->price_per_unit_distance);
                                     $charge['price_per_unit_time'] = currency_converted($request_typ->price_per_unit_time);
                                 }
                                 $charge['total'] = currency_converted($request->total);
                                 $charge['is_paid'] = $request->is_paid;
                                 $loc1 = WalkLocation::where('request_id', $request->id)->first();
                                 $loc2 = WalkLocation::where('request_id', $request->id)->orderBy('id', 'desc')->first();
                                 if ($loc1) {
                                     $time1 = strtotime($loc2->created_at);
                                     $time2 = strtotime($loc1->created_at);
                                     $difference = intval(($time1 - $time2) / 60);
                                 } else {
                                     $difference = 0;
                                 }
                                 $difference = $request->time;
                                 $rserv = RequestServices::where('request_id', $request_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', $request->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);
                                 }
                                 $bill['type'] = $typi;
                                 $response_array = array('success' => true, 'unique_id' => 1, 'status' => $request->status, '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, '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, 'is_cancelled' => $request->is_cancelled, 'dest_latitude' => $request->D_latitude, 'dest_longitude' => $request->D_longitude, 'promo_id' => $request->promo_id, 'promo_code' => $request->promo_code, 'walker' => $walker_data, 'time' => $difference, 'bill' => $bill, 'owner' => $owner, 'card_details' => $cards, 'charge_details' => $charge);
                                 $user_timezone = $walker->timezone;
                                 $default_timezone = Config::get('app.timezone');
                                 $accepted_time = get_user_time($default_timezone, $user_timezone, $request->request_start_time);
                                 $time = DB::table('walk_location')->where('request_id', $request_id)->min('created_at');
                                 $end_time = get_user_time($default_timezone, $user_timezone, $time);
                                 $response_array['accepted_time'] = $accepted_time;
                                 if ($request->is_started == 1) {
                                     $response_array['start_time'] = DB::table('walk_location')->where('request_id', $request_id)->min('created_at');
                                     $settings = Settings::where('key', 'default_distance_unit')->first();
                                     $unit = $settings->value;
                                     $response_array['distance'] = DB::table('walk_location')->where('request_id', $request_id)->max('distance');
                                     $response_array['distance'] = (string) convert($response_array['distance'], $unit);
                                     if ($unit == 0) {
                                         $unit_set = 'kms';
                                     } elseif ($unit == 1) {
                                         $unit_set = 'miles';
                                     }
                                     $response_array['unit'] = $unit_set;
                                 }
                                 if ($request->is_completed == 1) {
                                     $response_array['end_time'] = $end_time;
                                 }
                             } else {
                                 if ($request->current_walker != 0) {
                                     $walker = Walker::find($request->current_walker);
                                     $walker_data = array();
                                     $walker_data['unique_id'] = 1;
                                     $walker_data['id'] = $walker->id;
                                     $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['car_model'] = $walker->car_model;
                                     $walker_data['car_number'] = $walker->car_number;
                                     $walker_data['bearing'] = $walker->bearing;
                                     // $walker_data['payment_type'] = $request->payment_mode;
                                     $walker_data['rating'] = $walker->rate;
                                     $walker_data['num_rating'] = $walker->rate_count;
                                 }
                                 $cards = "";
                                 /* $cards['none'] = ""; */
                                 $dif_card = 0;
                                 $cardlist = Payment::where('owner_id', $owner_id)->where('is_default', 1)->first();
                                 /* $cardlist = Payment::where('id', $owner_data->default_card_id)->first(); */
                                 if (count($cardlist) >= 1) {
                                     $cards = array();
                                     $default = $cardlist->is_default;
                                     if ($default == 1) {
                                         $dif_card = $cardlist->id;
                                         $cards['is_default_text'] = "default";
                                     } else {
                                         $cards['is_default_text'] = "not_default";
                                     }
                                     $cards['card_id'] = $cardlist->id;
                                     $cards['owner_id'] = $cardlist->owner_id;
                                     $cards['customer_id'] = $cardlist->customer_id;
                                     $cards['last_four'] = $cardlist->last_four;
                                     $cards['card_token'] = $cardlist->card_token;
                                     $cards['card_type'] = $cardlist->card_type;
                                     $cards['is_default'] = $default;
                                 }
                                 $code_data = Ledger::where('owner_id', '=', $owner_data->id)->first();
                                 $owner = array();
                                 $owner['owner_lat'] = $owner_data->latitude;
                                 $owner['owner_long'] = $owner_data->longitude;
                                 $owner['owner_dist_lat'] = $request->D_latitude;
                                 $owner['owner_dist_long'] = $request->D_longitude;
                                 $owner['payment_type'] = $request->payment_mode;
                                 $owner['default_card'] = $dif_card;
                                 $owner['dest_latitude'] = $request->D_latitude;
                                 $owner['dest_longitude'] = $request->D_longitude;
                                 $owner['referral_code'] = $code_data->referral_code;
                                 $owner['is_referee'] = $owner_data->is_referee;
                                 $owner['promo_count'] = $owner_data->promo_count;
                                 /* $driver = Keywords::where('id', 1)->first(); */
                                 $requestserv = RequestServices::where('request_id', $request->id)->first();
                                 $charge = array();
                                 $request_typ = ProviderType::where('id', '=', $requestserv->type)->first();
                                 $settings = Settings::where('key', 'default_distance_unit')->first();
                                 $unit = $settings->value;
                                 if ($unit == 0) {
                                     $unit_set = 'kms';
                                 } elseif ($unit == 1) {
                                     $unit_set = 'miles';
                                 }
                                 $charge['unit'] = $unit_set;
                                 if ($requestserv->base_price != 0) {
                                     $charge['base_distance'] = $request_typ->base_distance;
                                     $charge['base_price'] = currency_converted($requestserv->base_price);
                                     $charge['distance_price'] = currency_converted($requestserv->distance_cost);
                                     $charge['price_per_unit_time'] = currency_converted($requestserv->time_cost);
                                 } else {
                                     /* $setbase_price = Settings::where('key', 'base_price')->first();
                                        $charge['base_price'] = currency_converted($setbase_price->value);
                                        $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
                                        $charge['distance_price'] = currency_converted($setdistance_price->value);
                                        $settime_price = Settings::where('key', 'price_per_unit_time')->first();
                                        $charge['price_per_unit_time'] = currency_converted($settime_price->value); */
                                     $charge['base_distance'] = $request_typ->base_distance;
                                     $charge['base_price'] = currency_converted($request_typ->base_price);
                                     $charge['distance_price'] = currency_converted($request_typ->price_per_unit_distance);
                                     $charge['price_per_unit_time'] = currency_converted($request_typ->price_per_unit_time);
                                 }
                                 $charge['total'] = currency_converted($request->total);
                                 $charge['is_paid'] = $request->is_paid;
                                 $response_array = array('success' => true, 'unique_id' => 1, 'status' => $request->status, '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, 'confirmed_walker' => 0, '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, 'is_cancelled' => $request->is_cancelled, 'dest_latitude' => $request->D_latitude, 'dest_longitude' => $request->D_longitude, 'promo_id' => $request->promo_id, 'promo_code' => $request->promo_code, 'walker' => $walker_data, 'bill' => "", 'owner' => $owner, 'card_details' => $cards, 'charge_details' => $charge, 'confirmed_walker' => 0, 'error_code' => 484, 'error' => 'Searching for ' . Config::get('app.generic_keywords.Provider') . 's.');
                             }
                         } else {
                             /* $driver = Keywords::where('id', 1)->first(); */
                             if ($request->current_walker != 0) {
                                 $walker = Walker::find($request->current_walker);
                                 $walker_data = array();
                                 $walker_data['unique_id'] = 1;
                                 $walker_data['id'] = $walker->id;
                                 $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['car_model'] = $walker->car_model;
                                 $walker_data['car_number'] = $walker->car_number;
                                 $walker_data['bearing'] = $walker->bearing;
                                 // $walker_data['payment_type'] = $request->payment_mode;
                                 $walker_data['rating'] = $walker->rate;
                                 $walker_data['num_rating'] = $walker->rate_count;
                             }
                             $cards = "";
                             /* $cards['none'] = ""; */
                             $dif_card = 0;
                             $cardlist = Payment::where('owner_id', $owner_id)->where('is_default', 1)->first();
                             /* $cardlist = Payment::where('id', $owner_data->default_card_id)->first(); */
                             if (count($cardlist) >= 1) {
                                 $cards = array();
                                 $default = $cardlist->is_default;
                                 if ($default == 1) {
                                     $dif_card = $cardlist->id;
                                     $cards['is_default_text'] = "default";
                                 } else {
                                     $cards['is_default_text'] = "not_default";
                                 }
                                 $cards['card_id'] = $cardlist->id;
                                 $cards['owner_id'] = $cardlist->owner_id;
                                 $cards['customer_id'] = $cardlist->customer_id;
                                 $cards['last_four'] = $cardlist->last_four;
                                 $cards['card_token'] = $cardlist->card_token;
                                 $cards['card_type'] = $cardlist->card_type;
                                 $cards['is_default'] = $default;
                             }
                             $code_data = Ledger::where('owner_id', '=', $owner_data->id)->first();
                             $owner = array();
                             $owner['owner_lat'] = $owner_data->latitude;
                             $owner['owner_long'] = $owner_data->longitude;
                             $owner['owner_dist_lat'] = $request->D_latitude;
                             $owner['owner_dist_long'] = $request->D_longitude;
                             $owner['payment_type'] = $request->payment_mode;
                             $owner['default_card'] = $dif_card;
                             $owner['dest_latitude'] = $request->D_latitude;
                             $owner['dest_longitude'] = $request->D_longitude;
                             $owner['referral_code'] = $code_data->referral_code;
                             $owner['is_referee'] = $owner_data->is_referee;
                             $owner['promo_count'] = $owner_data->promo_count;
                             /* $driver = Keywords::where('id', 1)->first(); */
                             $requestserv = RequestServices::where('request_id', $request->id)->first();
                             $charge = array();
                             $request_typ = ProviderType::where('id', '=', $requestserv->type)->first();
                             $settings = Settings::where('key', 'default_distance_unit')->first();
                             $unit = $settings->value;
                             if ($unit == 0) {
                                 $unit_set = 'kms';
                             } elseif ($unit == 1) {
                                 $unit_set = 'miles';
                             }
                             $charge['unit'] = $unit_set;
                             if ($requestserv->base_price != 0) {
                                 $charge['base_distance'] = $request_typ->base_distance;
                                 $charge['base_price'] = currency_converted($requestserv->base_price);
                                 $charge['distance_price'] = currency_converted($requestserv->distance_cost);
                                 $charge['price_per_unit_time'] = currency_converted($requestserv->time_cost);
                             } else {
                                 /* $setbase_price = Settings::where('key', 'base_price')->first();
                                    $charge['base_price'] = currency_converted($setbase_price->value);
                                    $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first();
                                    $charge['distance_price'] = currency_converted($setdistance_price->value);
                                    $settime_price = Settings::where('key', 'price_per_unit_time')->first();
                                    $charge['price_per_unit_time'] = currency_converted($settime_price->value); */
                                 $charge['base_distance'] = $request_typ->base_distance;
                                 $charge['base_price'] = currency_converted($request_typ->base_price);
                                 $charge['distance_price'] = currency_converted($request_typ->price_per_unit_distance);
                                 $charge['price_per_unit_time'] = currency_converted($request_typ->price_per_unit_time);
                             }
                             $charge['total'] = currency_converted($request->total);
                             $charge['is_paid'] = $request->is_paid;
                             $response_array = array('success' => false, 'unique_id' => 1, 'status' => $request->status, '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, 'confirmed_walker' => 0, '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, 'is_cancelled' => $request->is_cancelled, 'dest_latitude' => $request->D_latitude, 'dest_longitude' => $request->D_longitude, 'promo_id' => $request->promo_id, 'promo_code' => $request->promo_code, 'walker' => $walker_data, 'bill' => "", 'owner' => $owner, 'card_details' => $cards, 'charge_details' => $charge, 'current_walker' => 0, 'error_code' => 483, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . 's are available currently. Please try after sometime.');
                         }
                         $response_code = 200;
                     } else {
                         /* $response_array = array('success' => false, 'error' => 'Request ID doesnot matches with ' . $var->keyword . ' ID', 'error_code' => 407); */
                         $response_array = array('success' => false, 'error' => 'Request ID doesnot matches with ' . Config::get('app.generic_keywords.User') . ' ID', 'error_code' => 407);
                         $response_code = 200;
                     }
                 } else {
                     $response_array = array('success' => false, 'error' => 'Request ID Not Found', 'error_code' => 408);
                     $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' => '' . $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 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');
 }