#!/usr/bin/perl

use strict;
use CGI;
use Data::Dumper;
use DBI;
use YAML 'LoadFile';
my $cgi = new CGI;
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 );
print $cgi->header('text/html');

my $colortoggle = 0;
my $colortogglevalue = "";
my $colortogglecolor = "#C0C0C0";
my $orderby = "alert";
$orderby = $var{orderby} if $var{orderby};
exit unless $orderby =~ m/^[a-z\-\.]+$/;
my $reverse = 0;
$reverse = 1 if $var{'reverse'} == 1;

my $me = $ENV{SCRIPT_NAME};
my $now = time;
my $yesterday = $now - (60 * 60 * 24);
my $oneweek = $now - (60 * 60 * 24 * 7);
my $thirtysixhours =  $now - (60 * 60 * 36);
my %expectednum = (
      'homepercentused' => 80,
      'backuppercentused' => 80,
      'alert' => 0,
);
my %expecteddate = (
#      'lastupdated' => ($oneweek),
);
my %expectedstring = (
#      'rpm-version' => "backup-2.1.31-1.BH",
      'rpm-version' => "backup-2.1.56-1.BH|bmu2",
#      'rpm-version' => "backup-2.1.2[59]-1.BH|backup-2.1.31-1.BH",
);
#my @order = qw{ hostname bhostname alert mountpoint-problems rpm-version backup-status backup-stage backup-dirs-completed backup-dirs-uncompleted postbackup.log-date cpanel-accounts-one-week-behind cpanel-accounts-two-days-behind cpanel-accounts-not-backuped-up cpanel-accounts-with-backups cpanel-accounts-total dirs.files.lastrun-date mysql-backup.lastrun-date last-checkin-date };
my @order = qw{ partition alert homesize homeused homepercentused backupsize backupused backuppercentused bpercent ballocate ballocatem bsavings lastupdated };

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 * FROM backupstatepartitions";
#$query = "SELECT * FROM backupstatepartitions WHERE hostname like 'box69%.bluehost.com'";

my $sth = $dbh->prepare($query);
$sth->execute or warn $sth->errstr;
my $data = {};
while(my $ref = $sth->fetchrow_hashref()){
  next if $ref->{hostname} =~ m/\.alpha\./; #XXX ignore alpha boxes for now
  my $partition = $ref->{hostname}."-".$ref->{'pnum'};
  $data->{$partition}->{'partition'} = $partition;
  foreach my $key (keys %$ref){
    if(defined($data->{$partition}->{$key})){
      $data->{$partition}->{$key} .= "<br>\n".$ref->{$key};
    }else{
      $data->{$partition}->{$key} = $ref->{$key};
    }
  }
}
$sth->finish;

my %totals;
# flag specific boxes
# and generate derived data
foreach my $part (keys %$data){
  $data->{$part}->{alert} = 0;
  $data->{$part}->{homepercentused} = 0;
  $data->{$part}->{homepercentused} = (int(($data->{$part}->{homeused} / $data->{$part}->{homesize})*10000)/100) if $data->{$part}->{homesize};
  $data->{$part}->{backuppercentused} = 0;
  $data->{$part}->{backuppercentused} = (int(($data->{$part}->{backupused} / $data->{$part}->{backupsize})*10000)/100) if $data->{$part}->{backupsize};
  $data->{$part}->{bpercent} = 0;
  $data->{$part}->{bpercent} = (int(($data->{$part}->{backupused} / $data->{$part}->{homeused})*100)) if $data->{$part}->{homeused};
  $data->{$part}->{ballocatem} = "homeused";
  $data->{$part}->{ballocate} = $data->{$part}->{homeused} * 1.5;
  if(480000000 > $data->{$part}->{ballocate}){
    $data->{$part}->{ballocate} = 480000000;
    $data->{$part}->{ballocate} = 550000000 if $data->{$part}->{homesize} > 700000000;
    $data->{$part}->{ballocate} = 660000000 if $data->{$part}->{homesize} > 1400000000;
    $data->{$part}->{ballocate} = 750000000 if $data->{$part}->{homesize} > 1500000000;
    $data->{$part}->{ballocatem} = "minimum";
  }
  if(($data->{$part}->{backupused} * 1.1) > $data->{$part}->{ballocate}){
    $data->{$part}->{ballocate} = $data->{$part}->{backupused} * 1.25;
    $data->{$part}->{ballocatem} = "backupused";
  }
  if(($data->{$part}->{homesize} * 1.5) < $data->{$part}->{ballocate}){
    $data->{$part}->{ballocate} = $data->{$part}->{homesize} * 1.5;
    $data->{$part}->{ballocatem} = "standard";
  }
  $data->{$part}->{bsavings} = $data->{$part}->{backupsize} - $data->{$part}->{ballocate};
  foreach my $key (keys %{$data->{$part}}){
    $totals{$key} += $data->{$part}->{$key} if $data->{$part}->{$key} =~ m/^\-?\d+\.?\d*$/;
#    next if $data->{$part}->{'cpanel-accounts-total'} == 0;
    if(defined($expectednum{$key})){
#print "$part $key ".$data->{$part}->{$key}."<br>\n";
#print " ".$data->{$part}->{$key}." ".$expectednum{$key}."<br>\n";
      $data->{$part}->{alert}++ if $data->{$part}->{$key} > $expectednum{$key};
    }elsif(defined($expecteddate{$key})){
      $data->{$part}->{alert}++ if $data->{$part}->{$key} < $expecteddate{$key};
    }elsif(defined($expectedstring{$key})){
      my $matchstring = $expectedstring{$key};
      $data->{$part}->{alert}++ unless $data->{$part}->{$key} =~ m/$matchstring/;
    }
  }
#  $data->{$part}->{alert}++ unless $data->{$part}->{'backup-status'} =~ m/running|bmu2/;
}

