How to show order history in frontend?

now i'm only can show list of orders and here user can see last updated order status. But what if i want to show for user all his order history:
When order status changed, what was the name of order status and even what was the Modification reason for that.

Hi arnask,


You can display these different informations, you have to edit:
yourSite\components\com_hikashop\views\order\view.html.php > function listing().

Add:

foreach($rows as $k => $hist){
			$database->setQuery('SELECT * FROM '.hikashop_table('history').' WHERE history_id IN(SELECT max(history_id) FROM '.hikashop_table('history').' WHERE `history_order_id` = '.$rows[$k]->order_id.' AND history_type = "modification" )');
			$rows[$k]->history = $database->loadObjectList();
		}

$this->assignRef('rows',$rows);

<?php
echo '<br/>'.hikashop_getDate($row->order_modified,'%Y-%m-%d %H:%M').' / ';
echo $row->history[0]->history_new_status.' / ';
echo $row->history[0]->history_reason; ?>

Parse error: syntax error, unexpected T_VARIABLE in .../components/com_hikashop/views/order/tmpl/listing.php on line 123

where exactly is "In the listing table, between <tr><td> tags for each elements" can you provide line numbers?

no good:

yes i've done that. Now it loks like:

$this->assignRef('params',$params);
		foreach($rows as $k => $hist){
			$database->setQuery('SELECT * FROM '.hikashop_table('history').' WHERE history_id IN(SELECT max(history_id) FROM '.hikashop_table('history').' WHERE `history_order_id` = '.$rows[$k]->order_id.' AND history_type = "modification" )');
			$rows[$k]->history = $database->loadObjectList();
		}
		$this->assignRef('rows',$rows);

yes, but i still can not see all the history of order. Only the last change.
What if there was 5 order changes with different reasons in different time. I can not see that.

still the last one. No history.

now it ok, onnly we need to handle dates, because everything is in the same last modification date.
And of course we need to handle languages of order statuses to disply correctly with Falang.

But already thank you nicolas!

Hi arnask,

For the dates, you can use :

$hist->history_created;

still it shows the last modification date for all modifications.
Date is in some numbers format.
Order statuses are not in correct language.

now code in listing.php looks:

<?php
foreach($row->history as $hist){
echo '<br/>'.hikashop_getDate($row->order_modified,'%Y-%m-%d %H:%M').' / ';
echo $hist->history_new_status.' / ';
echo $hist->history_reason;
echo $hist->history_created;  
} 
?>

Thanks, it works now. But there is still language issue. How to make "history_new_status" display correct language?

after updating hikashop, everything has gone, and now i need to do it all again. Is there a chance that it will be implemented in future hikashop?
I think this feature is very useful, and VM is a big competitor in this field.
Is there a possibility to attache file in frontend near all users orders? I need to give a special reports for my customers about theirs orders.
For example when i'm changing order status, i'm putting a modification reason and need to attache a file to it. So that this file could be in email and in frontend "My orders" section.