<?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\Language\Text;
use Joomla\CMS\Table\Table;

defined('_JEXEC') or die('Restricted access');

require_once( JPATH_ROOT .'/components/com_community/models/models.php' );

class CommunityModelProfile extends JCCModel
{
	var $_data = null;
	var $_profile;

	var $_user	= '';
	var $_allField = null;

	var $_genderId = null;

	public function _getUngroup()
	{
		$obj = new stdClass();
		$obj->id = 0;
		$obj->type =  'group';
		$obj->ordering =  2;
		$obj->published =  1;
		$obj->min =  0;
		$obj->max =  0;
		$obj->name =  'ungrouped';
		$obj->tips =  '';
		$obj->visible =  1;
		$obj->required =  1;
		$obj->searchable =  1 ;
		$obj->fields = array();

		return $obj;
	}

	public function aliasExists( $alias , $userId = '' )
	{
		// For backward compatibility, prior to 2.0, this method only has 1 parameter.
		if( empty($userId ) )
		{
			$my		= CFactory::getUser();
			$userId	= $my->id;
		}

		$db		= Factory::getDBO();
		$config	= CFactory::getConfig();

		$query	= 'SELECT COUNT(*) FROM '
				. $db->quoteName( '#__users' ) . ' AS a '
				. ' INNER JOIN ' . $db->quoteName( '#__community_users' ) . ' AS b '
				. ' ON b.'.$db->quoteName('userid').'=a.'.$db->quoteName('id')
				. ' WHERE ( CONCAT_WS("-", a.'.$db->quoteName('id').' , LOWER( REPLACE(a.' . $db->quoteName( $config->get('displayname') ) . ', " " , "-") ) )=LOWER(' . $db->Quote( $alias ) . ') '
				. 'OR b.'.$db->quoteName('alias').'=' . $db->Quote( $alias ) . ') '
				. 'AND b.'.$db->quoteName('userid').'!=' . $db->Quote( $userId );
		$db->setQuery( $query );
		$exists	= $db->loadResult() > 0 ? true : false;

		return $exists;
	}

	public function getGroup( $fieldId )
	{
		$db		= $this->getDBO();
		$field	= Table::getInstance( 'ProfileField' , 'CTable' );
		$field->load( $fieldId );

		$query	= 'SELECT * '
				. 'FROM ' . $db->quoteName( '#__community_fields' ) . ' '
				. 'WHERE ' . $db->quoteName( 'ordering' ) . '<' . $field->ordering . ' '
				. 'AND ' . $db->quoteName( 'type' ) . '=' . $db->Quote( 'group' ) . ' '
				. 'ORDER BY '.$db->quoteName('ordering').' DESC';
		$db->setQuery( $query );

		$result	= $db->loadObject();

		return $db->loadObject();
	}

	public function _loadAllFields($filter = array() , $type = COMMUNITY_DEFAULT_PROFILE )
	{
		if($this->_allField == null)
		{
			$this->_allField = array();
			$db		= Factory::getDBO();

			//setting up the search condition is there is any
			$wheres = array();
			if(! empty($filter))
			{
				foreach($filter as $column => $value)
				{
					$wheres[] = $db->quoteName($column) .' = ' . $db->Quote($value);
				}
			}

			if( $type != COMMUNITY_DEFAULT_PROFILE )
			{
				$query	= 'SELECT '.$db->quoteName('field_id').' FROM ' . $db->quoteName( '#__community_profiles_fields' )
						. ' WHERE ' . $db->quoteName( 'parent' ) . '=' . $db->Quote( $type );
				$db->setQuery( $query );
				$filterIds	= $db->loadColumn();

			  if(empty($filterIds)){
					$filterIds = array(0);
				}
				$wheres[]	= $db->quoteName('id').' IN (' . implode( ',' , $filterIds ) . ')';
			}

			$query	= 'SELECT * FROM ' . $db->quoteName( '#__community_fields' );

			if(! empty($wheres))
			{
			   $query .= " WHERE ".implode(' AND ', $wheres);
			}

			$query .= ' ORDER BY '.$db->quoteName('ordering');

			$db->setQuery($query);

			$fields = $db->loadObjectList();

			$group	= $ungrouped = Text::_('COM_COMMUNITY_UNGROUPED');

			for($i = 0; $i < count($fields); $i++)
			{
				if($fields[$i]->type == 'group')
				{
					$group	= $fields[$i]->name;
					$this->_allField[$group] = $fields[$i];
					$this->_allField[$group]->fields = array();
				}
				else
				{
					// Re-arrange options to be an array by splitting them into an array
					if(isset($fields[$i]->options) && $fields[$i]->options != '')
					{
						$options	= $fields[$i]->options;
						$options	= explode("\n", $options);

						array_walk($options, array('CStringHelper' , 'trim') );
						$fields[$i]->options	= $options;
					}

					if($group == $ungrouped && empty($this->_allField[$group]))
					{
						$this->_allField[$group] = $this->_getUngroup();
					}

					$this->_allField[$group]->fields[] =	$fields[$i];
				}
			}

            //trigger field load to allow 3rd party developer to manipulate the fields
            $app = CAppPlugins::getInstance();
            $app->loadApplications();
            $this->_allField = $app->triggerEvent( 'onAllFieldsLoad' , array($this->_allField));
		}
	}

