";
echo "";
echo "
";
echo "";
echo "![](\"chart5.php?serviceid=".$_GET["serviceid"]."\") ";
echo " | ";
echo "
";
echo "";
show_footer();
exit;
}
$now=time();
$result=DBselect("select serviceid,name,triggerid,status,showsla,goodsla from services order by sortorder,name");
table_begin();
table_header(array(S_SERVICE,S_STATUS,S_REASON,S_SLA_LAST_7_DAYS,nbsp(S_PLANNED_CURRENT_SLA),S_GRAPH));
$col=0;
if(isset($_GET["serviceid"]))
{
echo "";
$service=get_service_by_serviceid($_GET["serviceid"]);
echo "| ".$service["name"]." | ";
echo "".get_service_status_description($service["status"])." | ";
echo " | ";
if($service["showsla"]==1)
{
echo "![](\"chart_sla.php?serviceid=".$service["serviceid"]."\") | ";
}
else
{
echo "- | ";
}
if($service["showsla"]==1)
{
$now=time(NULL);
$period_start=$now-7*24*3600;
$period_end=$now;
$stat=calculate_service_availability($service["serviceid"],$period_start,$period_end);
if($service["goodsla"]>$stat["ok"])
{
$color="AA0000";
}
else
{
$color="00AA00";
}
printf ("%.2f%%/%.2f%% | ",$service["goodsla"],$color,$stat["ok"]);
}
else
{
echo "- | ";
}
echo "Show | ";
echo "
";
$col++;
}
while($row=DBfetch($result))
{
if(!isset($_GET["serviceid"]) && service_has_parent($row["serviceid"]))
{
continue;
}
if(isset($_GET["serviceid"]) && service_has_no_this_parent($_GET["serviceid"],$row["serviceid"]))
{
continue;
}
if(isset($row["triggerid"])&&!check_right_on_trigger("R",$row["triggerid"]))
{
continue;
}
if(isset($_GET["serviceid"])&&($_GET["serviceid"]==$row["serviceid"]))
{
echo "";
}
else
{
if($col++%2==0) { echo "
"; }
else { echo "
"; }
}
$childs=get_num_of_service_childs($row["serviceid"]);
if(isset($row["triggerid"]))
{
$description=nbsp(expand_trigger_description($row["triggerid"]));
$description="[".S_TRIGGER_BIG."] $description";
}
else
{
$trigger_link="";
$description=$row["name"];
}
if(isset($_GET["serviceid"]))
{
if($childs == 0)
{
echo "| - $description | ";
}
else
{
echo " - $description | ";
}
}
else
{
if($childs == 0)
{
echo "$description | ";
}
else
{
echo " $description | ";
}
}
echo "".get_service_status_description($row["status"])." | ";
if($row["status"]==0)
{
echo "- | ";
}
else
{
echo "";
echo "";
$sql="select s.triggerid,s.serviceid from services s, triggers t where s.status>0 and s.triggerid is not NULL and t.triggerid=s.triggerid order by s.status desc,t.description";
$result2=DBselect($sql);
while($row2=DBfetch($result2))
{
if(does_service_depend_on_the_service($row["serviceid"],$row2["serviceid"]))
{
$description=nbsp(expand_trigger_description($row2["triggerid"]));
echo "- $description
";
}
}
echo " ";
echo " | ";
}
if($row["showsla"]==1)
{
echo "![](\"chart_sla.php?serviceid=".$row["serviceid"]."\") | ";
}
else
{
echo "- | ";
}
if($row["showsla"]==1)
{
$now=time(NULL);
$period_start=$now-7*24*3600;
$period_end=$now;
$stat=calculate_service_availability($row["serviceid"],$period_start,$period_end);
if($row["goodsla"]>$stat["ok"])
{
$color="AA0000";
}
else
{
$color="00AA00";
}
printf ("%.2f%%/%.2f%% | ",$row["goodsla"],$color,$stat["ok"]);
}
else
{
echo "- | ";
}
echo "Show | ";
echo "
";
}
table_end();
?>