r1441 + initial VS rendering

diff --git a/inc/database.php b/inc/database.php
index 19a4e34..5ae4ab8 100644 (file)
--- a/inc/database.php
+++ b/inc/database.php
@@ -2001,7 +2001,36 @@ function getSLBSummary ()
                }
                $ret[$vsid]['rspools'][$row['object_id']] = $row['rscount'];
        }
+       $result->closeCursor();
        return $ret;
 }
 
+function getVServiceInfo ($vsid = 0)
+{
+       global $dbxlink;
+       $query = "select inet_ntoa(vip) as vip, vport, proto, name, vsconfig, default_rsconfig, " .
+               "rs.id as rsid, inet_ntoa(rs.rsip) as rsip, rsport as rsport from " .
+               "IPVirtualService as vs inner join IPRealServer as rs on vs.vsid = rs.vsid " .
+               "where vs.vsid = ${vsid} order by rsip, rsport";
+       $result = $dbxlink->query ($query);
+       if ($result == NULL)
+       {
+               showError ('SQL query failed', __FUNCTION__);
+               return NULL;
+       }
+       $vsinfo = array ();
+       while ($row = $result->fetch (PDO::FETCH_ASSOC))
+       {
+               if (!isset ($vsinfo['vip']))
+               {
+                       foreach (array ('vip', 'vport', 'proto', 'name', 'vsconfig', 'default_rsconfig') as $cname)
+                               $vsinfo[$cname] = $row[$cname];
+                       $vsinfo['rslist'] = array();
+               }
+               $vsinfo['rslist'][] = array ('rsid' => $row['rsid'], 'rsip' => $row['rsip'], 'rsport' => $row['rsport']);
+       }
+       $result->closeCursor();
+       return $vsinfo;
+}
+
 ?>

diff --git a/inc/interface.php b/inc/interface.php
index 53e1814..15eba52 100644 (file)
--- a/inc/interface.php
+++ b/inc/interface.php
@@ -3579,9 +3579,17 @@ function renderLVSConfig ($object_id = 0)
        echo '</pre>';
 }
 
-function renderVirtualService ()
+function renderVirtualService ($vsid = 0)
 {
-       dragon();
+       if ($vsid <= 0)
+       {
+               showError ('Invalid vsid', __FUNCTION__);
+               return;
+       }
+       $vsinfo = getVServiceInfo ($vsid);
+echo '<pre>';
+print_r ($vsinfo);
+echo '</pre>';
 }
 
 ?>