View the selected carrier in BackOffice order tab

[levviking]

Hi, i want to view the carriers in BackOffice -> Orders Tab, without opening the order details.

How to add them?

 

In Administration -> Menus -> Orders.

But what to write in this field?

[vekia]

 

You will need to override the AdminOrdersController class in order to do this. Try creating a new file, "/override/controllers/admin/AdminOrdersController.php" and paste the following code into it:

 

<?php

class AdminOrdersController extends AdminOrdersControllerCore

{

public function __construct()

{

parent::__construct();

 

$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'carrier` crr ON (crr.`id_carrier` = a.`id_carrier`)';

$this->_select = 'crr.`name` AS `carrier_name`,'.$this->_select;

 

$this->fields_list['carrier_name'] = array(

'title' => $this->l('Carrier '),

'width' => 100,

'havingFilter' => true,

);

}

}

Reorder the "fields_list" array to position the carrier name in the table.

You might have to delete the class index (/cache/class_index.php) to get the override running.

[vekia]

another modification: http://www.prestashop.com/forums/topic/293176-filter-orders-by-carrier/

[cat1999]

 

 

You will need to override the AdminOrdersController class in order to do this. Try creating a new file, "/override/controllers/admin/AdminOrdersController.php" and paste the following code into it:

 

<?php

class AdminOrdersController extends AdminOrdersControllerCore

{

public function __construct()

{

parent::__construct();

 

$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'carrier` crr ON (crr.`id_carrier` = a.`id_carrier`)';

$this->_select = 'crr.`name` AS `carrier_name`,'.$this->_select;

 

$this->fields_list['carrier_name'] = array(

'title' => $this->l('Carrier '),

'width' => 100,

'havingFilter' => true,

);

}

}

Reorder the "fields_list" array to position the carrier name in the table.

You might have to delete the class index (/cache/class_index.php) to get the override running.

 

Worked like a charm for me! PS 1.6.0.5

[nikmagnus]

Thanks so much for this.

 

I incorporated this into my override. It works well.

 

Many thanks again!

Nik

[ragnabt]

Hi 

 

I works great, but I dont understand how I can reorder the list, I would like to "remove" new client column and just put the carrier column in there instead. 

Edited October 21, 2015 by ragnabt (see edit history)

[sondiva]

vekia, on 12 Mar 2014 - 3:55 PM, said:

 

Quote
 
You will need to override the AdminOrdersController class in order to do this. Try creating a new file, "/override/controllers/admin/AdminOrdersController.php" and paste the following code into it:

 <?php
class AdminOrdersController extends AdminOrdersControllerCore
{
public function __construct()
{
parent::__construct();

$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'carrier` crr ON (crr.`id_carrier` = a.`id_carrier`)';
$this->_select = 'crr.`name` AS `carrier_name`,'.$this->_select;

$this->fields_list['carrier_name'] = array(
'title' => $this->l('Carrier '),
'width' => 100,
'havingFilter' => true,
);
}
}
Reorder the "fields_list" array to position the carrier name in the table.
You might have to delete the class index (/cache/class_index.php) to get the override running.

 

 

Hi Vekia,
 
I need to put carrier selection while generating all the pdf file invoices from/to date in back office so that we can only print the particular invoices as per carrier selection..any advice on that...

[Zumo]

It works perfect in 1.6.1.0 version.

 

Thanks!

[julianbaros]

Hello,

I need help for my BO.

I correctly add a new column with the tracking number (cf ModifBO Commande.png).

Now I would like to recover the link of the tracking number in the order (cf CommandeNumSuivi) to put it directly in my column.

Like that I don't need to go inside each order to see the link of the tracking number.

Please help.

[julianbaros]

Anyone can help me please ?

[NBlack]

It works like a charm @Vekia

[rachel01]

Hi,

I've tried but I've this error :

Column 'id_carrier' in field list is ambiguous

 

Can you help me ?

 

Thanks