}
if (!isset($_POST['action']) || $_POST['action'] == "none") {
?>
<style>
button { margin-left: 10px; }
</style>
<table id='transac' class='table'></table>
<div id='roster_ops' class='pull-right'><button type='button' class='btn' onclick='addMoneyForm()'>Add Transaction</button></div>
<?php
exit(0);
}
switch ($_POST['action']) {
case 'values':
$member = mysql_real_escape_string($_POST['member']);
$result = mysql_fetch_array(mysql_query("select sum(`amount`) as `total` from `transaction` where `memberID` = '{$member}' and `type` = 'deposit'"));
$total = $result['total'];
$deposit = fee("tie");
$dues = fee("dues");
if ($total >= $deposit) {
$dep = -1 * $deposit;
} else {
$dep = $deposit;
}
echo "{$dep}";
break;
case 'row':
echo "<tr class='trans_row'><td>" . memberDropdown() . "</td><td>" . transacTypes() . "</td><td>" . semesterDropdown() . "</td><td><input type='text' class='amount' data-amount-dues='{$dues}' data-amount-deposit='{$deposit}' placeholder='Amount' style='width: 60px'></input></td><td><input type='text' class='description' placeholder='Description' maxlength='500'></input></td><td><input type='checkbox' class='receipt'> Send receipt</td><td><button type='button' class='btn cancel'><i class='icon-remove'></i></button></td></tr>";
break;
default:
die("Unknown action {$_POST['action']}");
}
<style>
th { text-align: left; }
td { padding-right: 40px; }
</style>
<?php
require_once 'functions.php';
if (!isUber($USER)) {
die("Go home, earthling.");
}
if (!$CHOIR) {
die("Choir is not set");
}
echo "<table><tr><th>Position</th><th>Member</th></tr>";
$query = mysql_query("select * from `role` where `rank` > 0 and `choir` = '{$CHOIR}' order by `rank` asc");
while ($row = mysql_fetch_array($query)) {
$subq = mysql_query("select `member`.`email` from `member`, `memberRole` where `memberRole`.`role` = '{$row['id']}' and `memberRole`.`member` = `member`.`email`");
// TODO Filter by semester
for ($i = 0; $i < $row['quantity']; $i++) {
$member = mysql_fetch_array($subq);
echo "<tr><td class='position'>{$row['name']}</td><td data-old='{$member['email']}'>" . ($member ? memberDropdown($member['email']) : memberDropdown("")) . "</td></tr>";
}
}
echo "</table>";
<?php require_once 'functions.php'; echo memberDropdown();
