function gigBlock($userEmail)
{
global $SEMESTER;
$count = attendance($userEmail, 3);
$result = mysql_fetch_array(mysql_query("select `gigreq` from `semester` where `semester` = '{$SEMESTER}'"));
$gigreq = $result['gigreq'];
if ($count < $gigreq) {
$precentProgress = floor(100 * $count / $gigreq);
} else {
$precentProgress = 100;
}
return "<div class='btn btn-danger' id='notificationsButton'>Enable Notifications</div>\n\t\t<p>You have attended {$count} of {$gigreq} required volunteer gigs:</p>\n\t\t<div class='progress progress-striped active'>\n\t\t<div class='bar' style='width: " . $precentProgress . "%;'></div>\n\t\t</div>";
}
}
//get members
$q = "SELECT * FROM members WHERE mActive=1 order by mLName";
$result = $db->query($q);
while ($data = $result->fetch_object()) {
$members[] = $data;
}
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename='meeting-attendance'.csv");
header("Pragma: no-cache");
header("Expires: 0");
echo replace($_POST['name']) . ',,,,,,,,,,' . "\n";
echo 'First Name, LastName, Company, Email, Phone, Address, Attending?, Meal Choice';
echo "\n";
foreach ($members as $member) {
$att = attendance($member->mId);
$line = array(replace($member->mFname), replace($member->mLname), replace($member->mCompanyName), replace($member->mEmail), replace($member->mPhone), replace($member->mAddress1 . ' ' . $member->mAddress2 . ' ' . $member->mCity . ' ' . $member->mState . ' ' . $member->mZip), $att->attending, replace($att->meal));
echo implode(',', $line) . "\n";
}
?>
<?php
function attendance($member)
{
// member id
global $rsvps;
global $meals;
$return = (object) ['attending' => 'no response', 'meal' => 'N/A'];
foreach ($rsvps as $rsvp) {
if ($rsvp->member_id == $member) {
if ($rsvp->attending == 1) {
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 rosterProp($member, $prop)
{
global $SEMESTER, $CHOIR;
if (!$CHOIR) {
die("No choir selected");
}
$html = '';
switch ($prop) {
case "Section":
$section = mysql_fetch_array(mysql_query("select `sectionType`.`name` from `sectionType`, `activeSemester` where `sectionType`.`id` = `activeSemester`.`section` and `activeSemester`.`choir` = '{$CHOIR}' and `activeSemester`.`semester` = '{$SEMESTER}' and `activeSemester`.`member` = '" . $member["email"] . "'"));
$html .= $section['name'];
break;
case "Contact":
$html .= "<a href='tel:" . $member["phone"] . "'>" . $member["phone"] . "</a><br><a href='mailto:" . $member['email'] . "'>" . $member["email"] . "</a>";
break;
case "Location":
$html .= $member["location"];
break;
case "Car":
if ($member["passengers"] == 0) {
$html .= "No";
} else {
$html .= $member["passengers"] . " passengers";
}
break;
case "Enrollment":
$enr = enrollment($member["email"]);
if ($enr == "class") {
$html .= "<span style=\"color: blue\">class</span>";
} else {
if ($enr == "club") {
$html .= "club";
} else {
$html .= "<span style=\"color: gray\">inactive</span>";
}
}
break;
case "Balance":
$balance = balance($member['email']);
if ($balance < 0) {
$html .= "<span class='moneycell' style='color: red'>{$balance}</span>";
} else {
$html .= "<span class='moneycell'>{$balance}</span>";
}
break;
case "Dues":
$result = mysql_fetch_array(mysql_query("select sum(`amount`) as `balance` from `transaction` where `memberID` = '" . $member['email'] . "' and `type` = 'dues' and `semester` = '{$SEMESTER}'"));
$balance = $result['balance'];
if ($balance == '') {
$balance = 0;
}
if ($balance >= 0) {
$html .= "<span class='duescell' style='color: green'>{$balance}</span>";
} else {
$html .= "<span class='duescell' style='color: red'>{$balance}</span>";
}
break;
case "Gigs":
$gigcount = attendance($member["email"], 3);
$result = mysql_fetch_array(mysql_query("select `gigreq` from `semester` where `semester` = '{$SEMESTER}'"));
$gigreq = $result['gigreq'];
if ($gigcount >= $gigreq) {
$html .= "<span class='gigscell' style='color: green'>";
} else {
$html .= "<span class='gigscell' style='color: red'>";
}
$html .= "{$gigcount}</span>";
break;
case "Score":
if (enrollment($member["email"]) == 'inactive') {
$grade = "--";
} else {
$grade = attendance($member["email"], 0);
}
$html .= "<span class='gradecell'";
if (enrollment($member["email"]) == "class" && $grade < 80) {
$html .= " style=\"color: red\"";
}
$html .= ">{$grade}</span>";
break;
case "Tie":
$html .= "<span class='tiecell' ";
$result = mysql_fetch_array(mysql_query("select sum(`amount`) as `amount` from `transaction` where `memberID` = '" . $member['email'] . "' and `type` = 'deposit'"));
$tieamount = $result['amount'];
if ($tieamount == '') {
$tieamount = 0;
}
if ($tieamount >= fee("tie")) {
$html .= "style='color: green'";
} else {
$html .= "style='color: red'";
}
$html .= ">";
$query = mysql_query("select `tie` from `tieBorrow` where `member` = '" . $member['email'] . "' and `dateIn` is null");
if (mysql_num_rows($query) != 0) {
$result = mysql_fetch_array($query);
$html .= $result['tie'];
} else {
$html .= "•";
}
$html .= "</span>";
break;
default:
$html .= "???";
break;
}
return $html;
}
<?php
require_once 'functions.php';
if (!isUber($USER)) {
die("DENIED");
}
echo attendance(mysql_real_escape_string($_POST['member']), 0);
<?php
require_once 'functions.php';
$style = '<style>td { padding: 0px 10px; }</style>';
if (!isOfficer($USER)) {
die("DENIED");
}
echo "<html><head><meta charset='UTF-8'><title>Attendance Record</title></head><body>{$style}";
echo attendance($_GET['id'], 1, $SEMESTER, "print");
echo "</body></html>";
function rosterProp($member, $prop)
{
global $SEMESTER, $CHOIR;
if (!$CHOIR) {
die("No choir selected");
}
$html = '';
switch ($prop) {
case "Section":
$section = mysql_fetch_array(mysql_query("select `sectionType`.`name` from `sectionType`, `activeSemester` where `sectionType`.`id` = `activeSemester`.`section` and `activeSemester`.`choir` = '{$CHOIR}' and `activeSemester`.`semester` = '{$SEMESTER}' and `activeSemester`.`member` = '" . $member["email"] . "'"));
$html .= $section['name'];
break;
case "Contact":
$html .= "<a href='tel:" . $member["phone"] . "'>" . $member["phone"] . "</a><br><a href='mailto:" . $member['email'] . "'>" . $member["email"] . "</a>";
break;
case "Location":
$html .= $member["location"];
break;
case "Balance":
$balance = balance($member['email']);
if ($balance < 0) {
$html .= "<span class='moneycell' style='color: red'>{$balance}</span>";
} else {
$html .= "<span class='moneycell'>{$balance}</span>";
}
break;
case "Dues":
$result = mysql_fetch_array(mysql_query("select sum(`amount`) as `balance` from `transaction` where `memberID` = '" . $member['email'] . "' and `type` = 'dues' and `semester` = '{$SEMESTER}'"));
$balance = $result['balance'];
if ($balance == '') {
$balance = 0;
}
if ($balance >= 0) {
$html .= "<span class='duescell' style='color: green'>{$balance}</span>";
} else {
$html .= "<span class='duescell' style='color: red'>{$balance}</span>";
}
break;
case "Score":
if (enrollment($member["email"]) == 'inactive') {
$grade = "--";
} else {
$grade = attendance($member["email"], 0);
}
$html .= "<span class='gradecell'";
if (enrollment($member["email"]) == "class" && $grade < 80) {
$html .= " style=\"color: red\"";
}
$html .= ">{$grade}</span>";
break;
default:
$html .= "???";
break;
}
return $html;
}
