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
|
<?php
//
// Les variables de connexion a la BDD mySQL
//
require("../../config.php");
// Opens a connection to a MySQL server
$connection=mysql_connect ($dbhost, $dbuser, $dbpasswd);
if (!$connection) {
die('Not connected : ' . mysql_error());
}
// Set the active MySQL database
$db_selected = mysql_select_db($db_clients, $connection);
if (!$db_selected) {
die ('Can\'t use db : ' . mysql_error());
}
// Select all the rows in the markers table
if($_GET['etat']=="Tous" && $_GET['dep']=="Tous")
{
$query = "SELECT clt1.Code , clt1.etat, clt2.code, clt2.login, clt2.latitude, clt2.longitude FROM clients AS clt1, clients2 AS clt2 WHERE clt1.Code = clt2.code AND clt2.latitude <> '0.00000000'";
}
if($_GET['etat']=="Tous" && $_GET['dep']!="Tous")
{
$query = "SELECT clt1.Code , clt1.etat, clt2.code, clt2.login, clt2.latitude, clt2.longitude FROM clients AS clt1, clients2 AS clt2 WHERE clt1.Code = clt2.code AND clt2.latitude <> '0.00000000' AND clt1.codeFam='".$GET['dep']."'";
}
if($_GET['etat']!="Tous" && $_GET['dep']!="Tous")
{
$query = "SELECT clt1.Code , clt1.etat, clt2.code, clt2.login, clt2.latitude, clt2.longitude FROM clients AS clt1, clients2 AS clt2 WHERE clt1.Code = clt2.code AND clt2.latitude <> '0.00000000' AND clt1.codeFam='".$GET['dep']."' AND clt1.etat='".$GET['etat']."'";
}
if($_GET['etat']!="Tous" && $_GET['dep']=="Tous")
{
$query = "SELECT clt1.Code , clt1.etat, clt2.code, clt2.login, clt2.latitude, clt2.longitude FROM clients AS clt1, clients2 AS clt2 WHERE clt1.Code = clt2.code AND clt2.latitude <> '0.00000000' AND clt1.etat='".$GET['etat']."'";
}
$result = mysql_query($query);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
if ($row['etat'] >=0 && $row['etat'] <=6) {$etat = "Demande Infos";}
elseif ($row['etat'] == 20) {
if ($row['etat'] >= 40 && $row['etat'] <= 42) {$etat = "Installation a faire";} }
elseif ($row['etat'] >= 21 && $row['etat'] <= 32) {$etat = "Ineligibles";}
elseif ($row['etat'] >= 50 && $row['etat'] <= 52) {$etat = "En production";}
elseif ($row['etat'] >= 60 && $row['etat'] <= 69) {$etat = "En panne";}
else {$etat = "Autre Etat";}
// ADD TO XML DOCUMENT NODE
echo '<marker ';
echo 'code="' . parseToXML($row['code']) . '" ';
echo 'login="' . parseToXML($row['login']) . '" ';
echo 'lat="' . $row['latitude'] . '" ';
echo 'lng="' . $row['longitude'] . '" ';
echo 'etat="' . $etat . '" ';
echo 'etatnum="' . $row['etat'] . '" ';
echo '/>';
}
// End XML file
echo '</markers>';
?> |
