PHP Event::select方法代码示例

 public function getCalendar()
 {
     $eventos = Event::select('titulo_evento')->where('user_id', '=', Auth::user()->id)->take(4)->get();
     //$datos['cTrabajo']= \DB::table('trabajo')->count();
     $array = Event::where('user_id', '=', Auth::user()->id)->get();
     return view('Calendar/calendar', compact('array', 'datos', 'eventos'));
 }

 public static function eventsUsuari($cultius)
 {
     if (!is_null($cultius)) {
         //	foreach ($cultius as $cultiu){
         //		dd($cultiu);
         if (!is_null($cultius)) {
             $results = Event::select('id', 'headline', 'text', 'startDate', 'cultiu_id')->where(function ($query) use($cultius) {
                 foreach ($cultius as $value) {
                     if (!is_null($value)) {
                         //you can use orWhere the first time, dosn't need to be ->where
                         $query->orWhere('cultiu_id', $value['id']);
                     }
                 }
             })->orderBy('updated_at', 'desc')->get()->toArray();
             foreach ($results as $passa) {
                 $dades[] = $passa;
             }
         }
         //}
     }
     //dd($dades);
     if (!is_null($dades)) {
         return $dades;
     }
 }

 public function events(Request $request)
 {
     if ($request->start && $request->end) {
         return Event::whereRaw("start between '" . $request->start . "' and '" . $request->end . "'")->with("order")->get();
     } else {
         return Event::select("*")->get();
     }
 }

 /**
  * Display events that require CERFs.
  *
  * @return \Illuminate\View\View
  */
 public function overview()
 {
     // Ensures only events created after implementation of online CERFs system are checked.
     $oldestAllowed = Carbon::create(2015, 11, 1, 8, 0, 0, 'UTC');
     $newestAllowed = Carbon::now();
     // Finds IDs of all events that do not have an associated approved CERF.
     $eventIdsWithoutCerfs = Event::select('events.id')->leftJoin('cerfs', 'events.id', '=', 'cerfs.event_id')->whereNull('cerfs.id')->orWhere('cerfs.approved', false)->get();
     // TODO Paginate events that need to be CERFed.
     // Retrieves events without CERFs based on ID. Casts to array to pass to foreach loop in view.
     $eventsWithoutCerfs = Event::find($eventIdsWithoutCerfs->toArray());
     $userCerfs = Cerf::where('reporter_id', Auth::id())->where('approved', false)->get();
     return view('pages.cerfs.overview', compact('eventsWithoutCerfs', 'userCerfs', 'oldestAllowed', 'newestAllowed'));
 }

 public function index()
 {
     /* Get data for timeline */
     $eventDates = \App\Event::select('timelineDate')->distinct()->get()->pluck('timelineDate')->toArray();
     $mediaDates = \App\Media::select('timelineDate')->distinct()->get()->pluck('timelineDate')->toArray();
     $dates = array_unique(array_merge($eventDates, $mediaDates), SORT_REGULAR);
     usort($dates, array('\\App\\Http\\Controllers\\TimelineController', 'dateCompare'));
     $media = array();
     $events = array();
     foreach ($dates as $date) {
         $eventsForThisDate = \App\Event::get()->where('timelineDate', $date)->toArray();
         $mediaForThisDate = \App\Media::get()->where('timelineDate', $date)->toArray();
         usort($eventsForThisDate, array('\\App\\Http\\Controllers\\TimelineController', 'itemCompare'));
         usort($mediaForThisDate, array('\\App\\Http\\Controllers\\TimelineController', 'itemCompare'));
         $media[$date] = $mediaForThisDate;
         $events[$date] = $eventsForThisDate;
     }
     /* Get data for filters */
     $mediums = \App\Media::select('medium')->distinct()->get()->pluck('medium')->toArray();
     $tags = \App\EventTag::select('tag')->distinct()->get()->pluck('tag')->toArray();
     $series = \App\Series::get()->pluck('seriesAbbreviation');
     sort($mediums);
     sort($tags);
     $eventIDToTags = array();
     $eventIDs = \App\Event::get()->pluck('id');
     foreach ($eventIDs as $eventID) {
         $eventIDToTags[$eventID] = \App\EventTag::select('tag')->where('eventID', $eventID)->get()->pluck('tag')->toArray();
     }
     $seriesToCollections = array();
     foreach ($series as $thisSeries) {
         $seriesToCollections[$thisSeries] = \App\Media::select('collection')->where('series', $thisSeries)->distinct()->get()->pluck('collection')->toArray();
     }
     /* Get event-media relationships */
     $eventMediaPairs = \App\EventMedia::get(array('eventID', 'mediaID'))->toArray();
     return view('timeline')->with(['seriesToCollections' => $seriesToCollections, 'eventMediaPairs' => $eventMediaPairs, 'eventIDToTags' => $eventIDToTags, 'mediums' => $mediums, 'events' => $events, 'dates' => $dates, 'media' => $media, 'tags' => $tags]);
 }

 public function getTittlesEvents()
 {
     $eventos = Event::select('titulo_evento')->where('user_id', '=', Auth::user()->id)->take(4)->get();
     return $eventos;
 }

 /**
  * View a list of events.
  * @return mixed
  */
 public function index()
 {
     $events = Event::select('events.*')->join('event_times', 'events.id', '=', 'event_times.event_id')->orderBy('event_times.start', 'DESC')->distinct()->distinctPaginate(15);
     $this->checkPagination($events);
     return View::make('events.index')->withEvents($events);
 }

 /**
  * Show the form for editing an existing event's info.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function editEventInfo($id)
 {
     $event = Event::select('events.*')->where('id', '=', $id)->firstorfail();
     return view('admin/edit', ['event' => $event]);
 }