#! /usr/bin/perl
use CGI;
use DBI;
my $cgi = CGI->new;

my $dbh = DBI->connect("dbi:Pg:dbname=snmpfetch;host=violet.tg05.gathering.org", "snmpfetch", "removed")
        or die "Couldn't connect to database";
print $cgi->header(-type=>'text/html', -refresh=>'45; http://nms.tg05.gathering.org/nettkart-telnet.pl');

print <<"EOF";
<html>
  <head>
    <title>nettkart - telnet</title>
  </head>
  <body>
    <map name="switches">
EOF

my $q = $dbh->prepare('select * from switches natural join placements natural left join
( select switch,sum(bytes_in)/count(*) as
bytes_in,sum(bytes_out)/count(*) as bytes_out from get_datarate() group
by switch ) t1');
$q->execute();
while (my $ref = $q->fetchrow_hashref()) {
	$ref->{'placement'} =~ /\((\d+),(\d+)\),\((\d+),(\d+)\)/;
	
	my $traffic = 4.0 * $ref->{'bytes_in'} + $ref->{'bytes_out'};  # average and convert to bits (should be about the same in practice)
	my $ttext;
	if ($traffic >= 1_000_000_000) {
		$ttext = sprintf "%.2f Gbit/port/sec", $traffic/1_000_000_000;
	} elsif ($traffic => 1_000_000) {
		$ttext = sprintf "%.2f Mbit/port/sec", $traffic/1_000_000;
	} else {
		$ttext = sprintf "%.2f kbit/port/sec", $traffic/1_000;
	}

	printf "      <area shape=\"rect\" coords=\"%u,%u,%u,%u\" target=\"blank\" href=\"telnet://$ref->{'ip'}\" alt=\"%s (%s)\" onmouseover=\"window.status='%s (%s)'; return true\" onmouseout=\"window.status=''\" />\n",
		$3, $4, $1, $2, $ref->{'switch'}, $ref->{'sysname'},
		$ttext, $ref->{'sysname'}, $ttext;
}
$dbh->disconnect;

print <<"EOF";
    </map>

    <p><img src="nettkart.pl" usemap="#switches" /></p>
  </body>
</html>
EOF
