X-Git-Url: https://git.llucax.com/mecon/ai.git/blobdiff_plain/bfb8e871c0f11bd56529ddc1d1852bfa974b3dc0..8485a1e9661ed55cbd522b3a3fce5ac254ab3ba3:/sistema/www/index.php

diff --git a/sistema/www/index.php b/sistema/www/index.php
index cfab50e..5021868 100644
--- a/sistema/www/index.php
+++ b/sistema/www/index.php
@@ -211,22 +211,21 @@ if ($tipo) {
         'db'            => &$db,
         'tabla'         => $tabla,
         'id'            => $tipo,
-        'nombre'        => $tipo,
-        'prepend_link'  => $tipo.'?accion='.AI_MODIF.'&id='
+        'nombre'        => 'nombre',
+        'prepend_link'  => $tipo.'?accion='.AI_MODIF.'&id=',
+        'order'         => 'asc',
     );
     if ($tipo == 'grupo' or $tipo == 'servicio') {
-        $dbdata['nombre']   = 'nombre';
         $dbdata['id_padre'] = $tipo . '_padre';
     } elseif ($tipo == 'sistema') { // FIXME - horrible!!!
-        $dbdata = array(
-            'db'            => &$db,
-            'tabla'         => "intranet.$tabla as A, samurai.sistema as S",
-            'id'            => "A.$tipo",
-            'nombre'        => 'S.nombre_sistema',
-            'prepend_link'  => $tipo.'?accion='.AI_MODIF.'&id=',
-            'where'         => 'S.id_sistema = A.sistema',
-            'order'         => 'asc',
-        );
+        $dbdata =
+            array(
+                'tabla'         => "intranet.$tabla as A, samurai.sistema as S",
+                'id'            => "A.$tipo",
+                'nombre'        => 'S.nombre_sistema',
+                'where'         => 'S.id_sistema = A.sistema AND S.estado = 1',
+            )
+            + $dbdata;
     }
     $arbol = new HTML_ArbolDB($dbdata, $arbol);
     $marco->addMenuVertical($arbol);