3 +-------------------------------------------------------------------------+
4 | Copyright (C) 2004 Juan Luis Francés Jiménez |
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. |
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 +-------------------------------------------------------------------------+
18 require ("paths.php");
19 require($smarty_path."Smarty.class.php");
20 include "bweb.inc.php";
22 $smarty = new Smarty();
29 $smarty->compile_check = true;
30 $smarty->debugging = false;
31 $smarty->force_compile = true;
33 $smarty->template_dir = "./templates";
34 $smarty->compile_dir = "./templates_c";
35 $smarty->config_dir = "./configs";
38 $smarty->config_load("bacula.conf"); // Load config file
39 $mode = $smarty->get_config_vars("mode");
42 // Getting mode from config file
43 $mode = $dbSql->get_config_param("mode");
47 $smarty->assign( "mode", $mode );
49 // Determine which template to show
50 $indexreport = $dbSql->get_config_param( "IndexReport" );
52 if( $indexreport == 0 ) {
53 $smarty->assign( "last_report", "last_run_report.tpl" );
55 $smarty->assign( "last_report", "report_select.tpl" );
58 // Assign to template catalogs number
59 $smarty->assign( "dbs", $dbSql->Get_Nb_Catalogs() );
63 if ( count($dbSql->dbs) >1 ) {
64 $smarty->assign("dbs", $dbSql->dbs);
65 $smarty->assign("dbs_now", $_SESSION['DATABASE']);
69 // generaldata.tpl & last_run_report.tpl ( Last 24 hours report )
73 // Stored files number
74 $totalfiles = $dbSql->GetStoredFiles( ALL );
75 $smarty->assign('stored_files',$totalfiles);
78 $smarty->assign('database_size', $dbSql->GetDbSize());
80 // Overall stored bytes
81 $result = $dbSql->GetStoredBytes( ALL );
82 $smarty->assign('stored_bytes', $dbSql->human_file_size($result['stored_bytes']) );
84 // Total stored bytes since last 24 hours
85 $result = $dbSql->GetStoredBytes( LAST_DAY );
86 $smarty->assign('bytes_last', $dbSql->human_file_size($result['stored_bytes']) );
88 // Total stored files since last 24 hours
89 $files_last = $dbSql->GetStoredFiles( LAST_DAY );
90 $smarty->assign('files_last', $files_last );
94 $nb_clients = $dbSql->Get_Nb_Clients();
95 $smarty->assign('clientes_totales',$nb_clients["nb_client"] );
97 // Backup Job list for report.tpl and last_run_report.tpl
98 $smarty->assign( 'total_name_jobs', $dbSql->Get_BackupJob_Names() );
100 // Get volumes list (volumes.tpl)
101 $smarty->assign('pools', $dbSql->GetVolumeList() );
103 // Last 24 hours completed jobs number
104 $smarty->assign( 'completed_jobs', $dbSql->CountJobs( LAST_DAY, 'completed' ) );
106 // Last 24 hours failed jobs number
107 $smarty->assign( 'failed_jobs', $dbSql->CountJobs( LAST_DAY, 'failed' ) );
109 // Last 24 hours waiting jobs number
110 $smarty->assign( 'waiting_jobs', $dbSql->CountJobs( LAST_DAY, 'waiting' ) );
112 // Last 24 hours elapsed time (last_run_report.tpl)
113 //$smarty->assign( 'elapsed_jobs', $dbSql->Get_ElapsedTime_Job() );
115 // Last 24 hours Job status graph
117 $status = array( 'completed', 'terminated_errors', 'failed', 'waiting', 'created', 'running', 'error' );
119 foreach( $status as $job_status ) {
120 array_push( $data, $dbSql->GetJobsStatistics( $job_status ) );
123 $graph = new BGraph( "graph.png" );
124 $graph->SetData( $data, 'pie', 'text-data-single' );
125 $graph->SetGraphSize( 400, 230 );
128 $smarty->assign('graph_jobs', $graph->Get_Image_file() );
131 // Pool and volumes graph
133 $graph = new BGraph( "graph1.png" );
135 $pools = $dbSql->Get_Pools_List();
137 foreach( $pools as $pool ) {
138 array_push( $data, $dbSql->GetPoolsStatistics( $pool ) );
141 $graph->SetData( $data, 'pie', 'text-data-single' );
142 $graph->SetGraphSize( 400, 230 );
145 $smarty->assign('graph_pools', $graph->Get_Image_file() );
147 // Last 7 days stored Bytes graph
149 $graph = new BGraph( "graph2.png" );
152 // Get the last 7 days interval (start and end)
153 for( $c = 6 ; $c >= 0 ; $c-- ) {
154 $today = ( mktime() - ($c * LAST_DAY) );
155 array_push( $days, array( 'start' => date( "Y-m-d 00:00:00", $today ), 'end' => date( "Y-m-d 23:59:00", $today ) ) );
158 $days_stored_bytes = array();
160 foreach( $days as $day ) {
161 array_push( $days_stored_bytes, $dbSql->GetStoredBytesByInterval( $day['start'], $day['end'] ) );
164 $graph->SetData( $days_stored_bytes, 'bars', 'text-data' );
165 $graph->SetGraphSize( 400, 230 );
168 $smarty->assign('graph_stored_bytes', $graph->Get_Image_file() );
170 // Last 15 used volumes
173 $query = "SELECT DISTINCT Media.Volumename, Media.Lastwritten, Media.VolStatus, Job.JobId FROM Job ";
174 $query .= "LEFT JOIN JobMedia ON Job.JobId = JobMedia.JobId ";
175 $query .= "LEFT JOIN Media ON JobMedia.MediaId = Media.MediaId ";
176 $query .= "ORDER BY Job.JobId DESC ";
177 $query .= "LIMIT 10 ";
179 $result = $dbSql->db_link->query( $query );
181 if ( PEAR::isError( $result ) )
182 die( "Unable to get last used volumes from catalog \n " . $result->getMessage() );
184 while ( $vol = $result->fetchRow( DB_FETCHMODE_ASSOC ) )
185 array_push( $vol_list, $vol );
187 $smarty->assign( 'volume_list', $vol_list );
189 //if ($_GET['Full_popup'] == "yes" || $_GET['pop_graph1'] == "yes" || $_GET['pop_graph2'] == "yes")
190 // $smarty->display('full_popup.tpl');
194 $smarty->display('index.tpl');