Exemplo n.º 1
0
 public function epfavs(Request $request, $id, $type)
 {
     if ($request->has('sort')) {
         $sort = $request->input('sort');
     } else {
         $sort = 'updated_at';
     }
     $favorites = Epfav::with(['episode' => function ($query) {
         $query->join('dramas', 'dramas.id', '=', 'episodes.drama_id')->select('episodes.id as id', 'dramas.title as dramaTitle', 'episodes.title as title', 'dramas.sc as cv', 'episodes.duration as duration');
     }])->select('episode_id', 'type', 'rating', 'updated_at')->where('user_id', $id)->where('type', $type)->orderBy($sort, 'desc')->simplePaginate(20);
     return $favorites;
 }
Exemplo n.º 2
0
 public function favorites($id)
 {
     $episode = Episode::find($id, ['id', 'drama_id', 'title']);
     $drama = Drama::find($episode->drama_id, ['title']);
     $favorites = Epfav::with(['user' => function ($query) {
         $query->select('id', 'name');
     }])->select('user_id', 'type', 'updated_at')->where('episode_id', $id)->orderBy('updated_at')->paginate(20);
     return view('episode.favorites', ['episode' => $episode, 'drama' => $drama, 'favorites' => $favorites]);
 }
Exemplo n.º 3
0
 public function epfavs(Request $request, $id, $type)
 {
     $user = User::find($id, ['id', 'name']);
     if ($request->has('sort')) {
         $sort = $request->input('sort');
     } else {
         $sort = 'updated_at';
     }
     $favorites = Epfav::with(['episode' => function ($query) {
         $query->join('dramas', 'dramas.id', '=', 'episodes.drama_id')->select('episodes.id as id', 'drama_id', 'dramas.title as drama_title', 'episodes.title as title', 'dramas.sc as cv', 'episodes.duration as duration');
     }])->select('episode_id', 'type', 'rating', 'updated_at')->where('user_id', $id)->where('type', $type)->orderBy($sort, 'desc')->paginate(20);
     return view('user.epfavs', ['user' => $user, 'type' => $type, 'favorites' => $favorites, 'sort' => $sort]);
 }