public function index() { $user = auth()->getUser(); $request = Request::createFromGlobals(); $articles = Model\Portal\Article::withPrivate()->published()->contributor($user->id)->latest('date')->get(); $drafts = Model\Portal\Article::withPrivate()->onlyDrafts()->contributor($user->id)->latest('date')->get(); $toptenarticles = Model\Portal\Article::groupBy('contributor_id')->orderBy('contributor_id', 'desc')->take(10)->get(); $data['toptenarticlecount'] = Model\Portal\Article::selectRaw('count(`contributor_id`) as `occurences`')->groupBy('contributor_id')->orderBy('contributor_id', 'desc')->take(10)->get(); $draftcount = $drafts->count(); $courses = Model\Kelas\Course::latest()->get(); $myclasscourse = Model\Kelas\CourseMember::where('user_id', $user->id)->has('course')->get(); $coursecomments = Model\Kelas\CourseComment::where('parent', '0')->has('course')->get(); $toptenactiveclass = Model\Kelas\CourseMember::groupBy('user_id')->orderBy('user_id', 'desc')->take(10)->get(); $data['toptenactiveclasscount'] = Model\Kelas\CourseMember::selectRaw('count(`user_id`) as `counttotal`')->groupBy('user_id')->orderBy('user_id', 'desc')->take(10)->get(); /* Start Activity Konsultasi */ $data['konsultasiCat'] = $this->Mod_konsultasi->getKonsultasiKategori(); $data['latestReply'] = $this->Mod_konsultasi->getLatestReply($user->id); $konsultasi = collect($this->Mod_konsultasi->getKonsultasi($user->id)); $data['latestKonsultasi'] = $konsultasi; /* End Activity Konsultasi */ $category = $this->medialib->getCategory(); $categories = $category->with(['media' => function ($query) { $query->userId(sentinel()->getUser()->id)->withDrafts(); }])->get(); $data['categories'] = $categories; $data['categories_checkbox'] = (new Model\Portal\Category())->generateCheckbox(); $data['artikel'] = pagination($articles, 4, 'dashboard/my-article'); $data['drafts'] = $drafts; $data['draftcount'] = $draftcount; $data['links'] = $this->Mod_link->read(); $data['toptenarticles'] = $toptenarticles; $data['toptenactiveclass'] = $toptenactiveclass; $data['courses'] = $courses; $data['myclasscourse'] = $myclasscourse; $data['coursecomments'] = $coursecomments; $data['forumNotif'] = $this->Mod_forum->getMemberNotif($user->id); $data['forumCategories'] = $this->Mod_forum->getCategoryMember($user->id); $latestComment = $this->Mod_forum->getLatestComment($user->id); $data['forumLatestComment'] = $latestComment; if (!empty($latestComment)) { foreach ($latestComment as $latest) { $data['threadLatestComment'] = $this->Mod_forum->threadLatestComment($latest->reply_to); } } $data['allThreads'] = $this->Mod_forum->allThreads($user->id); $listNewThreadComments = array(); if (!empty($data['allThreads'])) { foreach ($data['allThreads'] as $thr) { $listNewThreadComments[] = $thr->id; } $data['newThreadComments'] = $this->Mod_forum->newComments($listNewThreadComments); } // START: Recent activity elibrary $data['recentMedia'] = $this->medialib->onlyUserId($user->id)->latestById()->slice(0, 5); // END: Recent activity elibrary $data['recentMedia'] = $this->medialib->onlyUserId($user->id)->latestById()->slice(0, 5); $data['recentArticleComment'] = $this->Mod_artikel->getRecentComment($user->id); $this->template->set('sidebar'); $this->template->set_layout('privatepage'); $this->template->build('index', $data); }