#!/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 $sanh = $dbh->prepare("SELECT id,hostname,inet_ntoa(ip) AS ip FROM san WHERE ip = inet_aton(?)");
  $sanh->execute($remote_ip) || die("Error: ".$sanh->errstr."\n");
  $data->{self} = $sanh->fetchrow_hashref();
  $sanh->finish;
  if(! defined($data->{self}->{id})){
    print Dump({sandata => 'There is none'});
    exit;
  }
    my $bmh = $dbh->prepare('SELECT DISTINCT backup.hostname as backuphostname,
                                 backup.publickey as backuppublickey,
                                 "backupgw1.silo1.provo1.unifiedlayer.com" as gatewayhostname,
                                 "10.24.15.250" as gatewayprivateip
                          FROM san
                          LEFT JOIN volume ON volume.san_id = san.id
                          LEFT JOIN instance ON volume.instance_id = instance.id
                          LEFT JOIN vps ON instance.vps_id = vps.id
                          LEFT JOIN backupmap ON vps.id = backupmap.vps_id
                          LEFT JOIN backup ON backupmap.backup_id = backup.id
                          WHERE san.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({sandata => 'There is none'});
    exit;
}




