Get user address outside hikashop

Hi,

I am trying to get user address inside easy profile view.
What I want is to show user shipping address street, city, zip and use them to show location on google map....

I have read this topic www.hikashop.com/support/forum/developme...ikashop-address.html and used code below Provided by Nicolas 3 years ago:

// Get a db connection.
$db = JFactory::getDbO();
$db->setQuery('SELECT user_id FROM #__hikashop_user WHERE user_cms_id = ' . (int) $userId);
$hikashop_id = $db->loadResult();

$db->setQuery('SELECT * FROM #__hikashop_address WHERE address_user_id =' . (int) $hikashop_id);
$address = $db->loadObject();

//then you can do like that to get the address_street  for example:
echo $address->address_street;

Please ignore. Found the issue.

Have a great day

Hi,

It looks like I still need some little help here.

I have customizes profile view and it shows location on google map based on entered address in hikashop address listing...However issue is that if you have 2 or more addresses using "echo $address->address_street;" will give first entered/created address and NOT selected in address listing.

So question. Is it possible to get default selected address using those queries? Else easiest way will be to limit user to have only one address.

Many thanks

Hi,

Thank you Jerome. It really helped.

Gave a great day

Hi,
I am using Google Matrix API to calculate distance between users address and the pre-difined store addresses, include js code inside checkout.php.

I want to appoligize about my english and php skill, im new at both of them.
My idea is to make a popup or similar when the user is about to order, that inform him about a store near his address location, otherwise he will pay the shipping ports.
As you can see on the code i'll send, on the line 714, there are a variable that should get the user address, so that google api could calculate the distance between the locations and return the shortest one.

Thank you!

Hi Jerome,

Thank you for the warning about core files, such checkout.php. When you said that i should override the view(s), you mean files like address_view.php on this path ./components/com_hikashop/views/checkout/tmpl ? ill send you the example.

Sorry again, php is not my strongest. I really need help to finish this.
Thank you for all the support.

Hi Gerome,
Thank you so much, you are a life saver. Following your wisdom, i managed to get the correct user address.