<?php
/**
* @copyright (C) 2013 iJoomla, Inc. - All rights reserved.
* @license GNU General Public License, version 2 (http://www.gnu.org/licenses/gpl-2.0.html)
* @author iJoomla.com <webmaster@ijoomla.com>
* @url https://www.jomsocial.com/license-agreement
* The PHP code portions are distributed under the GPL license. If not otherwise stated, all images, manuals, cascading style sheets, and included JavaScript *are NOT GPL, and are released under the IJOOMLA Proprietary Use License v1.0
* More info at https://www.jomsocial.com/license-agreement
*/

use Joomla\CMS\Factory;
use Joomla\CMS\Table\Table;

// Disallow direct access to this file
defined('_JEXEC') or die('Restricted access');

/**
 * JomSocial Table Model
 */
class CommunityTableUsers extends Table
{
	var $userid			= null;
	var $status			= null;
	var $points			= null;
	var $posted_on		= null;
	var $avatar			= null;
	var $thumb			= null;
	var $invite			= null;
	var $params			= null;
	var $view			= null;
	var $friendcount	= null;
	var $usergroup		= null;

	public function __construct(&$db)
	{
		parent::__construct('#__community_users','userid', $db);
	}

	public function getFriendCount()
	{
		$db		= Factory::getDBO();

		$query = 'SELECT COUNT(*) FROM '.$db->quoteName( '#__community_connection').' AS ' . $db->quoteName('a');
		$query .= ' INNER JOIN '.$db->quoteName( '#__users').' AS ' . $db->quoteName('b') . ' ON ' . $db->quoteName('a') . '.' .$db->quoteName('connect_to') . ' = ' . $db->quoteName('b') . '.' . $db->quoteName('id');
		$query .= ' WHERE ' . $db->quoteName('a') . '.' . $db->quoteName('connect_from') . ' = '.$db->Quote( $this->userid );
		$query .= ' AND ' . $db->quoteName('a'). '.' . $db->quoteName('STATUS') . ' = ' . $db->Quote(1);

		$db->setQuery( $query );
		$count	= $db->loadResult();

		return $count;
	}
}