include DB . 'judging_locations.db.php';
include DB . 'stewarding.db.php';
include DB . 'styles.db.php';
}
include DB . 'brewer.db.php';
include DB . 'dropoff.db.php';
if ($section != "step2" && $row_brewer['brewerCountry'] == "United States") {
$us_phone = TRUE;
} else {
$us_phone = FALSE;
}
$phone1 = $row_brewer['brewerPhone1'];
$phone2 = $row_brewer['brewerPhone2'];
if ($us_phone) {
$phone1 = format_phone_us($phone1);
$phone2 = format_phone_us($phone2);
}
// Get table assignments and build flags
$table_assign_judge = table_assignments($_SESSION['user_id'], "J", $_SESSION['prefsTimeZone'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeFormat'], 0);
$table_assign_steward = table_assignments($_SESSION['user_id'], "S", $_SESSION['prefsTimeZone'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeFormat'], 0);
if (!empty($table_assign_judge) || !empty($table_assign_steward)) {
$table_assignment = TRUE;
}
if (empty($table_assign_judge) && empty($table_assign_steward)) {
$table_assignment = FALSE;
}
// Build info message
if ($section == "step2" || $action == "add" || ($action == "edit" && $_SESSION['loginUsername'] == $row_brewerID['brewerEmail'] || $_SESSION['userLevel'] <= "1")) {
$info_msg = "<p class=\"lead\">The information here beyond your first name, last name, and club is strictly for record-keeping and contact purposes. <small>A condition of entry into the competition is providing this information. Your name and club may be displayed should one of your entries place, but no other information will be made public.</small></p>\n";
// Build form action link
if ($section == "step2") {
$output_datatables_body .= "<tr>";
}
$output_datatables_body .= "<td class='dataList'><a name='" . $row_brewer['uid'] . "'>" . $row_brewer['brewerLastName'] . "</a></td>";
$output_datatables_body .= "<td class='dataList'>" . $row_brewer['brewerFirstName'] . "</td>";
$output_datatables_body .= "<td class='dataList'>";
$output_datatables_body .= "<a href='mailto:" . $row_brewer['brewerEmail'] . "?Subject={$email_subject}'>" . $row_brewer['brewerEmail'] . "</a><br />";
if ($row_brewer['brewerPhone1'] != "") {
if ($us_phone) {
$output_datatables_body .= format_phone_us($row_brewer['brewerPhone1']) . " (1)<br>";
} else {
$output_datatables_body .= $row_brewer['brewerPhone1'] . " (1)<br>";
}
}
if ($row_brewer['brewerPhone2'] != "") {
if ($us_phone) {
$output_datatables_body .= format_phone_us($row_brewer['brewerPhone2']) . " (2)<br>";
} else {
$output_datatables_body .= $row_brewer['brewerPhone2'] . " (2)<br>";
}
}
$output_datatables_body .= "</td>";
$output_datatables_body .= "<td class='dataList'>";
if ($totalRows_judging > 0 && ($filter == "judges" || $filter == "stewards")) {
$output_datatables_body .= judge_steward_availability($locations, 1);
} else {
$output_datatables_body .= $row_brewer['brewerClubs'];
}
//else $output_datatables_body .= " ";
$output_datatables_body .= "</td>";
if ($filter == "default") {
$output_datatables_body .= "<td class='dataList'>";
}
$date = date("m-d-Y");
$a[] = array('First Name', 'Last Name', 'Address', 'City', 'State/Province', 'Zip', 'Country', 'Phone', 'Email', 'Clubs', 'Entries In...', 'Assignment', 'Judge ID', 'Judge Rank', 'Likes', 'Dislikes');
//echo $query_sql;
do {
$brewerFirstName = strtr($row_sql['brewerFirstName'], $html_remove);
$brewerLastName = strtr($row_sql['brewerLastName'], $html_remove);
$brewerAddress = strtr($row_sql['brewerAddress'], $html_remove);
$brewerCity = strtr($row_sql['brewerCity'], $html_remove);
if ($go == "tab") {
$assignment = $row_sql['brewerNickname'];
} else {
$assignment = brewer_assignment($row_sql['uid'], "1");
}
if ($row_sql['brewerCountry'] == "United States") {
$phone = format_phone_us($row_sql['brewerPhone1']);
} else {
$phone = $row_sql['brewerPhone1'];
}
$a[] = array($brewerFirstName, $brewerLastName, $brewerAddress, $brewerCity, $row_sql['brewerState'], $row_sql['brewerZip'], $row_sql['brewerCountry'], $phone, $row_sql['brewerEmail'], $row_sql['brewerClubs'], judge_entries($row_sql['uid'], 0), $assignment, $row_sql['brewerJudgeID'], str_replace(",", ", ", $row_sql['brewerJudgeRank']), style_convert($row_sql['brewerJudgeLikes'], '6'), style_convert($row_sql['brewerJudgeDislikes'], '6'));
} while ($row_sql = mysql_fetch_assoc($sql));
$filename = ltrim(filename($contest) . "_Participants" . filename($date) . $loc . $extension, "_");
header('Content-type: application/x-msdownload');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Pragma: no-cache');
header('Expires: 0');
$fp = fopen('php://output', 'w');
foreach ($a as $fields) {
fputcsv($fp, $fields, $separator);
}
fclose($fp);
</script>
<table class="table table-responsive table-striped table-bordered" id="sortable">
<thead>
<tr>
<th>Name</th>
<th>Phone</th>
<th>Address</th>
<th>Notes</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
do {
if ($us_phone) {
$phone = format_phone_us($row_dropoff['dropLocationPhone']);
} else {
$phone = $row_dropoff['dropLocationPhone'];
}
?>
<tr>
<td><?php
echo $row_dropoff['dropLocationName'];
?>
</td>
<td nowrap><?php
echo $phone;
?>
</td>
<td><?php
echo $row_dropoff['dropLocation'];
echo format_phone_us($row_brewer['brewerPhone1']);
} else {
echo $row_brewer['brewerPhone1'];
}
}
?>
" size="32"></td>
<td width="5%" nowrap="nowrap" class="data"><span class="required">Required</span></td>
<td class="data"> </td>
</tr>
<tr>
<td class="dataLabel">Phone 2:</td>
<td class="data"><input type="text" name="brewerPhone2" value="<?php
if ($action == "edit") {
if ($us_phone) {
echo format_phone_us($row_brewer['brewerPhone2']);
} else {
echo $row_brewer['brewerPhone2'];
}
}
?>
" size="32"></td>
<td width="5%" nowrap="nowrap" class="data"> </td>
<td class="data"> </td>
</tr>
<tr>
<td class="dataLabel">Drop-Off Location:</td>
<td class="data">
<select name="brewerDropOff">
<?php
include DB . 'dropoff.db.php';
<th>Entry Name</th>
<th width="20%">Style</th>
<th width="5%">Sub</th>
<th width="5%">Contact</th>
<th width="5%">Paid?</th>
<th width="5%">Sorted?</th>
<th width="5%">Location/Box</th>
</tr>
</thead>
<tbody>
<?php
do {
$info = brewer_info($row_entries['brewBrewerID']);
$brewer_info = explode("^", $info);
if ($brewer_info[14] == "United States") {
$phone = format_phone_us($brewer_info[2]);
} else {
$phone = $brewer_info[2];
}
?>
<tr>
<td><?php
echo sprintf("%04s", $row_entries['id']);
?>
</td>
<?php
if ($view == "default") {
?>
<td><?php
echo readable_judging_number($row_entries['brewCategory'], $row_entries['brewJudgingNumber']);
?>
$output_datatables_delete_link = "<span class=\"fa fa-trash-o text-muted\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Silly, you cannot delete yourself, " . $_SESSION['brewerFirstName'] . "!\"></span>";
}
if ($row_brewer['brewerEmail'] != $_SESSION['loginUsername']) {
$output_datatables_other_link = build_action_link("fa-lock", $base_url, "admin", "make_admin", "default", "default", $row_brewer['uid'], "default", "Change " . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . "’s User Level");
} else {
$output_datatables_other_link = "<span class=\"fa fa-lock text-muted\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"You cannot change your own user level, " . $_SESSION['brewerFirstName'] . ".\"></span>";
}
if (strpos($brewer_assignment, 'Judge') !== false) {
$output_datatables_view_link = "<a href=\"" . $base_url . "output/labels.output.php?section=admin&go=participants&action=judging_labels&id=" . $row_brewer['id'] . "&psort=5160\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Download Judge Scoresheet Labels for " . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . " - Letter (Avery 5160)\"><span class=\"fa fa-file\"></span></a> <a href=\"" . $base_url . "output/labels.output.php?section=admin&go=participants&action=judging_labels&id=" . $row_brewer['id'] . "&psort=3422\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Download Judge Scoresheet Labels for " . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . " - A4 (Avery 3422)\"><span class=\"fa fa-file-text\"></span></a>";
} else {
$output_datatables_view_link = "";
}
$output_datatables_other_link2 = build_action_link("fa-user", $base_url, "user", "default", "username", "admin", $row_brewer['uid'], "default", "Change " . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . "’s Email Address");
$output_datatables_email_link .= "<a href=\"mailto:" . $row_brewer['brewerEmail'] . "\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Email " . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . " at " . $row_brewer['brewerEmail'] . "\"><span class=\"fa fa-envelope\"></span></a>";
if ($us_phone) {
$output_datatables_phone_link = "<a href=\"#\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"" . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . "’s phone number: " . format_phone_us($row_brewer['brewerPhone1']) . "\"><span class=\"fa fa-phone\"></span></a>";
} else {
$output_datatables_phone_link = "<a href=\"#\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"" . $row_brewer['brewerFirstName'] . " " . $row_brewer['brewerLastName'] . "’s phone number: " . $row_brewer['brewerPhone1'] . "\"><span class=\"fa fa-phone\"></span></a>";
}
$output_datatables_actions = $output_datatables_add_link . " " . $output_datatables_edit_link . " " . $output_datatables_delete_link . " " . $output_datatables_other_link . " " . $output_datatables_email_link . " " . $output_datatables_phone_link . " " . $output_datatables_other_link2 . " " . $output_datatables_view_link;
$output_datatables_body .= "<td>" . $output_datatables_actions . "</td>";
}
$output_datatables_body .= "</tr>";
} while ($row_brewer = mysql_fetch_assoc($brewer));
// ----------------------------------------- Presentation ------------------------------------------
// Display Top Of Page Elements (Subtitle, Primary Page Info, Nav, and Secondary Page Info)
echo $output_assignment_modals;
?>
<?php
if ($action == "print") {
}
if ($_SESSION['brewerCountry'] == "United States") {
$us_phone = TRUE;
} else {
$us_phone = FALSE;
}
if (!empty($_SESSION['brewerPhone1'])) {
if ($us_phone) {
$phone .= format_phone_us($_SESSION['brewerPhone1']) . " (1)";
} else {
$phone .= $_SESSION['brewerPhone1'] . " (1)";
}
}
if (!empty($_SESSION['brewerPhone2'])) {
if ($us_phone) {
$phone .= "<br>" . format_phone_us($_SESSION['brewerPhone2']) . " (2)";
} else {
$phone .= "<br>" . $_SESSION['brewerPhone2'] . " (2)";
}
}
if (!empty($_SESSION['brewerClubs'])) {
$club = $_SESSION['brewerClubs'];
} else {
$club = "None entered";
}
$discount .= "Yes (" . $currency_symbol . $_SESSION['contestEntryFeePasswordNum'] . " per entry)";
if (!empty($_SESSION['brewerAHA'])) {
if ($_SESSION['brewerAHA'] < "999999994") {
$aha_number .= sprintf("%09s", $_SESSION['brewerAHA']);
} elseif ($_SESSION['brewerAHA'] >= "999999994") {
$aha_number .= "Pending";