	/**
	 * Return the complete (but empty) profile structure
	 */
	public function &getAllFields($filter = array() , $profileType = COMMUNITY_DEFAULT_PROFILE )
	{
		$this->_loadAllFields($filter , $profileType );
		return $this->_allField;
	}

	public function _bind($data){
	}

	/**
	 * Returns an object of user's data
	 *
	 * @access	public
	 * @param	none
	 * @returns object  An object that is related to user's data
	 */
	public function &getData()
	{
		$db	= $this->getDBO();

		$wheres	  = array();
		$wheres[] = $db->quoteName('block').' = '.$db->Quote('0');
		$wheres[] = $db->quoteName('id').' = '. $db->Quote($this->getState('id'));

		$query = "SELECT *"
			. ' FROM '.$db->quoteName('#__users')
			. ' WHERE ' . implode( ' AND ', $wheres )
			. ' ORDER BY '.$db->quoteName('id').' DESC ';

		$db->setQuery( $query );

		try {
			$result = $db->loadObject();
		} catch (Exception $e) {
			Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
		}

		return $result;
	}

	public function getProfileName( $fieldCode )
	{
		$db		= $this->getDBO();

		$query	= 'SELECT ' . $db->quoteName('name') . ' FROM '
				. $db->quoteName( '#__community_fields') . ' WHERE '
				. $db->quoteName( 'fieldcode') . '=' . $db->Quote( $fieldCode );

		$db->setQuery( $query );
		try {
			$name = $db->loadResult();
		} catch (Exception $e) {
			Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
		}

		return $name;
	}

	/**
	 * Wrapper method
	 */
	public function getProfile( $userId = null )
	{
		return $this->getViewableProfile( $userId );
	}

