#!/usr/bin/perl
use strict;
use DBI;
use CGI;
use YAML qw(Dump LoadFile);
use Data::Dumper;
my $cgi = new CGI;
print $cgi->header('text/yaml');
my %var = $cgi->Vars;
$Data::Dumper::Sortkeys = 1;

my $trusted = 'no';

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});
  $trusted = 'yes';
}

my $config = LoadFile("/var/www/conf/vpsbackup_master_config.yaml") || die "Failed to load config: $!\n";

my $data = {};

my $dbh = DBI->connect("DBI:mysql:database=".$config->{vps_backup_db}.";host=localhost",$config->{vps_backup_user}, $config->{vps_backup_pass}) or die("couldnt connect to db $!");


if ($trusted ne 'yes'){
  # find if the remote IP is a gateway, and if so what gateway
  my $query = "select id,inet_ntoa(gateway.privateip) as gatewayprivateip from gateway where publicip = inet_aton(?) or privateip = inet_aton(?);";
  my $gwh = $dbh->prepare($query);
  $gwh->execute($remote_ip,$remote_ip) || die("Error:".$gwh->errstr."\n");
  $data->{gateway} = $gwh->fetchrow_hashref();
  $gwh->finish;
  if( defined($data->{gateway}->{id})){
    $trusted = 'yes';
  }else{
    print Dump({data => 'There is none'});
    exit;
  }
  $remote_ip = $var{ip} if defined($var{ip});
}

if($trusted eq 'yes'){

  my $vpsh = $dbh->prepare("SELECT id,hostname,inet_ntoa(privateip) AS privateip, type FROM vps WHERE privateip = inet_aton(?)");
  $vpsh->execute($remote_ip) || die("Error: ".$vpsh->errstr."\n");
  $data->{self} = $vpsh->fetchrow_hashref();
  $vpsh->finish;
  if(! defined($data->{self}->{id})){
    print Dump({vpsdata => 'There is none'});
    exit;
  }
  my $bmh = $dbh->prepare(" SELECT backup.hostname as backuphostname,
                               backup.publickey as backuppublickey,
                               gateway.hostname as gatewayhostname,
                               inet_ntoa(gateway.privateip) as gatewayprivateip
                        FROM backupmap
                        LEFT JOIN gateway ON backupmap.gateway_id = gateway.id
                        LEFT JOIN backup ON backupmap.backup_id = backup.id
                        WHERE backupmap.vps_id = ?");

  $bmh->execute($data->{self}->{id}) || die("Error:".$bmh->errstr."\n");
  while( my $ref = $bmh->fetchrow_hashref()){
    push(@{$data->{backupmap}},$ref);
  }
  $bmh->finish;
  print Dump($data);
}else{
    print Dump({vpstdata => 'There is none'});
    exit;
}




