public function create_manual_request() { $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'); $user_id = Session::get('user_id'); $time = date("Y-m-d H:i:s"); $provider_details = Walker::where('id', '=', $provider)->first(); $user = Owner::where('id', '=', $user_id)->first(); $request = new Requests(); $request->owner_id = $user_id; $request->request_start_time = $time; $request->confirmed_walker = $provider; if ($d_longitude != '' && $d_latitude != '') { $request->D_latitude = $d_latitude; $request->D_longitude = $d_longitude; } $request->current_walker = $provider; $request->status = 1; $request->save(); $reqid = $request->id; $request_service = new RequestServices(); $request_service->type = $type; $request_service->request_id = $request->id; $request_service->save(); $owner = Owner::find($user_id); $owner->latitude = $latitude; $owner->longitude = $longitude; $owner->save(); $walkerlocation = new WalkLocation(); $walkerlocation->request_id = $request->id; $walkerlocation->distance = 0.0; $walkerlocation->latitude = $latitude; $walkerlocation->longitude = $longitude; $walkerlocation->save(); if ($request->save()) { $current_request = Requests::where('id', '=', $reqid)->first(); return Redirect::to('/user/request-trip'); } }
public function get_providers() { $token = Input::get('token'); $owner_id = Input::get('id'); $latitude = Input::get('latitude'); $longitude = Input::get('longitude'); $type = Input::get('type'); $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'latitude' => $latitude, 'longitude' => $longitude), array('token' => 'required', 'owner_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required')); if ($validator->fails()) { $error_messages = $validator->messages()->all(); $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages); $response_code = 200; } else { $is_admin = $this->isAdmin($token); if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) { // check for token validity if (is_token_active($owner_data->token_expiry) || $is_admin) { // Do necessary operations if (!$type) { // choose default type $provider_type = ProviderType::where('is_default', 1)->first(); if (!$provider_type) { $type = 1; } else { $type = $provider_type->id; } } foreach ($type as $key) { $typ[] = $key; } $ty = implode(",", $typ); $typequery = "SELECT distinct provider_id from walker_services where type IN({$ty})"; $typewalkers = DB::select(DB::raw($typequery)); Log::info('typewalkers = ' . print_r($typewalkers, true)); foreach ($typewalkers as $key) { $types[] = $key->provider_id; } $typestring = implode(",", $types); Log::info('typestring = ' . print_r($typestring, true)); if ($typestring == '') { $response_array = array('success' => false, 'error' => 'No provider found matching the service type.', 'error_code' => 405); $response_code = 200; return Response::json($response_array, $response_code); } $settings = Settings::where('key', 'default_search_radius')->first(); $distance = $settings->value; $query = "SELECT walker.id, 1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and (1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) <= {$distance} and walker.id IN({$typestring}) order by distance"; $walkers = DB::select(DB::raw($query)); Log::info('walkers = ' . print_r($walkers, true)); if ($walkers != NULL) { $owner = Owner::find($owner_id); $owner->latitude = $latitude; $owner->longitude = $longitude; $owner->save(); $request = new Requests(); $request->owner_id = $owner_id; $request->request_start_time = date("Y-m-d H:i:s"); $request->save(); foreach ($type as $key) { $reqserv = new RequestServices(); $reqserv->request_id = $request->id; $reqserv->type = $key; $reqserv->save(); } $response_array = array('success' => true, 'request_id' => $request->id, 'walkers' => $walkers); $response_code = 200; } else { $response_array = array('success' => false, 'error' => 'No walker found'); $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405); $response_code = 200; } } else { if ($is_admin) { $response_array = array('success' => false, 'error' => 'Owner ID not Found', 'error_code' => 410); } else { $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406); } $response_code = 200; } } $response = Response::json($response_array, $response_code); return $response; }
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 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 create_request_later() { $token = Input::get('token'); $owner_id = Input::get('id'); $latitude = Input::get('latitude'); $longitude = Input::get('longitude'); $date_time = Input::get('datetime'); // dd(date('Y-m-d h:i:s', strtotime("$date_time + 2 hours"))); $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'latitude' => $latitude, 'longitude' => $longitude, 'datetime' => $date_time), array('token' => 'required', 'owner_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required', 'datetime' => 'required')); if ($validator->fails()) { $error_messages = $validator->messages()->all(); $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages); $response_code = 200; } else { $is_admin = $this->isAdmin($token); if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) { // check for token validity if (is_token_active($owner_data->token_expiry) || $is_admin) { // Do necessary operations if ($owner_data->debt > 0) { $response_array = array('success' => false, 'error' => "You are already in \${$owner->debt} debt", 'error_code' => 417); $response_code = 200; $response = Response::json($response_array, $response_code); return $response; } if (Input::has('type')) { $type = Input::get('type'); if (!$type) { // choose default type $provider_type = ProviderType::where('is_default', 1)->first(); if (!$provider_type) { $type = 1; } else { $type = $provider_type->id; } } $typequery = "SELECT distinct provider_id from walker_services where type IN({$type})"; $typewalkers = DB::select(DB::raw($typequery)); Log::info('typewalkers = ' . print_r($typewalkers, true)); foreach ($typewalkers as $key) { $types[] = $key->provider_id; } $typestring = implode(",", $types); Log::info('typestring = ' . print_r($typestring, true)); if ($typestring == '') { /* $driver = Keywords::where('id', 1)->first(); $response_array = array('success' => false, 'error' => 'No ' . $driver->keyword . ' found matching the service type.', 'error_code' => 405); */ $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found matching the service type.', 'error_code' => 405); $response_code = 200; return Response::json($response_array, $response_code); } $settings = Settings::where('key', 'default_search_radius')->first(); $distance = $settings->value; $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $multiply = 1.609344; } elseif ($unit == 1) { $multiply = 1; } $query1 = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.id IN({$typestring});"; $ssstrings = DB::select(DB::raw($query1)); foreach ($ssstrings as $ssstrin) { $ssstri[] = $ssstrin->id; } $ssstring = implode(",", $ssstri); $datewant = new DateTime($date_time); $datetime = $datewant->format('Y-m-d H:i:s'); $dategiven = $datewant->sub(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s'); $end_time = $datewant->add(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s'); /* $setting = Settings::where('key', 'allow_calendar')->first(); if ($setting->value == 1) $pvquery = "SELECT distinct provider_id from provider_availability where start <= '" . $datetime . "' and end >= '" . $datetime . "' and provider_id IN($ssstring) and provider_id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');"; else */ $pvquery = "SELECT id from walker where id IN({$ssstring}) and id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');"; $pvques = DB::select(DB::raw($pvquery)); // dd($pvques); $ssstr = array(); foreach ($pvques as $ssstn) { $ssstr[] = $ssstn->provider_id; } $pvque = implode(",", $ssstr); $walkers = array(); if ($pvque) { $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $multiply = 1.609344; } elseif ($unit == 1) { $multiply = 1; } $query = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.id IN({$typestring}) and id IN({$pvque}) order by distance;"; $walkers = DB::select(DB::raw($query)); } $walker_list = array(); $owner = Owner::find($owner_id); $owner->latitude = $latitude; $owner->longitude = $longitude; $owner->save(); $request = new Requests(); $request->owner_id = $owner_id; $request->request_start_time = $datetime; $request->later = 1; if (Input::has('cod')) { if (Input::get('cod') == 1) { $request->cod = 1; } else { $request->cod = 0; } } $request->save(); $reqserv = new RequestServices(); $reqserv->request_id = $request->id; $reqserv->type = $type; $reqserv->save(); } else { $settings = Settings::where('key', 'default_search_radius')->first(); $distance = $settings->value; $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $multiply = 1.609344; } elseif ($unit == 1) { $multiply = 1; } $query1 = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance};"; $ssstrings = DB::select(DB::raw($query1)); foreach ($ssstrings as $ssstrin) { $ssstri[] = $ssstrin->id; } $ssstring = implode(",", $ssstri); $datewant = new DateTime($date_time); $datetime = $datewant->format('Y-m-d H:i:s'); $dategiven = $datewant->sub(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s'); $end_time = $datewant->add(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s'); /* $setting = Settings::where('key', 'allow_calendar')->first(); if ($setting->value == 1) $pvquery = "SELECT distinct provider_id from provider_availability where start <= '" . $datetime . "' and end >= '" . $datetime . "' and provider_id IN($ssstring) and provider_id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');"; else */ $pvquery = "SELECT id from walker where id IN({$ssstring}) and id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');"; $pvques = DB::select(DB::raw($pvquery)); $ssstr = array(); foreach ($pvques as $ssstn) { $ssstr[] = $ssstn->provider_id; } $pvque = implode(",", $ssstr); $walkers = array(); if ($pvque) { $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $multiply = 1.609344; } elseif ($unit == 1) { $multiply = 1; } $query = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and id IN({$pvque}) order by distance;"; $walkers = DB::select(DB::raw($query)); } $walker_list = array(); $owner = Owner::find($owner_id); $owner->latitude = $latitude; $owner->longitude = $longitude; $owner->save(); $request = new Requests(); $request->owner_id = $owner_id; $request->request_start_time = $datetime; $request->save(); $reqserv = new RequestServices(); $reqserv->request_id = $request->id; $reqserv->save(); } $i = 0; $first_walker_id = 0; if ($walkers) { foreach ($walkers as $walker) { $request_meta = new RequestMeta(); $request_meta->request_id = $request->id; $request_meta->walker_id = $walker->id; if ($i == 0) { $first_walker_id = $walker->id; $i++; } $request_meta->save(); } $req = Requests::find($request->id); $req->current_walker = $first_walker_id; $req->save(); } $settings = Settings::where('key', 'provider_timeout')->first(); $time_left = $settings->value; // Send Notification $walker = Walker::find($first_walker_id); if ($walker) { $msg_array = array(); $msg_array['unique_id'] = 3; $msg_array['request_id'] = $request->id; $msg_array['time_left_to_respond'] = $time_left; $owner = Owner::find($owner_id); $request_data = array(); $request_data['owner'] = array(); $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name; $request_data['owner']['picture'] = $owner->picture; $request_data['owner']['phone'] = $owner->phone; $request_data['owner']['address'] = $owner->address; $request_data['owner']['latitude'] = $owner->latitude; $request_data['owner']['longitude'] = $owner->longitude; $request_data['owner']['rating'] = $owner->rate; $request_data['owner']['num_rating'] = $owner->rate_count; /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0; $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */ $date_want = new DateTime($date_time); $datetime1 = $date_want->format('Y-m-d H:i:s'); $request_data['datetime'] = $datetime1; $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } $msg_array['request_data'] = $request_data; $title = "New Request"; $message = $msg_array; Log::info('first_walker_id = ' . print_r($first_walker_id, true)); Log::info('New request = ' . print_r($message, true)); /* don't do json_encode in above line because if */ send_notifications($first_walker_id, "walker", $title, $message); } // Send SMS $settings = Settings::where('key', 'sms_request_created')->first(); $pattern = $settings->value; $pattern = str_replace('%user%', $owner_data->first_name . " " . $owner_data->last_name, $pattern); $pattern = str_replace('%id%', $request->id, $pattern); $pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern); sms_notification(1, 'admin', $pattern); // send email /* $settings = Settings::where('key', 'email_new_request')->first(); $pattern = $settings->value; $pattern = str_replace('%id%', $request->id, $pattern); $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern); $subject = "New Request Created"; email_notification(1, 'admin', $pattern, $subject); */ $settings = Settings::where('key', 'admin_email_address')->first(); $admin_email = $settings->value; $follow_url = web_url() . "/user/signin"; $pattern = array('admin_eamil' => $admin_email, 'trip_id' => $request->id, 'follow_url' => $follow_url); $subject = "Ride Booking Request"; email_notification(1, 'admin', $pattern, $subject, 'new_request', null); $response_array = array('success' => true, 'request_id' => $request->id); $response_code = 200; } else { $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405); $response_code = 200; } } else { if ($is_admin) { /* $var = Keywords::where('id', 2)->first(); $response_array = array('success' => false, 'error' => '' . $var->keyword . ' ID not Found', 'error_code' => 410); */ $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.User') . ' ID not Found', 'error_code' => 410); } else { $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406); } $response_code = 200; } } $response = Response::json($response_array, $response_code); return $response; }
public function userTripDetail() { $id = Request::segment(3); $owner_id = Session::get('user_id'); $request = Requests::find($id); $request_service = RequestServices::find($id); if ($request->owner_id == $owner_id) { $locations = WalkLocation::where('request_id', $id)->orderBy('id')->get(); $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&style=feature:landscape|visibility:off&style=feature:poi|visibility:off&style=feature:transit|visibility:off&style=feature:road.highway|element:geometry|lightness:39&style=feature:road.local|element:geometry|gamma:1.45&style=feature:road|element:labels|gamma:1.22&style=feature:administrative|visibility:off&style=feature:administrative.locality|visibility:on&style=feature:landscape.natural|visibility:on&scale=2&markers=shadow:false|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}"; } $start_location = json_decode(file_get_contents("https://maps.googleapis.com/maps/api/geocode/json?latlng={$start->latitude},{$start->longitude}"), TRUE); $start_address = $start_location['results'][0]['formatted_address']; $end_location = json_decode(file_get_contents("https://maps.googleapis.com/maps/api/geocode/json?latlng={$end->latitude},{$end->longitude}"), TRUE); $end_address = $end_location['results'][0]['formatted_address']; $walker = Walker::find($request->confirmed_walker); $walker_review = WalkerReview::where('request_id', $id)->first(); if ($walker_review) { $rating = round($walker_review->rating); } else { $rating = 0; } /* $var = Keywords::where('id', 4)->first(); $currency = Keywords::where('id', 5)->first(); */ return View::make('web.userTripDetail')->with('title', 'My ' . Config::get('app.generic_keywords.Trip') . 's')->with('request', $request)->with('request_service', $request_service)->with('start_address', $start_address)->with('end_address', $end_address)->with('currency', Config::get('app.generic_keywords.Currency'))->with('start', $start)->with('end', $end)->with('map_url', $map)->with('walker', $walker)->with('rating', $rating); } else { echo "false"; } }