	/**
	 * Returns an array of custom profiles which are created from the back end.
	 *
	 * @access	public
	 * @param	string 	User's id.
	 * @returns array  An objects of custom fields.
	 */
	public function getViewableProfile( $userId	= null , $profileType = COMMUNITY_DEFAULT_PROFILE )
	{
		$db			= $this->getDBO();
		$data		= array();

		// Return with empty data
		if($userId == null || $userId == '')
		{
			//return false;
		}

		$user		= CFactory::getUser($userId);

		if($user->id == null){
			//return false;
		}

		$data['id']		= $user->id;
		$data['name']	= $user->name;
		$data['email']	= $user->email;

		// Attach custom fields into the user object
		$query	= 'SELECT field.*, value.'.$db->quoteName('value').',value.'.$db->quoteName('access')
				.', value.'.$db->quoteName('params').' as fieldparams '
				. ' FROM ' . $db->quoteName('#__community_fields') . ' AS field '
				. ' LEFT JOIN ' . $db->quoteName('#__community_fields_values') . ' AS value '
 				. ' ON field.'.$db->quoteName('id').'=value.'.$db->quoteName('field_id').' AND value.'.$db->quoteName('user_id').'=' . $db->Quote($userId)
				. ' WHERE field.'.$db->quoteName('published').'=' . $db->Quote('1') . ' AND '
 				. ' field.'.$db->quoteName('visible').'>=' . $db->Quote('1');

 		// Build proper query for multiple profile types.
		if( $profileType != COMMUNITY_DEFAULT_PROFILE )
		{
			$query2	= 'SELECT '.$db->quoteName('field_id').' FROM ' . $db->quoteName( '#__community_profiles_fields' )
					. ' WHERE ' . $db->quoteName( 'parent' ) . '=' . $db->Quote( $profileType );
			$db->setQuery( $query2 );
			$filterIds	= $db->loadColumn();

			if( empty( $filterIds ) )
			{
				$data['fields']	= array();
				return $data;
			}

			$query	.= ' AND field.'.$db->quoteName('id').' IN (' . implode( ',' , $filterIds ) . ')';
		}

		$query	.= ' ORDER BY field.'.$db->quoteName('ordering');

		$db->setQuery( $query );

		try {
			$result = $db->loadAssocList();
		} catch (Exception $e) {
			Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
		}

		//trigger field load to allow 3rd party developer to manupulate the fields
		$app = CAppPlugins::getInstance();
		$app->loadApplications();

		$args 	= array();

        $args[]	= $userId;
        $args[]	= $result;
        $args[]	= __FUNCTION__;

		$result = $app->triggerEvent( 'onProfileFieldLoad' , $args);

		//let's check the viewer's relation to the profile he/she's about to see
		$visitor = CFactory::getUser();
		$access_limit = PRIVACY_PUBLIC;

    	$isfriend = $visitor->isFriendWith($user->id);

		//let's set the maximum access limit viewer can go
		if($visitor->id > 0){
			$access_limit = PRIVACY_MEMBERS;
		}

		if($isfriend){
			$access_limit = PRIVACY_FRIENDS;
		}

		if(($visitor->id == $user->id && $visitor->id != 0) || COwnerHelper::isCommunityAdmin()){
			$access_limit = PRIVACY_PRIVATE;
		}
		//=====================================

		$data['fields']	= array();

		for($i = 0; $i < count($result); $i++){

			// We know that the groups will definitely be correct in ordering.
			if($result[$i]['type'] == 'group') {
				$group	= $result[$i]['name'];
				$this->_getResultData($data, $result, $i, $group);
			}

			// Re-arrange options to be an array by splitting them into an array
			$this->_getArrangedOptions($result, $i);

			// Only append non group type into the returning data as we don't
			// allow users to edit or change the group stuffs.
			if($result[$i]['type'] != 'group'){
				if($result[$i]['access'] <= $access_limit){ //check privacy access here
					if(!isset($group)) {
                        $data['fields']['ungrouped'][] = $result[$i];
                    } else {
                        $data['fields'][$group][] = $result[$i];
                    }

                    $data['fieldsById'][$result[$i]['id']] = $result[$i];
                }
			}

		}
		//$this->_dump($data);
		return $data;
	}

