public static function getUserData($userId = 0)
{
$db = Factory::getDBO();
if ((int) $userId == 0) {
$user = PhocacartUser::getUser();
$userId = (int) $user->id;
}
if ((int) $userId > 0) {
$query = 'SELECT u.*, r.title as regiontitle, c.title as countrytitle FROM #__phocacart_users AS u' . ' LEFT JOIN #__phocacart_countries AS c ON c.id = u.country' . ' LEFT JOIN #__phocacart_regions AS r ON r.id = u.region' . ' WHERE u.user_id = ' . (int) $userId . ' ORDER BY u.type ASC';
$db->setQuery($query);
$data = $db->loadObjectList();
return $data;
}
return false;
}