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; }