#!/usr/bin/perl -Tw

use strict;
use Data::Dumper;
use DBI;
use YAML qw( LoadFile );
my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";

$ENV{ 'PATH' } = '';
$| = 1;

use constant TB => 1099511627776;
use constant GB => 1073741824;

################################################################################
sub ago( $ ) {
	my $s = shift;
	return int($s /60);
}

################################################################################
sub hr_unit( $ ) {
	my $val = 'ERR';
	if ( @_ ) {
		my $n = shift;
		$val = $n / 1024 / 1024 / 1024 / 1024;
	}
	return $val;
}

################################################################################
sub gather ( \$ $ ) {


}
################################################################################
my $rxHost = qr#(backup\d+)\.([\w\.]+)$#;

my $top = 5;
my $volumes = 0;
my @filters;
my $partials = 0;
my $quiet = 0;
my $avail = 1;
my %specific;
if (@ARGV) {
	foreach my $p (@ARGV) {
		$p = lc $p;
		if ( $p =~ m/-+[hH]/ ) {
			$top = 0;
			print "Usage:\nfree_backupspace [-haqpv] {backupbox,.} {filter,.} {n}\n";
			print "\t-h(elp)\n";
			print "\t-a(ll)\n";
			print "\t-q(uiet)\n";
			print "\t-p(artial)\n";
			print "\t-v(olumes)\n";
			print "\t-t(otal) space\n";
		}
		else {
			if ( $p =~ m/^-+/ ) {
				if ( $p =~ m/a/ ) {
					$top = 1000;
				}
				if ( $p =~ m/q/ ) {
					$quiet = 1;
				}
				if ( $p =~ m/v/ ) {
					$volumes = 1;
				}
				if ( $p =~ m/t/ ) {
					$avail = 0;
				}
				if ( $p =~ m/p/ ) {
					$partials = 0;
				}

			}
			else {
				if ($p =~ m/^(backup\d+)(.?)(.*)/ ) {
					$specific{ $1 } = 1;
					push @filters, $3 if ($3);
				}
				elsif ($p =~ m/(\d+)/ ) {
					$top = $p;
				}
				else {
					push @filters, $p;
				}
			}
		}
	}
}
if ( $top ) {
	if ( my $dbh = DBI->connect("DBI:mysql:database=".$config_settings->{backup_db}.";host=localhost",$config_settings->{backup_user}, $config_settings->{backup_pass}))}
		my %h;
		my $now = time;
		my $query = "select `hostname`, `freespace`, (`totalspace` / 10) as reserved, `last-checkin-date` as last  from bstate;";
		my $vquery = "select `hostname`, `volume`, `free`, (`total` / 10 ) as reserved from bstatevolumes where volume like 'volume%';";
		if ( my $r = $dbh->selectall_arrayref( $query, { Slice => {} } ) ) {
			foreach my $rec ( @$r ) {
					if ( $rec->{ 'hostname' } =~ $rxHost ) {
						$rec->{ 'host' } = $1;
						$rec->{ 'brand' } = $2;
						$rec->{'freespace' } = ($avail && $rec->{'freespace' } > $rec->{'reserved' } ) ? $rec->{ 'freespace' } - $rec->{ 'reserved' } : 0;
						if ( $rec->{ 'freespace' } ) {
							if ( %specific ) {
								if ($partials) {
									foreach my $bbox ( keys %specific ) {
										if ($rec->{ 'hostname' }  =~ /\$bbox/ ) {
											push @{ $h{'rec'}{ $rec->{ 'brand' } } }, $rec;
											$h{ 'hosts' }{ $rec->{ 'hostname' } } = 1;
										}
									}
								}
								else {
									if (defined $specific{ $rec->{ 'host' } } ) {
										push @{ $h{'rec'}{ $rec->{ 'brand' } } }, $rec;
										$h{ 'hosts' }{ $rec->{ 'hostname' } } = 1;
									}
								}
							}
							else {
								push @{ $h{'rec'}{ $rec->{ 'brand' } } }, $rec;
								$h{ 'hosts' }{ $rec->{ 'hostname' } } = 1;
							}	
							if ( @filters ) {
								foreach my $filt ( @filters ) {
									if ( $rec->{ 'brand' } =~ /\$filt/ ) {
										push @{ $h{'rec'}{ $rec->{ 'brand' } } }, $rec;
										$h{ 'hosts' }{ $rec->{ 'hostname' } } = 1;
									}
								}
							}
							else {
								push @{ $h{'rec'}{ $rec->{ 'brand' } } }, $rec;
								$h{ 'hosts' }{ $rec->{ 'hostname' } } = 1;
							}
#####
						}
					}
					else {
						warn 'unexpected host ' . Dumper( $rec );
					}
			}
			if ( $volumes ) {
				if ( my $vols = $dbh->selectall_arrayref( $vquery, { Slice => {} } ) ) {
					foreach my $rec ( @$vols ) {
						if ( defined $h{ 'hosts' }{ $rec->{ 'hostname' } } ) {
							if ($avail) {
								$h{ 'vols' }{ $rec->{ 'hostname' } }{ $rec->{ 'volume' } } = $rec->{ 'free' } - $rec->{ 'reserved' };
 							} 
							else {
								$h{ 'vols' }{ $rec->{ 'hostname' } }{ $rec->{ 'volume' } } = $rec->{ 'free' };
							}
						}
					}
				}
			}
			foreach my $brand ( keys %{ $h{ 'rec' } } ) {
				my $c = $top;
					print "\n$brand\n" if (!$quiet);
					foreach my $rec ( sort { $b->{ 'freespace' } <=> $a->{ 'freespace' } } @{ $h{'rec'}{ $brand } } ) {
							last if ( !$c-- );
							printf "  %25s\t%3.2fT\t%5dh\n", $rec->{ 'hostname' }, hr_unit($rec->{ 'freespace' }), ago($now -$rec->{ 'last' });
							if ( defined $h{ 'vols' }{ $rec->{ 'hostname' } } ) {
								foreach my $vol ( sort keys %{ $h{ 'vols' }{ $rec->{ 'hostname' } } } ) {
									printf " %26s\t %3.2fT\n", $vol, hr_unit($h{ 'vols' }{ $rec->{ 'hostname' } }{ $vol });
								}
								print "\n" if (!$quiet);
							}
						
					}
				
			}
			print "\n" if (!$quiet);
			$dbh->disconnect;
  		}
		else {
			warn 'Error: ' . $r->errstr . "\n";
		}
	}
	else {
		warn "couldnt connect to db $!\n";
	}
}

