public function edit($title)
{
$this->middleware('auth');
$article_seo_url = addslashes(strip_tags($title));
$article = Article::with('author', 'articleImages')->where('seo_url', $article_seo_url)->first();
return view('article.edit', ['article' => $article]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$tags = Tag::lists("name", "id");
$article = Article::with("tags")->find($id);
$categories = Category::lists("name", "id");
// dd($article->tags->lists("id"));
return view("dashboard.articles.edit", compact("article", "categories", "tags"));
}
public function index()
{
$articles = Article::with('comment')->select(['id', 'title', 'tag', 'view', 'introduction', 'updated_at', 'created_at'])->whereNull('deleted_at')->paginate(1);
foreach ($articles as $v) {
$v->last_reply = $v->comment->max('created_at');
}
return view('user.article.index')->with('articles', $articles)->with('tops', ArticleController::getTop10());
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
if ($result = check_auth_to('WZGL_INDEX')) {
return $result;
}
$site = Config::get('site');
$data['articleList'] = Article::with('articleUser')->paginate($site['page_size']);
return view('admin.article.index', $data);
}
/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//banner
$banners = Banner::orderBy('created_at', 'DESC')->take(7)->get();
//最新
$last_articles = Article::with('author')->orderBy('created_time', 'DESC')->take(12)->get();
$hot_articles = Article::orderBy('views', 'DESC')->take(10)->get();
return view('home', compact('banners', 'last_articles', 'hot_articles'));
}
public function index()
{
$user_id = \Auth::user()->id;
$articles = Article::with('comment')->select(['id', 'title', 'tag', 'view', 'introduction', 'updated_at', 'created_at'])->where('user_id', $user_id)->where('status', config('DbStatus.article.status'))->paginate(1);
foreach ($articles as $v) {
$v->tag = str_replace('，', ',', $v->tag);
$v->last_reply = $v->comment->max('created_at');
}
return view('user.user')->with('articles', $articles)->with('tops', ArticleController::getTop10());
}
/**
* 获取最新文章列表
* @return array
*/
public static function getNewArticleList()
{
$page = Input::get('page', 1);
if (empty($articles = Cache::tags(self::REIDS_NEW_ARTICLE_CACHE)->get(self::REIDS_NEW_ARTICLE_CACHE . $page))) {
$articles = Article::with('articleUser')->orderBy('id', 'desc')->paginate(config('site')['article_list_count']);
//文章列表（最新）
Cache::tags(self::REIDS_NEW_ARTICLE_CACHE)->put(self::REIDS_NEW_ARTICLE_CACHE . $page, $articles, config('site')['redis_cache_time']);
}
return $articles;
}
public function cate($cate = null)
{
$cateId = DB::table('article_categories')->select('id')->where('title', $cate)->first();
if (is_null($cateId)) {
return $this->tagList();
}
if ($cate != null) {
$articles = Article::with('comment')->select(['id', 'title', 'tag', 'view', 'introduction', 'updated_at', 'created_at'])->whereNull('deleted_at')->where('category_id', $cateId->id)->paginate(10);
} else {
return $this->tagList();
}
$list = array();
foreach ($articles as $v) {
$v->tag = str_replace('，', ',', $v->tag);
$list = array_merge($list, explode(',', $v->tag));
$v->last_reply = $v->comment->max('created_at');
}
$tags = array_unique($list);
return view('home.cateList')->with('articles', $articles)->with('tags', $tags)->with('tops', ArticleController::getTop10());
}
public function show($id)
{
Article::where('id', $id)->increment('views');
//阅读量加1
$article = Article::with(['comments' => function ($query) {
$query->take(10);
}])->find($id);
// dd($article);
$views = Article::where('author_id', $article->author_id)->where('author_type', $article->author_type)->sum('views');
$comments_count = Comment::where('article_id', $id)->count();
$hots = Article::orderBy('views', 'desc')->take(10)->get();
$is_like = false;
$is_collection = false;
$is_follow = false;
if ($this->login_user) {
$is_like = Like::where('user_id', $this->login_user->id)->where('like_type', 'article')->where('like_id', $id)->first();
$is_collection = Collection::where('user_id', $this->login_user->id)->where('collection_type', 'article')->where('collection_id', $id)->first();
$is_follow = DB::table('user_follow')->where('user_id', $this->login_user->id)->where('follow_id', $article->author_id)->first();
}
return view('front.article.index', compact('article', 'views', 'comments_count', 'hots', 'is_like', 'is_collection', 'is_follow'));
}
public function index()
{
$articles = Article::with(['articleImages', 'type', 'author'])->orderBy('created_at', 'DESC')->paginate(30);
if (Request::isMethod('get')) {
$whereConditions = [];
if (!empty(Input::all())) {
foreach (Input::all() as $key => $input) {
if (!empty($input) && $key != 'page' && $key != '_token') {
$whereConditions[$key] = $input;
}
}
$articles = Article::with(['articleImages', 'type', 'author'])->where($whereConditions)->paginate(30);
} else {
$articles = Article::with(['articleImages', 'type', 'author'])->orderBy('created_at', 'DESC')->paginate(30);
}
} else {
$articles = Article::with(['articleImages', 'type', 'author'])->orderBy('created_at', 'DESC')->paginate(30);
}
Request::flash();
return view('admin.post.index')->with(['articles' => $articles])->withInput(Input::all());
}
public function comments($article_id)
{
$article = Article::with('comments')->find($article_id);
return view('dashboard.article.comments', compact('article'));
}
public function blog($title)
{
$selectedPostType = addslashes($title);
$postCategoryName = ArticleTypes::where(['seo_url' => $selectedPostType])->first();
if (!$postCategoryName) {
return redirect('/');
}
$articles = Article::with('type')->whereHas('type', function ($query) use($selectedPostType) {
$query->where(['seo_url' => $selectedPostType]);
})->with('author')->paginate(5);
$popular = Article::with('type')->whereHas('type', function ($query) use($selectedPostType) {
$query->where(['seo_url' => $selectedPostType]);
})->with('author')->orderBy('viewed')->take(5)->get()->toArray();
//$popular = Article::with(['author','type'])->where(['seo_url' => $title])->orderBy('viewed')->take(5)->get()->toArray();
return view('blog.bloghome', ['articles' => $articles, 'popular' => $popular, 'postCategoryName' => $postCategoryName]);
}
