public static function getStoreAddress()
{
if (!isset(self::$store)) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('s.*, c.country_name, c.country_isocode_2, c.country_isocode_3, z.zone_name, z.zone_code');
$query->from('#__j2store_storeprofiles AS s');
$query->where('s.state=1');
$query->order('s.store_id ASC LIMIT 1');
$query->leftJoin('#__j2store_countries AS c ON s.country_id = c.country_id');
$query->leftJoin('#__j2store_zones AS z ON s.zone_id = z.zone_id');
$db->setQuery($query);
self::$store = $db->loadObject();
}
return self::$store;
}
