<?php
/*
** ZABBIX
** Copyright (C) 2000-2005 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');
require_once('include/services.inc.php');

$page['title'] = "S_IT_SERVICES_AVAILABILITY_REPORT";
$page['file'] = 'report3.php';
$page['hist_arg'] = array();

?>
<?php
//		VAR			TYPE	OPTIONAL FLAGS	VALIDATION	EXCEPTION
	$fields=array(
		'serviceid'=>		array(T_ZBX_INT, O_MAND,P_SYS,	DB_ID,						NULL),
		'period'=>		array(T_ZBX_STR, O_OPT,	null,	IN('"dayly","weekly","monthly","yearly"'),	NULL),
		'year'=>		array(T_ZBX_INT, O_OPT,	null,	null,						NULL),
		'format'=>		array(T_ZBX_STR, O_OPT,	null,	IN('"html","csv"'),			NULL)
	);

	check_fields($fields);

	$period = get_request('period',	'weekly');
	$year	= get_request('year',	date('Y'));
	$format = get_request('format', 'html');

	define("YEAR_LEFT_SHIFT", 5);
?>
<?php
	$sql = 'SELECT s.* FROM services s  WHERE s.serviceid='.$_REQUEST['serviceid'];
	if(!$service = DBfetch(DBselect($sql,1))){
		fatal_error(S_NO_IT_SERVICE_DEFINED);
	}

	if(!is_null($service['triggerid'])){
		$options = array(
			'triggerids' => $service['triggerid'],
			'output' => API_OUTPUT_SHORTEN,
			'nodeids' => get_current_nodeid(true)
		);

		$db_data = CTrigger::get($options);
		if(empty($db_data)) access_deny();
	}

	if(!DBfetch(DBselect('SELECT serviceid FROM services WHERE serviceid='.$_REQUEST['serviceid']))){
		fatal_error(S_NO_IT_SERVICE_DEFINED);
	}
?>
<?php
	if ($format == 'html') {
		include_once('include/page_header.php');
		$form = new CForm();
		$form->setMethod('get');
		$form->addVar('serviceid', $_REQUEST['serviceid']);

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

		$cmbYear = new CComboBox('year', $year, 'submit();');

		for($y = (date('Y') - YEAR_LEFT_SHIFT); $y <= date('Y'); $y++){
			$cmbYear->addItem($y, $y);
		}

		$form->addItem(array(SPACE.S_YEAR.SPACE, $cmbYear));

		show_table_header(array(
				S_IT_SERVICES_AVAILABILITY_REPORT_BIG,
				SPACE.'"',
				new CLink($service['name'],'srv_status.php?showgraph=1&serviceid='.$service['serviceid']),
				SPACE.SPACE.SPACE,
				new CLink("CSV",'report3.php?serviceid='.$service['serviceid']."&year=".$year."&period=".$period."&format=csv")
			),
			$form);
	} else if ('csv' == $format) {
		header("Content-type: text/csv");
		header("Content-disposition: attachment;filename=\"sla.csv\"");
		print "\"$service[name]\"\n";
		$csv_delim = ',';
	}
?>
<?php
	if ($format == 'html') {
		$table = new CTableInfo();
	}

	$header = array(S_OK,S_PROBLEMS,S_DOWNTIME,S_PERCENTAGE,S_SLA);

        switch($period){
			case 'yearly':
				$from	= (date('Y') - YEAR_LEFT_SHIFT);
				$to	= date('Y');
				if ($format == 'html') {
					array_unshift($header, new CCol(S_YEAR,'center'));
				} else if ('csv' == $format) {
					print S_YEAR.$csv_delim;
				}
				function get_time($y)	{	return mktime(0,0,0,1,1,$y);		}
				function format_time($t){	return date('Y', $t);			}
				function format_time2($t){	return null; };
				break;
			case 'monthly':
				$from	= 1;
				$to	= 12;
				if ($format == 'html') {
					array_unshift($header, new CCol(S_MONTH,'center'));
				} else if ('csv' == $format) {
					print S_MONTH.$csv_delim;
				}
				function get_time($m)	{	global $year;	return mktime(0,0,0,$m,1,$year);	}
				function format_time($t){	return date('M Y',$t);			}
				function format_time2($t){	return null; };
				break;
			case 'dayly':
				$from	= 1;
				$to	= 365;
				if ($format == 'html') {
					array_unshift($header, new CCol(S_DAY,'center'));
				} else if ('csv' == $format) {
					print S_DAY.$csv_delim;
				}
				function get_time($d)	{	global $year;	return mktime(0,0,0,1,$d,$year);	}
				function format_time($t){	return date('d M Y',$t);		}
				function format_time2($t){	return null; };
				break;
			case 'weekly':
			default:
				$from	= 0;
				$to	= 52;
				if ($format == 'html') {
					array_unshift($header,new CCol(S_FROM,'center'),new CCol(S_TILL,'center'));
				} else if ('csv' == $format) {
					print S_FROM.$csv_delim.S_TILL.$csv_delim;
				}
				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 date('d M Y H:i',$t);	}
				function format_time2($t){	return format_time($t); };
				break;
	}

	if ($format == 'html') {
		$table->SetHeader($header);
	} else if ('csv' == $format) {
		print implode($csv_delim, $header)."$csv_delim\n";
	}

	for($t = $from; $t <= $to; $t++){

		if(($start = get_time($t)) > time())
			break;

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

		$stat = calculate_service_availability($service['serviceid'],$start,$end);

		if ($format == 'html') {
			$ok 		= new CSpan(
						sprintf('%dd %dh %dm',
							$stat['ok_time']/(24*3600),
							($stat['ok_time']%(24*3600))/3600,
							($stat['ok_time']%(3600))/(60)),
						'off');

			$problems	= new CSpan(
						sprintf('%dd %dh %dm',
							$stat['problem_time']/(24*3600),
							($stat['problem_time']%(24*3600))/3600,
							($stat['problem_time']%(3600))/(60)),
						'on');

			$downtime	= sprintf('%dd %dh %dm',
						$stat['downtime_time']/(24*3600),
						($stat['downtime_time']%(24*3600))/3600,
						($stat['downtime_time']%(3600))/(60));

			$percentage	= new CSpan(sprintf('%2.2f%%',$stat['ok']) , 'off');

			$table->addRow(array(
				format_time($start),
				format_time2($end),
				$ok,
				$problems,
				$downtime,
				$percentage,
				($service['showsla']==1) ?
					new CSpan($service['goodsla'], ($stat['ok'] >= $service['goodsla']) ? 'off' : 'on') :
					'-'

				));
		} else if ('csv' == $format) {
			$ok 		= sprintf('%dd %dh %dm',
							$stat['ok_time']/(24*3600),
							($stat['ok_time']%(24*3600))/3600,
							($stat['ok_time']%(3600))/(60));

			$problems	= sprintf('%dd %dh %dm',
							$stat['problem_time']/(24*3600),
							($stat['problem_time']%(24*3600))/3600,
							($stat['problem_time']%(3600))/(60));

			$downtime	= sprintf('%dd %dh %dm',
						$stat['downtime_time']/(24*3600),
						($stat['downtime_time']%(24*3600))/3600,
						($stat['downtime_time']%(3600))/(60));

			$percentage	= sprintf('%2.2f%%',$stat['ok']);

			print	format_time($start).$csv_delim;
			$end_fmt = format_time2($end);
			if (strlen($end_fmt)>0) print  $end_fmt.$csv_delim;
			print $ok.$csv_delim.$problems.$csv_delim.$downtime.$csv_delim.$percentage.$csv_delim;
			if ($service['showsla']) print $service['goodsla'].$csv_delim;
			print "\n";
		}
	}

	if ($format == 'html') {
		$table->Show();
	}
?>
<?php

if ($format == 'html') {
	include_once('include/page_footer.php');
}

?>