public function getbrandsAction() { try { $sql = "select marcas.codmarca, marcas.descmarca from marcas"; $account = $this->user->account; $fconnector = new \Silar\Misc\FirebirdConnector(); $fconnector->setAccount($account); $fconnector->executeQuery($sql); $result = $fconnector->getResult(); $obj = new stdClass(); $obj->id = "TODAS"; $obj->text = "Todas las marcas"; $brands = array($obj); foreach ($result as $r) { $obj = new stdClass(); $obj->id = trim($r->CODMARCA); $obj->text = trim($r->DESCMARCA); $brands[] = $obj; } return $this->setJsonResponse($brands, 200); } catch (Exception $ex) { $this->logger->log("Exception while connecting database... {$ex}"); return $this->setJsonResponse(array('message' => 'Error interno, por favor contacte al administrador'), 500); } }
public function getResult($account, $sql) { switch ($account->database) { case 'firebird': $fconnector = new \Silar\Misc\FirebirdConnector(); $fconnector->setAccount($account); $fconnector->executeQuery($sql); $result = $fconnector->getResult(); break; } return $result; }