public function destroy(Request $request, $id)
{
$version = Episodever::select('user_id')->where('episode_id', $id)->where('first', 1)->first();
if ($version->user_id != $request->user()->id) {
return '抱歉, 目前仅支持添加此条目的用户删除分集> <';
}
$favorite = Epfav::select('user_id')->where('episode_id', $id)->first();
if ($favorite) {
return '抱歉, 已有人收藏本集，不能删除> <';
}
$review = Review::select('id')->where('episode_id', $id)->first();
if ($review) {
return '抱歉，已有人评论本集，不能删除> <';
}
$role = Role::select('id')->where('episode_id', $id)->first();
if ($role) {
return '抱歉，请先逐一删除SC关联后再删除本集';
}
$item = Item::select('id')->where('episode_id', $id)->first();
if ($item) {
return '抱歉，已有剧单收录本集，不能删除> <';
}
$ed = Ed::select('id')->where('episode_id', $id)->first();
if ($ed) {
return '抱歉，请先逐一删除歌曲关联后再删除本集';
}
$episode = Episode::find($id, ['id', 'drama_id']);
if ($episode->delete()) {
DB::table('users')->where('id', $version->user_id)->decrement('episodevers');
return redirect()->route('drama.show', [$episode->drama_id]);
} else {
return '删除失败';
}
}
public function edit(Request $request, $episode_id)
{
$review = Review::select('title', 'content', 'visible')->where('user_id', $request->user()->id)->where('episode_id', $episode_id)->first();
return $review;
}
public function edit(Request $request, $episode_id)
{
$episode = Episode::find($episode_id, ['id', 'drama_id', 'title']);
$drama = Drama::find($episode->drama_id, ['title']);
$user_id = $request->user()->id;
$favorite = Epfav::select('type', 'rating')->where('user_id', $user_id)->where('episode_id', $episode_id)->first();
$review = Review::select('title', 'content', 'visible')->where('user_id', $user_id)->where('episode_id', $episode_id)->first();
return view('epfav.edit', ['episode' => $episode, 'drama' => $drama, 'favorite' => $favorite, 'review' => $review]);
}
public function destroy(Request $request, $id)
{
$version = Dramaver::select('user_id')->where('drama_id', $id)->where('first', 1)->first();
if ($version->user_id != $request->user()->id) {
return '抱歉, 目前仅支持添加此条目的用户删除剧集> <';
}
$episode = Episode::select('id')->where('drama_id', $id)->first();
if ($episode) {
return '抱歉，请先逐一删除分集后再删除本剧';
}
$favorite = Favorite::select('user_id')->where('drama_id', $id)->first();
if ($favorite) {
return '抱歉, 已有人收藏本剧，不能删除> <';
}
$review = Review::select('id')->where('drama_id', $id)->first();
if ($review) {
return '抱歉，已有人评论本剧，不能删除> <';
}
$item = Item::select('id')->where('drama_id', $id)->first();
if ($item) {
return '抱歉，已有剧单收录本剧，不能删除> <';
}
$ed = Ed::select('id')->where('drama_id', $id)->first();
if ($ed) {
return '抱歉，请先逐一删除歌曲关联后再删除本剧';
}
$drama = Drama::find($id, ['id']);
if ($drama->delete()) {
return redirect('/');
} else {
return '删除失败';
}
}
public function edit(Request $request, $drama_id)
{
$drama = Drama::find($drama_id, ['id', 'title']);
$user_id = $request->user()->id;
$favorite = Favorite::select('type', 'rating', 'tags')->where('user_id', $user_id)->where('drama_id', $drama_id)->first();
$review = Review::select('title', 'content', 'visible')->where('user_id', $user_id)->where('drama_id', $drama_id)->where('episode_id', 0)->first();
$tagmaps = Tagmap::with('tag')->select(DB::raw('count(*) as count, tag_id'))->where('user_id', $request->user()->id)->groupBy('tag_id')->orderBy('count', 'desc')->take(15)->get();
return view('favorite.edit', ['drama' => $drama, 'favorite' => $favorite, 'review' => $review, 'tagmaps' => $tagmaps]);
}
