list - employees informations.tpl prestashop -

list - employees informations.tpl prestashop -

my problem: need create employee list in

admin\themes\default\template\controllers\products\informations.tpl:

http://darkplace.pl/wp-content/uploads/2013/02/1111111111.png

so pasted code in:

\override\classes\product.php

<?php class product extends productcore { public static function getemployees() { homecoming db::getinstance()->executes(' select `id_employee`, `firstname`, `lastname` `'._db_prefix_.'employee` `active` = 1 order `lastname` asc '); } } ?>

&&

admin\themes\default\template\controllers\products\informations.tpl :

<select name="id_employee_forward" style="vertical-align: middle;"> <option value="-1">{l s='-- take --'}</option> {foreach $employees $employee} <option value="{$employee.id_employee}"> {tools::substr($employee.firstname, 0, 1)}. {$employee.lastname}</option> {/foreach} <option value="0">{l s='someone else'}</option> </select>

it not working presume need induce code somewhere.

$employees = product::getemployees();

but hell freeze before figure out myself. there is. quest 4 best. please help me !

you need assign info using smarty, screenshot looks need in file adminproductscontroller.php located in /controllers/admin/

you accomplish next code.

$this->context->smarty->assign("employees", product::getemployees());

i place code in function renderform()

list controller smarty prestashop