<?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 DjclassifiedsModelUserPoints extends DJClassifiedsModel
{
	function getPoints()
	{
		$app = JFactory::getApplication();
		$user = JFactory::getUser();
		$par = $app->getParams('com_djclassifieds');

		$limitstart	= $app->input->getInt('limitstart', 0);
		$limit = $app->input->getInt('limit', $par->get('limit_djitem_show','7'));
		$order = $app->input->getCmd('order', 'date');
		$ord_t = $app->input->getCmd('ord_t', 'desc');
			
		$ord = "date ";
		if($order == "points"){
			$ord = "points ";
		}
		$ord .= $ord_t == 'desc' ? 'DESC' : 'ASC';
		
		$query = "SELECT * "
				."FROM #__djcf_users_points "
				."WHERE user_id=".$user->id." "
				."ORDER BY ".$ord;
		$points = $this->_getList($query, $limitstart, $limit);
	
		foreach($points as $key => $point){
			if(!empty($point->desc_json)){
				$points[$key]->description = DJClassifiedsTheme::decodeDescJson($point->desc_json);
			}
		}
			
		return $points;
	}
	
	function getCountPoints()
	{
		$db = JFactory::getDBO();	
		$user = JFactory::getUser();

		$query = "SELECT count(id) FROM #__djcf_users_points WHERE user_id=".$user->id;	
		$db->setQuery($query);
		$points_count = $db->loadResult();

		return $points_count;
	}
}