Add a column to Sales View in Backend

I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up all the time, and they usually don't have their invoice number.

I tried editing the sales view file in the views menu

Even when I fully deleted that file, the sales view was unchanged. How can I add a column to the sales view in the backend?

Thanks!
Jesse
RageHats.com

Hi RageHats,

You can d oit by editing the view order / listing.php in HikaShop > Display > Views.

Then add:

$address_id = $row->order_shipping_address_id;
$fieldClass = hikashop_get('class.field');
$addressClass = hikashop_get('class.address');
$order->fields = $fieldClass->getData('backend','address');
if(!empty($address_id)){
	$order->name=$addressClass->get($address_id);
}

$target = '';
if($this->popup)
	$target = '" target="_top';
$k = 0;
for($i = 0,$a = count($this->rows);$i<$a;$i++){
	$row =& $this->rows[$i];

<?php echo $order->name->address_lastname; ?>

how I can replace the column "method of payment" for "product code" and that at the top:


echo $ this-> payment-> display ("filter_payment", $ this-> PageInfo-> filter-> filter_payment, false);


To output the filter by "Product Code" instead of "payment method".

thanks

Hi dvddvd,

Can you explain in more details what you need ?

A sale have many products, so we can't add a filter on the product code in the listing of the sales.

Sorry, in my case only allows one product per order

Ok so in your case, you can edit the file: "yourSite/administrator/components/com_hikashop/views/order/show.html.php

And add the line:

$tables = ' INNER JOIN '.hikashop_table('order_product').' AS d ON b.order_id = d.order_id';

$query = ' FROM '.hikashop_table('order').' AS b LEFT JOIN '.hikashop_table('user').' AS a ON b.order_user_id=a.user_id LEFT JOIN '.hikashop_table('users',false).' AS c ON a.user_cms_id=c.id '.$tables.$filters.$order;

						<?php if(!empty($row->order_payment_method)){
							if(!empty($this->payments[$row->order_payment_method])){
								echo $this->payments[$row->order_payment_method]->payment_name;
							}else{
								echo $row->order_payment_method;
							}
						} ?>

<?php echo $row->order_product_code; ?>

Hello Xavier thank you very much for your help

I made ​​the following changes

1) add the following code:

$tables = ' INNER JOIN '.hikashop_table('order_product').' AS d ON b.order_id = d.order_id';

$query = ' FROM '.hikashop_table('order').' AS b LEFT JOIN '.hikashop_table('user').' AS a ON b.order_user_id=a.user_id LEFT JOIN '.hikashop_table('users',false).' AS c ON a.user_cms_id=c.id '.$tables.$filters.$order;

code removed by the administrator.
Please do not paste entire files here

code removed by the administrator.
Please do not paste entire files here

Sorry for paste entire files.

Oh I forgot one thing, , you need to add ",d.*" like this:

$database->setQuery('SELECT a.*,b.*,c.*,d.*'.$query,(int)$pageInfo->limit->start,(int)$pageInfo->limit->value);

$searchMap = array('c.id','c.username','c.name','a.user_email','b.order_user_id','b.order_number','b.order_id','b.order_full_price','d.order_product_code');

thank you very much now all right !!!!

Hello again,

I'm trying to replace the 'id column' by 'telephone', following the steps you've RageHats indicated earlier in this post, but I just get the blank column.

thnaks

Hi dvddvd,

You need to display "echo $order->name->address_telephone;" instead of "echo $order->name->address_lastname" like I said to RageHats.

ok operates correctly. Thank you very much

Hello Xavier,
We use HikaShop for university courses. We deleted all the orders last year and since then, the field added to order / listing is blank.
I was using "echo $ order-> name-> address_telephone;?".
What is the new command I use to take that data table address and field address_telephone ?

Thanks Xavier. I see that to enlist new orders from the administration and assign a customer, goes blank the form to the right which is where the data takes. Because if I put the phone there, if it appears

I only needed to change $ address_id = $ row-> order_shipping_address_id, for $ address_id = $ row-> order_billing_address_id, in <? php
         $ target ='';
         if ($ this-> popup)
           $ target = "" target = "_top";
         $ k = 0;
         for ($ i = 0, $ a = count ($ this-> rows); $ i <$ a, $ i + +) {
           $ row = & $ this-> rows [$ i];
        $ address_id = $ row-> order_billing_address_id;
        $ fieldClass = hikashop_get ('class.field');
        $ AddressClass = hikashop_get ('class.address');
        $ order-> fields = $ fieldClass-> getData ('backend', 'address');
        if (! empty ($ address_id)) {
        $ order-> name = $ AddressClass-> get ($ address_id);
        }
       ?>

Thank very much Xavier

Hi Xavier,
I just upgrade to HikaShop bussiness. This modification we do not work anymore.
In the country where the product code was to appear, is now blank.
It could appear again in the updated version of the product code in this field.
Thank You