Пример #1
0
 /**
  * Creates a new model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  */
 public function actionCreate()
 {
     $model = new Requests();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['Requests'])) {
         $model->attributes = $_POST['Requests'];
         if ($model->save()) {
             $this->redirect(array('view', 'id' => $model->id));
         }
     }
     $this->render('create', array('model' => $model));
 }
 public function DoCreate()
 {
     $requestData = Input::all();
     $validationRules = array('name' => 'required', 'location' => 'required', 'skills' => 'required');
     $validator = Validator::make($requestData, $validationRules);
     if ($validator->fails()) {
         return Redirect::action('RequestController@ShowCreate')->withErrors($validator);
     } else {
         $request = new Requests();
         $request->name = Input::get('name');
         $request->request_location = Input::get('location');
         $request->service_category = "General";
         $request->skills_required = Input::get('skills');
         $request->creator_user_id = 1;
         $request->save();
         return Redirect::action('RequestController@ShowCreate')->with('message', 'Request submitted to database!');
     }
 }
Пример #3
0
 public function postFormRequest()
 {
     $all = Input::all();
     $rules = array('name' => 'required|min:2|max:255', 'text' => 'required|min:5', 'email' => 'required|email');
     $validator = Validator::make($all, $rules);
     if ($validator->fails()) {
         return Redirect::to('/#contact')->withErrors($validator)->withInput()->with('message_error', 'Ошибка, пожалуйста заполните форму');
     }
     $post = new Requests();
     $post->name = $all['name'];
     $post->phone = $all['phone'];
     $post->email = $all['email'];
     $post->text = $all['text'];
     $post->save();
     $mail = Setting::where('name', 'email')->first()->value;
     $messages = '<b>Пользователь: </b>' . $all['name'] . '<br>';
     $messages .= '<b>Сообщение: </b>' . $all['text'] . '<br>';
     $messages .= '<b>Контактные данные: </b>' . '<br>';
     $messages .= '<i>Телефон: </i>' . $all['phone'] . '<br>';
     $messages .= '<i>Емайл: </i>' . $all['email'] . '<br>';
     Mail::send('emails.message', array('messages' => $messages), function ($message) use($mail) {
         $message->to($mail)->subject('Заказ каталога');
     });
     return Redirect::to('/#formRequest')->with('message_sent', 'Ваше сообщение отправлено, с вами свяжутся наши сотрудники.');
 }
 public function saveUserRequestTrip()
 {
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $type = Input::get('type');
     $owner_id = Session::get('user_id');
     $owner_data = Owner::find($owner_id);
     $settings = Settings::where('key', 'default_search_radius')->first();
     $distance = $settings->value;
     $query = "SELECT walker.id, 1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and type = {$type} and (1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) <= {$distance}  order by distance";
     $walkers = DB::select(DB::raw($query));
     $walker_list = array();
     $owner = Owner::find($owner_id);
     $owner->latitude = $latitude;
     $owner->longitude = $longitude;
     $owner->save();
     $request = new Requests();
     $request->owner_id = $owner_id;
     $request->type = $type;
     $request->request_start_time = date("Y-m-d H:i:s");
     $request->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->save();
     $settings = Settings::where('key', 'provider_timeout')->first();
     $time_left = $settings->value;
     $message = "Your Request is successful. Please wait while we are finding a nearest cab driver 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']['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 = 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); */
 }
 public function create_manual_request()
 {
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $d_latitude = Input::get('d_latitude');
     $d_longitude = Input::get('d_longitude');
     $type = Input::get('type');
     $provider = Input::get('provider');
     $user_id = Session::get('user_id');
     $time = date("Y-m-d H:i:s");
     $provider_details = Walker::where('id', '=', $provider)->first();
     $user = Owner::where('id', '=', $user_id)->first();
     $request = new Requests();
     $request->owner_id = $user_id;
     $request->request_start_time = $time;
     $request->confirmed_walker = $provider;
     if ($d_longitude != '' && $d_latitude != '') {
         $request->D_latitude = $d_latitude;
         $request->D_longitude = $d_longitude;
     }
     $request->current_walker = $provider;
     $request->status = 1;
     $request->save();
     $reqid = $request->id;
     $request_service = new RequestServices();
     $request_service->type = $type;
     $request_service->request_id = $request->id;
     $request_service->save();
     $owner = Owner::find($user_id);
     $owner->latitude = $latitude;
     $owner->longitude = $longitude;
     $owner->save();
     $walkerlocation = new WalkLocation();
     $walkerlocation->request_id = $request->id;
     $walkerlocation->distance = 0.0;
     $walkerlocation->latitude = $latitude;
     $walkerlocation->longitude = $longitude;
     $walkerlocation->save();
     if ($request->save()) {
         $current_request = Requests::where('id', '=', $reqid)->first();
         return Redirect::to('/user/request-trip');
     }
 }
 public function create_request()
 {
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $type = Input::get('type');
     $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'latitude' => $latitude, 'longitude' => $longitude), array('token' => 'required', 'owner_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 // Do necessary operations
                 if (!$type) {
                     // choose default type
                     $provider_type = ProviderType::where('is_default', 1)->first();
                     if (!$provider_type) {
                         $type = 0;
                     } else {
                         $type = $provider_type->id;
                     }
                 }
                 $settings = Settings::where('key', 'default_search_radius')->first();
                 $distance = $settings->value;
                 $query = "SELECT walker.id, 1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and type = {$type} and (1.609344 * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) <= {$distance}  order by distance";
                 $walkers = DB::select(DB::raw($query));
                 $walker_list = array();
                 $owner = Owner::find($owner_id);
                 $owner->latitude = $latitude;
                 $owner->longitude = $longitude;
                 $owner->save();
                 $request = new Requests();
                 $request->owner_id = $owner_id;
                 $request->type = $type;
                 $request->request_start_time = date("Y-m-d H:i:s");
                 $request->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->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;
                     $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 = "New Request";
                     $message = $msg_array;
                     /* don't do json_encode in above line because if */
                     send_notifications($first_walker_id, "walker", $title, $message);
                 }
                 // Send SMS
                 $settings = Settings::where('key', 'sms_request_created')->first();
                 $pattern = $settings->value;
                 $pattern = str_replace('%user%', $owner_data->first_name . " " . $owner_data->last_name, $pattern);
                 $pattern = str_replace('%id%', $request->id, $pattern);
                 $pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern);
                 sms_notification(1, 'admin', $pattern);
                 // send email
                 $settings = Settings::where('key', 'email_new_request')->first();
                 $pattern = $settings->value;
                 $pattern = str_replace('%id%', $request->id, $pattern);
                 $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern);
                 $subject = "New Request Created";
                 email_notification(1, 'admin', $pattern, $subject);
                 $response_array = array('success' => true, 'request_id' => $request->id);
                 $response_code = 200;
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 $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;
 }
