#!/usr/bin/perl

use strict;
use CGI;
use Data::Dumper;
use DBI;
use YAML qw( LoadFile );
my $cgi = new CGI;
print $cgi->header('text/html');
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 $colortoggle = 0;
my $colortogglevalue = "";
my $colortogglecolor = "#C0C0C0";
my $orderby = "alert";
my $brand = $var{brand} ? $var{brand} : "all";
exit unless $brand =~ m/^[a-z0-9]+$/;
$orderby = $var{orderby} if $var{orderby};
exit unless $orderby =~ m/^[a-z\-\.]+$/;
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 $brandmap = {
    "bluehost"  => qr{bluehost|hostmonster|justhost|fastdomain|rhostbh|rhostjh|cloudhosted|digitalcloud|ehosts|hostclear|hostfinity|ideahost"}o,
    "seo"       => qr{seoboxes}o,
    "aso"       => qr{asoshared|mysitehosted|webserversystems}o,
    "site5"     => qr{accountservergroup|apthost}o,
    "h9"        => qr{myserverhosts}o,
    "arvixe"    => qr{arvixe|arvixeshared|mysitehosted}o,
    "hostgator" => qr{websitewelcome|webhostbox|hostgator}o,
    "themecloud"=> qr{themecloud|themecloudshared},
    "all"       => qr{\w++}o,
};
my %expectednum = (
      'cpanel-accounts-two-days-behind' => 50,
      'cpanel-accounts-three-days-behind' => 50,
      'cpanel-accounts-four-days-behind' => 50,
      'cpanel-accounts-five-days-behind' => 50,
      'cpanel-accounts-six-days-behind' => 50,
      'cpanel-accounts-one-week-behind' => 50,
      'cpanel-accounts-not-backuped-up' => 50,
      'mountpoint-problems' => 0,
      'alert' => 0,
);
my %expecteddate = (
      'dirs.files.lastrun-date' => ($oneweek),
      'mysql-backup.lastrun-date' => ($oneweek),
      'postbackup.log-date' => $yesterday,
      'last-checkin-date' => ($now - 86400),
);
my %expectedstring = (
      'rpm-version' => $config_settings->{"eig_backup"}
);
my @order = qw{ hostname bhostname has-fc alert mountpoint-problems backup-status backup-stage cpanel-accounts-total cpanel-accounts-with-backups backups-daily backups-weekly backups-monthly backup-dirs-completed backup-dirs-uncompleted postbackup.log-date cpanel-accounts-one-week-behind cpanel-accounts-six-days-behind cpanel-accounts-five-days-behind cpanel-accounts-four-days-behind cpanel-accounts-three-days-behind cpanel-accounts-two-days-behind cpanel-accounts-one-day-behind cpanel-accounts-not-backuped-up dirs.files.lastrun-date mysql-backup.lastrun-date last-checkin-date rpm-version };


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 backupstate";
my $sth = $dbh->prepare($query);
$sth->execute or warn $sth->errstr;
my $data = {};
while(my $ref = $sth->fetchrow_hashref()){
  next unless $brand && $ref->{hostname} =~ m/\.($brandmap->{$brand})\./;
  next if $ref->{hostname} =~ m/\.alpha\./; #XXX ignore alpha boxes for now
  next if($ref->{hostname} =~ m/\.beta/ and substr($ref->{"backup-stage"},0,5) eq "Fatal");;
  foreach my $key (keys %$ref){
    if(defined($data->{$ref->{hostname}}->{$key})){
      $data->{$ref->{hostname}}->{$key} .= "<br>\n".$ref->{$key};
    }else{
      $data->{$ref->{hostname}}->{$key} = $ref->{$key};
    }
  }
}
$sth->finish;

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

while(my $ref = $sth->fetchrow_hashref()){
  if(defined($data->{$ref->{chostname}})){
    next if($data->{$ref->{chostname}}->{'has-fc'} eq 'yes');
    $data->{$ref->{chostname}}->{bhostname} = $ref->{bhostname};
  }
}
$sth->finish;




# flag specific boxes
foreach my $hostname (keys %$data){
  $data->{$hostname}->{alert} = 0;
  foreach my $part (keys %{$data->{$hostname}}){
    next if $data->{$hostname}->{'cpanel-accounts-total'} == 0;
    if(defined($expectednum{$part})){
      $data->{$hostname}->{alert}++ if $data->{$hostname}->{$part} > $expectednum{$part};
    }elsif(defined($expecteddate{$part})){
      $data->{$hostname}->{alert}++ if $data->{$hostname}->{$part} < $expecteddate{$part};
    }elsif(defined($expectedstring{$part})){
      my $matchstring = $expectedstring{$part};
      $data->{$hostname}->{alert}++ unless $data->{$hostname}->{$part} =~ m/$matchstring/;
    }
  }
  $data->{$hostname}->{alert}++ unless $data->{$hostname}->{'backup-status'} =~ m/running|bmu2/;
}
my $orderstring = $orderby ? "&orderby=$orderby" : "";
foreach my $availablebrand (keys %$brandmap){
    print "<a href='$me?brand=$availablebrand$orderstring'>$availablebrand</a>    ";
}

print "<table border=0>\n";
print "<tr>";
foreach my $part (@order){
  my $brandstring = $brand ? "&brand=$brand" : "";
  if($part eq $orderby && !$var{reverse}){
    print "<th><a href='$me?orderby=$part&reverse=1$brandstring'>$part</a></th>";
  }else{
    print "<th><a href='$me?orderby=$part$brandstring'>$part</a></th>";
  }
}
print "</tr>\n";
my @longorder = (sort{ ($data->{$b}->{$orderby} =~ /(^\d+$)/)[0] <=> ($data->{$a}->{$orderby} =~ /(^\d+$)/)[0] || $data->{$b}->{$orderby} cmp $data->{$a}->{$orderby} } keys %$data);
@longorder =  (sort{ ($data->{$a}->{$orderby} =~ /(^\d+$)/)[0] <=> ($data->{$b}->{$orderby} =~ /(^\d+$)/)[0] || $data->{$a}->{$orderby} cmp $data->{$b}->{$orderby} } keys %$data) if $var{reverse};

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 "bhostname"){
      if($data->{$hostname}->{"bhostname"} 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 "has-fc"){
      if(substr($data->{$hostname}->{'has-fc'},0,3) eq 'yes'){
        print " bgcolor='#66FF99'";
      }elsif(substr($data->{$hostname}->{'has-fc'},0,4) eq 'part'){
        print " bgcolor='#FFFF00'";
      }
    }elsif($part eq "backup-status"){
      print " bgcolor='#FF0099'" unless $data->{$hostname}->{'backup-status'} =~ m/(Datacycle running)|(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>";
    }else{
      print $data->{$hostname}->{$part};
    }
    print "</td>";
  }
  print "</tr>\n";
}
print "</table>\n";



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;
}

