static function get_field_value_hikashop($field, $user_id) { $db = JFactory::getDBO(); $query = "SELECT user_id " . ' FROM #__hikashop_user' . " WHERE user_cms_id = " . $db->Quote($user_id); $db->setQuery($query); $hikashop_user_id = $db->loadResult(); $query = "SELECT {$field} " . ' FROM #__hikashop_address' . " WHERE address_user_id = " . $db->Quote($hikashop_user_id); $db->setQuery($query); $value = $db->loadResult(); /* Check if data needs transformation */ switch ($field) { case 'address_country': $value = JoomdleHelperMappings::get_moodle_country_from_hikashop($value); break; default: break; } return $value; }