#!/usr/bin/perl

use strict;
use CGI;
use DBI;
use JSON 'encode_json';
use YAML 'LoadFile';
use Data::Dumper;
my $cgi = new CGI;
#print $cgi->header("text/plain");
my %var = $cgi->Vars;
my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";

my $validated = 0;
foreach my $regex ( @{ $config_settings->{"valid_ips"} } ) {
        $validated = 1 if ( $ENV{REMOTE_ADDR} =~ m/^$regex/ );
}
exit if ( !$validated );

my $order = "bbox";
$order = "cbox" if($var{order} eq "cbox");
my $bycustomer = {};
my $bybackup = {};

my $dbh = DBI->connect("DBI:mysql:database=".$config_settings->{backup_db}.";host=localhost",$config_settings->{backup_user}, $config_settings->{backup_pass}) or die("couldnt connect to db $!"); 

my $query = "SELECT DISTINCT chostname,bhostname FROM iscsiview";
my $sth = $dbh->prepare($query);
$sth->execute or warn $sth->errstr;

while(my $ref = $sth->fetchrow_hashref()){
  $bycustomer->{$ref->{chostname}}->{$ref->{bhostname}} = "NFS";
  $bybackup->{$ref->{bhostname}}->{$ref->{chostname}} = "NFS";
}
$sth->finish;
#print Dumper($bycustomer);
#print Dumper($bybackup);

if (exists $var{'json'}) {
    print $cgi->header('application/json');
    print encode_json({'by_cust' => $bycustomer, 'by_backup' => $bybackup});
    exit;
}

print $cgi->header();
print "<table border=1>\n";

if($order eq "bbox"){
  print '<tr><th><a href=?order=bbox>Backup Server</a></th><th><a href=?order=cbox>Customer Server</a></th></tr>'."\n";
  printdata(\$bybackup);
}else{
  print '<tr><th><a href=?order=cbox>Customer Server</a></th><th><a href=?order=bbox>Backup Server</a></th></tr>'."\n";
  printdata(\$bycustomer);
}

#while(my $ref = $sth->fetchrow_hashref()){
#  print "<tr><td>".$ref->{bbox}."</td><td>".$ref->{cbox}."</td></tr>\n";
#}
print "</table>\n";

sub printdata {
  my $data_ref = shift;
  my $lasthost = "";
  foreach my $host1 (sort keys %{$$data_ref}){
    foreach my $host2( sort keys %{$$data_ref->{$host1}}){
      my $tmphost = $host1;
      unless($host1 eq $lasthost){
        $lasthost = $host1;
        $tmphost = $host1;
      }else{
        $tmphost = "";
      }
      print "<tr><td>$tmphost</td><td>$host2</td><td>".$$data_ref->{$host1}->{$host2}."</td><tr>\n";
    }
  }

}
