} 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();