diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2017-11-20 16:23:50 +0100 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2017-11-20 16:23:50 +0100 |
| commit | f4753c25b41fa3380b11c2fd6ad4b76047e6e284 (patch) | |
| tree | 67ee5ecda560b7ff6ee6ecf46c09244194e38e2f | |
| parent | 7bcbf754477cf8e146553d92b733c02458f2ced7 (diff) | |
| download | chd_gestion-f4753c25b41fa3380b11c2fd6ad4b76047e6e284.zip chd_gestion-f4753c25b41fa3380b11c2fd6ad4b76047e6e284.tar.gz chd_gestion-f4753c25b41fa3380b11c2fd6ad4b76047e6e284.tar.bz2 | |
D3.js: Display only backbone.
| -rw-r--r-- | api/data.json.php | 11 |
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(); |