public function index()
{
$favorites = Favorite::with(['user' => function ($query) {
$query->select('id', 'name');
}, 'drama' => function ($query) {
$query->select('id', 'title');
}])->select('user_id', 'drama_id', 'type', 'updated_at')->orderBy('updated_at', 'desc')->take(50)->get();
$epfavs = Epfav::join('episodes', function ($join) {
$join->on('episodes.id', '=', 'epfavs.episode_id');
})->join('dramas', function ($join) {
$join->on('dramas.id', '=', 'episodes.drama_id');
})->select('user_id', 'drama_id', 'dramas.title as drama_title', 'episode_id', 'episodes.title as episode_title', 'epfavs.type as type', 'epfavs.updated_at as updated_at')->orderBy('epfavs.updated_at', 'desc')->take(50)->get();
$epfavs->load(['user' => function ($query) {
$query->select('id', 'name');
}]);
return view('favorite.index', ['favorites' => $favorites, 'epfavs' => $epfavs]);
}
