Permito mostrar tablas sin padre

diff --git a/lib/MECON/HTML/Arbol/ArbolDB.php b/lib/MECON/HTML/Arbol/ArbolDB.php
index 13e9d991921aed3dbce1f96b50016b3872fc0379..3a5f9b961bf2bea62def756d7b275518960d9269 100644 (file)
--- a/lib/MECON/HTML/Arbol/ArbolDB.php
+++ b/lib/MECON/HTML/Arbol/ArbolDB.php
@@ -7,7 +7,7 @@ require_once 'DB.php';
 
 class HTML_ArbolDB extends HTML_Arbol
 {
 
 class HTML_ArbolDB extends HTML_Arbol
 {

-        var $padre;
+        var $padre = null;

        var $tabla;
        var $nombre;
        var $id;
        var $tabla;
        var $nombre;
        var $id;


@@ -16,7 +16,8 @@ class HTML_ArbolDB extends HTML_Arbol
     
     function HTML_ArbolDB($dbdata, $imagen)
     {
     
     function HTML_ArbolDB($dbdata, $imagen)
     {

-        $this->padre = $dbdata['id_padre'];
+        if(isset($dbdata['id_padre']))
+          $this->padre = $dbdata['id_padre'];

        $this->tabla = $dbdata['tabla'];
        $this->nombre = $dbdata['nombre'];
        $this->id = $dbdata['id'];
        $this->tabla = $dbdata['tabla'];
        $this->nombre = $dbdata['nombre'];
        $this->id = $dbdata['id'];


@@ -29,8 +30,9 @@ class HTML_ArbolDB extends HTML_Arbol
     function BuscarHijos($id)
     {
         $sql = "SELECT $this->nombre, $this->id
     function BuscarHijos($id)
     {
         $sql = "SELECT $this->nombre, $this->id

-               FROM $this->tabla
-               WHERE $this->padre = '$id'";
+               FROM $this->tabla";
+       if(!is_null$this->padre)
+         $sql .= "WHERE $this->padre = '$id'";

         $result = $this->db->query($sql);
         if(DB::isError($result))
           die($result->getMessage());
         $result = $this->db->query($sql);
         if(DB::isError($result))
           die($result->getMessage());