function basic_info($person)
{
global $officer, $uber;
$member = mysql_fetch_array(mysql_query("select * from `member` where `email` = '{$person}'"));
$about = getMemberAttribute('about', $person);
if ($about == '') {
$about = "I don't have a quote";
}
$html .= "<img class='profile' src='" . profilePic($person) . "'>";
$html .= "<h3><span style='font-weight: normal; padding-right: 8pt'>" . implode(" and ", positions($person)) . " </span> " . completeNameFromEmail($person) . "</h3>";
$html .= "<div class='about'>\"{$about}\"</div>";
$html .= "<table style='width: initial'><tr><td style='width: 40%; vertical-align: top'>";
$html .= "<table>";
$html .= "<tr><td class='key'>Email</td><td><a href='mailto:{$person}'>{$person}</a></td></tr>";
$html .= "<tr><td class='key'>Phone</td><td><a href='tel:" . phoneNumber($person) . "'>" . phoneNumber($person) . "</a></td></tr>";
$html .= "<tr><td class='key'>Section</td><td>" . sectionFromEmail($person, 1) . "</td></tr>";
$html .= "<tr><td class='key'>Car</td><td>" . rosterProp($member, "Car") . "</td></tr>";
$html .= "<tr><td class='key'>Major</td><td>" . getMemberAttribute('major', $person) . "</td></tr>";
$html .= "<tr><td class='key'>Year at Tech</td><td>" . getMemberAttribute('techYear', $person) . "</td></tr>";
$sql = mysql_query("select `semester`.`semester` from `activeSemester`, `semester` where `activeSemester`.`member` = '{$person}' and `activeSemester`.`semester` = `semester`.`semester` order by `semester`.`beginning` desc");
$activeSemesters = '';
while ($row = mysql_fetch_array($sql)) {
$activeSemesters .= "<span class='label'>" . $row['semester'] . "</span> ";
}
if ($officer) {
$html .= "<tr><td class='key'>Active</td><td>{$activeSemesters}</td></tr>";
$html .= "</table></td><td style='width: 40%; vertical-align: top'><table>";
$html .= "<tr><td class='key'>Enrollment</td><td>" . rosterProp($member, "Enrollment") . "</td></tr>";
if ($uber || hasPosition($USER, "Treasurer")) {
$html .= "<tr><td class='key'>Balance</td><td>" . rosterProp($member, "Balance") . "</td></tr>";
$html .= "<tr><td class='key'>Dues</td><td>" . rosterProp($member, "Dues") . "</td></tr>";
$html .= "<tr><td class='key'>Tie</td><td>" . rosterProp($member, "Tie") . "</td></tr>";
}
if ($uber) {
$html .= "<tr><td class='key'>Gigs</td><td>" . rosterProp($member, "Gigs") . "</td></tr>";
$html .= "<tr><td class='key'>Score</td><td>" . rosterProp($member, "Score") . "</td></tr>";
$html .= "<tr><td class='key'>Actions</td><td><button class='btn action' onclick='chgusr(\"{$person}\")'>Log in as</button><button class='btn action' style='color: red' onclick='delusr(\"{$person}\")'>Delete</button></td></tr>";
}
}
$html .= "</table></td></tr></table>";
return $html;
}
function active_semesters($memberID)
{
global $CHOIR;
if (!$CHOIR) {
die("Choir is not set");
}
$table = "<style>table.semesters { width: auto; } table.semesters td { padding: 2px 10px; } select.section { margin-bottom: 0px; width: 10em; }</style><table class='semesters'><tr><th>Semester</th><th>Status</th><th>Section</th><th>Score</th></tr>";
$query = mysql_query("select `semester` from `semester` order by `beginning` asc");
while ($result = mysql_fetch_array($query)) {
$activebtn = 0;
$semester = $result['semester'];
$query1 = mysql_query("select `enrollment` from `activeSemester` where `member` = '{$memberID}' and `semester` = '{$semester}' and `choir` = '{$CHOIR}'");
$active = mysql_num_rows($query1);
if ($active) {
$result1 = mysql_fetch_array($query1);
$enrollment = $result1['enrollment'];
if ($enrollment == "club") {
$activebtn = 1;
} else {
if ($enrollment == "class") {
$activebtn = 2;
} else {
die("Invalid enrollment state");
}
}
}
$table .= "<tr data-semester='{$semester}'><td>{$semester}</td><td><div class='btn-group' data-toggle='buttons-radio'>" . "<button class='btn btn-small semesterbutton" . ($activebtn == 0 ? ' active' : '') . "' data-val='0'>Inactive</button>" . "<button class='btn btn-small semesterbutton" . ($activebtn == 1 ? ' active' : '') . "' data-val='1'>Club</button>" . "<button class='btn btn-small semesterbutton" . ($activebtn == 2 ? ' active' : '') . "' data-val='2'>Class</button>" . "</div></td><td>" . dropdown(sections(), "section", $active ? sectionFromEmail($memberID, false, $semester) : 0, !$active) . "</td>" . "<td>" . ($active ? "<span>" : "<span style='color: gray'>") . attendance($memberID, 0, $semester) . "</span></td></tr>";
}
$table .= "</table>";
return $table;
}
function attendancePermission($email, $event)
{
if (isOfficer($email) || canEditEvents($email)) {
return true;
}
if (!hasPosition($email, "Section Leader")) {
return false;
}
$result = mysql_fetch_array(mysql_query("select `section`, `type` from `event` where `eventNo` = '{$event}'"));
if ($result['type'] != 'sectional') {
return false;
}
$eventSection = $result['section'];
if ($eventSection == 0) {
return true;
}
if (sectionFromEmail($email) == $eventSection) {
return true;
}
return false;
}
<?php require_once './functions.php'; echo dropdown(sections(mysql_real_escape_string($_POST['choir'])), 'section', $USER ? sectionFromEmail($user) : ''); ?>
