Directory:~$ /home/lmsyaran/www/administrator/components/com_rsmembership/models/

Upload File

[Home] [System Details] [Kill Me]

<?php
/**
 * @package	RSMembership!
 * @copyright	(c) 2009 - 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 RSMembershipModelSyslogs extends JModelList
{
	public function __construct($config = array()) {
		if (empty($config['filter_fields'])) {
			$config['filter_fields'] = array(
				'date', 'type',
			);
		}

		parent::__construct($config);
	}
	
	protected function getListQuery() {
		$db 	= JFactory::getDBO();
		$query 	= $db->getQuery(true);
		
		// get filtering states
		$search  = $this->getState('filter.search');
		
		$query->select($db->qn('id'))
			  ->select($db->qn('date'))
			  ->select($db->qn('type'))
			  ->select($db->qn('message'))
			 
->from($db->qn('#__rsmembership_syslog','l'));
		// search
		if ($search != '') {
			$search = $db->quote('%'.str_replace(' ',
'%', $db->escape($search, true)).'%', false);
			$query->where('('.$db->qn('type').' LIKE
'.$search.' OR '.$db->qn('message').' LIKE
'.$search.')');
		}
		
		// order by
		$query->order($db->qn($this->getState('list.ordering',
'date')).'
'.$db->escape($this->getState('list.direction',
'desc')));
		
		return $query;
	}
	
	protected function populateState($ordering = null, $direction = null) {
		$this->setState('filter.search', 
$this->getUserStateFromRequest($this->context.'.filter.search',
 'filter_search'));
		
		// List state information.
		parent::populateState('date', 'desc');
	}

	public function getFilterBar() {
		require_once
JPATH_COMPONENT.'/helpers/adapters/filterbar.php';
		
		$options = array();
		$options['search'] = array(
			'label' => JText::_('JSEARCH_FILTER'),
			'value' => $this->getState('filter.search')
		);
		$options['limitBox']  =
$this->getPagination()->getLimitBox();
		$options['listDirn']  =
$this->getState('list.direction', 'desc');
		$options['listOrder'] =
$this->getState('list.ordering', 'date');
		$options['sortFields'] = array(
			JHtml::_('select.option', 'date',
JText::_('COM_RSMEMBERSHIP_DATE')),
			JHtml::_('select.option', 'type',
JText::_('COM_RSMEMBERSHIP_SYSLOGS_TYPE'))
		);
		$options['rightItems'] = array();
		
		$bar = new RSFilterBar($options);
		
		return $bar;
	}
	
	public function getSideBar() {
		require_once JPATH_COMPONENT.'/helpers/toolbar.php';
		
		return RSMembershipToolbarHelper::render();
	}
}