/**
* form for creating a new resource.
*
* @return Response
*/
public function feed()
{
$Movies = new MoviesController();
$critics = $Movies->getCritics(Auth::user()->id);
$home = new HomeController();
$recent = DB::table('film')->select('fl_id', 'fl_name', 'fl_image', 'fl_year', 'fl_stars', 'fl_genre', 'fl_outline', 'fl_dir_ar_id', 'fl_releasedate')->take(7)->orderBy('fl_release_date', 'desc')->whereRaw('fl_id NOT IN (select fs_fl_id from film_spotlight)')->remember(10)->get();
$other = DB::table('film')->select('fl_id', 'fl_name', 'fl_image', 'fl_year', 'fl_stars', 'fl_genre', 'fl_outline', 'fl_dir_ar_id', 'fl_releasedate')->take(7)->orderBy('fl_release_date', 'desc')->remember(10)->get();
// gets the user details fro username
$friend = DB::table('user_actions')->leftjoin('user_friends', 'user_friends.friend_user_id', '=', 'user_actions.subject_id')->join('users', 'users.id', '=', 'user_actions.subject_id')->where('follower_user_id', Auth::user()->id)->orWhere('user_actions.subject_id', '=', Auth::user()->id)->take('20')->orderBy('action_date', 'desc')->get();
return view('users.feed', compact('friend', 'critics', 'recent', 'other'));
}
public function newTest()
{
if (Auth::check()) {
$Movies = new MoviesController();
$critics = $Movies->getCritics(Auth::user()->id);
$home = new HomeController();
$recent = DB::table('film')->select('fl_id', 'fl_name', 'fl_image', 'fl_year', 'fl_stars', 'fl_genre', 'fl_outline', 'fl_dir_ar_id', 'fl_releasedate')->take(10)->orderBy('fl_release_date', 'desc')->whereRaw('fl_id NOT IN (select fs_fl_id from film_spotlight)')->get();
$other = DB::table('film')->select('fl_id', 'fl_name', 'fl_image', 'fl_year', 'fl_stars', 'fl_genre', 'fl_outline', 'fl_dir_ar_id', 'fl_releasedate')->take(20)->orderBy('fl_release_date', 'desc')->get();
// gets the user details fro username
$friends = DB::table('user_actions')->leftjoin('user_friends', 'user_friends.friend_user_id', '=', 'user_actions.subject_id')->join('users', 'users.id', '=', 'user_actions.subject_id')->where('follower_user_id', Auth::user()->id)->take('40')->orderBy('action_date', 'desc')->get();
$User = new UsersController();
$following = $User->getFollowing(Auth::user()->id);
$column = array();
foreach ($following as $following) {
$column[] = $following->id;
}
if ($following) {
$friend = DB::table('user_actions')->join('users', 'users.id', '=', 'user_actions.subject_id')->wherein('user_actions.subject_id', $column)->orWhere('user_actions.subject_id', Auth::user()->id)->take('40')->orderBy('action_date', 'desc')->get();
} else {
$friend = DB::table('user_actions')->join('users', 'users.id', '=', 'user_actions.subject_id')->orWhere('user_actions.subject_id', Auth::user()->id)->take('40')->orderBy('action_date', 'desc')->get();
}
return view('users.feed', compact('friend', 'critics', 'recent', 'other'));
} else {
$Movies = new MoviesController();
$critics = array();
$home = new HomeController();
$recent = DB::table('film')->select('fl_id', 'fl_name', 'fl_image', 'fl_year', 'fl_stars', 'fl_genre', 'fl_outline', 'fl_dir_ar_id', 'fl_releasedate')->take(10)->orderBy('fl_release_date', 'desc')->whereRaw('fl_id NOT IN (select fs_fl_id from film_spotlight)')->get();
$other = DB::table('film')->select('fl_id', 'fl_name', 'fl_image', 'fl_year', 'fl_stars', 'fl_genre', 'fl_outline', 'fl_dir_ar_id', 'fl_releasedate')->take(20)->orderBy('fl_release_date', 'desc')->get();
// gets the user details fro username
$friends = DB::table('user_actions')->leftjoin('user_friends', 'user_friends.friend_user_id', '=', 'user_actions.subject_id')->join('users', 'users.id', '=', 'user_actions.subject_id')->take('40')->orderBy('action_date', 'desc')->get();
$review = DB::table('film_review')->join('film', 'film.fl_id', '=', 'film_review.fr_fl_id')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->take('6')->get();
return View::make('new', compact('review', 'critics', 'recent', 'other'));
}
}