public static function getAllForCategory($categoryURL, $limit = 10, $offset = 0)
{
$items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.id, i.revision_id, i.language, i.title, i.introduction, i.text, i.num_comments AS comments_count,
c.title AS category_title, m2.url AS category_url, i.image,
UNIX_TIMESTAMP(i.publish_on) AS publish_on, i.user_id, i.allow_comments,
m.url
FROM blog_posts AS i
INNER JOIN blog_categories AS c ON i.category_id = c.id
INNER JOIN meta AS m ON i.meta_id = m.id
INNER JOIN meta AS m2 ON c.meta_id = m2.id
WHERE i.status = ? AND i.language = ? AND i.hidden = ? AND i.publish_on <= ? AND m2.url = ?
ORDER BY i.publish_on DESC
LIMIT ?, ?', array('active', LANGUAGE, 'N', FrontendModel::getUTCDate('Y-m-d H:i'), (string) $categoryURL, (int) $offset, (int) $limit), 'id');
// no results?
if (empty($items)) {
return array();
}
// init var
$link = FrontendNavigation::getURLForBlock('Blog', 'Detail');
$categoryLink = FrontendNavigation::getURLForBlock('Blog', 'Category');
$folders = FrontendModel::getThumbnailFolders(FRONTEND_FILES_PATH . '/Blog/Images', true);
// loop
foreach ($items as $key => $row) {
// URLs
$items[$key]['full_url'] = $link . '/' . $row['url'];
$items[$key]['category_full_url'] = $categoryLink . '/' . $row['category_url'];
// comments
if ($row['comments_count'] > 0) {
$items[$key]['comments'] = true;
}
if ($row['comments_count'] > 1) {
$items[$key]['comments_multiple'] = true;
}
// allow comments as boolean
$items[$key]['allow_comments'] = $row['allow_comments'] == 'Y';
// reset allow comments
if (!FrontendModel::get('fork.settings')->get('Blog', 'allow_comments')) {
$items[$key]['allow_comments'] = false;
}
// image?
if (isset($row['image'])) {
foreach ($folders as $folder) {
$items[$key]['image_' . $folder['dirname']] = $folder['url'] . '/' . $folder['dirname'] . '/' . $row['image'];
}
}
}
// get all tags
$tags = FrontendTagsModel::getForMultipleItems('Blog', array_keys($items));
// loop tags and add to correct item
foreach ($tags as $postId => $data) {
$items[$postId]['tags'] = $data;
}
// return
return $items;
} /**
* Load the data, don't forget to validate the incoming data
*/
private function getData()
{
// get categories
$categories = FrontendBlogModel::getAllCategories();
$possibleCategories = array();
foreach ($categories as $category) {
$possibleCategories[$category['url']] = $category['id'];
}
// requested category
$requestedCategory = \SpoonFilter::getValue($this->URL->getParameter(1, 'string'), array_keys($possibleCategories), 'false');
// requested page
$requestedPage = $this->URL->getParameter('page', 'int', 1);
// validate category
if ($requestedCategory == 'false') {
$this->redirect(FrontendNavigation::getURL(404));
}
// set category
$this->category = $categories[$possibleCategories[$requestedCategory]];
// set URL and limit
$this->pagination['url'] = FrontendNavigation::getURLForBlock('Blog', 'Category') . '/' . $requestedCategory;
$this->pagination['limit'] = $this->get('fork.settings')->get('Blog', 'overview_num_items', 10);
// populate count fields in pagination
$this->pagination['num_items'] = FrontendBlogModel::getAllForCategoryCount($requestedCategory);
$this->pagination['num_pages'] = (int) ceil($this->pagination['num_items'] / $this->pagination['limit']);
// redirect if the request page doesn't exists
if ($requestedPage > $this->pagination['num_pages'] || $requestedPage < 1) {
$this->redirect(FrontendNavigation::getURL(404));
}
// populate calculated fields in pagination
$this->pagination['requested_page'] = $requestedPage;
$this->pagination['offset'] = $this->pagination['requested_page'] * $this->pagination['limit'] - $this->pagination['limit'];
// get articles
$this->items = FrontendBlogModel::getAllForCategory($requestedCategory, $this->pagination['limit'], $this->pagination['offset']);
}
