#!/usr/bin/perl
use strict;
use DBI;
use CGI;
use YAML 'LoadFile';
use JSON 'encode_json';
use Data::Dumper;

my $cgi = new CGI;
print $cgi->header();
my %var = $cgi->Vars;

validate(qw(hostname));
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 $compute = get_server($var{'hostname'});
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 50.6.6.12);
push (@trustedips, $compute->{'ip'});
exit unless  grep(/^$ENV{REMOTE_ADDR}$/, @trustedips);

my $vlan_mapping = {
    '101' => '541',
    '105' => '542',
    '495' => '543',
    '1490' => '544',
    '1500' => '545',
    '1501' => '546',
    '787' => '547',
    '1190' => '548',
    '1191' => '515',
    '1493' => '517',
    '794' => '518',
    '1497' => '519',
    '121' => '521',
    '109' => '522',
};

update_initiator_name() if defined $var{'initiator_name'};
get_all();

sub get_all {
    my $query = q(
        SELECT distinct(backupserver.hostname) AS backup_hostname,
        INET_NTOA(backupserverip.backnetip) AS backup_ip,
        s.hostname,s.dc,
        dr.nproc,dr.ram,dr.vlan,dr.distro,dr.size,dr.id,
        driscsi.initiator_name as intiator_name,
        INET_NTOA(newbacknetip.backnetip) AS ip
        FROM drserver AS dr
        JOIN server AS s ON s.serverid = dr.serverid
        JOIN newbacknetip ON dr.serverid = newbacknetip.serverid
        JOIN iscsimounts ON dr.serverid = iscsimounts.cboxid
        JOIN server AS backupserver ON iscsimounts.bboxid = backupserver.serverid
        JOIN privbacknetip AS backupserverip ON backupserver.serverid = backupserverip.serverid
        JOIN driscsi ON dr.computeid = driscsi.computeid
        WHERE dr.computeid = ?
        );
    my $sth = $dbh->prepare($query);
    $sth->execute($compute->{'serverid'}) or die $sth->errstr;
    my $dr_clients = $sth->fetchall_hashref('hostname');
    foreach my $client (keys %$dr_clients){
        if (defined $dr_clients->{$client}->{'vlan'} && defined $vlan_mapping->{$dr_clients->{$client}->{'vlan'}}){
            $dr_clients->{$client}->{'dr_vlan'} = $vlan_mapping->{$dr_clients->{$client}->{'vlan'}};
        }
    }
    $query = q(
        SELECT mountid,cmount,plabel,cbox.hostname
        FROM iscsimounts
        JOIN server AS cbox ON cbox.serverid = iscsimounts.cboxid
        WHERE cboxid IN (
            SELECT serverid FROM drserver
            WHERE computeid = ?
            )
        );
    my $sth = $dbh->prepare($query);
    $sth->execute($compute->{'serverid'}) or die $sth->errstr;
    my $dr_mounts = $sth->fetchall_hashref('mountid');
    foreach my $id (keys %$dr_mounts){
        push @{$dr_clients->{$dr_mounts->{$id}->{'hostname'}}->{'backup_mounts'}}, $dr_mounts->{$id}->{'cmount'};
    }
    print encode_json($dr_clients);
    exit;
}

sub get_server {
    my $server_hostname = shift;
    my $query = q(
            SELECT *,INET_NTOA(newbacknetip.backnetip) AS "ip" FROM server
            JOIN newbacknetip ON server.serverid = newbacknetip.serverid
            WHERE hostname = ?
            LIMIT 1
            );
    my $sth = $dbh->prepare($query);
    $sth->execute($server_hostname) or die $sth->errstr;
    my $res = $sth->fetchrow_hashref();
    exit unless defined $res->{'serverid'};
    return $res;
}
sub validate {
    my @required = @_;
    foreach my $required (@required){
        exit unless(defined($var{$required}));
        exit unless($var{$required} =~ m/^[a-z0-9-\.]+$/);
    }
}
sub update_initiator_name {
    my $query = q(
        INSERT INTO driscsi (computeid, initiator_name)
        VALUES (?,?)
        ON DUPLICATE KEY
        UPDATE initiator_name=VALUES(initiator_name);
    );
    my $sth = $dbh->prepare($query);
    $sth->execute($compute->{'serverid'},$var{'initiator_name'});
    print encode_json({'status' => "success"});
    exit;

}
sub ensure_server {
    #userd to add customer boxes to the drserver table
    my $query = q(
        INSERT INTO drserver (nproc,ram,vlan,serverid)
        VALUES (?,?,?,?)
        ON DUPLICATE KEY UPDATE
        `nproc` = ?,
        `ram`   = ?,
        `vlan   = ?,
    );
    my $sth = $dbh->prepare($query);
    $sth->execute();
    print encode_json({'status' => "success"});
    exit;
}
