function get_images($id = false) { if ($id) { $query = Self::join('media_resized_new as media', 'regpage_images.media_id', '=', 'media.media_id')->where('media.image_type', 'registration')->where('id', $id)->get(); $result = $query->toArray(); } else { $query = Self::join('media_resized_new as media', 'regpage_images.media_id', '=', 'media.media_id')->where('media.image_type', 'registration')->get(); $result = $query->toArray(); } return $result; }
/** *Get the showable news for foundation */ protected static function classShowable() { return Self::join('users', 'news.creator_id', '=', 'users.id')->join('students', 'students.user_id', '=', 'users.id')->where('level', self::$levels['class'])->where('students.course_school_id', Auth::user()->details->course_school_id)->get(['news.id', 'news.title', 'news.level', 'news.creator_id', 'news.created_at', 'news.updated_at', 'news.content']); }