public function apply_promo_code()
 {
     $promo_code = Input::get('promo_code');
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id), array('token' => 'required', 'owner_id' => 'required|integer'));
     if ($validator->fails()) {
         $error_messages = $validator->messages();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401);
         $response_code = 200;
     } else {
         $request_id = 0;
         $is_apply_on_trip = 0;
         $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) {
                 $request = Requests::where('owner_id', '=', $owner_id)->where('status', '=', 1)->orderBy('created_at', 'desc')->first();
                 if ($request) {
                     if (isset($request->id)) {
                         if ($request->promo_id) {
                             $response_array = array('success' => FALSE, 'error' => 'You can not apply multiple code for single trip.', 'error_code' => 411);
                             $response_code = 200;
                         } else {
                             $settings = Settings::where('key', 'promotional_code_activation')->first();
                             $prom_act = $settings->value;
                             if ($prom_act) {
                                 if ($request->payment_mode == 0) {
                                     $settings = Settings::where('key', 'get_promotional_profit_on_card_payment')->first();
                                     $prom_act_card = $settings->value;
                                     if ($prom_act_card) {
                                         /* if ($ledger = PromotionalCodes::where('promo_code', $promo_code)->first()) { */
                                         if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) {
                                             if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) {
                                                 $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available.', 'error_code' => 505);
                                                 $response_code = 200;
                                             } else {
                                                 /* echo $promos->id;
                                                    echo $owner_id;
                                                    $promo_is_used = 0; */
                                                 $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count();
                                                 /* $promo_is_used = DB::table('user_promo_used')->where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count(); */
                                                 if ($promo_is_used) {
                                                     $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512);
                                                     $response_code = 200;
                                                 } else {
                                                     $promo_update_counter = PromoCodes::find($promos->id);
                                                     $promo_update_counter->uses = $promo_update_counter->uses - 1;
                                                     $promo_update_counter->save();
                                                     $user_promo_entry = new UserPromoUse();
                                                     $user_promo_entry->code_id = $promos->id;
                                                     $user_promo_entry->user_id = $owner_id;
                                                     $user_promo_entry->save();
                                                     $owner = Owner::find($owner_id);
                                                     $owner->promo_count = $owner->promo_count + 1;
                                                     $owner->save();
                                                     $request = Requests::find($request->id);
                                                     $request->promo_id = $promos->id;
                                                     $request->promo_code = $promos->coupon_code;
                                                     $request->save();
                                                     $owner = Owner::find($owner_id);
                                                     $code_data = Ledger::where('owner_id', '=', $owner->id)->first();
                                                     $response_array = array('success' => true, 'error' => 'Promotional code successfully applied.', 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count, 'request_id' => $request->id);
                                                     $response_code = 200;
                                                 }
                                             }
                                         } else {
                                             $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available.', 'error_code' => 505);
                                             $response_code = 200;
                                         }
                                     } else {
                                         $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on card payment.', 'error_code' => 505);
                                         $response_code = 200;
                                     }
                                 } else {
                                     if ($request->payment_mode == 1) {
                                         $settings = Settings::where('key', 'get_promotional_profit_on_cash_payment')->first();
                                         $prom_act_cash = $settings->value;
                                         if ($prom_act_cash) {
                                             /* if ($ledger = PromotionalCodes::where('promo_code', $promo_code)->first()) { */
                                             if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) {
                                                 if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) {
                                                     $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                     $response_code = 200;
                                                 } else {
                                                     /* echo $promos->id;
                                                        echo $owner_id;
                                                        $promo_is_used = 0; */
                                                     $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count();
                                                     /* $promo_is_used = DB::table('user_promo_used')->where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count(); */
                                                     if ($promo_is_used) {
                                                         $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512);
                                                         $response_code = 200;
                                                     } else {
                                                         $promo_update_counter = PromoCodes::find($promos->id);
                                                         $promo_update_counter->uses = $promo_update_counter->uses - 1;
                                                         $promo_update_counter->save();
                                                         $user_promo_entry = new UserPromoUse();
                                                         $user_promo_entry->code_id = $promos->id;
                                                         $user_promo_entry->user_id = $owner_id;
                                                         $user_promo_entry->save();
                                                         $owner = Owner::find($owner_id);
                                                         $owner->promo_count = $owner->promo_count + 1;
                                                         $owner->save();
                                                         $request = Requests::find($request->id);
                                                         $request->promo_id = $promos->id;
                                                         $request->promo_code = $promos->coupon_code;
                                                         $request->save();
                                                         $owner = Owner::find($owner_id);
                                                         $code_data = Ledger::where('owner_id', '=', $owner->id)->first();
                                                         $response_array = array('success' => true, 'error' => 'Promotional code successfully applied.', 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count, 'request_id' => $request->id);
                                                         $response_code = 200;
                                                     }
                                                 }
                                             } else {
                                                 $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                 $response_code = 200;
                                             }
                                         } else {
                                             $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on cash payment.', 'error_code' => 505);
                                             $response_code = 200;
                                         }
                                     } else {
                                         $response_array = array('success' => FALSE, 'error' => 'Payment mode is paypal', 'error_code' => 505);
                                         $response_code = 200;
                                     }
                                 }
                             } else {
                                 $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active.', 'error_code' => 505);
                                 $response_code = 200;
                             }
                         }
                     } else {
                         $response_array = array('success' => FALSE, 'error' => 'You can\'t apply promotional code without creating request.', 'error_code' => 506);
                         $response_code = 200;
                     }
                 } else {
                     $response_array = array('success' => FALSE, 'error' => 'You can\'t apply promotional code without creating request.', 'error_code' => 506);
                     $response_code = 200;
                 }
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 $response_array = array('success' => false, 'error' => 'Owner ID is not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }
예제 #2
0
 public function create_request()
 {
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $d_latitude = Input::get('d_latitude');
     $d_longitude = Input::get('d_longitude');
     $payment_opt = 0;
     if (Input::has('payment_mode')) {
         $payment_opt = Input::get('payment_mode');
     }
     if (Input::has('payment_opt')) {
         $payment_opt = Input::get('payment_opt');
     }
     $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'));
     /* $var = Keywords::where('id', 2)->first(); */
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         $unit = "";
         $driver_data = "";
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 /* SEND REFERRAL & PROMO INFO */
                 $settings = Settings::where('key', 'referral_code_activation')->first();
                 $referral_code_activation = $settings->value;
                 if ($referral_code_activation) {
                     $referral_code_activation_txt = "referral on";
                 } else {
                     $referral_code_activation_txt = "referral off";
                 }
                 $settings = Settings::where('key', 'promotional_code_activation')->first();
                 $promotional_code_activation = $settings->value;
                 if ($promotional_code_activation) {
                     $promotional_code_activation_txt = "promo on";
                 } else {
                     $promotional_code_activation_txt = "promo off";
                 }
                 /* SEND REFERRAL & PROMO INFO */
                 // Do necessary operations
                 /* $req = Requests::find($request_id);
                                       $req->current_walker = $provider_id;
                                       $req->save();
                 
                                       $response_array = array(
                                       'success' => true,
                                       'request_id' => $req->id,
                                       );
                                       $response_code = 200; */
                 $request = DB::table('request')->where('owner_id', $owner_data->id)->where('is_completed', 0)->where('is_cancelled', 0)->where('current_walker', '!=', 0)->first();
                 if ($request) {
                     goto DontcreateReq;
                 } else {
                     /* SEND REFERRAL & PROMO INFO */
                     if ($payment_opt != 1) {
                         $card_count = Payment::where('owner_id', '=', $owner_id)->count();
                         if ($card_count <= 0) {
                             $response_array = array('success' => false, 'error' => "Please add card first for payment.", 'error_code' => 417);
                             $response_code = 200;
                             $response = Response::json($response_array, $response_code);
                             return $response;
                         }
                     }
                     /* if ($owner_data->debt > 0) {
                        $response_array = array('success' => false, 'error' => "You are already in \$$owner_data->debt debt", 'error_code' => 417);
                        $response_code = 200;
                        $response = Response::json($response_array, $response_code);
                        return $response;
                        } */
                     if (Input::has('type')) {
                         Log::info('out');
                         $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));
                         if (count($typewalkers) > 0) {
                             foreach ($typewalkers as $key) {
                                 $types[] = $key->provider_id;
                             }
                             $typestring = implode(",", $types);
                             Log::info('typestring = ' . print_r($typestring, true));
                         } else {
                             /* $driver = Keywords::where('id', 1)->first();
                                send_notifications($owner_id, "owner", 'No ' . $driver->keyword . ' Found', 'No ' . $driver->keyword . ' found matching the service type.'); */
                             send_notifications($owner_id, "owner", 'No ' . Config::get('app.generic_keywords.Provider') . ' Found', 'No ' . Config::get('app.generic_keywords.Provider') . ' found matching the service type.');
                             /* $response_array = array('success' => false, 'error' => 'No ' . $driver->keyword . ' found matching the service type.', 'error_code' => 416); */
                             $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found matching the service type.', 'error_code' => 416);
                             $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;
                         }
                         $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();
                         $request = new Requests();
                         $request->owner_id = $owner_id;
                         if (Input::has('payment_mode')) {
                             $request->payment_mode = $payment_opt = Input::get('payment_mode');
                         }
                         if (Input::has('promo_code')) {
                             $promo_code = Input::get('promo_code');
                             $payment_mode = 0;
                             if (Input::has('payment_mode')) {
                                 $payment_mode = $payment_opt = Input::get('payment_mode');
                             }
                             $settings = Settings::where('key', 'promotional_code_activation')->first();
                             $prom_act = $settings->value;
                             if ($prom_act) {
                                 if ($payment_mode == 0) {
                                     $settings = Settings::where('key', 'get_promotional_profit_on_card_payment')->first();
                                     $prom_act_card = $settings->value;
                                     if ($prom_act_card) {
                                         if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) {
                                             if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) {
                                                 $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                 $response_code = 200;
                                                 return Response::json($response_array, $response_code);
                                             } else {
                                                 $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count();
                                                 if ($promo_is_used) {
                                                     $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512);
                                                     $response_code = 200;
                                                     return Response::json($response_array, $response_code);
                                                 } else {
                                                     $promo_update_counter = PromoCodes::find($promos->id);
                                                     $promo_update_counter->uses = $promo_update_counter->uses - 1;
                                                     $promo_update_counter->save();
                                                     $user_promo_entry = new UserPromoUse();
                                                     $user_promo_entry->code_id = $promos->id;
                                                     $user_promo_entry->user_id = $owner_id;
                                                     $user_promo_entry->save();
                                                     $owner = Owner::find($owner_id);
                                                     $owner->promo_count = $owner->promo_count + 1;
                                                     $owner->save();
                                                     $request->promo_id = $promos->id;
                                                     $request->promo_code = $promos->coupon_code;
                                                 }
                                             }
                                         } else {
                                             $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                             $response_code = 200;
                                             return Response::json($response_array, $response_code);
                                         }
                                     } else {
                                         $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on card payment.', 'error_code' => 505);
                                         $response_code = 200;
                                         return Response::json($response_array, $response_code);
                                     }
                                 } else {
                                     if ($payment_mode == 1) {
                                         $settings = Settings::where('key', 'get_promotional_profit_on_cash_payment')->first();
                                         $prom_act_cash = $settings->value;
                                         if ($prom_act_cash) {
                                             if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) {
                                                 if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) {
                                                     $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                     $response_code = 200;
                                                     return Response::json($response_array, $response_code);
                                                 } else {
                                                     $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count();
                                                     if ($promo_is_used) {
                                                         $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512);
                                                         $response_code = 200;
                                                         return Response::json($response_array, $response_code);
                                                     } else {
                                                         $promo_update_counter = PromoCodes::find($promos->id);
                                                         $promo_update_counter->uses = $promo_update_counter->uses - 1;
                                                         $promo_update_counter->save();
                                                         $user_promo_entry = new UserPromoUse();
                                                         $user_promo_entry->code_id = $promos->id;
                                                         $user_promo_entry->user_id = $owner_id;
                                                         $user_promo_entry->save();
                                                         $owner = Owner::find($owner_id);
                                                         $owner->promo_count = $owner->promo_count + 1;
                                                         $owner->save();
                                                         $request->promo_id = $promos->id;
                                                         $request->promo_code = $promos->coupon_code;
                                                     }
                                                 }
                                             } else {
                                                 $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                 $response_code = 200;
                                                 return Response::json($response_array, $response_code);
                                             }
                                         } else {
                                             $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on cash payment.', 'error_code' => 505);
                                             $response_code = 200;
                                             return Response::json($response_array, $response_code);
                                         }
                                     }
                                 }
                                 /* else {
                                    $response_array = array('success' => FALSE, 'error' => 'Payment mode is paypal', 'error_code' => 505);
                                    $response_code = 200;
                                    return Response::json($response_array, $response_code);
                                    } */
                             } else {
                                 $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active.', 'error_code' => 505);
                                 $response_code = 200;
                                 return Response::json($response_array, $response_code);
                             }
                             /* $pcode = PromoCodes::where('coupon_code', Input::get('promo_code'))->first();
                             
                                                               if ($pcode) {
                                                               // promo history
                                                               $promohistory = PromoHistory::where('user_id', $owner_id)->where('promo_code', Input::get('promo_code'))->first();
                                                               if (!$promohistory) {
                                                               if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($pcode->expiry)))) {
                                                               $response_array = array('success' => false, 'Promo Code already Expired', 'error_code' => 425);
                                                               $response_code = 200;
                                                               return Response::json($response_array, $response_code);
                                                               } else {
                                                               $request->promo_code = $pcode->id;
                                                               if ($pcode->uses == 1) {
                                                               $pcode->status = 3;
                                                               }
                                                               $pcode->uses = $pcode->uses - 1;
                                                               $pcode->save();
                                                               $phist = new PromoHistory();
                                                               $phist->user_id = $owner_id;
                                                               $phist->promo_code = Input::get('promo_code');
                                                               $phist->amount_earned = $pcode->value;
                                                               $phist->save();
                                                               if ($pcode->type == 2) {
                                                               // Absolute discount
                                                               // Add to ledger amount
                                                               $led = Ledger::where('owner_id', $owner_id)->first();
                                                               if ($led) {
                                                               $led->amount_earned = $led->amount_earned + $pcode->value;
                                                               $led->save();
                                                               } else {
                                                               $ledger = new Ledger();
                                                               $ledger->owner_id = $owner_id;
                                                               $ledger->referral_code = "0";
                                                               $ledger->total_referrals = 0;
                                                               $ledger->amount_earned = $pcode->value;
                                                               $ledger->amount_spent = 0;
                                                               $ledger->save();
                                                               }
                                                               }
                                                               }
                                                               } else {
                                                               $response_array = array('success' => false, 'Promo Code already Used', 'error_code' => 425);
                                                               $response_code = 200;
                                                               return Response::json($response_array, $response_code);
                                                               }
                                                               } else {
                                                               $response_array = array('success' => false, 'Invalid Promo Code', 'error_code' => 415);
                                                               $response_code = 200;
                                                               return Response::json($response_array, $response_code);
                                                               } */
                         }
                         $user_timezone = $owner->timezone;
                         $default_timezone = Config::get('app.timezone');
                         /* $offset = $this->get_timezone_offset($default_timezone, $user_timezone); */
                         $date_time = get_user_time($default_timezone, $user_timezone, date("Y-m-d H:i:s"));
                         $request->D_latitude = 0;
                         if (isset($d_latitude)) {
                             $request->D_latitude = Input::get('d_latitude');
                         }
                         $request->D_longitude = 0;
                         if (isset($d_longitude)) {
                             $request->D_longitude = Input::get('d_longitude');
                         }
                         /* $request->request_start_time = date("Y-m-d H:i:s"); */
                         $request->request_start_time = $date_time;
                         $request->save();
                         $reqserv = new RequestServices();
                         $reqserv->request_id = $request->id;
                         $reqserv->type = $type;
                         $reqserv->save();
                     } else {
                         Log::info('in');
                         $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 " . "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;
                         if (Input::has('payment_mode')) {
                             $request->payment_mode = $payment_opt = Input::get('payment_mode');
                         }
                         if (Input::has('promo_code')) {
                             $promo_code = Input::get('promo_code');
                             $payment_mode = 0;
                             if (Input::has('payment_mode')) {
                                 $payment_mode = $payment_opt = Input::get('payment_mode');
                             }
                             $settings = Settings::where('key', 'promotional_code_activation')->first();
                             $prom_act = $settings->value;
                             if ($prom_act) {
                                 if ($payment_mode == 0) {
                                     $settings = Settings::where('key', 'get_promotional_profit_on_card_payment')->first();
                                     $prom_act_card = $settings->value;
                                     if ($prom_act_card) {
                                         if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) {
                                             if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) {
                                                 $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                 $response_code = 200;
                                                 return Response::json($response_array, $response_code);
                                             } else {
                                                 $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count();
                                                 if ($promo_is_used) {
                                                     $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512);
                                                     $response_code = 200;
                                                     return Response::json($response_array, $response_code);
                                                 } else {
                                                     $promo_update_counter = PromoCodes::find($promos->id);
                                                     $promo_update_counter->uses = $promo_update_counter->uses - 1;
                                                     $promo_update_counter->save();
                                                     $user_promo_entry = new UserPromoUse();
                                                     $user_promo_entry->code_id = $promos->id;
                                                     $user_promo_entry->user_id = $owner_id;
                                                     $user_promo_entry->save();
                                                     $owner = Owner::find($owner_id);
                                                     $owner->promo_count = $owner->promo_count + 1;
                                                     $owner->save();
                                                     $request->promo_id = $promos->id;
                                                     $request->promo_code = $promos->coupon_code;
                                                 }
                                             }
                                         } else {
                                             $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                             $response_code = 200;
                                             return Response::json($response_array, $response_code);
                                         }
                                     } else {
                                         $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on card payment.', 'error_code' => 505);
                                         $response_code = 200;
                                         return Response::json($response_array, $response_code);
                                     }
                                 } else {
                                     if ($payment_mode == 1) {
                                         $settings = Settings::where('key', 'get_promotional_profit_on_cash_payment')->first();
                                         $prom_act_cash = $settings->value;
                                         if ($prom_act_cash) {
                                             if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) {
                                                 if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) {
                                                     $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                     $response_code = 200;
                                                     return Response::json($response_array, $response_code);
                                                 } else {
                                                     $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count();
                                                     if ($promo_is_used) {
                                                         $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512);
                                                         $response_code = 200;
                                                         return Response::json($response_array, $response_code);
                                                     } else {
                                                         $promo_update_counter = PromoCodes::find($promos->id);
                                                         $promo_update_counter->uses = $promo_update_counter->uses - 1;
                                                         $promo_update_counter->save();
                                                         $user_promo_entry = new UserPromoUse();
                                                         $user_promo_entry->code_id = $promos->id;
                                                         $user_promo_entry->user_id = $owner_id;
                                                         $user_promo_entry->save();
                                                         $owner = Owner::find($owner_id);
                                                         $owner->promo_count = $owner->promo_count + 1;
                                                         $owner->save();
                                                         $request->promo_id = $promos->id;
                                                         $request->promo_code = $promos->coupon_code;
                                                     }
                                                 }
                                             } else {
                                                 $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505);
                                                 $response_code = 200;
                                                 return Response::json($response_array, $response_code);
                                             }
                                         } else {
                                             $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on cash payment.', 'error_code' => 505);
                                             $response_code = 200;
                                             return Response::json($response_array, $response_code);
                                         }
                                     }
                                 }
                                 /* else {
                                    $response_array = array('success' => FALSE, 'error' => 'Payment mode is paypal', 'error_code' => 505);
                                    $response_code = 200;
                                    return Response::json($response_array, $response_code);
                                    } */
                             } else {
                                 $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active.', 'error_code' => 505);
                                 $response_code = 200;
                                 return Response::json($response_array, $response_code);
                             }
                             /* $pcode = PromoCodes::where('coupon_code', Input::get('promo_code'))->first();
                             
                                                               if ($pcode) {
                             
                                                               $request->promo_code = $pcode->id;
                             
                                                               if ($pcode->uses == 1) {
                                                               $pcode->status = 3;
                                                               }
                                                               $pcode->uses = $pcode->uses - 1;
                                                               $pcode->save();
                                                               } else {
                                                               $response_array = array('success' => false, 'Invalid Promo Code', 'error_code' => 415);
                                                               $response_code = 200;
                                                               return Response::json($response_array, $response_code);
                                                               } */
                         }
                         $request->request_start_time = date("Y-m-d H:i:s");
                         $request->save();
                         $reqserv = new RequestServices();
                         $reqserv->request_id = $request->id;
                         $reqserv->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;
                             $driver_data = array();
                             $driver_data['unique_id'] = 1;
                             $driver_data['id'] = "" . $first_walker_id;
                             $driver_data['first_name'] = "" . $walker->first_name;
                             $driver_data['last_name'] = "" . $walker->last_name;
                             $driver_data['phone'] = "" . $walker->phone;
                             /*  $driver_data['email'] = "" . $walker->email; */
                             $driver_data['picture'] = "" . $walker->picture;
                             $driver_data['bio'] = "" . $walker->bio;
                             /* $driver_data['address'] = "" . $walker->address;
                                $driver_data['state'] = "" . $walker->state;
                                $driver_data['country'] = "" . $walker->country;
                                $driver_data['zipcode'] = "" . $walker->zipcode;
                                $driver_data['login_by'] = "" . $walker->login_by;
                                $driver_data['social_unique_id'] = "" . $walker->social_unique_id;
                                $driver_data['is_active'] = "" . $walker->is_active;
                                $driver_data['is_available'] = "" . $walker->is_available; */
                             $driver_data['latitude'] = "" . $walker->latitude;
                             $driver_data['longitude'] = "" . $walker->longitude;
                             /* $driver_data['is_approved'] = "" . $walker->is_approved; */
                             $driver_data['type'] = "" . $walker->type;
                             $driver_data['car_model'] = "" . $walker->car_model;
                             $driver_data['car_number'] = "" . $walker->car_number;
                             $driver_data['rating'] = $walker->rate;
                             $driver_data['num_rating'] = $walker->rate_count;
                             /* $driver_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $first_walker_id)->avg('rating') ? : 0;
                                $driver_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $first_walker_id)->count(); */
                             $i++;
                         }
                         $request_meta->save();
                     }
                     $req = Requests::find($request->id);
                     $req->current_walker = $first_walker_id;
                     $req->save();
                     $settings = Settings::where('key', 'provider_timeout')->first();
                     $time_left = $settings->value;
                     // Send Notification
                     $walker = Walker::find($first_walker_id);
                     if ($walker) {
                         $msg_array = array();
                         $msg_array['unique_id'] = 1;
                         $msg_array['request_id'] = $request->id;
                         $msg_array['time_left_to_respond'] = $time_left;
                         if (Input::has('payment_mode')) {
                             $msg_array['payment_mode'] = $payment_opt = Input::get('payment_mode');
                         }
                         $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;
                         if ($d_latitude != NULL) {
                             $request_data['owner']['d_latitude'] = $d_latitude;
                             $request_data['owner']['d_longitude'] = $d_longitude;
                         }
                         $request_data['owner']['owner_dist_lat'] = $request->D_latitude;
                         $request_data['owner']['owner_dist_long'] = $request->D_longitude;
                         $request_data['owner']['payment_type'] = $payment_opt;
                         $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(); */
                         $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('response = ' . print_r($message, true));
                         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);
                     } else {
                         Log::info('No provider found in your area');
                         /* $driver = Keywords::where('id', 1)->first();
                            send_notifications($owner_id, "owner", 'No ' . $driver->keyword . ' Found', 'No ' . $driver->keyword . ' found for the selected service in your area currently'); */
                         send_notifications($owner_id, "owner", 'No ' . Config::get('app.generic_keywords.Provider') . ' Found', 'No ' . Config::get('app.generic_keywords.Provider') . ' found for the selected service in your area currently');
                         /* $response_array = array('success' => false, 'error' => 'No ' . $driver->keyword . ' found for the selected service in your area currently', 'error_code' => 415); */
                         $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found for the selected service in your area currently', 'error_code' => 415);
                         $response_code = 200;
                         return Response::json($response_array, $response_code);
                     }
                     // 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);
                     if (!empty($driver_data)) {
                         $response_array = array('success' => true, 'unique_id' => 1, '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, 'request_id' => $request->id, 'walker' => $driver_data);
                     } else {
                         $response_array = array('success' => false, 'unique_id' => 1, 'error' => 'No driver found around you.', '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, 'request_id' => $request->id, 'error_code' => 411, 'walker' => $driver_data);
                     }
                     $response_code = 200;
                 }
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 /* $response_array = array('success' => false, 'error' => '' . $var->keyword . ' ID not Found', 'error_code' => 410); */
                 $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.User') . ' ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
     DontcreateReq:
     Log::info('Request not created ');
 }