function getAssignments($link, $table, $divisions) { // initialize data $semesterData = array(); foreach ($divisions as $index => $division) { $semesterData[$division] = 0; } // show all assignments $query = "select t.Task, t.Person, s.Division from {$table} as t inner join Students as s on s.Email = t.Person order by t.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, $division); while ($statement->fetch()) { $weight = 0; $myTask = new TeachingTask($task); if ($myTask->isTa() && $myTask->getEffort() == 'full') { $weight = 1.0; } if ($myTask->isTa() && $myTask->getEffort() == 'half') { $weight = 0.5; } $semesterData[$division] += $weight; } $statement->close(); return $semesterData; }
$errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not register selection: ErrNo=" . $errNum . ": " . $errMsg . "\n"; exit; } $statement->bind_result($Email, $pref1, $pref2, $pref3); $empty = true; print 'Your registered TA preferences are:'; print ' '; while ($statement->fetch()) { $empty = false; print '</p><p>'; $task1 = new TeachingTask($pref1); print ' 1: '; $task1->printTaTask(); // print '<br>'; $task2 = new TeachingTask($pref2); print ' 2: '; $task2->printTaTask(); // print '<br>'; $task3 = new TeachingTask($pref3); print ' 3: '; $task3->printTaTask(); // print '<br>'; print '</p> '; } if ($empty) { print 'EMPTY.</p>'; } print '</article>' . "\n"; include "app/views/ta/footer.php";
$db = Dbc::getReader(); $students = $db->query("select * from Students where Email = '{$email}'"); $student = ''; foreach ($students as $key => $row) { $student = Student::fromRow($row); } // connect to our database $link = getLink(); $tables = findTables($link, 'Assignments'); print '<article class="page">' . "\n"; print "<hr>\n"; //print "<h1>TA Summary Page</h1>\n"; $student->printSummary(); print "\n"; print "<hr>\n"; // loop through all assignment tables and find our candidate print '<ul>'; foreach ($tables as $key => $table) { $query = "select * from " . $table . " where Person='" . $email . "'"; $statement = $link->prepare($query); $statement->execute(); $statement->bind_result($taskId, $person); while ($statement->fetch()) { print '<li>'; $task = new TeachingTask($taskId); $task->printTaskWithLink(); } } print '</ul>'; print '</article>' . "\n"; include "app/views/admin/footer.php";
function printTeachers($link, $table, $courses) { // show all assignments $query = "select Person,Task from {$table} where Task like '%-Lec-%' 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($email, $task); $list = ""; while ($statement->fetch()) { $myTask = new TeachingTask($task); $number = $myTask->getCourse(); foreach ($courses as $key => $course) { if ($course == $number) { print " {$course} --> {$email}<br>\n"; if ($list == "") { $list = "{$email}"; } else { $list = "{$list},{$email}"; } break; } //else // print " NO MATCH -- Course: $course --> $email<br>\n"; } } print " ALL: {$list}<br>\n"; return; }
print "<th> Email </th>"; print "<th> Preference 1 </th>"; print "<th> Preference 2 </th>"; print "<th> Preference 3 </th>"; print "</tr>\n"; $empty = true; foreach ($preferences as $email => $preference) { $empty = false; if (array_key_exists($email, $students)) { $student = $students[$email]; $name = "{$student->lastName}, {$student->firstName}"; } else { $name = "<b>NO NAME FOUND IN DATABASE - FIX IT!</b>"; } $task1 = new TeachingTask($preference->pref1); $task2 = new TeachingTask($preference->pref2); $task3 = new TeachingTask($preference->pref3); print "<tr>"; print "<td> {$name} </td>"; print "<td> {$email} </td>"; print "<td> " . $task1->getTaTask() . " </td>"; print "<td> " . $task2->getTaTask() . " </td>"; print "<td> " . $task3->getTaTask() . " </td>"; print "</tr>\n"; } print "</table>\n"; if ($empty) { print ' No preferences found in this term.'; } print '</article>' . "\n"; include "app/views/admin/footer.php";
print '<article class="page">' . "\n"; print "<hr>\n"; print "<h1>Course Task Summary Page</h1>\n<h2>{$number} {$courseName}</h2>"; print "<hr>\n"; print '<table>'; foreach ($tables as $key => $table) { $query = "select * from " . $table . " where Task like '%-" . $number . "-Ta%'"; $statement = $link->prepare($query); $statement->execute(); $statement->bind_result($taskId, $person); while ($statement->fetch()) { $name = ""; if (!isset($names[$person])) { if ($person == '') { $name = 'NOT ASSIGNED'; } else { print " person not found: {$person}<br>\n"; } } else { $name = $names[$person]; } // print the result print '<tr><td>' . $name . ' </td><td> ' . '<a href="/showTaSummary?email=' . $person . '">' . $person . '</a> </td><td>'; $task = new TeachingTask($taskId); $task->printTask(); print "</td></tr>\n"; } } print '</table>'; print '</article>' . "\n"; include "app/views/admin/footer.php";
// find the active Assignment table $active = findActiveTable($link, 'Assignments'); print "Active tables: {$tasTable} (TAs), {$active['0']} (Assignments)</p>"; // start the form print '<form class="ta" action="/register" method="post">' . "\n"; // start the table print '<p>' . "\n"; print '<table>' . "\n"; // generate the options $options = array(); $query = "select * from {$active['0']} order by Task"; $statement = $link->prepare($query); $statement->execute(); $statement->bind_result($task, $email); while ($statement->fetch()) { $myTask = new TeachingTask($task); if ($myTask->isTa() && $myTask->getEffort() == 'full') { $option = $myTask->getTaTask(); $find = array_search($option, $options); if (!$find) { $options[$task] = $option; } } } // First preference print '<tr><td>What is your first preference?</td><td><select class="ta" name="pref1">' . "\n"; print ' <option value="">Select Preference 1</option>' . "\n"; foreach ($options as $key => $option) { print "<option value=\"" . $key . "\"> {$option} </option>"; } print '</select></td></tr>' . "\n";