diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-05-01 18:35:57 +0200 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-05-01 18:35:57 +0200 |
| commit | e0dc7cfd7b0e54e20e53cc9c658275e4e5c96a56 (patch) | |
| tree | 2bb3e5d3f87b75a1f56a61199789331f20fe9dd6 /api/img_adt_svc_relais.php | |
| parent | 8b9dc52fbf27656ad304523dcf2592e4afa4f0cf (diff) | |
| download | chd_gestion-e0dc7cfd7b0e54e20e53cc9c658275e4e5c96a56.zip chd_gestion-e0dc7cfd7b0e54e20e53cc9c658275e4e5c96a56.tar.gz chd_gestion-e0dc7cfd7b0e54e20e53cc9c658275e4e5c96a56.tar.bz2 | |
Update synoptique ADT -> Svc -> Equipement (icones et labels)
Diffstat (limited to 'api/img_adt_svc_relais.php')
| -rw-r--r-- | api/img_adt_svc_relais.php | 30 |
1 files changed, 21 insertions, 9 deletions
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']) ) { |