- added frontends/php/chart4.php (Alexei)

 - availability report will not show trigger expressions (Alexei)
 - added creation of table 'sessions' to migration scripts for
 1.0beta4 (Alexei)


git-svn-id: svn://svn.zabbix.com/trunk@477 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 213 insertions, 0 deletions

diff --git a/frontends/php/chart4.php b/frontends/php/chart4.php
new file mode 100644
index 00000000..761c26ae
--- /dev/null
+++ b/frontends/php/chart4.php
@@ -0,0 +1,213 @@
+<? 
+	include "include/config.inc.php";
+
+#	PARAMETERS:
+	
+#	itemid
+#	type
+
+	$start_time=time(NULL);
+
+	if(!isset($HTTP_GET_VARS["type"]))
+	{
+		$HTTP_GET_VARS["type"]="week";
+	}
+
+	if($HTTP_GET_VARS["type"] == "month")
+	{
+		$period=30*24*3600;
+	}
+	else if($HTTP_GET_VARS["type"] == "week")
+	{
+		$period=7*24*3600;
+	}
+	else if($HTTP_GET_VARS["type"] == "year")
+	{
+		$period=365*24*3600;
+	}
+	else
+	{
+		$period=7*24*3600;
+		$type="week";
+	}
+
+	$sizeX=900;
+	$sizeY=200;
+
+	$shiftX=12;
+	$shiftYup=13;
+	$shiftYdown=7+15*3;
+
+
+//	Header( "Content-type:  text/html"); 
+	Header( "Content-type:  image/png"); 
+	Header( "Expires:  Mon, 17 Aug 1998 12:51:50 GMT"); 
+
+	$im = imagecreate($sizeX+$shiftX+61,$sizeY+$shiftYup+$shiftYdown+10); 
+  
+	$red=ImageColorAllocate($im,255,0,0); 
+	$darkred=ImageColorAllocate($im,150,0,0); 
+	$green=ImageColorAllocate($im,0,255,0); 
+	$darkgreen=ImageColorAllocate($im,0,150,0); 
+	$blue=ImageColorAllocate($im,0,0,255); 
+	$darkblue=ImageColorAllocate($im,0,0,150); 
+	$yellow=ImageColorAllocate($im,255,255,0); 
+	$darkyellow=ImageColorAllocate($im,150,150,0); 
+	$cyan=ImageColorAllocate($im,0,255,255); 
+	$black=ImageColorAllocate($im,0,0,0); 
+	$gray=ImageColorAllocate($im,150,150,150); 
+	$white=ImageColorAllocate($im,255,255,255); 
+	$bg=ImageColorAllocate($im,6+6*16,7+7*16,8+8*16);
+
+	$x=imagesx($im); 
+	$y=imagesy($im);
+  
+	ImageFilledRectangle($im,0,0,$sizeX+$shiftX+61,$sizeY+$shiftYup+$shiftYdown+10,$white);
+	ImageRectangle($im,0,0,$x-1,$y-1,$black);
+
+	$now = time(NULL);
+	$to_time=$now;
+	$from_time=$to_time-$period;
+	$from_time_now=$to_time-24*3600;
+
+	$count=array();
+	$min=array();
+	$max=array();
+	$avg=array();
+
+	for($i=0;$i<48;$i++)
+	{
+		$max[$i]=$i;
+		$min[$i]=$i;
+		$avg[$i]=$i;
+		$count[$i]=$i;
+	}
+
+	$count_now=array();
+	$true=array();
+	for($i=0;$i<48;$i++)
+	{
+		$true[$i]=47*$i/100;
+		$false[$i]=$i/2;
+		$unknown[$i]=$i/3;
+		$count_now[$i]=1;
+	}
+
+	for($i=0;$i<=$sizeY;$i+=$sizeY/10)
+	{
+		ImageDashedLine($im,$shiftX,$i+$shiftYup,$sizeX+$shiftX,$i+$shiftYup,$gray);
+	}
+
+	for($i=0;$i<=$sizeX;$i+=$sizeX/48)
+	{
+		ImageDashedLine($im,$i+$shiftX,$shiftYup,$i+$shiftX,$sizeY+$shiftYup,$gray);
+		ImageString($im, 1,$i+$shiftX-11, $sizeY+$shiftYup+5, date("H:i",-3*3600+24*3600*$i/900) , $black);
+	}
+
+	unset($maxY);
+	unset($minY);
+
+	$maxY=100;
+	$tmp=max($true);
+	if($tmp>$maxY)
+	{
+		$maxY=$tmp;
+	}
+	$minY=min($avg);
+	$tmp=min($true);
+	if($tmp<$minY)
+	{
+		$minY=$tmp;
+	}
+
+	$maxX=900;
+	$minX=0;
+
+	if(isset($minY)&&($maxY)&&($minX!=$maxX)&&($minY!=$maxY))
+	{
+		$nodata=0;
+		for($i=1;$i<48;$i++)
+		{
+			$x1=(900/48)*$sizeX*($i-$minX)/($maxX-$minX);
+			$y1=$sizeY*($true[$i]-$minY)/($maxY-$minY);
+			$x2=(900/48)*$sizeX*($i-$minX-1)/($maxX-$minX);
+			$y2=$sizeY*($true[$i-1]-$minY)/($maxY-$minY);
+			$y1=$sizeY-$y1;
+			$y2=$sizeY-$y2;
+	
+			ImageLine($im,$x1+$shiftX,$y1+$shiftYup,$x2+$shiftX,$y2+$shiftYup,$darkred);
+
+			$x1=(900/48)*$sizeX*($i-$minX)/($maxX-$minX);
+			$y1=$sizeY*($false[$i]-$minY)/($maxY-$minY);
+			$x2=(900/48)*$sizeX*($i-$minX-1)/($maxX-$minX);
+			$y2=$sizeY*($false[$i-1]-$minY)/($maxY-$minY);
+			$y1=$sizeY-$y1;
+			$y2=$sizeY-$y2;
+
+			ImageLine($im,$x1+$shiftX,$y1+$shiftYup,$x2+$shiftX,$y2+$shiftYup,$darkgreen);
+
+			$x1=(900/48)*$sizeX*($i-$minX)/($maxX-$minX);
+			$y1=$sizeY*($unknown[$i]-$minY)/($maxY-$minY);
+			$x2=(900/48)*$sizeX*($i-$minX-1)/($maxX-$minX);
+			$y2=$sizeY*($unknown[$i-1]-$minY)/($maxY-$minY);
+			$y1=$sizeY-$y1;
+			$y2=$sizeY-$y2;
+
+			ImageLine($im,$x1+$shiftX,$y1+$shiftYup,$x2+$shiftX,$y2+$shiftYup,$darkyellow);
+
+#			ImageStringUp($im, 1, $x1+10, $sizeY+$shiftYup+15, $i , $red);
+		}
+	}
+	else
+	{
+//		ImageLine($im,$shiftX,$shiftYup+$sizeY/2,$sizeX+$shiftX,$shiftYup+$sizeY/2,$green);
+	}
+
+	$i=intval( 900*(($now+3*3600)%(24*3600))/(24*3600));
+	$x1=$sizeX*($i-$minX)/($maxX-$minX);
+	$y1=$sizeY*($avg[$i]-$minY)/($maxY-$minY);
+	$x2=$x1;
+	$y2=0;
+	$y1=$sizeY-$y1;
+	$y2=$sizeY-$y2;
+
+//	ImageDashedLine($im,$x1+$shiftX,$y1+$shiftYup,$x2+$shiftX,$y2+$shiftYup,$black);
+	ImageDashedLine($im,$x1+$shiftX,$shiftYup,$x2+$shiftX,$sizeY+$shiftYup,$black);
+
+	if(isset($nodata)&&($nodata == 0))
+	{
+		for($i=0;$i<=$sizeY;$i+=$sizeY/10)
+		{
+			ImageString($im, 1, $sizeX+5+$shiftX, $sizeY-$i-4+$shiftYup, $i*($maxY-$minY)/$sizeY+$minY , $darkred);
+		}
+
+//		date("dS of F Y h:i:s A",DBget_field($result,0,0));
+
+//		ImageString($im, 1,10,                $sizeY+$shiftY+5, date("dS of F Y h:i:s A",$minX) , $red);
+//		ImageString($im, 1,$sizeX+$shiftX-168,$sizeY+$shiftY+5, date("dS of F Y h:i:s A",$maxX) , $red);
+	}
+	else
+	{
+		ImageString($im, 2,$sizeX/2 -50,                $sizeY+$shiftYup+3, "NO DATA FOR THIS PERIOD" , $red);
+	}
+
+	ImageFilledRectangle($im,$shiftX,$sizeY+$shiftYup+19+15*0,$shiftX+5,$sizeY+$shiftYup+15+9+15*0,$darkgreen);
+	ImageRectangle($im,$shiftX,$sizeY+$shiftYup+19+15*0,$shiftX+5,$sizeY+$shiftYup+15+9+15*0,$black);
+	ImageString($im, 2,$shiftX+9,$sizeY+$shiftYup+15*0+15, "FALSE (%)", $black);
+
+	ImageFilledRectangle($im,$shiftX,$sizeY+$shiftYup+19+15*1,$shiftX+5,$sizeY+$shiftYup+15+9+15*1,$darkred);
+	ImageRectangle($im,$shiftX,$sizeY+$shiftYup+19+15*1,$shiftX+5,$sizeY+$shiftYup+15+9+15*1,$black);
+	ImageString($im, 2,$shiftX+9,$sizeY+$shiftYup+15*1+15, "TRUE (%)", $black);
+
+	ImageFilledRectangle($im,$shiftX,$sizeY+$shiftYup+19+15*2,$shiftX+5,$sizeY+$shiftYup+15+9+15*2,$darkyellow);
+	ImageRectangle($im,$shiftX,$sizeY+$shiftYup+19+15*2,$shiftX+5,$sizeY+$shiftYup+15+9+15*2,$black);
+	ImageString($im, 2,$shiftX+9,$sizeY+$shiftYup+15*2+15, "UNKNOWN (%)", $black);
+
+	ImageStringUp($im,0,imagesx($im)-10,imagesy($im)-50, "http://zabbix.sourceforge.net", $gray);
+
+	$end_time=time(NULL);
+	ImageString($im, 0,imagesx($im)-100,imagesy($im)-12,"Generated in ".($end_time-$start_time)." sec", $gray);
+
+	ImagePng($im); 
+	ImageDestroy($im); 
+?>