<?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 RSFeedbackModelComments extends ListModel
{
	public function __construct($config = array()) {
		if (empty($config['filter_fields'])) {
			$config['filter_fields'] = array(
				'c.name', 'c.text', 'feedbacktitle', 'c.date', 'c.published', 'feedback_id'
			);
		}

		parent::__construct($config);
	}

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

		$query->select('c.*')->select($db->qn('f.title','feedbacktitle'))->from($db->qn('#__rsfeedback_comments','c'));
		$query->join('left', $db->qn('#__rsfeedback_feedbacks','f').' ON '.$db->qn('c.feedback_id').' = '.$db->qn('f.id'));
		
		// search filter
		if ($search = $this->getState('filter.search')) 
			$query->where($db->qn("c.name")." LIKE '%".$search."%' OR ".$db->qn("c.text")." LIKE '%".$search."%'");

		// for the selected filter
		if ($feedback_id = $this->getState('filter.feedback_id')) 
			$query->where($db->qn('c.feedback_id') .' = '. $db->q($feedback_id));

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

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

		return $query;
	}
}