public function involve() { //参与话题内容 $join_id = Input::get('join_id'); $article_join = ArticleJoin::find($join_id); if (!isset($article_join)) { return Response::json(array('errCode' => 1, 'message' => '没有该参与话题内容!')); } $article_join_parts = ArticleJoinPart::where('join_id', '=', $join_id)->orderBy('id', 'asc')->get(); foreach ($article_join_parts as $part) { if ($part->type == 'url') { $part->img = StaticController::imageWH($part->content); } } //评论内容 $per_page = Input::get('per_page'); $page = Input::get('page'); $join_coms = ArticleJoinCom::where('join_id', '=', $join_id)->with(['replies' => function ($query) { $query->select('com_id', 'content', 'sender_id')->orderBy('id', 'asc'); }, 'sender' => function ($query) { $query->select('id', 'username', 'avatar'); }, 'replies.sender' => function ($query) { $query->select('id', 'username'); }])->get(); foreach ($join_coms as $join_com) { $user = $join_com->sender; $join_com->username = $user->username; $join_com->avatar = $user->avatar; $join_com->replys = $join_com->replies; if (count($join_com->replys) != 0) { foreach ($join_com->replys as $reply) { // dd($reply); $reply->reply_name = $reply->sender->username; unset($reply->sender); } } unset($join_com->replies); unset($join_com->sender); } // //总页数 $total = ceil(count($join_coms) / $per_page); // //文章 $join_coms = StaticController::page($per_page, $page, $join_coms); // $join_coms = DB::table('article_join_coms')->where('join_id', '=', $join_id)->get(); // //总页数 // $total = ceil(count($join_coms)/$per_page); // //文章 // $join_coms = StaticController::page($per_page,$page,$join_coms); // if( $join_coms ) // { // foreach($join_coms as $join_com) // { // $join_com->username = User::find($join_com->sender_id)->username; // $join_com->avatar = User::find($join_com->sender_id)->avatar; // $join_com->replys = ArticleJoinReply::where('com_id', '=', $join_com->id)->orderBy('id','asc')->get(); // if(count($join_com->replys)!=0) // { // foreach($join_com->replys as $reply) // { // $reply->reply_name = User::find($reply->sender_id)->username; // } // } // } // } //是否喜欢 $type = $this->isJoinLike($join_id); if ($page == 1) { return Response::json(array('errCode' => 0, 'message' => '返回参与话题详情', 'article_join' => $article_join, 'article_join_parts' => $article_join_parts, 'join_coms' => $join_coms, 'total' => $total, 'type' => $type)); } else { return Response::json(array('errCode' => 0, 'message' => '返回参与话题详情', 'join_coms' => $join_coms, 'total' => $total, 'type' => $type)); } }
public function dArticle() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); $join_id = Input::get('join_id'); $article_join = ArticleJoin::find($join_id); if (!isset($article_join)) { return Response::json(array('errCode' => 2, 'message' => '你想删除的参与话题不存在!')); } if ($user->id != $article_join->user_id) { return Response::json(array('errCode' => 3, 'message' => ' [权限不够]不可删除他人的参与话题!')); } try { DB::transaction(function () use($article_join) { //话题参与人数减1 $article = Article::find($article_join->article_id); $article->join_num = $article->join_num - 1; $article->save(); $article_join->delete(); }); } catch (\Exception $e) { return Response::json(array('errCode' => 11, 'message' => '操作失败')); } return Response::json(array('errCode' => 0, 'message' => '参与话题删除成功!')); }
public function joinCollection() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } // Sentry::login(Sentry::findUserById(5), false); $join_id = Input::get('join_id'); $join_focus = DB::table('join_focus')->where('user_id', '=', Sentry::getUser()->id)->where('join_id', '=', $join_id)->first(); if (count($join_focus) == 1) { try { DB::transaction(function () use($join_id, $join_focus) { //参与话题收藏条数减1 $article_join = ArticleJoin::find($join_id); $article_join->focus_num = $article_join->focus_num - 1; $article_join->save(); $join_focus = DB::table('join_focus')->where('user_id', '=', Sentry::getUser()->id)->where('join_id', '=', $join_id); $join_focus->delete(); }); } catch (\Exception $e) { return Response::json(array('errCode' => 11, 'message' => '操作失败')); } return Response::json(array('errCode' => 0, 'message' => '取消收藏成功!')); } else { try { DB::transaction(function () use($join_id) { //参与话题收藏条数加1 $article_join = ArticleJoin::find($join_id); $article_join->focus_num = $article_join->focus_num + 1; $article_join->save(); $join_focus = new JoinFocus(); $join_focus->user_id = Sentry::getUser()->id; $join_focus->join_id = $join_id; $join_focus->save(); }); } catch (\Exception $e) { return Response::json(array('errCode' => 11, 'message' => '操作失败')); } return Response::json(array('errCode' => 0, 'message' => '收藏成功!')); } }
public function joinDetail() { //参与话题内容 $join_id = Input::get('join_id'); $article_join = ArticleJoin::find($join_id); if (!isset($article_join)) { return Response::view('errors.missing'); } $article_join_parts = ArticleJoinPart::where('join_id', '=', $join_id)->orderBy('id', 'asc')->get(); $type = $this->isJoinLike($join_id); $user = User::find($article_join->user_id); $article_join->avatar = $user->avatar; $article_join->username = $user->username; $article_join->article_title = Article::find($article_join->article_id)->title; return View::make('pc.discuss')->with(array('article_join' => $article_join, 'article_join_parts' => $article_join_parts, 'type' => $type)); }