added common BackupPC::Search::host_backup_nums
[BackupPC.git] / lib / BackupPC / CGI / Archive.pm
index 8259fe2..18f7ba4 100644 (file)
@@ -39,7 +39,7 @@ package BackupPC::CGI::Archive;
 use strict;
 use BackupPC::CGI::Lib qw(:all);
 use Data::Dumper;
 use strict;
 use BackupPC::CGI::Lib qw(:all);
 use Data::Dumper;
-use DBI;
+use BackupPC::Search;
 
 sub action
 {
 
 sub action
 {
@@ -61,7 +61,6 @@ sub action
             my($fullDur, $incrCnt, $fullSize, $fullRate);
             my @Backups = $bpc->BackupInfoRead($host);
             my $fullCnt = $incrCnt = 0;
             my($fullDur, $incrCnt, $fullSize, $fullRate);
             my @Backups = $bpc->BackupInfoRead($host);
             my $fullCnt = $incrCnt = 0;
-            my $all_backup_numbers;
 
             for ( my $i = 0 ; $i < @Backups ; $i++ ) {
                 if ( $Backups[$i]{type} eq "full" ) {
 
             for ( my $i = 0 ; $i < @Backups ; $i++ ) {
                 if ( $Backups[$i]{type} eq "full" ) {
@@ -71,7 +70,6 @@ sub action
                     $incrSizeTot = $Backups[$i]{size} / (1024 * 1024);
                 }
                 $backupnumber = $Backups[$i]{num};
                     $incrSizeTot = $Backups[$i]{size} / (1024 * 1024);
                 }
                 $backupnumber = $Backups[$i]{num};
-               $all_backup_numbers->{$backupnumber}++;
             }
             $fullSizeTot += $fullSize + $incrSizeTot;
             $fullSize = sprintf("%.2f", ($fullSize + $incrSizeTot) / 1000);
             }
             $fullSizeTot += $fullSize + $incrSizeTot;
             $fullSize = sprintf("%.2f", ($fullSize + $incrSizeTot) / 1000);
@@ -79,40 +77,8 @@ sub action
                $bpc->ConfigRead($archHost);
                %Conf = $bpc->Conf();
 
                $bpc->ConfigRead($archHost);
                %Conf = $bpc->Conf();
 
-use Data::Dump qw(dump);
-
-               my $dbh = DBI->connect($Conf{SearchDSN}, $Conf{SearchUser}, "", { RaiseError => 1, AutoCommit => 0 });
-               my $sth = $dbh->prepare(qq{
-                       select
-                               hosts.name as host, -- FIXME for debug
-                               backups.num as num,
-                               inc_size,
-                               size,
-                               inc_deleted
-                       from backups
-                       join hosts on hosts.id = hostid
-                       where hosts.name = ?
-               });
-               $sth->execute($host);
-               # and inc_size < 0 and size > 0 and not inc_deleted
-               while( my $row = $sth->fetchrow_hashref ) {
-warn "# row ",dump $row;
-                       $all_backup_numbers->{ $row->{num} } =
-                       $row->{inc_deleted}  ? 0 :
-                       $row->{size}    == 0 ? 0 :
-                       $row->{inc_size} > 0 ? 0 :
-                       $row->{size}     > 0 ? 1 :
-                       0;
-               }
-
-warn "# host $host all_backup_numbers = ",dump($all_backup_numbers);
-               my @backup_nums = 
-                       sort { $a <=> $b }
-                       grep { $all_backup_numbers->{$_} }
-                       keys %$all_backup_numbers;
-
                my $checkboxes;
                my $checkboxes;
-               foreach my $backupnumber ( @backup_nums ) {
+               foreach my $backupnumber ( BackupPC::Search::host_backup_nums($host) ) {
                        $checkboxes .= qq|
 <input type="hidden" name="fcb$checkBoxCnt" value="$host">
 <input type="checkbox" name="backup$checkBoxCnt" value="$backupnumber">$backupnumber
                        $checkboxes .= qq|
 <input type="hidden" name="fcb$checkBoxCnt" value="$host">
 <input type="checkbox" name="backup$checkBoxCnt" value="$backupnumber">$backupnumber