if ($go == "csv" && $action == "hccp" && $filter != "winners") {
$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));
<?php
$a = explode(",", $row_tables_edit['tableStyles']);
// print_r($a);
foreach (array_unique($a) as $value) {
$style_name = style_convert($value, "8");
include DB . 'admin_judging_flights.db.php';
do {
if ($action == "edit") {
$flight_number = flight_entry_info($row_entries['id']);
$flight_number = explode("^", $flight_number);
$random = random_generator(7, 2);
}
?>
<tr>
<td><?php
echo readable_judging_number($row_entries['brewCategory'], $row_entries['brewJudgingNumber']);
?>
<input type="hidden" name="id[]" value="<?php
if ($action == "add") {
echo $row_entries['id'];
}
if ($action == "edit" && $flight_number[0] != "") {
echo $flight_number[0];
} else {
echo $random;
}
?>
" />
<input type="hidden" name="flightTable" value="<?php
echo $row_tables_edit['id'];
?>
$hloopRow1 = 0;
// first row flag
$output .= '<table class="BOS-mat">';
do {
if ($row_scores['brewJudgingNumber'] > 0) {
$style = $row_scores['brewCategory'] . $row_scores['brewSubCategory'];
if ($endRow == 0 && $hloopRow1++ != 0) {
$output .= "<tr>";
}
$output .= '<td>';
$output .= '<h3>' . $row_scores['brewCategory'] . ': ' . style_convert($row_scores['brewCategorySort'], 1) . '</h3>';
$output .= '<p class="lead">' . $style . ': ' . $row_scores['brewStyle'] . '</p>';
if ($filter == "entry") {
$output .= '<p>#' . $row_scores['id'] . '</p>';
} else {
$output .= '<p>#' . readable_judging_number($row_scores['brewCategorySort'], $row_scores['brewJudgingNumber']) . '</p>';
}
$output .= '<p><small><em>' . $row_scores['brewInfo'] . '</em></small></p>';
$output .= '<p><small><em>' . $row_scores['brewComments'] . '</em></small></p>';
if ($type == 2) {
$output .= '<p>' . $row_scores['brewMead1'] . ', ' . $row_scores['brewMead2'] . '</p>';
}
if ($type == 3) {
$output .= '<p>' . $row_scores['brewMead1'] . ', ' . $row_scores['brewMead2'] . ', ' . $row_scores['brewMead3'] . '</p>';
}
$output .= '</td>';
$endRow++;
if ($endRow >= $columns) {
$output .= '</tr>';
if ($hloopRow1 % 2 == 0) {
$output .= '</table><div style="page-break-after:always;"></div><table class="BOS-mat">';
}
$filename .= ".pdf";
if ($psort == "3422") {
$pdf = new PDF_Label('3422');
} else {
$pdf = new PDF_Label('5160');
}
$pdf->AddPage();
$pdf->SetFont('Arial', '', 10);
// Print labels
do {
for ($i = 0; $i < $sort; $i++) {
if (NHC || $_SESSION['prefsEntryForm'] == "N") {
$entry_no = $row_log['brewJudgingNumber'];
} else {
$entry_no = readable_judging_number($row_log['brewCategory'], $row_log['brewJudgingNumber']);
}
$style = $row_log['brewCategory'] . $row_log['brewSubCategory'];
//if ($style == "21A") $style_name = "S.H.V.";
//else
$style_name = truncate($row_log['brewStyle'], 22);
$special = str_replace("\n", " ", truncate($row_log['brewInfo'], 50));
$special = strtr($special, $html_remove);
if (in_array($style, $special_ingredients)) {
$text = sprintf("\n%s %s #%s\nSpecial: %s", $row_log['brewCategory'] . $row_log['brewSubCategory'], $style_name, $entry_no, $special);
if (in_array($style, $mead)) {
$text .= "\n";
if ($row_log['brewMead1'] != "") {
$text .= sprintf("%s", $row_log['brewMead1']);
}
if ($row_log['brewMead2'] != "") {
<th nowrap>Judging</th>
<th>Category</th>
<th>Score</th>
<th>Place</th>
</tr>
</thead>
<tbody>
<?php
do {
$bos_entry_info = bos_entry_info($row_enter_bos['eid'], "default", "default");
$bos_entry_info = explode("^", $bos_entry_info);
$style = $bos_entry_info[1] . $bos_entry_info[3];
if (NHC || $_SESSION['prefsEntryForm'] == "N") {
$judging_number = sprintf("%06s", $bos_entry_info[6]);
} else {
$judging_number = readable_judging_number($bos_entry_info[1], $bos_entry_info[6]);
}
?>
<tr>
<?php
$score_id = $bos_entry_info[13];
?>
<input type="hidden" name="score_id[]" value="<?php
echo $score_id;
?>
" />
<input type="hidden" name="scorePrevious<?php
echo $score_id;
?>
" value="<?php
if (!empty($bos_entry_info[10])) {
$score_previous = "Y";
} else {
$score_previous = "N";
}
$eid = $row_entries['id'];
// $bid is the brewBrewerID/uid
$bid = $row_entries['brewBrewerID'];
if (NHC && $prefix == "final_") {
$entry_number = sprintf("%06s", $row_entries['id']);
} else {
$entry_number = sprintf("%04s", $row_entries['id']);
}
if (NHC || $_SESSION['prefsEntryForm'] == "N") {
$judging_number = sprintf("%06s", $row_entries['brewJudgingNumber']);
} else {
$judging_number = readable_judging_number($table_score_data[1], $row_entries['brewJudgingNumber']);
}
$judging_number = sprintf("%06s", $row_entries['brewJudgingNumber']);
$style_display = $style . " " . style_convert($row_entries['brewCategorySort'], 1) . ": " . $score_style_data[2];
?>
<tr>
<input type="hidden" name="score_id[]" value="<?php
echo $score_id;
?>
" />
<?php
if ($action == "edit") {
?>
<input type="hidden" name="scorePrevious<?php
echo $score_id;
?>
<input type="hidden" name="id<?php
echo $score_id;
?>
" value="<?php
echo $bos_entry_info[14];
?>
" />
<?php
}
?>
<td><?php
echo sprintf("%04s", $row_enter_bos['eid']);
?>
</td>
<td class="data"><?php
echo readable_judging_number($bos_entry_info[2], $bos_entry_info[6]);
?>
</td>
<td class="data"><?php
echo $style . " " . style_convert($bos_entry_info[1], 1) . ": " . $bos_entry_info[0];
?>
</td>
<td class="data"><input type="text" name="scoreEntry<?php
echo $score_id;
?>
" size="5" maxlength="2" value="<?php
echo $bos_entry_info[11];
?>
" /></td>
<td>
<select class="nodupe" name="scorePlace<?php
<?php
do {
// Query scores table for each entry. If no score and not placing, or if score is not entered at all, put on the list
$query_post_inventory_entry = sprintf("SELECT id,scoreEntry,scorePlace FROM %s WHERE eid='%s'", $prefix . "judging_scores", $row_post_inventory['id']);
$post_inventory_entry = mysql_query($query_post_inventory_entry, $brewing) or die(mysql_error());
$row_post_inventory_entry = mysql_fetch_assoc($post_inventory_entry);
$totalRows_post_inventory_entry = mysql_num_rows($post_inventory_entry);
if ($totalRows_post_inventory_entry > 0 && $row_post_inventory_entry['scorePlace'] == "" || $totalRows_post_inventory_entry == 0) {
?>
<tr>
<td class="data bdr1B_gray"><?php
echo sprintf("%04s", $row_post_inventory['id']);
?>
</td>
<td class="data bdr1B_gray"><?php
echo readable_judging_number($row_post_inventory['brewCategory'], $row_post_inventory['brewJudgingNumber']);
?>
</td>
<td class="data bdr1B_gray"><?php
echo $row_post_inventory['brewName'];
?>
</td>
<td class="data bdr1B_gray"><?php
echo $row_post_inventory['brewCategorySort'] . $row_post_inventory['brewSubCategory'] . ": " . $row_post_inventory['brewStyle'];
?>
</td>
<td class="data bdr1B_gray"><?php
echo $row_post_inventory['brewInfo'];
?>
</td>
<?php
" class="col-lg-2 col-md-3 col-sm-4 col-xs-12 control-label">Winning Entry's Judging Number</label>
<div class="col-lg-3 col-md-6 col-sm-8 col-xs-12">
<div class="input-group has-warning">
<!-- Input Here -->
<input class="form-control" id="sbd_judging_no<?php
echo $row_sbd['id'];
?>
" name="sbd_judging_no<?php
echo $row_sbd['id'];
?>
" type="text" size="10" maxlength="255" value="<?php
if ($info[6] > 0) {
if (NHC || $_SESSION['prefsEntryForm'] == "N") {
echo sprintf("%06s", $info[6]);
} else {
echo readable_judging_number($info[3], $info[6]);
}
}
?>
" placeholder="">
<span class="input-group-addon" id="sbd_judging_no<?php
echo $row_sbd['id'];
?>
-2"><span class="fa fa-star"></span></span>
</div>
</div>
</div><!-- ./Form Group -->
<div class="form-group"><!-- Form Group REQUIRED Text Input -->
<label for="sbd_place<?php
