public function joinArticle() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); // $user = User::find(1); //分页 $per_page = Input::get('per_page'); $page = Input::get('page'); $article_joins = ArticleJoin::where('user_id', '=', $user->id)->orderBy('created_at', 'desc')->get(); //总页数 $total = ceil(count($article_joins) / $per_page); //参与话题 $article_joins = StaticController::page($per_page, $page, $article_joins); if ($article_joins == false) { return Response::json(array('errCode' => 0, 'message' => '没有参与话题', 'articles' => array(), 'total' => 0)); } //根据用户参与的话题取到官方话题 $articles = array(); foreach ($article_joins as $article_join) { $article = Article::where('id', '=', $article_join->article_id)->first(); array_push($articles, $article); } //去掉重复值 array_unique($articles); //取到每个话题的图片和首段文字 foreach ($articles as $article) { $article_url = ArticlePart::where('article_id', '=', $article->id)->where('type', '=', 'url')->orderBy('id', 'asc')->first(); if (isset($article_url)) { $article->img = StaticController::imageWH($article_url->content); } $article_text = ArticlePart::where('article_id', '=', $article->id)->where('type', '=', 'text')->orderBy('id', 'asc')->first(); if (isset($article_text)) { $article->content = $article_text->content; } } return Response::json(array('errCode' => 0, 'message' => '返回参与话题的内容!', 'articles' => $articles, 'total' => $total)); }