public function checkCourseTitle($Title)
{
$course = Courses::where('Title', '=', $Title)->get()->toArray();
if (count($course) > 0) {
return 'exist';
}
return 'notExist';
}
public function viewNewestPosts()
{
if (auth() && auth()->user() && User::find(auth()->user()->getAuthIdentifier())['admin'] >= ConstsAndFuncs::PERM_ADMIN) {
$Posts = Posts::orderBy('id', 'desc')->paginate(5);
$newpost = Posts::orderBy('visited', 'dsc')->take(5)->get();
$paginateBaseLink = '/';
return view('userindex')->with(compact(['Posts', 'newpost', 'paginateBaseLink']));
} else {
$hidden_course_ids = array();
$courses = Courses::where('Hidden', '=', 1)->get()->toArray();
foreach ($courses as $value) {
$hidden_course_ids = array_merge($hidden_course_ids, [$value['id']]);
}
$Posts = Posts::whereNotIn('CourseID', $hidden_course_ids)->where('Hidden', '=', 0)->orderBy('id', 'desc')->paginate(5);
$newpost = Posts::whereNotIn('CourseID', $hidden_course_ids)->where('Hidden', '=', 0)->orderBy('visited', 'dsc')->take(5)->get();
$paginateBaseLink = '/';
return view('userindex')->with(compact(['Posts', 'newpost', 'paginateBaseLink']));
}
}
public function toeicView()
{
$Posts = Posts::orderBy('id', 'desc')->paginate(5);
$course = Courses::where('CategoryID', '=', 4)->first();
$newpost = Posts::where('CourseID', '=', $course['id'])->orderBy('visited', 'dsc')->take(3)->get();
return view('toeic')->with(compact(['Posts', 'newpost']));
}
