Source for file weblinks.php
Documentation is available at weblinks.php
* @package Joomla.Administrator
* @subpackage com_weblinks
* @copyright Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
* Methods supporting a list of weblink records.
* @package Joomla.Administrator
* @subpackage com_weblinks
* @param array An optional associative array of configuration settings.
if (empty($config['filter_fields']))
$config['filter_fields'] =
array(
'checked_out', 'a.checked_out',
'checked_out_time', 'a.checked_out_time',
'catid', 'a.catid', 'category_title',
'access', 'a.access', 'access_level',
'created_by', 'a.created_by',
'ordering', 'a.ordering',
'featured', 'a.featured',
'language', 'a.language',
'publish_up', 'a.publish_up',
'publish_down', 'a.publish_down',
* Method to auto-populate the model state.
* Note. Calling getState in this method will result in recursion.
protected function populateState($ordering =
null, $direction =
null)
// Load the filter state.
$this->setState('filter.search', $search);
$this->setState('filter.access', $accessId);
$this->setState('filter.state', $published);
$this->setState('filter.category_id', $categoryId);
$this->setState('filter.language', $language);
// List state information.
* 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
* @param string $id A prefix for the store id.
* @return string A store id.
$id .=
':' .
$this->getState('filter.search');
$id .=
':' .
$this->getState('filter.access');
$id .=
':' .
$this->getState('filter.state');
$id .=
':' .
$this->getState('filter.category_id');
$id .=
':' .
$this->getState('filter.language');
* Build an SQL query to load the list data.
// Create a new query object.
$query =
$db->getQuery(true);
// Select the required fields from the table.
'a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid,' .
'a.state, a.access, a.ordering,' .
'a.language, a.publish_up, a.publish_down'
$query->from($db->quoteName('#__weblinks') .
' AS a');
// Join over the language
$query->select('l.title AS language_title')
->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')
->join('LEFT', '#__categories AS c ON c.id = a.catid');
// Filter by access level.
if ($access =
$this->getState('filter.access'))
$query->where('a.access = ' . (int)
$access);
// Implement View Level Access
if (!$user->authorise('core.admin'))
$groups =
implode(',', $user->getAuthorisedViewLevels());
$query->where('a.access IN (' .
$groups .
')');
// Filter by published state
$published =
$this->getState('filter.state');
$query->where('a.state = ' . (int)
$published);
elseif ($published ===
'')
$query->where('(a.state IN (0, 1))');
$categoryId =
$this->getState('filter.category_id');
$query->where('a.catid = ' . (int)
$categoryId);
// Filter by search in title
$search =
$this->getState('filter.search');
$query->where('a.id = ' . (int)
substr($search, 3));
$search =
$db->quote('%' .
$db->escape($search, true) .
'%');
$query->where('(a.title LIKE ' .
$search .
' OR a.alias LIKE ' .
$search .
')');
// Filter on the language.
if ($language =
$this->getState('filter.language'))
$query->where('a.language = ' .
$db->quote($language));
// Filter by a single tag.
$query->where($db->quoteName('tagmap.tag_id') .
' = ' . (int)
$tagId)
'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_weblinks.weblink')
// Add the list ordering clause.
$orderCol =
$this->state->get('list.ordering');
$orderDirn =
$this->state->get('list.direction');
if ($orderCol ==
'a.ordering' ||
$orderCol ==
'category_title')
$orderCol =
'c.title ' .
$orderDirn .
', a.ordering';
$query->order($db->escape($orderCol .
' ' .
$orderDirn));
//echo nl2br(str_replace('#__','jos_',$query));
Documentation generated on Tue, 19 Nov 2013 15:18:30 +0100 by phpDocumentor 1.4.3