$varApp_rsApps = "1";
if (isset($_GET['app'])) {
$varApp_rsApps = get_magic_quotes_gpc() ? $_GET['app'] : addslashes($_GET['app']);
}
mysql_select_db($database_connProdOps, $connProdOps);
$query_rsApps = sprintf("SELECT * FROM applications WHERE applicationID = %s", $varApp_rsApps);
$rsApps = mysql_query($query_rsApps, $connProdOps) or die(mysql_error());
$row_rsApps = mysql_fetch_assoc($rsApps);
$totalRows_rsApps = mysql_num_rows($rsApps);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("an Application");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
if ($_GET['function'] == "add") {
buildHeaderNEW("application", "Applications", "app", "Add an Application", null);
} elseif ($_GET['function'] == "update") {
buildHeaderNEW("application", "Applications", "app", "Update Application", "Add an Application");
} else {
buildHeaderNEW("application", "Applications", "app", "View an Application", "Add an Application");
foreach ($params as $param) {
if (stristr($param, "pageNum_rsCountries") == false && stristr($param, "totalRows_rsCountries") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsCountries = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsCountries = sprintf("&totalRows_rsCountries=%d%s", $totalRows_rsCountries, $queryString_rsCountries);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Countries");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
buildHeaderNEW("country", null, "countries", "Countries", "Add a Country");
?>
<div align="center">
<div class="casing" align="left">
<?php
login();
}
$varConnType_rsConnTypes = "1";
if (isset($_GET['connType'])) {
$varConnType_rsConnTypes = get_magic_quotes_gpc() ? $_GET['connType'] : addslashes($_GET['connType']);
}
mysql_select_db($database_connProdOps, $connProdOps);
$query_rsConnTypes = sprintf("SELECT * FROM conntypes WHERE connTypeID = %s", $varConnType_rsConnTypes);
$rsConnTypes = mysql_query($query_rsConnTypes, $connProdOps) or die(mysql_error());
$row_rsConnTypes = mysql_fetch_assoc($rsConnTypes);
$totalRows_rsConnTypes = mysql_num_rows($rsConnTypes);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("a Connection Type");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
if ($_GET['function'] == "add") {
buildHeader("connType", "Connection Types", "connType", "Add Connection Type", null);
} elseif ($_GET['function'] == "update") {
buildHeader("connType", "Connection Types", "connType", "Update Connection Type", "Add a Connection Type");
} else {
buildHeader("connType", "Connection Types", "connType", "View Connection Type", "Add a Connection Type");
return "<span class=\"label bg-red\">{$id}</span>";
} elseif ($colorme >= 12 && $colorme < 20) {
return "<span class=\"label bg-orange\">{$id}</span>";
} elseif ($colorme >= 2 && $colorme < 12) {
return "<span class=\"label bg-yellow text-black\">{$id}</span>";
} elseif ($colorme >= 0 && $colorme < 2) {
return "<span class=\"label bg-gray\">{$id}</span>";
}
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Support Requests");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<?php
build_navbar($conn, 4);
?>
</header>
//$row_rsApplications = $rsApplications->fetch_assoc();
$totalRows_rsApplications = $rsApplications->num_rows;
$query_rsReportTypes = "SELECT reportTypeID, reportType FROM reporttypes ORDER BY reportType ASC";
$rsReportTypes = $conn->query($query_rsReportTypes) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
//$row_rsReportTypes = $rsReportTypes->fetch_assoc();
$totalRows_rsReportTypes = $rsReportTypes->num_rows;
$query_rsEmployees = "SELECT employeeID, engineer, displayName FROM employees WHERE engineer = 'y' AND active = 't' ORDER BY displayName ASC";
$rsEmployees = $conn->query($query_rsEmployees) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
//$row_rsEmployees = $rsEmployees->fetch_assoc();
$totalRows_rsEmployees = $rsEmployees->num_rows;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Status Report: " . stripslashes($row_rsStatusReport['subject']));
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
<script src="../js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="../css/datepicker.css"/>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
foreach ($params as $param) {
if (stristr($param, "pageNum_rsCustomerTypes") == false && stristr($param, "totalRows_rsCustomerTypes") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsCustomerTypes = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsCustomerTypes = sprintf("&totalRows_rsCustomerTypes=%d%s", $totalRows_rsCustomerTypes, $queryString_rsCustomerTypes);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Customer Types");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
buildHeaderNEW("customerType", null, "customerTypes", "Customer Types", "Add a Customer Type");
?>
<div align="center">
<div class="casing" align="left">
<?php
login();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsConnTypes") == false && stristr($param, "totalRows_rsConnTypes") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsConnTypes = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsConnTypes = sprintf("&totalRows_rsConnTypes=%d%s", $totalRows_rsConnTypes, $queryString_rsConnTypes);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Connection Types");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
buildHeader("connType", null, "connTypes", "Connection Types", "Add a Connection Type");
?>
<div align="center">
<div class="casing" align="left">
<?php
login();
$varEmployee = (isset($_SESSION['employee']) ? addslashes($_SESSION['employee']) : "1");
$query_rsEmployeeInfo = "SELECT employeeID, firstName, displayName FROM employees WHERE employeeID = $varEmployee";
$rsEmployeeInfo = $conn->query($query_rsEmployeeInfo) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
$row_rsEmployeeInfo = $rsEmployeeInfo->fetch_assoc();
$totalRows_rsEmployeeInfo = $rsEmployeeInfo->num_rows;
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--
<meta http-equiv="refresh" content="30; URL=../userPortals/myPortal.php"/>
-->
<title><?php
buildTitle("My Portal");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<?php
build_navbar($conn, 0);
?>
</header>
foreach ($params as $param) {
if (stristr($param, "pageNum_rsApps") == false && stristr($param, "totalRows_rsApps") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsApps = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsApps = sprintf("&totalRows_rsApps=%d%s", $totalRows_rsApps, $queryString_rsApps);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Applications");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
buildHeaderNEW("application", null, "applications", "Applications", "Add an Application");
?>
<div align="center">
<div class="casing" align="left">
<?php
login();
$rsApps = $conn->query($query_rsApps) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
$row_rsApps = $rsApps->fetch_assoc();
$totalRows_rsApps = $rsApps->num_rows;
//select employees for employee filter list
$query_rsEngineers = "SELECT employeeID, displayName FROM employees WHERE employees.engineer ='y' ORDER BY displayName ASC";
$rsEngineers = $conn->query($query_rsEngineers);
$row_rsEngineers = $rsEngineers->fetch_assoc();
$totalRows_rsEngineers = $rsEngineers->num_rows;
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Change Requests");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<?php
build_navbar($conn, 1);
?>
</header>
$query_rsCategories = "SELECT reportTypeID, reportType FROM reporttypes ORDER BY reportType ASC";
$rsCategories = $conn->query($query_rsCategories) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
}
//Engineers
$query_rsAssignedTo = "SELECT employeeID, displayName FROM employees WHERE engineer='y' AND active='t' ORDER BY displayName ASC";
$rsAssignedTo = $conn->query($query_rsAssignedTo) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
//Customers
$query_rsCustomers = "SELECT customerID, customer FROM customers ORDER BY customer ASC";
$rsCustomers = $conn->query($query_rsCustomers) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("a Support Request");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
<script src="../js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="../css/datepicker.css"/>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<?php
foreach ($params as $param) {
if (stristr($param, "pageNum_rsEmployees") == false && stristr($param, "totalRows_rsEmployees") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsEmployees = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsEmployees = sprintf("&totalRows_rsEmployees=%d%s", $totalRows_rsEmployees, $queryString_rsEmployees);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Employees");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link href="../../inc/menu.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/menu.js"></script>
<script type="text/javascript" src="../../inc/js/js.js"></script>
<script type="text/javascript" src="../../inc/js/calendarDateInput2.js"></script>
</head>
<body>
<?php
//buildMenu();
?>
<script type="text/javascript">
$varEmployee_rsEmployeeXSRs = "1";
if (isset($_GET['employee'])) {
$varEmployee_rsEmployeeXSRs = get_magic_quotes_gpc() ? $_GET['employee'] : addslashes($_GET['employee']);
}
mysql_select_db($database_connProdOps, $connProdOps);
$query_rsEmployeeXSRs = sprintf("SELECT statusReportID, subject, endTime, employeeID, endDate, endTime, maintenanceNotifID FROM statusreports WHERE employeeID=%s ORDER BY endDate, endTime ASC", $varEmployee_rsEmployeeXSRs);
$rsEmployeeXSRs = mysql_query($query_rsEmployeeXSRs, $connProdOps) or die(mysql_error());
$row_rsEmployeeXSRs = mysql_fetch_assoc($rsEmployeeXSRs);
$totalRows_rsEmployeeXSRs = mysql_num_rows($rsEmployeeXSRs);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("an Employee");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
if ($_GET['function'] == "add") {
buildHeaderNEW("employee", "Employees", "employee", "Add an Employee", null);
} elseif ($_GET['function'] == "update") {
buildHeaderNEW("employee", "Employees", "employee", "Update Employee Information", "Add an Employee");
} else {
buildHeaderNEW("employee", "Employees", "employee", "View an Employee", "Add an Employee");
$insertSQL = sprintf("INSERT INTO datacenters (datacenter, notes) VALUES (%s, %s)", GetSQLValueString($_POST['datacenter'], "text"), GetSQLValueString($_POST['notes'], "text"));
mysql_select_db($database_connProdOps, $connProdOps);
$Result1 = mysql_query($insertSQL, $connProdOps) or die(mysql_error());
$insertGoTo = "datacenter.php?function=add&sent=y";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= strpos($insertGoTo, '?') ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("a Datacenter");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
if ($_GET['function'] == "add") {
buildHeaderNEW("datacenter", "Datacenters", "datacenter", "Add Datacenter", null);
} elseif ($_GET['function'] == "update") {
buildHeaderNEW("datacenter", "Datacenters", "datacenter", "Update Datacenter", "Add a Datacenter");
} else {
buildHeaderNEW("datacenter", "Datacenters", "datacenter", "View Datacenter", "Add a Datacenter");
$insertSQL = sprintf("INSERT INTO customertypes (customerTypeID, customerType, notes) VALUES (%s, %s, %s)", GetSQLValueString($_POST['customerTypeID'], "int"), GetSQLValueString($_POST['customerType'], "text"), GetSQLValueString($_POST['notes'], "text"));
mysql_select_db($database_connProdOps, $connProdOps);
$Result1 = mysql_query($insertSQL, $connProdOps) or die(mysql_error());
$insertGoTo = "customerType.php?function=add&sent=y";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= strpos($insertGoTo, '?') ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("a Customer Type");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
if ($_GET['function'] == "add") {
buildHeader("customerType", "Customer Types", "customerType", "Add a Customer Type", null);
} elseif ($_GET['function'] == "update") {
buildHeader("customerType", "Customer Types", "customerType", "Update Customer Type", "Add a Customer Type");
} else {
buildHeader("customerType", "Customer Types", "customerType", "View a Customer Type", "Add a Customer Type");
$varCountry_rsCountries = "1";
if (isset($_GET['country'])) {
$varCountry_rsCountries = get_magic_quotes_gpc() ? $_GET['country'] : addslashes($_GET['country']);
}
mysql_select_db($database_connProdOps, $connProdOps);
$query_rsCountries = sprintf("SELECT zone, countryCode, countryISO, country, digits, countryID, notes FROM countries WHERE countryID = %s", $varCountry_rsCountries);
$rsCountries = mysql_query($query_rsCountries, $connProdOps) or die(mysql_error());
$row_rsCountries = mysql_fetch_assoc($rsCountries);
$totalRows_rsCountries = mysql_num_rows($rsCountries);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("a Country");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
if ($_GET['function'] == "add") {
buildHeaderNEW("country", "Countries", "country", "Add a Country", null);
} elseif ($_GET['function'] == "update") {
buildHeaderNEW("country", "Countries", "country", "Update a Country", "Add a Country");
} else {
buildHeaderNEW("country", "Countries", "country", "View a Country", "Add a Country");
if ($my_get['function'] != "add") {
$varRFA_rsRFA = "-1";
if (isset($my_get['rfa'])) {
$varRFA_rsRFA = addslashes($my_get['rfa']);
}
$query_rsRFA = "SELECT changerequests.changeRequestID, employees1.displayName as submittedBy, employees2.displayName as reviewer, changerequests.reviewedBy" . ", DATE_FORMAT(dateSubmitted, '%Y-%m-%d') AS dateSubmitted, TIME_FORMAT(timeSubmitted,'%k:%i') AS timeSubmitted, changerequests.summary, changerequests.description" . ", changerequests.status, changerequests.comments, changerequests.requestOrigin, changerequests.requestOriginID, changerequests.flagged" . ", DATE_FORMAT(windowStartDate, '%Y-%m-%d') AS windowStartDate, TIME_FORMAT(windowStartTime,'%k:%i') AS windowStartTime" . ", DATE_FORMAT(windowEndDate, '%Y-%m-%d') AS windowEndDate, TIME_FORMAT(windowEndTime,'%k:%i') AS windowEndTime, changerequests.applicationID, applications.application" . ", changerequests.subapplicationID, subapplications.subapplication, changerequests.layerID, layers.layer, changerequests.risk" . " FROM changerequests" . " LEFT JOIN employees as employees1 ON changerequests.submittedBy=employees1.employeeID" . " LEFT JOIN employees AS employees2 ON changerequests.reviewedBy=employees2.employeeID" . " LEFT JOIN applications ON changerequests.applicationID=applications.applicationID" . " LEFT JOIN subapplications ON changerequests.subapplicationID=subapplications.subapplicationID" . " LEFT JOIN layers ON changerequests.layerID=layers.layerID WHERE changerequests.changeRequestID = {$varRFA_rsRFA}";
$rsRFA = $conn->query($query_rsRFA);
$row_rsRFA = $rsRFA->fetch_assoc();
$totalRows_rsRFA = $rsRFA->num_rows;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("an RFC");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
<script src="../js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="../css/datepicker.css"/>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<?php
$query_rsAnyPEforMN = "SELECT projecttasksxmodules.projectTasksXmoduleID, projecttasksxmodules.projectID, projecttasksxmodules.projectTaskID, projecttasksxmodules.module" . ", projecttasksxmodules.moduleID" . " FROM projecttasksxmodules WHERE projecttasksxmodules.moduleID = {$varModuleID_rsAnyPEforMN} AND projecttasksxmodules.module='maintenance'";
$rsAnyPEforMN = $conn->query($query_rsAnyPEforMN) or die($conn->error);
$row_rsAnyPEforMN = $rsAnyPEforMN->fetch_assoc();
$totalRows_rsAnyPEforMN = $rsAnyPEforMN->num_rows;
}
//Select engineers
$query_rsEngineers = "SELECT employeeID, engineer, lastName, displayName FROM employees WHERE employees.engineer='y' AND employees.active='t' ORDER BY displayName ASC";
$rsEngineers = $conn->query($query_rsEngineers) or die($conn->error);
$row_rsEngineers = $rsEngineers->fetch_assoc();
$totalRows_rsEngineers = $rsEngineers->num_rows;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Maintenance Notification");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
<script src="../js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="../css/datepicker.css"/>
<!--
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"/>
-->
</head>
foreach ($params as $param) {
if (stristr($param, "pageNum_rsDatacenters") == false && stristr($param, "totalRows_rsDatacenters") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsDatacenters = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsDatacenters = sprintf("&totalRows_rsDatacenters=%d%s", $totalRows_rsDatacenters, $queryString_rsDatacenters);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Datacenters");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
buildHeaderNEW("datacenter", null, "datacenters", "Datacenters", "Add a Datacenter");
?>
<div align="center">
<div class="casing" align="left">
<?php
login();
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title><?php
echo buildTitle($title);
?>
</title>
<link rel="stylesheet" href="//cdn.iaero.me/bootstrap/3.3.6/css/bootstrap.min.css">
<link rel="stylesheet" href="//cdn.iaero.me/fontawesome/4.5.0/css/font-awesome.min.css">
<link rel="stylesheet" href="/assets/css/main.site.css">
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<?php
if ($showNav) {
?>
<nav class="navbar navbar-inverse navbar-static-top" role="navigation">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
foreach ($params as $param) {
if (stristr($param, "pageNum_fsProtocols") == false && stristr($param, "totalRows_fsProtocols") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_fsProtocols = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_fsProtocols = sprintf("&totalRows_fsProtocols=%d%s", $totalRows_fsProtocols, $queryString_fsProtocols);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Protocols");
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="../../inc/global.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="../images/logos/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../../inc/js/js.js"></script>
</head>
<body>
<?php
buildHeaderNEW("protocol", null, "protocols", "Protocols", "Add a Protocol");
?>
<div align="center">
<div class="casing" align="left">
<?php
login();
function getTitleData($id)
{
// Queries the DB for the ID number. Returns all the title info.
global $con;
try {
$sql = "SELECT * FROM `titles` WHERE `ID` = (:id)";
$sql = $con->prepare($sql);
$sql->bindParam(':id', $_GET['id']);
$sql->execute();
buildTitle($sql->fetch());
} catch (PDOException $e) {
echo $e->getMessage();
}
}
if (isset($my_get['ticket'])) {
$where = " AND statusreports.magicTicket={$my_get['ticket']}";
$filter_text = " <span class='glyphicon glyphicon-filter'></span> Filter: <em>Ticket=</em>{$my_get['ticket']}\n";
}
if (isset($my_get['case'])) {
$where = " AND statusreports.wrm={$my_get['case']}";
$filter_text = " <span class='glyphicon glyphicon-filter'></span> Filter: <em>Case#</em>{$my_get['case']}\n";
}
$query_rsStatusReports = "SELECT statusreports.statusReportID, statusreports.applicationID, statusreports.customerID, statusreports.employeeID, applications.application" . ", customers.customer, employees.displayName, statusreports.magicTicket, statusreports.subject, statusreports.wrm, statusreports.reportTypeID, reporttypes.reportType" . ", DATE_FORMAT(endDate, '%m/%d/%Y') as endDate" . " FROM applications, customers, statusreports, employees, reporttypes" . " WHERE statusreports.applicationID=applications.applicationID" . " AND statusreports.customerID=customers.customerID" . " AND statusreports.reportTypeID=reporttypes.reportTypeID" . " AND statusreports.employeeID=employees.employeeID" . " %%where%%" . " ORDER BY statusreports.endDate DESC, statusreports.endTime DESC";
$rsStatusReports = $conn->query(str_replace('%%where%%', $where, $query_rsStatusReports)) or die("<div class='alert alert-danger' role='alert'>{$conn->error}</div>");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
buildTitle("Status Reports");
?>
</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<?php
build_header();
?>
</head>
<body class="skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<?php
build_navbar($conn, 2);
?>
