index.html 0000705 00000000037 15242036640 0006541 0 ustar 00
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
mod_tags_similar.php
tmpl
helper.php
en-GB.mod_tags_similar.ini
en-GB.mod_tags_similar.sys.ini
MOD_TAGS_SIMILAR_FIELD_ALL
MOD_TAGS_SIMILAR_FIELD_ONE
MOD_TAGS_SIMILAR_FIELD_HALF
MOD_TAGS_SIMILAR_FIELD_ORDERING_COUNT
MOD_TAGS_SIMILAR_FIELD_ORDERING_RANDOM
MOD_TAGS_SIMILAR_FIELD_ORDERING_COUNT_AND_RANDOM
JGLOBAL_USE_GLOBAL
COM_MODULES_FIELD_VALUE_NOCACHING
helper.php 0000705 00000011753 15242036640 0006543 0 ustar 00
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined('_JEXEC') or die;
use Joomla\Registry\Registry;
JLoader::register('TagsHelperRoute', JPATH_BASE . '/components/com_tags/helpers/route.php');
/**
* Helper for mod_tags_similar
*
* @since 3.1
*/
abstract class ModTagssimilarHelper
{
/**
* Get a list of tags
*
* @param Registry &$params Module parameters
*
* @return array
*/
public static function getList(&$params)
{
$app = JFactory::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 = JFactory::getDbo();
$user = JFactory::getUser();
$groups = implode(',', $user->getAuthorisedViewLevels());
$matchtype = $params->get('matchtype', 'all');
$maximum = $params->get('maximum', 5);
$ordering = $params->get('ordering', 'count');
$tagsHelper = new JHelperTags;
$prefix = $option . '.' . $view;
$id = $app->input->getInt('id');
$now = JFactory::getDate()->toSql();
$nullDate = $db->getNullDate();
$tagsToMatch = $tagsHelper->getTagIds($id, $prefix);
if (!$tagsToMatch || $tagsToMatch === null)
{
return array();
}
$tagCount = substr_count($tagsToMatch, ',') + 1;
$query = $db->getQuery(true)
->select(
array(
$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'),
)
);
$query->from($db->quoteName('#__contentitem_tag_map', 'm'));
$query->join('INNER', $db->quoteName('#__tags', 't') . ' ON m.tag_id = t.id')
->join('INNER', $db->quoteName('#__ucm_content', 'cc') . ' ON m.core_content_id = cc.core_content_id')
->join('INNER', $db->quoteName('#__content_types', 'ct') . ' ON m.type_alias = ct.type_alias');
$query->where($db->quoteName('m.tag_id') . ' IN (' . $tagsToMatch . ')');
$query->where('t.access IN (' . $groups . ')');
$query->where('(cc.core_access IN (' . $groups . ') OR cc.core_access = 0)');
// Don't show current item
$query->where('(' . $db->quoteName('m.content_item_id') . ' <> ' . $id
. ' OR ' . $db->quoteName('m.type_alias') . ' <> ' . $db->quote($prefix) . ')'
);
// Only return published tags
$query->where($db->quoteName('cc.core_state') . ' = 1 ')
->where('(' . $db->quoteName('cc.core_publish_up') . '=' . $db->quote($nullDate) . ' OR '
. $db->quoteName('cc.core_publish_up') . '<=' . $db->quote($now) . ')'
)
->where('(' . $db->quoteName('cc.core_publish_down') . '=' . $db->quote($nullDate) . ' OR '
. $db->quoteName('cc.core_publish_down') . '>=' . $db->quote($now) . ')'
);
// Optionally filter on language
$language = JComponentHelper::getParams('com_tags')->get('tag_list_language_filter', 'all');
if ($language !== 'all')
{
if ($language === 'current_language')
{
$language = JHelperContent::getCurrentLanguage();
}
$query->where($db->quoteName('cc.core_language') . ' IN (' . $db->quote($language) . ', ' . $db->quote('*') . ')');
}
$query->group(
$db->quoteName(
array('m.core_content_id', 'm.content_item_id', 'm.type_alias', 'ct.router', 'cc.core_title',
'cc.core_alias', 'cc.core_catid', 'cc.core_language', 'cc.core_params')
)
);
if ($matchtype === 'all' && $tagCount > 0)
{
$query->having('COUNT( ' . $db->quoteName('tag_id') . ') = ' . $tagCount);
}
elseif ($matchtype === 'half' && $tagCount > 0)
{
$tagCountHalf = ceil($tagCount / 2);
$query->having('COUNT( ' . $db->quoteName('tag_id') . ') >= ' . $tagCountHalf);
}
if ($ordering === 'count' || $ordering === 'countrandom')
{
$query->order($db->quoteName('count') . ' DESC');
}
if ($ordering === 'random' || $ordering === 'countrandom')
{
$query->order($query->Rand());
}
$db->setQuery($query, 0, $maximum);
try
{
$results = $db->loadObjectList();
}
catch (RuntimeException $e)
{
$results = array();
JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
}
foreach ($results as $result)
{
$result->link = TagsHelperRoute::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;
}
}
mod_tags_similar.php 0000705 00000001634 15242036640 0010576 0 ustar 00
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined('_JEXEC') or die;
// Include the tags_similar functions only once
JLoader::register('ModTagssimilarHelper', __DIR__ . '/helper.php');
$cacheparams = new stdClass;
$cacheparams->cachemode = 'safeuri';
$cacheparams->class = 'ModTagssimilarHelper';
$cacheparams->method = 'getList';
$cacheparams->methodparams = $params;
$cacheparams->modeparams = array('id' => 'array', 'Itemid' => 'int');
$list = JModuleHelper::moduleCache($module, $params, $cacheparams);
if (!count($list))
{
return;
}
$moduleclass_sfx = htmlspecialchars($params->get('moduleclass_sfx', ''), ENT_COMPAT, 'UTF-8');
require JModuleHelper::getLayoutPath('mod_tags_similar', $params->get('layout', 'default'));