';
// 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 matching modern uniform layout + pagination styling + button hover specifications
$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) {
// Format game_date to Month Day, Year (e.g., October 12, 2023)
$formatted_date = !empty($ps->game_date) ? date('F j, Y', strtotime($ps->game_date)) : '';
// Handle period display name (leave blank if period is 0)
if (intval($ps->period) === 0) {
$period_name = '';
} else {
$period_name = ($ps->period == 4) ? 'Overtime' : get_ordinal($ps->period) . ' Period';
}
// Format Result string: [Outcome] [Score] [(OT/SO)]
$outcome_label = '';
if (!empty($ps->game_outcome)) {
$raw_outcome = strtoupper($ps->game_outcome);
// Keep L as L (do not convert to OTL)
if ($raw_outcome === 'OTL') {
$outcome_label = 'L';
} else {
$outcome_label = $raw_outcome;
}
}
// Build score string (e.g., 2-3)
$score_part = intval($ps->rangers_score) . '-' . intval($ps->opponent_score);
// Format OT or SO inside parentheses if applicable
$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);
// Handle Shooter extraction & profile linking uniformly for both Goals and Misses
$shooter_name = '';
$player_id = $ps->player_id; // Starts with whatever subquery joined (for goals)
if ($ps->ps_outcome === 'Goal') {
$shooter_name = $ps->shooter_name;
$shot_result_display = 'Goal';
} else {
// Parse shooter name properly from penalty_type for misses (e.g., ps-Vincent Trocheck-slashing)
if (!empty($ps->penalty_type) && strpos($ps->penalty_type, 'ps-') === 0) {
$trimmed = substr($ps->penalty_type, 3); // Remove 'ps-'
$parts = explode('-', $trimmed);
if (!empty($parts[0])) {
$shooter_name = trim($parts[0]);
}
}
$shot_result_display = 'Miss';
}
// Universal fallback lookup: If player_id is missing, look up ID by Name in otg_players
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;
}
}
// Format Shooter display with profile link if player ID exists
if (!empty($player_id)) {
$shooter_display = '' . esc_html($shooter_name) . '';
} else {
$shooter_display = !empty($shooter_name) ? esc_html($shooter_name) : 'Unknown';
}
// Leave time blank if period is 0
$time_display = (intval($ps->period) === 0) ? '' : esc_html($ps->time_elapsed);
// Look up the opponent logo dynamically per row using exact abbreviation and formatted season (YYYY-YY)
$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;
}
}
// Format Opposition display using logo if available, falling back to abbreviation text
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 (preserving active filters in query parameters)
if ($total_pages > 1) {
$output .= '';
}
$output .= '
