/** * 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); ?>