From e0dc7cfd7b0e54e20e53cc9c658275e4e5c96a56 Mon Sep 17 00:00:00 2001
From: Ludovic Pouzenc <ludovic@pouzenc.fr>
Date: Sun, 1 May 2016 18:35:57 +0200
Subject: Update synoptique ADT -> Svc -> Equipement (icones et labels)

---
 api/img_adt_svc_relais.php | 30 +++++++++++++++++++++---------
 1 file changed, 21 insertions(+), 9 deletions(-)

(limited to 'api/img_adt_svc_relais.php')

diff --git a/api/img_adt_svc_relais.php b/api/img_adt_svc_relais.php
index 56fe7ee..a8ee294 100644
--- a/api/img_adt_svc_relais.php
+++ b/api/img_adt_svc_relais.php
@@ -72,13 +72,14 @@ EOD;
 }
 //	>];
 
-function node_equipement($eid, $shape, $img, $label) {
+function node_equipement($eid, $img, $label, $ip) {
 	$label = htmlentities($label);
+	$sub = (strlen($ip)>0)?$ip:"eid $eid";
 		return <<<EOD
-	"e$eid" [ margin=0, shape=$shape, label=<
+	"e$eid" [ margin=0, shape=none, label=<
 		<TABLE border="0" cellborder="0">
 		<TR><TD><IMG SRC="icons/$img"/></TD></TR>
-		<TR><TD>$label<br/><font point-size="8">eid $eid</font></TD></TR>
+		<TR><TD>$label<br/><font point-size="8">$sub</font></TD></TR>
 		</TABLE>
 	>, URL="/gestion/equipements/view/$eid"];
 
@@ -108,23 +109,34 @@ EOD;
 //	>, URL="/gestion/relais/view/$rid"];
 
 fwrite($fd, graph_header());
-$res = $mysqli->query("SELECT * FROM v_relais_detail WHERE adherent_id=" . $arg_adt);
+$sql = "SELECT v.adt, v.adt_title, v.service_id, v.service, v.relais_id, v.relais_degre, v.relais,
+	v.routeur_equipement_id, v.antenne1_equipement_id, v.antenne2_equipement_id,
+	e1.ipmgmt_id AS e1_ip, IF(LENGTH(e1.hostname)>0,e1.hostname,'Routeur') AS e1_title, CONCAT('emid', e1.equipement_modele_id, '.png') AS e1_img,
+	e2.ipmgmt_id AS e2_ip, IF(LENGTH(e2.hostname)>0,e2.hostname,'Antenne1') AS e2_title, CONCAT('emid', e2.equipement_modele_id, '.png') AS e2_img,
+	e3.ipmgmt_id AS e3_ip, IF(LENGTH(e3.hostname)>0,e3.hostname,'Antenne2') AS e3_title, CONCAT('emid', e3.equipement_modele_id, '.png') AS e3_img
+FROM v_relais_detail v
+LEFT JOIN equipements e1 ON (e1.id = v.routeur_equipement_id)
+LEFT JOIN equipements e2 ON (e2.id = v.antenne1_equipement_id)
+LEFT JOIN equipements e3 ON (e3.id = v.antenne2_equipement_id)
+WHERE adherent_id=" . $arg_adt;
+
+$res = $mysqli->query($sql);
 $empty=true;
 while ( $row = $res->fetch_assoc() ) {
 	$empty=false;
 
 	if ( isset($row['adt']) && isset($row['service_id']) && isset($row['routeur_equipement_id']) ) {
-		fwrite($fd, node_adt($row['adherent_id'], 'none', $row['adt'], $row['adt_title'])); //egg
-		fwrite($fd, node_equipement($row['routeur_equipement_id'], 'none', 'rt.png', 'Routeur')); //rectangle
-		fwrite($fd, edge_service($row['adherent_id'],$row['routeur_equipement_id'], $row['service']));
+		fwrite($fd, node_adt($arg_adt, 'none', $row['adt'], $row['adt_title'])); //egg
+		fwrite($fd, node_equipement($row['routeur_equipement_id'], $row['e1_img'], $row['e1_title'], $row['e1_ip']));
+		fwrite($fd, edge_service($arg_adt,$row['routeur_equipement_id'], $row['service']));
 	}
 
 	if ( isset($row['antenne1_equipement_id']) ) {
-		fwrite($fd, node_equipement($row['antenne1_equipement_id'], 'none', 'ant.png', 'Antenne1'));
+		fwrite($fd, node_equipement($row['antenne1_equipement_id'], $row['e2_img'], $row['e2_title'], $row['e2_ip']));
 		fwrite($fd, "\te".$row['routeur_equipement_id']." -> e".$row['antenne1_equipement_id'].";\n");
 	}
 	if ( isset($row['antenne2_equipement_id']) ) {
-		fwrite($fd, node_equipement($row['antenne2_equipement_id'], 'none', 'ant.png', 'Antenne2'));
+		fwrite($fd, node_equipement($row['antenne2_equipement_id'], $row['e3_img'], $row['e3_title'], $row['e3_ip']));
 		fwrite($fd, "\te".$row['antenne1_equipement_id']." -> e".$row['antenne2_equipement_id'].";\n");
 	}
 	if ( isset($row['relais_id']) && isset($row['relais_degre']) ) {
-- 
cgit v1.1