public function getCalendarTopList($iLimit = 4) { if (isset($this->aCachedCalendarEvents['limit' . $iLimit]) && $this->aCachedCalendarEvents['limit' . $iLimit] != null) { return $this->aCachedCalendarEvents['limit' . $iLimit]; } $nSubsiteID = $this->EditingSubsite; $oCalendarEvents = CalendarEvent::get()->where('SubsiteID = ' . $nSubsiteID . ' AND StartDate >= CURDATE()')->limit($iLimit)->sort('StartDate ASC'); // alle nieuwsitems worden meteen gepublished dus daar hoeven we niet op te filteren if (!$oCalendarEvents) { return false; } $this->aCachedCalendarEvents['limit' . $iLimit] = $oCalendarEvents; return $this->aCachedCalendarEvents['limit' . $iLimit]; }
/** * Display a listing of the resource. * * @return Response */ public function index() { /*CalendarEvent is the Class name in CalendarEvent model*/ $query = new CalendarEvent(); $search = Input::get('search'); if (Input::has('search')) { $query->where('title', 'like', '%' . $search . "%")->orWhere('description', 'like', '%' . $search . "%"); /* ->orWhereHas('tag', function($q) use ($name){ $q->where('name', 'like', '%' . $search . "%") }*/ /* ->orWhereHas('user', function($q) use ($search){ $q->where('first_name', 'like', '%' . $search . "%") ->orWhere('last_name', 'like', '%' . $search . "%"); });*/ } //display a listing of calendar events $calendar_events = $query->orderBy('start_date_time', 'desc')->paginate(10); $calendar_events = $query->get(); /*->orderBy('start_date_time', 'desc')->paginate(10) // dd($calendar_events); /* compact() is a PHP function. It creates an array containing variables and their values*/ return View::make('calendar_events.index', compact('calendar_events')); /*return View::make('calendar_events.index')->with('calendar_events', $calendar_events);*/ }
/** * Getter for registration link */ public function getAttendanceLink() { $detailStr = 'attendance/' . $this->owner->ID; $event = CalendarEvent::get()->First(); return $event->Link() . $detailStr; }