73 lines
1.7 KiB
PHP
73 lines
1.7 KiB
PHP
<?php
|
|
/**
|
|
* @package Joomla.Administrator
|
|
* @subpackage com_foos
|
|
*
|
|
* @copyright Copyright (C) 2005 - 2020 Open Source Matters, Inc. All rights reserved.
|
|
* @license GNU General Public License version 2 or later; see LICENSE.txt
|
|
*/
|
|
|
|
namespace FooNamespace\Component\Foos\Administrator\Model;
|
|
|
|
\defined('_JEXEC') or die;
|
|
|
|
use Joomla\CMS\MVC\Model\ListModel;
|
|
|
|
/**
|
|
* Methods supporting a list of foo records.
|
|
*
|
|
* @since __BUMP_VERSION__
|
|
*/
|
|
class FoosModel extends ListModel
|
|
{
|
|
/**
|
|
* Constructor.
|
|
*
|
|
* @param array $config An optional associative array of configuration settings.
|
|
*
|
|
* @see \JControllerLegacy
|
|
*
|
|
* @since __BUMP_VERSION__
|
|
*/
|
|
public function __construct($config = [])
|
|
{
|
|
parent::__construct($config);
|
|
}
|
|
/**
|
|
* Build an SQL query to load the list data.
|
|
*
|
|
* @return \JDatabaseQuery
|
|
*
|
|
* @since __BUMP_VERSION__
|
|
*/
|
|
protected function getListQuery()
|
|
{
|
|
// Create a new query object.
|
|
$db= $this->getDatabase();
|
|
$query = $db->getQuery(true);
|
|
|
|
// Select the required fields from the table.
|
|
$query->select(
|
|
$db->quoteName(['a.id', 'a.name', 'a.alias', 'a.access', 'a.catid'])
|
|
);
|
|
|
|
$query->from($db->quoteName('#__foos_details', 'a'));
|
|
|
|
// Join over the asset groups.
|
|
$query->select($db->quoteName('ag.title', 'access_level'))
|
|
->join(
|
|
'LEFT',
|
|
$db->quoteName('#__viewlevels', 'ag') . ' ON ' . $db->quoteName('ag.id') . ' = ' . $db->quoteName('a.access')
|
|
);
|
|
|
|
// Join over the categories.
|
|
$query->select($db->quoteName('c.title', 'category_title'))
|
|
->join(
|
|
'LEFT',
|
|
$db->quoteName('#__categories', 'c') . ' ON ' . $db->quoteName('c.id') . ' = ' . $db->quoteName('a.catid')
|
|
);
|
|
|
|
return $query;
|
|
}
|
|
}
|