<th class="dataHeading bdr1B" width="5%">Table #</th> <th class="dataHeading bdr1B" width="20%">Table Name</th> <th class="dataHeading bdr1B" width="5%">Round #</th> <?php if ($_SESSION['jPrefsQueued'] == "N") { ?> <th class="dataHeading bdr1B" width="5%">Flight #</th> <?php } ?> </tr> </thead> <tbody> <?php do { $judge_info = explode("^", brewer_info($row_assignments['bid'])); $table_info = explode("^", get_table_info("none", "basic", $row_assignments['assignTable'], $dbTable, "default")); $location_info = explode("^", get_table_info($row_assignments['assignLocation'], "location", "1", $dbTable, "default")); $judge_ranks = str_replace(",", ", ", $judge_info['3']); ?> <tr> <td class="bdr1B_gray"><?php echo ucfirst(strtolower($judge_info['1'])) . ", " . ucfirst(strtolower($judge_info['0'])); ?> </td> <td class="data bdr1B_gray"><?php echo $judge_ranks; ?> </td> <td class="data bdr1B_gray"><?php echo table_location($row_assignments['assignTable'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeZone'], $_SESSION['prefsTimeFormat'], "default");
$beer_end = 23; } if ($_SESSION['prefsStyleSet'] == "BJCP2015") { $beer_end = 34; } if ($action == "edit") { $collapse_icon = "fa-plus-circle"; } else { $collapse_icon = "fa-pencil"; } if ($filter == "admin" || $filter == "default") { $brewer_id = $_SESSION['user_id']; } else { $brewer_id = $filter; } $brewer_info = brewer_info($brewer_id); $brewer_info = explode("^", $brewer_info); // Define custom functions function display_array_content_style($arrayname, $method, $base_url) { $a = ""; sort($arrayname); while (list($key, $value) = each($arrayname)) { if (is_array($value)) { $c = display_array_content($value, ''); $d = ltrim($c, "0"); $d = str_replace("-", "", $c); $a .= "<a id='modal_window_link' href='" . $base_url . "output/print.output.php?section=styles&view=" . $c . "&tb=true'>" . $d . "</a>"; } else { $e = ltrim($value, "0"); $e = str_replace("-", "", $value);
$header2_1 .= "<h3>Best of Show – " . $row_sbi['sbi_name'] . "</h3>"; if ($row_sbi['sbi_description'] != "") { $header2_1 .= "<p>" . $row_sbi['sbi_description'] . "</p>"; } // Build table headers $table_head2 .= "<tr>"; if ($row_sbi['sbi_display_places'] == "1") { $table_head2 .= "<th width='5%'>Place</th>"; } $table_head2 .= "<th width='25%'>Brewer(s)</th>"; $table_head2 .= "<th width='20%'>Entry Name</th>"; $table_head2 .= "<th width='25%'>Style</th>"; $table_head2 .= "<th>Club</th>"; // Build table body do { $brewer_info = explode("^", brewer_info($row_sbd['bid'])); $entry_info = explode("^", entry_info($row_sbd['eid'])); $style = $entry_info['5'] . $entry_info['2']; $table_body2 .= "<tr>"; if ($row_sbi['sbi_display_places'] == "1") { if ($action == "print") { $table_body2 .= "<td>"; $table_body2 .= display_place($row_sbd['sbd_place'], 0); $table_body2 .= "</td>"; } else { $table_body2 .= "<td>"; $table_body2 .= display_place($row_sbd['sbd_place'], 3); $table_body2 .= "</td>"; } } if ($action == "print") {
$output .= "\t\t<JudgeData>\n"; $output .= "\t\t\t<JudgeName>" . $staff_name . "</JudgeName>\n"; $output .= "\t\t\t<JudgeRole>Staff</JudgeRole>\n"; $output .= "\t\t\t<JudgePts>0.0</JudgePts>\n"; if ($staff_points < $organ_points) { $output .= "\t\t\t<NonJudgePts>" . $staff_points . "</NonJudgePts>\n"; } else { $output .= "\t\t\t<NonJudgePts>" . $organ_points . "</NonJudgePts>\n"; } $output .= "\t\t</JudgeData>\n"; } } } // Organizer without a properly formatted BJCP ID in the system foreach (array_unique($o) as $uid) { $organizer_info = explode("^", brewer_info($uid)); if ($organizer_info['0'] != "" && $organizer_info['1'] != "" && !validate_bjcp_id($organizer_info['4'])) { $output .= "\t\t<JudgeData>\n"; $output .= "\t\t\t<JudgeName>" . $organizer_info['0'] . " " . $organizer_info['1'] . "</JudgeName>\n"; $output .= "\t\t\t<JudgeRole>Organizer</JudgeRole>\n"; $output .= "\t\t\t<JudgePts>0.0</JudgePts>\n"; $output .= "\t\t\t<NonJudgePts>" . $organ_points . "</NonJudgePts>\n"; $output .= "\t\t</JudgeData>\n"; } } $output .= "\t</NonBJCP>\n"; // BOS Reporting $output .= "\t<Comments>\n"; $output .= "Submitter Email: " . $_SESSION['user_name'] . "\n"; /* do { $a[] = $row_style_types['id']; } while ($row_style_types = mysql_fetch_assoc($style_types));
</script> <table class="dataTable" id="sortable<?php echo $style; ?> "> <thead> <tr> <th width="10%" class="dataHeading bdr1B">Entry #</th> <th width="10%" class="dataHeading bdr1B">Judging #</th> <th class="dataHeading bdr1B">Label Affixed?</th> </tr> </thead> <tbody> <?php do { $info = brewer_info($row_entries['brewBrewerID']); $brewer_info = explode("^", $info); ?> <tr> <td class="data bdr1B_gray"><?php echo sprintf("%04s", $row_entries['id']); ?> </td> <td class="data bdr1B_gray"><?php echo readable_judging_number($row_entries['brewCategory'], $row_entries['brewJudgingNumber']); ?> </td> <td class="data bdr1B_gray"><p class="box_small"> </p></td> </tr> <?php } while ($row_entries = mysql_fetch_assoc($entries));
<th width="3%" class="dataHeading bdr1B">Paid?</th> <th width="3%" class="dataHeading bdr1B">Rec'd?</th> <th class="dataHeading bdr1B">Loc / Box</th> <?php if ($action != "print" && $dbTable == "default") { ?> <th class="dataHeading bdr1B">Actions</th> <?php } ?> </tr> </thead> <tbody> <?php do { $brewer_info = brewer_info($row_log['brewBrewerID']); $brewer_info = explode("^", $brewer_info); $styleConvert = style_convert($row_log['brewCategorySort'], 1); $entry_style = $row_log['brewCategorySort'] . "-" . $row_log['brewSubCategory']; ?> <tr<?php if ($row_log['brewConfirmed'] == "0" && $action != "print") { echo " style='background-color: #ff9; border-top: 1px solid #F90; border-bottom: 1px solid #F90;'"; } elseif (check_special_ingredients($entry_style) && $row_log['brewInfo'] == "") { echo " style='background-color: #ff9; border-top: 1px solid #F90; border-bottom: 1px solid #F90;'"; } ?> > <input type="hidden" name="id[]" value="<?php echo $row_log['id']; ?>
?> <th class="dataHeading bdr1B hidden-print">Actions</th> <?php } ?> </tr> </thead> <tbody> <?php do { if ($dbTable == "default") { $brewer_info_filter = "default"; } else { $brewer_info_filter = get_suffix($dbTable); } $brewer_info = brewer_info($row_log['brewBrewerID'], $brewer_info_filter); $brewer_info = explode("^", $brewer_info); $styleConvert = style_convert($row_log['brewCategorySort'], 1); $entry_style = $row_log['brewCategorySort'] . "-" . $row_log['brewSubCategory']; $entry_style_display = ""; $entry_brewer_display = ""; $entry_updated_display = ""; $entry_judging_num_display = ""; $entry_paid_display = ""; $entry_received_display = ""; $entry_box_num_display = ""; $entry_actions = ""; $entry_unconfirmed_row = ""; if ($row_log['brewConfirmed'] == 0 || $row_log['brewConfirmed'] == "") { $entry_unconfirmed_row = "bg-danger"; } elseif (check_special_ingredients($entry_style) && $row_log['brewInfo'] == "") {
} $output_stewards .= "</td>"; $output_stewards .= "<td class='data bdr1B_gray'>" . steward_points($uid) . "</td>"; $output_stewards .= "</tr>"; } } } } if ($totalRows_staff > 0) { do { $st[] = $row_staff['uid']; } while ($row_staff = mysql_fetch_assoc($staff)); $st_running_total[] = ""; foreach (array_unique($st) as $uid) { if (array_sum($st_running_total) < $staff_points_total) { $staff_info = explode("^", brewer_info($uid)); $st_running_total[] = $staff_points; if (!empty($staff_info['1'])) { $staff_name = ucwords(strtolower($staff_info['1'])) . ", " . ucwords(strtolower($staff_info['0'])); $output_staff .= "<tr>"; $output_staff .= "<td class='bdr1B_gray'>" . $staff_name . "</td>"; $output_staff .= "<td class='data bdr1B_gray'>"; if (validate_bjcp_id($staff_info['4'])) { $output_staff .= strtoupper(strtr($staff_info['4'], $bjcp_num_replace)); } $output_staff .= "</td>"; $output_staff .= "<td class='data bdr1B_gray'>"; if (array_sum($st_running_total) <= $staff_points_total && $staff_points < $organ_points) { $output_staff .= $staff_points; } else { $output_staff .= $organ_points;
$a[] = array('First Name', 'Last Name', 'Email', 'Category', 'Sub Category', 'Entry Number', 'Judging Number', 'Brew Name', 'Special Ingredients', 'Sweetness', 'Carb', 'Strength'); } if ($go == "csv" && ($action == "default" || $action == "email") && $filter != "winners") { $a[] = array('First Name', 'Last Name', 'Email', 'Category', 'Sub Category', 'Entry Number', 'Judging Number', 'Brew Name', 'Special Ingredients', 'Sweetness', 'Carb', 'Strength', 'Address', 'City', 'State/Province', 'Zip/Postal Code', 'Country'); } if ($go == "csv" && $action == "default" && $filter == "winners") { $a[] = array('Table Number', 'Table Name', 'Category', 'Sub-Category', 'Style', 'Place', 'Last Name', 'First Name', 'Email', 'Address', 'City', 'State/Province', 'Zip/Postal Code', 'Country', 'Phone', 'Entry Name', 'Club', 'Co Brewer'); } do { $brewerFirstName = strtr($row_sql['brewBrewerFirstName'], $html_remove); $brewerLastName = strtr($row_sql['brewBrewerLastName'], $html_remove); $brewName = strtr($row_sql['brewName'], $html_remove); $brewInfo = strtr($row_sql['brewInfo'], $html_remove); $entryNo = sprintf("%04s", $row_sql['id']); $judgingNo = readable_judging_number($row_sql['brewCategory'], $row_sql['brewJudgingNumber']); $brewer_info = explode("^", brewer_info($row_sql['brewBrewerID'])); // Winner Downloads if ($action == "default" && $filter == "winners" && $_SESSION['prefsWinnerMethod'] == 0) { include DB . 'output_entries_export_winner.db.php'; } // end if (($action == "default") && ($filter == "winners")) // No participant email addresses if ($action == "hccp" && $filter != "winners") { $a[] = array($brewerFirstName, $brewerLastName, $row_sql['brewCategory'], $row_sql['brewSubCategory'], $entryNo, $brewName, $brewInfo, $row_sql['brewMead2'], $row_sql['brewMead1'], $row_sql['brewMead3']); } // With email addresses of participants. if (($action == "default" || $action == "email") && $go == "csv" && $filter != "winners") { $a[] = array($brewerFirstName, $brewerLastName, $brewer_info[6], $row_sql['brewCategory'], $row_sql['brewSubCategory'], $entryNo, $judgingNo, $brewName, $brewInfo, $row_sql['brewMead1'], $row_sql['brewMead2'], $row_sql['brewMead3'], $brewer_info[10], $brewer_info[11], $brewer_info[12], $brewer_info[13], $brewer_info[14]); } } while ($row_sql = mysql_fetch_assoc($sql)); if ($action == "default" && $filter == "winners" && $_SESSION['prefsWinnerMethod'] > 0) {