';
// Header Section
$output .= '
';
$output .= '
New York Rangers Penalty Shots
';
// Summary Count Pill Display
$success_rate = ($total_rows > 0) ? round(($total_success / $total_rows) * 100, 1) : 0;
$output .= '
';
$output .= 'Total Attempts: ' . $total_rows . ' | Successful: ' . $total_success . ' (' . $success_rate . '%)';
$output .= '
';
$output .= '
';
// Filters Section UI
$current_page_url = strtok($_SERVER["URI"] ?? $_SERVER["REQUEST_URI"], '?');
$output .= '
';
// Styles
$output .= '';
$output .= '
| Date |
Type |
Opposition |
Result |
Period |
Time |
Shooter |
Shot Result |
Box Score |
';
if (!$penalty_shots) {
$output .= '| No New York Rangers penalty shot attempts found matching the selected filters. |
';
} else {
foreach ($penalty_shots as $ps) {
$formatted_date = !empty($ps->game_date) ? date('F j, Y', strtotime($ps->game_date)) : '';
if (intval($ps->period) === 0) {
$period_name = '';
} else {
$period_name = ($ps->period == 4) ? 'Overtime' : get_ordinal($ps->period) . ' Period';
}
$outcome_label = '';
if (!empty($ps->game_outcome)) {
$raw_outcome = strtoupper($ps->game_outcome);
if ($raw_outcome === 'OTL') {
$outcome_label = 'L';
} else {
$outcome_label = $raw_outcome;
}
}
$score_part = intval($ps->rangers_score) . '-' . intval($ps->opponent_score);
$suffix_part = '';
if (!empty($ps->overtime_status)) {
$ot_status_upper = strtoupper($ps->overtime_status);
if ($ot_status_upper === 'OT' || $ot_status_upper === 'SO') {
$suffix_part = ' (' . $ot_status_upper . ')';
}
}
$result_display = trim($outcome_label . ' ' . $score_part . $suffix_part);
$shooter_name = $ps->shooter_name;
$player_id = $ps->player_id;
if ($ps->ps_outcome === 'Goal') {
$shot_result_display = 'Goal';
} else {
$shot_result_display = 'Miss';
}
// Fallback lookup if player_id wasn't populated via join
if (empty($player_id) && !empty($shooter_name)) {
$matched_player = $wpdb->get_row($wpdb->prepare(
"SELECT ID FROM otg_players WHERE Name = %s LIMIT 1",
$shooter_name
));
if ($matched_player) {
$player_id = $matched_player->ID;
}
}
if (!empty($player_id)) {
$shooter_display = '' . esc_html($shooter_name) . '';
} else {
$shooter_display = !empty($shooter_name) ? esc_html($shooter_name) : 'Unknown';
}
$time_display = (intval($ps->period) === 0) ? '' : esc_html($ps->time_elapsed);
$opponent_logo = '';
if (!empty($ps->opponent_abbr) && !empty($ps->game_id)) {
$logo_row = $wpdb->get_row($wpdb->prepare(
"SELECT logo FROM otg_standings_nhl WHERE abbreviation = %s AND season = %s LIMIT 1",
$ps->opponent_abbr,
$ps->season_str
));
if ($logo_row && !empty($logo_row->logo)) {
$opponent_logo = $logo_row->logo;
}
}
if (!empty($opponent_logo)) {
$opponent_display = ' . ' "' . esc_attr($ps->opponent_abbr) . '")
';
} else {
$opponent_display = esc_html($ps->opponent_abbr);
}
$output .= '';
$output .= '| ' . esc_html($formatted_date) . ' | ';
$output .= '' . esc_html($ps->game_type_str) . ' | ';
$output .= '' . $opponent_display . ' | ';
$output .= '' . esc_html($result_display) . ' | ';
$output .= '' . esc_html($period_name) . ' | ';
$output .= '' . $time_display . ' | ';
$output .= '' . $shooter_display . ' | ';
$output .= '' . $shot_result_display . ' | ';
$output .= 'View Box Score | ';
$output .= '
';
}
}
$output .= '
';
// Pagination Links Output
if ($total_pages > 1) {
$output .= '';
}
$output .= '
