Modify Orders Page

Hi,
can I modify the List Orders page linked in the Cpanel user?
I would like to add 2 columns: Product name and quantity products...it is possible??
Thanks
Guy

Hi,

I think that you'll be able to do that by changing the code of your "listing" file of your "order" view through "Hikashop->Display->Views".

Hi,
Thanks for tour reply!
I understood how to add any columns.....but do you have any suggestions to how insert a sql query to collect data from other tables? because I'm able to get data only from order table.
Thanks!!!
Guy

You can run queries like that:
<?php
$db = JFactory::getDBO();
$db->setQuery('YOUR QUERY');
$data = $db->loadObjectList();
?>

Perfect!
Thanks!!!
Guy

Hi,
I need last suggestion, if is possible:
I have insert a sql Query into the order_listing like this:

$db->setQuery('SELECT order_product_name FROM hikashop_order_product join hikashop_order on hikashop_order_product.order_id=hikashop_order.order_id and hikashop_order.order_id=????????');

but I can not correct link the table order with table order_product in a way that corresponds to each order the exact product name.
If it is not too complicated…my PHP Skills are not very good!
Thanks!!!
Guy

you can find the order_id in the variable:
$row->order_id

Thanks!!
it's OK
Bye
Guy

Hi,
sorry, but I'd like to filter orders in this page so that they are displayed only in status = "completed".
I always have to edit the file "listing" in view "Order"?
Thanks!!
Bye
Guy

Yes.
You can just add the line:
if($row->order_status!='confirmed') continue;
after the line:
$row =& $this->rows[$i];
in that order/listing view file.

spectacular!!
you were very fast and very good!
It's all OK!
Many many Thanks
Grazie!!
Guy