Пример #7
0
 public function create_request_later()
 {
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $date_time = Input::get('datetime');
     // dd(date('Y-m-d h:i:s', strtotime("$date_time + 2 hours")));
     $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'latitude' => $latitude, 'longitude' => $longitude, 'datetime' => $date_time), array('token' => 'required', 'owner_id' => 'required|integer', 'latitude' => 'required', 'longitude' => 'required', 'datetime' => 'required'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 // Do necessary operations
                 if ($owner_data->debt > 0) {
                     $response_array = array('success' => false, 'error' => "You are already in \${$owner->debt} debt", 'error_code' => 417);
                     $response_code = 200;
                     $response = Response::json($response_array, $response_code);
                     return $response;
                 }
                 if (Input::has('type')) {
                     $type = Input::get('type');
                     if (!$type) {
                         // choose default type
                         $provider_type = ProviderType::where('is_default', 1)->first();
                         if (!$provider_type) {
                             $type = 1;
                         } else {
                             $type = $provider_type->id;
                         }
                     }
                     $typequery = "SELECT distinct provider_id from walker_services where type IN({$type})";
                     $typewalkers = DB::select(DB::raw($typequery));
                     Log::info('typewalkers = ' . print_r($typewalkers, true));
                     foreach ($typewalkers as $key) {
                         $types[] = $key->provider_id;
                     }
                     $typestring = implode(",", $types);
                     Log::info('typestring = ' . print_r($typestring, true));
                     if ($typestring == '') {
                         /* $driver = Keywords::where('id', 1)->first();
                            $response_array = array('success' => false, 'error' => 'No ' . $driver->keyword . ' found matching the service type.', 'error_code' => 405); */
                         $response_array = array('success' => false, 'error' => 'No ' . Config::get('app.generic_keywords.Provider') . ' found matching the service type.', 'error_code' => 405);
                         $response_code = 200;
                         return Response::json($response_array, $response_code);
                     }
                     $settings = Settings::where('key', 'default_search_radius')->first();
                     $distance = $settings->value;
                     $settings = Settings::where('key', 'default_distance_unit')->first();
                     $unit = $settings->value;
                     if ($unit == 0) {
                         $multiply = 1.609344;
                     } elseif ($unit == 1) {
                         $multiply = 1;
                     }
                     $query1 = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.id IN({$typestring});";
                     $ssstrings = DB::select(DB::raw($query1));
                     foreach ($ssstrings as $ssstrin) {
                         $ssstri[] = $ssstrin->id;
                     }
                     $ssstring = implode(",", $ssstri);
                     $datewant = new DateTime($date_time);
                     $datetime = $datewant->format('Y-m-d H:i:s');
                     $dategiven = $datewant->sub(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     $end_time = $datewant->add(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     /* $setting = Settings::where('key', 'allow_calendar')->first();
                        if ($setting->value == 1)
                        $pvquery = "SELECT distinct provider_id from provider_availability where start <= '" . $datetime . "' and end >= '" . $datetime . "' and provider_id IN($ssstring) and provider_id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                        else */
                     $pvquery = "SELECT id from walker where id IN({$ssstring}) and id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                     $pvques = DB::select(DB::raw($pvquery));
                     //  dd($pvques);
                     $ssstr = array();
                     foreach ($pvques as $ssstn) {
                         $ssstr[] = $ssstn->provider_id;
                     }
                     $pvque = implode(",", $ssstr);
                     $walkers = array();
                     if ($pvque) {
                         $settings = Settings::where('key', 'default_distance_unit')->first();
                         $unit = $settings->value;
                         if ($unit == 0) {
                             $multiply = 1.609344;
                         } elseif ($unit == 1) {
                             $multiply = 1;
                         }
                         $query = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and walker.id IN({$typestring}) and id IN({$pvque}) order by distance;";
                         $walkers = DB::select(DB::raw($query));
                     }
                     $walker_list = array();
                     $owner = Owner::find($owner_id);
                     $owner->latitude = $latitude;
                     $owner->longitude = $longitude;
                     $owner->save();
                     $request = new Requests();
                     $request->owner_id = $owner_id;
                     $request->request_start_time = $datetime;
                     $request->later = 1;
                     if (Input::has('cod')) {
                         if (Input::get('cod') == 1) {
                             $request->cod = 1;
                         } else {
                             $request->cod = 0;
                         }
                     }
                     $request->save();
                     $reqserv = new RequestServices();
                     $reqserv->request_id = $request->id;
                     $reqserv->type = $type;
                     $reqserv->save();
                 } else {
                     $settings = Settings::where('key', 'default_search_radius')->first();
                     $distance = $settings->value;
                     $settings = Settings::where('key', 'default_distance_unit')->first();
                     $unit = $settings->value;
                     if ($unit == 0) {
                         $multiply = 1.609344;
                     } elseif ($unit == 1) {
                         $multiply = 1;
                     }
                     $query1 = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance};";
                     $ssstrings = DB::select(DB::raw($query1));
                     foreach ($ssstrings as $ssstrin) {
                         $ssstri[] = $ssstrin->id;
                     }
                     $ssstring = implode(",", $ssstri);
                     $datewant = new DateTime($date_time);
                     $datetime = $datewant->format('Y-m-d H:i:s');
                     $dategiven = $datewant->sub(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     $end_time = $datewant->add(new DateInterval('P0Y0M0DT1H59M59S'))->format('Y-m-d H:i:s');
                     /* $setting = Settings::where('key', 'allow_calendar')->first();
                        if ($setting->value == 1)
                        $pvquery = "SELECT distinct provider_id from provider_availability where start <= '" . $datetime . "' and end >= '" . $datetime . "' and provider_id IN($ssstring) and provider_id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                        else */
                     $pvquery = "SELECT id from walker where id IN({$ssstring}) and id NOT IN(SELECT confirmed_walker FROM request where request_start_time>='" . $dategiven . "' and request_start_time<='" . $end_time . "');";
                     $pvques = DB::select(DB::raw($pvquery));
                     $ssstr = array();
                     foreach ($pvques as $ssstn) {
                         $ssstr[] = $ssstn->provider_id;
                     }
                     $pvque = implode(",", $ssstr);
                     $walkers = array();
                     if ($pvque) {
                         $settings = Settings::where('key', 'default_distance_unit')->first();
                         $unit = $settings->value;
                         if ($unit == 0) {
                             $multiply = 1.609344;
                         } elseif ($unit == 1) {
                             $multiply = 1;
                         }
                         $query = "SELECT walker.id, ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ,8) as distance from walker where is_available = 1 and is_active = 1 and is_approved = 1 and ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * cos( radians(latitude) ) * cos( radians(longitude) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians(latitude) ) ) ) ,8) <= {$distance} and id IN({$pvque}) order by distance;";
                         $walkers = DB::select(DB::raw($query));
                     }
                     $walker_list = array();
                     $owner = Owner::find($owner_id);
                     $owner->latitude = $latitude;
                     $owner->longitude = $longitude;
                     $owner->save();
                     $request = new Requests();
                     $request->owner_id = $owner_id;
                     $request->request_start_time = $datetime;
                     $request->save();
                     $reqserv = new RequestServices();
                     $reqserv->request_id = $request->id;
                     $reqserv->save();
                 }
                 $i = 0;
                 $first_walker_id = 0;
                 if ($walkers) {
                     foreach ($walkers as $walker) {
                         $request_meta = new RequestMeta();
                         $request_meta->request_id = $request->id;
                         $request_meta->walker_id = $walker->id;
                         if ($i == 0) {
                             $first_walker_id = $walker->id;
                             $i++;
                         }
                         $request_meta->save();
                     }
                     $req = Requests::find($request->id);
                     $req->current_walker = $first_walker_id;
                     $req->save();
                 }
                 $settings = Settings::where('key', 'provider_timeout')->first();
                 $time_left = $settings->value;
                 // Send Notification
                 $walker = Walker::find($first_walker_id);
                 if ($walker) {
                     $msg_array = array();
                     $msg_array['unique_id'] = 3;
                     $msg_array['request_id'] = $request->id;
                     $msg_array['time_left_to_respond'] = $time_left;
                     $owner = Owner::find($owner_id);
                     $request_data = array();
                     $request_data['owner'] = array();
                     $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name;
                     $request_data['owner']['picture'] = $owner->picture;
                     $request_data['owner']['phone'] = $owner->phone;
                     $request_data['owner']['address'] = $owner->address;
                     $request_data['owner']['latitude'] = $owner->latitude;
                     $request_data['owner']['longitude'] = $owner->longitude;
                     $request_data['owner']['rating'] = $owner->rate;
                     $request_data['owner']['num_rating'] = $owner->rate_count;
                     /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0;
                        $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */
                     $date_want = new DateTime($date_time);
                     $datetime1 = $date_want->format('Y-m-d H:i:s');
                     $request_data['datetime'] = $datetime1;
                     $request_data['dog'] = array();
                     if ($dog = Dog::find($owner->dog_id)) {
                         $request_data['dog']['name'] = $dog->name;
                         $request_data['dog']['age'] = $dog->age;
                         $request_data['dog']['breed'] = $dog->breed;
                         $request_data['dog']['likes'] = $dog->likes;
                         $request_data['dog']['picture'] = $dog->image_url;
                     }
                     $msg_array['request_data'] = $request_data;
                     $title = "New Request";
                     $message = $msg_array;
                     Log::info('first_walker_id = ' . print_r($first_walker_id, true));
                     Log::info('New request = ' . print_r($message, true));
                     /* don't do json_encode in above line because if */
                     send_notifications($first_walker_id, "walker", $title, $message);
                 }
                 // Send SMS
                 $settings = Settings::where('key', 'sms_request_created')->first();
                 $pattern = $settings->value;
                 $pattern = str_replace('%user%', $owner_data->first_name . " " . $owner_data->last_name, $pattern);
                 $pattern = str_replace('%id%', $request->id, $pattern);
                 $pattern = str_replace('%user_mobile%', $owner_data->phone, $pattern);
                 sms_notification(1, 'admin', $pattern);
                 // send email
                 /* $settings = Settings::where('key', 'email_new_request')->first();
                    $pattern = $settings->value;
                    $pattern = str_replace('%id%', $request->id, $pattern);
                    $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $request->id, $pattern);
                    $subject = "New Request Created";
                    email_notification(1, 'admin', $pattern, $subject); */
                 $settings = Settings::where('key', 'admin_email_address')->first();
                 $admin_email = $settings->value;
                 $follow_url = web_url() . "/user/signin";
                 $pattern = array('admin_eamil' => $admin_email, 'trip_id' => $request->id, 'follow_url' => $follow_url);
                 $subject = "Ride Booking Request";
                 email_notification(1, 'admin', $pattern, $subject, 'new_request', null);
                 $response_array = array('success' => true, 'request_id' => $request->id);
                 $response_code = 200;
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 /* $var = Keywords::where('id', 2)->first();
                    $response_array = array('success' => false, 'error' => '' . $var->keyword . ' ID not Found', 'error_code' => 410); */
                 $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.User') . ' ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }
 public function 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);
     }
 }
Пример #9
0
 private function createRequest($user_id, $doc_id, $comment)
 {
     $params = array('user_id' => $user_id, 'doc_id' => $doc_id, 'comment' => $comment, 'state' => 'WAIT', 'state_time' => date("Y-m-d H:i:s"));
     $model = new Requests();
     $model->attributes = $params;
     if ($model->save()) {
         return true;
     }
     return false;
 }