- added frontends/php/include/services.inc.php (Alexei)

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

2 files changed, 353 insertions, 380 deletions

diff --git a/frontends/php/include/config.inc.php b/frontends/php/include/config.inc.php
index 4254574a..53394957 100644
--- a/frontends/php/include/config.inc.php
+++ b/frontends/php/include/config.inc.php
@@ -35,6 +35,8 @@
 	include_once 	"include/items.inc.php";
 	include_once 	"include/screens.inc.php";
 	include_once 	"include/triggers.inc.php";
+	include_once 	"include/actions.inc.php";
+	include_once 	"include/services.inc.php";
 
 	function getmicrotime()
 	{
@@ -554,33 +556,6 @@
 		return $desc;
 	}
 
-	function	get_service_status_description($status)
-	{
-		$desc="<font color=\"#00AA00\">OK</a>";
-		if($status==5)
-		{
-			$desc="<font color=\"#FF0000\">Disaster</a>";
-		}
-		elseif($status==4)
-		{
-			$desc="<font color=\"#FF8888\">Serious&nbsp;problem</a>";
-		}
-		elseif($status==3)
-		{
-			$desc="<font color=\"#AA0000\">Average&nbsp;problem</a>";
-		}
-		elseif($status==2)
-		{
-			$desc="<font color=\"#AA5555\">Minor&nbsp;problem</a>";
-		}
-		elseif($status==1)
-		{
-			$desc="<font color=\"#00AA00\">OK</a>";
-		}
-		return $desc;
-	}
-
-
 //	The hash has form <md5sum of triggerid>,<sum of priorities>
 	function	calc_trigger_hash()
 	{
@@ -749,32 +724,6 @@
 		return	$host;
 	}
 
-	function	get_num_of_service_childs($serviceid)
-	{
-		global	$ERROR_MSG;
-
-		$sql="select count(*) from services_links where serviceupid=$serviceid";
-		$result=DBselect($sql);
-		return	DBget_field($result,0,0);
-	}
-
-	function	get_service_by_serviceid($serviceid)
-	{
-		global	$ERROR_MSG;
-
-		$sql="select * from services where serviceid=$serviceid";
-		$result=DBselect($sql);
-		if(Dbnum_rows($result) == 1)
-		{
-			return	DBfetch($result);
-		}
-		else
-		{
-			$ERROR_MSG="No service with serviceid=[$serviceid]";
-		}
-		return	FALSE;
-	}
-
 	function	show_messages($bool,$msg,$errmsg)
 	{
 		global	$ERROR_MSG;
@@ -1525,211 +1474,6 @@ echo "</head>";
 		}
 	}
 
