From: Leandro Lucarella Date: Thu, 24 Jul 2003 22:29:30 +0000 (+0000) Subject: Se pone mas lindo el query de getSistemas (que no deja de ser feo). X-Git-Tag: svn_import~41 X-Git-Url: https://git.llucax.com/mecon/ai.git/commitdiff_plain/6a8125da9b09da9fb28ac0eccae1283162d1545d?ds=sidebyside Se pone mas lindo el query de getSistemas (que no deja de ser feo). --- diff --git a/lib/AI/Sistema.php b/lib/AI/Sistema.php index 6c761ae..17a4d02 100644 --- a/lib/AI/Sistema.php +++ b/lib/AI/Sistema.php @@ -190,7 +190,10 @@ FIXME - preguntar a gonzalo si le sirve. $id_field = $conf['id']; $tabla = $conf['base'].'.'.$conf['tabla']; // FIXME - ver como manejar JOINs - Ver de hacer el JOIN tambien en cargar. - $query = "SELECT AI.*, SA.nombre_sistema as nombre, SA.desc_sistema as descripcion FROM $tabla as AI, samurai.sistema as SA WHERE SA.id_sistema = AI.sistema and SA.estado = 1"; + $query = " + SELECT AI.*, SA.nombre_sistema as nombre, SA.desc_sistema as descripcion + FROM $tabla as AI, samurai.sistema as SA + WHERE SA.id_sistema = AI.sistema and SA.estado = 1"; if ($where) { $query .= " WHERE $where"; }