public function providerRequestPing() { $walker_id = Session::get('walker_id'); $time = date("Y-m-d H:i:s"); $query = "SELECT id,owner_id,TIMESTAMPDIFF(SECOND,request_start_time, '{$time}') as diff from request where is_cancelled = 0 and status = 0 and current_walker={$walker_id} and TIMESTAMPDIFF(SECOND,request_start_time, '{$time}') <= 600 limit 1"; $requests = DB::select(DB::raw($query)); $request_data = array(); foreach ($requests as $request) { $request_data['success'] = "true"; $request_data['request_id'] = $request->id; $request_data['time_left_to_respond'] = 600 - $request->diff; $owner = Owner::find($request->owner_id); $request_data['owner'] = array(); $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name; $request_data['owner']['picture'] = $owner->picture; $request_data['owner']['phone'] = $owner->phone; $request_data['owner']['address'] = $owner->address; $request_data['owner']['latitude'] = $owner->latitude; $request_data['owner']['longitude'] = $owner->longitude; $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ?: 0; $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } } $response_code = 200; $response = Response::json($request_data, $response_code); return $response; }
public function userTripCancel() { $request_id = Request::segment(4); $owner_id = Session::get('user_id'); $request = Requests::find($request_id); if ($request->owner_id == $owner_id) { Requests::where('id', $request_id)->update(array('is_cancelled' => 1)); RequestMeta::where('request_id', $request_id)->update(array('is_cancelled' => 1)); if ($request->confirmed_walker) { $walker = Walker::find($request->confirmed_walker); $walker->is_available = 1; $walker->save(); } if ($request->current_walker) { $msg_array = array(); $msg_array['request_id'] = $request_id; $msg_array['unique_id'] = 2; $owner = Owner::find($owner_id); $request_data = array(); $request_data['owner'] = array(); $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name; $request_data['owner']['picture'] = $owner->picture; $request_data['owner']['phone'] = $owner->phone; $request_data['owner']['address'] = $owner->address; $request_data['owner']['latitude'] = $owner->latitude; $request_data['owner']['longitude'] = $owner->longitude; $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ?: 0; $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } $msg_array['request_data'] = $request_data; $title = "Request Cancelled"; $message = $msg_array; send_notifications($request->current_walker, "walker", $title, $message); } } // Redirect $message = "Your Request is Cancelled."; $type = "success"; return Redirect::to('/user/trips')->with('message', $message)->with('type', $type); }
public function cancel_request() { $request_id = Input::get('request_id'); $token = Input::get('token'); $owner_id = Input::get('id'); $validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'owner_id' => $owner_id), array('request_id' => 'required|integer', 'token' => 'required', 'owner_id' => 'required|integer')); 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 ($request = Requests::find($request_id)) { if ($request->owner_id == $owner_data->id) { Requests::where('id', $request_id)->update(array('is_cancelled' => 1)); RequestMeta::where('request_id', $request_id)->update(array('is_cancelled' => 1)); if ($request->confirmed_walker) { $walker = Walker::find($request->confirmed_walker); $walker->is_available = 1; $walker->save(); } if ($request->current_walker) { $msg_array = array(); $msg_array['request_id'] = $request_id; $msg_array['unique_id'] = 2; $owner = Owner::find($owner_id); $request_data = array(); $request_data['owner'] = array(); $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name; $request_data['owner']['picture'] = $owner->picture; $request_data['owner']['phone'] = $owner->phone; $request_data['owner']['address'] = $owner->address; $request_data['owner']['latitude'] = $owner->latitude; $request_data['owner']['longitude'] = $owner->longitude; $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ?: 0; $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } $msg_array['request_data'] = $request_data; $title = "Request Cancelled"; $message = $msg_array; send_notifications($request->current_walker, "walker", $title, $message); } $response_array = array('success' => true); $response_code = 200; } else { $response_array = array('success' => false, 'error' => 'Request ID doesnot matches with Owner ID', 'error_code' => 407); $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Request ID Not Found', 'error_code' => 408); $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405); $response_code = 200; } } else { if ($is_admin) { $response_array = array('success' => false, 'error' => '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 alternative_walkers_xml() { $id = Request::segment(4); $walk = Walk::find($id); $schedule = Schedules::find($walk->schedule_id); $dog = Dog::find($walk->dog_id); $owner = Owner::find($dog->owner_id); $current_walker = Walker::find($walk->walker_id); $latitude = $owner->latitude; $longitude = $owner->longitude; $distance = 5; // Get Latitude $schedule_meta = ScheduleMeta::where('schedule_id', '=', $schedule->id)->orderBy('started_on', 'DESC')->get(); $flag = 0; $date = "0000-00-00"; $days = array(); foreach ($schedule_meta as $meta) { if ($flag == 0) { $date = $meta->started_on; $flag++; } array_push($days, $meta->day); } $start_time = date('H:i:s', strtotime($schedule->start_time) - 60 * 60); $end_time = date('H:i:s', strtotime($schedule->end_time) + 60 * 60); $days_str = implode(',', $days); $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,walker.bio,walker.first_name,walker.last_name,walker.phone,walker.latitude,walker.longitude from walker where id NOT IN ( SELECT distinct schedules.walker_id FROM `schedule_meta` left join schedules on schedule_meta.schedule_id = schedules.id where schedules.is_confirmed\t != 0 and schedule_meta.day IN ({$days_str}) and schedule_meta.ends_on >= '{$date}' and schedule_meta.started_on <= '{$date}' and ((schedules.start_time > '{$start_time}' and schedules.start_time < '{$end_time}') OR ( schedules.end_time > '{$start_time}' and schedules.end_time < '{$end_time}' )) ) and " . "ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * " . "cos( radians(latitude) ) * " . "cos( radians(longitude) - radians('{$longitude}') ) + " . "sin( radians('{$latitude}') ) * " . "sin( radians(latitude) ) ) ) ,8) <= {$distance} "; $walkers = DB::select(DB::raw($query)); $response = ""; $response .= '<markers>'; foreach ($walkers as $walker) { $response .= '<marker '; $response .= 'name="' . $walker->first_name . " " . $walker->last_name . '" '; $response .= 'client_name="' . $walker->first_name . " " . $walker->last_name . '" '; $response .= 'contact="' . $walker->phone . '" '; $response .= 'amount="' . 0 . '" '; $response .= 'lat="' . $walker->latitude . '" '; $response .= 'lng="' . $walker->longitude . '" '; $response .= 'id="' . $walker->id . '" '; $response .= 'type="client" '; $response .= '/>'; } // Add Current walker if ($current_walker) { $response .= '<marker '; $response .= 'name="' . $current_walker->first_name . " " . $current_walker->last_name . '" '; $response .= 'client_name="' . $current_walker->first_name . " " . $current_walker->last_name . '" '; $response .= 'contact="' . $current_walker->phone . '" '; $response .= 'amount="' . 0 . '" '; $response .= 'lat="' . $current_walker->latitude . '" '; $response .= 'lng="' . $current_walker->longitude . '" '; $response .= 'id="' . $current_walker->id . '" '; $response .= 'type="driver" '; $response .= '/>'; } // Add Owner $response .= '<marker '; $response .= 'name="' . $owner->first_name . " " . $owner->last_name . '" '; $response .= 'client_name="' . $owner->first_name . " " . $owner->last_name . '" '; $response .= 'contact="' . $owner->phone . '" '; $response .= 'amount="' . 0 . '" '; $response .= 'lat="' . $owner->latitude . '" '; $response .= 'lng="' . $owner->longitude . '" '; $response .= 'id="' . $owner->id . '" '; $response .= 'type="client_pay_done" '; $response .= '/>'; // Add Busy Walkers $walkers = DB::table('request')->where('walk.is_started', 1)->where('walk.is_completed', 0)->join('walker', 'walk.walker_id', '=', 'walker.id')->select('walker.id', 'walker.phone', 'walker.first_name', 'walker.last_name', 'walker.latitude', 'walker.longitude')->distinct()->get(); foreach ($walkers as $walker) { $response .= '<marker '; $response .= 'name="' . $walker->first_name . " " . $walker->last_name . '" '; $response .= 'client_name="' . $walker->first_name . " " . $walker->last_name . '" '; $response .= 'contact="' . $walker->phone . '" '; $response .= 'amount="' . 0 . '" '; $response .= 'lat="' . $walker->latitude . '" '; $response .= 'lng="' . $walker->longitude . '" '; $response .= 'id="' . $owner->id . '" '; $response .= 'type="client_no_pay" '; $response .= '/>'; } $response .= '</markers>'; $content = View::make('walkers_xml')->with('response', $response); return Response::make($content, '200')->header('Content-Type', 'text/xml'); }
public function login() { $login_by = Input::get('login_by'); $device_token = Input::get('device_token'); $device_type = Input::get('device_type'); if (Input::has('email') && Input::has('password')) { $email = Input::get('email'); $password = Input::get('password'); $validator = Validator::make(array('password' => $password, 'email' => $email, 'device_token' => $device_token, 'device_type' => $device_type, 'login_by' => $login_by), array('password' => 'required', 'email' => 'required|email', 'device_token' => 'required', 'device_type' => 'required|in:android,ios', 'login_by' => 'required|in:manual,facebook,google')); 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; Log::error('Validation error during manual login for owner = ' . print_r($error_messages, true)); } else { if ($owner = Owner::where('email', '=', $email)->first()) { if (Hash::check($password, $owner->password)) { if ($login_by !== "manual") { $response_array = array('success' => false, 'error' => 'Login by mismatch', 'error_code' => 417); $response_code = 200; } else { if ($owner->device_type != $device_type) { $owner->device_type = $device_type; } if ($owner->device_token != $device_token) { $owner->device_token = $device_token; } $owner->token = generate_token(); $owner->token_expiry = generate_expiry(); $owner->save(); /* SEND REFERRAL & PROMO INFO */ $settings = Settings::where('key', 'referral_code_activation')->first(); $referral_code_activation = $settings->value; if ($referral_code_activation) { $referral_code_activation_txt = "referral on"; } else { $referral_code_activation_txt = "referral off"; } $settings = Settings::where('key', 'promotional_code_activation')->first(); $promotional_code_activation = $settings->value; if ($promotional_code_activation) { $promotional_code_activation_txt = "promo on"; } else { $promotional_code_activation_txt = "promo off"; } /* SEND REFERRAL & PROMO INFO */ $code_data = Ledger::where('owner_id', '=', $owner->id)->first(); $response_array = array('success' => true, '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, 'timezone' => $owner->timezone, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count, 'is_referral_active' => $referral_code_activation, 'is_referral_active_txt' => $referral_code_activation_txt, 'is_promo_active' => $promotional_code_activation, 'is_promo_active_txt' => $promotional_code_activation_txt); $dog = Dog::find($owner->dog_id); if ($dog !== NULL) { $response_array = array_merge($response_array, array('dog_id' => $dog->id, 'age' => $dog->age, 'name' => $dog->name, 'breed' => $dog->breed, 'likes' => $dog->likes, 'image_url' => $dog->image_url)); } $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Invalid Username and Password', 'error_code' => 403); $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Not a Registered User', 'error_code' => 404); $response_code = 200; } } } elseif (Input::has('social_unique_id')) { $social_unique_id = Input::get('social_unique_id'); $socialValidator = Validator::make(array('social_unique_id' => $social_unique_id, 'device_token' => $device_token, 'device_type' => $device_type, 'login_by' => $login_by), array('social_unique_id' => 'required|exists:owner,social_unique_id', 'device_token' => 'required', 'device_type' => 'required|in:android,ios', 'login_by' => 'required|in:manual,facebook,google')); if ($socialValidator->fails()) { $error_messages = $socialValidator->messages(); Log::error('Validation error during social login for owner = ' . print_r($error_messages, true)); $error_messages = $socialValidator->messages()->all(); $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages); $response_code = 200; } else { if ($owner = Owner::where('social_unique_id', '=', $social_unique_id)->first()) { if (!in_array($login_by, array('facebook', 'google'))) { $response_array = array('success' => false, 'error' => 'Login by mismatch', 'error_code' => 417); $response_code = 200; } else { if ($owner->device_type != $device_type) { $owner->device_type = $device_type; } if ($owner->device_token != $device_token) { $owner->device_token = $device_token; } $owner->token_expiry = generate_expiry(); $owner->save(); $response_array = array('success' => true, '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, 'timezone' => $owner->timezone, 'token' => $owner->token, 'is_referee' => $owner->is_referee); $dog = Dog::find($owner->dog_id); if ($dog !== NULL) { $response_array = array_merge($response_array, array('dog_id' => $dog->id, 'age' => $dog->age, 'name' => $dog->name, 'breed' => $dog->breed, 'likes' => $dog->likes, 'image_url' => $dog->image_url)); } $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Not a valid social registration User', 'error_code' => 404); $response_code = 200; } } } else { $response_array = array('success' => false, 'error' => 'Invalid input', 'error_code' => 404); $response_code = 200; } $response = Response::json($response_array, $response_code); return $response; }
public function get_request() { $request_id = Input::get('request_id'); $token = Input::get('token'); $walker_id = Input::get('id'); $validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'walker_id' => $walker_id), array('request_id' => 'required|integer', 'token' => 'required', 'walker_id' => 'required|integer')); if ($validator->fails()) { $error_messages = $validator->messages()->all(); $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages); $response_code = 200; } else { $is_admin = $this->isAdmin($token); if ($walker_data = $this->getWalkerData($walker_id, $token, $is_admin)) { // check for token validity if (is_token_active($walker_data->token_expiry) || $is_admin) { // Do necessary operations if ($request = Requests::find($request_id)) { if ($request->confirmed_walker == $walker_id) { $owner = Owner::find($request->owner_id); $request_data = array(); $request_data['is_walker_started'] = $request->is_walker_started; $request_data['is_walker_arrived'] = $request->is_walker_arrived; $request_data['is_started'] = $request->is_started; $request_data['is_completed'] = $request->is_completed; $request_data['is_dog_rated'] = $request->is_dog_rated; $request_data['accepted_time'] = $request->request_start_time; if ($request->is_started == 1) { $request_data['start_time'] = DB::table('walk_location')->where('request_id', $request_id)->min('created_at'); $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; $distance = DB::table('walk_location')->where('request_id', $request_id)->max('distance'); $request_data['distance'] = convert($distance, $unit); } if ($request->is_completed == 1) { $request_data['distance'] = $distance; $request_data['end_time'] = DB::table('walk_location')->where('request_id', $request_id)->max('created_at'); } $request_data['owner'] = array(); $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name; $request_data['owner']['picture'] = $owner->picture; $request_data['owner']['phone'] = $owner->phone; $request_data['owner']['address'] = $owner->address; $request_data['owner']['latitude'] = $owner->latitude; $request_data['owner']['longitude'] = $owner->longitude; $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ?: 0; $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } $request_data['bill'] = array(); $bill = array(); $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; 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; } $request_data['bill'] = $bill; $response_array = array('success' => true, 'request' => $request_data); $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 request_walk_completed_old123() { 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'); if (Input::has('bearing')) { $angle = Input::get('bearing'); } Log::info('distance input = ' . print_r($distance, true)); Log::info('time input = ' . print_r($time, true)); $validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'walker_id' => $walker_id, 'latitude' => $latitude, 'longitude' => $longitude, 'distance' => $distance), array('request_id' => 'required|integer', 'token' => 'required', 'walker_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required', 'distance' => '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 { $cash_card_user = ""; $payment_type = ""; $walker_payment_remaining = 0; $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) { $providertype = ProviderType::where('id', $walker_data->type)->first(); // Do necessary operations if ($request = Requests::find($request_id)) { $time = $request->time; 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; Log::info('distance = ' . print_r($distance, true)); $reqserv = RequestServices::where('request_id', $request_id)->get(); $actual_total = 0; $price_per_unit_distance = 0; $price_per_unit_time = 0; $base_price = 0; foreach ($reqserv as $rse) { Log::info('type = ' . print_r($rse->type, true)); $protype = ProviderType::where('id', $rse->type)->first(); $pt = ProviderServices::where('provider_id', $walker_id)->where('type', $rse->type)->first(); if ($pt->base_price == 0) { /* $setbase_price = Settings::where('key', 'base_price')->first(); $base_price = $setbase_price->value; */ $base_price = $providertype->base_price; $rse->base_price = $base_price; } else { $base_price = $pt->base_price; $rse->base_price = $base_price; } $is_multiple_service = Settings::where('key', 'allow_multiple_service')->first(); if ($is_multiple_service->value == 0) { if ($pt->price_per_unit_distance == 0) { /* $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first(); $price_per_unit_distance = $setdistance_price->value * $distance; $rse->distance_cost = $price_per_unit_distance; */ if ($distance <= $providertype->base_distance) { $price_per_unit_distance = 0; } else { $price_per_unit_distance = $providertype->price_per_unit_distance * ($distance - $providertype->base_distance); } $rse->distance_cost = $price_per_unit_distance; } else { if ($distance <= $providertype->base_distance) { $price_per_unit_distance = 0; } else { $price_per_unit_distance = $pt->price_per_unit_distance * ($distance - $providertype->base_distance); } $rse->distance_cost = $price_per_unit_distance; } if ($pt->price_per_unit_time == 0) { /* $settime_price = Settings::where('key', 'price_per_unit_time')->first(); $price_per_unit_time = $settime_price->value * $time; */ $price_per_unit_time = $providertype->price_per_unit_time * $time; $rse->time_cost = $price_per_unit_time; } else { $price_per_unit_time = $pt->price_per_unit_time * $time; $rse->time_cost = $price_per_unit_time; } } Log::info('total price = ' . print_r($base_price + $price_per_unit_distance + $price_per_unit_time, true)); $rse->total = $base_price + $price_per_unit_distance + $price_per_unit_time; $rse->save(); $actual_total = $actual_total + $base_price + $price_per_unit_distance + $price_per_unit_time; Log::info('total_price = ' . print_r($actual_total, true)); } pay_fail: $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 = Requests::find($request_id); $request->is_completed = 1; $request->distance = $distance; $request->time = $time; $request->security_key = NULL; $request->total = $total; $owner_data = Owner::where('id', $request->owner_id)->first(); /* GET REFERRAL & PROMO INFO */ $prom_act = $prom_for_card = $prom_for_cash = $ref_act = $ref_for_card = $ref_for_cash = $ref_total = $promo_total = 0; $settings = Settings::where('key', 'promotional_code_activation')->first(); $prom_act = $settings->value; $settings = Settings::where('key', 'referral_code_activation')->first(); $ref_act = $settings->value; /* GET REFERRAL & PROMO INFO END */ $cash_card_user = $request->payment_mode; if ($request->payment_mode == 0) { $walker_payment_remaining = $total; if ($prom_act) { $settings = Settings::where('key', 'get_promotional_profit_on_card_payment')->first(); $prom_for_card = $settings->value; if ($prom_for_card) { if ($total > 0) { if ($pcode = PromoCodes::where('id', $request->promo_id)->first()) { if ($pcode->type == 1) { $promo_total = $total * ($pcode->value / 100); $total = $total - $promo_total; if ($total <= 0) { $total = 0; } } else { $promo_total = $pcode->value; $total = $total - $promo_total; if ($total <= 0) { $total = 0; } } } } } } if ($ref_act) { $settings = Settings::where('key', 'get_referral_profit_on_card_payment')->first(); $ref_for_card = $settings->value; if ($ref_for_card) { // charge client $ledger = Ledger::where('owner_id', $request->owner_id)->first(); if ($ledger) { $balance = $ledger->amount_earned - $ledger->amount_spent; Log::info('ledger balance = ' . print_r($balance, true)); if ($balance > 0) { if ($total > 0) { if ($total > $balance) { $ref_total = $balance; $ledger_temp = Ledger::find($ledger->id); $ledger_temp->amount_spent = $ledger_temp->amount_spent + $balance; $ledger_temp->save(); $total = $total - $balance; } else { $ref_total = $total; $ledger_temp = Ledger::find($ledger->id); $ledger_temp->amount_spent = $ledger_temp->amount_spent + $total; $ledger_temp->save(); $total = 0; } } } } } } } else { if ($request->payment_mode == 1) { $walker_payment_remaining = 0; if ($prom_act) { $settings = Settings::where('key', 'get_promotional_profit_on_cash_payment')->first(); $prom_for_cash = $settings->value; if ($prom_for_cash) { if ($total > 0) { if ($pcode = PromoCodes::where('id', $request->promo_id)->first()) { if ($pcode->type == 1) { $promo_total = $total * ($pcode->value / 100); $total = $total - $promo_total; if ($total <= 0) { $total = 0; } } else { $promo_total = $pcode->value; $total = $total - $promo_total; if ($total <= 0) { $total = 0; } } } } } } if ($ref_act) { $settings = Settings::where('key', 'get_referral_profit_on_cash_payment')->first(); $ref_for_cash = $settings->value; if ($ref_for_cash) { // charge client $ledger = Ledger::where('owner_id', $request->owner_id)->first(); if ($ledger) { $balance = $ledger->amount_earned - $ledger->amount_spent; Log::info('ledger balance = ' . print_r($balance, true)); if ($balance > 0) { if ($total > 0) { if ($total > $balance) { $ref_total = $balance; $ledger_temp = Ledger::find($ledger->id); $ledger_temp->amount_spent = $ledger_temp->amount_spent + $balance; $ledger_temp->save(); $total = $total - $balance; } else { $ref_total = $total; $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', $request->promo_code)->where('type', 1)->first()) { $discount = ($pcode->value) / 100; $promo_discount = $total * $discount; $total = $total - $promo_discount; if ($total < 0) { $total = 0; } } $request->total = $total; */ Log::info('final total = ' . print_r($total, true)); $cod_sett = Settings::where('key', 'cod')->first(); $allow_cod = $cod_sett->value; if ($request->payment_mode == 1 and $allow_cod == 1) { $request->is_paid = 1; $payment_type = 'Payment By cash'; Log::info('allow_cod'); } else { if ($request->payment_mode == 2) { // paypal $payment_type = 'Payment By paypal payment'; Log::info('paypal payment'); } else { Log::info('normal payment. Stored cards'); 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; $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" => floor($total) * 100, "currency" => "usd", "customer" => $customer_id)); if ($charge->paid) { $request->is_paid = 1; //$payment_type = "Creditcard Card Payment Successfully"; } else { $request->is_paid = 0; $payment_type = "Creditcard Card Payment Fail"; $ledger = Ledger::where('owner_id', $request->owner_id)->first(); if ($ledger) { $ledger_temp = Ledger::find($ledger->id); $ledger_temp->amount_spent = $ledger_temp->amount_spent + $ref_total; $ledger_temp->save(); } $change_to_cash = Requests::find($request_id); $change_to_cash->payment_mode = 1; $change_to_cash->save(); /* Client Side Push */ $title = 'Your card is declined, please pay cash to driver for your trip.'; $response_array = array('success' => true, 'message' => $title); $message = $response_array; send_notifications($request->owner_id, "owner", $title, $message); /* Client Side Push END */ /* Driver Side Push */ $title = 'Please collect cash from client for your trip.'; $response_array = array('success' => true, 'message' => $title); $message = $response_array; send_notifications($walker_id, "walker", $title, $message); /* Driver Side Push END */ goto pay_fail; } } catch (Stripe_InvalidRequestError $e) { $request->is_paid = 0; // 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; } $settng = Settings::where('key', 'service_fee')->first(); if ($transfer_allow == 1 && $walker_data->merchant_id != "" && Config::get('app.generic_keywords.Currency') == '$') { $transfer = Stripe_Transfer::create(array("amount" => floor($total - $settng->value * $total / 100) * 100, "currency" => "usd", "recipient" => $walker_data->merchant_id)); $request->transfer_amount = floor($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 ($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; $payment_type = "Creditcard Card Payment Successfully"; } else { $request->is_paid = 0; $payment_type = "Creditcard Card Payment Fail"; $ledger = Ledger::where('owner_id', $request->owner_id)->first(); if ($ledger) { $ledger_temp = Ledger::find($ledger->id); $ledger_temp->amount_spent = $ledger_temp->amount_spent + $ref_total; $ledger_temp->save(); } $change_to_cash = Requests::find($request_id); $change_to_cash->payment_mode = 1; $change_to_cash->save(); /* Client Side Push */ $title = 'Your card is declined, please pay cash to driver for your trip.'; $response_array = array('success' => true, 'message' => $title); $message = $response_array; send_notifications($request->owner_id, "owner", $title, $message); /* Client Side Push END */ /* Driver Side Push */ $title = 'Please collect cash from client for your trip.'; $response_array = array('success' => true, 'message' => $title); $message = $response_array; send_notifications($walker_id, "walker", $title, $message); /* Driver Side Push END */ goto pay_fail; } } 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->card_payment = $total; $request->ledger_payment = $ref_total; $request->promo_payment = $promo_total; //$request->payment_mode = $cash_card_user; $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; $location = get_location($latitude, $longitude); $latitude = $location['lat']; $longitude = $location['long']; if (!isset($angle)) { $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(); Log::info('distance walk location = ' . print_r($distance, true)); $walk_location = new WalkLocation(); $walk_location->latitude = $latitude; $walk_location->longitude = $longitude; $walk_location->request_id = $request_id; $walk_location->distance = $distance; $walk_location->bearing = $angle; $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'] = $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(); */ $requestserv = RequestServices::where('request_id', $request->id)->first(); $bill = array(); /* $currency_selected = Keywords::find(5); */ if ($request->is_completed == 1) { $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; // $bill['payment_mode'] = $request->payment_mode; // $bill['payment_mode'] = ""; $bill['distance'] = (string) $distance; if ($unit == 0) { $unit_set = 'kms'; } elseif ($unit == 1) { $unit_set = 'miles'; } $bill['unit'] = $unit_set; $bill['time'] = floatval(sprintf2($request->time, 2)); if ($requestserv->base_price != 0) { $bill['base_price'] = currency_converted($requestserv->base_price); $bill['distance_cost'] = currency_converted($requestserv->distance_cost); $bill['time_cost'] = currency_converted(floatval(sprintf2($requestserv->time_cost, 2))); } else { /* $setbase_price = Settings::where('key', 'base_price')->first(); $bill['base_price'] = currency_converted($setbase_price->value); */ $bill['base_price'] = currency_converted($providertype->base_price); /* $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first(); $bill['distance_cost'] = currency_converted($setdistance_price->value); */ $bill['distance_cost'] = currency_converted($providertype->price_per_unit_distance); /* $settime_price = Settings::where('key', 'price_per_unit_time')->first(); $bill['time_cost'] = currency_converted(floatval(sprintf2($settime_price->value, 2))); */ $bill['time_cost'] = currency_converted(floatval(sprintf2($providertype->price_per_unit_time, 2))); } $admins = Admin::first(); $bill['walker']['email'] = $walker->email; $bill['admin']['email'] = $admins->username; if ($request->transfer_amount != 0) { $bill['walker']['amount'] = currency_converted($request->total - $request->transfer_amount); $bill['admin']['amount'] = currency_converted($request->transfer_amount); } else { $bill['walker']['amount'] = currency_converted($request->transfer_amount); $bill['admin']['amount'] = currency_converted($request->total - $request->transfer_amount); } /* $bill['currency'] = $currency_selected->keyword; */ $bill['currency'] = Config::get('app.generic_keywords.Currency'); $bill['actual_total'] = currency_converted($actual_total); $bill['total'] = currency_converted($request->total); $bill['is_paid'] = $request->is_paid; $bill['promo_discount'] = currency_converted($promo_total); $bill['main_total'] = currency_converted($request->total); $bill['total'] = currency_converted($request->total - $request->ledger_payment - $request->promo_payment); $bill['referral_bonus'] = currency_converted($request->ledger_payment); $bill['promo_bonus'] = currency_converted($request->promo_payment); // $bill['payment_type'] = ""; // $bill['payment_type'] = $request->"payment_mode; $bill['is_paid'] = $request->is_paid; $chagre = array(); $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $unit_set = 'kms'; } elseif ($unit == 1) { $unit_set = 'miles'; } $chagre['unit'] = $unit_set; $requestserv = RequestServices::where('request_id', $request->id)->first(); if ($requestserv->base_price != 0) { $chagre['base_price'] = $requestserv->base_price; $chagre['distance_price'] = $requestserv->distance_cost; $chagre['price_per_unit_time'] = $requestserv->time_cost; } else { $setbase_price = Settings::where('key', 'base_price')->first(); $chagre['base_price'] = $setbase_price->value; $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first(); $chagre['distance_price'] = $setdistance_price->value; $settime_price = Settings::where('key', 'price_per_unit_time')->first(); $chagre['price_per_unit_time'] = $settime_price->value; } $chagre['total'] = $request->total; $chagre['is_paid'] = $request->is_paid; //$message = $response_array; } $rservc = RequestServices::where('request_id', $request->id)->get(); $typs = array(); $typi = array(); $typp = array(); foreach ($rservc as $typ) { $typ1 = ProviderType::where('id', $typ->type)->first(); $typ_price = ProviderServices::where('provider_id', $request->confirmed_walker)->where('type', $typ->type)->first(); if ($typ_price->base_price > 0) { $typp1 = 0.0; $typp1 = $typ_price->base_price; } elseif ($typ_price->price_per_unit_distance > 0) { $typp1 = 0.0; foreach ($rservc as $key) { $typp1 = $typp1 + $key->distance_cost; } } else { $typp1 = 0.0; } $typs['name'] = $typ1->name; // $typs['icon']=$typ1->icon; $typs['price'] = $typp1; array_push($typi, $typs); } $bill['type'] = $typi; $rserv = RequestServices::where('request_id', $request_id)->get(); $typs = array(); foreach ($rserv as $typ) { $typ1 = ProviderType::where('id', $typ->type)->first(); array_push($typs, $typ1->name); } $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, 'payment_mode' => "", 'bill' => $bill, 'payment_option' => "", 'is_paid' => $request->is_paid); $owner_data1 = array(); $owner_data1['name'] = $owner_data->first_name . " " . $owner_data->last_name; $owner_data1['picture'] = $owner_data->picture; $owner_data1['phone'] = $owner_data->phone; $owner_data1['address'] = $owner_data->address; $owner_data1['bio'] = $owner_data->bio; $owner_data1['latitude'] = $owner_data->latitude; $owner_data1['longitude'] = $owner_data->longitude; $owner_data1['owner_dist_lat'] = $request->D_latitude; $owner_data1['owner_dist_long'] = $request->D_longitude; $owner_data1['dest_latitude'] = $request->D_latitude; $owner_data1['dest_longitude'] = $request->D_longitude; //$owner_data1['payment_type'] = $request->payment_mode; // $owner_data1['payment_type'] = ""; $owner_data1['rating'] = $owner_data->rate; $owner_data1['num_rating'] = $owner_data->rate_count; $title = "Trip Completed"; $dog1 = array(); if ($dog = Dog::find($owner_data->dog_id)) { $dog1['name'] = $dog->name; $dog1['age'] = $dog->age; $dog1['breed'] = $dog->breed; $dog1['likes'] = $dog->likes; $dog1['picture'] = $dog->image_url; } $cards = ""; /* $cards['none'] = ""; */ $cardlist = Payment::where('owner_id', $owner_data->id)->where('is_default', 1)->first(); if (count($cardlist) >= 1) { $cards = array(); $default = $cardlist->is_default; if ($default == 1) { $cards['is_default_text'] = "default"; } else { $cards['is_default_text'] = "not_default"; } $cards['card_id'] = $cardlist->id; $cards['owner_id'] = $cardlist->owner_id; $cards['customer_id'] = $cardlist->customer_id; $cards['last_four'] = $cardlist->last_four; $cards['card_token'] = $cardlist->card_token; $cards['card_type'] = $cardlist->card_type; $cards['is_default'] = $default; } $chagre = array(); $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $unit_set = 'kms'; } elseif ($unit == 1) { $unit_set = 'miles'; } $chagre['unit'] = $unit_set; $requestserv = RequestServices::where('request_id', $request->id)->first(); if ($requestserv->base_price != 0) { $chagre['base_price'] = currency_converted($requestserv->base_price); $chagre['distance_price'] = currency_converted($requestserv->distance_cost); $chagre['price_per_unit_time'] = currency_converted($requestserv->time_cost); } else { /* $setbase_price = Settings::where('key', 'base_price')->first(); $chagre['base_price'] = currency_converted($setbase_price->value); */ $chagre['base_price'] = currency_converted($providertype->base_price); /* $setdistance_price = Settings::where('key', 'price_per_unit_distance')->first(); $chagre['distance_price'] = currency_converted($setdistance_price->value); */ $chagre['distance_price'] = currency_converted($providertype->price_per_unit_distance); /* $settime_price = Settings::where('key', 'price_per_unit_time')->first(); $chagre['price_per_unit_time'] = currency_converted($settime_price->value); */ $chagre['price_per_unit_time'] = currency_converted($providertype->price_per_unit_time); } $chagre['total'] = currency_converted($request->total); $chagre['is_paid'] = $request->is_paid; /* $var = Keywords::where('id', 4)->first(); */ $title = 'Your ' . Config::get('app.generic_keywords.Trip') . ' is 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('%amount%', $request->total, $pattern); sms_notification($request->owner_id, 'owner', $pattern); $id = $request->id; // 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(2, '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); $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']; // $email_data['payment_mode'] = $bill['payment_mode']; $email_data['actual_total'] = currency_converted($actual_total); $email_data['is_paid'] = $request->is_paid; $email_data['promo_discount'] = currency_converted($promo_total); $request_services = RequestServices::where('request_id', $request->id)->first(); $locations = WalkLocation::where('request_id', $request->id)->orderBy('id')->get(); $start = WalkLocation::where('request_id', $request->id)->orderBy('id')->first(); $end = WalkLocation::where('request_id', $request->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 = "Address not found"; if (isset($start_location['results'][0]['formatted_address'])) { $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 = "Address not found"; if (isset($end_location['results'][0]['formatted_address'])) { $end_address = $end_location['results'][0]['formatted_address']; } $email_data['start_location'] = $start_location; $email_data['end_location'] = $end_location; $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; } $email_data['map'] = $map; $settings = Settings::where('key', 'admin_email_address')->first(); $admin_email = $settings->value; $requestserv = RequestServices::where('request_id', $request->id)->orderBy('id', 'DESC')->first(); $get_type_name = ProviderType::where('id', $requestserv->type)->first(); $detail = array('admin_eamil' => $admin_email, 'request' => $request, 'start_address' => $start_address, 'end_address' => $end_address, 'start' => $start, 'end' => $end, 'map_url' => $map, 'walker' => $walker, 'rating', $rating, 'base_price' => $requestserv->base_price, 'price_per_time' => $price_per_unit_time, 'price_per_dist' => $price_per_unit_distance, 'ref_bonus' => $request->ledger_payment, 'promo_bonus' => "", 'dist_cost' => $requestserv->distance_cost, 'time_cost' => $requestserv->time_cost, 'type_name' => ucwords($get_type_name->name)); //send email to owner /* $subject = "Invoice Generated"; send_email($request->owner_id, 'owner', $email_data, $subject, 'invoice'); */ $subject = "Invoice Generated"; email_notification($request->owner_id, 'owner', $detail, $subject, 'invoice'); $subject = "Request Completed"; email_notification(1, 'admin', $detail, $subject, 'invoice'); //send email to walker /* $subject = "Invoice Generated"; $email_data['emailType'] = 'walker'; send_email($request->confirmed_walker, 'walker', $email_data, $subject, 'invoice'); */ $subject = "Invoice Generated"; email_notification($request->confirmed_walker, 'walker', $detail, $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/map/" . $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' => $request->total, 'req_id' => $request_id, 'web_url' => web_url()); $subject = "Payment Done With " . $request_id . ""; email_notification(1, 'admin', $pattern, $subject, 'pay_charged', null); } else { // send email /* $pattern = "Payment Failed for the request id " . $request->id . "."; $subject = "Payment Failed"; email_notification(1, 'admin', $pattern, $subject); */ } $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $unit_set = 'kms'; } elseif ($unit == 1) { $unit_set = 'miles'; } $distance = DB::table('walk_location')->where('request_id', $request_id)->max('distance'); $end_time = DB::table('walk_location')->where('request_id', $request_id)->max('created_at'); $request_data_1 = array('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_started' => $request->is_started, 'is_walk_started' => $request->is_started, 'is_completed' => $request->is_completed, 'is_dog_rated' => $request->is_dog_rated, 'is_cancelled' => $request->is_cancelled, 'is_walker_rated' => $request->is_walker_rated, 'dest_latitude' => $request->D_latitude, 'dest_longitude' => $request->D_longitude, 'accepted_time' => $request->request_start_time, 'distance' => (string) convert($distance, $unit), 'unit' => $unit_set, 'end_time' => $end_time, 'owner' => $owner_data1, 'dog' => $dog1, 'bill' => $bill, 'card_details' => $cards, 'charge_details' => $chagre, 'payment_option' => $request->is_paid); $response_array = array('success' => true, 'total' => currency_converted($total), 'error' => $payment_type, 'currency' => Config::get('app.generic_keywords.Currency'), 'is_paid' => $request->is_paid, '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, 'payment_mode' => "", 'bill' => $bill, 'owner' => $owner_data1, 'payment_option' => $request->is_paid, 'request' => $request_data_1); $response_code = 200; } else { $response_array = array('success' => false, 'error' => 'Service not yet started', 'error_code' => 413); $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; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $dog = Dog::find($id); if (!$dog) { Session::flash('errorMessage', "Something went wrong, no dog with id: {$id} found!"); App::abort(404); } Dog::find($id)->delete(); return Redirect::action('DogsController@index'); }
public function user_set_destination() { $request_id = Input::get('request_id'); $token = Input::get('token'); $owner_id = Input::get('id'); $dest_lat = Input::get('dest_lat'); $dest_long = Input::get('dest_long'); $validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'owner_id' => $owner_id, 'dest_lat' => $dest_lat, 'dest_long' => $dest_long), array('request_id' => 'required|integer', 'token' => 'required', 'owner_id' => 'required|integer', 'dest_lat' => 'required', 'dest_long' => 'required')); if ($validator->fails()) { $error_messages = $validator->messages()->all(); $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages); $response_code = 200; } else { $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 ($request = Requests::find($request_id)) { if ($request->owner_id == $owner_data->id) { Requests::where('id', $request_id)->update(array('D_latitude' => $dest_lat, 'D_longitude' => $dest_long)); if ($request->current_walker) { $msg_array = array(); $msg_array['request_id'] = $request_id; $msg_array['unique_id'] = 4; $last_destination = Requests::find($request_id); $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']['dest_latitude'] = $last_destination->D_latitude; $request_data['owner']['dest_longitude'] = $last_destination->D_longitude; $request_data['owner']['rating'] = $owner->rate; $request_data['owner']['num_rating'] = $owner->rate_count; $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } $msg_array['request_data'] = $request_data; $title = "Set Destination"; $message = $msg_array; if ($request->confirmed_walker == $request->current_walker) { send_notifications($request->confirmed_walker, "walker", $title, $message); } } $response_array = array('success' => true, 'error' => "Destination Set Successfully"); $response_code = 200; } else { $response_array = array('success' => false, 'error' => 'Request ID doesnot matches with Owner ID', 'error_code' => 407); $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Request ID Not Found', 'error_code' => 408); $response_code = 200; } } else { $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405); $response_code = 200; } } else { if ($is_admin) { $response_array = array('success' => false, 'error' => '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 saveUserRequestTrip() { Session::forget('skipReview'); $latitude = Input::get('latitude'); $longitude = Input::get('longitude'); $d_latitude = Input::get('d_latitude'); $d_longitude = Input::get('d_longitude'); $type = Input::get('type'); $owner_id = Session::get('user_id'); $payment_type = Input::get('payment_type'); if ($type == "") { $message = "Please Select the Service Type"; $type = "warning"; return Redirect::route('userrequestTrip')->with('message', $message)->with('type', $type); } else { if (Input::has('promo_code')) { $promo_code = Input::get('promo_code'); $code_check = PromoCodes::where('coupon_code', $promo_code)->first(); if ($code_check == NULL) { $message = "Invalid Promo Code"; $type = "error"; return Redirect::route('userrequestTrip')->with('message', $message)->with('type', $type); } else { if ($code_check->state == 1 && date('Y-m-d H:i:s', strtotime($code_check->expiry)) > date('Y-m-d H:i:s')) { $code_id = $code_check->id; } else { $message = "Invalid Promo Code"; $type = "error"; return Redirect::route('userrequestTrip')->with('message', $message)->with('type', $type); } } } else { $code_id = NULL; } $owner_data = Owner::find($owner_id); $settings = Settings::where('key', 'default_search_radius')->first(); $distance = $settings->value; if (Input::has('type')) { $type = Input::get('type'); if (!$type) { // choose default type $provider_type = ProviderType::where('is_default', 1)->first(); if (!$provider_type) { $type = 1; } else { $type = $provider_type->id; } } } $typequery = "SELECT distinct provider_id from walker_services where type IN({$type})"; $typewalkers = DB::select(DB::raw($typequery)); /* $var = Keywords::where('id', 1)->first(); */ if (empty($typewalkers)) { /* $message = "No " . $var->keyword . " found matching the service type."; */ $message = "No " . Config::get('app.generic_keywords.Provider') . " found matching the service type."; } else { Log::info('typewalkers = ' . print_r($typewalkers, true)); foreach ($typewalkers as $key) { $types[] = $key->provider_id; } $typestring = implode(",", $types); Log::info('typestring = ' . print_r($typestring, true)); if ($typestring == '') { /* $message = "No " . $var->keyword . " found matching the service type."; */ $message = "No " . Config::get('app.generic_keywords.Provider') . " found matching the service type."; } $settings = Settings::where('key', 'default_search_radius')->first(); $distance = $settings->value; $settings = Settings::where('key', 'default_distance_unit')->first(); $unit = $settings->value; if ($unit == 0) { $multiply = 1.609344; } elseif ($unit == 1) { $multiply = 1; } $query = "SELECT walker.*, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.deleted_at IS NULL and walker.id IN({$typestring}) order by distance"; $walkers = DB::select(DB::raw($query)); $walker_list = array(); $owner = Owner::find($owner_id); $owner->latitude = $latitude; $owner->longitude = $longitude; $owner->save(); $user_timezone = $owner->timezone; $default_timezone = Config::get('app.timezone'); $offset = $this->get_timezone_offset($default_timezone, $user_timezone); $request = new Requests(); $request->owner_id = $owner_id; if ($d_longitude != '' && $d_latitude != '') { $request->D_latitude = $d_latitude; $request->D_longitude = $d_longitude; } $request->request_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d H:i:s")) + $offset); $request->save(); $request_service = new RequestServices(); $request_service->type = $type; $request_service->request_id = $request->id; $request_service->save(); $i = 0; $first_walker_id = 0; foreach ($walkers as $walker) { $request_meta = new RequestMeta(); $request_meta->request_id = $request->id; $request_meta->walker_id = $walker->id; if ($i == 0) { $first_walker_id = $walker->id; $i++; } $request_meta->save(); } $req = Requests::find($request->id); $req->current_walker = $first_walker_id; $req->confirmed_walker = 0; $req->payment_mode = $payment_type; $req->promo_code = $code_id; $req->save(); $settings = Settings::where('key', 'provider_timeout')->first(); $time_left = $settings->value; /* $var = Keywords::where('id', 1)->first(); $message = "Your Request is successful. Please wait while we are finding a nearest " . $var->keyword . " for you."; */ $message = "Your Request is successful. Please wait while we are finding a nearest " . Config::get('app.generic_keywords.Provider') . " for you."; $type = "success"; } return Redirect::to('/user/request-trip')->with('message', $message)->with('type', $type); // Send Notification $walker = Walker::find($first_walker_id); if ($walker) { $msg_array = array(); $msg_array['unique_id'] = 1; $msg_array['request_id'] = $request->id; $msg_array['time_left_to_respond'] = $time_left; $owner = Owner::find($owner_id); $request_data = array(); $request_data['owner'] = array(); $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name; $request_data['owner']['picture'] = $owner->picture; $request_data['owner']['phone'] = $owner->phone; $request_data['owner']['address'] = $owner->address; $request_data['owner']['latitude'] = $owner->latitude; $request_data['owner']['longitude'] = $owner->longitude; /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0; */ $request_data['owner']['rating'] = $owner->rate; /* $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */ $request_data['owner']['num_rating'] = $owner->rate_count; $request_data['dog'] = array(); if ($dog = Dog::find($owner->dog_id)) { $request_data['dog']['name'] = $dog->name; $request_data['dog']['age'] = $dog->age; $request_data['dog']['breed'] = $dog->breed; $request_data['dog']['likes'] = $dog->likes; $request_data['dog']['picture'] = $dog->image_url; } $msg_array['request_data'] = $request_data; $title = "New Request"; $message = json_encode($msg_array); send_notifications($first_walker_id, "walker", $title, $message); } // Send SMS $settings = Settings::where('key', 'sms_request_created')->first(); $pattern = $settings->value; $pattern = str_replace('%user%', $owner_data->first_name . " " . $owner_data->last_name, $pattern); $pattern = str_replace('%id%', $request->id, $pattern); $pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern); sms_notification(1, 'admin', $pattern); // send email /* $settings = Settings::where('key', 'email_new_request')->first(); $pattern = $settings->value; $pattern = str_replace('%id%', $request->id, $pattern); $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern); $subject = "New Request Created"; email_notification(1, 'admin', $pattern, $subject); */ $settings = Settings::where('key', 'admin_email_address')->first(); $admin_email = $settings->value; $follow_url = web_url() . "/user/signin"; $pattern = array('admin_eamil' => $admin_email, 'trip_id' => $request->id, 'follow_url' => $follow_url); $subject = "Ride Booking Request"; email_notification(1, 'admin', $pattern, $subject, 'new_request', null); return Redirect::to('/user/request-trip')->with('message', $message)->with('type', $type); } }