aboutsummaryrefslogtreecommitdiffstats
path: root/config/rrd-summary/status_rrd_summary.php
diff options
context:
space:
mode:
authorjim-p <jimp@pfsense.org>2010-06-24 14:15:25 -0400
committerjim-p <jimp@pfsense.org>2010-06-24 14:15:25 -0400
commitf470286614fcf816671bf772cfbe42ae81e077cc (patch)
tree36c8b00d0bd7a72c7b500baec98a843e992ca9f3 /config/rrd-summary/status_rrd_summary.php
parentcc851da395e1915026d321fd8f421dacddd71203 (diff)
downloadpfsense-packages-f470286614fcf816671bf772cfbe42ae81e077cc.tar.gz
pfsense-packages-f470286614fcf816671bf772cfbe42ae81e077cc.tar.bz2
pfsense-packages-f470286614fcf816671bf772cfbe42ae81e077cc.zip
Add RRD Summary package which will show current and previous month bandwidth usage for any given RRD file and start date.
Diffstat (limited to 'config/rrd-summary/status_rrd_summary.php')
-rw-r--r--config/rrd-summary/status_rrd_summary.php90
1 files changed, 90 insertions, 0 deletions
diff --git a/config/rrd-summary/status_rrd_summary.php b/config/rrd-summary/status_rrd_summary.php
new file mode 100644
index 00000000..8906ee55
--- /dev/null
+++ b/config/rrd-summary/status_rrd_summary.php
@@ -0,0 +1,90 @@
+<?php
+/*
+ rrd_summary.php
+ Copyright (C) 2010 Jim Pingle
+
+ Redistribution and use in source and binary forms, with or without
+ modification, are permitted provided that the following conditions are met:
+
+ 1. Redistributions of source code must retain the above copyright notice,
+ this list of conditions and the following disclaimer.
+
+ 2. Redistributions in binary form must reproduce the above copyright
+ notice, this list of conditions and the following disclaimer in the
+ documentation and/or other materials provided with the distribution.
+
+ THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES,
+ INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
+ AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
+ AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY,
+ OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ POSSIBILITY OF SUCH DAMAGE.
+*/
+require_once("guiconfig.inc");
+
+$startday = isset($_POST['startday']) ? $_POST['startday'] : "01";
+$rrd = isset($_POST['rrd']) ? $_POST['rrd'] : "wan-traffic.rrd";
+
+$start = "00 " . date("m/{$startday}/Y");
+$lastmonth = "00 " . date("m/{$startday}/Y", strtotime("-1 month", strtotime(date("m/{$startday}/Y"))));
+
+$thismonth = fetch_rrd_summary($rrd, $start, "now");
+$lastmonth = fetch_rrd_summary($rrd, $lastmonth, $start, "86400");
+
+function fetch_rrd_summary($rrd, $start, $end, $resolution="3600") {
+ $traffic = array();
+ $rrd = escapeshellarg("/var/db/rrd/{$rrd}");
+ $start = escapeshellarg($start);
+ $end = escapeshellarg($end);
+ exec("/usr/local/bin/rrdtool fetch {$rrd} AVERAGE -r {$resolution} -s {$start} -e {$end} | grep -v nan | awk '{ sum1 += $2/(1024*1024); sum2 += $3/(1024*1024) } END { printf \"%u|%u\", sum1*{$resolution}, sum2*{$resolution}; }'", $traffic);
+ return explode('|', trim($traffic[0]));
+}
+
+function print_rrd_summary_table($data) { ?>
+<table>
+ <tr><th>&nbsp;</th><th>Bandwidth</th></tr>
+ <tr><td>In</td><td><?php echo $data[0]; ?> MBytes</td></tr>
+ <tr><td>Out</td><td><?php echo $data[1]; ?> MBytes</td></tr>
+ <tr><td>Total</td><td><?php echo $data[0] + $data[1]; ?> MBytes</td></tr>
+</table>
+<?php
+}
+
+$pgtitle = "Status: RRD Summary";
+include("head.inc");
+include("fbegin.inc");
+
+$rrds = glob("/var/db/rrd/*-traffic.rrd");
+
+?>
+<form name="form1" action="status_rrd_summary.php" method="POST">
+ RRD Database:
+ <select name="rrd" class="formselect" onchange="document.form1.submit()">
+ <?php
+ foreach ($rrds as $r) {
+ $r = basename($r);
+ $selected = ($r == $rrd) ? " selected" : "";
+ print "<option value=\"{$r}\"{$selected}>{$r}</option>";
+ } ?>
+ </select>
+ Start Day:
+ <select name="startday" class="formselect" onchange="document.form1.submit()">
+ <?php
+ for ($day=1; $day < 29; $day++) {
+ $selected = ($day == $startday) ? " selected" : "";
+ print "<option value=\"{$day}\"{$selected}>{$day}</option>";
+ } ?>
+ </select>
+</form>
+<br/>
+This Month (to date, does not include this hour, starting at day <?php echo $startday; ?>):
+<?php print_rrd_summary_table($thismonth); ?>
+<br/><br/>
+Last Month:
+<?php print_rrd_summary_table($lastmonth); ?>
+
+<?php include("fend.inc"); ?>