File manager - Edit - /home/verseaumee/ptitsanes/administrator/components/com_solidres/models/reservationnotes.php
Back
<?php /** ------------------------------------------------------------------------ SOLIDRES - Accommodation booking extension for Joomla ------------------------------------------------------------------------ * @author Solidres Team <contact@solidres.com> * @website https://www.solidres.com * @copyright Copyright (C) 2013 - 2019 Solidres. All Rights Reserved. * @license GNU General Public License version 3, or later ------------------------------------------------------------------------ */ defined('_JEXEC') or die('Restricted access'); /** * ReservationNotes model * * @package Solidres * @subpackage ReservationNote * @since 0.3.0 */ class SolidresModelReservationNotes extends JModelList { /** * Constructor. * * @param array An optional associative array of configuration settings. * * @see JController * @since 1.6 */ public function __construct($config = array()) { parent::__construct($config); } public function getItems() { $items = parent::getItems(); return $items; } /** * Build an SQL query to load the list data. * * @return JDatabaseQuery * @since 1.6 */ protected function getListQuery() { $db = $this->getDbo(); $query = $db->getQuery(true); $query->select( $this->getState( 'list.select', 'a.*, u.username as username') ); $query->from($db->quoteName('#__sr_reservation_notes') . ' AS a'); $query->join('LEFT', '#__users as u ON a.created_by = u.id'); // Filter by reservation. $reservationId = $this->getState('filter.reservation_id'); if (is_numeric($reservationId)) { $query->where('a.reservation_id = ' . (int) $reservationId); } // Filter by visibility in front end $visibleInFrontend = $this->getState('filter.visible_in_frontend'); if (is_numeric($visibleInFrontend)) { $query->where('a.visible_in_frontend = 1'); } $query->order('a.created_date ASC'); return $query; } }
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings