';
$header_titles = [
'nyr' => 'Rangers Goal Timing Breakdown (Minute-by-Minute)',
'opp' => 'Opponent Goal Timing vs Rangers (Minute-by-Minute)',
'response_for' => 'Follow-up Goal: Goals Scored by Rangers Following a Rangers Goal',
'response_against' => 'Follow-up Goal: Goals Scored by Opponents Following an Opponent Goal',
'rangers_response' => 'Rangers Response Goal: Rangers Goal Following an Opponent Goal',
'opponent_response' => 'Opponent Response Goal: Opponent Goal Following a Rangers Goal',
'player_period_breakdown' => 'Rangers Player Scoring Breakdown by Period'
];
$current_title = $header_titles[$view_side] ?? 'Goal Timing Breakdown';
$output .= '
';
$output .= '
' . $current_title . '
';
$query_params_base = '&opponent_abbr='.urlencode($opponent_abbr).'&view_side='.urlencode($view_side).'&season_start='.urlencode($season_start).'&season_end='.urlencode($season_end).'&exclude_empty_net='.$exclude_empty_net;
$output .= '
';
$output .= '
';
// 6. Filter Form
$output .= '
';
// 7. Render Conditional Branch: Player Period Breakdown Report vs Charts
if ($is_player_period_mode) {
// Query goals specifically for Rangers, mapping player info, grouping by period
$player_goals_query = $wpdb->prepare("
SELECT p.id as player_id, s.scorer_name, s.period, COUNT(*) as goal_count
FROM otg_rangers_scoring s
JOIN otg_rangers_games g ON s.game_id = g.game_id
LEFT JOIN otg_players p ON s.scorer_name = p.Name
WHERE s.team_abbr = 'NYR'
AND s.time_elapsed != '00:00'
AND g.game_type = %s
$season_where
$game_filter
GROUP BY s.scorer_name, s.period
ORDER BY s.scorer_name ASC, s.period ASC
", $game_type);
$raw_player_data = $wpdb->get_results($player_goals_query);
// Organize into a structured matrix: player => [period => count]
$player_matrix = [];
$totals_by_period = [1 => 0, 2 => 0, 3 => 0, 'ot' => 0];
foreach ($raw_player_data as $row) {
$name = !empty($row->scorer_name) ? $row->scorer_name : 'Unknown / Unattributed';
$p_id = !empty($row->player_id) ? $row->player_id : '';
$p = (int)$row->period;
$p_key = ($p >= 4) ? 'ot' : $p;
if (!isset($player_matrix[$name])) {
$player_matrix[$name] = [
'player_id' => $p_id,
1 => 0, 2 => 0, 3 => 0, 'ot' => 0, 'total' => 0
];
}
$player_matrix[$name][$p_key] += (int)$row->goal_count;
$player_matrix[$name]['total'] += (int)$row->goal_count;
if (empty($player_matrix[$name]['player_id']) && !empty($p_id)) {
$player_matrix[$name]['player_id'] = $p_id;
}
if (isset($totals_by_period[$p_key])) {
$totals_by_period[$p_key] += (int)$row->goal_count;
}
}
// Parse sorting parameters for player breakdown table (default to total goals descending)
$sort_input = isset($_GET['sort']) ? sanitize_text_field($_GET['sort']) : 'total:desc';
$active_sorts = [];
foreach (explode(',', $sort_input) as $sort_pair) {
$parts = explode(':', trim($sort_pair));
if (!empty($parts[0])) {
$active_sorts[] = [
'col' => trim($parts[0]),
'dir' => (isset($parts[1]) && strtolower($parts[1]) === 'asc') ? 'asc' : 'desc'
];
}
}
if (empty($active_sorts)) {
$active_sorts[] = ['col' => 'total', 'dir' => 'desc'];
}
$active_sort_map = [];
foreach ($active_sorts as $index => $s_item) {
$active_sort_map[$s_item['col']] = [
'dir' => $s_item['dir'],
'priority' => count($active_sorts) > 1 ? ($index + 1) : null
];
}
// Apply Multi-column Sorting to Player Matrix
uasort($player_matrix, function($a, $b) use ($active_sorts) {
foreach ($active_sorts as $sort) {
$col = $sort['col'];
$dir = $sort['dir'];
$valA = $a[$col] ?? 0;
$valB = $b[$col] ?? 0;
if ($col === 'player_name') {
$cmp = strcasecmp($a['player_name'] ?? '', $b['player_name'] ?? '');
} else {
$cmp = ($valA == $valB) ? 0 : (($valA < $valB) ? -1 : 1);
}
if ($cmp !== 0) {
return ($dir === 'asc') ? $cmp : -$cmp;
}
}
return 0;
});
$output .= '';
// Hidden sort input to support column clicking for player breakdown report
$output .= '
';
$output .= '
';
$output .= '
Rangers Player Scoring Breakdown by Period
';
$output .= '
';
$output .= '
';
$output .= '';
$output .= '';
$headers_map = [
'player_name' => 'Player Name',
'1' => 'Period 1',
'2' => 'Period 2',
'3' => 'Period 3',
'ot' => 'Overtime (OT+)',
'total' => 'Total Goals'
];
foreach ($headers_map as $col_key => $col_label) {
$is_sorted = isset($active_sort_map[$col_key]);
$arrow = '';
$priority_badge = '';
if ($is_sorted) {
$arrow = ($active_sort_map[$col_key]['dir'] === 'asc') ? ' ▲' : ' ▼';
if ($active_sort_map[$col_key]['priority'] !== null) {
$priority_badge = ' ' . $active_sort_map[$col_key]['priority'] . '';
}
}
$th_class = $is_sorted ? 'highlight-col' : '';
$align_style = ($col_key === 'player_name') ? 'text-align: left;' : 'text-align: center;';
$output .= '| '.$col_label.$arrow.$priority_badge.' | ';
}
$output .= '
';
$output .= '';
$output .= '';
if (!empty($player_matrix)) {
$grand_total = 0;
foreach ($player_matrix as $p_name => $counts) {
$grand_total += $counts['total'];
$output .= '';
// Player Name column with profile link
$name_display = esc_html($p_name);
if (!empty($counts['player_id'])) {
$profile_url = home_url('/profile/?player_id=' . $counts['player_id']);
$name_display = '' . esc_html($p_name) . '';
}
$output .= '| ' . $name_display . ' | ';
$output .= '' . ($counts[1] > 0 ? $counts[1] : '-') . ' | ';
$output .= '' . ($counts[2] > 0 ? $counts[2] : '-') . ' | ';
$output .= '' . ($counts[3] > 0 ? $counts[3] : '-') . ' | ';
$output .= '' . ($counts['ot'] > 0 ? $counts['ot'] : '-') . ' | ';
$output .= '' . $counts['total'] . ' | ';
$output .= '
';
}
// Totals Row
$output .= '';
$output .= '| Team Totals | ';
$output .= '' . $totals_by_period[1] . ' | ';
$output .= '' . $totals_by_period[2] . ' | ';
$output .= '' . $totals_by_period[3] . ' | ';
$output .= '' . $totals_by_period['ot'] . ' | ';
$output .= '' . $grand_total . ' | ';
$output .= '
';
} else {
$output .= '| No player scoring records found for the selected filters. |
';
}
$output .= '';
$output .= '
';
$output .= '
';
$output .= '
';
$js_player_sorts = json_encode($active_sorts);
$output .= '';
} else {
// Summary Count Note for Visual Chart Card
$note_label = $is_response_mode ? 'Total Follow-up Goal Intervals Analyzed: ' : 'Total Goals Analyzed (time elapsed > 00:00): ';
$output .= '
' . $note_label . '' . $total_goals_counted . ' (Tip: Click any bar or segment to inspect game boxscores)
';
// 8. Render Visual Chart Card
$card_title = $is_response_mode ? 'Time Elapsed Following Prior Goal' : 'Minute-by-Minute Period Breakdown';
$output .= '';
$output .= '
';
$output .= '
' . $card_title . ' (Total Count: ' . $total_goals_counted . ')
';
$max_val = (int)$scale_max;
$three_quarter_val = (int)round($max_val * 0.75);
$mid_val = (int)round($max_val * 0.5);
$quarter_val = (int)round($max_val * 0.25);
$output .= '
';
// Left Scale Axis
$output .= '
';
$output .= '' . $max_val . '';
$output .= '' . $three_quarter_val . '';
$output .= '' . $mid_val . '';
$output .= '' . $quarter_val . '';
$output .= '0';
$output .= '
';
// Main Bar Grid Area
$output .= '
';
if (!$is_response_mode) {
$p1_pct = (20 / $max_buckets) * 100;
$p2_pct = (40 / $max_buckets) * 100;
$p3_pct = (60 / $max_buckets) * 100;
$output .= '
';
$output .= '
';
if ($max_buckets > 60) {
$output .= '
';
}
}
for ($m = 0; $m < $max_buckets; $m++) {
$count_norm = $breakdown_normal[$m];
$count_en = $breakdown_en[$m];
$total_count = $count_norm + $count_en;
$height_pct = ($scale_max > 0) ? max(4, round(($total_count / $scale_max) * 100)) : 4;
if ($total_count == 0) $height_pct = 3;
if (!$is_response_mode && $m >= 60) {
$ot_min_num = $m - 60;
$time_range_label = sprintf('Overtime (OT %d:%02d-%d:%02d)', $ot_min_num, 0, $ot_min_num, 59);
} else {
$time_range_label = $is_response_mode ? sprintf('%d-%d min elapsed after goal', $m, $m + 1) : sprintf('%02d:00-%02d:59', $m, $m);
}
$col_label = '';
if ($is_response_mode) {
$col_label = ($m % 5 == 0) ? ($m + 1) : '';
} else {
if ($m < 60) {
$col_label = $m + 1;
} else {
$col_label = $m - 60;
}
}
$title_tooltip = $time_range_label . ': ' . $total_count . ' occurrences (Click bar segments to view games)';
if ($count_en > 0) {
$title_tooltip .= ' (' . $count_norm . ' regular, ' . $count_en . ' empty-net)';
}
$output .= '
';
$output .= '
';
if ($total_count > 0) {
$output .= '
' . $total_count . '
';
} else {
$output .= '
0
';
}
$output .= '
';
if ($count_en > 0) {
$en_pct = ($total_count > 0) ? ($count_en / $total_count) * 100 : 0;
$en_click_url = add_query_arg(array_merge($base_query_params, [
'game_type' => $game_type,
'view_side' => $view_side,
'opponent_abbr' => $opponent_abbr,
'season_start' => $season_start,
'season_end' => $season_end,
'exclude_empty_net' => $exclude_empty_net,
'modal_min' => $m,
'modal_type' => 'en'
]), $current_url_clean);
$output .= '
';
}
if ($count_norm > 0) {
$norm_pct = ($total_count > 0) ? ($count_norm / $total_count) * 100 : 0;
$norm_click_url = add_query_arg(array_merge($base_query_params, [
'game_type' => $game_type,
'view_side' => $view_side,
'opponent_abbr' => $opponent_abbr,
'season_start' => $season_start,
'season_end' => $season_end,
'exclude_empty_net' => $exclude_empty_net,
'modal_min' => $m,
'modal_type' => 'normal'
]), $current_url_clean);
$output .= '
';
}
if ($total_count == 0) {
$output .= '
';
}
$output .= '
';
$output .= '
';
$output .= '
';
$output .= '' . $col_label . '';
$output .= '
';
$output .= '
';
}
$output .= '
';
// Right Scale Axis
$output .= '
';
$output .= '' . $max_val . '';
$output .= '' . $three_quarter_val . '';
$output .= '' . $mid_val . '';
$output .= '' . $quarter_val . '';
$output .= '0';
$output .= '
';
$output .= '
';
$output .= '
';
}
// 9. Render Modal Popup if selected_minute is active
if ($selected_minute !== '' && $selected_type !== '') {
$m_idx = (int)$selected_minute;
$t_key = ($selected_type === 'en') ? 'en' : 'normal';
$games_in_modal = $matching_games_by_minute[$m_idx][$t_key] ?? [];
if (!$is_response_mode && $m_idx >= 60) {
$time_title_label = sprintf('Overtime Minute %d', $m_idx - 60);
} else {
$time_title_label = $is_response_mode ? sprintf('%d-%d Minutes After Prior Goal', $m_idx, $m_idx + 1) : sprintf('%02d:00-%02d:59 Elapsed', $m_idx, $m_idx);
}
$type_title_label = ($t_key === 'en') ? 'Empty-Net Goals' : 'Regular Goals';
$close_modal_url = add_query_arg($base_query_params, $current_url_clean);
$close_modal_url = add_query_arg([
'game_type' => $game_type,
'view_side' => $view_side,
'opponent_abbr' => $opponent_abbr,
'season_start' => $season_start,
'season_end' => $season_end,
'exclude_empty_net' => $exclude_empty_net
], $close_modal_url);
$output .= '
';
$output .= '
';
$output .= '';
$output .= '
';
if (!empty($games_in_modal)) {
$output .= '
';
$output .= '| Season / Date | Opponent | Match Details | Action |
|---|
';
$output .= '';
foreach ($games_in_modal as $gm) {
$boxscore_url = home_url('/box/?game_id=' . $gm['game_id']);
$date_disp = !empty($gm['game_date']) ? $gm['game_date'] : $gm['season'];
$output .= '';
$output .= '| ' . esc_html($date_disp) . ' | ';
$output .= 'vs ' . esc_html($gm['opponent_abbr']) . ' | ';
$output .= '' . esc_html($gm['desc']) . ' | ';
$output .= 'View Box → | ';
$output .= '
';
}
$output .= '';
$output .= '
';
} else {
$output .= '
No specific games found for this segment.
';
}
$output .= '
';
$output .= '
';
$output .= '
';
$output .= '
';
$output .= '';
}
// JavaScript for View Switching & Smart Year Auto-Correction
$output .= '';
$output .= '
