private function getPermisos() { $dataResult = array(); $dbh = new \Login\Model\DataBaseHelper($this->em); $resultSelect = $dbh->selectWhere('SELECT p FROM \\Login\\Model\\Entity\\Permiso p'); foreach ($resultSelect as $res) { //$dataResult[$res->getPermisoId()] = $res->getPermisoTipo(); $dataResult[] = array('value' => $res->getPermisoId(), 'label' => $res->getPermisoTipo(), 'attributes' => array('id' => $res->getPermisoTipo() . 'opt'), 'label_attributes' => array('id' => $res->getPermisoTipo(), 'class' => '')); } return $dataResult; }
public function getOptionsLugar() { $dataResult = array(); $dbh = new \Login\Model\DataBaseHelper($this->em); $resultSelect = $dbh->selectAll('\\Login\\Model\\Entity\\Lugar'); $dataResult[''] = '--Seleccione un lugar--'; foreach ($resultSelect as $res) { $dataResult[$res->getLugarId()] = $res->getLugarNombre(); } return $dataResult; }
/** * Metodo para consultar todos los barrios que existen en la BBDD * @return type */ public function getOptionsBarrio() { $dataResult = array(); $dbh = new \Login\Model\DataBaseHelper($this->em); $resultSelect = $dbh->selectWhere('SELECT p FROM \\Login\\Model\\Entity\\Barrio p'); $dataResult[''] = '--Seleccione un Barrio--'; foreach ($resultSelect as $res) { $dataResult[$res->getBarrioId()] = $res->getBarrioNombre(); } return $dataResult; }