-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy pathgraph_onu_ethernet_ports.php
109 lines (103 loc) · 4.97 KB
/
graph_onu_ethernet_ports.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<?php
include ("common.php");
include ("dbconnect.php");
if ($_GET) {
$id = $_GET['id'];
$port = $_GET['port'];
if (!preg_match('/^[0-9]*$/', $id)) {
print "that sux";
exit;
}
if (!preg_match('/^[0-9]*$/', $port)) {
print "that sux";
exit;
} else {
try {
$result = $db->query("SELECT CUSTOMERS.ID, CUSTOMERS.NAME, CUSTOMERS.ADDRESS, SN, OLT.NAME as OLT_NAME, INET_NTOA(OLT.IP_ADDRESS) as IP_ADDRESS, OLT.RO as RO, OLT_MODEL.TYPE, PON.NAME as PON_NAME, PON.PORT_ID as PORT_ID, PON.SLOT_ID as SLOT_ID, PON_ONU_ID from CUSTOMERS LEFT JOIN OLT on CUSTOMERS.OLT=OLT.ID LEFT JOIN OLT_MODEL on OLT.MODEL=OLT_MODEL.ID LEFT JOIN PON on CUSTOMERS.PON_PORT=PON.ID where CUSTOMERS.ID=$id");
} catch (PDOException $e) {
echo "Connection Failed:" . $e->getMessage() . "\n";
exit;
}
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
if($row{'TYPE'} == "1")
$big_onu_id = $row{'SLOT_ID'} * 10000000 + $row{'PORT_ID'} * 100000 + $row{'PON_ONU_ID'};
if($row{'TYPE'} == '2')
$big_onu_id = type2id($row{'SLOT_ID'}, $row{'PORT_ID'}, $row{'PON_ONU_ID'});
$olt_ip_address = $row["IP_ADDRESS"];
$sn = $row["SN"];
$olt_name = $row["OLT_NAME"];
$customer_name = $row["NAME"];
$rrd_name = dirname(__FILE__) . "/rrd/" . $sn . "_ethernet_" . $port . ".rrd";
$opts = array( "--start", "-1d", "--lower-limit=0", "--vertical-label=B/s", "--title=Daily Traffic Ethernet Port $port",
"DEF:inoctets=$rrd_name:input:AVERAGE",
"DEF:outoctets=$rrd_name:output:AVERAGE",
"AREA:inoctets#00FF00:In traffic",
"LINE1:outoctets#0000FF:Out traffic\\r",
"CDEF:inbits=inoctets",
"CDEF:outbits=outoctets",
"GPRINT:inbits:LAST:Last In\: %6.2lf %sBps",
"GPRINT:inbits:AVERAGE:Avg In\: %6.2lf %sBps",
"COMMENT: ",
"GPRINT:inbits:MAX:Max In\: %6.2lf %sBps\\r",
"COMMENT:\\n",
"GPRINT:outbits:LAST:Last Out\: %6.2lf %sBps",
"GPRINT:outbits:AVERAGE:Avg Out\: %6.2lf %sBps",
"COMMENT: ",
"GPRINT:outbits:MAX:Max Out\: %6.2lf %sBps\\r"
);
$opts2 = array( "--start", "-1w", "--lower-limit=0", "--vertical-label=B/s", "--title=Weekly Traffic Ethernet Port $port",
"DEF:inoctets=$rrd_name:input:AVERAGE",
"DEF:outoctets=$rrd_name:output:AVERAGE",
"AREA:inoctets#00FF00:In traffic",
"LINE1:outoctets#0000FF:Out traffic\\r",
"CDEF:inbits=inoctets",
"CDEF:outbits=outoctets",
"GPRINT:inbits:LAST:Last In\: %6.2lf %sBps",
"GPRINT:inbits:AVERAGE:Avg In\: %6.2lf %sBps",
"COMMENT: ",
"GPRINT:inbits:MAX:Max In\: %6.2lf %sBps\\r",
"COMMENT:\\n",
"GPRINT:outbits:LAST:Last Out\: %6.2lf %sBps",
"GPRINT:outbits:AVERAGE:Avg Out\: %6.2lf %sBps",
"COMMENT: ",
"GPRINT:outbits:MAX:Max Out\: %6.2lf %sBps\\r"
);
$opts3 = array( "--start", "-1m", "--lower-limit=0", "--vertical-label=B/s", "--title=Monthly Traffic Ethernet Port $port",
"DEF:inoctets=$rrd_name:input:AVERAGE",
"DEF:outoctets=$rrd_name:output:AVERAGE",
"AREA:inoctets#00FF00:In traffic",
"LINE1:outoctets#0000FF:Out traffic\\r",
"CDEF:inbits=inoctets",
"CDEF:outbits=outoctets",
"GPRINT:inbits:LAST:Last In\: %6.2lf %sBps",
"GPRINT:inbits:AVERAGE:Avg In\: %6.2lf %sBps",
"COMMENT: ",
"GPRINT:inbits:MAX:Max In\: %6.2lf %sBps\\r",
"COMMENT:\\n",
"GPRINT:outbits:LAST:Last Out\: %6.2lf %sBps",
"GPRINT:outbits:AVERAGE:Avg Out\: %6.2lf %sBps",
"COMMENT: ",
"GPRINT:outbits:MAX:Max Out\: %6.2lf %sBps\\r"
);
$rrd_traffic_url = $sn . "_ethernet_" . $port . ".gif";
$rrd_traffic_url_week = $sn . "_ethernet_" . $port . "week.gif";
$rrd_traffic_url_month = $sn . "_ethernet_" . $port . "month.gif";
$rrd_traffic = dirname(__FILE__) . "/rrd/" . $rrd_traffic_url;
$rrd_traffic_week = dirname(__FILE__) . "/rrd/" . $rrd_traffic_url_week;
$rrd_traffic_month = dirname(__FILE__) . "/rrd/" . $rrd_traffic_url_month;
$ret = rrd_graph($rrd_traffic, $opts);
$ret = rrd_graph($rrd_traffic_week, $opts2);
$ret = rrd_graph($rrd_traffic_month, $opts3);
if( !is_array($ret) )
{
$err = rrd_error();
echo "rrd_graph() ERROR: $err\n";
}
}
print "<center><h3>RRD Traffic Graphs for $customer_name @ OLT:$olt_name : ONU_SN: $sn</h3> ";
print "<p><img src=\"rrd/" . $rrd_traffic_url . "\"></img></p>";
print "<p><img src=\"rrd/" . $rrd_traffic_url_week . "\"></img></p>";
print "<p><img src=\"rrd/" . $rrd_traffic_url_month . "\"></img></p>";
}
}
?>