1 files changed, 10 insertions, 1 deletions
diff --git a/api/data.json.php b/api/data.json.php
index 961d6fa..79ce772 100644
--- a/api/data.json.php
+++ b/api/data.json.php
@@ -27,7 +27,16 @@ if (mysqli_connect_errno()) {
 unset($db_config);
 $mysqli->set_charset("utf8") or die($mysqli->error);
 
-$res = $mysqli->query("SELECT id, CONCAT('e', id) as 'name', uplink_id FROM equipements");
+// $res = $mysqli->query("SELECT id, IFNULL(NULLIF(hostname,''), CONCAT('e', id)) as 'name', uplink_id
+//  FROM equipements
+//  WHERE equipement_modele_id >= 12
+//  AND equipement_modele_id != 47
+//  AND date_hs IS NULL");
+
+$res = $mysqli->query("SELECT id, IFNULL(NULLIF(hostname,''), CONCAT('e', id)) as 'name', uplink_id
+FROM equipements
+WHERE (relais_id IS NOT NULL OR hostname='STG1')
+AND date_hs IS NULL");
 
 $roots = array();
 $childrens = array();