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 6c761aefcce8def330b3c3a9b56b18e2baa2d032..17a4d02a2bad6bc8ba871ca138fbcf92ac0595a3 100644 (file)
--- 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";
         }