PHP Location::where方法代码示例

 public function update(LocationUpdateRequest $request, $id)
 {
     $location = new Location($request->all());
     Location::where('id', $id)->update($location->getAttributes());
     flash()->success(trans('location.label.name'), trans('location.message_alert.update_success'));
     return redirect('/locations');
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($type, $id)
 {
     if ($id == 'video') {
         $events = Video::all();
         return view('video.show', compact('events'));
     } elseif ($id == 'staff') {
         $events = Staff::all();
         return view('staff.show', compact('events'));
     } elseif ($id == 'gallery') {
         $events = Image::all();
         return view('gallery.show', compact('events'));
     } else {
         $event = Event::where('slug', $id)->where('type', $type)->first();
         $location = Location::where('event_id', $event->id)->first();
         $slider = EventImage::where('event_id', $event->id)->orderBy(\DB::raw('RAND()'))->take(4)->get();
         $gallery = EventImage::where('event_id', $event->id)->first();
         if ($event->type == $type) {
             if ($event->status == 1) {
                 return view($type . '.show', compact('event', 'location', 'slider', 'gallery'));
             } else {
                 return redirect('/' . $type . '/');
             }
         }
     }
 }

 /**
  *
  * @return view
  */
 public function dashboard_by_location()
 {
     // summary by location
     $locations = \App\Location::where('parent_id', 0)->orderBy('name')->get();
     for ($i = 0; $i < count($locations); $i++) {
         $nodesAll = \App\Node::where('location_id', $locations[$i]->id)->get();
         $nodesUp = \App\Node::where('location_id', $locations[$i]->id)->where('ping_success', '100')->get();
         $locations[$i]->nodesUp = $nodesUp->count();
         $locations[$i]->nodesDown = $nodesAll->count() - $nodesUp->count();
         // no node assigned in this project
         if ($nodesAll->count() == 0) {
             $locations[$i]->nodesUpnPercent = 0;
             $locations[$i]->nodesDownPercent = 0;
         } else {
             $locations[$i]->nodesUpPercent = $nodesUp->count() / $nodesAll->count() * 100;
             $locations[$i]->nodesDownPercent = 100 - $locations[$i]->nodesUpPercent;
             // to prevent too small click area
             if ($locations[$i]->nodesDownPercent > 0 && $locations[$i]->nodesDownPercent < 10) {
                 $locations[$i]->nodesUpPercent -= 10;
                 $locations[$i]->nodesDownPercent += 10;
             }
             if ($locations[$i]->nodesUpPercent > 0 && $locations[$i]->nodesUpPercent < 10) {
                 $locations[$i]->nodesUpPercent += 10;
                 $locations[$i]->nodesDownPercent -= 10;
             }
         }
     }
     return view('pages.dashboard_by_location', compact('locations'));
 }

 /**
  * Display a list of all locations.
  *
  * @param  Request  $request
  * @return Response
  */
 public function index(Request $request)
 {
     $showLocations = DB::select('select * from configs where id = ?', [2]);
     if ($showLocations[0]->value === '1') {
         return view('locations.index', ['locations' => Location::where('status', 1)->orderBy('name')->get()]);
     } else {
         return view('locations.index', ['locations' => []]);
     }
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  Request  $request
  * @return Response
  */
 public function store(Request $request)
 {
     $rp_arr = [];
     $user = \Auth::user();
     if ($user->role->name != 'guest') {
         $data = $request->json()->get('data');
         for ($i = 0; $i < count($data); $i++) {
             $order = new \App\Order();
             $from = Carbon::parse($data[$i]['from']);
             $to = Carbon::parse($data[$i]['to']);
             $order['from'] = $from;
             $order['to'] = $to;
             $order['location_id'] = \App\Location::where('name', $data[$i]['location'])->first()['id'];
             //$order['user_id'] = $user['id'];
             // count the similar records
             // if the num of them reaches upper limite then operation would be aborted
             $num_of_ordered = \App\Order::where('from', $from)->where('to', $to)->where('location_id', $order['location_id'])->count();
             $allowance = \App\Location::findOrFail($order['location_id'])->capacity;
             //dd($num_of_ordered);
             // $num_of_ordered can only be 0 or 1 in this case
             if ($num_of_ordered < $allowance) {
                 $user->orders()->save($order);
                 // Only one vacancy left before the saving statement.
                 if ($allowance - $num_of_ordered <= 1) {
                     array_push($rp_arr, ['from' => $order['from'], 'to' => $order['to'], 'status' => '0']);
                 } else {
                     array_push($rp_arr, ['from' => $order['from'], 'to' => $order['to'], 'status' => '1']);
                 }
             }
             /*else {
                   array_push($rp_arr, ['from' => $order['from'], 'to' => $order['to'], 'status' => '0']);
               }*/
         }
         /*if (\Auth::user()->orders()->save($order)) {
         
                         // \Mail::send('emails.test', [], function ($m) {
                         //     $m->from('soniczhangss@gmail.com', 'sonic');
                         //     $m->to('soniczhangss@gmail.com', 'sonic')->subject('Your Reminder!');
                         // });
                             return back()->withInput();
         
                         // $headers = 'From: soniczhangss@gmail.com' . "\r\n" . 'Reply-To: soniczhangss@gmail.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
                         // if (mail('soniczhangss@gmail.com', 'My Subject', 'blah blah', $headers)) {
                         //     return response()->json(['response' => 'successful']);
                         // } else {
                         //     return response()->json(['response' => 'failed']);
                         // }
                         //dd(mail('soniczhangss@gmail.com', 'My Subject', 'blah blah', $headers));
                         
                         //return response()->json(['response' => 'successful']);
                         
                     }*/
     }
     //return back()->withInput();
     return response()->json(['data' => $rp_arr]);
 }

 public function showLocations(Request $request)
 {
     $q = $request->input('q');
     $json['results'] = [];
     $results = Location::where('name', 'LIKE', "%{$q}%")->take(10)->lists('name', 'id');
     foreach ($results as $key => $value) {
         $json['results'][] = array('id' => $key, 'text' => $value);
     }
     return json_encode($json);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $travel_id = Request::input('travel_id');
     $locations = Location::where('travel_id', $travel_id)->orderBy('order', 'asc')->get();
     if (count($locations) > 0) {
         return $locations;
     } else {
         return [];
     }
 }

 /**
  * Handle an incoming request.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  \Closure  $next
  * @return mixed
  */
 public function handle($request, Closure $next)
 {
     if (Session::has('currency')) {
         return $next($request);
     }
     $ip = $_SERVER['REMOTE_ADDR'];
     $data = \SypexGeo::get($ip);
     $currency = 'BYR';
     if (isset($data['country']['iso'])) {
         switch ($data['country']['iso']) {
             case 'KZ':
             case 'RU':
                 $currency = 'RUB';
                 break;
             case 'BY':
                 $currency = 'BYR';
                 break;
                 //Euro zone countries
             //Euro zone countries
             case 'AT':
             case 'BE':
             case 'DE':
             case 'GR':
             case 'IE':
             case 'IT':
             case 'ES':
             case 'CY':
             case 'LV':
             case 'LT':
             case 'LU':
             case 'MT':
             case 'NL':
             case 'PT':
             case 'SK':
             case 'SI':
             case 'FI':
             case 'FR':
             case 'EE':
                 $currency = 'EUR';
                 break;
             case 'GB':
                 $currency = 'GBP';
                 break;
             default:
                 $currency = 'USD';
                 break;
         }
     }
     Session::put('currency', $currency);
     $isInBase = \App\Location::where('ip', $ip)->twentyFour()->first();
     if (!$isInBase) {
         \App\Location::create(['ip' => $ip]);
     }
     return $next($request);
 }

 /**
  * Handle an incoming request.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  \Closure  $next
  * @return mixed
  */
 public function handle($request, Closure $next)
 {
     $ip = $_SERVER['REMOTE_ADDR'];
     $isInBase = \App\Location::where('ip', $ip)->twentyFour()->first();
     if (!$isInBase) {
         $data = \SypexGeo::get($ip);
         $sData = serialize($data);
         $visitor = \App\Location::create(['ip' => $ip, 'content' => $sData]);
     }
     return $next($request);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     //
     $q = \Request::get('q');
     if ($q != '') {
         $locations = \App\Location::where('name', 'RLIKE', $q)->where('id', '>', 1)->paginate(200);
     } else {
         $locations = \App\Location::where('id', '>', 1)->paginate(200);
     }
     return view('locations.index', compact('locations', 'q'));
 }

 public function map($location_id)
 {
     $oLocation = Location::where('id', '=', $location_id)->first();
     if (!$oLocation) {
         return '<center><h1>Locación no valida :P</h1></center>';
     } else {
         $valores['latitude'] = (double) $oLocation->latitude;
         $valores['longitude'] = (double) $oLocation->longitude;
         $valores['date'] = $oLocation->date;
         return view('map', compact('valores'));
     }
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  Request  $request
  * @param  int  $id
  * @return Response
  */
 public function update(Request $request)
 {
     $data = $request->json()->get('data');
     $locationOld = $data[0]['locationOld'];
     $location = $data[0]['location'];
     $allowance = $data[0]['allowance'];
     $locationRec = \App\Location::where('name', $locationOld);
     if ($allowance == '') {
         $locationRec->update(['name' => $location]);
     } else {
         $locationRec->update(['name' => $location, 'capacity' => $allowance]);
     }
 }

 /**
  * Query by zipcode
  * @param  string $zipcode 5 digit zipcode - validated in route
  * @return json
  */
 public function zipcode($zipcode)
 {
     $resp = new \stdClass();
     $l = Location::where('zip', intval($zipcode))->first();
     if (null === $l) {
         return ['status' => 'error', 'message' => 'zipcode not found'];
     }
     $reps = Representative::atLocation($l);
     usort($reps, 'rankSort');
     $resp->reps = $reps;
     $resp->location = $l;
     return response()->json($resp);
 }

 /**
  * Generate Location Associate Array
  *
  * @return Array
  */
 public static function all_select($show_all = '')
 {
     $_ret = array();
     $_ret[''] = '-- location --';
     if ($show_all == 'all') {
         $_ret[1] = '** ALL **';
     }
     $locations = \App\Location::where('id', '>', 1)->get();
     foreach ($locations as $location) {
         $_ret[$location->id] = $location->name;
     }
     return $_ret;
 }

 public static function searchLocationTweets($locName, $locLat, $locLng)
 {
     $location = Location::where('latitude', '=', round($locLat, 7))->where('longitude', '=', round($locLng, 7))->first();
     $tweets = null;
     if ($location == null) {
         $location = new Location();
         $location->name = $locName;
         $location->latitude = round($locLat, 7);
         $location->longitude = round($locLng, 7);
         $locRet = $location->save();
         //save search history
         $search = new Search();
         $search->location_id = $location->id;
         $search->user = $_COOKIE['user'];
         $search->save();
         $tweets = self::getTweets($locName, round($locLat, 7), round($locLng, 7));
         //save tweets
         foreach ($tweets as $tweet) {
             $tweet->search_id = $search->id;
             $tweet->save();
         }
     } else {
         $search = Search::where('location_id', '=', $location->id)->orderBy('created_at', 'desc')->first();
         $searchTime = strtotime($search->created_at);
         //save new search
         $newSearch = new Search();
         $newSearch->location_id = $location->id;
         $newSearch->user = $_COOKIE['user'];
         $newSearch->save();
         //if search is older than 1 hour, tweet again
         if ($searchTime <= strtotime('-' . Config::get('app.cache_duration') . ' minutes')) {
             $tweets = self::getTweets($locName, round($locLat, 7), round($locLng, 7));
             //save tweets
             foreach ($tweets as $tweet) {
                 $tweet->search_id = $search->id;
                 $tweet->save();
             }
         } else {
             //get last search with tweets
             $search = DB::table('searches')->where('location_id', '=', $location->id)->whereExists(function ($query) {
                 $query->select(DB::raw(1))->from('tweets')->whereRaw('tweets.search_id = searches.id');
             })->orderBy('created_at', 'desc')->first();
             $tweets = Tweet::where('search_id', '=', $search->id)->get();
         }
     }
     return $tweets;
 }