File manager - Edit - /home/jardides/www/Jardi-design/administrator/components/com_hotspots/models/kmls.php
Back
<?php /** * @package Hotspots * @author DanielDimitrov <daniel@compojoom.com> * @date 13.10.14 * * @copyright Copyright (C) 2008 - 2013 compojoom.com . All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE */ defined('_JEXEC') or die(); jimport('joomla.application.component.modellist'); /** * Class HotspotsModelKmls * * @since 3.0 */ class HotspotsModelKmls extends JModelList { /** * @var string The prefix to use with controller messages. * @since 1.6 */ protected $text_prefix = 'COM_HOTSPOTS'; /** * Method to auto-populate the model state. * * Note. Calling getState in this method will result in recursion. * * @since 1.6 */ protected function populateState($ordering = null, $direction = null) { // Load the filter state. $search = $this->getUserStateFromRequest($this->context . '.filter.search', 'filter_search'); $this->setState('filter.search', $search); $published = $this->getUserStateFromRequest($this->context . '.filter.published', 'filter_published', ''); $this->setState('filter.published', $published); // List state information. parent::populateState('kmls.title', 'asc'); } protected function getListQuery() { // Create a new query object. $db = $this->getDbo(); $query = $db->getQuery(true); $query->select('kmls.*, cat.title AS cat_name , u.name as user_name') ->from('#__hotspots_kmls AS kmls') ->leftJoin('#__categories as cat ON cat.id = kmls.catid') ->leftJoin('#__users as u ON u.id = kmls.created_by'); // Filter by published state $published = $this->getState('filter.published'); if (is_numeric($published)) { $query->where('kmls.state = ' . (int) $published); } elseif ($published === '') { $query->where('(kmls.state IN (0, 1))'); } // Filter by search in title $search = $this->getState('filter.search'); if (!empty($search)) { if (stripos($search, 'id:') === 0) { $query->where('kmls.id = ' . (int) substr($search, 3)); } else { $search = $db->Quote('%' . $db->escape($search, true) . '%'); $query->where('(kmls.name LIKE ' . $search . ')'); } } // Add the list ordering clause. $orderCol = $this->state->get('list.ordering', 'kmls.title'); $orderDirn = $this->state->get('list.direction', 'asc'); $query->order($db->escape($orderCol . ' ' . $orderDirn)); return $query; } }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings