- [DEV-197] added support of trends_uint

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

1 files changed, 11 insertions, 0 deletions

diff --git a/frontends/php/include/classes/pie.inc.php b/frontends/php/include/classes/pie.inc.php
index ad92298d..822431b9 100644
--- a/frontends/php/include/classes/pie.inc.php
+++ b/frontends/php/include/classes/pie.inc.php
@@ -132,6 +132,17 @@ function selectData(){
 					' AND t.clock>='.$from_time.
 					' AND t.clock<='.$to_time.
 				' GROUP BY t.itemid'
+				,
+
+				'SELECT t.itemid, '.
+					' avg(t.value_avg) AS avg,min(t.value_min) AS min,'.
+					' max(t.value_max) AS max,max(t.clock) AS clock, max(i.lastvalue) as lst'.
+				' FROM trends_uint t '.
+					' LEFT JOIN items i ON t.itemid = i.itemid'.
+				' WHERE t.itemid='.$this->items[$i]['itemid'].
+					' AND t.clock>='.$from_time.
+					' AND t.clock<='.$to_time.
+				' GROUP BY t.itemid'
 				);
 		}