예제 #1
0
    /**
     * 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;
    }