zabbix-frontend-php 1:1.8.11-1 / usr / share / zabbix / report4.php

<?php
/*
** ZABBIX
** Copyright (C) 2000-2010 SIA Zabbix
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
**/
?>
<?php
require_once('include/config.inc.php');

$page['title'] = "S_IT_NOTIFICATIONS";
$page['file'] = 'report4.php';
$page['hist_arg'] = array('media_type','period','year');

include_once('include/page_header.php');

?>
<?php
//		VAR			TYPE	OPTIONAL FLAGS	VALIDATION	EXCEPTION
	$fields=array(
		'year'=>		array(T_ZBX_INT, O_OPT,	P_SYS|P_NZERO,	NULL,						NULL),
		'period'=>		array(T_ZBX_STR, O_OPT,	P_SYS|P_NZERO,	IN('"daily","weekly","monthly","yearly"'),	NULL),
		'media_type'=>		array(T_ZBX_INT, O_OPT,	P_SYS,	DB_ID,							NULL)
	);

	check_fields($fields);
?>
<?php
	$year		= get_request('year', 		intval(date('Y')));
	$period		= get_request('period',		'weekly');
	$media_type	= get_request('media_type',	0);
?>
<?php
	$_REQUEST['year']	= $year;
	$_REQUEST['period']	= $period;
	$_REQUEST['media_type']	= $media_type;

	$css = getUserTheme($USER_DETAILS);
	$vTextColor = ($css == 'css_od.css')?'&color=white':'';

	$header = array();
	$db_users = DBselect('select * from users where '.DBin_node('userid').' order by alias,userid');
	while($user_data = DBfetch($db_users)){
		array_push($header, new CImg('vtext.php?text='.urlencode($user_data['alias']).$vTextColor));
		$users[$user_data['userid']] = $user_data['alias'];
	}

	$media_types = array();

	$sql = 'SELECT * '.
			' FROM media_type '.
			' WHERE '.DBin_node('mediatypeid').
			' ORDER BY description';
	$db_media_types = DBselect($sql);
	while($media_type_data = DBfetch($db_media_types)){
		$media_types[$media_type_data['mediatypeid']] = $media_type_data['description'];
	}

	// if no media types were defined, we have nothing to show
	if (zbx_empty($media_types)){
		show_table_header(S_NOTIFICATIONS_BIG);
		$table = new CTableInfo(S_NO_MEDIA_TYPES_DEFINED);
		$table->Show();
	}
	else
	{
		$table = new CTableInfo();

		if( ($min_time = DBfetch(DBselect('select min(clock) as clock from alerts'))) && $min_time['clock'])
		{
			$MIN_YEAR = intval(date('Y', $min_time['clock']));
		}

		if( !isset($MIN_YEAR) ){
			$MIN_YEAR = intval(date('Y'));
		}

		$form = new CForm();
		$form->SetMethod('get');

		$form->addItem(SPACE.S_MEDIA_TYPE.SPACE);
		$cmbMedia = new CComboBox('media_type', $media_type, 'submit();');
		$cmbMedia->addItem(0,S_ALL_SMALL);

		foreach($media_types as $media_type_id => $media_type_description){
			$cmbMedia->addItem($media_type_id, $media_type_description);
			// we won't need other media types in the future, if only one was selected
			if($media_type > 0 && $media_type != $media_type_id){
				unset($media_types[$media_type_id]);
			}
		}

		$form->addItem($cmbMedia);

		$form->addItem(SPACE.S_PERIOD.SPACE);
		$cmbPeriod = new CComboBox('period', $period, 'submit();');
		$cmbPeriod->addItem('daily',	S_DAILY);
		$cmbPeriod->addItem('weekly',	S_WEEKLY);
		$cmbPeriod->addItem('monthly',	S_MONTHLY);
		$cmbPeriod->addItem('yearly',	S_YEARLY);
		$form->addItem($cmbPeriod);

		if($period != 'yearly'){
			$form->addItem(SPACE.S_YEAR.SPACE);
			$cmbYear = new CComboBox('year', $year, 'submit();');
			for($y = $MIN_YEAR; $y <= date('Y'); $y++)
				$cmbYear->addItem($y, $y);
			$form->addItem($cmbYear);
		}

		show_table_header(S_NOTIFICATIONS_BIG, $form);

		switch($period){
			case 'yearly':
				$from	= $MIN_YEAR;
				$to	= date('Y');
				array_unshift($header, new CCol(S_YEAR,'center'));
				function get_time($y)	{	return mktime(0,0,0,1,1,$y);		}
				function format_time($t){	return zbx_date2str(S_REPORT4_ANNUALLY_DATE_FORMAT, $t);}
				function format_time2($t){	return null; }
				break;
			case 'monthly':
				$from	= 1;
				$to	= 12;
				array_unshift($header, new CCol(S_MONTH,'center'));
				function get_time($m)	{	global $year;	return mktime(0,0,0,$m,1,$year);	}
				function format_time($t){	return zbx_date2str(S_REPORT4_MONTHLY_DATE_FORMAT,$t);	}
				function format_time2($t){	return null; }
				break;
			case 'daily':
				$from	= 1;
				$to	= 365;
				array_unshift($header, new CCol(S_DAY,'center'));
				function get_time($d)	{	global $year;	return mktime(0,0,0,1,$d,$year);	}
				function format_time($t){	return zbx_date2str(S_REPORT4_DAILY_DATE_FORMAT,$t);	}
				function format_time2($t){	return null; }
				break;
			case 'weekly':
			default:
				$from	= 0;
				$to	= 52;
				array_unshift($header,new CCol(S_FROM,'center'),new CCol(S_TILL,'center'));
				function get_time($w)	{
					global $year;

					$time	= mktime(0,0,0,1, 1, $year);
					$wd	= date('w', $time);
					$wd	= $wd == 0 ? 6 : $wd - 1;

					return ($time + ($w*7 - $wd)*24*3600);
				}
				function format_time($t){	return zbx_date2str(S_REPORT4_WEEKLY_DATE_FORMAT,$t);	}
				function format_time2($t){	return format_time($t); }
				break;

		}

		$table->setHeader($header,'vertical_header');
		for($t = $from; $t <= $to; $t++){
			if(($start = get_time($t)) > time())
				break;

			if(($end = get_time($t+1)) > time())
				$end = time();

			$table_row = array(format_time($start),format_time2($end));

			//getting all alerts in this period of time
			$options = array(
				'output'=> array('mediatypeid', 'userid'),
				'time_from'=>$start,
				'time_till'=>$end
			);

			//if we must get only specific media type, no need to select the other ones
			if ($media_type > 0){
				$options['mediatypeids'] = $media_type;
			}

			//getting data through API
			$alert_info = CAlert::get($options);

			//counting alert count for each user and media type
			$summary = array();
			foreach($users as $userid => $alias){
				$summary[$userid] = array();
				$summary[$userid]['total'] = 0;
				$summary[$userid]['medias'] = array();
				foreach($media_types as $media_type_nr => $mt){
					$summary[$userid]['medias'][$media_type_nr] = 0;
				}
			}

			foreach($alert_info as $ai){
				if( !isset($summary[$ai['userid']]) ) continue;

				$summary[$ai['userid']]['total']++;
				if (isset($summary[$ai['userid']]['medias'][$ai['mediatypeid']])) {
					$summary[$ai['userid']]['medias'][$ai['mediatypeid']]++;
				}
				else {
					$summary[$ai['userid']]['medias'][$ai['mediatypeid']] = 1;
				}
			}

			foreach($summary as $s){
				array_push($table_row, array($s['total'], ($media_type == 0 ? SPACE.'('.implode('/',$s['medias']).')' : '' )));
			}

			$table->addRow($table_row);
		}
		$table->show();

		if($media_type == 0){
			echo SBR;

			$links = array();
			foreach($media_types as $id => $description){
				$links[] = new CLink($description, 'media_types.php?form=update&mediatypeid=' . $id);
				$links[] = SPACE . '/' . SPACE;
			}
			array_pop($links);

			$linksDiv = new CDiv(array(SPACE . S_ALL_SMALL . SPACE . '(' . SPACE, $links, SPACE.')'));
			$linksDiv->show();
		}
	}

?>
<?php

include_once('include/page_footer.php');

?>