public static function getForItem($module, $otherId)
{
$module = (string) $module;
$otherId = (int) $otherId;
// init var
$return = array();
// get tags
$linkedTags = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT t.tag AS name, t.url
FROM modules_tags AS mt
INNER JOIN tags AS t ON mt.tag_id = t.id
WHERE mt.module = ? AND mt.other_id = ?', array($module, $otherId));
// return
if (empty($linkedTags)) {
return $return;
}
// create link
$tagLink = FrontendNavigation::getURLForBlock('Tags', 'Detail');
// loop tags
foreach ($linkedTags as $row) {
// add full URL
$row['full_url'] = $tagLink . '/' . $row['url'];
// add
$return[] = $row;
}
// return
return $return;
}