public function showList()
{
$count = Post::count();
$posts = Post::orderBy('created_at', 'DESC')->take(6)->get();
return view('list', ['count' => $count, 'posts' => $posts]);
//будет использоваться list.blade.php
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index($current_page)
{
$current_page = $current_page ? $current_page : 1;
$current_page = $current_page - 1;
$page = 10;
//echo $current_page*$page;exit;
$post = Post::leftJoin('websites', 'posts.website', '=', 'websites.websites_id')->leftJoin('projects', 'posts.project', '=', 'projects.projects_id')->orderby('posts_id', 'desc')->offset($current_page * $page)->limit($page);
$posts['data'] = $post->get();
$posts['count'] = Post::count();
$posts['pageSize'] = $page;
return response()->json($posts);
}
public function index()
{
$postsPerPage = $this->_config('posts_on_index');
// Way 1
// Define which get method to use to fetch Posts by checking ACL
// Use that function and the Model's logic to get those posts.
$unpub = $this->user->hasAccess('blog read unpublished');
$method = $unpub ? 'newest' : 'newestPublished';
$posts = models\Post::$method($postsPerPage);
// The quick 'n dirty //
$page = Options::one($_GET, 'page', 1, false);
$start = ($page - 1) * $postsPerPage;
$conditions = $unpub ? '1' : 'is_published = 1';
$posts = models\Post::all($conditions . ' ORDER BY created_on DESC LIMIT ' . $start . ', ' . $postsPerPage . '');
// Don't do it! //
// Way 2
// Define the difference in conditions here (instead of in the Model)
$conditions = $unpub ? '' : array('is_published' => true);
$numAllPosts = models\Post::count($conditions);
// Way 3
// A third way would be a combination like this:
/*
$access = $this->user->hasAccess('blog read unpublished');
$posts = model\Post::postsByAccess($access, $this->_config('posts_on_index'));
*/
// That way you can check access in the Controller and have fetch logic in the Model
$messages = Session::messages();
$canCreatePosts = $this->user->hasAccess('blog create posts');
return get_defined_vars();
// view will be rendered by row\Controller->_post_action
return $this->_display(__METHOD__, get_defined_vars(), !$this->AJAX);
// view will be rendered by Output->display
return $this->_display(get_defined_vars());
// view will be rendered by Output->display
}
public function getNumPosts()
{
return \app\models\Post::count(array('author_id' => $this->user_id));
}
public function numPosts()
{
return Post::count(array('category_id' => $this->category_id));
}
/**
* Dashboard index.
*
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function index()
{
$postsCount = Post::count();
$commentsCount = Comment::whereSeen(0)->count();
return view('back.index', compact('postsCount', 'commentsCount'));
}