	/**
	 * Returns an array of custom profiles which are created from the back end.
	 *
	 * @access	public
	 * @param	string 	User's id.
	 * @returns array  An objects of custom fields.
	 */
	public function getEditableProfile($userId	= null , $profileType = COMMUNITY_DEFAULT_PROFILE )
	{
		$db			= $this->getDBO();
		$data		= array();

		$user		= CFactory::getUser($userId);

		$data['id']		= $user->id;
		$data['name']	= $user->name;
		$data['email']	= $user->email;

		// Attach custom fields into the user object
		$query	= 'SELECT field.*, value.'.$db->quoteName('value').' , value.'.$db->quoteName('access')
				.', value.'.$db->quoteName('params').' as fieldparams '
				. 'FROM ' . $db->quoteName('#__community_fields') . ' AS field '
				. 'LEFT JOIN ' . $db->quoteName('#__community_fields_values') . ' AS value '
 				. 'ON field.'.$db->quoteName('id').'=value.'.$db->quoteName('field_id').' AND value.'.$db->quoteName('user_id').'=' . $db->Quote($userId);

 		// Build proper query for multiple profile types.
		if( $profileType != COMMUNITY_DEFAULT_PROFILE )
		{
			$query2	= 'SELECT '.$db->quoteName('field_id').' FROM ' . $db->quoteName( '#__community_profiles_fields' ) . ' '
					. 'WHERE ' . $db->quoteName( 'parent' ) . '=' . $db->Quote( $profileType );
			$db->setQuery( $query2 );
			$filterIds	= $db->loadColumn();

			if( empty( $filterIds ) )
			{
				$data['fields']	= array();
				return $data;
			}

			$query	.= ' WHERE field.'.$db->quoteName('id').' IN (' . implode( ',' , $filterIds ) . ')';
			$query	.= ' AND field.'.$db->quoteName('published').'=' . $db->Quote( '1' );
		}
		else
		{
			$query	.= ' WHERE field.'.$db->quoteName('published').'=' . $db->Quote('1');
		}

		if(!COwnerHelper::isCommunityAdmin())
			$query 	.= ' AND '.$db->quoteName('visible') . ' < ' .$db->Quote('2');

		$query	.= ' ORDER BY field.'.$db->quoteName('ordering');

		$db->setQuery( $query );

		try {
			$result = $db->loadAssocList();
		} catch (Exception $e) {
			Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
		}

		//trigger field load to allow 3rd party developer to manupulate the fields
		$app = CAppPlugins::getInstance();
		$app->loadApplications();

		$args 	= array();

        $args[]	= $userId;
        $args[]	= $result;
        $args[]	= __FUNCTION__;

		$result = $app->triggerEvent( 'onProfileFieldLoad' , $args);

		$data['fields']	= array();
		for($i = 0; $i < count($result); $i++)
		{

			if($result[$i]['type'] == 'group'){
			    $group	= $result[$i]['name'];
			    $this->_getResultData($data, $result, $i, $group);
			}

			// Re-arrange options to be an array by splitting them into an array
			$this->_getArrangedOptions($result, $i);

			// Only append non group type into the returning data as we don't
			// allow users to edit or change the group stuffs.
			if($result[$i]['type'] != 'group'){
				if(!isset($group))
					$data['fields']['ungrouped'][]	= $result[$i];
				else
					$data['fields'][$group][]	= $result[$i];
			}
		}
		return $data;
	}

	/**
	 * Returns an array of custom profiles which are created from the back end.
	 *
	 * @access	public
	 * @param	string 	User's id.
	 */
	public function _dump(& $data){
		echo '<pre>';
		print_r($data);
		echo '</pre>';
		exit;
	}

	public function saveProfile($userId, $fields)
	{
		jimport('joomla.utilities.date');
		$db		= $this->getDBO();

		foreach($fields as $id => $value)
		{
			$table	= Table::getInstance( 'FieldValue' , 'CTable' );

			if( !$table->load( $userId , $id ) )
			{
				$table->user_id		= $userId;
				$table->field_id	= $id;
			}

			if( is_object( $value ) )
			{
				$table->value	= $value->value;
				$table->access	= $value->access;
				$table->params = isset($value->params) ? $value->params : '';
			}

			if( is_string( $value ) )
			{
				$table->value	= $value;
			}

			$table->params = isset($table->params) ? $table->params : '';

			// delete profile fields value if the profile fields not exist at selected profile type
			if ($table->store()) {
				$table->remapFieldValue($userId, $fields);
			}
		}
	}

	/**
	 * Update user location with user's address information
	 * @param type $userid
	 */
	public function updateLocationData($userid)
	{
		$usermodel	= CFactory::getModel('user');
		$user		= CFactory::getUser($userid);

		// Get location field data, if not exist build the address string
		$address = CMapsHelper::getAddress($userid);
		
		$fromLocationField = false;
		if (isset($address->location)) {
			$location = json_decode($address->location);
			if (json_last_error() === 0) {
			    if (isset($location->lat) && isset($location->lng)) {
			    	$fromLocationField = true;
			    	$latitude = $location->lat;
			    	$longitude = $location->lng;
			    }
			}
		}

		if (!$fromLocationField) {
			// Store the location
			$data = CMapping::getAddressData($address);

			// reset it to null;
			$latitude 	= COMMUNITY_LOCATION_NULL;
			$longitude	= COMMUNITY_LOCATION_NULL;

			if ($data) {
				if (CFactory::getConfig()->get('maps_api', '') == 'googlemap') {
					if ($data->status == 'OK') {
						$latitude  = $data->results[0]->geometry->location->lat;
						$longitude = $data->results[0]->geometry->location->lng;
					}
				} else {
					if (isset($data[0]->lat) && $data[0]->lon) {
						$latitude  = $data[0]->lat;
						$longitude = $data[0]->lon;
					}
				}
			}
		}
		
		$usermodel->storeLocation($user->id, $latitude, $longitude);

		return $this;
	}


