<?php
/**
 * @package DJ-Classifieds
 * @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email: contact@dj-extensions.com
 */

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

class DjclassifiedsModelPoints extends DJClassifiedsModel
{			
	function getPoints()
	{
		$db = JFactory::getDBO();
		$user = JFactory::getUser();
			
		$query = "SELECT p.*, g.g_active, ga.g_all "
			."FROM #__djcf_points p "
			."LEFT JOIN (SELECT COUNT(id) as g_active, points_id FROM #__djcf_points_groups g " 
						."WHERE group_id IN (".($user->groups ? implode(',',$user->groups) : '0').") GROUP BY points_id) g ON g.points_id=p.id "
			."LEFT JOIN (SELECT COUNT(id) as g_all, points_id FROM #__djcf_points_groups g " 
						." GROUP BY points_id ) ga ON ga.points_id=p.id "
			."WHERE p.published=1 AND (g.g_active>0 OR ga.g_all IS NULL) "
			."ORDER BY p.ordering";
		$db->setQuery($query);
		$points = $db->loadObjectList();

		return $points;
	}
}