- md5
- f13a13b7667408d6107203096b4aebfd
- sha1
- d69be41615aa458cdf17af863d85228c9449da2b
- sha256
- 95c988e5e29fdc6b82f4d71dd233cb46c7aeb76ba3e167ac240c673f1fcf3479
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634
<?php
/**
* @package Joomla.Administrator
* @subpackage com_content
*
* @copyright Copyright (C) 2005 - 2019 Open Source Matters, Inc. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
namespace Joomla\Component\Content\Administrator\Model;
defined('_JEXEC') or die;
use Joomla\CMS\Factory;
use Joomla\CMS\Language\Associations;
use Joomla\CMS\Language\Text;
use Joomla\CMS\MVC\Model\ListModel;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\CMS\Table\Table;
use Joomla\CMS\Workflow\Workflow;
use Joomla\Component\Content\Administrator\Extension\ContentComponent;
use Joomla\Utilities\ArrayHelper;
/**
* Methods supporting a list of article records.
*
* @since 1.6
*/
class ArticlesModel extends ListModel
{
/**
* Constructor.
*
* @param array $config An optional associative array of configuration settings.
*
* @since 1.6
* @see \Joomla\CMS\MVC\Controller\BaseController
*/
public function __construct($config = array())
{
if (empty($config['filter_fields']))
{
$config['filter_fields'] = array(
'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',
'modified', 'a.modified',
'created_by', 'a.created_by',
'created_by_alias', 'a.created_by_alias',
'ordering', 'a.ordering',
'featured', 'a.featured',
'language', 'a.language',
'hits', 'a.hits',
'publish_up', 'a.publish_up',
'publish_down', 'a.publish_down',
'published', 'a.published',
'author_id',
'category_id',
'level',
'tag',
'rating_count', 'rating',
);
if (Associations::isEnabled())
{
$config['filter_fields'][] = 'association';
}
}
parent::__construct($config);
}
/**
* Method to auto-populate the model state.
*
* 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 1.6
*/
protected function populateState($ordering = 'a.id', $direction = 'desc')
{
$app = Factory::getApplication();
$forcedLanguage = $app->input->get('forcedLanguage', '', 'cmd');
// Adjust the context to support modal layouts.
if ($layout = $app->input->get('layout'))
{
$this->context .= '.' . $layout;
}
// Adjust the context to support forced languages.
if ($forcedLanguage)
{
$this->context .= '.' . $forcedLanguage;
}
$search = $this->getUserStateFromRequest($this->context . '.filter.search', 'filter_search');
$this->setState('filter.search', $search);
$featured = $this->getUserStateFromRequest($this->context . '.filter.featured', 'filter_featured', '');
$this->setState('filter.featured', $featured);
$published = $this->getUserStateFromRequest($this->context . '.filter.published', 'filter_published', '');
$this->setState('filter.published', $published);
$condition = $this->getUserStateFromRequest($this->context . '.filter.condition', 'filter_condition', '');
$this->setState('filter.condition', $condition);
$level = $this->getUserStateFromRequest($this->context . '.filter.level', 'filter_level');
$this->setState('filter.level', $level);
$language = $this->getUserStateFromRequest($this->context . '.filter.language', 'filter_language', '');
$this->setState('filter.language', $language);
$formSubmited = $app->input->post->get('form_submited');
$access = $this->getUserStateFromRequest($this->context . '.filter.access', 'filter_access');
$authorId = $this->getUserStateFromRequest($this->context . '.filter.author_id', 'filter_author_id');
$categoryId = $this->getUserStateFromRequest($this->context . '.filter.category_id', 'filter_category_id');
$tag = $this->getUserStateFromRequest($this->context . '.filter.tag', 'filter_tag', '');
if ($formSubmited)
{
$access = $app->input->post->get('access');
$this->setState('filter.access', $access);
$authorId = $app->input->post->get('author_id');
$this->setState('filter.author_id', $authorId);
$categoryId = $app->input->post->get('category_id');
$this->setState('filter.category_id', $categoryId);
$tag = $app->input->post->get('tag');
$this->setState('filter.tag', $tag);
}
// List state information.
parent::populateState($ordering, $direction);
// Force a language
if (!empty($forcedLanguage))
{
$this->setState('filter.language', $forcedLanguage);
$this->setState('filter.forcedLanguage', $forcedLanguage);
}
}
/**
* 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 .= ':' . $this->getState('filter.search');
$id .= ':' . serialize($this->getState('filter.access'));
$id .= ':' . $this->getState('filter.published');
$id .= ':' . serialize($this->getState('filter.category_id'));
$id .= ':' . serialize($this->getState('filter.author_id'));
$id .= ':' . $this->getState('filter.language');
$id .= ':' . serialize($this->getState('filter.tag'));
return parent::getStoreId($id);
}
/**
* Build an SQL query to load the list data.
*
* @return \Joomla\Database\DatabaseQuery
*
* @since 1.6
*/
protected function getListQuery()
{
// Create a new query object.
$db = $this->getDbo();
$query = $db->getQuery(true);
$user = Factory::getUser();
// Select the required fields from the table.
$query->select(
$this->getState(
'list.select',
'DISTINCT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid' .
', a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.ordering, a.featured, a.language, a.hits' .
', a.publish_up, a.publish_down, a.introtext, a.note'
)
);
$query->from('#__content AS a');
// Join over the language
$query->select('l.title AS language_title, l.image AS language_image')
->join('LEFT', $db->quoteName('#__languages') . ' AS l ON l.lang_code = a.language');
// Join over the users for the checked out user.
$query->select('uc.name AS editor')
->join('LEFT', '#__users AS uc ON uc.id=a.checked_out');
// Join over the asset groups.
$query->select('ag.title AS access_level')
->join('LEFT', '#__viewlevels AS ag ON ag.id = a.access');
// Join over the categories.
$query->select('c.title AS category_title, c.created_user_id AS category_uid, c.level AS category_level')
->join('LEFT', '#__categories AS c ON c.id = a.catid');
// Join over the parent categories.
$query->select('parent.title AS parent_category_title, parent.id AS parent_category_id,
parent.created_user_id AS parent_category_uid, parent.level AS parent_category_level')
->join('LEFT', '#__categories AS parent ON parent.id = c.parent_id');
// Join over the users for the author.
$query->select('ua.name AS author_name')
->join('LEFT', '#__users AS ua ON ua.id = a.created_by');
// Join over the associations.
$query->select($query->quoteName('wa.stage_id', 'stage_id'))
->innerJoin(
$query->quoteName('#__workflow_associations', 'wa')
. ' ON ' . $query->quoteName('wa.item_id') . ' = ' . $query->quoteName('a.id')
);
// Join over the workflow stages.
$query->select(
$query->quoteName(
[
'ws.title',
'ws.condition',
'ws.workflow_id'
],
[
'stage_title',
'stage_condition',
'workflow_id'
]
)
)
->innerJoin(
$query->quoteName('#__workflow_stages', 'ws')
. ' ON ' . $query->quoteName('ws.id') . ' = ' . $query->quoteName('wa.stage_id')
);
// Join on voting table
$associationsGroupBy = array(
'a.id',
'a.title',
'a.alias',
'a.checked_out',
'a.checked_out_time',
'a.state',
'a.access',
'a.created',
'a.created_by',
'a.created_by_alias',
'a.modified',
'a.ordering',
'a.featured',
'a.language',
'a.hits',
'a.publish_up',
'a.publish_down',
'a.catid',
'l.title',
'l.image',
'uc.name',
'ag.title',
'c.title',
'c.created_user_id',
'c.level',
'ua.name',
'ws.title',
'ws.workflow_id',
'ws.condition',
'wa.stage_id',
'parent.id',
);
if (PluginHelper::isEnabled('content', 'vote'))
{
$query->select('COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count')
->join('LEFT', '#__content_rating AS v ON a.id = v.content_id');
array_push($associationsGroupBy, 'v.rating_sum', 'v.rating_count');
}
// Join over the associations.
if (Associations::isEnabled())
{
$query->select('CASE WHEN COUNT(asso2.id)>1 THEN 1 ELSE 0 END as association')
->join('LEFT', '#__associations AS asso ON asso.id = a.id AND asso.context=' . $db->quote('com_content.item'))
->join('LEFT', $db->quoteName('#__associations', 'asso2'), $db->quoteName('asso2.key') . ' = ' . $db->quoteName('asso.key'))
->group($db->quoteName($associationsGroupBy));
}
// Filter by access level.
$access = $this->getState('filter.access');
if (is_numeric($access))
{
$query->where('a.access = ' . (int) $access);
}
elseif (is_array($access))
{
$access = ArrayHelper::toInteger($access);
$access = implode(',', $access);
$query->where('a.access IN (' . $access . ')');
}
// Filter by featured.
$featured = (string) $this->getState('filter.featured');
if (in_array($featured, ['0','1']))
{
$query->where('a.featured =' . (int) $featured);
}
// Filter by access level on categories.
if (!$user->authorise('core.admin'))
{
$groups = implode(',', $user->getAuthorisedViewLevels());
$query->where('a.access IN (' . $groups . ')');
$query->where('c.access IN (' . $groups . ')');
}
// Filter by published state
$workflowStage = (string) $this->getState('filter.stage');
if (is_numeric($workflowStage))
{
$query->where('wa.stage_id = ' . (int) $workflowStage);
}
$condition = (string) $this->getState('filter.condition');
if ($condition !== '*')
{
if (is_numeric($condition))
{
$query->where($db->quoteName('ws.condition') . ' = ' . (int) $condition);
}
elseif (!is_numeric($workflowStage))
{
$query->whereIn(
$db->quoteName('ws.condition'),
[
ContentComponent::CONDITION_PUBLISHED,
ContentComponent::CONDITION_UNPUBLISHED
]
);
}
}
$query->where($db->quoteName('wa.extension') . '=' . $db->quote('com_content'));
// Filter by categories and by level
$categoryId = $this->getState('filter.category_id', array());
$level = $this->getState('filter.level');
if (!is_array($categoryId))
{
$categoryId = $categoryId ? array($categoryId) : array();
}
// Case: Using both categories filter and by level filter
if (count($categoryId))
{
$categoryId = ArrayHelper::toInteger($categoryId);
$categoryTable = Table::getInstance('Category', 'JTable');
$subCatItemsWhere = array();
foreach ($categoryId as $filter_catid)
{
$categoryTable->load($filter_catid);
$subCatItemsWhere[] = '(' .
($level ? 'c.level <= ' . ((int) $level + (int) $categoryTable->level - 1) . ' AND ' : '') .
'c.lft >= ' . (int) $categoryTable->lft . ' AND ' .
'c.rgt <= ' . (int) $categoryTable->rgt . ')';
}
$query->where('(' . implode(' OR ', $subCatItemsWhere) . ')');
}
// Case: Using only the by level filter
elseif ($level)
{
$query->where('c.level <= ' . (int) $level);
}
// Filter by author
$authorId = $this->getState('filter.author_id');
if (is_numeric($authorId))
{
$type = $this->getState('filter.author_id.include', true) ? '= ' : '<>';
$query->where('a.created_by ' . $type . (int) $authorId);
}
elseif (is_array($authorId))
{
$authorId = ArrayHelper::toInteger($authorId);
$authorId = implode(',', $authorId);
$query->where('a.created_by IN (' . $authorId . ')');
}
// Filter by search in title.
$search = $this->getState('filter.search');
if (!empty($search))
{
if (stripos($search, 'id:') === 0)
{
$query->where('a.id = ' . (int) substr($search, 3));
}
elseif (stripos($search, 'author:') === 0)
{
$search = $db->quote('%' . $db->escape(substr($search, 7), true) . '%');
$query->where('(ua.name LIKE ' . $search . ' OR ua.username LIKE ' . $search . ')');
}
elseif (stripos($search, 'content:') === 0)
{
$search = $db->quote('%' . $db->escape(substr($search, 8), true) . '%');
$query->where('(a.introtext LIKE ' . $search . ' OR a.fulltext LIKE ' . $search . ')');
}
else
{
$search = $db->quote('%' . str_replace(' ', '%', $db->escape(trim($search), true) . '%'));
$query->where('(a.title LIKE ' . $search . ' OR a.alias LIKE ' . $search . ' OR a.note LIKE ' . $search . ')');
}
}
// Filter on the language.
if ($language = $this->getState('filter.language'))
{
$query->where('a.language = ' . $db->quote($language));
}
// Filter by a single or group of tags.
$hasTag = false;
$tagId = $this->getState('filter.tag');
if (is_numeric($tagId))
{
$hasTag = true;
$query->where($db->quoteName('tagmap.tag_id') . ' = ' . (int) $tagId);
}
elseif (is_array($tagId))
{
$tagId = ArrayHelper::toInteger($tagId);
$tagId = implode(',', $tagId);
if (!empty($tagId))
{
$hasTag = true;
$query->where($db->quoteName('tagmap.tag_id') . ' IN (' . $tagId . ')');
}
}
if ($hasTag)
{
$query->join('LEFT', $db->quoteName('#__contentitem_tag_map', 'tagmap')
. ' ON ' . $db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id')
. ' AND ' . $db->quoteName('tagmap.type_alias') . ' = ' . $db->quote('com_content.article')
);
}
// Add the list ordering clause.
$orderCol = $this->state->get('list.ordering', 'a.id');
$orderDirn = $this->state->get('list.direction', 'DESC');
$query->order($db->escape($orderCol) . ' ' . $db->escape($orderDirn));
return $query;
}
/**
* Method to get all transitions at once for all articles
*
* @return array|boolean
*
* @since 4.0.0
*/
public function getTransitions()
{
// Get a storage key.
$store = $this->getStoreId('getTransitions');
// Try to load the data from internal storage.
if (isset($this->cache[$store]))
{
return $this->cache[$store];
}
$db = $this->getDbo();
$user = Factory::getUser();
$items = $this->getItems();
if ($items === false)
{
return false;
}
$ids = ArrayHelper::getColumn($items, 'stage_id');
$ids = ArrayHelper::toInteger($ids);
$ids = array_unique(array_filter($ids));
$ids[] = -1;
$this->cache[$store] = array();
try
{
if (count($ids))
{
Factory::getLanguage()->load('com_workflow', JPATH_ADMINISTRATOR);
$query = $db->getQuery(true);
$select = $db->quoteName(
array(
't.id',
't.title',
't.from_stage_id',
't.to_stage_id',
's.id',
's.title',
's.condition',
's.workflow_id'
),
array(
'value',
'text',
'from_stage_id',
'to_stage_id',
'stage_id',
'stage_title',
'stage_condition',
'workflow_id'
)
);
$query->select($select)
->from($db->quoteName('#__workflow_transitions', 't'))
->leftJoin(
$db->quoteName('#__workflow_stages', 's') . ' ON '
. $db->quoteName('t.from_stage_id') . ' IN (' . implode(',', $ids) . ')'
)
->where($db->quoteName('t.to_stage_id') . ' = ' . $db->quoteName('s.id'))
->where($db->quoteName('t.published') . ' = 1')
->where($db->quoteName('s.published') . ' = 1')
->order($db->quoteName('t.ordering'));
$transitions = $db->setQuery($query)->loadAssocList();
$workflow = new Workflow(['extension' => 'com_content']);
foreach ($transitions as $key => $transition)
{
if (!$user->authorise('core.execute.transition', 'com_content.transition.' . (int) $transition['value']))
{
unset($transitions[$key]);
}
else
{
// Update the transition text with final state value
$conditionName = $workflow->getConditionName($transition['stage_condition']);
$transitions[$key]['text'] .= ' [' . Text::_($conditionName) . ']';
}
}
$this->cache[$store] = $transitions;
}
}
catch (\RuntimeException $e)
{
$this->setError($e->getMessage());
return false;
}
return $this->cache[$store];
}
/**
* Method to get a list of articles.
* Overridden to add a check for access levels.
*
* @return mixed An array of data items on success, false on failure.
*
* @since 4.0.0
*/
public function getItems()
{
$items = parent::getItems();
$asset = new \Joomla\CMS\Table\Asset($this->getDbo());
foreach (array_keys($items) as $x)
{
$items[$x]->typeAlias = 'com_content.article';
$asset->loadByName('com_content.article.' . $items[$x]->id);
// Re-inject the asset id.
$items[$x]->asset_id = $asset->id;
}
return $items;
}
}
No other release has this exact content. See every version of this file.