print "<table border=0>\n";
print "<tr>";
foreach my $part (@order){
  if($part eq $orderby && $reverse == 0){
    print "<th><a href='$me?orderby=$part&reverse=1'>$part</a></th>";
  }else{
    print "<th><a href='$me?orderby=$part'>$part</a></th>";
  }
}
print "</tr>\n";
if($orderby eq "alert" and $reverse == 1){
  $reverse = 0;
}elsif($orderby eq "alert"){
  $reverse = 1;
}
my @longorder;
if($orderby eq "partition"){
  @longorder = (sort{ $data->{$b}->{$orderby} cmp $data->{$a}->{$orderby} } keys %$data) if $reverse == 0;;
  @longorder = (sort{ $data->{$a}->{$orderby} cmp $data->{$b}->{$orderby} } keys %$data) if $reverse == 1;
}elsif($orderby eq 'lastupdated' or $orderby eq 'ballocatem'){
  @longorder = (sort{ $data->{$b}->{$orderby} cmp $data->{$a}->{$orderby} || $data->{$a}->{'partition'} cmp $data->{$b}->{'partition'} } keys %$data) if $reverse == 0;;
  @longorder = (sort{ $data->{$a}->{$orderby} cmp $data->{$b}->{$orderby} || $data->{$a}->{'partition'} cmp $data->{$b}->{'partition'}} keys %$data) if $reverse == 1;

}else{
  @longorder = (sort{ $data->{$a}->{$orderby} <=> $data->{$b}->{$orderby} || $data->{$a}->{'partition'} cmp $data->{$b}->{'partition'} } keys %$data) if $reverse == 0;
  @longorder = (sort{ $data->{$b}->{$orderby} <=> $data->{$a}->{$orderby} || $data->{$a}->{'partition'} cmp $data->{$b}->{'partition'} } keys %$data) if $reverse == 1;
}

foreach my $hostname (@longorder){
#  print "$hostname\n";
  print "<tr>";

  foreach my $part (@order){
    print "<td";
    if(defined($expectednum{$part})){
      print " bgcolor='#FF0000'" if $data->{$hostname}->{$part} > $expectednum{$part};
    }elsif(defined($expecteddate{$part})){
      print " bgcolor='#FF0000'" if $data->{$hostname}->{$part} < $expecteddate{$part};
    }elsif(defined($expectedstring{$part})){
      my $matchstring = $expectedstring{$part};
      print " bgcolor='#FF0000'" unless $data->{$hostname}->{$part} =~ m/$matchstring/;
    }elsif($part eq $orderby){
      if($data->{$hostname}->{$part} ne $colortogglevalue){
        if($colortoggle == 1){
          $colortoggle = 0;
        }else{
          $colortoggle = 1;
        }
        $colortogglevalue = $data->{$hostname}->{$part};
      }
      print " bgcolor='$colortogglecolor'" if $colortoggle == 1;

    }elsif($part eq "backup-stage"){
   
      if($data->{$hostname}->{$part} =~ m/(Idle: gathering events)|(No jobs.)/ ){
        print " bgcolor='#99FFFF'";
      }elsif($data->{$hostname}->{$part} =~ m/(Paused)|(Pending)/ ){
        print " bgcolor='#FFFF00'";
      }elsif($data->{$hostname}->{$part} =~ m/(Full backup in progress)|(Full)/){
        print " bgcolor='#00FF00'";
      }elsif($data->{$hostname}->{$part} =~ m/Active/ ){
        print " bgcolor='#66FF99'";
      }elsif($data->{$hostname}->{$part} =~ m/(Incr)|(Constructing seed directory)|(Rotate)/){
        print " bgcolor='#66FF99'";
      }else{
        print " bgcolor='#FF0099'";
      }
    }elsif($part eq "backup-status"){
      print " bgcolor='#FF0099'" unless $data->{$hostname}->{'backup-status'} =~ m/(is running)|(running [\d\.]+)|bmu2/;
    }elsif($part eq "hostname"){
      print " bgcolor='#488AC7'" if $hostname =~ m/alpha|beta/;
    }elsif($part eq "cpanel-accounts-total"){
      print " bgcolor='#3BB9FF'" if $data->{$hostname}->{'cpanel-accounts-total'} == 0;
    }
    print ">";
    if($part =~ m/date$/){
      my $datestamp = $data->{$hostname}->{$part};
      print metime($datestamp);
    }elsif($part eq "hostname"){
      print "<a target=_new href='backupstatechanges?box=$hostname'>$hostname</a>";
    }elsif($part =~ m/percent/){
      print $data->{$hostname}->{$part}." %";
    }else{
      if($data->{$hostname}->{$part} =~ m/^(\-?\d+\.?\d*)$/){
        my $value = $1;
        $value =~ s/(?<=\d)(?=(?:\d\d\d)+\b)/,/g;
        print $value;
      }else{
        print $data->{$hostname}->{$part};
      }
    }
    print "</td>";
  }
  print "</tr>\n";
#  foreach my $uid( sort{ $tmphash->{$b} <=> $tmphash->{$a}} keys %$tmphash){
}
print "<tr>\n";
foreach my $key (@order){
  my $value = $totals{$key};
  $value =~ s/(?<=\d)(?=(?:\d\d\d)+\b)/,/g;
  print "<td>$value</td>";
}
print "\n</tr>\n";
print "</table>\n";

#print Dumper($data);


sub metime {
  my $timestamp = shift;
  my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) =  localtime($timestamp);
  my @abbr = qw( Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec );
  my $result = sprintf("%s %2s %2d:%02d:%02d ",$abbr[$mon],$mday,$hour,$min,$sec);
  return $result;
}

