networkissues.php

<?php 
$fromserverstatus = true;
if( !defined("CLIENTAREA") ) 
{
    define("CLIENTAREA", false);
    require("init.php");
    $templatepath = ROOTDIR . "/templates/" . $CONFIG["Template"] . "/";
    if( !file_exists($templatepath . "networkissues.tpl") && file_exists($templatepath . "serverstatus.tpl") ) 
    {
        redir("", "serverstatus.php");
    }

    $pagetitle = $_LANG["networkissuestitle"];
    $pageicon = "images/clientarea_big.gif";
    $breadcrumbnav = "<a href=\"index.php\">" . $_LANG["globalsystemname"] . "</a> > <a href=\"networkissues.php\">" . $_LANG["networkissuestitle"] . "</a>";
    $fromserverstatus = false;
}

$view = $whmcs->get_req_var("view");
if( $view == "open" ) 
{
    $query_where = "status!='Resolved' AND status!='Scheduled'";
    $breadcrumbnav .= " > <a href=\"networkissues.php?view=open\">" . $_LANG["networkissuesstatusopen"] . "</a>";
}
else
{
    if( $view == "scheduled" ) 
    {
        $query_where = "status='Scheduled'";
        $breadcrumbnav .= " > <a href=\"networkissues.php?view=scheduled\">" . $_LANG["networkissuesstatusscheduled"] . "</a>";
    }
    else
    {
        if( $view == "resolved" ) 
        {
            $query_where = "status='Resolved'";
            $breadcrumbnav .= " > <a href=\"networkissues.php?view=resolved\">" . $_LANG["networkissuesstatusresolved"] . "</a>";
        }
        else
        {
            if( substr($view, 0, 3) == "nid" ) 
            {
                $nid = str_replace("nid", "", $view);
                $query_where = "id=" . (int) $nid;
            }
            else
            {
                $query_where = "status!='Resolved'";
            }

        }

    }

}

if( !$fromserverstatus ) 
{
    initialiseClientArea($pagetitle, $pageicon, $breadcrumbnav);
}

#if( $CONFIG["NetworkIssuesRequireLogin"] && !$_SESSION["uid"] ) 
#{
#    $goto = "networkissues";
#    require("login.php");
#}

$issueStatusCounts = array(  );
$result = select_query("tblnetworkissues", "COUNT(*)", "status!='Resolved' AND status!='Scheduled'");
$data = mysql_fetch_array($result);
$smartyvalues["opencount"] = $data[0];
$issueStatusCounts["open"] = $data[0];
$result = select_query("tblnetworkissues", "COUNT(*)", "status='Scheduled'");
$data = mysql_fetch_array($result);
$smartyvalues["scheduledcount"] = $data[0];
$issueStatusCounts["scheduled"] = $data[0];
$result = select_query("tblnetworkissues", "COUNT(*)", "status='Resolved'");
$data = mysql_fetch_array($result);
$smartyvalues["resolvedcount"] = $data[0];
$issueStatusCounts["resolved"] = $data[0];
$users_servers = array(  );
if( isset($_SESSION["uid"]) ) 
{
    $result = select_query("tblhosting", "DISTINCT server", array( "userid" => $_SESSION["uid"] ));
    while( $data = mysql_fetch_array($result) ) 
    {
        if( $data["server"] ) 
        {
            $users_servers[] = $data["server"];
        }

    }
}

$result = select_query("tblnetworkissues", "COUNT(*)", $query_where);
$data = mysql_fetch_array($result);
$numitems = $data[0];
list($orderby, $sort, $limit) = clientAreaTableInit("networkissues", "lastupdate", "DESC", $numitems);
$smartyvalues["orderby"] = $orderby;
$smartyvalues["sort"] = strtolower($sort);
$issues = array(  );
$result = select_query("tblnetworkissues", "", $query_where, $orderby, $sort, $limit);
while( $data = mysql_fetch_array($result) ) 
{
    $startdate = fromMySQLDate($data["startdate"], true);
    $lastupdate = fromMySQLDate($data["lastupdate"], true);
    if( !is_null($data["enddate"]) ) 
    {
        $enddate = fromMySQLDate($data["enddate"], true);
    }
    else
    {
        $enddate = "";
    }

    $priority = $_LANG["networkissuespriority" . strtolower($data["priority"])];
    $status = $_LANG["networkissuesstatus" . str_replace(" ", "", strtolower($data["status"]))];
    $type = $_LANG["networkissuestype" . strtolower($data["type"])];
    $affected = false;
    if( $data["server"] ) 
    {
        if( in_array($data["server"], $users_servers) ) 
        {
            $affected = true;
        }

        $result2 = select_query("tblservers", "name", array( "id" => $data["server"] ));
        $data2 = mysql_fetch_array($result2);
        $servername = $data2["name"];
    }
    else
    {
        $affected = false;
        $servername = "";
    }

    $issues[] = array( "id" => $data["id"], "startdate" => $startdate, "enddate" => $enddate, "title" => $data["title"], "description" => $data["description"], "type" => $type, "affecting" => $data["affecting"], "server" => $servername, "priority" => $priority, "rawPriority" => $data["priority"], "status" => $status, "lastupdate" => $lastupdate, "clientaffected" => $affected );
}
$smartyvalues["issues"] = $issues;
$smartyvalues["view"] = $view;
$smartyvalues = array_merge($smartyvalues, clientAreaTablePageNav($numitems));
$smartyvalues["noissuesmsg"] = sprintf($_LANG["networkstatusnone"], (isset($_LANG["networkissuesstatus" . $view]) ? $_LANG["networkissuesstatus" . $view] : ""));
if( !$fromserverstatus ) 
{
    $templatefile = "networkissues";
    outputClientArea($templatefile, false, array( "ClientAreaPageNetworkIssues" ));
}