if ($row = $result->fetch_assoc()) {
$assignName = $row["FirstName"] . " " . $row["LastName"];
}
}
if ($author != "") {
$sql = "SELECT FirstName, LastName FROM Users WHERE UserID = " . $author;
$result = SqlQuery($loc, $sql);
if ($row = $result->fetch_assoc()) {
$authorName = $row["FirstName"] . " " . $row["LastName"];
}
}
if (isset($_SESSION["ERROR"])) {
$error_msg = $_SESSION["ERROR"];
$sql = "SELECT * FROM ActiveWorkOrders";
} else {
$sql = CreateFilterSQL($filters);
}
/* lib function that returns filtering SQL Query */
//print $sql; /*used for testing*/
$filterresult = SqlQuery($loc, $sql);
$pagetitle = "";
$pagetext = "";
if ($sql != "") {
if ($view == "full") {
$tableheader = array("WO", "Title", "Receiving IPT", "DateNeeded", "CAP", "AP", "AS", "F ", "C");
} else {
$tableheader = array("WO", "Title", "Receiving IPT", "DateNeeded");
}
$tabledata = array();
while ($row = $filterresult->fetch_assoc()) {
$wid = $row["WID"];
}
if ($_SERVER["REQUEST_METHOD"] == "GET") {
/*access values stored in session */
if (isset($_SESSION["FILTERS"])) {
$view = $_SESSION["FILTERS"]["View"];
$priority = $_SESSION["FILTERS"]["Priority"];
$receiver = $_SESSION["FILTERS"]["ReceivingTeam"];
$filters = $_SESSION["FILTERS"];
} else {
$view = "simple";
$priority = "";
$receiver = "";
$filters = array("View" => "simple", "Priority" => "", "ReceivingTeam" => "");
}
/* lib function that returns filtering SQL Query */
$sql = CreateFilterSQL($filters, $nlimit);
$result = SqlQuery($loc, $sql);
$pagetitle = "";
$pagetext = "";
if ($sql != "") {
/*set tableheader */
if ($view == "full") {
$tableheader = array("WO", "Title", "Receiving IPT", "DateNeeded", "CAP", "AP", "AS", "F ", "C");
} else {
$tableheader = array("WO", "Title", "Receiving IPT", "DateNeeded");
}
/*set table data */
$tabledata = array();
$ncount = 0;
while ($row = $result->fetch_assoc()) {
$isResult = 1;
