Add a new column to the list of commands in the backoffice

[Rihab002]

Hello,

 

I want to add two columns in the list of commands in the backoffice (Delivery city and type of delivery).

 

I did the overload AdminOrdersController.php class:

 

I created the file in the AdminOrdersController.php prestashop / override / controllers / admin / with the following content:

 

?php

class AdminOrdersController extends AdminOrdersControllerCore {

public function __construct() {

parent::__construct(); $this->_select .= ', carrier.`name` as scarrier,

CONCAT(address.`postcode`, \' \', address.`city`) as sville';

$this->fields_list['scarrier'] = array( 'title' => $this->l('Type delivery') );

$this->fields_list['sville'] = array( 'title' => $this->l('delivery address') ); }

 

An error message appears when using the search bar / new column filter (Type delivery or delivery address) "Poor SQL Unknown column 'sville' in 'where clause' '

 

  and then I have no access to the backoffice.

 

 

Do you have an idea to solve this problem?

 

Edited June 7, 2016 by Rihab002 (see edit history)