function ifcrush_bid_handle_bid_form($frat_letters)
{
global $wpdb;
$pnm_netID = $_POST['available_pnm_netID'];
if ($pnm_netID == "none") {
echo "<p>Please select a PNM</p>";
return;
}
$pnm_pw = $_POST['pnm_pw'];
$pnm_name = get_pnm_name_by_netID($pnm_netID);
$failure = false;
if (-1 == ifcrush_bid_verify_password($pnm_netID, $pnm_pw)) {
$failure = true;
echo "<p>PNM Password Failed - please try again.</p>";
}
if (!$failure) {
echo "<h2>{$frat_letters} offering a bid to {$pnm_name}</h2>";
$thisBid = array('netID' => $pnm_netID, 'fratID' => $frat_letters);
ifcrush_bid_insert_bid($thisBid);
}
}
/** This is a report function. A function should be added for
** each desired report, and the appropriate case should be added to handle form.
**/
function ifcrush_create_frat_report($frat_letters)
{
global $wpdb;
$event_table_name = $wpdb->prefix . "ifc_event";
$eventreg_table_name = $wpdb->prefix . "ifc_eventreg";
$query = "SELECT * FROM {$eventreg_table_name} \n\t\t\t\t\tJOIN {$event_table_name} on \n\t\t\t\t\t{$eventreg_table_name}.eventID = {$event_table_name}.eventID\n\t\t\t\t\twhere fratID='{$frat_letters}' order by pnm_netID";
//echo "query is $query";
$allresults = $wpdb->get_results($query);
if ($allresults) {
foreach ($allresults as $r) {
?>
<div class="reportrow">
<?php
echo get_pnm_name_by_netID($r->pnm_netID) . " {$r->title} ";
?>
</div>
<?php
}
} else {
echo "no results!";
}
}
function ifcrush_create_frat_report_pnms_bid_count($frat_letters)
{
global $wpdb;
$bid_table_name = $wpdb->prefix . "ifc_bid";
$query = "SELECT netID from {$bid_table_name} where fratID='{$frat_letters}'";
$allresults = $wpdb->get_results($query);
if ($allresults) {
echo "<h3>BID Report for {$frat_letters}</h3>\n\t\t<table><tr><th>Net ID</th><th>Name</th><th></th></tr>\n\t\t";
foreach ($allresults as $r) {
echo "<tr><td>{$r->netID}</td><td>" . get_pnm_name_by_netID($r->netID) . "</td><td></td></tr>\n\t\t\t\t\t\t\t";
}
echo "</table>\n\t\t ";
return true;
}
return false;
}
function create_eventreg_table_row($eventreg)
{
?>
<div class="ifcrushtablerow">
<form method="post">
<div class="ifcrushtablecellwide">
<?php
echo get_pnm_name_by_netID($eventreg->pnm_netID);
?>
</div>
<div class="ifcrushtablecellwide">
<?php
echo $eventreg->fratID . "-" . $eventreg->title;
?>
</div>
<div class="ifcrushtablecellauto">
<input type="hidden" name="eventID" value="<?php
echo $eventreg->eventID;
?>
">
<input type="hidden" name="pnm_netID" value="<?php
echo $eventreg->pnm_netID;
?>
">
<input type="submit" name="action" value="Delete Event Reg"/>
</div>
</form>
</div><!-- end ifcrush tablerow-->
<?php
}
