xmlatlas.php
2.53 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php
//
//$id_menu = id do menu que será montado
//$perfil = perfis
include_once("php/admin.php");
include_once("php/conexao.php");
echo "<"."\x3F"."xml version='1.0' encoding='UTF-8' "."\x3F".">";
//echo "<"."\x3F"."xml-stylesheet type='text/xsl' href='../menutemas/menutemas.xsl'"."\x3F".">";
echo "\n<RAIZ>\n";
if (!isset($perfil)){$perfil = "";}
$q = "select * from i3geoadmin_atlas ";
$qatlas = $dbh->query($q);
foreach($qatlas as $row)
{
echo "<ATLAS>\n";
echo " <ID>".$row["id_atlas"]."</ID>\n";
echo " <TITULO>".xmlmenu_prepara($row["titulo_atlas"])."</TITULO>\n";
echo " <DESCRICAO>".xmlmenu_prepara($row["desc_atlas"])."</DESCRICAO>\n";
echo " <ICONE>".$row["icone_atlas"]."</ICONE>\n";
echo " <LINKMAISINFO>".xmlmenu_prepara($row["link_atlas"])."</LINKMAISINFO>\n";
echo " <TEMPLATEHTML>".xmlmenu_prepara($row["template_atlas"])."</TEMPLATEHTML>\n";
echo " <WABERTURA>".$row["w_atlas"]."</WABERTURA>\n";
echo " <HABERTURA>".$row["h_atlas"]."</HABERTURA>\n";
echo " <PRANCHADEFAULT>".$row["pranchadefault_atlas"]."</PRANCHADEFAULT>\n";
echo " <TIPOGUIAS>".$row["tipoguias_atlas"]."</TIPOGUIAS>\n";
echo " <BASEMAPFILE>".$row["basemapfile_atlas"]."</BASEMAPFILE>\n";
echo " <PRANCHAS>\n";
xmlmenu_pegapranchas($row["id_atlas"]);
echo " </PRANCHAS>\n";
echo " </ATLAS>\n";
}
echo "</RAIZ>\n";
$dbh = null;
function xmlmenu_pegapranchas($id_atlas)
{
global $dbh;
$q = "select * from i3geoadmin_atlasp as p where p.id_atlas = $id_atlas ";
$qpranchas = $dbh->query($q);
foreach($qpranchas as $row)
{
echo " <PRANCHA>\n";
echo " <ID>".$row["id_prancha"]."</ID>\n";
echo " <TITULO>".xmlmenu_prepara($row["titulo_prancha"])."</TITULO>\n";
echo " <DESCRICAO>".xmlmenu_prepara($row["desc_prancha"])."</DESCRICAO>\n";
echo " <ICONE>".$row["icone_prancha"]."</ICONE>\n";
echo " <LINKMAISINFO>".xmlmenu_prepara($row["link_prancha"])."</LINKMAISINFO>\n";
echo " <WABERTURA>".$row["w_prancha"]."</WABERTURA>\n";
echo " <HABERTURA>".$row["h_prancha"]."</HABERTURA>\n";
echo " <MAPEXT>".$row["mapext_prancha"]."</MAPEXT>\n";
echo " <TEMAS>\n";
xmlmenu_pegatemas($row["id_prancha"]);
echo " </TEMAS>\n";
echo " </PRANCHA>\n";
}
}
function xmlmenu_pegatemas($id_prancha)
{
global $dbh;
$q = "select * from i3geoadmin_atlast as t where t.id_prancha = $id_prancha ";
$qpranchas = $dbh->query($q);
foreach($qpranchas as $row)
{
echo "<TEMA>\n";
echo "</TEMA>\n";
}
}
function xmlmenu_prepara($texto)
{
return str_replace("&","&",$texto);
}
?>