[SOLVED] Add Delivery Address and Delivery Receiver Name to Admin Order List

[Jagotic]

Hello Experts,

I really need to see Delivery details in admin order list. New Filter like Deliver receiver name, receiver address, and receiver's phone number. Is their any way to do that?

 

Help will be appreciated

Thanks

Edited March 6, 2019 by Jagotic
Solved! (see edit history)

[NemoPS]

Try to add this to the column named 'cname" (that is the country name) in AdminOrdersController.php
'callback'    => 'getDeliveryAddress',

Then create a function like this

 

public function getDeliveryAddress($a, $order)
    {
        $address = new Address($order['id_address_delivery']);
        return AddressFormat::generateAddress($address, [], '<br />', ' ');

    }

You also need to get that id_address_delivery from the main query, same file.

I will make a video tutorial for it next week.

[Jagotic]

Thanks Fabio, Please make that tutorial ASAP. i'm waiting for that.

[Jagotic]

I have solved this with added following codes in AdminOrdersController.php

Added 

CONCAT(ad.`firstname`, \' \', ad.`lastname`) AS `shipping_customer_full_name`,
ad.phone_mobile as shipping_phone_mobile,

this 2 line after line 65

And added

LEFT JOIN `'._DB_PREFIX_.'address` as ad ON id_address_delivery= ad.id_address

after line 76

 

NOW i can see Delivery person name & phone number on order list

SOLVED!

[__fito__]

On 2/20/2019 at 2:44 PM, NemoPS said:

Try to add this to the column named 'cname" (that is the country name) in AdminOrdersController.php
'callback'    => 'getDeliveryAddress',

Then create a function like this

 

public function getDeliveryAddress($a, $order)
    {
        $address = new Address($order['id_address_delivery']);
        return AddressFormat::generateAddress($address, [], '<br />', ' ');

    }

You also need to get that id_address_delivery from the main query, same file.

I will make a video tutorial for it next week.

Hi NemoPS!

Did you made the video tutorial? I need to see delivery address in Order´s list (address, zip code, city and contact phone) but I don´t know how to user your code in AdminOrdersController.php

It would be great if you can detail how to insert your code or the tutorial 😃

Thank you for your help!