function showAssignment($link, $table, $option = "ALL")
{
// show all assignments
$query = "select * from {$table} order by Task";
$statement = $link->prepare($query);
$rc = $statement->execute();
if (!$rc) {
$errNum = mysqli_errno($link);
$errMsg = mysqli_error($link);
print " ERROR - could not register selection: ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n";
exit;
}
$statement->bind_result($task, $person);
print "<table>\n";
print "<tr><th> Course </th><th> Type </th><th> Effort </th>";
print "<th> TA type </th><th> Person </th><th> Id </th></tr>\n";
$iF = 0;
$iP = 0;
while ($statement->fetch()) {
$myTask = new TeachingTask($task);
$display = 0;
if ($option == "ALL") {
$display = 1;
} else {
if ($option == "TA" && $myTask->isTa() && $person != "" && $person != "*****@*****.**") {
$display = 1;
} else {
if ($option == "Unassigned" && ($person == "" || $person == "*****@*****.**")) {
$display = 1;
}
}
}
if ($display) {
print "<tr><td> " . "<a href=\"/showTaskSummary?number=" . $myTask->getCourse() . "\">" . $myTask->getCourse() . "</a>" . " </td><td>" . $myTask->getType() . " </td><td>" . $myTask->getEffort() . " </td><td>" . $myTask->getTaType() . " </td><td>" . "<a href=\"/showTaSummary?email=" . $person . "\">" . $person . "</a>" . " </td><td>" . $myTask->generateId() . " </td></tr>\n";
if ($myTask->isTa() && $myTask->getEffort() == 'full') {
$iF = $iF + 1;
}
if ($myTask->isTa() && $myTask->getEffort() == 'half') {
$iF = $iF + 0.5;
}
if ($myTask->isTa() && $myTask->getEffort() == 'part') {
$iP = $iP + 1;
}
}
}
print "</table>";
print "<p> TA openings ({$option}): <b>{$iF}</b> (full time) <b>{$iP}</b> (part time).</p><br> \n";
}
