/**
* 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'));
}
/**
* Lists the inserted articles
* either by id, title or none.
*
* @param int $id
* @param str $title
* @param int $limit
*
* @throws Illuminate\Database\Eloquent\ModelNotFoundException
*
* @return array
**/
public function listArticles($id = null, $title = null, $limit = 20)
{
$query = Article::orderBy('created_at');
if ($id) {
return Article::findOrFail($id);
}
if ($title) {
return $query->where('title', 'LIKE', '%' . $title . '%')->paginate($limit)->items();
}
return $query->paginate($limit)->items();
}
public function index()
{
$collection = Article::orderBy('updated_at')->get();
// dd($collection);
$collection->each(function ($model) {
// var_dump($model->id);
$model = $this->handleModelIndex($model);
});
// dd($collection->toArray());
return $collection;
}
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'));
}
/**
* display articles
*/
public function all()
{
$articles = Article::orderBy('published_at', 'desc')->simplePaginate(7);
return view('backend.articles', ['articles' => $articles, 'load_js' => 'backend/article.list']);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return view('backend.article.index')->with(['items' => Article::orderBy('updated_at', 'desc')->paginate(20)]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$posts = Article::orderBy('created_at', 'DESC')->paginate(5);
$data = compact('posts');
return view('blog\\blog', $data);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$articles = Article::orderBy('date_created', 'DESC')->paginate(20);
return view('admin.articles.index', ['articles' => $articles]);
}
$data = \App\Models\Articles::where('id', '=', 11)->first();
$data->article_title = 'update test -3-.';
$data->feature = true;
$data->save();
}]);
Route::get('delete', ['as' => 'ORM.delete', function () {
$data = \App\Models\Articles::find(2);
$data->delete();
\App\Models\Articles::destroy(19, 20);
}]);
});
Route::get('test', function () {
// $data = \App\Models\Article::find(5);
$data1 = \App\Models\Article::all();
$data2 = \App\Models\Article::where('id', '>', 8);
$data3 = \App\Models\Article::orderBy('id', 'DESC');
dd([$data1, $data2, $data3]);
});
/*
Route::get('hello', function(){
return "Hello World!";
});
Route::get('post/{id}', function($id) {
return "id:".$id;
})->where('id', '[0-9]+');
// route name
Route::get('post2/{id?}', ['as' => 'post2.show', function($id = 0) {
return "id:".$id;
}])->where('id', '[0-9]+');
public function index()
{
$articles = Article::orderBy('published_at', 'desc')->simplePaginate(7);
return view('index', ['articles' => $articles]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$articles = Article::orderBy("id", "DESC")->paginate(20);
return view("dashboard.articles.index", compact("articles"));
//->with("message", $message);
}
/**
* Override index here because we want every article in the system
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$articles = Article::orderBy('id', 'desc')->paginate(15);
return view('admin.article.index', compact('articles'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$articles = Article::orderBy('id', 'ASC')->paginate(15);
return view('admin/articles/index')->with('articles', $articles);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$articles = Article::orderBy('created_at', 'desc')->take(10)->get();
return view('articles.index')->with('articles', $articles);
}
