Beispiel #1
0
 public function getMemberHome()
 {
     date_default_timezone_set(config::$timezone);
     $today = date("Y-m-d");
     // Holding watched movies id
     $watchedMovies = Order::where('member_id', '=', Session::get('member_id'))->select('movie_id')->get()->toArray();
     // Building query whare id = ? or id = ? so on
     $ids = 'id = ?';
     for ($i = 1; $i < count($watchedMovies); $i++) {
         $ids .= ' or id = ?';
     }
     $memberWatchedMovies = Movie::orWhereRaw($ids, $watchedMovies)->get();
     return View::make('adminArea/home/member-dashboard')->with('newMovies', Movie::orderBy('id', 'desc')->get()->take(20))->with('watchedMovies', $memberWatchedMovies);
 }