public function loadEvents() { $MyEvents = []; if ($this->usePermissions) { $this->loadPermissions(); $query = MyEvents::whereIn('id', CategorysEvents::whereIn('category_id', Category::whereIn('permission_id', $this->permarray)->lists('id'))->lists('event_id'))->whereNotIn('id', CategorysEvents::whereIn('category_id', Category::where('permission_id', Settings::get('deny_perm'))->lists('id'))->lists('event_id'))->published(); } else { $query = MyEvents::published(); } $events = $query->past($this->dayspast)->future($this->daysfuture)->orderBy('date')->orderBy('time')->get(); $maxLen = $this->property('title_max', 100); $linkPage = $this->property('linkpage', ''); foreach ($events as $e) { $title = strlen($e->text) > 50 ? substr(strip_tags($e->text), 0, $maxLen) . '...' : $e->text; $link = $e->link ? $e->link : ($linkPage ? Page::url($linkPage, ['slug' => $e->id]) : '#EventDetail" data-request="onShowEvent" data-request-data="evid:' . $e->id . '" data-request-update="\'Events::details\':\'#EventDetail\'" data-toggle="modal" data-target="#myModal'); $MyEvents[$e->year][$e->month][$e->day][] = ['name' => $e->name . ' ' . $e->human_time, 'title' => $title, 'link' => $link, 'id' => $e->id, 'owner' => $e->user_id]; } return $MyEvents; }