]> git.sur5r.net Git - bacula/bacula/blob - gui/bacula-web/index.php
bacula-web: Add last used volumes to main dashboard
[bacula/bacula] / gui / bacula-web / index.php
1 <?php
2 /* 
3 +-------------------------------------------------------------------------+
4 | Copyright (C) 2004 Juan Luis Francés Jiménez                            |
5 |                                                                         |
6 | This program is free software; you can redistribute it and/or           |
7 | modify it under the terms of the GNU General Public License             |
8 | as published by the Free Software Foundation; either version 2          |
9 | of the License, or (at your option) any later version.                  |
10 |                                                                         |
11 | This program is distributed in the hope that it will be useful,         |
12 | but WITHOUT ANY WARRANTY; without even the implied warranty of          |
13 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
14 | GNU General Public License for more details.                            |
15 +-------------------------------------------------------------------------+ 
16 */
17 session_start();
18 require ("paths.php");
19 require($smarty_path."Smarty.class.php");
20 include "bweb.inc.php";
21
22 $smarty = new Smarty();     
23 $dbSql = new Bweb();
24
25 require("lang.php");
26
27 $mode = "";                             
28
29 $smarty->compile_check = true;
30 $smarty->debugging = false;
31 $smarty->force_compile = true;
32
33 $smarty->template_dir = "./templates";
34 $smarty->compile_dir = "./templates_c";
35 $smarty->config_dir     = "./configs";
36
37 /*
38 $smarty->config_load("bacula.conf");                                                                                    // Load config file
39 $mode = $smarty->get_config_vars("mode");     
40 */                                                                          // Lite o Extend?
41
42 // Getting mode from config file
43 $mode = $dbSql->get_config_param("mode");
44 if( $mode == false )
45         $mode = "Lite";
46
47 $smarty->assign( "mode", $mode );
48
49 // Determine which template to show
50 $indexreport = $dbSql->get_config_param( "IndexReport" );
51
52 if( $indexreport == 0 ) {
53         $smarty->assign( "last_report", "last_run_report.tpl" );
54 }else {
55         $smarty->assign( "last_report", "report_select.tpl" );
56 }
57
58 // Assign to template catalogs number
59 $smarty->assign( "dbs", $dbSql->Get_Nb_Catalogs() );
60
61 //Assign dbs
62 /*
63 if ( count($dbSql->dbs) >1 ) {
64   $smarty->assign("dbs", $dbSql->dbs);
65   $smarty->assign("dbs_now", $_SESSION['DATABASE']);
66 }
67 */
68
69 // generaldata.tpl & last_run_report.tpl ( Last 24 hours report )
70 $last24bytes = "";
71 $query = "";
72
73 // Stored files number 
74 $totalfiles = $dbSql->GetStoredFiles();
75 $smarty->assign('files_totales',$totalfiles);
76   
77 // Database size
78 $smarty->assign('database_size', $dbSql->GetDbSize());
79
80 // Overall stored bytes
81 $result = $dbSql->GetStoredBytes( ALL );
82 $smarty->assign('stored_bytes', $dbSql->human_file_size($result['stored_bytes']) );
83
84 // Total stored bytes since last 24 hours
85 $result = $dbSql->GetStoredBytes( LAST_DAY );
86 $smarty->assign('bytes_totales', $dbSql->human_file_size($result['stored_bytes']) );
87
88 // Number of clients
89 $nb_clients = $dbSql->Get_Nb_Clients();
90 $smarty->assign('clientes_totales',$nb_clients["nb_client"] );
91
92 // Backup Job list for report.tpl and last_run_report.tpl
93 $smarty->assign( 'total_name_jobs', $dbSql->Get_BackupJob_Names() );
94
95 // Get volumes list (volumes.tpl)
96 $smarty->assign('pools', $dbSql->GetVolumeList() );
97
98 // Last 24 hours completed jobs number
99 $smarty->assign( 'completed_jobs', $dbSql->CountJobs( LAST_DAY, 'completed' ) );
100
101 // Last 24 hours failed jobs number
102 $smarty->assign( 'failed_jobs', $dbSql->CountJobs( LAST_DAY, 'failed' ) );
103
104 // Last 24 hours waiting jobs number
105 $smarty->assign( 'waiting_jobs', $dbSql->CountJobs( LAST_DAY, 'waiting' ) );
106
107 // Last 24 hours elapsed time (last_run_report.tpl)
108 //$smarty->assign( 'elapsed_jobs', $dbSql->Get_ElapsedTime_Job() );
109
110 // Last 24 hours Job status graph
111 $data   = array();  
112 $status = array( 'completed', 'terminated_errors', 'failed', 'waiting', 'created', 'running', 'error' );
113
114 foreach( $status as $job_status ) {
115         array_push( $data, $dbSql->GetJobsStatistics( $job_status ) );
116 }
117
118 $graph = new BGraph( "graph.png" );
119 $graph->SetData( $data, 'pie', 'text-data-single' );
120 $graph->SetGraphSize( 400, 230 );
121
122 $graph->Render();
123 $smarty->assign('graph_jobs', $graph->Get_Image_file() );
124 unset($graph);
125
126 // Pool and volumes graph
127 $data = array();
128 $graph = new BGraph( "graph1.png" );
129
130 $pools = $dbSql->Get_Pools_List();
131
132 foreach( $pools as $pool ) {
133         array_push( $data, $dbSql->GetPoolsStatistics( $pool ) );
134 }
135
136 $graph->SetData( $data, 'pie', 'text-data-single' );
137 $graph->SetGraphSize( 400, 230 );
138
139 $graph->Render();
140 $smarty->assign('graph_pools', $graph->Get_Image_file() );
141
142 // Last 7 days stored Bytes graph
143 $data  = array();
144 $graph = new BGraph( "graph2.png" );
145 $days  = array();
146
147 // Get the last 7 days interval (start and end)
148 for( $c = 6 ; $c >= 0 ; $c-- ) {
149         $today = ( mktime() - ($c * LAST_DAY) );
150         array_push( $days, array( 'start' => date( "Y-m-d 00:00:00", $today ), 'end' => date( "Y-m-d 23:59:00", $today ) ) );
151 }
152
153 $days_stored_bytes = array();
154
155 foreach( $days as $day ) {
156   array_push( $days_stored_bytes, $dbSql->GetStoredBytesByInterval( $day['start'], $day['end'] ) );
157 }
158
159 $graph->SetData( $days_stored_bytes, 'bars', 'text-data' );
160 $graph->SetGraphSize( 400, 230 );
161
162 $graph->Render();
163 $smarty->assign('graph_stored_bytes', $graph->Get_Image_file() );
164
165 // Last 15 used volumes
166 $vol_list = array();
167
168 $query  = "SELECT DISTINCT Media.Volumename, Media.VolStatus, Job.JobId FROM Job ";
169 $query .= "LEFT JOIN JobMedia ON Job.JobId = JobMedia.JobId ";
170 $query .= "LEFT JOIN Media ON JobMedia.MediaId = Media.MediaId ";
171 $query .= "ORDER BY Job.JobId DESC ";
172 $query .= "LIMIT 15 ";
173
174 $result = $dbSql->db_link->query( $query );
175
176 if ( PEAR::isError( $result ) )
177         die( "Unable to get last used volumes from catalog \n " . $result->getMessage() );
178 else {
179         while ( $vol = $result->fetchRow( DB_FETCHMODE_ASSOC ) ) 
180                 array_push( $vol_list, $vol );
181 }
182 $smarty->assign( 'volume_list', $vol_list );    
183
184 //if ($_GET['Full_popup'] == "yes" || $_GET['pop_graph1'] == "yes" || $_GET['pop_graph2'] == "yes")
185 //        $smarty->display('full_popup.tpl');
186 //else
187
188 // Render template
189 $smarty->display('index.tpl');
190 ?>