As the name of complete client requests appear in the screen

[franzneves]

In the order screen appears the first name abbreviated as this client: J. Luiz da Silva. 

 

Does anyone know the name of the client full well appear: José Luiz da Silva? 

 

grateful

Edited July 5, 2014 by franzneves (see edit history)

[PSfever.com]

By order screen - do you mean the backoffice? Or frontoffice - the order process?

[franzneves]

Backoffice - Thanks.

[vekia]

you have to modify contorller: /controllers/admin/AdminOrdersController.php

CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`,

instead of LEFT(c.`firstname`, 1)

use just c.`firstname`

[franzneves]

Thanks but not work. 

 

message errror:

 

Query in SQL wrong
Column 'firstname' in field list is ambiguous

[vekia]

strange

can you show please how your modified code looks like?

[franzneves]

CONCAT(LEFT(`firstname`, 1), \'. \', c.`lastname`) AS `customer`,

[vekia]

it's not a code that i suggested to use ;-)

 

 

use just c.`firstname`

[franzneves]

I delete this entire line: 

 

                              CONCAT (LEFT (c. `firstname`, 1), \ '. \', C. `Lastname`) AS `customer`, 

 

and substituted by 

 

                               c. `firstname` 

 

is this? 

 

Thank you

[Mister Denial]

Hi Vekia,

 

even with the code looking like this

CONCAT(LEFT(c.`firstname`), \'. \', c.`lastname`) AS `customer`,

It creates a bad sql error on the orders page in 1.6.0.8:

 

"Bad SQL query
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), '. ', c.`lastname`) AS `customer`, osl.`name` AS `osname`, os.`color`, ' at line 6"

Edited August 1, 2014 by Mister Denial (see edit history)

[franzneves]

Look: http://www.prestashop.com/forums/topic/342145-resolvido-como-aparecer-o-nome-do-cliente-completo-na-tela-de-pedidos/?do=findComment&comment=1725127

[Mister Denial]

Thanks franzneves, didn't think about searching the spanish forum. Worked perfect!

[franzneves]

Ok. Portuguese forum.

[Mister Denial]

Sorry, can't speak either, but I should have known, as someone from Brazil was posting there. Didn't catch the clue.

[franzneves]

The important thing is that we solve our problem.  

Edited August 1, 2014 by franzneves (see edit history)

[vekia]

code is equal to code that i suggested to use

[Mister Denial]

@ Vekia: true, but I was confused, I thoguht the LEFT had to stay in there an only remove the ,1 for the line. ;-)

 

@ franzneves: you're right! :-)

Edited August 2, 2014 by Mister Denial (see edit history)