1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
public function fetchdepartementAction()
{
$taping = $this->_getParam('taping');
Zend_Layout::getMvcInstance()->disableLayout();
$this->_helper->viewRenderer->setNoRender();
$dbAdapter = Zend_Registry::get('dbAdapter');
$select = $dbAdapter->select()
->from(array('m' => 'maps_dep'),
array('m.id_departement',
'm.nom_departement',
"concat(m.code,'-',m.nom_departement) as Search"))
->where('m.code LIKE ?',$taping.'%')
->orwhere('m.nom_departement LIKE ?',$taping.'%')
->group('m.id_departement');
//die($select);
$rows = $dbAdapter->fetchAll($select);
//die(print_r($rows));
$data = new Zend_Dojo_Data('id_departement', $rows);
echo $data->toJson();
} |
Partager