/**
* Returns attendance info about the event whose eventNo matches $eventNo in the form of rows
**/
function getEventAttendanceRows($eventNo)
{
global $SEMESTER, $CHOIR;
$eventRows = "\n\t<tr class='topRow'>\n\t\t<td class='cellwrap'>Name</td>\n\t\t<td class='cellwrap'>Attended</td>\n\t\t<td class='cellwrap'>Minutes Late</td>\n\t\t<td class='cellwrap'>Should Attend</td>\n\t\t<td class='cellwrap'>Did Attend</td>\n\t\t<td class='cellwrap'>Confirmed</td>\n\t</tr>";
$sections = array();
$sect = mysql_query("select `id`, `name` from `sectionType` where `id` > '0' and `choir` = '{$CHOIR}' order by `id` asc");
while ($s = mysql_fetch_array($sect)) {
$sections[$s["id"]] = $s["name"];
}
$unassigned = mysql_num_rows(mysql_query("select * from `member` where `section` = 0"));
if ($unassigned) {
$sections[0] = "<span style='color: red'>Not assigned to any section</span>";
}
foreach ($sections as $num => $name) {
$eventRows .= "<tr><td colspan=6><b>{$name}</b></td></tr>";
$members = mysql_query("select `member`.`email` from `member`, `activeSemester` where `member`.`email` = `activeSemester`.`member` and `activeSemester`.`semester` = '{$SEMESTER}' and `activeSemester`.`choir` = '{$CHOIR}' and `activeSemester`.`section` = '{$num}' order by `member`.`lastName` asc");
while ($member = mysql_fetch_array($members)) {
$eventRows .= '<tr id="attends_' . $member['email'] . '_' . $eventNo . '">' . getSingleEventAttendanceRow($eventNo, $member['email']) . '</tr>';
}
}
return $eventRows;
}
if ($action == "should") {
$field = "shouldAttend";
} else {
if ($action == "did") {
$field = "didAttend";
}
}
ensure_attends($memberID, $eventNo);
mysql_query("update `attends` set `{$field}` = '{$value}' where `memberID` = '{$memberID}' and `eventNo` = '{$eventNo}'");
} else {
if ($action == "late") {
ensure_attends($memberID, $eventNo);
mysql_query("update `attends` set `minutesLate` = '{$value}' where `memberID` = '{$memberID}' and `eventNo` = '{$eventNo}'");
} else {
if ($action == "confirmed") {
ensure_attends($memberID, $eventNo);
mysql_query("update `attends` set `confirmed` = '{$value}' where `memberID` = '{$memberID}' and `eventNo` = '{$eventNo}'");
} else {
if ($action == "excuse_all") {
mysql_query("update `attends` set `shouldAttend` = '0' where `eventNo` = '{$eventNo}' and `confirmed` = '0'");
} else {
die("Unknown action");
}
}
}
}
//get the updated attendance info for this one attends relationship
echo getSingleEventAttendanceRow($eventNo, $memberID);
?>
