title = $aInt->lang('networkissues', 'title');
$aInt->sidebar = 'support';
$aInt->icon = 'networkissues';
$upd = fromMySQLDate(date("Y-m-d H:i:s"), true);
if( $action == 'save' )
{
check_token("WHMCS.admin.default");
if( !$startdate )
{
$startdate = $upd;
}
$errormessage = '';
if( !$title )
{
$errormessage = "" . $aInt->lang('networkIssues', 'missingTitle') . "";
}
if( !$type )
{
$errormessage = "" . $aInt->lang('networkIssues', 'missingType') . "";
}
if( $type == 'Server' && !$server )
{
$errormessage = "" . $aInt->lang('networkIssues', 'missingServer') . "";
}
if( ($type == 'Service' || $type == 'Other') && !$affecting )
{
$errormessage = "" . $aInt->lang('networkIssues', 'missingAffecting') . "";
}
if( $type != 'Server' )
{
$server = 0;
}
if( !$startdate )
{
$errormessage = "" . $aInt->lang('networkIssues', 'missingStartDate') . "";
}
if( !$description )
{
$errormessage = "" . $aInt->lang('networkIssues', 'missingDescription') . "";
}
if( $errormessage )
{
$action = 'manage';
}
else
{
$startdate = toMySQLDate($startdate);
if( $enddate )
{
$enddate = toMySQLDate($enddate);
}
else
{
$enddate = 'NULL';
}
$updatearray = array( 'startdate' => $startdate, 'enddate' => $enddate, 'title' => $title, 'description' => WHMCS_Input_Sanitize::decode($description), 'type' => $type, 'server' => $server, 'affecting' => $affecting, 'priority' => $priority, 'status' => $status, 'lastupdate' => "now()" );
if( $id )
{
update_query('tblnetworkissues', $updatearray, array( 'id' => $id ));
run_hook('NetworkIssueEdit', array_merge(array( 'id' => $id ), $updatearray));
if( $status == 'Resolved' )
{
run_hook('NetworkIssueClose', array( 'id' => $id ));
}
}
else
{
$nwid = insert_query('tblnetworkissues', $updatearray);
run_hook('NetworkIssueAdd', array_merge(array( 'id' => $nwid ), $updatearray));
}
redir();
}
}
if( $action == 'close' )
{
check_token("WHMCS.admin.default");
update_query('tblnetworkissues', array( 'status' => 'Resolved', 'enddate' => "now()" ), array( 'id' => $id ));
run_hook('NetworkIssueClose', array( 'id' => $id ));
redir("view=resolved");
}
if( $action == 'reopen' )
{
check_token("WHMCS.admin.default");
update_query('tblnetworkissues', array( 'status' => "In Progress", 'enddate' => 'NULL' ), array( 'id' => $id ));
run_hook('NetworkIssueReopen', array( 'id' => $id ));
redir();
}
if( $action == 'delete' )
{
check_token("WHMCS.admin.default");
run_hook('NetworkIssueDelete', array( 'id' => $id ));
delete_query('tblnetworkissues', array( 'id' => $id ));
redir();
}
$t_query = "SHOW COLUMNS FROM tblnetworkissues LIKE 'type'";
$t_result = full_query($t_query);
if( 0 < mysql_num_rows($t_result) )
{
$t_row = mysql_fetch_row($t_result);
$type_options = explode("','", preg_replace("/(enum|set)\\('(.+?)'\\)/", "\\2", $t_row[1]));
}
$p_query = "SHOW COLUMNS FROM tblnetworkissues LIKE 'priority'";
$p_result = full_query($p_query);
if( 0 < mysql_num_rows($p_result) )
{
$p_row = mysql_fetch_row($p_result);
$priority_options = explode("','", preg_replace("/(enum|set)\\('(.+?)'\\)/", "\\2", $p_row[1]));
}
$s_query = "SHOW COLUMNS FROM tblnetworkissues LIKE 'status'";
$s_result = full_query($s_query);
if( 0 < mysql_num_rows($s_result) )
{
$s_row = mysql_fetch_row($s_result);
$status_options = explode("','", preg_replace("/(enum|set)\\('(.+?)'\\)/", "\\2", $s_row[1]));
}
$server_query = "SELECT id, name FROM tblservers";
$server_result = full_query($server_query);
ob_start();
if( $action == '' )
{
if( $view == 'scheduled' )
{
$pagetitle = 'Scheduled';
$where = array( 'status' => 'Scheduled' );
}
else
{
if( $view == 'resolved' )
{
$pagetitle = 'Resolved';
$where = array( 'status' => 'Resolved' );
}
else
{
$pagetitle = 'Open';
$where = "status!='Resolved' AND status!='Scheduled'";
}
}
$result = select_query('tblnetworkissues', "*,(select name from tblservers where id = tblnetworkissues.server) as server", $where, 'lastupdate', 'DESC');
$aInt->deleteJSConfirm('doDelete', 'networkissues', 'deletesure', "?action=delete&id=");
echo "\n";
echo $aInt->lang('fields', 'options');
echo ":\n ";
echo $aInt->lang('networkissues', 'open');
echo " |\n ";
echo $aInt->lang('networkissues', 'scheduled');
echo " |\n ";
echo $aInt->lang('networkissues', 'resolved');
echo " |\n ![](\"images/icons/add.png\")
";
echo $aInt->lang('networkissues', 'addnew');
echo "
\n\n";
echo $pagetitle;
echo " Issues
\n\n";
$aInt->sortableTableInit('nopagination');
if( mysql_num_rows($result) )
{
while( $open_row = mysql_fetch_assoc($result) )
{
$enddate = $open_row['enddate'];
if( $enddate )
{
$enddate = fromMySQLDate($enddate, true);
}
else
{
$enddate = $aInt->lang('networkIssues', 'none');
}
if( $open_row['server'] )
{
$open_row['type'] .= " (" . $open_row['server'] . ")";
}
if( $open_row['status'] == 'Resolved' )
{
$actions = "" . $aInt->lang('networkIssues', 'reopen') . "";
}
else
{
$actions = "" . $aInt->lang('networkIssues', 'close') . "";
}
$tabledata[] = array( "" . $open_row['title'] . "", $open_row['type'], $open_row['priority'], $open_row['status'], fromMySQLDate($open_row['startdate'], true), $enddate, $actions, "![\"Delete\"](\"images/delete.gif\")
" );
}
}
echo $aInt->sortableTable(array( $aInt->lang('networkIssues', 'titleTitle'), $aInt->lang('networkIssues', 'type'), $aInt->lang('networkIssues', 'priority'), $aInt->lang('networkIssues', 'status'), $aInt->lang('networkIssues', 'startDate'), $aInt->lang('networkIssues', 'endDate'), " ", '' ), $tabledata);
}
else
{
if( $action == 'manage' )
{
if( $errormessage )
{
infoBox($aInt->lang('networkIssues', 'validationFailed'), $errormessage, 'error');
echo $infobox;
}
echo "\n\n\n\n";
$aInt->richTextEditor();
}
}
$content = ob_get_contents();
ob_end_clean();
$aInt->content = $content;
$aInt->jquerycode = $jquerycode;
$aInt->jscode = $jscode;
$aInt->display();