X-Git-Url: https://git.llucax.com/mecon/ai.git/blobdiff_plain/0f3a5c8880fffcc8c23d3fa1028e7e41b7c823ee..6a8125da9b09da9fb28ac0eccae1283162d1545d:/lib/AI/Sistema.php 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"; }