<?php /* vim: set binary expandtab tabstop=4 shiftwidth=4 textwidth=80:
-------------------------------------------------------------------------------
                             Ministerio de Economía
                                    meconlib
-------------------------------------------------------------------------------
This file is part of meconlib.

meconlib is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.

meconlib is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
 
You should have received a copy of the GNU General Public License; if not,
write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
Boston, MA  02111-1307  USA
-------------------------------------------------------------------------------
Creado: jue jul 17 15:33:41 ART 2003
Autor:  Gonzalo Merayo <gmeray@mecon.gov.ar>
        Leandro Lucarella <llucar@mecon.gov.ar>
-------------------------------------------------------------------------------
$Id$
-----------------------------------------------------------------------------*/

require_once 'MECON/HTML/Arbol.php';
require_once 'DB.php';

/**
 * DESC
 *
 * @access public
 */
class MECON_HTML_ArbolDB extends MECON_HTML_Arbol
{
    
    /**
     * DESC
     *
     * @var string $padre
     * @access public
     */
    var $padre = '';
    
    /**
     * DESC
     *
     * @var TIPO $tabla
     * @access public
     */
    var $tabla;
    
    /**
     * DESC
     *
     * @var string $nombre
     * @access public
     */
    var $nombre;
    
    /**
     * DESC
     *
     * @var TIPO $id   
     * @access public
     */
    var $id;
    
    /**
     * DESC
     *
     * @var TIPO $id_activo
     * @access public
     */
    var $id_activo;
    
    /**
     * DESC
     *
     * @var string $link 
     * @access public
     */
    var $link = '';
    
    /**
     * DESC
     *
     * @var string $link_append
     * @access public
     */
    var $link_append = '';
    
    /**
     * DESC
     *
     * @var string $where
     * @access public
     */
    var $where = '';
    
    /**
     * DESC
     *
     * @var string $order 
     * @access public
     */
    var $order = '';
    
    /**
     * DESC
     *
     * @var DB $db   
     * @access public
     */
    var $db;
    
    /**
     * 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'];
        $this->tabla = $dbdata['tabla'];
        $this->nombre = $dbdata['nombre'];
        $this->id = $dbdata['id'];
        $this->id_activo = @$dbdata['id_activo'];
        // FIXME - Deprecated!
        if(isset($dbdata['prepend_link']))
            $link_append = $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']; 
        
        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);
    }
     
    /**
     * DESC
     *
     * @param TIPO $id DESC
     *
     * @return TIPO
     * @access public
     */
    function BuscarHijos($id)
    {
        $sql = "SELECT $this->nombre, $this->id ";
        if($this->link)
            $sql .=  ", $this->link ";
        $sql .=  "FROM $this->tabla ";
        if($this->padre or $this->where)
          $sql .= 'WHERE ';
        if($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());
        $dat = array();
	while($row = $result->fetchRow())
	{
	    $titulo = $row[0];
	    $id = $row[1];
	    if(!$this->padre || !(!isset($this->expandir) ||
                              in_array($id, $this->expandir)))
                       $sub = array();
	    else $sub = $this->BuscarHijos($id);
	    $link = strval(@$row[2]);
	    $d = array(
            'titulo'=> $titulo,
            'link' => $link,
            '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;
        }
        $dat[] = $d;
	}
	return $dat;

    }

}

?>