Модуль вывода категорий, формирование ссылки - Joomla 3.x: Общие вопросы

echo JRoute::_(ContentHelperRoute::getCategoryRoute($item->id));

JRoute::_('index.php?option=com_content&view=category&id='.$item->id)

JRoute::_('index.php?option=com_content&view=category&id='.$item->slug)

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias)!= 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM j_categories as c

  LEFT JOIN j_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM j_categories AS cat JOIN j_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,2,3,6) 
  AND c.published = 1 
  AND s.id=153 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

JROOT/libraries/legacy/categories/categories.php:296
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:80
JROOT/modules/mod_articles_categories/tmpl/default_items.php:22

1й запрос
  AND s.id=22

2й запрос
  AND s.id=23

3й запрос
  AND s.id=24

Nй запрос
  AND s.id=N

$link = preg_replace('~\/([A-Za-z0-9_-]+)~siu', '/'.$item->id.'-\\1'.($sef_suffix == true ? '.html' : ''), $item->path);

<?php
/**
 * @package     Joomla.Site
 * @subpackage  mod_articles_categories
 *
 * @copyright   Copyright (C) 2005 - 2015 Open Source Matters, Inc. All rights reserved.
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

defined('_JEXEC') or die;

foreach ($list as $item) : ?>
        <li <?php if ($_SERVER['REQUEST_URI'] == JRoute::_(ContentHelperRoute::getCategoryRoute($item->id))) echo ' class="active"';?>> <?php $levelup = $item->level - $startLevel - 1; ?>
                <h<?php echo $params->get('item_heading') + $levelup; ?>>
                <a href="<?php echo JRoute::_(ContentHelperRoute::getCategoryRoute($item->id)); ?>">
                <?php echo $item->title;?>
                        <?php if ($params->get('numitems')) : ?>
                                (<?php echo $item->numitems; ?>)
                        <?php endif; ?>
                </a>
                </h<?php echo $params->get('item_heading') + $levelup; ?>>

                <?php if ($params->get('show_description', 0)) : ?>
                        <?php echo JHtml::_('content.prepare', $item->description, $item->getParams(), 'mod_articles_categories.content'); ?>
                <?php endif; ?>
                <?php if ($params->get('show_children', 0) && (($params->get('maxlevel', 0) == 0)
                        || ($params->get('maxlevel') >= ($item->level - $startLevel)))
                        && count($item->getChildren())) : ?>
                        <?php echo '<ul>'; ?>
                        <?php $temp = $list; ?>
                        <?php $list = $item->getChildren(); ?>
                        <?php require JModuleHelper::getLayoutPath('mod_articles_categories', $params->get('layout', 'default'). '_items'); ?>
                        <?php $list = $temp; ?>
                        <?php echo '</ul>'; ?>
                <?php endif; ?>
        </li>
<?php endforeach; ?>

<a href="<?php echo JRoute::_(ContentHelperRoute::getCategoryRoute($item->id)); ?>">

<a href="<?php echo JRoute::_(ContentHelperRoute::getCategoryRoute($item)); ?>">

<?php
$node = new JCategoryNode($item);
?>
<a href="<?php echo JRoute::_(ContentHelperRoute::getCategoryRoute($node)); ?>">

class JCategoryNode#807 (40) { public $id => string(3) "151" public $asset_id => string(5) "16002" public $parent_id => string(3) "144" public $lft => string(3)..........................................

<a href="<?php echo JRoute::_(ContentHelperRoute::getCategoryRoute($item)); ?>">

SELECT `m`.`tag_id`,`t`.*

  FROM `j_contentitem_tag_map` AS m 

  INNER JOIN `j_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 27924 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,2,3,6)

	public function getItemTags($contentType, $id, $getTagData = true)
	{
		return false;
.....................................

Заменил это
			$item->tags = new JHelperTags;
			$item->tags->getItemTags('com_content.article', $this->item->id);

На это
		if($this->params->get('show_tags')!== "0")
		{
			$item->tags = new JHelperTags;
			$item->tags->getItemTags('com_content.article', $this->item->id);
		}

Заменил это
			// Get the tags
				$item->tags = new JHelperTags;
				$item->tags->getItemTags('com_content.article', $item->id);
На это
			// Get the tags
			if($item->params->get('show_cat_tags')!== "0")
			{
				$item->tags = new JHelperTags;
				$item->tags->getItemTags('com_content.article', $item->id);
			}