public function isUniqueInLedger($data)
{
if (empty($data['code'])) {
return true;
}
/* Load the Ledger model */
App::import("Webzash.Model", "Ledger");
$Ledger = new Ledger();
$count = $Ledger->find('count', array('conditions' => array('code' => $data['code'])));
if ($count != 0) {
return false;
} else {
return true;
}
}
public function apply_referral_code()
{
$referral_code = Input::get('referral_code');
$token = Input::get('token');
$owner_id = Input::get('id');
$validator = Validator::make(array('referral_code' => $referral_code, 'token' => $token, 'owner_id' => $owner_id), array('referral_code' => 'required', 'token' => 'required', 'owner_id' => 'required|integer'));
if ($validator->fails()) {
$error_messages = $validator->messages();
$response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401);
$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) {
if ($ledger = Ledger::where('referral_code', $referral_code)->first()) {
$referred_by = $ledger->owner_id;
$settings = Settings::where('key', 'default_referral_bonus')->first();
$referral_bonus = $settings->value;
$ledger = Ledger::find($ledger->id);
$ledger->total_referrals = $ledger->total_referrals + 1;
$ledger->amount_earned = $ledger->amount_earned + $referral_bonus;
$ledger->save();
$owner = Owner::find($owner_id);
$owner->referred_by = $ledger->owner_id;
$owner->save();
$response_array = array('success' => true);
$response_code = 200;
} else {
$response_array = array('success' => false, 'error' => 'Invalid referral code', 'error_code' => 405);
$response_code = 200;
}
} else {
$response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
$response_code = 200;
}
} else {
if ($is_admin) {
$response_array = array('success' => false, 'error' => 'Owner ID is 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 updateUserCode()
{
$owner_id = Session::get('user_id');
$code = Input::get('code');
$code_count = Ledger::where('referral_code', '=', $code)->where('owner_id', '!=', $owner_id)->count();
if ($code_count) {
$message = "This referral code is already in use. Please choose a new one";
$type = "danger";
} else {
$ledger = Ledger::where('owner_id', $owner_id)->first();
$ledger = Ledger::find($ledger->id);
$ledger->referral_code = $code;
$ledger->save();
$message = "Your referral code is successfully updated";
$type = "success";
}
return Redirect::to('/user/payments')->with('message', $message)->with('type', $type);
}
public function providerTripChangeState()
{
$date = date("Y-m-d H:i:s");
$time_limit = date("Y-m-d H:i:s", strtotime($date) - 3 * 60 * 60);
$walker_id = Session::get('walker_id');
$state = $request_id = Request::segment(4);
$current_request = Requests::where('confirmed_walker', $walker_id)->where('is_cancelled', 0)->where('is_dog_rated', 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_dog_rated', 0);
});
})->first();
if ($current_request && $state) {
if ($state == 2) {
$current_request->is_walker_started = 1;
$owner = Owner::find($current_request->owner_id);
$walker = Walker::find($walker_id);
$location = get_location($owner->latitude, $owner->longitude);
$latitude = $location['lat'];
$longitude = $location['long'];
$angle = get_angle($walker->latitude, $walker->longitude, $latitude, $longitude);
$walker->old_latitude = $walker->latitude;
$walker->old_longitude = $walker->longitude;
$walker->latitude = $latitude;
$walker->longitude = $longitude;
$walker->bearing = $angle;
$walker->save();
$walk_location = new WalkLocation();
$walk_location->request_id = $current_request->id;
$walk_location->latitude = $latitude;
$walk_location->longitude = $longitude;
$walk_location->distance = 0;
$walk_location->save();
}
if ($state == 3) {
$current_request->is_walker_arrived = 1;
}
if ($state == 4) {
$current_request->is_started = 1;
}
if ($state == 6) {
$rating = 0;
if (Input::has('rating')) {
$rating = Input::get('rating');
}
$current_request->is_dog_rated = 1;
$current_request->save();
$review_dog = new DogReview();
$review_dog->walker_id = $current_request->confirmed_walker;
$review_dog->comment = Input::get('review');
$review_dog->rating = $rating;
$review_dog->owner_id = $current_request->owner_id;
$review_dog->request_id = $current_request->id;
$review_dog->save();
if ($rating) {
if ($owner = Owner::find($current_request->owner_id)) {
$old_rate = $owner->rate;
$old_rate_count = $owner->rate_count;
$new_rate_counter = $owner->rate_count + 1;
$new_rate = ($owner->rate * $owner->rate_count + $rating) / $new_rate_counter;
$owner->rate_count = $new_rate_counter;
$owner->rate = $new_rate;
$owner->save();
}
}
$message = "You has successfully rated the owner.";
$type = "success";
return Redirect::to('/provider/trips')->with('message', $message)->with('type', $type);
}
if ($state == 5) {
$request_services = RequestServices::where('request_id', $current_request->id)->first();
$request_typ = ProviderType::where('id', '=', $request_services->req_typ)->first();
$address = urlencode(Input::get('address'));
$end_address = json_decode(file_get_contents("https://maps.googleapis.com/maps/api/geocode/json?address={$address}"), TRUE);
$end_location = $end_address['results'][0]['geometry'];
$latitude = $end_location['location']['lat'];
$longitude = $end_location['location']['lng'];
$location = get_location($latitude, $longitude);
$latitude = $location['lat'];
$longitude = $location['long'];
$request_id = $current_request->id;
$walk_location_last = WalkLocation::where('request_id', $request_id)->orderBy('created_at', 'desc')->first();
if ($walk_location_last) {
$distance_old = $walk_location_last->distance;
$distance_new = distanceGeoPoints($walk_location_last->latitude, $walk_location_last->longitude, $latitude, $longitude);
$distance = $distance_old + $distance_new;
$settings = Settings::where('key', 'default_distance_unit')->first();
//$unit = $settings->value;
$distance = $distance;
} else {
$distance = 0;
}
$walker = Walker::find($walker_id);
$angle = get_angle($walker->latitude, $walker->longitude, $latitude, $longitude);
$walker->old_latitude = $walker->latitude;
$walker->old_longitude = $walker->longitude;
$walker->latitude = $latitude;
$walker->longitude = $longitude;
$walker->bearing = $angle;
$walker->save();
$walk_location = new WalkLocation();
$walk_location->request_id = $request_id;
$walk_location->latitude = $latitude;
$walk_location->longitude = $longitude;
$walk_location->distance = $distance;
$walk_location->save();
Walker::where('id', '=', $walker_id)->update(array('is_available' => 1));
// Calculate Rerquest Stats
$time = 0;
$time_query = "SELECT TIMESTAMPDIFF(SECOND,MIN(created_at),MAX(created_at)) as diff\n\t\t\t\tFROM walk_location where request_id = {$current_request->id}\n\t\t\t\tGROUP BY request_id limit 1 ";
$time_data = DB::select(DB::raw($time_query));
foreach ($time_data as $time_diff) {
$time = $time_diff->diff;
}
$time = $time / 60;
/* TIME CALCULATION REDIRECTED */
$time = 0;
/* TIME CALCULATION REDIRECTED END */
$walker_data = Walker::find($current_request->confirmed_walker);
$provider_type = ProviderServices::where('type', $walker_data->type)->where('provider_id', $walker_id)->first();
if ($provider_type == NULL) {
/* $settings = Settings::where('key', 'price_per_unit_distance')->first();
$price_per_unit_distance = $settings->value;
$settings = Settings::where('key', 'price_per_unit_time')->first();
$price_per_unit_time = $settings->value;
$settings = Settings::where('key', 'base_price')->first();
$base_price = $settings->value; */
$setbase_distance = $request_typ->base_distance;
$base_price = $request_typ->base_price;
$price_per_unit_distance = $request_typ->price_per_unit_distance;
$price_per_unit_time = $request_typ->price_per_unit_time;
} else {
// $setbase_distance = $request_typ->base_distance;
$setbase_distance = "";
$provider_type = ProviderServices::where('type', $walker_data->type)->where('provider_id', $walker_id)->first();
$base_price = $provider_type->base_price;
$price_per_unit_distance = $provider_type->price_per_unit_distance;
$price_per_unit_time = $provider_type->price_per_unit_time;
}
$settings = Settings::where('key', 'default_charging_method_for_users')->first();
$pricing_type = $settings->value;
$settings = Settings::where('key', 'default_distance_unit')->first();
//$unit = $settings->value;
$distance = convert($distance);
if ($pricing_type == 1) {
if ($distance <= $setbase_distance) {
$distance_cost = 0;
} else {
$distance_cost = $price_per_unit_distance * ($distance - $setbase_distance);
}
$time_cost = $price_per_unit_time * $time;
$total = $base_price + $distance_cost + $time_cost;
} else {
$distance_cost = 0;
$time_cost = 0;
$total = $base_price;
}
$current_request->is_completed = 1;
$current_request->distance = $distance;
$current_request->time = $time;
$request_services->base_price = $base_price;
$request_services->distance_cost = $distance_cost;
$request_services->time_cost = $time_cost;
$request_services->total = $total;
$current_request->total = $total;
$request_services->save();
// charge client
// charge client
$ledger = Ledger::where('owner_id', $current_request->owner_id)->first();
if ($ledger) {
$balance = $ledger->amount_earned - $ledger->amount_spent;
if ($balance > 0) {
if ($total > $balance) {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $balance;
$ledger_temp->save();
$total = $total - $balance;
} else {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $total;
$ledger_temp->save();
$total = 0;
}
}
}
$promo_discount = 0;
if ($pcode = PromoCodes::where('id', $current_request->promo_code)->where('type', 1)->first()) {
$discount = $pcode->value / 100;
$promo_discount = $total * $discount;
$total = $total - $promo_discount;
if ($total < 0) {
$total = 0;
}
}
$current_request->total = $total;
$current_request->save();
$cod_sett = Settings::where('key', 'cod')->first();
$allow_cod = $cod_sett->value;
if ($current_request->payment_mode == 1 and $allow_cod == 1) {
// Pay by Cash
$current_request->is_paid = 1;
Log::info('allow_cod');
} elseif ($current_request->payment_mode == 2) {
// paypal
Log::info('paypal payment');
} else {
Log::info('normal payment. Stored cards');
// stored cards
if ($total == 0) {
$current_request->is_paid = 1;
} else {
$payment_data = Payment::where('owner_id', $current_request->owner_id)->where('is_default', 1)->first();
if (!$payment_data) {
$payment_data = Payment::where('owner_id', $current_request->owner_id)->first();
}
if ($payment_data) {
$customer_id = $payment_data->customer_id;
$setransfer = Settings::where('key', 'transfer')->first();
$transfer_allow = $setransfer->value;
if (Config::get('app.default_payment') == 'stripe') {
//dd($customer_id);
Stripe::setApiKey(Config::get('app.stripe_secret_key'));
try {
$charge = Stripe_Charge::create(array("amount" => ceil($total * 100), "currency" => "usd", "customer" => $customer_id));
Log::info($charge);
} catch (Stripe_InvalidRequestError $e) {
// Invalid parameters were supplied to Stripe's API
$ownr = Owner::find($current_request->owner_id);
$ownr->debt = $total;
$ownr->save();
$message = array('error' => $e->getMessage());
$type = "success";
Log::info($message);
return Redirect::to('/provider/tripinprogress')->with('message', $message)->with('type', $type);
}
$current_request->is_paid = 1;
$settng = Settings::where('key', 'service_fee')->first();
$settng_mode = Settings::where('key', 'payment_mode')->first();
if ($settng_mode->value == 2 and $transfer_allow == 1) {
$transfer = Stripe_Transfer::create(array("amount" => ($total - $settng->value * $total / 100) * 100, "currency" => "usd", "recipient" => $walker_data->merchant_id));
$current_request->transfer_amount = $total - $settng->value * $total / 100;
}
} else {
try {
Braintree_Configuration::environment(Config::get('app.braintree_environment'));
Braintree_Configuration::merchantId(Config::get('app.braintree_merchant_id'));
Braintree_Configuration::publicKey(Config::get('app.braintree_public_key'));
Braintree_Configuration::privateKey(Config::get('app.braintree_private_key'));
if ($settng_mode->value == 2 and $transfer_allow == 1) {
$sevisett = Settings::where('key', 'service_fee')->first();
$service_fee = $sevisett->value * $total / 100;
$result = Braintree_Transaction::sale(array('amount' => $total - $service_fee, 'paymentMethodNonce' => $customer_id, 'merchantAccountId' => $walker_data->merchant_id, 'options' => array('submitForSettlement' => true, 'holdInEscrow' => true), 'serviceFeeAmount' => $service_fee));
} else {
$result = Braintree_Transaction::sale(array('amount' => $total, 'paymentMethodNonce' => $customer_id));
}
if ($result->success) {
$request->is_paid = 1;
} else {
$request->is_paid = 0;
}
} catch (Exception $e) {
$message = "Something went wrong in the payment. Please try again.";
$type = "success";
return Redirect::to('/provider/tripinprogress')->with('message', $message)->with('type', $type);
}
}
$current_request->card_payment = $total;
$current_request->ledger_payment = $current_request->total - $total;
}
}
}
$current_request->save();
}
$current_request->save();
}
return Redirect::to('/provider/tripinprogress');
}
public function apply_referral_code()
{
$referral_code = Input::get('referral_code');
$token = Input::get('token');
$owner_id = Input::get('id');
$is_skip = Input::get('is_skip');
$validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'is_skip' => $is_skip), array('token' => 'required', 'owner_id' => 'required|integer', 'is_skip' => 'required'));
if ($validator->fails()) {
$error_messages = $validator->messages();
$response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401);
$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) {
if ($is_skip != 1) {
if ($ledger = Ledger::where('referral_code', $referral_code)->first()) {
$referred_by = $ledger->owner_id;
if ($referred_by != $owner_id) {
if ($owner_data->is_referee) {
$owner = Owner::find($owner_id);
$code_data = Ledger::where('owner_id', '=', $owner->id)->first();
$response_array = array('success' => false, 'error' => "Sorry, You have apready apply the refereel code.", 'error_code' => 405, 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count);
$response_code = 200;
} else {
$settings = Settings::where('key', 'default_referral_bonus_to_refered_user')->first();
$refered_user = $settings->value;
$settings = Settings::where('key', 'default_referral_bonus_to_refereel')->first();
$referral = $settings->value;
$ledger = Ledger::find($ledger->id);
$ledger->total_referrals = $ledger->total_referrals + 1;
$ledger->amount_earned = $ledger->amount_earned + $refered_user;
$ledger->save();
$ledger1 = Ledger::where('owner_id', $owner_id)->first();
$ledger1 = Ledger::find($ledger1->id);
$ledger1->amount_earned = $ledger1->amount_earned + $referral;
$ledger1->save();
$owner = Owner::find($owner_id);
$owner->referred_by = $ledger->owner_id;
$owner->is_referee = 1;
$owner->save();
$owner = Owner::find($owner_id);
$code_data = Ledger::where('owner_id', '=', $owner->id)->first();
$response_array = array('success' => true, 'error' => 'Referral process successfully completed.', 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count);
$response_code = 200;
}
} else {
$owner = Owner::find($owner_id);
$code_data = Ledger::where('owner_id', '=', $owner->id)->first();
$response_array = array('success' => false, 'error' => "Sorry, You can't apply your refereel code.", 'error_code' => 405, 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count);
$response_code = 200;
}
} else {
$owner = Owner::find($owner_id);
$code_data = Ledger::where('owner_id', '=', $owner->id)->first();
$response_array = array('success' => false, 'error' => 'Invalid referral code', 'error_code' => 405, 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count);
$response_code = 200;
}
} else {
$owner = Owner::find($owner_id);
$owner->is_referee = 1;
$owner->save();
$owner = Owner::find($owner_id);
$code_data = Ledger::where('owner_id', '=', $owner->id)->first();
$response_array = array('success' => true, 'error' => 'You have skipped for referral process', 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count);
$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 is 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 request_walk_completed()
{
if (Request::isMethod('post')) {
$request_id = Input::get('request_id');
$token = Input::get('token');
$walker_id = Input::get('id');
$latitude = Input::get('latitude');
$longitude = Input::get('longitude');
$distance = Input::get('distance');
$time = Input::get('time');
$walker = Walker::find($walker_id);
$validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'walker_id' => $walker_id, 'latitude' => $latitude, 'longitude' => $longitude, 'distance' => $distance, 'time' => $time), array('request_id' => 'required|integer', 'token' => 'required', 'walker_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required', 'distance' => 'required', 'time' => '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) {
// Do necessary operations
if ($request = Requests::find($request_id)) {
if ($request->confirmed_walker == $walker_id) {
if ($request->is_started == 1) {
$settings = Settings::where('key', 'default_charging_method_for_users')->first();
$pricing_type = $settings->value;
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
$distance = convert($distance, $unit);
$pt = ProviderServices::where('provider_id', $walker_id)->get();
foreach ($pt as $key) {
$reqserv = RequestServices::where('request_id', $request_id)->where('type', $key->type)->first();
$base_price = $key->base_price;
$price_per_unit_distance = $key->price_per_unit_distance * $distance;
$price_per_unit_time = $key->price_per_unit_time * $time;
$reqserv->base_price = $base_price;
$reqserv->distance_cost = $price_per_unit_distance;
$reqserv->time_cost = $price_per_unit_time;
$reqserv->total = $base_price + $price_per_unit_distance + $price_per_unit_time;
$reqserv->save();
}
$rs = RequestServices::where('request_id', $request_id)->get();
$total = 0;
foreach ($rs as $key) {
Log::info('total = ' . print_r($key->total, true));
$total = $total + $key->total;
}
$request->is_completed = 1;
$request->distance = $distance;
$request->time = $time;
$request->total = $total;
// charge client
$ledger = Ledger::where('owner_id', $request->owner_id)->first();
if ($ledger) {
$balance = $ledger->amount_earned - $ledger->amount_spent;
if ($balance > 0) {
if ($total > $balance) {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $balance;
$ledger_temp->save();
$total = $total - $balance;
} else {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $total;
$ledger_temp->save();
$total = 0;
}
}
}
if ($total == 0) {
$request->is_paid = 1;
} else {
$payment_data = Payment::where('owner_id', $request->owner_id)->first();
if ($payment_data) {
$customer_id = $payment_data->customer_id;
try {
if (Config::get('app.default_payment') == 'stripe') {
$am = round($total) * 100;
$sett = Settings::where('key', 'service_fee')->first();
$serviceFee = $sett->value * 100;
$amount = $am - $serviceFee;
Stripe::setApiKey(Config::get('app.stripe_secret_key'));
Stripe_Charge::create(array("amount" => $am, "currency" => "usd", "customer" => $customer_id));
if ($walker->merchant_id != NULL) {
$transfer = Stripe_Transfer::create(array("amount" => $amount, "currency" => "usd", "recipient" => $walker->merchant_id, "statement_descriptor" => "UberFoxX"));
Log::info('transfer = ' . print_r($transfer, true));
}
$request->is_paid = 1;
} else {
$am = round($total, 2);
$sett = Settings::where('key', 'service_fee')->first();
$serviceFee = $sett->value;
$amount = $am - $serviceFee;
Braintree_Configuration::environment(Config::get('app.braintree_environment'));
Braintree_Configuration::merchantId(Config::get('app.braintree_merchant_id'));
Braintree_Configuration::publicKey(Config::get('app.braintree_public_key'));
Braintree_Configuration::privateKey(Config::get('app.braintree_private_key'));
$card_id = $payment_data->card_token;
if ($walker->merchant_id == NULL) {
$result = Braintree_Transaction::sale(array('amount' => $amount, 'paymentMethodToken' => $card_id));
} else {
$result = Braintree_Transaction::sale(array('amount' => $amount, 'paymentMethodToken' => $card_id, 'merchantAccountId' => $walker->merchant_id, 'serviceFeeAmount' => $serviceFee));
}
Log::info('result = ' . print_r($result, true));
if ($result->success) {
$request->is_paid = 1;
} else {
$request->is_paid = 0;
}
}
} catch (Exception $e) {
$response_array = array('success' => false, 'error' => $e, 'error_code' => 405);
$response_code = 200;
$response = Response::json($response_array, $response_code);
return $response;
}
}
}
$request->card_payment = $total;
$request->ledger_payment = $request->total - $total;
$request->save();
if ($request->is_paid == 1) {
$owner = Owner::find($request->owner_id);
$settings = Settings::where('key', 'sms_request_unanswered')->first();
$pattern = $settings->value;
$pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%user_mobile%', $owner->phone, $pattern);
sms_notification(1, 'admin', $pattern);
}
$walker = Walker::find($walker_id);
$walker->is_available = 1;
$walker->save();
$walk_location = new WalkLocation();
$walk_location->latitude = $latitude;
$walk_location->longitude = $longitude;
$walk_location->request_id = $request_id;
$walk_location->save();
// Send Notification
$walker = Walker::find($request->confirmed_walker);
$walker_data = array();
$walker_data['first_name'] = $walker->first_name;
$walker_data['last_name'] = $walker->last_name;
$walker_data['phone'] = $walker->phone;
$walker_data['bio'] = $walker->bio;
$walker_data['picture'] = $walker->picture;
$walker_data['latitude'] = $walker->latitude;
$walker_data['longitude'] = $walker->longitude;
$walker_data['type'] = $walker->type;
$walker_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->avg('rating') ?: 0;
$walker_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->count();
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
$bill = array();
if ($request->is_completed == 1) {
$bill['distance'] = convert($request->distance, $unit);
$bill['time'] = $request->time;
$bill['base_price'] = $request->base_price;
$bill['distance_cost'] = $request->distance_cost;
$bill['time_cost'] = $request->time_cost;
$bill['total'] = $request->total;
$bill['is_paid'] = $request->is_paid;
}
$response_array = array('success' => true, 'request_id' => $request_id, 'status' => $request->status, 'confirmed_walker' => $request->confirmed_walker, 'is_walker_started' => $request->is_walker_started, 'is_walker_arrived' => $request->is_walker_arrived, 'is_walk_started' => $request->is_started, 'is_completed' => $request->is_completed, 'is_walker_rated' => $request->is_walker_rated, 'walker' => $walker_data, 'bill' => $bill);
$title = "Trip Completed";
$message = $response_array;
send_notifications($request->owner_id, "owner", $title, $message);
// Send SMS
$owner = Owner::find($request->owner_id);
$settings = Settings::where('key', 'sms_when_provider_completes_job')->first();
$pattern = $settings->value;
$pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
$pattern = str_replace('%driver%', $walker->first_name . " " . $walker->last_name, $pattern);
$pattern = str_replace('%driver_mobile%', $walker->phone, $pattern);
$pattern = str_replace('%damount%', $request->total, $pattern);
sms_notification($request->owner_id, 'owner', $pattern);
// send email
$settings = Settings::where('key', 'email_request_finished')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern);
$subject = "Request Completed";
email_notification(1, 'admin', $pattern, $subject);
$settings = Settings::where('key', 'email_invoice_generated_user')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%amount%', $request->total, $pattern);
$subject = "Invoice Generated";
email_notification($request->owner_id, 'owner', $pattern, $subject);
$settings = Settings::where('key', 'email_invoice_generated_provider')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%amount%', $request->total, $pattern);
$subject = "Invoice Generated";
email_notification($request->confirmed_walker, 'walker', $pattern, $subject);
if ($request->is_paid == 1) {
// send email
$settings = Settings::where('key', 'email_payment_charged')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern);
$subject = "Payment Charged";
email_notification(1, 'admin', $pattern, $subject);
}
$response_array = array('success' => true, 'total' => $total, 'is_paid' => $request->is_paid);
$response_code = 200;
} else {
$response_array = array('success' => false, 'error' => 'Walk not yet started', 'error_code' => 413);
$response_code = 200;
}
} else {
$response_array = array('success' => false, 'error' => 'Walk ID doesnot matches with Walker ID', 'error_code' => 407);
$response_code = 200;
}
} else {
$response_array = array('success' => false, 'error' => 'Walk 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' => '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 pre_payment()
{
if (Request::isMethod('post')) {
$request_id = Input::get('request_id');
$token = Input::get('token');
$walker_id = Input::get('id');
$time = Input::get('time');
$validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'walker_id' => $walker_id, 'time' => $time), array('request_id' => 'required|integer', 'token' => 'required', 'walker_id' => 'required|integer', 'time' => '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) {
// Do necessary operations
if ($request = Requests::find($request_id)) {
if ($request->confirmed_walker == $walker_id) {
$request_service = RequestServices::find($request_id);
$request_typ = ProviderType::where('id', '=', $request_service->type)->first();
if (!$walker_data->type) {
/* $settings = Settings::where('key', 'price_per_unit_distance')->first();
$price_per_unit_distance = $settings->value;
$settings = Settings::where('key', 'price_per_unit_time')->first();
$price_per_unit_time = $settings->value;
$settings = Settings::where('key', 'base_price')->first();
$base_price = $settings->value; */
$price_per_unit_distance = $request_typ->price_per_unit_distance;
$price_per_unit_time = $request_typ->price_per_unit_time;
$base_price = $request_typ->base_price;
} else {
$provider_type = ProviderServices::find($walker_data->type);
$base_price = $provider_type->base_price;
$price_per_unit_distance = $provider_type->price_per_unit_distance;
$price_per_unit_time = $provider_type->price_per_unit_time;
}
$settings = Settings::where('key', 'default_charging_method_for_users')->first();
$pricing_type = $settings->value;
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
if ($pricing_type == 1) {
$distance_cost = $price_per_unit_distance;
$time_cost = $price_per_unit_time;
$total = $base_price + $distance_cost + $time_cost;
} else {
$distance_cost = 0;
$time_cost = 0;
$total = $base_price;
}
Log::info('req');
$request_service = RequestServices::find($request_id);
$request_service->base_price = $base_price;
$request_service->distance_cost = $distance_cost;
$request_service->time_cost = $time_cost;
$request_service->total = $total;
$request_service->save();
$request->distance = $distance_cost;
$request->time = $time_cost;
$request->total = $total;
Log::info('in ');
// charge client
$ledger = Ledger::where('owner_id', $request->owner_id)->first();
if ($ledger) {
$balance = $ledger->amount_earned - $ledger->amount_spent;
if ($balance > 0) {
if ($total > $balance) {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $balance;
$ledger_temp->save();
$total = $total - $balance;
} else {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $total;
$ledger_temp->save();
$total = 0;
}
}
}
Log::info('out');
if ($total == 0) {
$request->is_paid = 1;
} else {
$payment_data = Payment::where('owner_id', $request->owner_id)->where('is_default', 1)->first();
if (!$payment_data) {
$payment_data = Payment::where('owner_id', $request->owner_id)->first();
}
if ($payment_data) {
$customer_id = $payment_data->customer_id;
try {
if (Config::get('app.default_payment') == 'stripe') {
Stripe::setApiKey(Config::get('app.stripe_secret_key'));
try {
Stripe_Charge::create(array("amount" => floor($total) * 100, "currency" => "usd", "customer" => $customer_id));
} catch (Stripe_InvalidRequestError $e) {
// Invalid parameters were supplied to Stripe's API
$ownr = Owner::find($request->owner_id);
$ownr->debt = $total;
$ownr->save();
$response_array = array('error' => $e->getMessage());
$response_code = 200;
$response = Response::json($response_array, $response_code);
return $response;
}
$request->is_paid = 1;
$setting = Settings::where('key', 'paypal')->first();
$settng1 = Settings::where('key', 'service_fee')->first();
if ($setting->value == 2 && $walker_data->merchant_id != NULL) {
// dd($amount$request->transfer_amount);
$transfer = Stripe_Transfer::create(array("amount" => ($total - $settng1->value) * 100, "currency" => "usd", "recipient" => $walker_data->merchant_id));
}
} else {
$amount = $total;
Braintree_Configuration::environment(Config::get('app.braintree_environment'));
Braintree_Configuration::merchantId(Config::get('app.braintree_merchant_id'));
Braintree_Configuration::publicKey(Config::get('app.braintree_public_key'));
Braintree_Configuration::privateKey(Config::get('app.braintree_private_key'));
$card_id = $payment_data->card_token;
$setting = Settings::where('key', 'paypal')->first();
$settng1 = Settings::where('key', 'service_fee')->first();
if ($setting->value == 2 && $walker_data->merchant_id != NULL) {
// escrow
$result = Braintree_Transaction::sale(array('amount' => $amount, 'paymentMethodToken' => $card_id));
} else {
$result = Braintree_Transaction::sale(array('amount' => $amount, 'paymentMethodToken' => $card_id));
}
Log::info('result = ' . print_r($result, true));
if ($result->success) {
$request->is_paid = 1;
} else {
$request->is_paid = 0;
}
}
} catch (Exception $e) {
$response_array = array('success' => false, 'error' => $e, 'error_code' => 405);
$response_code = 200;
$response = Response::json($response_array, $response_code);
return $response;
}
}
}
$request->card_payment = $total;
$request->ledger_payment = $request->total - $total;
$request->save();
Log::info('Request = ' . print_r($request, true));
if ($request->is_paid == 1) {
$owner = Owner::find($request->owner_id);
$settings = Settings::where('key', 'sms_request_unanswered')->first();
$pattern = $settings->value;
$pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%user_mobile%', $owner->phone, $pattern);
sms_notification(1, 'admin', $pattern);
}
$walker = Walker::find($walker_id);
$walker->is_available = 1;
$walker->save();
// Send Notification
$walker = Walker::find($request->confirmed_walker);
$walker_data = array();
$walker_data['first_name'] = $walker->first_name;
$walker_data['last_name'] = $walker->last_name;
$walker_data['phone'] = $walker->phone;
$walker_data['bio'] = $walker->bio;
$walker_data['picture'] = $walker->picture;
$walker_data['type'] = $walker->type;
$walker_data['rating'] = $walker->rate;
$walker_data['num_rating'] = $walker->rate_count;
$walker_data['car_model'] = $walker->car_model;
$walker_data['car_number'] = $walker->car_number;
/* $walker_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->avg('rating') ? : 0;
$walker_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->count(); */
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
if ($unit == 0) {
$unit_set = 'kms';
} elseif ($unit == 1) {
$unit_set = 'miles';
}
$bill = array();
if ($request->is_paid == 1) {
$bill['distance'] = (string) convert($request->distance, $unit);
$bill['unit'] = $unit_set;
$bill['time'] = $request->time;
$bill['base_price'] = currency_converted($base_price);
$bill['distance_cost'] = currency_converted($distance_cost);
$bill['time_cost'] = currency_converted($time_cost);
$bill['total'] = currency_converted($request->total);
$bill['is_paid'] = $request->is_paid;
}
$response_array = array('success' => true, 'request_id' => $request_id, 'status' => $request->status, 'confirmed_walker' => $request->confirmed_walker, 'walker' => $walker_data, 'bill' => $bill);
$title = "Payment Has Made";
$message = $response_array;
send_notifications($walker->id, "walker", $title, $message);
$settings = Settings::where('key', 'email_notification')->first();
$condition = $settings->value;
if ($condition == 1) {
/* $settings = Settings::where('key', 'payment_made_client')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%amount%', $request->total, $pattern);
$subject = "Payment Charged";
email_notification($walker->id, 'walker', $pattern, $subject); */
$settings = Settings::where('key', 'admin_email_address')->first();
$admin_email = $settings->value;
$pattern = array('admin_eamil' => $admin_email, 'name' => ucwords($walker->first_name . " " . $walker->last_name), 'amount' => $total, 'req_id' => $request_id, 'web_url' => web_url());
$subject = "Payment Done With " . $request_id . "";
email_notification($walker->id, 'walker', $pattern, $subject, 'pre_payment', null);
}
// Send SMS
$owner = Owner::find($request->owner_id);
$settings = Settings::where('key', 'sms_when_provider_completes_job')->first();
$pattern = $settings->value;
$pattern = str_replace('%user%', $owner->first_name . " " . $owner->last_name, $pattern);
$pattern = str_replace('%driver%', $walker->first_name . " " . $walker->last_name, $pattern);
$pattern = str_replace('%driver_mobile%', $walker->phone, $pattern);
$pattern = str_replace('%amount%', $request->total, $pattern);
sms_notification($request->owner_id, 'owner', $pattern);
$email_data = array();
$email_data['name'] = $owner->first_name;
$email_data['emailType'] = 'user';
$email_data['base_price'] = $bill['base_price'];
$email_data['distance'] = $bill['distance'];
$email_data['time'] = $bill['time'];
$email_data['unit'] = $bill['unit'];
$email_data['total'] = $bill['total'];
if ($bill['payment_mode']) {
$email_data['payment_mode'] = $bill['payment_mode'];
} else {
$email_data['payment_mode'] = '---';
}
/* $subject = "Invoice Generated";
send_email($request->owner_id, 'owner', $email_data, $subject, 'invoice');
$subject = "Invoice Generated";
$email_data['emailType'] = 'walker';
send_email($request->confirmed_walker, 'walker', $email_data, $subject, 'invoice');
*/
if ($request->is_paid == 1) {
// send email
/* $settings = Settings::where('key', 'email_payment_charged')->first();
$pattern = $settings->value;
$pattern = str_replace('%id%', $request->id, $pattern);
$pattern = str_replace('%url%', web_url() . "/admin/request/" . $request->id, $pattern);
$subject = "Payment Charged";
email_notification(1, 'admin', $pattern, $subject); */
$settings = Settings::where('key', 'admin_email_address')->first();
$admin_email = $settings->value;
$pattern = array('admin_eamil' => $admin_email, 'name' => 'Administrator', 'amount' => $total, 'req_id' => $request_id, 'web_url' => web_url());
$subject = "Payment Done With " . $request_id . "";
email_notification(1, 'admin', $pattern, $subject, 'pay_charged', null);
}
$response_array = array('success' => true, 'base_fare' => currency_converted($base_price), 'distance_cost' => currency_converted($distance_cost), 'time_cost' => currency_converted($time_cost), 'total' => currency_converted($total), 'is_paid' => $request->is_paid);
$response_code = 200;
} else {
/* $var = Keywords::where('id', 1)->first();
$response_array = array('success' => false, 'error' => 'Service ID doesnot matches with ' . $var->keyword . ' ID', 'error_code' => 407); */
$response_array = array('success' => false, 'error' => 'Service ID doesnot matches with ' . Config::get('app.generic_keywords.Provider') . ' ID', 'error_code' => 407);
$response_code = 200;
}
} else {
$response_array = array('success' => false, 'error' => 'Service 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) {
/* $var = Keywords::where('id', 1)->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.Provider') . ' ID not Found', 'error_code' => 410);
} else {
$response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
}
$response_code = 200;
}
}
}
$response = Response::json($response_array, $response_code);
return $response;
}
public function userSave()
{
$first_name = Input::get('first_name');
$last_name = Input::get('last_name');
$email = Input::get('email');
$phone = Input::get('phone');
$password = Input::get('password');
$referral_code = Input::get('referral_code');
$validator = Validator::make(array('first_name' => $first_name, 'last_name' => $last_name, 'email' => $email, 'password' => $password), array('password' => 'required', 'email' => 'required', 'last_name' => 'required', 'first_name' => 'required'));
$validator1 = Validator::make(array('email' => $email), array('email' => 'required|email'));
$validatorPhone = Validator::make(array('phone' => $phone), array('phone' => 'phone'));
if ($validator->fails()) {
$error_messages = $validator->messages()->first();
return Redirect::to('user/signup')->with('error', 'Please fill all the fields.');
} else {
if ($validator1->fails()) {
return Redirect::to('user/signup')->with('error', 'Please Enter email correctly.');
} else {
if ($validatorPhone->fails()) {
return Redirect::to('user/signup')->with('error', 'Invalid Phone Number Format');
} else {
if (Owner::where('email', $email)->count() == 0) {
$owner = new Owner();
$owner->first_name = $first_name;
$owner->last_name = $last_name;
$owner->email = $email;
if (Input::has('timezone')) {
$owner->timezone = Input::get('timezone');
}
$owner->phone = $phone;
if ($password != "") {
$owner->password = Hash::make($password);
}
$owner->token = generate_token();
$owner->token_expiry = generate_expiry();
$owner->save();
$zero_in_code = 10 - strlen($owner->id);
$referral_code1 = Config::get('app.referral_prefix');
for ($i = 0; $i < $zero_in_code; $i++) {
$referral_code1 .= "0";
}
$referral_code1 .= $owner->id;
/* Referral entry */
$ledger = new Ledger();
$ledger->owner_id = $owner->id;
$ledger->referral_code = $referral_code1;
$ledger->save();
if ($referral_code != "") {
if ($ledger = Ledger::where('referral_code', $referral_code)->first()) {
$referred_by = $ledger->owner_id;
/* $settings = Settings::where('key', 'default_referral_bonus')->first();
$referral_bonus = $settings->value;
$ledger = Ledger::find($ledger->id);
$ledger->total_referrals = $ledger->total_referrals + 1;
$ledger->amount_earned = $ledger->amount_earned + $referral_bonus;
$ledger->save(); */
$settings = Settings::where('key', 'default_referral_bonus_to_refered_user')->first();
$refered_user = $settings->value;
$settings = Settings::where('key', 'default_referral_bonus_to_refereel')->first();
$referral = $settings->value;
$ledger = Ledger::find($ledger->id);
$ledger->total_referrals = $ledger->total_referrals + 1;
$ledger->amount_earned = $ledger->amount_earned + $refered_user;
$ledger->save();
$ledger1 = Ledger::where('owner_id', $owner->id)->first();
$ledger1 = Ledger::find($ledger1->id);
$ledger1->amount_earned = $ledger1->amount_earned + $referral;
$ledger1->save();
$owner->referred_by = $ledger->owner_id;
$response_array = array('success' => true);
$response_code = 200;
}
}
$owner->save();
// ENVIA EMAIL ESTOU COM DIFICULDADE AQUI
//$settings = Settings::where('key', 'admin_email_address')->first();
//$admin_email = $settings->value;
//$pattern = array('admin_eamil' => $admin_email, 'name' => ucwords($owner->first_name . " " . $owner->last_name), 'web_url' => web_url());
//$subject = "Welcome to " . ucwords(Config::get('app.website_title')) . ", " . ucwords($owner->first_name . " " . $owner->last_name) . "";
//email_notification($owner->id, 'owner', $pattern, $subject, 'user_register', null);
return Redirect::to('user/signin')->with('success', 'You have successfully registered. <br>Please Login');
} else {
return Redirect::to('user/signup')->with('error', 'This email ID is already registered.');
}
}
}
}
}
public function providerTripChangeState()
{
$date = date("Y-m-d H:i:s");
$time_limit = date("Y-m-d H:i:s", strtotime($date) - 3 * 60 * 60);
$walker_id = Session::get('walker_id');
$state = $request_id = Request::segment(4);
$current_request = Requests::where('confirmed_walker', $walker_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_dog_rated', 0);
});
})->first();
if ($current_request && $state) {
if ($state == 2) {
$current_request->is_walker_started = 1;
$owner = Owner::find($current_request->owner_id);
$walk_location = new WalkLocation();
$walk_location->request_id = $current_request->id;
$walk_location->latitude = $owner->latitude;
$walk_location->longitude = $owner->longitude;
$walk_location->distance = 0;
$walk_location->save();
}
if ($state == 3) {
$current_request->is_walker_arrived = 1;
}
if ($state == 4) {
$current_request->is_started = 1;
}
if ($state == 6) {
$current_request->is_dog_rated = 1;
$current_request->save();
$review_dog = new DogReview();
$review_dog->walker_id = $current_request->confirmed_walker;
$review_dog->comment = Input::get('review');
$review_dog->rating = Input::get('rating');
$review_dog->owner_id = $current_request->owner_id;
$review_dog->request_id = $current_request->id;
$review_dog->save();
$message = "You has successfully rated the owner.";
$type = "success";
return Redirect::to('/provider/trips')->with('message', $message)->with('type', $type);
}
if ($state == 5) {
$address = urlencode(Input::get('address'));
$end_address = json_decode(file_get_contents("https://maps.googleapis.com/maps/api/geocode/json?address={$address}"), TRUE);
$end_location = $end_address['results'][0]['geometry'];
$latitude = $end_location['location']['lat'];
$longitude = $end_location['location']['lng'];
$request_id = $current_request->id;
$walk_location_last = WalkLocation::where('request_id', $request_id)->orderBy('created_at', 'desc')->first();
if ($walk_location_last) {
$distance_old = $walk_location_last->distance;
$distance_new = distanceGeoPoints($walk_location_last->latitude, $walk_location_last->longitude, $latitude, $longitude);
$distance = $distance_old + $distance_new;
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
$distance = $distance;
} else {
$distance = 0;
}
$walk_location = new WalkLocation();
$walk_location->request_id = $request_id;
$walk_location->latitude = $latitude;
$walk_location->longitude = $longitude;
$walk_location->distance = $distance;
$walk_location->save();
Walker::where('id', '=', $walker_id)->update(array('is_available' => 1));
// Calculate Rerquest Stats
$time = 0;
$time_query = "SELECT TIMESTAMPDIFF(SECOND,MIN(created_at),MAX(created_at)) as diff\n\t\t\t\tFROM walk_location where request_id = {$current_request->id}\n\t\t\t\tGROUP BY request_id limit 1 ";
$time_data = DB::select(DB::raw($time_query));
foreach ($time_data as $time_diff) {
$time = $time_diff->diff;
}
$time = $time / 60;
$walker_data = Walker::find($current_request->confirmed_walker);
if (!$walker_data->type) {
$settings = Settings::where('key', 'price_per_unit_distance')->first();
$price_per_unit_distance = $settings->value;
$settings = Settings::where('key', 'price_per_unit_time')->first();
$price_per_unit_time = $settings->value;
$settings = Settings::where('key', 'base_price')->first();
$base_price = $settings->value;
} else {
$provider_type = ProviderType::find($walker_data->type);
$base_price = $provider_type->base_price;
$price_per_unit_distance = $provider_type->price_per_unit_distance;
$price_per_unit_time = $provider_type->price_per_unit_time;
}
$settings = Settings::where('key', 'default_charging_method_for_users')->first();
$pricing_type = $settings->value;
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
$distance = convert($distance, $unit);
if ($pricing_type == 1) {
$distance_cost = $price_per_unit_distance * $distance;
$time_cost = $price_per_unit_time * $time;
$total = $base_price + $distance_cost + $time_cost;
} else {
$distance_cost = 0;
$time_cost = 0;
$total = $base_price;
}
$current_request->is_completed = 1;
$current_request->distance = $distance;
$current_request->time = $time;
$current_request->base_price = $base_price;
$current_request->distance_cost = $distance_cost;
$current_request->time_cost = $time_cost;
$current_request->total = $total;
// charge client
// charge client
$ledger = Ledger::where('owner_id', $current_request->owner_id)->first();
if ($ledger) {
$balance = $ledger->amount_earned - $ledger->amount_spent;
if ($balance > 0) {
if ($total > $balance) {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $balance;
$ledger_temp->save();
$total = $total - $balance;
} else {
$ledger_temp = Ledger::find($ledger->id);
$ledger_temp->amount_spent = $ledger_temp->amount_spent + $total;
$ledger_temp->save();
$total = 0;
}
}
}
if ($total == 0) {
$current_request->is_paid = 1;
} else {
/*
$payment_data = Payment::where('owner_id',$current_request->owner_id)->first();
if( $payment_data )
{
$customer_id = $payment_data->customer_id;
try{
if(Config::get('app.default_payment') == 'stripe')
{
Stripe::setApiKey(Config::get('app.stripe_secret_key'));
Stripe_Charge::create(array(
"amount" => $total * 100,
"currency" => "usd",
"customer" => $customer_id)
);
$request->is_paid = 1;
}
else{
Braintree_Configuration::environment(Config::get('app.braintree_environment'));
Braintree_Configuration::merchantId(Config::get('app.braintree_merchant_id'));
Braintree_Configuration::publicKey(Config::get('app.braintree_public_key'));
Braintree_Configuration::privateKey(Config::get('app.braintree_private_key'));
$result = Braintree_Transaction::sale(array(
'amount' => round($total,2),
'paymentMethodNonce' => $customer_id
));
if ($result->success) {
$request->is_paid = 1;
}
else{
$request->is_paid = 0;
}
}
}
catch(Exception $e) {
$response_array = array('success' => false , 'error' => $e , 'error_code' => 405);
$response_code = 200;
$response = Response::json($response_array, $response_code);
return $response;
}
}
*/
}
$current_request->card_payment = $total;
$current_request->ledger_payment = $current_request->total - $total;
$current_request->save();
}
$current_request->save();
}
return Redirect::to('/provider/tripinprogress');
}
