downloadJobResultsForRunId($_REQUEST["run_id"], $view);
}
exit;
break;
case "jobstatus":
$view = $_REQUEST["view"] == "1" ? true : false;
if (is_numeric($_REQUEST["job_id"])) {
downloadJobStatus($_REQUEST["job_id"], $view);
}
exit;
break;
case "jobcontrol":
switch ($_REQUEST["type"]) {
case "delete":
if (is_numeric($_REQUEST["job_id"])) {
deleteJob($_REQUEST["job_id"]);
header("Location: " . $GLOBALS['contextpath'] . "/user/" . $_SESSION['username'] . "/");
}
exit;
break;
case "reset":
if (is_numeric($_REQUEST["job_id"])) {
resetJob($_REQUEST["job_id"]);
header("Location: " . $GLOBALS['contextpath'] . "/job/" . $_REQUEST["job_id"] . "/");
}
case "viewall":
header("Location: " . $GLOBALS['contextpath'] . "/user/" . $_SESSION['username'] . "/");
break;
default:
getJobs();
exit;
$retTable .= "<tr><td align='center'>" . $row[ordNo] . "</td><td align='center'>" . $row[deliAddr] . "</td></tr>";
}
$retTable .= '</table>';
echo $retTable;
return;
} else {
if (isset($_POST[distNo])) {
if (editJob($_POST[jobNo], null, $_POST[distNo])) {
echo "true";
} else {
echo "false";
}
return;
} else {
if (isset($_POST['remove'])) {
if (deleteJob($_POST[jobNo])) {
echo "true";
} else {
echo "false";
}
return;
}
}
}
}
}
if (isset($_POST["district"], $_POST["repeatTime"])) {
if (isset($_POST["weekDay"])) {
$typeID = UserControl::getUserNo();
$typeID = getInfo($typeID)["ID"];
$thisWeek = date("w");
$start_time2 = $_POST["start_time2"];
$end_time2 = $_POST["end_time2"];
} else {
$start_time2 = "";
$end_time2 = "";
}
if ($_POST["jobGroup"] != "") {
$group = $_POST["jobGroup"];
} else {
$group = $_POST["dep_id"];
}
addJob($_POST["job_name"], $_POST["start_time"], $_POST["end_time"], $start_time2, $end_time2, $_POST["job_hours"], $group);
}
//delete job
if ($_POST["procedure"] == "Delete") {
deleteJob($_POST["jobid"]);
}
//############## Department Functions ################
//add category
if ($_POST["procedure"] == "ADD_DEPARTMENT") {
addDepartment($_POST["dep_name"]);
//delete category
} else {
if ($_POST["procedure"] == "DELETE_DEPARTMENT") {
deleteDepartment($_POST["dep_id"]);
//edit category
} else {
if ($_POST["procedure"] == "EDIT_DEPARTMENT") {
editDepartment($_POST["dep_id"], $_POST["dep_newName"]);
}
}
<?php
include "header.php";
?>
<?php
if (isset($_POST['deleteSelected'])) {
echo "<h3>Deleting</h3>";
$delList = $_POST['delList'];
foreach ($delList as $jobNo) {
echo "{$jobNo} is selected";
deleteJob($jobNo);
}
} elseif (isset($_POST['retrySelected'])) {
echo "<h3>Re-Queueing</h3>";
$delList = $_POST['delList'];
foreach ($delList as $jobNo) {
echo "{$jobNo} is selected";
retryJob($jobNo);
}
} else {
echo "<h1>Townguide Queue Administration</h2>\n";
print "<h3>Select Jobs to Delete </h3>";
$dbconn = pg_connect("host=localhost dbname=townguide user=www password=1234") or die('Could not connect: ' . pg_last_error());
$query = 'SELECT jobno,status,title FROM queue order by jobno desc';
$result = pg_query($query) or die('Query failed: ' . pg_last_error());
$resultCount = pg_num_rows($result);
echo "<p>There are " . $resultCount . " jobs in the queue.</p>";
echo "<form action='admin.php' method='POST'>";
echo "<input type='submit' value='Delete Selected Jobs' name='deleteSelected'>";
echo "<input type='submit' value='Retry Selected Jobs' name='retrySelected'>";
include "inc/departments.inc.php";
include "inc/employees.inc.php";
include "inc/locations.inc.php";
$db_conn = databaseConnect();
// Connect to DB
// Functions that do NOT generate content to browser
// This is necessary to escape the 'warning headers already
switch (getCurrentAction()) {
case "insertJob":
addJob();
break;
case "updateJob":
updateJob();
break;
case "deleteJob":
deleteJob();
break;
case "insertDepartment":
addDepartment();
break;
case "updateDepartment":
updateDepartment();
break;
case "deleteDepartment":
deleteDepartment();
break;
case "insertEmployee":
addEmployee();
break;
case "updateEmployee":
updateEmployee();
