5 Bweb - A Bacula web interface
6 Bacula® - The Network Backup Solution
8 Copyright (C) 2000-2006 Free Software Foundation Europe e.V.
10 The main author of Bweb is Eric Bollengier.
11 The main author of Bacula is Kern Sibbald, with contributions from
12 many others, a complete list can be found in the file AUTHORS.
14 This program is Free Software; you can redistribute it and/or
15 modify it under the terms of version two of the GNU General Public
16 License as published by the Free Software Foundation plus additions
17 that are listed in the file LICENSE.
19 This program is distributed in the hope that it will be useful, but
20 WITHOUT ANY WARRANTY; without even the implied warranty of
21 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
22 General Public License for more details.
24 You should have received a copy of the GNU General Public License
25 along with this program; if not, write to the Free Software
26 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
29 Bacula® is a registered trademark of John Walker.
30 The licensor of Bacula is the Free Software Foundation Europe
31 (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zurich,
32 Switzerland, email:ftf@fsfeurope.org.
41 # Si c'est un fichier selectionne, afficher ses attributs
42 # ajouter le base_fic et base_url dans les options bweb
46 use POSIX qw/strftime/;
49 use Digest::MD5 qw(md5_hex);
50 use File::Basename qw/basename dirname/;
52 my $conf = new Bweb::Config(config_file => '/etc/bweb/config');
54 my $bweb = new Bweb(info => $conf);
57 my $arg = $bweb->get_form('where', 'jobid');
58 my $where = $arg->{where};
59 my $jobid = $arg->{jobid};
60 my $jobid_url = "jobid=$jobid";
63 my $batch = CGI::param("mode") || '';
65 my $md5_rep = md5_hex("$where:$jobid") ;
66 my $base_url = '/bweb/fv' ;
67 my $base_fich = $conf->{fv_write_path};
69 if ($where and $jobid and $batch eq 'batch') {
70 my $root = fv_get_root_pathid($where);
72 fv_compute_size($jobid, $root);
78 print CGI::header('text/html');
79 $bweb->display_begin();
80 $bweb->display_job_zoom($jobid);
82 unless ($where and $jobid) {
83 $bweb->error("Can't get where or jobid");
87 unless (-w $base_fich) {
88 $bweb->error("$base_fich is not writable");
92 if (-f "$base_fich/$md5_rep.png" and -f "$base_fich/$md5_rep.tpl")
94 $bweb->display({}, "$base_fich/$md5_rep.tpl");
99 my $attribs = fv_get_file_attribute($jobid, $where);
100 if ($attribs->{found}) {
101 $bweb->display($attribs, 'fv_file_attribs.tpl');
102 $bweb->display_end();
106 if ($where !~ m!/$!) {
107 $where = $where . "/" ;
110 my $root = fv_get_root_pathid($where);
112 $bweb->error("Can't find $where in catalog");
113 $bweb->display_end();
117 my $total = fv_compute_size($jobid, $root);
119 my $url_action = "bfileview.pl?opt_level=$opt_level" ;
120 my $top = new CCircle(
122 base_url => "$url_action;$jobid_url;where=$where",
125 fv_display_rep($top, $total, $root, $opt_level) ;
127 $top->draw_labels() ;
128 $top->set_title(Bweb::human_size($total)) ;
130 open(OUT, ">$base_fich/$md5_rep.png") or die "$base_fich/$md5_rep.png $!";
131 # make sure we are writing to a binary stream
133 # Convert the image to PNG and print it on standard output
134 print OUT $CCircle::gd->png;
137 open(OUT, ">$base_fich/$md5_rep.tpl") or die "$base_fich/$md5_rep.tpl $!";
139 <form action='$url_action' method='get'>
141 <input title='jobids' type='hidden' name='jobid' value='$jobid'>
142 <input title='repertoire' type='text' name='where' value='$where'/>
143 <input type='submit' size='256' name='go' value='go'/>
149 print OUT $top->get_imagemap($where, "$base_url/$md5_rep.png") ;
152 $bweb->display({}, "$base_fich/$md5_rep.tpl");
153 $bweb->display_end();
157 my ($ccircle, $max, $rep, $level) = @_ ;
158 return if ($max < 1);
161 my $dirs = fv_list_dirs($jobid, $rep); # 0: pathid, 1: pathname
163 foreach my $dir (@{$dirs})
165 my $size = fv_compute_size($jobid, $dir->[0]);
168 my $chld = $ccircle->add_part($size * 100 / $max,
169 basename($dir->[1]) . '/',
172 . Bweb::human_size($size)
175 if ($chld and $level > 0) {
176 fv_display_rep($chld, $size, $dir->[0], $level - 1) ;
181 my $files = fv_get_big_files($jobid, $rep, 3*100/$max, $max_file/($level+1));
182 foreach my $f (@{$files}) {
183 $ccircle->add_part($f->[1] * 100 / $max,
185 $f->[0] . "\n" . Bweb::human_size($f->[1]));
190 $ccircle->add_part(($max - $sum) * 100 / $max,
192 "other\n" . Bweb::human_size($max - $sum));
195 $ccircle->finalize() ;
200 my ($jobid, $rep) = @_;
202 my $size = fv_get_size($jobid, $rep);
207 $size = fv_get_files_size($jobid, $rep);
209 my $dirs = fv_list_dirs($jobid, $rep);
210 foreach my $dir (@{$dirs}) {
211 $size += fv_compute_size($jobid, $dir->[0]);
214 fv_update_size($jobid, $rep, $size);
220 my ($jobid, $rep) = @_;
222 my $ret = $bweb->dbh_selectall_arrayref("
225 SELECT Path FROM Path WHERE PathId = P.PathId
227 SELECT Path FROM brestore_missing_path WHERE PathId = P.PathId
231 FROM brestore_pathvisibility
232 INNER JOIN brestore_pathhierarchy USING (PathId)
241 sub fv_get_file_attribute
243 my ($jobid, $full_name) = @_;
245 my $filename = $bweb->dbh_quote(basename($full_name));
246 my $path = $bweb->dbh_quote(dirname($full_name) . "/");
248 my $attr = $bweb->dbh_selectrow_hashref("
251 base64_decode_lstat(8, LStat) AS size,
252 base64_decode_lstat(11, LStat) AS atime,
253 base64_decode_lstat(12, LStat) AS mtime,
254 base64_decode_lstat(13, LStat) AS ctime
256 FROM File INNER JOIN Filename USING (FilenameId)
257 INNER JOIN Path USING (PathId)
258 WHERE Name = $filename
263 $attr->{filename} = $full_name;
264 $attr->{size} = Bweb::human_size($attr->{size});
265 foreach my $d (qw/atime ctime mtime/) {
266 $attr->{$d} = strftime('%F %H:%M', localtime($attr->{$d}));
273 my ($jobid, $rep) = @_;
275 my $ret = $bweb->dbh_selectrow_hashref("
277 FROM brestore_pathvisibility
285 sub fv_get_files_size
287 my ($jobid, $rep) = @_;
289 my $ret = $bweb->dbh_selectrow_hashref("
290 SELECT sum(base64_decode_lstat(8,LStat)) AS size
301 my ($jobid, $rep, $min, $limit) = @_;
303 my $ret = $bweb->dbh_selectall_arrayref("
306 SELECT FilenameId,base64_decode_lstat(8,LStat) AS size
310 ) AS S INNER JOIN Filename USING (FilenameId)
321 my ($jobid, $rep, $size) = @_;
323 my $nb = $bweb->dbh_do("
324 UPDATE brestore_pathvisibility SET Size = $size
332 sub fv_get_root_pathid
335 $path = $bweb->dbh_quote($path);
336 my $ret = $bweb->dbh_selectrow_hashref("
337 SELECT PathId FROM Path WHERE Path = $path
339 SELECT PathId FROM brestore_missing_path WHERE PATH = $path
341 return $ret->{pathid};
346 CREATE OR REPLACE FUNCTION base64_decode_lstat(int4, varchar) RETURNS int8 AS $$
353 size := split_part($2, ' ', $1);
354 b64 := 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
356 FOR i IN 1..length(size) LOOP
357 val := val + (strpos(b64, substr(size, i, 1))-1) * (64^(length(size)-i));
361 $$ language 'plpgsql';
363 ALTER TABLE brestore_pathvisibility ADD Size int8;