From 71e7c4f845cb4cfb0c81391d0dab71f2d634796d Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Fri, 28 Jan 2011 17:29:42 +0100 Subject: [PATCH] show scheduled and burned columns --- lib/BackupPC/Search.pm | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/lib/BackupPC/Search.pm b/lib/BackupPC/Search.pm index 77a68d3..5e45f35 100644 --- a/lib/BackupPC/Search.pm +++ b/lib/BackupPC/Search.pm @@ -391,7 +391,8 @@ print STDERR "## sort=". ($param->{'sort'} || 'no sort param') . " burn sql orde b.date, date_part('epoch',now()) - b.date as age, p.size, - count(ab.date) as copies + count(ap.*) as scheduled, + count(ab.*) as burned FROM backup_parts p JOIN backups b ON b.id = p.backup_id LEFT OUTER JOIN archive_parts ap ON ap.backup_part_id = p.id @@ -773,7 +774,9 @@ EOF3 sort_header($param, 'Age/days', 'age', 'center') . sort_header($param, 'Size', 'size', 'center') . qq{ - copies + sc + bu + }; my @color = (' bgcolor="#e0e0e0"', ''); @@ -793,7 +796,8 @@ EOF3 ,'', epoch_to_iso( $backup->{'date'} ), '' ,'', $backup->{'age'}, '' ,'', unit($backup->{'size'}), '' - ,'', '*' x $backup->{copies}, '' + ,'', $backup->{scheduled}, '' + ,'', $backup->{burned}, '' ,"\n" ); } -- 2.20.1