/**
 * Shortcode to display merged player stats for a team.
 * Usage: [player_stats_on_venue match_id="62447" team="teama"]
 */

function display_merged_player_stats_shortcode($atts) {
    // Shortcode attributes with default values
    $atts = shortcode_atts([
        'match_id' => '',
        'team' => 'teama' // Default to teama
    ], $atts, 'player_stats_on_venue');

    // Validate match ID
    if (empty($atts['match_id'])) {
        return '<p>Error: Match ID is required.</p>';
    }

    $match_id = sanitize_text_field($atts['match_id']);
    $selected_team = sanitize_text_field($atts['team']);
    $csv_file_path = WP_CONTENT_DIR . "/uploads/match_stats_{$match_id}_{$selected_team}.csv";

    // Check if CSV exists
    if (file_exists($csv_file_path)) {
        // Read CSV data
        $csv_data = array_map('str_getcsv', file($csv_file_path));
        $header = array_shift($csv_data); // Remove header row
        $merged_stats = [];
        foreach ($csv_data as $row) {
            $merged_stats[] = array_combine($header, $row);
        }
    } else {
        // Fetch data from API
        $match_info_url = API_CALL_BASE_URL . "v4/matches/$match_id/advance?token=" . GENERATE_DRAFT_TOKEN;
        $match_response = wp_remote_get($match_info_url);

        if (is_wp_error($match_response)) {
            return '<p>Error: Unable to fetch match info.</p>';
        }

        $match_response_code = wp_remote_retrieve_response_code($match_response);
        if ($match_response_code !== 200) {
            return '<p>Error: Unable to fetch match info. API returned an error code: ' . $match_response_code . '</p>';
        }

        $match_data = json_decode(wp_remote_retrieve_body($match_response), true);

        // Extract teams and stats
        $teama = $match_data['response']['items']['info']['teama'] ?? [];
        $teamb = $match_data['response']['items']['info']['teamb'] ?? [];

        $team1 = [];
        $batting_stats = [];
        $bowling_stats = [];

        if ($selected_team === 'teama') {
            $team1 = $teama;
            $batting_stats = $match_data['response']['items']['player_batting_stats_on_venue']['team1'] ?? [];
            $bowling_stats = $match_data['response']['items']['player_bowling_stats_on_venue']['team1'] ?? [];
        } elseif ($selected_team === 'teamb') {
            $team1 = $teamb;
            $batting_stats = $match_data['response']['items']['player_batting_stats_on_venue']['team2'] ?? [];
            $bowling_stats = $match_data['response']['items']['player_bowling_stats_on_venue']['team2'] ?? [];
        } else {
            return '<p>Error: Invalid team selection. Use "teama" or "teamb".</p>';
        }

        // Combine stats for CSV
        $merged_stats = [];
        foreach ($batting_stats as $batsman) {
            $player_name = $batsman['batsman_title'];
            $merged_stats[$player_name] = [
                'player' => $player_name,
                'innings' => $batsman['innings'] ?? '',
                'runs' => $batsman['runs'] ?? '',
                'wickets' => '',
                'bat_sr' => $batsman['strike'] ?? '',
                'bat_avg' => $batsman['average'] ?? '',
                'bowl_eco' => ''
            ];
        }
        foreach ($bowling_stats as $bowler) {
            $player_name = $bowler['bowler_title'];
            if (!isset($merged_stats[$player_name])) {
                $merged_stats[$player_name] = [
                    'player' => $player_name,
                    'innings' => $bowler['innings'] ?? '',
                    'runs' => '',
                    'wickets' => $bowler['wickets'] ?? '',
                    'bat_sr' => '',
                    'bat_avg' => '',
                    'bowl_eco' => $bowler['econ'] ?? ''
                ];
            } else {
                $merged_stats[$player_name]['wickets'] = $bowler['wickets'] ?? '';
                $merged_stats[$player_name]['bowl_eco'] = $bowler['econ'] ?? '';
            }
        }

        // Write data to CSV
        $csv_header = ['player', 'innings', 'runs', 'wickets', 'bat_sr', 'bat_avg', 'bowl_eco'];
        $csv_handle = fopen($csv_file_path, 'w');
        fputcsv($csv_handle, $csv_header);
        foreach ($merged_stats as $row) {
            fputcsv($csv_handle, $row);
        }
        fclose($csv_handle);
    }

    // Generate HTML table
    $html = "<h3>Player Stats for Team: {$selected_team}</h3>";
    $html .= "<table border='1' style='width:100%; text-align:left; border-collapse:collapse; margin-bottom: 20px;'>
        <thead>
            <tr style='background-color:#d4f1c5;'>
                <th>Player</th>
                <th>Innings</th>
                <th>Runs</th>
                <th>Wickets</th>
                <th>BAT SR</th>
                <th>BAT Avg</th>
                <th>BOWL ECO</th>
            </tr>
        </thead>
        <tbody>";
    foreach ($merged_stats as $stats) {
        $html .= "<tr>
            <td>{$stats['player']}</td>
            <td>{$stats['innings']}</td>
            <td>{$stats['runs']}</td>
            <td>{$stats['wickets']}</td>
            <td>{$stats['bat_sr']}</td>
            <td>{$stats['bat_avg']}</td>
            <td>{$stats['bowl_eco']}</td>
        </tr>";
    }
    $html .= "</tbody></table>";

    return $html;
}

// Register the shortcode
add_shortcode('player_stats_on_venue', 'display_merged_player_stats_shortcode');
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/myfinjex/public_html/wp-content/plugins/cricket-live-dream11/includes/venue stats/player_batting_stats_on_venue.php:1) in <b>/home/myfinjex/public_html/wp-includes/pluggable.php</b> on line <b>1435</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/myfinjex/public_html/wp-content/plugins/cricket-live-dream11/includes/venue stats/player_batting_stats_on_venue.php:1) in <b>/home/myfinjex/public_html/wp-includes/pluggable.php</b> on line <b>1438</b><br />