Exemple #1
0
 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;
 }
Exemple #2
0
 /**
  *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']);
 }