?>
<th class="dataHeading bdr1B">Round <?php
echo $i;
?>
</th>
<?php
}
}
?>
</tr>
</thead>
<tbody>
<?php
do {
$table_location = "Y-" . $row_tables_edit['tableLocation'];
$judge_info = judge_info($row_brewer['uid']);
$judge_info = explode("^", $judge_info);
/*
$r =
$row_brewer_info['brewerFirstName']."^".
$row_brewer_info['brewerLastName']."^".
$row_brewer_info['brewerJudgeLikes']."^".
$row_brewer_info['brewerJudgeDislikes']."^".
$row_brewer_info['brewerJudgeMead']."^".
$row_brewer_info['brewerJudgeRank']."^".
$row_brewer_info['brewerJudgeID']."^".
$row_brewer_info['brewerStewardLocation']."^".
$row_brewer_info['brewerJudgeLocation'];
*/
$bjcp_rank = explode(",", $judge_info[5]);
$display_rank = bjcp_rank($bjcp_rank[0], 1);
function not_assigned($method)
{
require CONFIG . 'config.php';
mysql_select_db($database, $brewing);
$return = "";
$assignment = "";
if ($method == "J") {
$query_brewer = sprintf("SELECT a.uid, b.uid FROM %s a, %s b WHERE b.staff_judge='1' AND a.uid=b.uid", $prefix . "brewer", $prefix . "staff");
$human_readable = "judge";
}
if ($method == "S") {
$query_brewer = sprintf("SELECT a.uid, b.uid FROM %s a, %s b WHERE b.staff_steward='1' AND a.uid=b.uid", $prefix . "brewer", $prefix . "staff");
$human_readable = "steward";
}
$brewer = mysql_query($query_brewer, $brewing) or die(mysql_error());
$row_brewer = mysql_fetch_assoc($brewer);
$totalRows_brewer = mysql_num_rows($brewer);
if ($totalRows_brewer > 0) {
do {
$user[] .= $row_brewer['uid'];
} while ($row_brewer = mysql_fetch_assoc($brewer));
foreach ($user as $bid) {
if ($method == "J") {
$query_assignments = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE bid='%s' AND assignment='J'", $prefix . "judging_assignments", $bid);
$assignments = mysql_query($query_assignments, $brewing) or die(mysql_error());
$row_assignments = mysql_fetch_assoc($assignments);
// If no assignment, get info and build output
if ($row_assignments['count'] == 0) {
$info = judge_info($bid);
$assignment_info = explode("^", $info);
$judge_rank = $assignment_info[5];
$judge_rank_explode = explode(",", $assignment_info[5]);
$judge_rank_display = $judge_rank_explode[0];
if (empty($judge_rank)) {
$judge_rank_display = "Novice";
}
$assignment .= "<tr><td class=\"small\">" . $assignment_info[1] . ", " . $assignment_info[0] . "</td><td class=\"small\">" . $judge_rank_display . "</td></tr>";
}
}
if ($method == "S") {
$query_assignments = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE bid='%s' AND assignment='S'", $prefix . "judging_assignments", $bid);
$assignments = mysql_query($query_assignments, $brewing) or die(mysql_error());
$row_assignments = mysql_fetch_assoc($assignments);
// If no assignment, get info and build output
if ($row_assignments['count'] == 0) {
$info = judge_info($bid);
$assignment_info = explode("^", $info);
$judge_rank = $assignment_info[5];
$judge_rank_explode = explode(",", $assignment_info[5]);
$judge_rank_display = $judge_rank_explode[0];
if (empty($judge_rank)) {
$judge_rank_display = "Novice";
}
$assignment .= "<tr><td class=\"small\">" . $assignment_info[1] . ", " . $assignment_info[0] . "</td><td class=\"small\">" . $judge_rank_display . "</td></tr>";
}
}
}
// Return the modal body text
$return .= "<p>These " . $human_readable . "s have not been assigned to any table.</p>";
$return .= "<table class=\"table table-responsive table-striped table-bordered table-condensed\" id=\"sortable" . $method . "\">";
$return .= "<thead>";
$return .= "<tr>";
$return .= "<th>Name</th>";
$return .= "<th>Rank</th>";
$return .= "</tr>";
$return .= "</thead>";
$return .= "<tbody>";
$return .= $assignment;
$return .= "</tbody>";
$return .= "</table>";
} else {
$return = "<p>No participants have been added to the " . $human_readable . " pool yet. Therefore, there no table assignments.</p>";
}
return $return;
}
