* @return void
* @access public
*/
- function MECON_HTML_ArbolDB($dbdata, $titulo, $link_append = '')
+ function MECON_HTML_ArbolDB($dbdata, $titulo, $link_append = '', $expandir = false)
{
if(isset($dbdata['id_padre']))
$this->padre = $dbdata['id_padre'];
$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'];
-
- $this->expandir = array($this->id_activo);
- if(isset($this->id_activo))
+
+ if(!$expandir)
{
- $id = $this->id_activo;
- while($id != 0)
+ $this->expandir = array($this->id_activo);
+ if(isset($this->id_activo))
{
- $sql = "SELECT $this->padre
- FROM $this->tabla
- WHERE $this->id = '".$id."'";
- $id = $this->db->getOne($sql);
- $this->expandir[] = $id;
+ $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;
+ }
}
}
$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))
{
$titulo = $row[0];
$id = $row[1];
- if(!$this->padre || !in_array($id, $this->expandir)) $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(
'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;
}