Display total value of the orders for a client

-- url of the page with the problem -- : www.vitaking.ro
-- HikaShop version -- : 2.2.3
-- Joomla version -- : 3.2
-- PHP version -- : 5.3.10
-- Browser(s) name and version -- : Chromium 31
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hi,

We would like to display in the user orders history page the total value of all the orders, belonging to the current account. The problem is that if we are using the listing.php loop it gets displayed only the total value for the current pagination. Can you please give us some hint about how we can achieve this?

Regards,
Dezso Markon,
vitaking.ro

You don't have the choice : you have to make a sql query to load all the prices.
Insert this code in the listing.php file :

$db = JFactory::getDBO();
$user_id = hikashop_loadUser();
$query = 'SELECT SUM(order_full_price) FROM  `#__hikashop_order` WHERE order_user_id = '.$user_id.';';
$db->setQuery($query);
$total= $db->loadObjectList();

Thank you!

Printing $total[0] renders the page inoperable.
My array looks like this: Array ( [0] => stdClass Object ( [SUM(order_full_price)] => 13874.35000 ))
So $total[0] it's not an integer or a value. I guess you know the solution for this

Thanks.

Thank you Nicolas, it's perfect!