" . $_LANG['globalsystemname'] . " > " . $_LANG['networkissuestitle'] . "";
$fromserverstatus = false;
}
$view = $whmcs->get_req_var('view');
if( $view == 'open' )
{
$query_where = "status!='Resolved' AND status!='Scheduled'";
$breadcrumbnav .= " > " . $_LANG['networkissuesstatusopen'] . "";
}
else
{
if( $view == 'scheduled' )
{
$query_where = "status='Scheduled'";
$breadcrumbnav .= " > " . $_LANG['networkissuesstatusscheduled'] . "";
}
else
{
if( $view == 'resolved' )
{
$query_where = "status='Resolved'";
$breadcrumbnav .= " > " . $_LANG['networkissuesstatusresolved'] . "";
}
else
{
if( substr($view, 0, 3) == 'nid' )
{
$nid = str_replace('nid', '', $view);
$query_where = "id=" . (int) $nid;
}
else
{
$view = 'open';
$query_where = "status!='Resolved'";
}
}
}
}
if( !$fromserverstatus )
{
initialiseClientArea($pagetitle, $pageicon, $breadcrumbnav);
}
if( $CONFIG['NetworkIssuesRequireLogin'] && !$_SESSION['uid'] )
{
$goto = 'networkissues';
require("login.php");
}
$result = select_query('tblnetworkissues', "COUNT(*)", "status!='Resolved' AND status!='Scheduled'");
$data = mysql_fetch_array($result);
$smartyvalues['opencount'] = $data[0];
$result = select_query('tblnetworkissues', "COUNT(*)", "status='Scheduled'");
$data = mysql_fetch_array($result);
$smartyvalues['scheduledcount'] = $data[0];
$result = select_query('tblnetworkissues', "COUNT(*)", "status='Resolved'");
$data = mysql_fetch_array($result);
$smartyvalues['resolvedcount'] = $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, 'status' => $status, 'lastupdate' => $lastupdate, 'clientaffected' => $affected );
}
$smartyvalues['issues'] = $issues;
$smartyvalues['view'] = $view;
$smartyvalues = array_merge($smartyvalues, clientAreaTablePageNav($numitems));
$smartyvalues['noissuesmsg'] = sprintf($_LANG['networkstatusnone'], $_LANG['networkissuesstatus' . $view]);
if( !$fromserverstatus )
{
$templatefile = 'networkissues';
outputClientArea($templatefile);
}