';
} else {
$badge_html .= esc_html($fa_upper);
}
$badge_html .= '';
return $badge_html;
}
return esc_html($fa_raw_trimmed);
};
// ==========================================
// MULTI-YEAR SUMMARY LOGIC & RENDER
// ==========================================
if ($current_view === 'summary') {
$all_players_query = "SELECT DISTINCT player_id FROM {$years_table} WHERE player_id IS NOT NULL AND player_id != ''";
$all_player_ids = $wpdb->get_col($all_players_query);
if (!empty($all_player_ids)) {
$ids_str = implode("','", array_map('esc_sql', $all_player_ids));
$future_query = "
SELECT
T2.player_id AS profile_id,
T2.player_id,
T1.aav,
T1.free_agent_type,
T1.fa_season,
T2.season,
T2.cap_hit,
T2.clause,
T2.roster_status,
p.Name AS player_name,
p.position AS player_position
FROM {$years_table} AS T2
LEFT JOIN {$contracts_table} AS T1 ON T2.contract_id = T1.contract_id
LEFT JOIN {$players_table} AS p ON T2.player_id = p.ID
WHERE T2.player_id IN ('$ids_str')
";
$future_records = $wpdb->get_results($future_query);
} else {
$future_records = [];
}
$player_future_years = [];
$player_meta = [];
foreach ($future_records as $fr) {
$pid = $fr->player_id;
$status_check = strtolower(trim($fr->roster_status));
$clause_check = strtoupper(trim($fr->clause));
$is_ret_35 = ($status_check === 'retired' && ($clause_check === '35+' || $clause_check === '35 PLUS' || strpos($clause_check, '35+') !== false));
if ($status_check === 'deceased' || ($status_check === 'retired' && !$is_ret_35)) {
continue;
}
if (!isset($player_future_years[$pid])) {
$player_future_years[$pid] = [];
}
$one_way_val = $wpdb->get_var($wpdb->prepare(
"SELECT one_way FROM {$years_table} WHERE player_id = %s AND season = %s LIMIT 1",
$pid,
$fr->season
));
if ($one_way_val === null) {
$one_way_val = $wpdb->get_var($wpdb->prepare(
"SELECT one_way FROM {$contracts_table} AS T1 JOIN {$years_table} AS T2 ON T1.contract_id = T2.contract_id WHERE T2.player_id = %s AND T2.season = %s LIMIT 1",
$pid,
$fr->season
));
}
$effective_cap_hit = floatval($fr->cap_hit);
if ($is_ret_35) {
$effective_cap_hit = 0;
}
$player_future_years[$pid][$fr->season] = [
'cap_hit' => $effective_cap_hit,
'raw_cap_hit' => floatval($fr->cap_hit),
'clause' => $fr->clause,
'fa_type' => $fr->free_agent_type,
'one_way' => $one_way_val,
'roster_status' => $fr->roster_status
];
if (!isset($player_meta[$pid])) {
$player_meta[$pid] = $fr;
}
}
$min_season = null;
$max_season = null;
foreach ($future_records as $fr) {
if (!empty($fr->season)) {
if ($min_season === null || strcmp($fr->season, $min_season) < 0) $min_season = $fr->season;
if ($max_season === null || strcmp($fr->season, $max_season) > 0) $max_season = $fr->season;
}
}
if ($min_season === null) $min_season = $default_season;
if ($max_season === null) $max_season = $default_season;
$inc_season = function($s) {
$p = explode('-', $s);
if (count($p) == 2) {
return ($p[0]+1) . '-' . str_pad(($p[1]+1), 2, '0', STR_PAD_LEFT);
}
return $s;
};
$display_seasons = [];
$curr = $min_season;
while (strcmp($curr, $max_season) <= 0) {
$display_seasons[] = $curr;
$curr = $inc_season($curr);
}
if (!in_array($max_season, $display_seasons)) {
$display_seasons[] = $max_season;
}
$season_caps = [];
$caps_results = $wpdb->get_results("SELECT season, salary_cap FROM {$settings_table}");
foreach ($caps_results as $cr) {
$season_caps[$cr->season] = floatval($cr->salary_cap);
}
$sum_forwards = [];
$sum_defense = [];
$sum_goalies = [];
$sum_bought_out = [];
$sum_retained = [];
$sum_bonuses = [];
$sum_retired_35_plus = [];
$sum_buried_contracts = [];
$sum_non_roster_forwards = [];
$sum_non_roster_defense = [];
$sum_non_roster_goalies = [];
$sum_non_roster_other = [];
foreach ($player_meta as $pid => $row) {
$status = strtolower(trim($row->roster_status));
$clause = strtoupper(trim($row->clause));
$pos = trim($row->player_position);
$is_ret_35 = ($status === 'retired' && ($clause === '35+' || $clause === '35 PLUS' || strpos($clause, '35+') !== false));
if ($status === 'deceased' || ($status === 'retired' && !$is_ret_35)) {
continue;
}
if ($is_ret_35) {
$sum_retired_35_plus[] = $row;
continue;
}
if ($status === 'buyout' || strpos($status, 'buyout') !== false) {
$sum_bought_out[] = $row;
continue;
}
if ($status === 'retained' || strpos($status, 'retained') !== false) {
$sum_retained[] = $row;
continue;
}
if ($status === 'bonus' || strpos($status, 'bonus') !== false || strpos($status, 'bonus charge') !== false || $status === 'bonus carryover' || strpos($status, 'carryover') !== false) {
$sum_bonuses[] = $row;
continue;
}
// Check buried status per season in generator logic or group globally if any season matches buried criteria
$is_non_roster = ($status === 'minors/buried' || $status === 'minors' || $status === 'buried' || strpos($status, 'minor') !== false);
// Check if player has any season where they qualify as a buried contract (> league minimum)
$has_buried_season = false;
if (isset($player_future_years[$pid])) {
foreach ($player_future_years[$pid] as $s_yr => $s_data) {
$s_status = strtolower(trim($s_data['roster_status']));
$s_is_minors = ($s_status === 'minors/buried' || $s_status === 'minors' || $s_status === 'buried' || strpos($s_status, 'minor') !== false);
if ($s_is_minors && $s_data['raw_cap_hit'] > $league_minimum_val) {
$has_buried_season = true;
break;
}
}
}
if ($has_buried_season) {
$sum_buried_contracts[] = $row;
} elseif ($is_non_roster) {
if (in_array($pos, ['C', 'L', 'R', 'Center', 'Left Wing', 'Right Wing'])) {
$sum_non_roster_forwards[] = $row;
} elseif (in_array($pos, ['D', 'Defenseman'])) {
$sum_non_roster_defense[] = $row;
} elseif (in_array($pos, ['G', 'Goaltender'])) {
$sum_non_roster_goalies[] = $row;
} else {
$sum_non_roster_other[] = $row;
}
} else {
if (in_array($pos, ['C', 'L', 'R', 'Center', 'Left Wing', 'Right Wing'])) {
$sum_forwards[] = $row;
} elseif (in_array($pos, ['D', 'Defenseman'])) {
$sum_defense[] = $row;
} elseif (in_array($pos, ['G', 'Goaltender'])) {
$sum_goalies[] = $row;
} else {
$sum_forwards[] = $row;
}
}
}
$total_cols = count($display_seasons) + 1;
$html .= '| Player | '; foreach ($display_seasons as $s) { $html .= '' . esc_html($s) . ' | '; } $html .= '
|---|---|
| ' . esc_html($title) . ' | |
| ' . esc_html($display_name) . '' . $player_status_icon . ' | '; $fa_season_target = $inc_season($p_max_season); foreach ($display_seasons as $s) { $sec_html .= '';
if (isset($p_data[$s])) {
$raw_ch = $p_data[$s]['raw_cap_hit'];
$clause = $p_data[$s]['clause'];
$one_way_val = $p_data[$s]['one_way'];
$s_status = strtolower(trim($p_data[$s]['roster_status']));
$s_is_minors = ($s_status === 'minors/buried' || $s_status === 'minors' || $s_status === 'buried' || strpos($s_status, 'minor') !== false);
$display_ch = $raw_ch;
if ($is_buried_section && $s_is_minors && $raw_ch > $league_minimum_val) {
$display_ch = $raw_ch - $league_minimum_val + 375000;
} elseif ($is_buried_section && (!$s_is_minors || $raw_ch <= $league_minimum_val)) {
$display_ch = 0; // Does not apply to this block for this season
}
if ($display_ch > 0) {
$season_totals[$s] += $display_ch;
}
if ($display_ch > 0 || !$is_buried_section) {
$sec_html .= ' ';
$left_group = ' ';
} else {
$sec_html .= '';
if (!empty($clause)) {
$c_info = $get_clause_details($clause);
$left_group .= '' . esc_html($clause) . '';
}
if ($one_way_val !== null && strtolower(trim((string)$one_way_val)) === 'n') {
$left_group .= ' ';
$sec_html .= $left_group;
$sec_html .= '$' . number_format($display_ch, 0) . '';
$sec_html .= ' ';
}
$left_group .= '- ';
}
} elseif ($s === $fa_season_target) {
$sec_html .= '' . $render_fa_badge($latest_fa_type) . ' ';
} else {
$sec_html .= '- ';
}
$sec_html .= ' | ';
}
$sec_html .= '
| ' . esc_html($title) . ' Total: | '; foreach ($display_seasons as $s) { $sec_html .= '';
if ($season_totals[$s] > 0) {
$sec_html .= ' $' . number_format($season_totals[$s], 0) . ' ';
} else {
$sec_html .= '-';
}
$sec_html .= ' | ';
}
$sec_html .= '
| Season Summary Breakdown | |
| ' . esc_html($label) . ' | '; foreach ($display_seasons as $s) { $val = isset($totals_arr[$s]) ? $totals_arr[$s] : 0; $r_html .= '';
if ($val > 0) {
$r_html .= ' $' . number_format($val, 0) . ' ';
} else {
$r_html .= '- ';
}
$r_html .= ' | ';
}
$r_html .= '
| Cap Space: | '; foreach ($display_seasons as $s) { $c_space = $cap_space_totals[$s]; $space_color = $c_space >= 0 ? '#2ecc71' : '#e74c3c'; $summary_block_html .= '';
$summary_block_html .= ' $' . number_format($c_space, 0) . ' ';
$summary_block_html .= ' | ';
}
$summary_block_html .= '
Non-Roster Players |
| Player | '; $html .= 'Position | '; $html .= 'Cap Hit | '; $html .= 'Status | '; $html .= 'Actual Days | '; $html .= 'Projected Days | '; $html .= 'FA Type | '; $html .= 'FA Season | '; $html .= 'Waivers | '; $html .= '
|---|---|---|---|---|---|---|---|---|
| ' . esc_html($display_name) . '' . $player_status_icon . ' | '; $html .= '' . esc_html($row->player_position) . ' | '; $html .= '';
if (!empty($row->cap_hit)) {
$contract_info = $wpdb->get_row($wpdb->prepare(
"SELECT one_way FROM {$contracts_table} WHERE player_id = %s OR contract_id = (SELECT contract_id FROM {$years_table} WHERE player_id = %s AND season = %s LIMIT 1) LIMIT 1",
$row->player_id,
$row->player_id,
$selected_season
));
$one_way_val = $contract_info ? $contract_info->one_way : null;
if ($one_way_val === null) {
$one_way_val = $wpdb->get_var($wpdb->prepare(
"SELECT one_way FROM {$years_table} WHERE player_id = %s AND season = %s LIMIT 1",
$row->player_id,
$selected_season
));
}
$raw_cap_val = floatval($row->cap_hit);
$display_cap_val = $raw_cap_val;
if ($is_buried_block && $raw_cap_val > $league_minimum_val) {
$display_cap_val = $raw_cap_val - $league_minimum_val + 375000;
}
$html .= ' ';
$left_group = ' ';
} else {
$html .= '-';
}
$html .= '';
if (!empty($row->clause)) {
$c_info = $get_clause_details($row->clause);
$left_group .= '' . esc_html($row->clause) . '';
}
if ($one_way_val !== null && strtolower(trim((string)$one_way_val)) === 'n') {
$left_group .= ' ';
$html .= $left_group;
$cap_display_text = '$' . number_format($display_cap_val, 0);
$html .= '' . $cap_display_text . '';
$html .= '';
}
$left_group .= ' | ';
$html .= '' . (!empty($row->roster_status) ? esc_html($row->roster_status) : 'Free Agent') . ' | '; $html .= '' . (!empty($row->cap_hit) && $actual_days !== '' ? $actual_days : '-') . ' | '; $html .= '' . (!empty($row->cap_hit) && $projected_days !== '' ? $projected_days : '-') . ' | '; $html .= '' . $render_fa_badge($row->free_agent_type) . ' | ';
$html .= '' . esc_html($row->fa_season) . ' | '; $html .= '' . esc_html($waiver_status['label']) . ' | '; $html .= '
| ' . esc_html($title) . ' Total: | '; $html .= '$' . number_format($section_sum, 0) . ' | ';
$html .= ''; $html .= ' | ||||||
