From f4753c25b41fa3380b11c2fd6ad4b76047e6e284 Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Mon, 20 Nov 2017 16:23:50 +0100 Subject: D3.js: Display only backbone. --- api/data.json.php | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) 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(); -- cgit v1.1