<?php
/**
 *  @package AdminTools
 *  @copyright Copyright (c)2010-2013 Nicholas K. Dionysopoulos
 *  @license GNU General Public License version 3, or later
 *  @version $Id$
 */

// Protect from unauthorized access
defined('_JEXEC') or die();

class AdmintoolsModelWafexceptions extends FOFModel
{
	public function buildQuery($overrideLimits = false)
	{
		$db = $this->getDbo();
		$query = $db->getQuery(true)
			->select(array('*'))
			->from($db->quoteName('#__admintools_wafexceptions'));

		$fltOption			= $this->getState('foption', null, 'string');
		if($fltOption) {
			$fltOption = '%'.$fltOption.'%';
			$query->where($db->quoteName('option').' LIKE '.$db->quote($fltOption));
		}
		
		$fltView			= $this->getState('fview', null, 'string');
		if($fltView) {
			$fltView = '%'.$fltView.'%';
			$query->where($db->quoteName('view').' LIKE '.$db->quote($fltView));
		}
		
		$fltQuery			= $this->getState('fquery', null, 'string');
		if($fltQuery) {
			$fltQuery = '%'.$fltQuery.'%';
			$query->where($db->quoteName('query').' LIKE '.$db->quote($fltQuery));
		}

		if(!$overrideLimits) {
			$order = $this->getState('filter_order',null,'cmd');
			if(!in_array($order, array_keys($this->getTable()->getData()))) $order = 'id';
			$dir = $this->getState('filter_order_Dir', 'ASC', 'cmd');
			$query->order($db->qn($order).' '.$dir);
		}

		return $query;
	}
}