PHP Location::find方法代码示例

 /**
  * @return ElasticaQuery
  */
 private function prepareQuery($params, $start = null, $limit = null)
 {
     $query = null;
     $filter = null;
     $sort = ['_score' => 'desc'];
     // We'd like to search in both title and description for keywords
     if (!empty($params['keywords'])) {
         $query = new QueryString($params['keywords']);
         $query->setDefaultOperator('AND')->setFields(['title', 'description']);
     }
     // Add location filter is location is selected from autosuggest
     if (!empty($params['location_id'])) {
         $location = Location::find($params['location_id']);
         $filter = new GeoDistance('location', ['lat' => $location->lat, 'lon' => $location->lon], $params['radius'] . 'mi');
         // Sort by nearest hit
         $sort = ['_geo_distance' => ['jobs.location' => [(double) $location->lon, (double) $location->lat], 'order' => 'asc', 'unit' => 'mi']];
     }
     // If neither keyword nor location supplied, then return all
     if (empty($params['keywords']) && empty($params['location_id'])) {
         $query = new MatchAll();
     }
     // We need a filtered query
     $elasticaQuery = new ElasticaQuery(new Filtered($query, $filter));
     $elasticaQuery->addSort($sort);
     // Offset and limits
     if (!is_null($start) && !is_null($limit)) {
         $elasticaQuery->setFrom($start)->setSize($limit);
     }
     // Set up the highlight
     $elasticaQuery->setHighlight(['order' => 'score', 'fields' => ['title' => ['fragment_size' => 100], 'description' => ['fragment_size' => 200]]]);
     return $elasticaQuery;
 }

 public static function boot()
 {
     parent::boot();
     static::creating(function ($model) {
         if ($model->status == null) {
             $model->status = static::CREATE;
         }
         if ($model->qty == null) {
             $model->qty = 1;
         }
         if ($model->location_id != null) {
             $location = Location::find($model->location_id, ['name']);
             if ($location) {
                 $model->location_name = $location->name;
             }
         }
     });
     static::created(function ($model) {
     });
     static::updating(function ($model) {
         if ($model->qty == null) {
             $model->qty = 1;
         }
     });
 }

 public function saveReferees(Season $season, Competition $competition, Request $request)
 {
     $data = $request->all();
     $competition->referees()->wherePivot('season_id', '=', $season->id)->detach();
     $pairs = $this->getPairs($season, $competition);
     foreach ($pairs as $pair) {
         $pair->active = 0;
         $pair->save();
     }
     $response = ['refs' => array(), 'crefs' => array()];
     $country = Country::find($data['country']);
     $refs = json_decode($data['referees'], true);
     foreach ($refs as $ref) {
         $newRef = $competition->storeReferee($ref, $season, 0, $country);
         if (array_key_exists('styled', $ref)) {
             if ($ref['styled'] == 'new') {
                 $newRef['location'] = Location::find($newRef->location_id)->name;
                 array_push($response['refs'], $newRef);
             }
         }
     }
     $crefs = json_decode($data['court_referees'], true);
     foreach ($crefs as $cref) {
         $newRef = $competition->storeReferee($cref, $season, 1, $country);
         if (array_key_exists('styled', $cref)) {
             if ($cref['styled'] == 'new') {
                 $newRef['location'] = Location::find($newRef->location_id)->name;
                 array_push($response['crefs'], $newRef);
             }
         }
     }
     $response['pairs'] = $this->getPairs($season, $competition)->toArray();
     return $response;
 }

 /**
  * Delete employee location from DB
  *
  * @param $id
  * @return mixed
  */
 public function deleteLocation($id)
 {
     $location = Location::find($id);
     if (count($location->employees()->get()->toArray())) {
         return redirect()->back()->with('danger_flash_message', 'You cannot delete a location that is in use.');
     }
     $location->delete();
     return redirect()->route('manageLocations')->with('flash_message', 'Location ' . $location->name . ' has been deleted');
 }

 public function getLocationNameByCode(Request $request, $code)
 {
     $location = Location::find($code);
     if ($location == null) {
         return response()->json(['name' => ""]);
     }
     $name = $location->name;
     return ['name' => $name];
 }

 public function destroy($id)
 {
     $location = Location::find($id);
     if ($location->delete()) {
         return $this->output('Location deleted');
     } else {
         return $this->notFound('Location not found');
     }
 }

 public function postDeleteLocation(Request $request)
 {
     $locationId = intval($request->input('location_id'));
     if ($locationId) {
         Location::find($locationId)->delete();
         return response(Location::all());
     }
     return redirect('dashboard/locations')->withErrors('No location id passed');
 }

 public static function countComments($id)
 {
     $comments = \App\Comment::where('id_location', '=', $id);
     $location = Location::find($id);
     $location->rating = ceil($comments->avg('rating') / 0.5) * 0.5;
     $location->voters = $comments->count();
     $location->save();
     return $avgRating;
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  Request  $request
  * @param  int  $id
  * @return Response
  */
 public function update(Request $request, $location_id, $id)
 {
     $location = Location::find($location_id);
     $price = Price::find($id);
     $price->type = $request->type;
     $price->price = $request->price;
     $price->price_date = $request->price_date;
     $price->location()->associate($location);
     $price->save();
     return redirect()->action('LocationController@show', $price->location->id);
 }

 public static function fromLocationWithCoordinates($location_id, $coordinates)
 {
     // DOES NOT SAVE TARGET -
     // must save through experiment for foreign key check
     $location = Location::find($location_id);
     $target = new Target();
     $target->location()->associate($location);
     $target->coordinates = $coordinates;
     $target->is_decoy = false;
     return $target;
 }

 /**
  * Downlod Tournaments
  *
  * @return Response
  */
 public function tournaments(Request $request)
 {
     $time_period = $request->input('time_period');
     $location_id = $request->input('location_id');
     $location = Location::find($location_id)->location;
     $ss = new Scraper();
     $new_tournaments = $ss->get_tournaments($location, $time_period);
     $tournaments = \DB::table('tournaments')->orderBy('start_date', 'desc')->get();
     //return view('pages/tournaments', compact('tournaments'));
     return redirect('admin/scraper')->with('success', 'tournaments downloaded successfully');
 }

 public function update($city, $id)
 {
     $location = Location::find($id);
     $location->name = Request::input('name');
     $location->type = Request::input('type');
     $location->time = Request::input('time');
     $location->specification = Request::input('specification');
     $location->description = Request::input('description');
     $location->price = Request::input('price');
     $location->address = Request::input('address');
     $location->save();
     return $location;
 }

 /**
  * @param $id
  * @param bool $withUsers
  * @return mixed
  * @throws GeneralException
  */
 public function findOrThrowException($id, $hasPcode = false)
 {
     if (empty($id)) {
         throw new GeneralException("Location id is empty.");
     }
     if ($hasPcode) {
         $location = Location::has('pcode')->find($id);
     } else {
         $location = Location::find($id);
     }
     if (!is_null($location)) {
         return $location;
     }
     throw new GeneralException("That location with id {$id} does not exist.");
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('adjacent_location')->delete();
     DB::table('locations')->delete();
     $locations = [["id" => 1, "name" => "Inn", "description" => "An establishment or building providing lodging and, usually, food and drink for travelers (Starting location)", "image" => "locations/Inn-800px.png", "image_sm" => "locations/Inn-300px.png"], ["id" => 2, "name" => "Town Hall", "description" => "Public forum or meeting in which those attending gather to discuss civic or political issues, hear and ask questions about the ideas of a candidate for public office", "image" => "locations/Townhall-800px.png", "image_sm" => "locations/Townhall-300px.png"], ["id" => 3, "name" => "Smithy", "description" => "A blacksmith's shop. A place to purchase weaponry and armor or train one's skill as a blacksmith", "image" => "locations/Blacksmith-800px.png", "image_sm" => "locations/Blacksmith-300px.png"], ["id" => 4, "name" => "Military academy fortress", "description" => "An institute where soldiers and mercenaries train they martial skills", "image" => "locations/Fortress-800px.png", "image_sm" => "locations/Fortress-300px.png"]];
     foreach ($locations as $location) {
         Location::create($location);
     }
     $adjacent_locations = [["location_id" => 1, "adjacent_location_id" => 2, "direction" => "north"], ["location_id" => 1, "adjacent_location_id" => 3, "direction" => "east"], ["location_id" => 1, "adjacent_location_id" => 4, "direction" => "south"]];
     foreach ($adjacent_locations as $record) {
         /** @var  $location Location */
         $location = Location::find($record['location_id']);
         /** @var  $adjacent_location Location */
         $adjacent_location = Location::find($record['adjacent_location_id']);
         $location->addAdjacentLocation($adjacent_location, $record['direction']);
     }
 }

 public function update(Request $request, $locationID)
 {
     if (!Auth::check() || !Auth::user()->is_admin) {
         return response(view('errors.403', ['error' => $this->errorMessages['incorrect_permissions']]), 403);
     }
     $data = $request->only(['name', 'latitude', 'longitude', 'capacity', 'featured_image']);
     // Validate all input
     $validator = Validator::make($data, ['name' => 'required', 'latitude' => 'required|numeric|between:-85.05,85.05', 'longitude' => 'required|numeric|between:-180,180', 'capacity' => 'required', 'featured_image' => 'image|sometimes']);
     if ($validator->fails()) {
         // If validation fails, redirect back to
         // registration form with errors
         return Redirect::back()->withErrors($validator)->withInput();
     }
     if ($request->hasFile('featured_image')) {
         $data['featured_image'] = MediaController::uploadImage($request->file('featured_image'), time(), $directory = "news_images", $bestFit = true, $fitDimensions = [1920, 1080]);
     } else {
         unset($data['featured_image']);
     }
     $location = Location::find($locationID);
     $location->update($data);
     return Redirect::route('locations.edit', [$location->id]);
 }