PK ! $ÀAüÄ Ä src/Helper/TagsSimilarHelper.phpnu &1i„
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
namespace Joomla\Module\TagsSimilar\Site\Helper;
\defined('_JEXEC') or die;
use Joomla\CMS\Component\ComponentHelper;
use Joomla\CMS\Factory;
use Joomla\CMS\Helper\ContentHelper;
use Joomla\CMS\Helper\TagsHelper;
use Joomla\CMS\Language\Text;
use Joomla\Component\Tags\Site\Helper\RouteHelper;
use Joomla\Database\ParameterType;
use Joomla\Registry\Registry;
/**
* Helper for mod_tags_similar
*
* @since 3.1
*/
abstract class TagsSimilarHelper
{
/**
* Get a list of tags
*
* @param Registry &$params Module parameters
*
* @return array
*/
public static function getList(&$params)
{
$app = Factory::getApplication();
$option = $app->input->get('option');
$view = $app->input->get('view');
// For now assume com_tags and com_users do not have tags.
// This module does not apply to list views in general at this point.
if ($option === 'com_tags' || $view === 'category' || $option === 'com_users')
{
return array();
}
$db = Factory::getDbo();
$user = Factory::getUser();
$groups = $user->getAuthorisedViewLevels();
$matchtype = $params->get('matchtype', 'all');
$ordering = $params->get('ordering', 'count');
$tagsHelper = new TagsHelper;
$prefix = $option . '.' . $view;
$id = $app->input->getInt('id');
$now = Factory::getDate()->toSql();
$nullDate = $db->getNullDate();
// This returns a comma separated string of IDs.
$tagsToMatch = $tagsHelper->getTagIds($id, $prefix);
if (!$tagsToMatch)
{
return array();
}
$tagsToMatch = explode(',', $tagsToMatch);
$tagCount = \count($tagsToMatch);
$query = $db->getQuery(true);
$query
->select(
[
$db->quoteName('m.core_content_id'),
$db->quoteName('m.content_item_id'),
$db->quoteName('m.type_alias'),
'COUNT( ' . $db->quoteName('tag_id') . ') AS ' . $db->quoteName('count'),
$db->quoteName('ct.router'),
$db->quoteName('cc.core_title'),
$db->quoteName('cc.core_alias'),
$db->quoteName('cc.core_catid'),
$db->quoteName('cc.core_language'),
$db->quoteName('cc.core_params'),
]
)
->from($db->quoteName('#__contentitem_tag_map', 'm'))
->join(
'INNER',
$db->quoteName('#__tags', 't'),
$db->quoteName('m.tag_id') . ' = ' . $db->quoteName('t.id')
)
->join(
'INNER',
$db->quoteName('#__ucm_content', 'cc'),
$db->quoteName('m.core_content_id') . ' = ' . $db->quoteName('cc.core_content_id')
)
->join(
'INNER',
$db->quoteName('#__content_types', 'ct'),
$db->quoteName('m.type_alias') . ' = ' . $db->quoteName('ct.type_alias')
)
->whereIn($db->quoteName('m.tag_id'), $tagsToMatch)
->whereIn($db->quoteName('t.access'), $groups)
->where($db->quoteName('cc.core_state') . ' = 1')
->extendWhere(
'AND',
[
$db->quoteName('cc.core_access') . ' IN (' . implode(',', $query->bindArray($groups)) . ')',
$db->quoteName('cc.core_access') . ' = 0',
],
'OR'
)
->extendWhere(
'AND',
[
$db->quoteName('m.content_item_id') . ' <> :currentId',
$db->quoteName('m.type_alias') . ' <> :prefix',
],
'OR'
)
->bind(':currentId', $id, ParameterType::INTEGER)
->bind(':prefix', $prefix)
->extendWhere(
'AND',
[
$db->quoteName('cc.core_publish_up') . ' IS NULL',
$db->quoteName('cc.core_publish_up') . ' = :nullDateUp',
$db->quoteName('cc.core_publish_up') . ' <= :nowDateUp',
],
'OR'
)
->bind(':nullDateUp', $nullDate)
->bind(':nowDateUp', $now)
->extendWhere(
'AND',
[
$db->quoteName('cc.core_publish_down') . ' IS NULL',
$db->quoteName('cc.core_publish_down') . ' = :nullDateDown',
$db->quoteName('cc.core_publish_down') . ' >= :nowDateDown',
],
'OR'
)
->bind(':nullDateDown', $nullDate)
->bind(':nowDateDown', $now);
// Optionally filter on language
$language = ComponentHelper::getParams('com_tags')->get('tag_list_language_filter', 'all');
if ($language !== 'all')
{
if ($language === 'current_language')
{
$language = ContentHelper::getCurrentLanguage();
}
$query->whereIn($db->quoteName('cc.core_language'), [$language, '*'], ParameterType::STRING);
}
$query->group(
[
$db->quoteName('m.core_content_id'),
$db->quoteName('m.content_item_id'),
$db->quoteName('m.type_alias'),
$db->quoteName('ct.router'),
$db->quoteName('cc.core_title'),
$db->quoteName('cc.core_alias'),
$db->quoteName('cc.core_catid'),
$db->quoteName('cc.core_language'),
$db->quoteName('cc.core_params'),
]
);
if ($matchtype === 'all' && $tagCount > 0)
{
$query->having('COUNT( ' . $db->quoteName('tag_id') . ') = :tagCount')
->bind(':tagCount', $tagCount, ParameterType::INTEGER);
}
elseif ($matchtype === 'half' && $tagCount > 0)
{
$tagCountHalf = ceil($tagCount / 2);
$query->having('COUNT( ' . $db->quoteName('tag_id') . ') >= :tagCount')
->bind(':tagCount', $tagCountHalf, ParameterType::INTEGER);
}
if ($ordering === 'count' || $ordering === 'countrandom')
{
$query->order($db->quoteName('count') . ' DESC');
}
if ($ordering === 'random' || $ordering === 'countrandom')
{
$query->order($query->rand());
}
$query->setLimit((int) $params->get('maximum', 5));
$db->setQuery($query);
try
{
$results = $db->loadObjectList();
}
catch (\RuntimeException $e)
{
$results = [];
$app->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
}
foreach ($results as $result)
{
$result->link = RouteHelper::getItemRoute(
$result->content_item_id,
$result->core_alias,
$result->core_catid,
$result->core_language,
$result->type_alias,
$result->router
);
$result->core_params = new Registry($result->core_params);
}
return $results;
}
}
PK ! KÛqí í mod_tags_similar.phpnu &1i„
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined('_JEXEC') or die;
use Joomla\CMS\Helper\ModuleHelper;
$cacheparams = new \stdClass;
$cacheparams->cachemode = 'safeuri';
$cacheparams->class = 'Joomla\Module\TagsSimilar\Site\Helper\TagsSimilarHelper';
$cacheparams->method = 'getList';
$cacheparams->methodparams = $params;
$cacheparams->modeparams = array('id' => 'array', 'Itemid' => 'int');
$list = ModuleHelper::moduleCache($module, $params, $cacheparams);
require ModuleHelper::getLayoutPath('mod_tags_similar', $params->get('layout', 'default'));
PK ! —€‚1 1 mod_tags_similar.xmlnu &1i„
mod_tags_similar
Joomla! Project
January 2013
(C) 2013 Open Source Matters, Inc.
GNU General Public License version 2 or later; see LICENSE.txt
admin@joomla.org
www.joomla.org
3.1.0
MOD_TAGS_SIMILAR_XML_DESCRIPTION
Joomla\Module\TagsSimilar
mod_tags_similar.php
src
tmpl
language/en-GB/mod_tags_similar.ini
language/en-GB/mod_tags_similar.sys.ini
PK ! ÙÈ#¡± ± tmpl/default.phpnu &1i„
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined('_JEXEC') or die;
use Joomla\CMS\Router\Route;
if (!$list)
{
return;
}
?>
PK ! $ÀAüÄ Ä src/Helper/TagsSimilarHelper.phpnu &1i„ PK ! KÛqí í mod_tags_similar.phpnu &1i„ PK ! —€‚1 1 E mod_tags_similar.xmlnu &1i„ PK ! ÙÈ#¡± ± º& tmpl/default.phpnu &1i„ PK X «*