- added "Data overview" for screens

 - added "Triggers overview" for screens (Eugene)
 - added blinking into Trigger overview (Eugene)
 - added screen displaying in other screen (Eugene)
 - improved Overview table header, vertical text added (Eugene)
 - developed "ZABBIX Clock" module for screens (Eugene)
 - developed "ZABBIX server info" module for screens (Eugene)
 - developed "Triggers info" module for screens (Eugene)
 - developed "Host info" module for screens (Eugene)
 - improved screens displaying, added item alignment (Eugene)
 - improved ZABBIX server report (Eugene)
 - improved images configuration (Eugene)
 - added onserver image resizing for thumbs by php (Eugene)
 - developed acknowledges system (Eugene)
 - added icons displaying for maps (Eugene)
 - added maps displaying for maps (Eugene)
 - improved maps (Eugene)


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

1 files changed, 64 insertions, 0 deletions

diff --git a/frontends/php/include/items.inc.php b/frontends/php/include/items.inc.php
index 2d080f4c..23562cab 100644
--- a/frontends/php/include/items.inc.php
+++ b/frontends/php/include/items.inc.php
@@ -434,4 +434,68 @@
 
 		return get_host_by_itemid($itemid);
 	}
+
+	function get_items_data_overview($groupid)
+	{
+		$table = new CTableInfo();
+
+		if($groupid > 0)
+		{
+			$group_where = ",hosts_groups hg where hg.groupid=$groupid and hg.hostid=h.hostid and";
+		} else {
+			$group_where = " where";
+		}
+
+		$header=array(new CCol(S_ITEMS,"center"));
+
+		$hosts=array();
+		$result=DBselect("select h.hostid,h.host from hosts h,items i $group_where".
+			" h.status=".HOST_STATUS_MONITORED." and h.hostid=i.hostid".
+			" group by h.host,h.hostid order by h.host");
+		while($row=DBfetch($result))
+		{
+			$header=array_merge($header,array(do_vertival_text($row["host"])));
+			$hosts=array_merge($hosts,array($row["hostid"]));
+		}
+		$table->SetHeader($header,"vertical_header");
+		
+
+		$db_items = DBselect("select distinct i.description from hosts h,items i $group_where".
+			" h.status=".HOST_STATUS_MONITORED." and h.hostid=i.hostid order by 1");
+		while($item = DBfetch($db_items))
+		{
+			$table_row = array(nbsp($item["description"]));
+			foreach($hosts as $hostid)
+			{
+				$db_host_items = DBselect("select itemid,value_type,lastvalue,units from items where".
+					" hostid=$hostid and description=".zbx_dbstr($item["description"]));
+				if(DBnum_rows($db_host_items)!=1)
+				{
+					array_push($table_row,"-");
+					continue;
+				}
+				$host_item = DBfetch($db_host_items);
+				if(!isset($host_item["lastvalue"]))
+				{
+					array_push($table_row,"-");
+					continue;
+				}
+				$db_item_triggers = DBselect("select t.triggerid from triggers t, items i, functions f where".
+					" i.hostid=$hostid and i.itemid=".$host_item["itemid"]." and i.itemid=f.itemid".
+					" and t.priority>1 and t.triggerid=f.triggerid and t.value=".TRIGGER_VALUE_TRUE);
+				if(DBnum_rows($db_item_triggers) > 0)		$style = "high";
+				else						$style = NULL;
+
+				if($host_item["value_type"] == 0)
+					$value = convert_units($host_item["lastvalue"],$host_item["units"]);
+				else
+					$value = htmlspecialchars(substr($host_item["lastvalue"],0,20)." ...");
+
+				array_push($table_row,new CCol(nbsp($value),$style));
+			}
+
+			$table->AddRow($table_row);
+		}
+		return $table;
+	}
 ?>