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

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

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

class RSFeedbackModelCategories extends ListModel
{
	public function __construct($config = array()) {
		if (empty($config['filter_fields'])) {
			$config['filter_fields'] = array('c.ordering', 'c.name', 
				'feedback_count', 'c.anonymous_voting',
				'c.anonymous_feedbacks', 'c.feedback_captcha', 'c.published'
			);
		}
		
		parent::__construct($config);
	}
	
	protected function getListQuery() {
		$db			= Factory::getDbo();
		$query		= $db->getQuery(true);
		$subquery	= $db->getQuery(true);

		$query->select('c.*')->select('('.$subquery->select('COALESCE(count(*),0)')->from($db->qn('#__rsfeedback_feedbacks','f'))->where($db->qn('f.cat_id').' = '.$db->qn('c.id')).' ) as feedback_count')
			  ->from($db->qn('#__rsfeedback_categories','c'));
		
		if ($search = $this->getState('filter.search'))
			$query->where($db->qn('c.name').' LIKE '.$db->q("%".$search."%"));

		$listOrdering  	= $this->getState('list.ordering', 'c.ordering');
		$listDirection 	= $this->getState('list.direction', 'asc');

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

		return $query;
	}
	
	protected function populateState($ordering = null, $direction = null) {
		parent::populateState('c.ordering', 'asc');
    }
}