Se agrega un TODO.

[mecon/meconlib.git] / lib / MECON / HTML / Arbol / ArbolDB.php

diff --git a/lib/MECON/HTML/Arbol/ArbolDB.php b/lib/MECON/HTML/Arbol/ArbolDB.php
index 13e9d991921aed3dbce1f96b50016b3872fc0379..0594bcb475087f0077a49f30f9e2950d64ce2af3 100644 (file)
--- a/lib/MECON/HTML/Arbol/ArbolDB.php
+++ b/lib/MECON/HTML/Arbol/ArbolDB.php
@@ -7,20 +7,31 @@ 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;

-       var $link;
+       var $link = null;
+       var $prepend_link = null;
+       var $where = '';
+       var $order = '';

        var $db;
     
     function HTML_ArbolDB($dbdata, $imagen)
     {
        var $db;
     
     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'];

-       $this->link = $dbdata['link']; 
+        if(isset($dbdata['prepend_link']))
+         $this->prepend_link = $dbdata['prepend_link']; 
+        if(isset($dbdata['link']))
+         $this->link = $dbdata['link']; 
+        if(isset($dbdata['where']))
+         $this->where = $dbdata['where'];
+        if(isset($dbdata['order']))
+         $this->order = ' ORDER BY '.$dbdata['nombre'].' '.$dbdata['order']; 

        $this->db = $dbdata['db']; 
        $dat = $this->BuscarHijos(0);
         parent::HTML_Arbol($dat, $imagen);
        $this->db = $dbdata['db']; 
        $dat = $this->BuscarHijos(0);
         parent::HTML_Arbol($dat, $imagen);


@@ -28,21 +39,35 @@ class HTML_ArbolDB extends HTML_Arbol
   
     function BuscarHijos($id)
     {
   
     function BuscarHijos($id)
     {

-        $sql = "SELECT $this->nombre, $this->id
-               FROM $this->tabla
-               WHERE $this->padre = '$id'";
+        $sql = "SELECT $this->nombre, $this->id ";
+        if(!is_null($this->link))
+        $sql .=  ", $this->link ";
+        $sql .=  "FROM $this->tabla ";
+        if(!is_null($this->padre) or $this->where)
+          $sql .= 'WHERE ';
+        if(!is_null($this->padre)) {
+          $sql .= "$this->padre = '$id'";
+          if ($this->where)
+            $sql .= ' AND';
+        } elseif ($this->where)
+          $sql .= $this->where;
+        $sql .= $this->order;

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

-       $dat = array();
+        $dat = array();

        while($row = $result->fetchRow())
        {
            $titulo = $row[0];
            $id = $row[1];
        while($row = $result->fetchRow())
        {
            $titulo = $row[0];
            $id = $row[1];

+           if(is_null($this->padre)) $sub = array();
+           else $sub = $this->BuscarHijos($id);
+           if(!is_null($this->link))  $link = $this->prepend_link.$row[2];
+           else $link = $this->prepend_link.$id;

            $dat[] = array(
                'titulo'=> $titulo,
            $dat[] = array(
                'titulo'=> $titulo,

-               'link' => $this->link.$id,
-               'sub' => $this->BuscarHijos($id) 
+               'link' => $link,
+               'sub' => $sub 

            );
        }
        return $dat;
            );
        }
        return $dat;