function getBacklink($id)
{
$db =& JFactory::getDBO();
//For Articles
$db->setQuery($query = "SELECT articleid from #__fieldsattach_values WHERE (value LIKE '%," . $id . ",%' OR value LIKE '" . $id . ",%' OR value LIKE '%," . $id . "' OR value LIKE '" . $id . "') AND fieldsid = 33");
$articles = $db->loadObjectList();
// For Categories
$db->setQuery("SELECT catid from #__fieldsattach_categories_values WHERE (value LIKE '%," . $id . ",%' OR value LIKE '" . $id . ",%' OR value LIKE '%," . $id . "' OR value LIKE '" . $id . "') AND fieldsid = 32");
$categories = $db->loadObjectList();
if (count($articles) + count($categories)) {
$function = '<ul>';
$function .= '<li class="active"><span>В Поликлинике</span></li>';
if (count($articles) + count($categories) == 1) {
$single = true;
} else {
$function .= '<li><span>В Стационаре</span>';
$function .= '<ul class="popup">';
}
foreach ($categories as $item) {
$parent = ModHCSwitch::getParent($item->catid);
if ($single) {
$function .= '<li><a href="' . ContentHelperRoute::getCategoryRoute($item->catid, $parent) . '">В Стационаре</a></li>';
} else {
$function .= '<li><a href="' . ContentHelperRoute::getCategoryRoute($item->catid, $parent) . '">' . ModHCSwitch::getTitle($item->catid, 1) . '</a></li>';
}
}
foreach ($articles as $item) {
$parent = ModHCSwitch::getParent(ModHCSwitch::getCategory($item->articleid));
if ($single) {
$function .= '<li><a href="' . ContentHelperRoute::getArticleRoute($item->articleid, $parent) . '">В Стационаре</a></li>';
} else {
$function .= '<li><a href="' . ContentHelperRoute::getArticleRoute($item->articleid, $parent) . '">' . ModHCSwitch::getTitle($item->articleid, 0) . '</a></li>';
}
}
if (!$single) {
$function .= '</ul>';
$function .= '</li>';
}
$function .= '</ul>';
} else {
return;
}
return $function;
}
