#!/usr/bin/perl
use CGI;
use Data::Dumper;
use JSON qw{ decode_json };
use DBI;
use YAML qw( LoadFile );
$Data::Dumper::Sortkeys = 1;

my $cgi = new CGI;
print $cgi->header('text/plain');
my %var = $cgi->Vars;
my $now = time();

my $remote_ip = $ENV{REMOTE_ADDR};
if( $ENV{REMOTE_ADDR} eq '127.0.0.1' || $ENV{REMOTE_ADDR} eq '74.220.198.194' || -t STDOUT ) {
  $remote_ip = $var{ip} if defined ($var{ip});
}

my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";
my $db_shared_h = 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 $!"); 



#select server.hostname as hostname,newbacknetip.serverid as id,inet_ntoa(newbacknetip.backnetip) as bnip from newbacknetip left join server on newbacknetip.serverid = server.serverid where newbacknetip.backnetip = inet_aton("192.185.135.165")
my $query_shared = $db_shared_h->prepare("select newbacknetip.serverid as serverid,server.hostname as hostname,inet_ntoa(newbacknetip.backnetip) as bnip from newbacknetip left join server on newbacknetip.serverid = server.serverid where newbacknetip.backnetip = inet_aton(?)");

$query_shared->execute($remote_ip) || die("Error:".$query_shared->errstr."\n");
$data->{self} = $query_shared->fetchrow_hashref();
$query_shared->finish;
if( ! defined($data->{self}->{serverid})){
    print "go away\n";
    exit;
}

$data->{fromremote} = decode_json($var{data});

if($data->{fromremote}->{hostname} ne $data->{self}->{hostname}){
  warn "imposter, remote: $data->{fromremote}->{hostname} ne from-remote-ip: $data->{self}->{hostname}";
  exit;
}


foreach my $k (qw(vgtotalspace vgfreespace)){
  $data->{fromremote}->{$k} =~ s/^(\d+).*$/$1/;
}


my $qbss = $db_shared_h->prepare("SELECT * FROM backupserverstate WHERE serverid = ?");
$qbss->execute($data->{self}->{serverid}) or die("error:".$qbss->errstr."\n");

if( $qbss->rows() ){
  $data->{fromdb}= $qbss->fetchrow_hashref();
  my $change = 0;
  foreach my $k (qw( vgtotalspace vgfreespace ) ){
    if($data->{fromdb}->{$k} ne $data->{fromremote}->{$k}){
      $change = 1;
      last;
    }
  }
  if($change == 0){
    print "checkin noted\n";
    my $qbssu = $db_shared_h->prepare('UPDATE backupserverstate SET lastcheckindate = ?');
    $qbssu->execute($now) or die("error: ".$qbssu->errstr);
  }else{
    print "updating disk space numbers\n";
    my $qbssu = $db_shared_h->prepare('UPDATE backupserverstate SET vgtotalspace = ?, vgfreespace = ?, lastupdate = ?, lastcheckindate = ?');
    $qbssu->execute($data->{fromremote}->{vgtotalspace}, $data->{fromremote}->{vgfreespace},$now,$now) or die("error: ".$qbssu->errstr);
  }
}else{
  print "inserting fresh entry\n";
  my $qbssi = $db_shared_h->prepare('INSERT INTO backupserverstate (serverid,hostname,vgtotalspace,vgfreespace,lastupdate,lastcheckindate) VALUES (?,?,?,?,?,?)');
  $qbssi->execute(  $data->{self}->{serverid},
                    $data->{self}->{hostname},
                    $data->{fromremote}->{vgtotalspace},
                    $data->{fromremote}->{vgfreespace},
                    $now,
                    $now
                 ) or die("error: ".$qbssi->errstr);
}

print Dumper($data) if defined($data->{fromremote}->{debug});
