<?php
require "auth_enduser.phph";
require "/nfscommon/html/admin/bam/uma_header_oracle.phph";
require "oci.phph";

mysql_rw_connect("footer_enduser.phph");
/*
|  1 | production         |
|  2 | upgrade            |
|  3 | paid_test_site     |
|  4 | internal_test_site |
|  6 | pre_clone          |
*/

$sql = sprintf("
    SELECT 
        s.site_name,
        i.interface_name,
        i.interface_id,
        d.fqdn,
        un.run_type,
        u.utility_id
    FROM
        sites s,
        interfaces i,
        utility_names un,
        utilities u,
        dns d,
        server_types st,
        site_types sit
    WHERE
        s.company_id = %d
        AND s.site_id = i.site_id
        AND i.interface_id = u.interface_id
        AND i.interface_id = d.interface_id
        AND d.prime = 1
        AND st.server_type = 'vip'
        AND st.server_type_id = d.server_type_id
        AND u.utility_id = un.utility_id
        AND un.script_enabled = 1
        AND sit.id = s.site_type_id
        AND sit.name IN ('production', 'upgrade', 'paid_test_site')
        AND s.active = 'Y'
    ORDER BY s.site_name, i.interface_name, un.utility_name
    ", $_SESSION["auth_company_id"]);

// Perform the query
$stmt = mysql_query($sql, $conn);
?>
<table width=640 border=0>
<tr>
    <td align=left width=500>
    <font size=+2><b>Utility Stats</b></font>
    </td>
    <td align=right>&nbsp;</td>
</tr>
<tr>
    <td><font size=+1>For <b><?php echo $_SESSION["auth_company_info"] ?></b></font>
    </center></td>
</tr>
</table>
<hr align=left color=orange noshade width=640>
<table width="640">
<tr>
<th width=170 align=left>Database</th>
<th width=170 align=left>Interface</th>
<th colspan=3>Utilities</th>
</tr>
</table>
<?php
$site_list = array();
while ($row = mysql_fetch_assoc($stmt)) {
    $site = $row["site_name"];
    // Skip any -- sites as well as .disabled40 sites
    #if ((ereg("\\.disabled", $site)) || (ereg("\\.retreat", $site)) 
    #    || (ereg("__", $site))) {
    #    continue;
    #}
    $interface = $row["interface_name"];
    $fqdn = $interface;
    $utility = $row["run_type"];

    // Populate "new" site
    if (!array_key_exists($site, $site_list)) {
        $site_list[$site] = array();
    }

    // Populate "new" interface
    if (!array_key_exists($interface, $site_list[$site])) {
        $site_list[$site][$interface] = array("url" => $fqdn, 
            "utilities" => array());
    }

    // Populate the utility
    if (!array_key_exists("utilities", $site_list[$site][$interface])) {
        $site_list[$site][$interface]["utilities"] = array();
    }
    $site_list[$site][$interface]["utilities"][$utility] = sprintf(
        "<a href=\"lastrun.php?iid=%s&utility=%s\">%s</a>",
            $row["interface_id"], $utility, $utility);

}

while (list ($site, $sval) = each ($site_list)) {
?>
        <hr width=360> 
        <table width="640">
<?php
    $first = 1;
    while (list ($interface, $ival) = each($sval)) {
        if ($first) {
            printf("<tr><td align=left valign=top width=170>%s</td>", $site);
            $first = 0;
        } else {
            print("<tr><td width=170></td>");
        }

        printf("<td align=left width=170 valign=top>%s</td>", 
            $site_list[$site][$interface]["url"]);

        printf("<td align=left valign=top>");
        while (list($utility, $uval) = 
            each($site_list[$site][$interface]["utilities"])) {

            printf(" %s<br> ", $uval);
        }
        print("</td></tr>");
    }
    print("</table>");
}
?>
<hr align=left color=orange noshade width=640>
<table width=640 border=0>
<tr>
    <td align=left width=500>
    <br>
    </td>
    <td align=right>&nbsp;</td>
</tr>
</table>

<?php
require "/nfscommon/html/admin/bam/uma_footer_oracle.phph";
?>