-	# Add Action
-
-	function	add_action( $triggerid, $userid, $good, $delay, $subject, $message, $scope, $severity, $recipient, $usrgrpid)
-	{
-		global	$ERROR_MSG;
-
-		if(!check_right_on_trigger("A",$triggerid))
-		{
-                        $ERROR_MSG="Insufficient permissions";
-                        return 0;
-		}
-
-		if($recipient == RECIPIENT_TYPE_USER)
-		{
-			$id = $userid;
-		}
-		else
-		{
-			$id = $usrgrpid;
-		}
-
-		if($scope==2)
-		{
-			$sql="insert into actions (triggerid,userid,good,delay,nextcheck,subject,message,scope,severity,recipient) values (0,$id,$good,$delay,0,'*Automatically generated*','*Automatically generated*',$scope,$severity,$recipient)";
-			return	DBexecute($sql);
-		}
-		elseif($scope==1)
-		{
-			$sql="select h.hostid from triggers t,hosts h,functions f,items i where f.triggerid=t.triggerid and h.hostid=i.hostid and i.itemid=f.itemid and t.triggerid=$triggerid";
-//			echo "$sql<br>";
-			$result=DBselect($sql);
-			while($row=DBfetch($result))
-			{
-				$sql="insert into actions (triggerid,userid,good,delay,nextcheck,subject,message,scope,severity,recipient) values (".$row["hostid"].",$id,$good,$delay,0,'*Automatically generated*','*Automatically generated*',$scope,$severity,$recipient)";
-//				echo "$sql<br>";
-				DBexecute($sql);
-			}
-			return TRUE;
-		}
-		else
-		{
-			$sql="insert into actions (triggerid,userid,good,delay,nextcheck,subject,message,scope,severity,recipient) values ($triggerid,$id,$good,$delay,0,'$subject','$message',$scope,$severity,$recipient)";
-			return	DBexecute($sql);
-		}
-	}
-
-	# Return TRUE if triggerid is a reason why the service is not OK
-	# Warning: recursive function
-	function	does_service_depend_on_the_service($serviceid,$serviceid2)
-	{
-#		echo "Serviceid:$serviceid Triggerid:$serviceid2<br>";
-		$service=get_service_by_serviceid($serviceid);
-#		echo "Service status:".$service["status"]."<br>";
-		if($service["status"]==0)
-		{
-			return	FALSE;
-		}
-		if($serviceid==$serviceid2)
-		{
-			if($service["status"]>0)
-			{
-				return TRUE;
-			}
-			
-		}
-
-		$sql="select serviceupid from services_links where servicedownid=$serviceid2 and soft=0";
-#		echo $sql."<br>";
-		$result=DBselect($sql);
-		while($row=DBfetch($result))
-		{
-			if(does_service_depend_on_the_service($serviceid,$row["serviceupid"]) == TRUE)
-			{
-				return	TRUE;
-			}
-		}
-		return	FALSE;
-	}
-
-	function	service_has_parent($serviceid)
-	{
-		$sql="select count(*) from services_links where servicedownid=$serviceid";
-		$result=DBselect($sql);
-		if(DBget_field($result,0,0)>0)
-		{
-			return	TRUE;
-		}
-		return	FALSE;
-	}
-
-	function	service_has_no_this_parent($parentid,$serviceid)
-	{
-		$sql="select count(*) from services_links where serviceupid=$parentid and servicedownid=$serviceid";
-		$result=DBselect($sql);
-		if(DBget_field($result,0,0)>0)
-		{
-			return	FALSE;
-		}
-		return	TRUE;
-	}
-
-
-	function	delete_service_link($linkid)
-	{
-		$sql="delete from services_links where linkid=$linkid";
-		return DBexecute($sql);
-	}
-
-	function	delete_service($serviceid)
-	{
-		$sql="delete from services_links where servicedownid=$serviceid or serviceupid=$serviceid";
-		$result=DBexecute($sql);
-		if(!$result)
-		{
-			return	$result;
-		}
-		$sql="delete from services where serviceid=$serviceid";
-		return DBexecute($sql);
-	}
-
-	function	update_service($serviceid,$name,$triggerid,$linktrigger,$algorithm,$showsla,$goodsla,$sortorder)
-	{
-		if( isset($linktrigger)&&($linktrigger=="on") )
-		{
-			// No mistake here
-			$triggerid=$triggerid;
-		}
-		else
-		{
-			$triggerid='NULL';
-		}
-		if( isset($showsla)&&($showsla=="on") )
-		{
-			$showsla=1;
-		}
-		else
-		{
-			$showsla=0;
-		}
-		$sql="update services set name='$name',triggerid=$triggerid,status=0,algorithm=$algorithm,showsla=$showsla,goodsla=$goodsla,sortorder=$sortorder where serviceid=$serviceid";
-		return	DBexecute($sql);
-	}
-
-	function	add_service($serviceid,$name,$triggerid,$linktrigger,$algorithm,$showsla,$goodsla,$sortorder)
-	{
-		if( isset($showsla)&&($showsla=="on") )
-		{
-			$showsla=1;
-		}
-		else
-		{
-			$showsla=0;
-		}
-		if( isset($linktrigger)&&($linktrigger=="on") )
-		{
-//			$trigger=get_trigger_by_triggerid($triggerid);
-//			$description=$trigger["description"];
-//			if( strstr($description,"%s"))
-//			{
-				$description=expand_trigger_description($triggerid);
-//			}
-			$description=addslashes($description);
-			$sql="insert into services (name,triggerid,status,algorithm,showsla,goodsla,sortorder) values ('$description',$triggerid,0,$algorithm,$showsla,$goodsla,$sortorder)";
-		}
-		else
-		{
-			$sql="insert into services (name,status,algorithm,showsla,goodsla,sortorder) values ('$name',0,$algorithm,$showsla,$goodsla,$sortorder)";
-		}
-		$result=DBexecute($sql);
-		if(!$result)
-		{
-			return FALSE;
-		}
-		$id=DBinsert_id($result,"services","serviceid");
-		if(isset($serviceid))
-		{
-			add_service_link($id,$serviceid,0);
-		}
-		return $id;
-	}
-
-	function	add_host_to_services($hostid,$serviceid)
-	{
-		$sql="select distinct t.triggerid,t.description from triggers t,hosts h,items i,functions f where h.hostid=$hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid";
-		$result=DBselect($sql);
-		while($row=DBfetch($result))
-		{
-			$serviceid2=add_service($serviceid,$row["description"],$row["triggerid"],"on",0,"off",99,0);
-//			add_service_link($serviceid2,$serviceid,0);
-		}
-		return	1;
-	}
-
-	function	is_service_hardlinked($serviceid)
-	{
-		$sql="select count(*) from services_links where servicedownid=$serviceid and soft=0";
-		$result=DBselect($sql);
-		if(DBget_field($result,0,0)>0)
-		{
-			return	TRUE;
-		}
-		return	FALSE;
-		
-	}
-
 	function	add_image($name,$imagetype,$files)
 	{
 		global	$ERROR_MSG;
@@ -1762,26 +1506,6 @@ echo "</head>";
 		return	DBexecute($sql);
 	}
 
