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 }