Tramites y Servicios

 

global $db_url;

if (!is_array($db_url)) {
$default_db = $db_url;
$db_url = array('default' => $default_db);
}

$db_url['mydb'] = 'mysql://gobtlajoUTI:d18hO!2u@localhost/gobtlajo_UTI';

db_set_active( 'mydb' );

$arreglo = array();
arbol(0, $arreglo);

dibuja_arbol( $arreglo );

db_set_active('default'); // set back to original

function arbol( $padre_id , &$arr ){
global $db_url;
$sql = "select * from arbol_tramites where padre_id = " . $padre_id . " and estatus = 1";
$res = db_query( $sql );

while( $r = db_fetch_array($res)){
$arr[$r['id']][0] = $r['id'];
$arr[$r['id']][1] = $r['etiqueta'];
$arr[$r['id']][2] = $r['padre_id'];
$arr[$r['id']][3] = $r['orden'];

$sql2 = "select * from arbol_tramites where padre_id = " . $r['id'];

$res2 = db_query($sql2);

//if ( $res2->num_rows ){
if ( mysql_num_rows($res2) ){

$arr[$r['id']][4] = array();
arbol( $r['id'] , $arr[$r['id']][4] );
}
}

}

function dibuja_arbol( $tramites ){
global $db_url;

echo "

";
foreach( $tramites as $tr ){

echo "

";
echo "

";

$sql = "SELECT * FROM arbol_tramites_asignados at, tramites t where t.estatus = 1 and at.tramite_id = t.id and at.arbol_id = " . $tr[0];
$res = db_query( $sql );

//if ( $res->num_rows ){
if ( mysql_num_rows($res) ){

while( $ita = db_fetch_array($res) ){

echo "

";
}
}

if ( is_array($tr[4]) ){
dibuja_arbol($tr[4]);
}

echo "

";
}
echo "

";
}
?>