-	function	add_service_link($servicedownid,$serviceupid,$softlink)
-	{
-		global	$ERROR_MSG;
-
-		if( ($softlink==0) && (is_service_hardlinked($servicedownid)==TRUE) )
-		{
-			return	FALSE;
-		}
-
-		if($servicedownid==$serviceupid)
-		{
-			$ERROR_MSG="Cannot link service to itself.";
-			return	FALSE;
-		}
-
-		$sql="insert into services_links (servicedownid,serviceupid,soft) values ($servicedownid,$serviceupid,$softlink)";
-		return	DBexecute($sql);
-	}
-
-
 	# Delete System Map
 
 	function	delete_sysmap( $sysmapid )
@@ -3264,108 +2988,6 @@ echo "</head>";
 		return $stat;
 	}
 
-	function	get_last_service_value($serviceid,$clock)
-	{
-	       	$sql="select count(*),max(clock) from service_alarms where serviceid=$serviceid and clock<=$clock";
-//		echo " $sql<br>";
-		
-	        $result=DBselect($sql);
-		if(DBget_field($result,0,0)>0)
-		{
-	       		$sql="select value from service_alarms where serviceid=$serviceid and clock=".DBget_field($result,0,1);
-		        $result2=DBselect($sql);
-// Assuring that we get very latest service value. There could be several with the same timestamp
-//			$value=DBget_field($result2,0,0);
-			for($i=0;$i<DBnum_rows($result2);$i++)
-			{
-				$value=DBget_field($result2,$i,0);
-			}
-		}
-		else
-		{
-			$value=0;
-		}
-		return $value;
-	}
-
-	function	calculate_service_availability($serviceid,$period_start,$period_end)
-	{
-	       	$sql="select count(*),min(clock),max(clock) from service_alarms where serviceid=$serviceid and clock>=$period_start and clock<=$period_end";
-		
-		$sql="select clock,value from service_alarms where serviceid=$serviceid and clock>=$period_start and clock<=$period_end";
-		$result=DBselect($sql);
-
-// -1,0,1
-		$state=get_last_service_value($serviceid,$period_start);
-		$problem_time=0;
-		$ok_time=0;
-		$time=$period_start;
-		for($i=0;$i<DBnum_rows($result);$i++)
-		{
-			$clock=DBget_field($result,$i,0);
-			$value=DBget_field($result,$i,1);
-
-			$diff=$clock-$time;
-
-			$time=$clock;
-#state=0,1 (OK), >1 PROBLEMS 
-
-			if($state<=1)
-			{
-				$ok_time+=$diff;
-				$state=$value;
-			}
-			else
-			{
-				$problem_time+=$diff;
-				$state=$value;
-			}
-		}
-//		echo $problem_time,"-",$ok_time,"<br>";
-
-		if(DBnum_rows($result)==0)
-		{
-			if(get_last_service_value($serviceid,$period_start)<=1)
-			{
-				$ok_time=$period_end-$period_start;
-			}
-			else
-			{
-				$problem_time=$period_end-$period_start;
-			}
-		}
-		else
-		{
-			if($state<=1)
-			{
-				$ok_time=$ok_time+$period_end-$time;
-			}
-			else
-			{
-				$problem_time=$problem_time+$period_end-$time;
-			}
-		}
-
-//		echo $problem_time,"-",$ok_time,"<br>";
-
-		$total_time=$problem_time+$ok_time;
-		if($total_time==0)
-		{
-			$ret["problem_time"]=0;
-			$ret["ok_time"]=0;
-			$ret["problem"]=0;
-			$ret["ok"]=0;
-		}
-		else
-		{
-			$ret["problem_time"]=$problem_time;
-			$ret["ok_time"]=$ok_time;
-			$ret["problem"]=(100*$problem_time)/$total_time;
-			$ret["ok"]=(100*$ok_time)/$total_time;
-		}
-		return $ret;
-	}
-
 	// If $period_start=$period_end=0, then take maximum period
 	function	calculate_availability($triggerid,$period_start,$period_end)
 	{
diff --git a/frontends/php/include/services.inc.php b/frontends/php/include/services.inc.php
new file mode 100644
index 00000000..786f1e3b
--- /dev/null
+++ b/frontends/php/include/services.inc.php
@@ -0,0 +1,351 @@
+<?php
+/*
+** Zabbix
+** Copyright (C) 2000,2001,2002,2003,2004 Alexei Vladishev
+**
+** 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
+	function	add_service($serviceid,$name,$triggerid,$linktrigger,$algorithm,$showsla,$goodsla,$sortorder)
+	{
+		if( isset($showsla)&&($showsla=="on") )
+		{
+			$showsla=1;
+		}
+		else
+		{
+			$showsla=0;
+		}
+		if( isset($linktrigger)&&($linktrigger=="on") )
+		{
+//			$trigger=get_trigger_by_triggerid($triggerid);
+//			$description=$trigger["description"];
+//			if( strstr($description,"%s"))
+//			{
+				$description=expand_trigger_description($triggerid);
+//			}
+			$description=addslashes($description);
+			$sql="insert into services (name,triggerid,status,algorithm,showsla,goodsla,sortorder) values ('$description',$triggerid,0,$algorithm,$showsla,$goodsla,$sortorder)";
+		}
+		else
+		{
+			$sql="insert into services (name,status,algorithm,showsla,goodsla,sortorder) values ('$name',0,$algorithm,$showsla,$goodsla,$sortorder)";
+		}
+		$result=DBexecute($sql);
+		if(!$result)
+		{
+			return FALSE;
+		}
+		$id=DBinsert_id($result,"services","serviceid");
+		if(isset($serviceid))
+		{
+			add_service_link($id,$serviceid,0);
+		}
+		return $id;
+	}
+
+	function	add_host_to_services($hostid,$serviceid)
+	{
+		$sql="select distinct t.triggerid,t.description from triggers t,hosts h,items i,functions f where h.hostid=$hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid";
+		$result=DBselect($sql);
+		while($row=DBfetch($result))
+		{
+			$serviceid2=add_service($serviceid,$row["description"],$row["triggerid"],"on",0,"off",99,0);
+//			add_service_link($serviceid2,$serviceid,0);
+		}
+		return	1;
+	}
+
+	function	is_service_hardlinked($serviceid)
+	{
+		$sql="select count(*) from services_links where servicedownid=$serviceid and soft=0";
+		$result=DBselect($sql);
+		if(DBget_field($result,0,0)>0)
+		{
+			return	TRUE;
+		}
+		return	FALSE;
+	}
+
+	function	delete_service_link($linkid)
+	{
+		$sql="delete from services_links where linkid=$linkid";
+		return DBexecute($sql);
+	}
+
+	function	delete_service($serviceid)
+	{
+		$sql="delete from services_links where servicedownid=$serviceid or serviceupid=$serviceid";
+		$result=DBexecute($sql);
+		if(!$result)
+		{
+			return	$result;
+		}
+		$sql="delete from services where serviceid=$serviceid";
+		return DBexecute($sql);
+	}
+
+	# Return TRUE if triggerid is a reason why the service is not OK
+	# Warning: recursive function
+	function	does_service_depend_on_the_service($serviceid,$serviceid2)
+	{
+#		echo "Serviceid:$serviceid Triggerid:$serviceid2<br>";
+		$service=get_service_by_serviceid($serviceid);
+#		echo "Service status:".$service["status"]."<br>";
+		if($service["status"]==0)
+		{
+			return	FALSE;
+		}
+		if($serviceid==$serviceid2)
+		{
+			if($service["status"]>0)
+			{
+				return TRUE;
+			}
+			
+		}
+
+		$sql="select serviceupid from services_links where servicedownid=$serviceid2 and soft=0";
+#		echo $sql."<br>";
+		$result=DBselect($sql);
+		while($row=DBfetch($result))
+		{
+			if(does_service_depend_on_the_service($serviceid,$row["serviceupid"]) == TRUE)
+			{
+				return	TRUE;
+			}
+		}
+		return	FALSE;
+	}
+
+	function	service_has_parent($serviceid)
+	{
+		$sql="select count(*) from services_links where servicedownid=$serviceid";
+		$result=DBselect($sql);
+		if(DBget_field($result,0,0)>0)
+		{
+			return	TRUE;
+		}
+		return	FALSE;
+	}
+
+	function	service_has_no_this_parent($parentid,$serviceid)
+	{
+		$sql="select count(*) from services_links where serviceupid=$parentid and servicedownid=$serviceid";
+		$result=DBselect($sql);
+		if(DBget_field($result,0,0)>0)
+		{
+			return	FALSE;
+		}
+		return	TRUE;
+	}
+
+	function	update_service($serviceid,$name,$triggerid,$linktrigger,$algorithm,$showsla,$goodsla,$sortorder)
+	{
+		if( isset($linktrigger)&&($linktrigger=="on") )
+		{
+			// No mistake here
+			$triggerid=$triggerid;
+		}
+		else
+		{
+			$triggerid='NULL';
+		}
+		if( isset($showsla)&&($showsla=="on") )
+		{
+			$showsla=1;
+		}
+		else
+		{
+			$showsla=0;
+		}
+		$sql="update services set name='$name',triggerid=$triggerid,status=0,algorithm=$algorithm,showsla=$showsla,goodsla=$goodsla,sortorder=$sortorder where serviceid=$serviceid";
+		return	DBexecute($sql);
+	}
+
+	function	add_service_link($servicedownid,$serviceupid,$softlink)
+	{
+		global	$ERROR_MSG;
+
+		if( ($softlink==0) && (is_service_hardlinked($servicedownid)==TRUE) )
+		{
+			return	FALSE;
+		}
+
+		if($servicedownid==$serviceupid)
+		{
+			$ERROR_MSG="Cannot link service to itself.";
+			return	FALSE;
+		}
+
+		$sql="insert into services_links (servicedownid,serviceupid,soft) values ($servicedownid,$serviceupid,$softlink)";
+		return	DBexecute($sql);
+	}
+
+	function	get_last_service_value($serviceid,$clock)
+	{
+	       	$sql="select count(*),max(clock) from service_alarms where serviceid=$serviceid and clock<=$clock";
+//		echo " $sql<br>";
+		
+	        $result=DBselect($sql);
+		if(DBget_field($result,0,0)>0)
+		{
+	       		$sql="select value from service_alarms where serviceid=$serviceid and clock=".DBget_field($result,0,1);
+		        $result2=DBselect($sql);
+// Assuring that we get very latest service value. There could be several with the same timestamp
+//			$value=DBget_field($result2,0,0);
+			for($i=0;$i<DBnum_rows($result2);$i++)
+			{
+				$value=DBget_field($result2,$i,0);
+			}
+		}
+		else
+		{
+			$value=0;
+		}
+		return $value;
+	}
+
+	function	calculate_service_availability($serviceid,$period_start,$period_end)
+	{
+	       	$sql="select count(*),min(clock),max(clock) from service_alarms where serviceid=$serviceid and clock>=$period_start and clock<=$period_end";
+		
+		$sql="select clock,value from service_alarms where serviceid=$serviceid and clock>=$period_start and clock<=$period_end";
+		$result=DBselect($sql);
+
+// -1,0,1
+		$state=get_last_service_value($serviceid,$period_start);
+		$problem_time=0;
+		$ok_time=0;
+		$time=$period_start;
+		for($i=0;$i<DBnum_rows($result);$i++)
+		{
+			$clock=DBget_field($result,$i,0);
+			$value=DBget_field($result,$i,1);
+
+			$diff=$clock-$time;
+
+			$time=$clock;
+#state=0,1 (OK), >1 PROBLEMS 
+
+			if($state<=1)
+			{
+				$ok_time+=$diff;
+				$state=$value;
+			}
+			else
+			{
+				$problem_time+=$diff;
+				$state=$value;
+			}
+		}
+//		echo $problem_time,"-",$ok_time,"<br>";
+
+		if(DBnum_rows($result)==0)
+		{
+			if(get_last_service_value($serviceid,$period_start)<=1)
+			{
+				$ok_time=$period_end-$period_start;
+			}
+			else
+			{
+				$problem_time=$period_end-$period_start;
+			}
+		}
+		else
+		{
+			if($state<=1)
+			{
+				$ok_time=$ok_time+$period_end-$time;
+			}
+			else
+			{
+				$problem_time=$problem_time+$period_end-$time;
+			}
+		}
+
+//		echo $problem_time,"-",$ok_time,"<br>";
+
+		$total_time=$problem_time+$ok_time;
+		if($total_time==0)
+		{
+			$ret["problem_time"]=0;
+			$ret["ok_time"]=0;
+			$ret["problem"]=0;
+			$ret["ok"]=0;
+		}
+		else
+		{
+			$ret["problem_time"]=$problem_time;
+			$ret["ok_time"]=$ok_time;
+			$ret["problem"]=(100*$problem_time)/$total_time;
+			$ret["ok"]=(100*$ok_time)/$total_time;
+		}
+		return $ret;
+	}
+
+	function	get_service_status_description($status)
+	{
+		$desc="<font color=\"#00AA00\">OK</a>";
+		if($status==5)
+		{
+			$desc="<font color=\"#FF0000\">Disaster</a>";
+		}
+		elseif($status==4)
+		{
+			$desc="<font color=\"#FF8888\">Serious&nbsp;problem</a>";
+		}
+		elseif($status==3)
+		{
+			$desc="<font color=\"#AA0000\">Average&nbsp;problem</a>";
+		}
+		elseif($status==2)
+		{
+			$desc="<font color=\"#AA5555\">Minor&nbsp;problem</a>";
+		}
+		elseif($status==1)
+		{
+			$desc="<font color=\"#00AA00\">OK</a>";
+		}
+		return $desc;
+	}
+
+	function	get_num_of_service_childs($serviceid)
+	{
+		global	$ERROR_MSG;
+
+		$sql="select count(*) from services_links where serviceupid=$serviceid";
+		$result=DBselect($sql);
+		return	DBget_field($result,0,0);
+	}
+
+	function	get_service_by_serviceid($serviceid)
+	{
+		global	$ERROR_MSG;
+
+		$sql="select * from services where serviceid=$serviceid";
+		$result=DBselect($sql);
+		if(Dbnum_rows($result) == 1)
+		{
+			return	DBfetch($result);
+		}
+		else
+		{
+			$ERROR_MSG="No service with serviceid=[$serviceid]";
+		}
+		return	FALSE;
+	}
+?>