[Solved] CustomerController Override Help

[belyza]

Hi. I was able to modify the customercontroller to show one more value for customers. I am adding an option in the create/edit customer page. Here is the section of code Im having trouble with. 

 

array(
                                       'type' => 'select',
                                       'label' => $this->l('Salesman'),
                                       'name' => 'salesman',
                                       'required' => true,
                                        'options' => array(
						'query' => $salesman,
						'id' => 'id_employee',
						'name' => 'lastname'
					),
                                       'col' => '4',
                                       'hint' => $this->l('Salesman who is linked to this customer')
                                ), 	

This works. In the selection box, I see the salesmen lastnames. If I change it to

array(
                                       'type' => 'select',
                                       'label' => $this->l('Salesman'),
                                       'name' => 'salesman',
                                       'required' => true,
                                        'options' => array(
						'query' => $salesman,
						'id' => 'id_employee',
						'name' => 'firstname'
					),
                                       'col' => '4',
                                       'hint' => $this->l('Salesman who is linked to this customer')
                                ), 	

obviously now I see the firstnames in the list. What I would like is for the list to show firstname and last name on the same line. Is this possible?

 

Edited September 9, 2015 by belyza (see edit history)

[rytiz2873]

it is posible

[belyza]

it is posible

Can you help me as to how?

 

thanks

[rytiz2873]

you need to change $salesman sql query

[rytiz2873]

can't help without seeing this

[belyza]

can't help without seeing this

$salesman = Employee::getEmployees($this->default_form_language, true);

[rytiz2873]

override function:

 

public static function getEmployees()

{

return Db::getInstance()->executeS('

SELECT `id_employee`, `firstname`, `lastname`, CONCAT(`firstname`, \' \', `lastname`) as `employee_name`

FROM `'._DB_PREFIX_.'employee`

WHERE `active` = 1

ORDER BY `lastname` ASC

');

}

 

and use "employee_name"

[belyza]

Thank you it works! I ended up using the following code: 

$salesman = Db::getInstance()->executeS('
                SELECT `id_employee`, `firstname`, `lastname`, CONCAT(`firstname`, \' \', 
`lastname`) as `employee_name`
                FROM `'._DB_PREFIX_.'employee`
                WHERE `active` = 1
                ORDER BY `lastname` ASC
                ');
		$this->fields_form = array(
			'legend' => array(
				'title' => $this->l('Customer'),
				'icon' => 'icon-user'
			),
			'input' => array(
				array(
					'type' => 'radio',
					'label' => $this->l('Social title'),
					'name' => 'id_gender',
					'required' => false,
					'class' => 't',
					'values' => $list_genders
				),
				array(
					'type' => 'text',
					'label' => $this->l('First name'),
					'name' => 'firstname',
					'required' => true,
					'col' => '4',
					'hint' => $this->l('Invalid characters:').' 0-9!<>,;?=+()@#"째{}_$%:'
				),
				array(
					'type' => 'text',
					'label' => $this->l('Last name'),
					'name' => 'lastname',
					'required' => true,
					'col' => '4',
					'hint' => $this->l('Invalid characters:').' 0-9!<>,;?=+()@#"째{}_$%:'
				),
				array(
					'type' => 'text',
					'prefix' => '<i class="icon-envelope-o"></i>',
					'label' => $this->l('Email address'),
					'name' => 'email',
					'col' => '4',
					'required' => true,
					'autocomplete' => false
				),
				array(
					'type' => 'password',
					'label' => $this->l('Password'),
					'name' => 'passwd',
					'required' => ($obj->id ? false : true),
					'col' => '4',
					'hint' => ($obj->id ? $this->l('Leave this field blank if there\'s no change.') :
						sprintf($this->l('Password should be at least %s characters long.'), Validate::PASSWORD_LENGTH))
				),
				array(
					'type' => 'birthday',
					'label' => $this->l('Birthday'),
					'name' => 'birthday',
					'options' => array(
						'days' => $days,
						'months' => $months,
						'years' => $years
					)
				),
                                array(
                                       'type' => 'select',
                                       'label' => $this->l('Salesman'),
                                       'name' => 'salesman',
                                       'required' => true,
                                        'options' => array(
						'query' => $salesman,
						'id' => 'id_employee',
						'name' => 'employee_name'
					),
                                       'col' => '4',
                                       'hint' => $this->l('Salesman who is linked to this customer')
                                ),