// Clients list
$view->assign('clients_list', Clients_Model::getClients($dbSql->db_link));
// Count volumes
$view->assign('volumes_nb', Volumes_Model::count($dbSql->db_link));
// ==============================================================
// Last period <Job status graph>
// ==============================================================
$jobs_status = array('Running', 'Completed', 'Waiting', 'Failed', 'Canceled');
$jobs_status_data = array();
foreach ($jobs_status as $status) {
$jobs_count = Jobs_Model::count_Jobs($dbSql->db_link, $custom_period, strtolower($status));
$jobs_status_data[] = array($status, $jobs_count);
}
$graph = new CGraph("dashboard-graph01.jpg");
$graph->SetData($jobs_status_data, 'pie');
$graph->setPieLegendColors(array('gray', 'green', 'blue', 'red', 'orange'));
// Graph rendering
$view->assign('graph_jobs', $graph->Render());
unset($graph);
// ==============================================================
// Volumes per pool widget
// ==============================================================
$vols_by_pool = array();
$graph = new CGraph("dashboard-graph02.jpg");
$max_pools = '9';
$table_pool = 'Pool';
$limit = '';
$sum_vols = '';
// Count defined pools in catalog
$pools_count = Pools_Model::count($dbSql->db_link);
// Display 9 biggest pools and rest of volumes in 10th one display as Other
