<?php
/**
* @package RSFeedback!
* @copyright (C) 2010-2018 www.rsjoomla.com
* @license GPL, http://www.gnu.org/copyleft/gpl.html
*/

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

use Joomla\CMS\MVC\Model\ListModel;
use Joomla\CMS\Factory;

class RSFeedbackModelFlags extends ListModel
{
	public function __construct($config = array()) {
		if (empty($config['filter_fields'])) {
			$config['filter_fields'] = array(
				'f.ordering', 'f.name', 'f.published'
			);
		}
		parent::__construct($config);
	}

	protected function getListQuery() {
		$db			= Factory::getDbo();
		$query		= $db->getQuery(true);

		$query->select('*')->from($db->qn('#__rsfeedback_flags').' f');

		// search filter
		if ($search = $this->getState('filter.search')) 
			$query->where("name LIKE ".$db->q("%".$search."%"));

		// order by filters
		$listOrdering  	= $this->getState('list.ordering', 'f.ordering');
		$listDirection 	= $this->getState('list.direction', 'asc');

		$query->order($db->qn($listOrdering).' '.$listDirection);

		return $query;
	}
}