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;
}
