Spade

Mini Shell

Directory:~$ /home/lmsyaran/www/administrator/components/com_rsticketspro/models/
Upload File

[Home] [System Details] [Kill Me]
Current File:~$ /home/lmsyaran/www/administrator/components/com_rsticketspro/models/notes.php

<?php
/**
 * @package    RSTickets! Pro
 *
 * @copyright  (c) 2010 - 2016 RSJoomla!
 * @link       https://www.rsjoomla.com
 * @license    GNU General Public License
http://www.gnu.org/licenses/gpl-3.0.en.html
 */

defined('_JEXEC') or die('Restricted access');

class RsticketsproModelNotes extends JModelList
{
	public function __construct($config = array())
	{
		if (empty($config['filter_fields'])) {
			$config['filter_fields'] = array(
				'date'
			);
		}

		parent::__construct($config);
	}
	
	public function getId()
	{
		return
JFactory::getApplication()->input->getInt('ticket_id');
	}
	
	protected function getListQuery()
	{
		$db 	= JFactory::getDbo();
		$query 	= $db->getQuery(true);
		
		$query->select('*')
			  ->from('#__rsticketspro_ticket_notes')
			 
->where($db->qn('ticket_id').'='.$db->q($this->getId()))
			  ->order($db->qn($this->getState('list.ordering',
'date')).'
'.$db->escape($this->getState('list.direction',
'desc')));
		
		return $query;
	}
	
	protected function populateState($ordering = null, $direction = null)
	{
		// List state information.
		parent::populateState('date', 'desc');
	}
}