#!/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};

my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";
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 $backupserver = get_server($ENV{REMOTE_ADDR});
my @trustedips = qw(74.220.198.194 127.0.0.1 74.220.198.27 74.220.198.28 74.220.198.29 162.144.11.10);
push (@trustedips, $backupserver->{'ip'});
exit unless grep(/^$ENV{REMOTE_ADDR}$/, @trustedips);

$data = decode_json($var{keywords});
exit unless $backupserver->{'hostname'} == $data->{'hostname'} ;


my $now = time;
my $query = "SELECT * FROM backupserver WHERE serverid = ?";
my $sth = $dbh->prepare($query);
$sth->execute($backupserver->{serverid}) or warn $sth->errstr;
my @fields = qw{ volume_type number_of_clients backup_space_size backup_space_available backup_space_used total_home_size};
if ($sth->rows()) {
    #Update the server entry with the received data
    $query = "UPDATE backupserver SET " . join(' = ?, ',@fields)  . " = ?, lastcheckindate = ? WHERE serverid = ?";
    $sth = $dbh->prepare($query);
    my @fields_data;
    foreach my $field (@fields){
        if (defined $data->{$field}) {
            push @fields_data,$data->{$field};
        } else {
            print "Missing data $field\n";
            die;
        }
    }
    $sth->execute(@fields_data, $now, $backupserver->{serverid}) or die $sth->errstr;
} else {
    #Case server not in db
    $query = "INSERT INTO backupserver (serverid, " . join(', ',@fields) . ", lastcheckindate ) values ( ?, ?, ?, ?, ?, ?, ?, ? )";
    $sth = $dbh->prepare($query);
    my @fields_data;
    foreach my $field (@fields){
        if (defined $data->{$field}) {
            push @fields_data,$data->{$field};
        } else {
            print "Missing data $field\n";
            die;
        }
    }
    $sth->execute($backupserver->{serverid}, @fields_data, $now) or die $sth->errstr;
}
print "done\n";

sub get_server {
    my $ip = shift;
    my $query = q(
            SELECT *,INET_NTOA(newbacknetip.backnetip) AS "ip" FROM server
            JOIN newbacknetip ON server.serverid = newbacknetip.serverid
            WHERE newbacknetip.backnetip = INET_ATON(?)
            LIMIT 1
            );
    my $sth = $dbh->prepare($query);
    $sth->execute($ip) or die $sth->errstr;
    my $res = $sth->fetchrow_hashref();
    exit unless defined $res->{'serverid'};
    return $res;
}
