X-Git-Url: https://git.llucax.com/mecon/meconlib.git/blobdiff_plain/71864b3585eb6e98f858701544c969ff2979aa9a..6a5d60ab6ce03a168256c9b77ad1fd3166d50c14:/lib/MECON/HTML/Arbol/ArbolDB.php

diff --git a/lib/MECON/HTML/Arbol/ArbolDB.php b/lib/MECON/HTML/Arbol/ArbolDB.php
index 3a5f9b9..111c4e5 100644
--- a/lib/MECON/HTML/Arbol/ArbolDB.php
+++ b/lib/MECON/HTML/Arbol/ArbolDB.php
@@ -1,9 +1,31 @@
-<?
+<?php /* vim: set binary expandtab tabstop=4 shiftwidth=4 textwidth=80:
+-------------------------------------------------------------------------------
+                             Ministerio de Economía
+                                    meconlib
+-------------------------------------------------------------------------------
+This file is part of meconlib.
 
-require_once 'MECON/HTML/Arbol.php';
-require_once 'DB.php';
+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>
+-------------------------------------------------------------------------------
+$Id$
+-----------------------------------------------------------------------------*/
 
+require_once 'MECON/HTML/Arbol.php';
+require_once 'DB.php';
 
 class HTML_ArbolDB extends HTML_Arbol
 {
@@ -11,7 +33,10 @@ class HTML_ArbolDB extends HTML_Arbol
 	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)
@@ -21,7 +46,14 @@ class HTML_ArbolDB extends HTML_Arbol
 	$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);
@@ -29,22 +61,35 @@ class HTML_ArbolDB extends HTML_Arbol
   
     function BuscarHijos($id)
     {
-        $sql = "SELECT $this->nombre, $this->id
-	        FROM $this->tabla";
-	if(!is_null$this->padre)
-	  $sql .= "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());
-	$dat = array();
+        $dat = array();
 	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,
-		'link' => $this->link.$id,
-		'sub' => $this->BuscarHijos($id) 
+		'link' => $link,
+		'sub' => $sub 
 	    );
 	}
 	return $dat;
@@ -52,4 +97,5 @@ class HTML_ArbolDB extends HTML_Arbol
     }
 
 }
+
 ?>