X-Git-Url: https://git.llucax.com/mecon/meconlib.git/blobdiff_plain/71864b3585eb6e98f858701544c969ff2979aa9a..7f336c0bd2baf96080346d3ed06812cf45948f3a:/lib/MECON/HTML/Arbol/ArbolDB.php diff --git a/lib/MECON/HTML/Arbol/ArbolDB.php b/lib/MECON/HTML/Arbol/ArbolDB.php index 3a5f9b9..6937df8 100644 --- a/lib/MECON/HTML/Arbol/ArbolDB.php +++ b/lib/MECON/HTML/Arbol/ArbolDB.php @@ -11,7 +11,8 @@ class HTML_ArbolDB extends HTML_Arbol var $tabla; var $nombre; var $id; - var $link; + var $link = null; + var $prepend_link = null; var $db; function HTML_ArbolDB($dbdata, $imagen) @@ -21,7 +22,10 @@ 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']; $this->db = $dbdata['db']; $dat = $this->BuscarHijos(0); parent::HTML_Arbol($dat, $imagen); @@ -29,9 +33,11 @@ class HTML_ArbolDB extends HTML_Arbol function BuscarHijos($id) { - $sql = "SELECT $this->nombre, $this->id - FROM $this->tabla"; - if(!is_null$this->padre) + $sql = "SELECT $this->nombre, $this->id "; + if(!is_null($this->link)) + $sql .= ", $this->link "; + $sql .= "FROM $this->tabla "; + if(!is_null($this->padre)) $sql .= "WHERE $this->padre = '$id'"; $result = $this->db->query($sql); if(DB::isError($result)) @@ -41,10 +47,14 @@ class HTML_ArbolDB extends HTML_Arbol { $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;