Index: /branches/amp_3_7/src/webui/webui/htdocs/new/src/hive/services/composer_query_service.py
===================================================================
--- /branches/amp_3_7/src/webui/webui/htdocs/new/src/hive/services/composer_query_service.py	(revision 2461)
+++ /branches/amp_3_7/src/webui/webui/htdocs/new/src/hive/services/composer_query_service.py	(working copy)
@@ -352,3 +352,38 @@
     query_string = format_query_string(query_string)
     req_dict["body"] = 'q=' + query_string
     return req_dict
+
+def get_llb_stats(request):
+    req_dict = {
+        "url": "/v1/datasource/proxy/1/query",
+        "path": "db=composer&epoch=ms",
+        "method": "POST",
+        "body": {},
+        "config": {'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8'}
+    }
+    query_string = 'select linkName, linkGateway, linkStatus, linkThresh, linkUsage, linkBandwidIn, linkBandwidOut, linkConn, linkHits from llbStats where time > now()-20s group by agent_host, linkName;'
+    if 'query' in request:
+        if 'agent_host' in request['query']:
+            query_string = 'select linkName, linkGateway, linkStatus, linkThresh, linkUsage, linkBandwidIn, linkBandwidOut, linkConn, linkHits from llbStats where agent_host  =~ {} and time > now()-20s group by agent_host, linkName;'.format(
+                request['query']['agent_host'])
+    query_string = format_query_string(query_string)
+    req_dict["body"] = 'q=' + query_string
+    return req_dict
+
+
+def get_llb_stats_monitoring_data(request):
+    req_dict = {
+        "url": "/v1/datasource/proxy/1/query",
+        "path": "db=composer&epoch=ms",
+        "method": "POST",
+        "body": {},
+        "config": {'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8'}
+    }
+    query_string = 'select TOP(hits, 5), linkName, agent_host from (select max(linkHits)-min(linkHits) as hits FROM llbStats group by linkName, agent_host) where time > now()-20s;select TOP(last, 5), linkName, agent_host from (select last(linkConn) from llbStats group by linkName, agent_host) where time > now()-20s;'
+    if 'query' in request:
+        if 'agent_host' in request['query']:
+            query_string = 'select TOP(hits, 5), linkName, agent_host from (select max(linkHits)-min(linkHits) as hits FROM llbStats where agent_host  =~ {} group by linkName, agent_host) WHERE time > now()-20s;select TOP(last, 5), linkName, agent_host from (select last(linkConn) from llbStats where agent_host  =~ {} group by linkName, agent_host) where time > now()-20s;'.format(
+                request['query']['agent_host'])
+    query_string = format_query_string(query_string)
+    req_dict["body"] = 'q=' + query_string
+    return req_dict
\ No newline at end of file