public function create(Request $request)
{
$this->validate($request, ['ftep' => 'required']);
$ftep = Ftep::find($request->input('ftep'), ['id', 'ft_id', 'title']);
$ft = Ft::find($ftep->ft_id, ['title']);
return view('ftepfav.create', ['ftep' => $ftep, 'ft' => $ft]);
}
public function create(Request $request)
{
if ($request->has('ftep')) {
return view('ftrev.create', ['ft' => Ft::find($request->input('ft'), ['id', 'title']), 'ftep' => Ftep::find($request->input('ftep'), ['id', 'title'])]);
} else {
return view('ftrev.create', ['ft' => Ft::find($request->input('ft'), ['id', 'title'])]);
}
}
public function destroy(Request $request, $id)
{
$version = Ftver::select('user_id')->where('ft_id', $id)->where('first', 1)->first();
if ($version->user_id != $request->user()->id) {
return '抱歉, 目前仅支持添加此条目的用户删除节目> <';
}
$ftep = Ftep::select('id')->where('ft_id', $id)->first();
if ($ftep) {
return '抱歉，请先逐一删除分集后再删除本节目';
}
$favorite = Ftfav::select('user_id')->where('ft_id', $id)->first();
if ($favorite) {
return '抱歉, 已有人收藏请先逐一删除分集后再删除本节目，不能删除> <';
}
$review = Ftrev::select('id')->where('ft_id', $id)->first();
if ($review) {
return '抱歉，已有人评论节目，不能删除> <';
}
$ft = Ft::find($id, ['id']);
if ($ft->delete()) {
return redirect('/');
} else {
return '删除失败';
}
}
public function zhoubian()
{
$newsongs = Song::select('id', 'title', 'alias', 'artist')->orderBy('id', 'desc')->take(15)->get();
$songrevs = Songrev::with(['user' => function ($query) {
$query->select('id', 'name');
}, 'song' => function ($query) {
$query->select('id', 'title');
}])->orderBy('id', 'desc')->take(10)->get();
$hotrevsongs = Songrev::with(['song' => function ($query) {
$query->select('id', 'title', 'artist');
}])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as review_count, song_id'))->groupBy('song_id')->orderBy('review_count', 'desc')->take(15)->get();
$hotfavsongs = Songfav::with(['song' => function ($query) {
$query->select('id', 'title', 'artist');
}])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as favorite_count, song_id'))->groupBy('song_id')->orderBy('favorite_count', 'desc')->take(15)->get();
$newcreatedfteps = Ftep::with(['ft' => function ($query) {
$query->select('id', 'title', 'host');
}])->select('id', 'ft_id', 'title', 'release_date')->orderBy('id', 'desc')->take(10)->get();
$ftrevs = Ftrev::with(['user' => function ($query) {
$query->select('id', 'name');
}, 'ft' => function ($query) {
$query->select('id', 'title');
}, 'ftep' => function ($query) {
$query->select('id', 'title');
}])->orderBy('id', 'desc')->take(10)->get();
$hotrevfts = Ftrev::with(['ft' => function ($query) {
$query->select('id', 'title');
}])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as review_count, ft_id'))->groupBy('ft_id')->orderBy('review_count', 'desc')->take(10)->get();
$hotfavfts = Ftfav::with(['ft' => function ($query) {
$query->select('id', 'title');
}])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as favorite_count, ft_id'))->groupBy('ft_id')->orderBy('favorite_count', 'desc')->take(10)->get();
$todaylives = Live::select('id', 'title', 'showtime')->whereRaw('date(showtime) = curdate()')->orderBy('showtime')->get();
$newlives = Live::select('id', 'title', 'showtime')->orderBy('id', 'desc')->take(15)->get();
$liverevs = Liverev::with(['user' => function ($query) {
$query->select('id', 'name');
}, 'live' => function ($query) {
$query->select('id', 'title', 'showtime');
}])->orderBy('id', 'desc')->take(10)->get();
$hotrevlives = Liverev::with(['live' => function ($query) {
$query->select('id', 'title', 'showtime');
}])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as review_count, live_id'))->groupBy('live_id')->orderBy('review_count', 'desc')->take(15)->get();
$hotfavlives = Livefav::with(['live' => function ($query) {
$query->select('id', 'title', 'showtime');
}])->where('created_at', '>=', date("Y-m-d H:i:s", strtotime("-30 day")))->select(DB::raw('count(*) as favorite_count, live_id'))->groupBy('live_id')->orderBy('favorite_count', 'desc')->take(15)->get();
return view('zhoubian', ['newsongs' => $newsongs, 'songrevs' => $songrevs, 'hotrevsongs' => $hotrevsongs, 'hotfavsongs' => $hotfavsongs, 'newcreatedfteps' => $newcreatedfteps, 'ftrevs' => $ftrevs, 'hotrevfts' => $hotrevfts, 'hotfavfts' => $hotfavfts, 'todaylives' => $todaylives, 'newlives' => $newlives, 'liverevs' => $liverevs, 'hotrevlives' => $hotrevlives, 'hotfavlives' => $hotfavlives]);
}
public function favorites($id)
{
$ftep = Ftep::find($id, ['id', 'ft_id', 'title']);
$ft = Ft::find($ftep->ft_id, ['id', 'title']);
$favorites = Ftepfav::with(['user' => function ($query) {
$query->select('id', 'name');
}])->select('user_id', 'created_at')->where('ftep_id', $id)->orderBy('created_at')->paginate(20);
return view('ftep.favorites', ['ftep' => $ftep, 'ft' => $ft, 'favorites' => $favorites]);
}