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

// no direct access
defined('_JEXEC') or die('Restricted access');

use Joomla\CMS\Factory;

class modRsfeedbackHelper
{
	public static function escape($text) {
		return htmlentities($text, ENT_COMPAT, 'utf-8');
	}
	
    public static function getFeedbacks( $params ) {
		$db 			= Factory::getDBO();
		$query			= $db->getQuery(true);
		$sort_filter 	= $params->get('SortBy','votes');
		$order  		= $params->get('SortOrder', 'DESC');
		$categories		= $params->get('categories', array());

		$query->select($db->qn('f.id').', '.$db->qn('f.title').', '.$db->qn('f.cat_id').', COALESCE(SUM(uv.number_points),0) as votes')
			->from($db->qn('#__rsfeedback_feedbacks', 'f'))
			->join('left', $db->qn('#__rsfeedback_user_votes', 'uv').' ON '.$db->qn('uv.feedback_id').' = '.$db->qn('f.id'));
				
		if (!empty($categories)) 
			$query->where($db->qn('f.cat_id').' IN (\''.implode('\', \'', $categories).'\')');

		$query->where($db->qn('f.published').' = '.$db->q('1'))->group($db->qn('f.title'))->order($db->qn($sort_filter).' '.$db->escape($order));

		$db->setQuery($query, 0,$params->get( 'FeedbackLimit', 2 ));

		return $db->loadObjectList();
    }
}