<?php
//++++++++++++++++++++++++++++++++++++++++++
// Authors: Minott Pruyn
// Platform: Unix
// Date: April 22, 2008
//
// This file is used to display site info
// such as URL's to the customer.
//++++++++++++++++++++++++++++++++++++++++++

require ("misc.phph");
require "/nfscommon/html/admin/bam/uma_header_oracle.phph";

require ("auth_enduser.phph");
$company_id = $_SESSION['auth_company_id'];
$company_name = $_SESSION['auth_company_info'];
$auth_login = $_SESSION['auth_login'];

$dbh = db_connect($db);

    $query = "
                SELECT 
                    s.site_name SITE_NAME,
                    i.interface_name INTERFACE_NAME,
                    concat( if(d.https_redirect != 0, 'https://', 'http://'),d.fqdn) ENDUSER_PAGE,
                    concat( if(d.https_redirect != 0, 'https://', 'http://'),d.fqdn, '/cgi-bin/', i.interface_name,
                                if (i.rnm_product_id != 0, '.cfg/metrics',
                                    if (i.interface_name like '%locator', '/login', '.cfg/php/admin/launch.php'))) ADMIN_PAGE
                FROM 
                    siteinfo.interfaces i,
                    siteinfo.sites s,
                    dns d,
                    server_types st,
                    siteinfo.site_types sit
                WHERE 
                    i.site_id = s.site_id
                    AND s.company_id = '".mysql_real_escape_string($company_id)."'
                    AND s.active !='N'
                    AND s.site_type_id = sit.id
                    AND sit.name IN ('paid_test_site', 'production', 'upgrade')
                    AND d.interface_id = i.interface_id
                    AND d.prime = 1
                    AND st.server_type = 'vip'
                    AND st.server_type_id = d.server_type_id

                ORDER BY s.site_name, i.interface_name";


    $res = mysql_query($query, $dbh);
    if(!$res) 
    {
    	db_err($dbh, "Query: " . $query);
    }

    // Build a data structure with all the data from the database
    $site_list = array();
    while ($row = mysql_fetch_assoc($res)) 
    {
        $site_list[ $row['SITE_NAME'] ][ $row['INTERFACE_NAME'] ] = array( 'enduser_page' => $row['ENDUSER_PAGE'], 'admin_page' => $row['ADMIN_PAGE']);
    }
?>

<table width=600 cellpadding=0 cellspacing=0>
    
    <tr>
        <td align=left width=400><font size=+2><b>Site Info</b></font></td>
    </tr>
</table>
<br>
<table width=600 cellpadding=0 cellspacing=0>
    <tr></tr>
    <tr>
        <td align=left width=400><font size=+1><b>
            <?php echo $company_name ?></b></font></td>
    </tr>
    <tr>
        <td align=left><font size=-1>Logged in as
            &lt;<?php echo $auth_login ?>&gt;</font></td>
        <td align=left></td>
        <td align=right>&nbsp;</td>
    </tr>
</table>

<br>

<?
    foreach($site_list as $site_name => $interfaces)
    {
        echo "<table bgcolor=#ccccff width=600>
                    <tr><th align=left width=600>$site_name</th></tr>
                </table>\n";
        foreach($interfaces as $interface_name => $interface_info)
        {
            echo "<hr width=600 align=left>
                    <table width=600>
                    <tr>
                        <td align='left'><b><i>".$interface_name."</i></b></td>
                    </tr><tr>
                        <td align='left' >Enduser Page: <a href='".$interface_info['enduser_page']."'>".$interface_info['enduser_page']."</a></td>
                    </tr><tr>
                        <td align='left' >Admin Page: <a href='".$interface_info['admin_page']."'>".$interface_info['admin_page']."</a></td>
                    </tr>
                    </table>\n";
        }
        echo "<br><br>";
    }
                    
?>
<table width=600 cellpadding=0 cellspacing=0>
<tr>
    <td colspan=2><br></td>
</tr>
<tr>
    <td width=450 align=left valign=top>
    <br></td>
    <td align=left>
&nbsp;</td>
</tr>
</table>

<? require ("/nfscommon/html/admin/bam/uma_footer_oracle.phph"); ?>
