Se agregan atributos para parametrizar gráficos de torta.

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

diff --git a/lib/MECON/HTML/ArbolDB.php b/lib/MECON/HTML/ArbolDB.php
index fc0ca689fee113a762c1d76ba245ec373ecc43a2..dedf3b93b37d21b6e2c5f3dd2c4f5e34999b5b4f 100644 (file)
--- a/lib/MECON/HTML/ArbolDB.php
+++ b/lib/MECON/HTML/ArbolDB.php
@@ -28,20 +28,105 @@ $Id$
 require_once 'MECON/HTML/Arbol.php';
 require_once 'DB.php';
 
 require_once 'MECON/HTML/Arbol.php';
 require_once 'DB.php';
 

+/**
+ * DESC
+ *
+ * @access public
+ */

 class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
 {
 class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
 {

+    
+    /**
+     * DESC
+     *
+     * @var string $padre
+     * @access public
+     */

     var $padre = '';
     var $padre = '';

+    
+    /**
+     * DESC
+     *
+     * @var TIPO $tabla
+     * @access public
+     */

     var $tabla;
     var $tabla;

+    
+    /**
+     * DESC
+     *
+     * @var string $nombre
+     * @access public
+     */

     var $nombre;
     var $nombre;

+    
+    /**
+     * DESC
+     *
+     * @var TIPO $id   
+     * @access public
+     */

     var $id;
     var $id;

+    
+    /**
+     * DESC
+     *
+     * @var TIPO $id_activo
+     * @access public
+     */

     var $id_activo;
     var $id_activo;

+    
+    /**
+     * DESC
+     *
+     * @var string $link 
+     * @access public
+     */

     var $link = '';
     var $link = '';

+    
+    /**
+     * DESC
+     *
+     * @var string $link_append
+     * @access public
+     */

     var $link_append = '';
     var $link_append = '';

+    
+    /**
+     * DESC
+     *
+     * @var string $where
+     * @access public
+     */

     var $where = '';
     var $where = '';

+    
+    /**
+     * DESC
+     *
+     * @var string $order 
+     * @access public
+     */

     var $order = '';
     var $order = '';

+    
+    /**
+     * DESC
+     *
+     * @var DB $db   
+     * @access public
+     */

     var $db;
     
     var $db;
     

-    function MECON_HTML_ArbolDB($dbdata, $titulo, $link_append = '')
+    /**
+     * Constructor
+     *
+     * @param TIPO $dbdata DESC
+     * @param TIPO $titulo DESC
+     * @param string $link_append DESC
+     *
+     * @return void
+     * @access public
+     */
+    function MECON_HTML_ArbolDB($dbdata, $titulo, $link_append = '', $expandir = false)

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


@@ -56,13 +141,41 @@ class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
             $this->link = $dbdata['link']; 
         if(isset($dbdata['where']))
             $this->where = $dbdata['where'];
             $this->link = $dbdata['link']; 
         if(isset($dbdata['where']))
             $this->where = $dbdata['where'];

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

         if(isset($dbdata['order']))
             $this->order = ' ORDER BY '.$dbdata['nombre'].' '.$dbdata['order']; 
         $this->db = $dbdata['db']; 
         if(isset($dbdata['order']))
             $this->order = ' ORDER BY '.$dbdata['nombre'].' '.$dbdata['order']; 
         $this->db = $dbdata['db']; 

+        
+        if(!$expandir)
+        {
+          $this->expandir = array($this->id_activo);
+          if(isset($this->id_activo))
+          {
+            $id = $this->id_activo;
+            while($id != 0)
+            {
+              $sql = "SELECT $this->padre
+                      FROM $this->tabla
+                      WHERE $this->id = '".$id."'";
+              $id = $this->db->getOne($sql);
+              $this->expandir[] = $id;
+            }
+          }
+        }
+

         parent::MECON_HTML_Arbol(array(), $titulo, $link_append);
         $this->datos = $this->BuscarHijos(0);
     }
         parent::MECON_HTML_Arbol(array(), $titulo, $link_append);
         $this->datos = $this->BuscarHijos(0);
     }

-  
+     
+    /**
+     * DESC
+     *
+     * @param TIPO $id DESC
+     *
+     * @return TIPO
+     * @access public
+     */

     function BuscarHijos($id)
     {
         $sql = "SELECT $this->nombre, $this->id ";
     function BuscarHijos($id)
     {
         $sql = "SELECT $this->nombre, $this->id ";


@@ -77,6 +190,8 @@ class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
             $sql .= ' AND';
         } elseif ($this->where)
           $sql .= $this->where;
             $sql .= ' AND';
         } elseif ($this->where)
           $sql .= $this->where;

+        if(isset($this->habilitado))
+          $sql .= " AND ".$this->habilitado." = 1 ";

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


@@ -86,7 +201,9 @@ class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
        {
            $titulo = $row[0];
            $id = $row[1];
        {
            $titulo = $row[0];
            $id = $row[1];

-           if(!$this->padre) $sub = array();
+           if(!$this->padre || !(!isset($this->expandir) ||
+                              in_array($id, $this->expandir)))
+                       $sub = array();

            else $sub = $this->BuscarHijos($id);
            $link = strval(@$row[2]);
            $d = array(
            else $sub = $this->BuscarHijos($id);
            $link = strval(@$row[2]);
            $d = array(


@@ -95,6 +212,8 @@ class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
             'id' => $id,
             'sub' => $sub 
            );
             'id' => $id,
             'sub' => $sub 
            );

+        if(isset($this->expandir) && in_array($id, $this->expandir) && $id != $this->id_activo)
+          $d['bold'] = 1;

         if (!is_null($this->id_activo) and $id == $this->id_activo) {
             $d['activo'] = 1;
         }
         if (!is_null($this->id_activo) and $id == $this->id_activo) {
             $d['activo'] = 1;
         }