/**
* Fetch the list of tags for a list of items
*
* @param array $ids The ids of the items to grab.
* @return array
*/
public static function getForTags(array $ids)
{
// fetch items
$items = (array) FrontendModel::getDB()->getRecords('SELECT i.title, m.url
FROM blog_posts AS i
INNER JOIN meta AS m ON m.id = i.meta_id
WHERE i.status = ? AND i.hidden = ? AND i.id IN (' . implode(',', $ids) . ')
ORDER BY i.publish_on DESC', array('active', 'N'));
// has items
if (!empty($items)) {
// init var
$link = FrontendNavigation::getURLForBlock('blog', 'detail');
$folders = FrontendModel::getThumbnailFolders(FRONTEND_FILES_PATH . '/blog/images', true);
// reset url
foreach ($items as &$row) {
$row['full_url'] = $link . '/' . $row['url'] . '?gn=' . str_pad($row['id'], 3, '0', STR_PAD_LEFT);
// image?
if (isset($row['image'])) {
foreach ($folders as $folder) {
$row['image_' . $folder['dirname']] = $folder['url'] . '/' . $folder['dirname'] . '/' . $row['image'];
}
}
}
}
// return
return $items;
}
