Spade
Mini Shell
| Directory:~$ /proc/self/root/home/lmsyaran/www/joomla5/components/com_content/src/Model/ |
| [Home] [System Details] [Kill Me] |
<?php
/**
* @package Joomla.Site
* @subpackage com_content
*
* @copyright (C) 2009 Open Source Matters, Inc.
<https://www.joomla.org>
* @license GNU General Public License version 2 or later; see
LICENSE.txt
*/
namespace Joomla\Component\Content\Site\Model;
use Joomla\CMS\Component\ComponentHelper;
use Joomla\CMS\Factory;
use Joomla\CMS\Helper\TagsHelper;
use Joomla\CMS\Language\Associations;
use Joomla\CMS\Language\Multilanguage;
use Joomla\CMS\MVC\Model\ListModel;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\Component\Content\Administrator\Extension\ContentComponent;
use Joomla\Component\Content\Site\Helper\AssociationHelper;
use Joomla\Database\ParameterType;
use Joomla\Registry\Registry;
use Joomla\String\StringHelper;
use Joomla\Utilities\ArrayHelper;
// phpcs:disable PSR1.Files.SideEffects
\defined('_JEXEC') or die;
// phpcs:enable PSR1.Files.SideEffects
/**
* This models supports retrieving lists of articles.
*
* @since 1.6
*/
class ArticlesModel extends ListModel
{
/**
* Constructor.
*
* @param array $config An optional associative array of
configuration settings.
*
* @see \JController
* @since 1.6
*/
public function __construct($config = [])
{
if (empty($config['filter_fields'])) {
$config['filter_fields'] = [
'id', 'a.id',
'title', 'a.title',
'alias', 'a.alias',
'checked_out', 'a.checked_out',
'checked_out_time',
'a.checked_out_time',
'catid', 'a.catid',
'category_title',
'state', 'a.state',
'access', 'a.access',
'access_level',
'created', 'a.created',
'created_by', 'a.created_by',
'ordering', 'a.ordering',
'featured', 'a.featured',
'language', 'a.language',
'hits', 'a.hits',
'publish_up', 'a.publish_up',
'publish_down', 'a.publish_down',
'images', 'a.images',
'urls', 'a.urls',
'filter_tag',
];
}
parent::__construct($config);
}
/**
* Method to auto-populate the model state.
*
* This method should only be called once per instantiation and is
designed
* to be called on the first call to the getState() method unless the
model
* configuration flag to ignore the request is set.
*
* Note. Calling getState in this method will result in recursion.
*
* @param string $ordering An optional ordering field.
* @param string $direction An optional direction (asc|desc).
*
* @return void
*
* @since 3.0.1
*/
protected function populateState($ordering = 'ordering',
$direction = 'ASC')
{
$app = Factory::getApplication();
$input = $app->getInput();
// List state information
$value = $input->get('limit',
$app->get('list_limit', 0), 'uint');
$this->setState('list.limit', $value);
$value = $input->get('limitstart', 0,
'uint');
$this->setState('list.start', $value);
$value = $input->get('filter_tag', 0,
'uint');
$this->setState('filter.tag', $value);
$orderCol = $input->get('filter_order',
'a.ordering');
if (!\in_array($orderCol, $this->filter_fields)) {
$orderCol = 'a.ordering';
}
$this->setState('list.ordering', $orderCol);
$listOrder = $input->get('filter_order_Dir',
'ASC');
if (!\in_array(strtoupper($listOrder), ['ASC',
'DESC', ''])) {
$listOrder = 'ASC';
}
$this->setState('list.direction', $listOrder);
$params = $app->getParams();
$this->setState('params', $params);
$user = $this->getCurrentUser();
if ((!$user->authorise('core.edit.state',
'com_content')) &&
(!$user->authorise('core.edit', 'com_content'))) {
// Filter on published for those who do not have edit or
edit.state rights.
$this->setState('filter.published',
ContentComponent::CONDITION_PUBLISHED);
}
$this->setState('filter.language',
Multilanguage::isEnabled());
// Process show_noauth parameter
if ((!$params->get('show_noauth')) ||
(!ComponentHelper::getParams('com_content')->get('show_noauth')))
{
$this->setState('filter.access', true);
} else {
$this->setState('filter.access', false);
}
$this->setState('layout',
$input->getString('layout'));
}
/**
* Method to get a store id based on model configuration state.
*
* This is necessary because the model is used by the component and
* different modules that might need different sets of data or
different
* ordering requirements.
*
* @param string $id A prefix for the store id.
*
* @return string A store id.
*
* @since 1.6
*/
protected function getStoreId($id = '')
{
// Compile the store id.
$id .= ':' .
serialize($this->getState('filter.published'));
$id .= ':' .
$this->getState('filter.access');
$id .= ':' .
$this->getState('filter.featured');
$id .= ':' .
serialize($this->getState('filter.article_id'));
$id .= ':' .
$this->getState('filter.article_id.include');
$id .= ':' .
serialize($this->getState('filter.category_id'));
$id .= ':' .
$this->getState('filter.category_id.include');
$id .= ':' .
serialize($this->getState('filter.author_id'));
$id .= ':' .
$this->getState('filter.author_id.include');
$id .= ':' .
serialize($this->getState('filter.author_alias'));
$id .= ':' .
$this->getState('filter.author_alias.include');
$id .= ':' .
$this->getState('filter.date_filtering');
$id .= ':' .
$this->getState('filter.date_field');
$id .= ':' .
$this->getState('filter.start_date_range');
$id .= ':' .
$this->getState('filter.end_date_range');
$id .= ':' .
$this->getState('filter.relative_date');
$id .= ':' .
serialize($this->getState('filter.tag'));
return parent::getStoreId($id);
}
/**
* Get the master query for retrieving a list of articles subject to
the model state.
*
* @return \Joomla\Database\DatabaseQuery
*
* @since 1.6
*/
protected function getListQuery()
{
$user = $this->getCurrentUser();
// Create a new query object.
$db = $this->getDatabase();
/** @var \Joomla\Database\DatabaseQuery $query */
$query = $db->getQuery(true);
$nowDate = Factory::getDate()->toSql();
$conditionArchived = ContentComponent::CONDITION_ARCHIVED;
$conditionUnpublished = ContentComponent::CONDITION_UNPUBLISHED;
// Select the required fields from the table.
$query->select(
$this->getState(
'list.select',
[
$db->quoteName('a.id'),
$db->quoteName('a.title'),
$db->quoteName('a.alias'),
$db->quoteName('a.introtext'),
$db->quoteName('a.fulltext'),
$db->quoteName('a.checked_out'),
$db->quoteName('a.checked_out_time'),
$db->quoteName('a.catid'),
$db->quoteName('a.created'),
$db->quoteName('a.created_by'),
$db->quoteName('a.created_by_alias'),
$db->quoteName('a.modified'),
$db->quoteName('a.modified_by'),
// Use created if publish_up is null
'CASE WHEN ' .
$db->quoteName('a.publish_up') . ' IS NULL THEN ' .
$db->quoteName('a.created')
. ' ELSE ' .
$db->quoteName('a.publish_up') . ' END AS ' .
$db->quoteName('publish_up'),
$db->quoteName('a.publish_down'),
$db->quoteName('a.images'),
$db->quoteName('a.urls'),
$db->quoteName('a.attribs'),
$db->quoteName('a.metadata'),
$db->quoteName('a.metakey'),
$db->quoteName('a.metadesc'),
$db->quoteName('a.access'),
$db->quoteName('a.hits'),
$db->quoteName('a.featured'),
$db->quoteName('a.language'),
$query->length($db->quoteName('a.fulltext')) . ' AS
' . $db->quoteName('readmore'),
$db->quoteName('a.ordering'),
]
)
)
->select(
[
$db->quoteName('fp.featured_up'),
$db->quoteName('fp.featured_down'),
// Published/archived article in archived category is
treated as archived article. If category is not published then force 0.
'CASE WHEN ' .
$db->quoteName('c.published') . ' = 2 AND ' .
$db->quoteName('a.state') . ' > 0 THEN ' .
$conditionArchived
. ' WHEN ' .
$db->quoteName('c.published') . ' != 1 THEN ' .
$conditionUnpublished
. ' ELSE ' .
$db->quoteName('a.state') . ' END AS ' .
$db->quoteName('state'),
$db->quoteName('c.title',
'category_title'),
$db->quoteName('c.path',
'category_route'),
$db->quoteName('c.access',
'category_access'),
$db->quoteName('c.alias',
'category_alias'),
$db->quoteName('c.language',
'category_language'),
$db->quoteName('c.published'),
$db->quoteName('c.published',
'parents_published'),
$db->quoteName('c.lft'),
'CASE WHEN ' .
$db->quoteName('a.created_by_alias') . ' > ' .
$db->quote(' ') . ' THEN ' .
$db->quoteName('a.created_by_alias')
. ' ELSE ' .
$db->quoteName('ua.name') . ' END AS ' .
$db->quoteName('author'),
$db->quoteName('ua.email',
'author_email'),
$db->quoteName('uam.name',
'modified_by_name'),
$db->quoteName('parent.title',
'parent_title'),
$db->quoteName('parent.id',
'parent_id'),
$db->quoteName('parent.path',
'parent_route'),
$db->quoteName('parent.alias',
'parent_alias'),
$db->quoteName('parent.language',
'parent_language'),
]
)
->from($db->quoteName('#__content',
'a'))
->join('LEFT',
$db->quoteName('#__categories', 'c'),
$db->quoteName('c.id') . ' = ' .
$db->quoteName('a.catid'))
->join('LEFT',
$db->quoteName('#__users', 'ua'),
$db->quoteName('ua.id') . ' = ' .
$db->quoteName('a.created_by'))
->join('LEFT',
$db->quoteName('#__users', 'uam'),
$db->quoteName('uam.id') . ' = ' .
$db->quoteName('a.modified_by'))
->join('LEFT',
$db->quoteName('#__categories', 'parent'),
$db->quoteName('parent.id') . ' = ' .
$db->quoteName('c.parent_id'));
$params = $this->getState('params');
$orderby_sec = $params->get('orderby_sec');
// Join over the frontpage articles if required.
$frontpageJoin = 'LEFT';
if ($this->getState('filter.frontpage')) {
if ($orderby_sec === 'front') {
$query->select($db->quoteName('fp.ordering'));
$frontpageJoin = 'INNER';
} else {
$query->where($db->quoteName('a.featured')
. ' = 1');
}
$query->where(
[
'(' .
$db->quoteName('fp.featured_up') . ' IS NULL OR ' .
$db->quoteName('fp.featured_up') . ' <=
:frontpageUp)',
'(' .
$db->quoteName('fp.featured_down') . ' IS NULL OR '
. $db->quoteName('fp.featured_down') . ' >=
:frontpageDown)',
]
)
->bind(':frontpageUp', $nowDate)
->bind(':frontpageDown', $nowDate);
} elseif ($orderby_sec === 'front' ||
$this->getState('list.ordering') === 'fp.ordering')
{
$query->select($db->quoteName('fp.ordering'));
}
$query->join($frontpageJoin,
$db->quoteName('#__content_frontpage', 'fp'),
$db->quoteName('fp.content_id') . ' = ' .
$db->quoteName('a.id'));
if (PluginHelper::isEnabled('content', 'vote'))
{
// Join on voting table
$query->select(
[
'COALESCE(NULLIF(ROUND(' .
$db->quoteName('v.rating_sum') . ' / ' .
$db->quoteName('v.rating_count') . ', 1), 0), 0)'
. ' AS ' .
$db->quoteName('rating'),
'COALESCE(NULLIF(' .
$db->quoteName('v.rating_count') . ', 0), 0) AS ' .
$db->quoteName('rating_count'),
]
)
->join('LEFT',
$db->quoteName('#__content_rating', 'v'),
$db->quoteName('a.id') . ' = ' .
$db->quoteName('v.content_id'));
}
// Filter by access level.
if ($this->getState('filter.access', true)) {
$groups = $this->getState('filter.viewlevels',
$user->getAuthorisedViewLevels());
$query->whereIn($db->quoteName('a.access'),
$groups)
->whereIn($db->quoteName('c.access'),
$groups);
}
// Filter by published state
$condition = $this->getState('filter.published');
if (is_numeric($condition) && $condition == 2) {
/**
* If category is archived then article has to be published or
archived.
* Or category is published then article has to be archived.
*/
$query->where('((' .
$db->quoteName('c.published') . ' = 2 AND ' .
$db->quoteName('a.state') . ' >
:conditionUnpublished)'
. ' OR (' .
$db->quoteName('c.published') . ' = 1 AND ' .
$db->quoteName('a.state') . ' =
:conditionArchived))')
->bind(':conditionUnpublished',
$conditionUnpublished, ParameterType::INTEGER)
->bind(':conditionArchived',
$conditionArchived, ParameterType::INTEGER);
} elseif (is_numeric($condition)) {
$condition = (int) $condition;
// Category has to be published
$query->where($db->quoteName('c.published') .
' = 1 AND ' . $db->quoteName('a.state') . ' =
:condition')
->bind(':condition', $condition,
ParameterType::INTEGER);
} elseif (\is_array($condition)) {
// Category has to be published
$query->where(
$db->quoteName('c.published') . ' = 1 AND
' . $db->quoteName('a.state')
. ' IN (' . implode(',',
$query->bindArray($condition)) . ')'
);
}
// Filter by featured state
$featured = $this->getState('filter.featured');
switch ($featured) {
case 'hide':
$query->extendWhere(
'AND',
[
$db->quoteName('a.featured') . '
= 0',
'(' .
$db->quoteName('fp.featured_up') . ' IS NOT NULL AND
' . $db->quoteName('fp.featured_up') . ' >=
:featuredUp)',
'(' .
$db->quoteName('fp.featured_down') . ' IS NOT NULL AND
' . $db->quoteName('fp.featured_down') . ' <=
:featuredDown)',
],
'OR'
)
->bind(':featuredUp', $nowDate)
->bind(':featuredDown', $nowDate);
break;
case 'only':
$query->where(
[
$db->quoteName('a.featured') . '
= 1',
'(' .
$db->quoteName('fp.featured_up') . ' IS NULL OR ' .
$db->quoteName('fp.featured_up') . ' <=
:featuredUp)',
'(' .
$db->quoteName('fp.featured_down') . ' IS NULL OR '
. $db->quoteName('fp.featured_down') . ' >=
:featuredDown)',
]
)
->bind(':featuredUp', $nowDate)
->bind(':featuredDown', $nowDate);
break;
case 'show':
default:
// Normally we do not discriminate between
featured/unfeatured items.
break;
}
// Filter by a single or group of articles.
$articleId = $this->getState('filter.article_id');
if (is_numeric($articleId)) {
$articleId = (int) $articleId;
$type =
$this->getState('filter.article_id.include', true) ? ' =
' : ' <> ';
$query->where($db->quoteName('a.id') . $type .
':articleId')
->bind(':articleId', $articleId,
ParameterType::INTEGER);
} elseif (\is_array($articleId)) {
$articleId = ArrayHelper::toInteger($articleId);
if ($this->getState('filter.article_id.include',
true)) {
$query->whereIn($db->quoteName('a.id'),
$articleId);
} else {
$query->whereNotIn($db->quoteName('a.id'),
$articleId);
}
}
// Filter by a single or group of categories
$categoryId = $this->getState('filter.category_id');
if (is_numeric($categoryId)) {
$type =
$this->getState('filter.category_id.include', true) ? ' =
' : ' <> ';
// Add subcategory check
$includeSubcategories =
$this->getState('filter.subcategories', false);
if ($includeSubcategories) {
$categoryId = (int) $categoryId;
$levels = (int)
$this->getState('filter.max_category_levels', 1);
// Create a subquery for the subcategory list
$subQuery = $db->getQuery(true)
->select($db->quoteName('sub.id'))
->from($db->quoteName('#__categories',
'sub'))
->join(
'INNER',
$db->quoteName('#__categories',
'this'),
$db->quoteName('sub.lft') . '
> ' . $db->quoteName('this.lft')
. ' AND ' .
$db->quoteName('sub.rgt') . ' < ' .
$db->quoteName('this.rgt')
)
->where($db->quoteName('this.id') .
' = :subCategoryId');
$query->bind(':subCategoryId', $categoryId,
ParameterType::INTEGER);
if ($levels >= 0) {
$subQuery->where($db->quoteName('sub.level') . ' <=
' . $db->quoteName('this.level') . ' +
:levels');
$query->bind(':levels', $levels,
ParameterType::INTEGER);
}
// Add the subquery to the main query
$query->where(
'(' . $db->quoteName('a.catid')
. $type . ':categoryId OR ' .
$db->quoteName('a.catid') . ' IN (' . $subQuery .
'))'
);
$query->bind(':categoryId', $categoryId,
ParameterType::INTEGER);
} else {
$query->where($db->quoteName('a.catid') .
$type . ':categoryId');
$query->bind(':categoryId', $categoryId,
ParameterType::INTEGER);
}
} elseif (\is_array($categoryId) && (\count($categoryId)
> 0)) {
$categoryId = ArrayHelper::toInteger($categoryId);
if (!empty($categoryId)) {
if
($this->getState('filter.category_id.include', true)) {
$query->whereIn($db->quoteName('a.catid'), $categoryId);
} else {
$query->whereNotIn($db->quoteName('a.catid'), $categoryId);
}
}
}
// Filter by author
$authorId = $this->getState('filter.author_id');
$authorWhere = '';
if (is_numeric($authorId)) {
$authorId = (int) $authorId;
$type =
$this->getState('filter.author_id.include', true) ? ' =
' : ' <> ';
$authorWhere = $db->quoteName('a.created_by') .
$type . ':authorId';
$query->bind(':authorId', $authorId,
ParameterType::INTEGER);
} elseif (\is_array($authorId)) {
$authorId = array_values(array_filter($authorId,
'is_numeric'));
if ($authorId) {
$type =
$this->getState('filter.author_id.include', true) ? '
IN' : ' NOT IN';
$authorWhere = $db->quoteName('a.created_by')
. $type . ' (' . implode(',',
$query->bindArray($authorId)) . ')';
}
}
// Filter by author alias
$authorAlias =
$this->getState('filter.author_alias');
$authorAliasWhere = '';
if (\is_string($authorAlias)) {
$type =
$this->getState('filter.author_alias.include', true) ? '
= ' : ' <> ';
$authorAliasWhere =
$db->quoteName('a.created_by_alias') . $type .
':authorAlias';
$query->bind(':authorAlias', $authorAlias);
} elseif (\is_array($authorAlias) && !empty($authorAlias))
{
$type =
$this->getState('filter.author_alias.include', true) ? '
IN' : ' NOT IN';
$authorAliasWhere =
$db->quoteName('a.created_by_alias') . $type
. ' (' . implode(',',
$query->bindArray($authorAlias, ParameterType::STRING)) . ')';
}
if (!empty($authorWhere) && !empty($authorAliasWhere)) {
$query->where('(' . $authorWhere . ' OR
' . $authorAliasWhere . ')');
} elseif (!empty($authorWhere) || !empty($authorAliasWhere)) {
// One of these is empty, the other is not so we just add both
$query->where($authorWhere . $authorAliasWhere);
}
// Filter by start and end dates.
if ((!$user->authorise('core.edit.state',
'com_content')) &&
(!$user->authorise('core.edit', 'com_content'))) {
$query->where(
[
'(' .
$db->quoteName('a.publish_up') . ' IS NULL OR ' .
$db->quoteName('a.publish_up') . ' <=
:publishUp)',
'(' .
$db->quoteName('a.publish_down') . ' IS NULL OR ' .
$db->quoteName('a.publish_down') . ' >=
:publishDown)',
]
)
->bind(':publishUp', $nowDate)
->bind(':publishDown', $nowDate);
}
// Filter by Date Range or Relative Date
$dateFiltering =
$this->getState('filter.date_filtering', 'off');
$dateField =
$db->escape($this->getState('filter.date_field',
'a.created'));
switch ($dateFiltering) {
case 'range':
$startDateRange =
$this->getState('filter.start_date_range', '');
$endDateRange =
$this->getState('filter.end_date_range', '');
if ($startDateRange || $endDateRange) {
$query->where($db->quoteName($dateField) . '
IS NOT NULL');
if ($startDateRange) {
$query->where($db->quoteName($dateField) .
' >= :startDateRange')
->bind(':startDateRange',
$startDateRange);
}
if ($endDateRange) {
$query->where($db->quoteName($dateField) .
' <= :endDateRange')
->bind(':endDateRange',
$endDateRange);
}
}
break;
case 'relative':
$relativeDate = (int)
$this->getState('filter.relative_date', 0);
$query->where(
$db->quoteName($dateField) . ' IS NOT NULL AND
'
. $db->quoteName($dateField) . ' >= ' .
$query->dateAdd($db->quote($nowDate), -1 * $relativeDate,
'DAY')
);
break;
case 'off':
default:
break;
}
// Process the filter for list views with user-entered filters
if (\is_object($params) &&
($params->get('filter_field') !== 'hide') &&
($filter = $this->getState('list.filter'))) {
// Clean filter variable
$filter = StringHelper::strtolower($filter);
$monthFilter = $filter;
$hitsFilter = (int) $filter;
$textFilter = '%' . $filter . '%';
switch ($params->get('filter_field')) {
case 'author':
$query->where(
'LOWER(CASE WHEN ' .
$db->quoteName('a.created_by_alias') . ' > ' .
$db->quote(' ')
. ' THEN ' .
$db->quoteName('a.created_by_alias') . ' ELSE ' .
$db->quoteName('ua.name') . ' END) LIKE :search'
)
->bind(':search', $textFilter);
break;
case 'hits':
$query->where($db->quoteName('a.hits')
. ' >= :hits')
->bind(':hits', $hitsFilter,
ParameterType::INTEGER);
break;
case 'month':
if ($monthFilter != '') {
$monthStart = date("Y-m-d",
strtotime($monthFilter)) . ' 00:00:00';
$monthEnd = date("Y-m-t",
strtotime($monthFilter)) . ' 23:59:59';
$query->where(
[
':monthStart <= CASE WHEN
a.publish_up IS NULL THEN a.created ELSE a.publish_up END',
':monthEnd >= CASE WHEN
a.publish_up IS NULL THEN a.created ELSE a.publish_up END',
]
)
->bind(':monthStart', $monthStart)
->bind(':monthEnd', $monthEnd);
}
break;
case 'title':
default:
// Default to 'title' if parameter is not
valid
$query->where('LOWER(' .
$db->quoteName('a.title') . ') LIKE :search')
->bind(':search', $textFilter);
break;
}
}
// Filter by language
if ($this->getState('filter.language')) {
$query->whereIn($db->quoteName('a.language'),
[Factory::getApplication()->getLanguage()->getTag(), '*'],
ParameterType::STRING);
}
// Filter by a single or group of tags.
$tagId = $this->getState('filter.tag');
if (\is_array($tagId) && \count($tagId) === 1) {
$tagId = current($tagId);
}
if (\is_array($tagId)) {
$tagId = ArrayHelper::toInteger($tagId);
if ($tagId) {
$subQuery = $db->getQuery(true)
->select('DISTINCT ' .
$db->quoteName('content_item_id'))
->from($db->quoteName('#__contentitem_tag_map'))
->where(
[
$db->quoteName('tag_id') . '
IN (' . implode(',', $query->bindArray($tagId)) .
')',
$db->quoteName('type_alias') .
' = ' . $db->quote('com_content.article'),
]
);
$query->join(
'INNER',
'(' . $subQuery . ') AS ' .
$db->quoteName('tagmap'),
$db->quoteName('tagmap.content_item_id') .
' = ' . $db->quoteName('a.id')
);
}
} elseif ($tagId = (int) $tagId) {
$query->join(
'INNER',
$db->quoteName('#__contentitem_tag_map',
'tagmap'),
$db->quoteName('tagmap.content_item_id') .
' = ' . $db->quoteName('a.id')
. ' AND ' .
$db->quoteName('tagmap.type_alias') . ' = ' .
$db->quote('com_content.article')
)
->where($db->quoteName('tagmap.tag_id') .
' = :tagId')
->bind(':tagId', $tagId,
ParameterType::INTEGER);
}
// Add the list ordering clause.
$query->order(
$db->escape($this->getState('list.ordering',
'a.ordering')) . ' ' .
$db->escape($this->getState('list.direction',
'ASC'))
);
return $query;
}
/**
* Method to get a list of articles.
*
* Overridden to inject convert the attribs field into a Registry
object.
*
* @return mixed An array of objects on success, false on failure.
*
* @since 1.6
*/
public function getItems()
{
$items = parent::getItems();
$user = $this->getCurrentUser();
$userId = $user->get('id');
$guest = $user->get('guest');
$groups = $user->getAuthorisedViewLevels();
$input = Factory::getApplication()->getInput();
// Get the global params
$globalParams = ComponentHelper::getParams('com_content',
true);
$taggedItems = [];
// Convert the parameter fields into objects.
foreach ($items as $item) {
$articleParams = new Registry($item->attribs);
// Unpack readmore and layout params
$item->alternative_readmore =
$articleParams->get('alternative_readmore');
$item->layout =
$articleParams->get('layout');
$item->params = clone
$this->getState('params');
/**
* For blogs, article params override menu item params only if
menu param = 'use_article'
* Otherwise, menu item params control the layout
* If menu item is 'use_article' and there is no
article param, use global
*/
if (
($input->getString('layout') ===
'blog') || ($input->getString('view') ===
'featured')
||
($this->getState('params')->get('layout_type')
=== 'blog')
) {
// Create an array of just the params set to
'use_article'
$menuParamsArray =
$this->getState('params')->toArray();
$articleArray = [];
foreach ($menuParamsArray as $key => $value) {
if ($value === 'use_article') {
// If the article has a value, use it
if ($articleParams->get($key) != '') {
// Get the value from the article
$articleArray[$key] =
$articleParams->get($key);
} else {
// Otherwise, use the global value
$articleArray[$key] =
$globalParams->get($key);
}
}
}
// Merge the selected article params
if (\count($articleArray) > 0) {
$articleParams = new Registry($articleArray);
$item->params->merge($articleParams);
}
} else {
// For non-blog layouts, merge all of the article params
$item->params->merge($articleParams);
}
// Get display date
switch ($item->params->get('list_show_date')) {
case 'modified':
$item->displayDate = $item->modified;
break;
case 'published':
$item->displayDate = ($item->publish_up == 0) ?
$item->created : $item->publish_up;
break;
default:
case 'created':
$item->displayDate = $item->created;
break;
}
/**
* Compute the asset access permissions.
* Technically guest could edit an article, but lets not check
that to improve performance a little.
*/
if (!$guest) {
$asset = 'com_content.article.' . $item->id;
// Check general edit permission first.
if ($user->authorise('core.edit', $asset)) {
$item->params->set('access-edit',
true);
} elseif (!empty($userId) &&
$user->authorise('core.edit.own', $asset)) {
// Now check if edit.own is available.
// Check for a valid user and that they are the owner.
if ($userId == $item->created_by) {
$item->params->set('access-edit',
true);
}
}
}
$access = $this->getState('filter.access');
if ($access) {
// If the access filter has been set, we already have only
the articles this user can view.
$item->params->set('access-view', true);
} else {
// If no access filter is set, the layout takes some
responsibility for display of limited information.
if ($item->catid == 0 || $item->category_access ===
null) {
$item->params->set('access-view',
\in_array($item->access, $groups));
} else {
$item->params->set('access-view',
\in_array($item->access, $groups) &&
\in_array($item->category_access, $groups));
}
}
// Some contexts may not use tags data at all, so we allow
callers to disable loading tag data
if ($this->getState('load_tags',
$item->params->get('show_tags', '1'))) {
$item->tags = new TagsHelper();
$taggedItems[$item->id] = $item;
}
if (Associations::isEnabled() &&
$item->params->get('show_associations')) {
$item->associations =
AssociationHelper::displayAssociations($item->id);
}
}
// Load tags of all items.
if ($taggedItems) {
$tagsHelper = new TagsHelper();
$itemIds = array_keys($taggedItems);
foreach
($tagsHelper->getMultipleItemTags('com_content.article',
$itemIds) as $id => $tags) {
$taggedItems[$id]->tags->itemTags = $tags;
}
}
return $items;
}
/**
* Method to get the starting number of items for the data set.
*
* @return integer The starting number of items available in the data
set.
*
* @since 3.0.1
*/
public function getStart()
{
return $this->getState('list.start');
}
/**
* Count Items by Month
*
* @return mixed An array of objects on success, false on failure.
*
* @since 3.9.0
*/
public function countItemsByMonth()
{
// Create a new query object.
$db = $this->getDatabase();
$query = $db->getQuery(true);
// Get the list query.
$listQuery = $this->getListQuery();
$bounded = $listQuery->getBounded();
// Bind list query variables to our new query.
$keys = array_keys($bounded);
$values = array_column($bounded, 'value');
$dataTypes = array_column($bounded, 'dataType');
$query->bind($keys, $values, $dataTypes);
$query
->select(
'DATE(' .
$query->concatenate(
[
$query->year($db->quoteName('publish_up')),
$db->quote('-'),
$query->month($db->quoteName('publish_up')),
$db->quote('-01'),
]
) . ') AS ' . $db->quoteName('d')
)
->select('COUNT(*) AS ' .
$db->quoteName('c'))
->from('(' . $this->getListQuery() . ') AS
' . $db->quoteName('b'))
->group($db->quoteName('d'))
->order($db->quoteName('d') . '
DESC');
return $db->setQuery($query)->loadObjectList();
}
}