	public function setProfile($v)
	{
		$this->_profile = $v;
		return $this;
	}

	/**
	 * Method to test if a specific field for a user exists
	 *
	 * @param	String	$fieldCode	Field Code
	 * @param	String	$userId		Userid
	 *
	 *	return boolean	True if exists and false otherwise.
	 **/
	public function _fieldValueExists( $fieldCode , $userId )
	{
		$db		= Factory::getDBO();

		$query	= 'SELECT COUNT(1) FROM ' . $db->quoteName( '#__community_fields' ) . ' AS a '
				. ' INNER JOIN ' . $db->quoteName( '#__community_fields_values' ) . ' AS b '
				. ' ON a.'.$db->quoteName('id').'=b.'.$db->quoteName('field_id')
				. ' WHERE a.'.$db->quoteName('fieldcode').'=' . $db->Quote( $fieldCode )
				. ' AND b.'.$db->quoteName('user_id').'=' . $db->Quote( $userId );

		$db->setQuery( $query );

		$result	= ( $db->loadResult() >= 1 ) ? true : false;

		return $result;
	}

	/**
	 * Method to retrieve a field's id with a given field code
	 *
	 * @param	String	$fieldCode	Field code for the specific field.
	 **/
	public function getFieldId( $fieldCode )
	{
		$db		= Factory::getDBO();
		$query	= 'SELECT ' . $db->quoteName( 'id' ) . ' FROM '
				. $db->quoteName( '#__community_fields' ) . ' '
				. 'WHERE ' . $db->quoteName( 'fieldcode' ) . '=' . $db->Quote( $fieldCode );

		$db->setQuery( $query );

		$result	= $db->loadResult();

		return $result;
	}

	/**
	 * Method to retrieve a field's id with a given field code
	 *
	 * @param	String	$fieldCode	Field code for the specific field.
	 **/
	public function getFieldCode( $fieldId )
	{
		$db		= Factory::getDBO();
		$query	= 'SELECT ' . $db->quoteName( 'fieldcode' ) . ' FROM '
				. $db->quoteName( '#__community_fields' ) . ' '
				. 'WHERE ' . $db->quoteName( 'id' ) . '=' . $db->Quote( $fieldId );

		$db->setQuery( $query );

		$result	= $db->loadResult();

		return $result;
	}

	/**
	 * Method to retrieve a field's params with a given field code
	 *
	 * @param	String	$fieldCode	Field code for the specific field.
	 **/
	public function getFieldParams( $fieldId )
	{
		$db		= Factory::getDBO();
		$query	= 'SELECT ' . $db->quoteName( 'params' ) . ' FROM '
				. $db->quoteName( '#__community_fields' ) . ' '
				. 'WHERE ' . $db->quoteName( 'id' ) . '=' . $db->Quote( $fieldId );

		$db->setQuery( $query );
		$result	= $db->loadResult();

		return $result;
	}

	public function getField($fieldId){
        $db		= Factory::getDBO();
        $query	= 'SELECT * FROM '
            . $db->quoteName( '#__community_fields' ) . ' '
            . 'WHERE ' . $db->quoteName( 'id' ) . '=' . $db->Quote( $fieldId );

        $db->setQuery( $query );
        $result	= $db->loadObject();

        return $result;
    }

	public function updateUserData( $fieldCode , $userId , $value )
	{
		$db		= Factory::getDBO();

		$data	= new stdClass();

		$fieldId	= $this->getFieldId( $fieldCode );

		if( $this->_fieldValueExists( $fieldCode , $userId ) )
		{
			// For existing record we just update it.
			$query	= 'UPDATE ' . $db->quoteName( '#__community_fields_values' ) . ' '
					. 'SET ' . $db->quoteName( 'value' ) . '=' . $db->Quote( $value ) . ' '
					. 'WHERE ' . $db->quoteName( 'field_id' ) . '=' . $db->Quote( $fieldId ) . ' '
					. 'AND ' . $db->quoteName( 'user_id' ) . '=' . $db->Quote( $userId );

			$db->setQuery( $query );
			$db->execute();
			return;
		}
		else
		{
			// For new records, we need to add it.
			$data			= new stdClass();
			$data->field_id	= $fieldId;
			$data->user_id	= $userId;
			$data->value	= $value;
			$data->params	= '';

			return $db->insertObject( '#__community_fields_values' ,  $data );
		}
	}
	/**
	 * [formatDate description]
	 * @param  [type] $value  [description]
	 * @param  string $format [description]
	 * @return [type]         [description]
	 * @deprecated in joomla 3.0
	 */
	public function formatDate($value, $format='')
	{
		$config	= CFactory::getConfig();

		if(empty($format)){
			$format	= $config->get( 'profileDateFormat' );
		}

		$date = new JDate($value);
		$result = $date->format($format);

		return $result;
	}

