$user_info = explode("^", $user_info); $table_assign_judge = table_assignments($user_info[0], "J", $_SESSION['prefsTimeZone'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeFormat'], 1); $table_assign_steward = table_assignments($user_info[0], "S", $_SESSION['prefsTimeZone'], $_SESSION['prefsDateFormat'], $_SESSION['prefsTimeFormat'], 1); if ($filter == "judges") { $locations = $row_brewer['brewerJudgeLocation']; } if ($filter == "stewards") { $locations = $row_brewer['brewerStewardLocation']; } if ($_SESSION['brewerCountry'] == "United States") { $us_phone = TRUE; } else { $us_phone = FALSE; } unset($brewer_assignment); $brewer_assignment = brewer_assignment($row_brewer['uid'], "1", $id, $dbTable); //$judge_array = str_replace(", ",",",$brewer_assignment); //$judge_array = explode(",",$judge_array); //if (in_array("Judge",$judge_array)) $brewer_judge = TRUE; else $brewer_judge = FALSE; if ($action == "print") { $output_datatables_body .= "<tr class='bdr1B_gray'>"; } else { $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>";
$loc = "_" . str_replace(' ', '_', $row_judging['judgingLocName']); } else { $loc = ""; } $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) {
echo $base_url . "index.php?section=admin&go=judging"; ?> "> </form> <?php } ?> <?php if ($action == "update" && $bid == "default") { ?> <table> <tr> <td class="dataLabel">Assign <?php echo brewer_assignment($filter, "3", "default", "default", "default"); ?> To:</td> <td class="data"> <select class="selectpicker" name="judge_loc" id="judge_loc" onchange="jumpMenu('self',this,0)" data-width="auto"> <option value=""></option> <?php do { ?> <option value="index.php?section=admin&action=update&go=judging&filter=<?php echo $filter; ?> &bid=<?php echo $row_judging['id']; ?> "><?php
$loc = "_" . str_replace(' ', '_', $row_judging['judgingLocName']); } else { $loc = ""; } $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", "blah", "default", "default"); } 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) {
} if ($filter == "stewards") { $locations = $row_brewer['brewerStewardLocation']; } if ($_SESSION['brewerCountry'] == "United States") { $us_phone = TRUE; } else { $us_phone = FALSE; } if ($dbTable != "default") { $archive = get_suffix($dbTable); } else { $archive = "default"; } unset($brewer_assignment); $brewer_assignment = brewer_assignment($row_brewer['uid'], "1", $id, $dbTable, $filter, $archive); if (!empty($brewer_assignment)) { // Build assignment modal for participants unset($assignment_modal_body); if (strpos($brewer_assignment, "Judge") !== false || strpos($brewer_assignment, "Steward") !== false) { if (strpos($brewer_assignment, "Judge") !== false) { if (!empty($table_assign_judge)) { $assignment_modal_body = "<p>" . $row_brewer['brewerFirstName'] . " is assigned as a <strong>judge</strong> to table(s): " . $table_assign_judge . "<p>"; } else { $assignment_modal_body = "<p>" . $row_brewer['brewerFirstName'] . " has been added to the <strong>judge</strong> pool, but has not been assigned to a table yet.<p>"; } } if (strpos($brewer_assignment, "Steward") !== false) { if (!empty($table_assign_steward)) { $assignment_modal_body .= "<p>" . $row_brewer['brewerFirstName'] . " is assigned as a <strong>steward</strong> to table(s): " . $table_assign_steward . "<p>"; } else {
$output_datatables_actions = ""; $user_info = user_info($row_brewer['uid']); $user_info = explode("^", $user_info); if ($filter == "judges") { $locations = $row_brewer['brewerJudgeLocation']; } if ($filter == "stewards") { $locations = $row_brewer['brewerStewardLocation']; } if ($_SESSION['brewerCountry'] == "United States") { $us_phone = TRUE; } else { $us_phone = FALSE; } unset($brewer_assignment); $brewer_assignment = brewer_assignment($row_brewer['uid'], "1"); //$judge_array = str_replace(", ",",",$brewer_assignment); //$judge_array = explode(",",$judge_array); //if (in_array("Judge",$judge_array)) $brewer_judge = TRUE; else $brewer_judge = FALSE; if ($action == "print") { $output_datatables_body .= "<tr class='bdr1B_gray'>"; } else { $output_datatables_body .= "<tr>"; } $output_datatables_body .= "<td class='dataList'>" . $row_brewer['brewerLastName'] . "</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>";
$table_head3 = ""; $table_body3 = ""; // Page specific variables $user_edit_links = ""; $name = ""; $email = ""; $phone = ""; $discount = ""; $aha_number = ""; // Build useful variables if ($_SESSION['brewerDiscount'] == "Y" && $_SESSION['contestEntryFeePasswordNum'] != "") { $entry_discount = TRUE; } else { $entry_discount = FALSE; } $brewer_assignment .= brewer_assignment($_SESSION['user_id'], "1", "blah", $dbTable, $filter); $assignment_array = str_replace(", ", ",", $brewer_assignment); $assignment_array = explode(",", $assignment_array); if (!in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) { $judge_available_not_assigned = TRUE; } else { $judge_available_not_assigned = FALSE; } if (!in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) { $steward_available_not_assigned = TRUE; } else { $steward_available_not_assigned = FALSE; } if (in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) { $assignment = "judge"; } elseif (in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) {
$user_edit_links = ""; $edit_user_info_link = ""; $edit_email_link = ""; $edit_password_link = ""; $name = ""; $email = ""; $phone = ""; $discount = ""; $aha_number = ""; // Build useful variables if ($_SESSION['brewerDiscount'] == "Y" && $_SESSION['contestEntryFeePasswordNum'] != "") { $entry_discount = TRUE; } else { $entry_discount = FALSE; } $brewer_assignment .= brewer_assignment($_SESSION['user_id'], "1"); $assignment_array = str_replace(", ", ",", $brewer_assignment); $assignment_array = explode(",", $assignment_array); if (!in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) { $judge_available_not_assigned = TRUE; } else { $judge_available_not_assigned = FALSE; } if (!in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) { $steward_available_not_assigned = TRUE; } else { $steward_available_not_assigned = FALSE; } if (in_array("Judge", $assignment_array) && $_SESSION['brewerJudge'] == "Y" && $totalRows_judging3 > 1) { $assignment = "judge"; } elseif (in_array("Steward", $assignment_array) && $_SESSION['brewerSteward'] == "Y" && $totalRows_judging3 > 1) {
echo $base_url . "index.php?section=admin&go=judging"; ?> "> </form> <?php } ?> <?php if ($action == "update" && $bid == "default") { ?> <table> <tr> <td class="dataLabel">Assign <?php echo brewer_assignment($filter, "3"); ?> To:</td> <td class="data"> <select name="judge_loc" id="judge_loc" onchange="jumpMenu('self',this,0)"> <option value=""></option> <?php do { ?> <option value="index.php?section=admin&action=update&go=judging&filter=<?php echo $filter; ?> &bid=<?php echo $row_judging['id']; ?> "><?php