File manager - Edit - /home/ferretapmx/public_html/administrator/components/com_speasyimagegallery/models/albums.php
Back
<?php /** * @package com_speasyimagegallery * @author JoomShaper http://www.joomshaper.com * @copyright Copyright (c) 2010 - 2025 JoomShaper * @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPLv2 or later */ // No direct access to this file defined('_JEXEC') or die('Restricted access'); use Joomla\CMS\Factory; use Joomla\CMS\Table\Table; use Joomla\Utilities\ArrayHelper; use Joomla\CMS\MVC\Model\ListModel; use Joomla\Database\DatabaseInterface; class SpeasyimagegalleryModelAlbums extends ListModel { public function __construct($config = array()) { if (empty($config['filter_fields'])) { $config['filter_fields'] = array( 'id','a.id', 'title','a.title', 'featured','a.featured', 'checked_out', 'a.checked_out', 'checked_out_time', 'a.checked_out_time', 'created_by','a.created_by', 'published','a.published', 'catid', 'a.catid', 'category_title', 'access', 'a.access', 'access_level', 'created_on','a.created_on', 'ordering', 'a.ordering', 'hits', 'a.hits', 'language','a.language', 'category_id', ); } parent::__construct($config); } protected function populateState($ordering = 'a.id', $direction = 'desc') { $app = Factory::getApplication(); $context = $this->context; $fullOrdering = $app->getUserStateFromRequest( $this->context . '.list.fullordering', 'list[fullordering]', '', 'string' ); if (!empty($fullOrdering)) { $parts = explode(' ', $fullOrdering); $this->setState('list.ordering', $parts[0]); $this->setState('list.direction', $parts[1] ?? 'ASC'); } else { $this->setState('list.ordering', $ordering); $this->setState('list.direction', $direction); } $search = $this->getUserStateFromRequest($this->context . '.filter.search', 'filter_search'); $this->setState('filter.search', $search); $access = $this->getUserStateFromRequest($this->context . '.filter.access', 'filter_access'); $this->setState('filter.access', $access); $published = $this->getUserStateFromRequest($this->context . '.filter.published', 'filter_published', ''); $this->setState('filter.published', $published); $categoryId = $this->getUserStateFromRequest($this->context . '.filter.category_id', 'filter_category_id'); $this->setState('filter.category_id', $categoryId); $language = $this->getUserStateFromRequest($this->context . '.filter.language', 'filter_language', ''); $this->setState('filter.language', $language); // List state information. parent::populateState($ordering, $direction); } protected function getStoreId($id = '') { // Compile the store id. $id .= ':' . $this->getState('filter.search'); $id .= ':' . $this->getState('filter.access'); $id .= ':' . $this->getState('filter.published'); $id .= ':' . $this->getState('filter.category_id'); $id .= ':' . $this->getState('filter.language'); return parent::getStoreId($id); } /** * Method to build an SQL query to load the list data. * * @return string An SQL query */ protected function getListQuery() { $db = Factory::getContainer()->get(DatabaseInterface::class); $query = $db->getQuery(true); // Create the base select statement. $query->select( $this->getState( 'list.select', 'a.*' ) ); $query->from('#__speasyimagegallery_albums as a'); $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'); $query->select('ua.name AS author_name') ->join('LEFT', '#__users AS ua ON ua.id = a.created_by'); $query->select('ug.title AS access_title') ->join('LEFT','#__viewlevels AS ug ON ug.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 published state $published = $this->getState('filter.published'); if (is_numeric($published)) { $query->where('a.published = ' . (int) $published); } elseif ($published === '') { $query->where('(a.published IN (0, 1))'); } // Filter by featured state $featured = $this->getState('filter.featured'); if (is_numeric($featured)) { $query->where('a.featured = ' . (int) $featured); } // Filter by a single or group of categories. $baselevel = 1; $categoryId = $this->getState('filter.category_id'); if (is_numeric($categoryId)) { $cat_tbl = Table::getInstance('Category', 'JTable'); $cat_tbl->load($categoryId); $rgt = $cat_tbl->rgt; $lft = $cat_tbl->lft; $baselevel = (int) $cat_tbl->level; $query->where('c.lft >= ' . (int) $lft) ->where('c.rgt <= ' . (int) $rgt); } elseif (is_array($categoryId)) { ArrayHelper::toInteger($categoryId); $categoryId = implode(',', $categoryId); $query->where('a.catid IN (' . $categoryId . ')'); } // Filter by language if ($language = $this->getState('filter.language')) { $query->where('a.language = ' . $db->quote($language)); } $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('(uc.name LIKE ' . $search . ' OR uc.username LIKE ' . $search . ')'); } else { $search = $db->quote('%' . $db->escape($search, true) . '%'); $query->where('(a.title LIKE ' . $search . ')'); } } // Filter by access level $access_level = $this->getState('filter.access'); if (!empty($access_level)) { $query->where('a.access = ' . (int) $access_level); } // Ordering $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; } public function setFeatured($cid, $value) { if (empty($cid)) { return false; } $db = Factory::getContainer()->get(DatabaseInterface::class); $query = $db->getQuery(true) ->update($db->quoteName('#__speasyimagegallery_albums')) ->set($db->quoteName('featured') . ' = ' . (int) $value) ->where('id IN (' . implode(',', $cid) . ')'); $db->setQuery($query); // Execute the query return $db->execute(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.2.32 | Generation time: 0.06 |
proxy
|
phpinfo
|
Settings