	public function getAdminEmails()
	{
		$emails		= '';
		$db			= $this->getDBO();

		$query		= 'SELECT a.' . $db->quoteName('email')
						. ' FROM ' . $db->quoteName('#__users') . ' as a, '
						. $db->quoteName('#__user_usergroup_map') . ' as b'
						. ' WHERE a.' . $db->quoteName('id') . '= b.' . $db->quoteName('user_id')
						. ' AND ( b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 7 )
						. ' OR b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 8 ) .')';

		$db->setQuery($query);
		$emails		= $db->loadColumn();

		return $emails;
	}

	/**
	 * Retrieves profile types available throughout the site.
	 *
	 * @returns	Array	An array of objects.
	 **/
	public function getProfileTypes()
	{
		$db		= $this->getDBO();
		$query	= 'SELECT * FROM ' . $db->quoteName( '#__community_profiles' ) . ' '
				. 'WHERE ' . $db->quoteName( 'published' ) . '=' . $db->Quote( 1 ) . ' '
				. 'ORDER BY ' . $db->quoteName( 'ordering' );
		$db->setQuery( $query );
		return $db->loadObjectList();
	}

	public function reset()
	{
		$this->_allField	= null;
	}

    private function _getResultData(&$data, &$result, &$i, &$group)
    {

			if(!isset($data['fields'][$group])){
				// Initialize the groups.
				$data['fields'][$group]	= array();
			}

    }

    private function _getArrangedOptions(&$result, &$i)
    {

        if(isset($result[$i]['options']) && $result[$i]['options'] != '')
        {
            $options	= $result[$i]['options'];
            $options	= explode("\n", $options);

			foreach($options as $key=>$option){
				$options[$key] = str_replace(array("\n", "\r"), '', trim($option));
			}

            $result[$i]['options']	= $options;
        }

    }

    public function getAllList()
    {
        $db		= $this->getDBO();
		$query	= 'SELECT ' . $db->quoteName('id') . ',' . $db->quoteName('options') .' FROM ' . $db->quoteName( '#__community_fields' ) . ' '
			. 'WHERE ' . $db->quoteName( 'type' ) . '=' . $db->Quote( 'select' ) . ' '
            . 'OR' . $db->quoteName( 'type' ) . '=' . $db->Quote( 'country' );

        $db->setQuery( $query );
		$data = $db->loadAssocList();

        for($i = 0; $i < count($data); $i++)
        {
            $this->_getArrangedOptions($data, $i);
        }

        return $data;
    }

    public function getGender( $userId )
    {

		$fieldId = $this->_getgenderId();

		$db		= Factory::getDBO();
		$query = 'SELECT '.$db->quoteName('value') . ' FROM '
				.$db->quoteName('#__community_fields_values'). ' '
				.'WHERE '. $db->quoteName( 'field_id' ) . ' = '. $db->Quote( $fieldId ) . ' '
				. 'AND '. $db->quoteName( 'user_id' ) . ' = '. $db->Quote( $userId);

		$db->setQuery( $query );
		$result = $db->loadResult();
		return $result ?: '';
    }

    private function _getgenderId(){

    	if(!is_null($this->_genderId)){
    		return $this->_genderId;
    	}

    	$db		= Factory::getDBO();
		$query	= 'SELECT ' . $db->quoteName( 'id' ) . ' FROM '
				. $db->quoteName( '#__community_fields' ) . ' '
				. 'WHERE ' . $db->quoteName( 'fieldcode' ) . '=' . $db->Quote( 'FIELD_GENDER' );

		$db->setQuery( $query );

		$this->_genderId = $db->loadResult();

		return $this->_genderId;
    }
}