--- FILE STRUCTURE ---
context_generator.php
curl_test.php
database.sql
delete_log.php
edit_log.php
log_entry.html
submit_log.php
views_logs.php


--- FILE: ./views_logs.php ---
<?php
// views_logs.php

// --- Schedule Hardcoded Data ---
$team_name = 'Boise State';
$today_date = date('Y-m-d'); 
$current_year = date('Y');

// Hardcoded 2025 Home Games Schedule
// Added 'sport' and 'attendance' fields to all games
$football_home_games = [
    // These games are PAST as of Oct 28, 2025, and will be auto-removed.
    ['date' => '2025-09-05', 'day' => 'Friday', 'opponent' => 'Eastern Washington', 'time' => '7:00 PM MT', 'sport' => 'Football 🏈', 'attendance' => '33,000'], // Non-Conference Estimate
    ['date' => '2025-09-27', 'day' => 'Saturday', 'opponent' => 'Appalachian State', 'time' => '5:30 PM MT', 'sport' => 'Football 🏈', 'attendance' => '36,363 (Sellout)'], // Marquee Non-Conference Estimate
    ['date' => '2025-10-11', 'day' => 'Saturday', 'opponent' => 'New Mexico', 'time' => '7:45 PM MT', 'sport' => 'Football 🏈', 'attendance' => '34,500'], // Weekday Conference Estimate
    ['date' => '2025-10-18', 'day' => 'Saturday', 'opponent' => 'UNLV', 'time' => '1:30 PM MT', 'sport' => 'Football 🏈', 'attendance' => '36,363 (Sellout)'], // Key Conference Game Estimate
    
    // These games are UPCOMING and will be displayed.
    ['date' => '2025-11-01', 'day' => 'Saturday', 'opponent' => 'Fresno State', 'time' => '1:30 PM MT', 'sport' => 'Football 🏈', 'attendance' => '36,363 (Sellout)'], // Rivalry/Key Conference Game Estimate
    ['date' => '2025-11-22', 'day' => 'Saturday', 'opponent' => 'Colorado State', 'time' => 'TBD', 'sport' => 'Football 🏈', 'attendance' => '36,363 (Sellout)'], // Key Conference Game Estimate
];

// UPDATED: Hardcoded 2025-2026 Men's Basketball Home Games Schedule (from provided link, Boise games only)
$basketball_home_games = [
    // All games are at ExtraMile Arena, Boise, ID
    ['date' => '2025-11-03', 'day' => 'Monday', 'opponent' => 'Hawaii Pacific Sharks', 'time' => '7:00 PM MT', 'sport' => 'Basketball 🏀', 'attendance' => '9,000'],
    ['date' => '2025-11-08', 'day' => 'Saturday', 'opponent' => 'Utah Valley Wolverines', 'time' => '2:00 PM MT', 'sport' => 'Basketball 🏀', 'attendance' => '9,500'],
    ['date' => '2025-11-11', 'day' => 'Tuesday', 'opponent' => 'UT Rio Grande Valley Vaqueros', 'time' => '7:00 PM MT', 'sport' => 'Basketball 🏀', 'attendance' => '9,000'],
    ['date' => '2025-11-15', 'day' => 'Saturday', 'opponent' => 'Montana State Bobcats', 'time' => '2:00 PM MT', 'sport' => 'Basketball 🏀', 'attendance' => '10,500'],
    ['date' => '2025-11-18', 'day' => 'Tuesday', 'opponent' => 'Wichita State Shockers', 'time' => '7:00 PM MT', 'sport' => 'Basketball 🏀', 'attendance' => '11,000'],
    ['date' => '2025-12-10', 'day' => 'Wednesday', 'opponent' => 'Duquesne Dukes', 'time' => '7:00 PM MT', 'sport' => 'Basketball 🏀', 'attendance' => '8,500'],
    ['date' => '2025-12-30', 'day' => 'Tuesday', 'opponent' => 'New Mexico Lobos', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '12,000'],
    // Switch to 2026 season dates
    ['date' => '2026-01-06', 'day' => 'Tuesday', 'opponent' => 'Grand Canyon Antelopes', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '10,000'],
    ['date' => '2026-01-10', 'day' => 'Saturday', 'opponent' => 'Utah State Aggies', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '13,500'],
    ['date' => '2026-01-17', 'day' => 'Saturday', 'opponent' => 'Colorado State Rams', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '12,500'],
    ['date' => '2026-01-24', 'day' => 'Saturday', 'opponent' => 'Air Force Academy Falcons', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '11,000'],
    ['date' => '2026-02-03', 'day' => 'Tuesday', 'opponent' => 'Nevada Wolf Pack', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '13,000'],
    ['date' => '2026-02-14', 'day' => 'Saturday', 'opponent' => 'UNLV Rebels', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '12,500'],
    ['date' => '2026-02-21', 'day' => 'Saturday', 'opponent' => 'San Jose State Spartans', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '10,000'],
    ['date' => '2026-02-24', 'day' => 'Tuesday', 'opponent' => 'Wyoming Cowboys', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '10,500'],
    ['date' => '2026-03-03', 'day' => 'Tuesday', 'opponent' => 'San Diego State Aztecs', 'time' => 'TBA', 'sport' => 'Basketball 🏀', 'attendance' => '14,000+'],
];

// COMBINE all home games
$all_home_games_data = array_merge($football_home_games, $basketball_home_games);

// Variables to store results
$is_home_game_day = false;
$api_status_message = '';
$upcoming_events_list = []; // This will store the filtered list

// Filter games: only keep those whose date is today or in the future
foreach ($all_home_games_data as $game) {
    
    // Logic to auto-remove past games
    if ($game['date'] >= $today_date) {
        $upcoming_events_list[] = $game;
    }

    // Check if TODAY is a game day (needs to check against the full list)
    if ($game['date'] === $today_date) {
        $is_home_game_day = true;
        $today_game_sport = $game['sport']; 
    }
}

// Assign the filtered list to the variable used for display
$home_events_list = $upcoming_events_list; 

// Sort the list by date to ensure chronological order
usort($home_events_list, function($a, $b) {
    return $a['date'] <=> $b['date'];
});

if (!$is_home_game_day) {
    $api_status_message = "Hardcoded schedule successfully loaded. No Boise State home game today, {$today_date}.";
} else {
    $api_status_message = "Successfully detected a hardcoded home game today.";
}


// --- Database Connection and Data Fetching for Chart and Table ---
$mysqli = new mysqli("localhost", "harper_chicken_log", "S>aPg-5UEjfxH_>S", "harper_chicken_log");
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Fetch data for the chart
$result_chart = $mysqli->query("SELECT log_date, main_oven_case_count, harvested_after_close, harvested_before_close FROM logs ORDER BY log_date ASC");

$chart_data = [];
if ($result_chart) {
    while ($row = $result_chart->fetch_assoc()) {
        $main_oven_count = $row['main_oven_case_count'] ?? 0;
        $harvested_after_close = $row['harvested_after_close'] ?? 0;
        $harvested_before_close = $row['harvested_before_close'] ?? 0;
        // Actual Sold = Main Oven/Case Count - Harvested After Close - Harvested Before Close
        $actual_sold = $main_oven_count - $harvested_after_close - $harvested_before_close;

        $chart_data[] = [
            'date' => $row['log_date'],
            'sales' => $actual_sold 
        ];
    }
    $result_chart->free();
}

$chart_data_json = json_encode($chart_data);
// Re-fetch data for the main table display
$result = $mysqli->query("SELECT * FROM logs ORDER BY log_date DESC");

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>View Chicken Logs</title>
    <script src="https://cdn.jsdelivr.net/npm/chart.js@3.7.1/dist/chart.min.js"></script>
    
    <style>
        body {
            padding-top: 50px; 
            font-family: Arial, sans-serif;
        }

        /* CSS for the HOME GAME ALERT */
        .game-alert {
            background-color: #ff9900; 
            color: #0033a0; 
            padding: 10px;
            text-align: center;
            font-size: 1.5em;
            font-weight: bold;
            margin-bottom: 20px;
            border-radius: 5px;
            border: 2px solid #0033a0;
        }

        /* Chart/Schedule containers */
        #chart-container, #schedule-container {
            position: fixed; 
            top: 0;
            left: 0;
            width: 100%;
            height: 350px; 
            background-color: #f7f7f7;
            border-bottom: 2px solid #ccc;
            z-index: 1000;
            padding: 10px;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
            display: none; 
            overflow-y: auto; /* Allow scroll for long schedules */
        }
        
        #schedule-container {
            /* Distinct color/style for schedule */
            background-color: #e6f7ff; 
            padding-left: 20px;
        }
        
        #schedule-container h3 {
            color: #0033a0;
        }
        
        .schedule-item {
            padding: 5px 0;
            border-bottom: 1px dashed #ccc;
        }
        
        .schedule-item:last-child {
            border-bottom: none;
        }

        /* Button Group Container */
        .button-group {
            position: fixed;
            top: 10px;
            right: 10px;
            z-index: 1001; 
        }

        /* Button styles */
        .toggle-btn {
            padding: 8px 12px;
            background-color: #007bff;
            color: white;
            border: none;
            border-radius: 5px;
            cursor: pointer;
            margin-left: 5px;
        }

        /* --- New CSS for Simplified View --- */
        .toggle-btn#toggle-simplified-btn {
             background-color: #28a745; /* Green color for the new button */
        }

        /* Table Styles */
        table {
            width: 95%;
            margin: 20px auto;
            border-collapse: collapse;
            /* Added transition for smooth hide/show, but display:none prevents smooth transition */
        }
        th, td {
            border: 1px solid #ddd;
            padding: 8px;
            text-align: left;
        }
        th {
            background-color: #f2f2f2;
        }

        /* Classes to hide columns in simplified view */
        .hide-in-simplified {
            /* Use a combination of display: none and visibility: collapse for cross-browser compatibility */
            display: none;
        }
        
        /* When the table has the 'simplified' class, hide the columns with 'hide-in-simplified' */
        table.simplified .hide-in-simplified {
            display: none;
        }

        /* Ensure the required columns are visible (this is technically redundant but good for clarity) */
        table.simplified .show-in-simplified {
            display: table-cell; /* For td elements */
        }

        /* Highlight the Actual Sold column */
        .highlight-sold {
            background-color: #fff3cd; /* Light yellow background */
            font-weight: bold;
            color: #856404; /* Darker text for contrast */
        }
        /* Keep the highlight in the simplified view too */
        table.simplified .highlight-sold {
            background-color: #ffe48a; /* Slightly different highlight for simplified view */
        }
        /* --- End New CSS --- */

        .chart-header {
            text-align: center;
            margin-bottom: 10px;
        }
    </style>
</head>
<body>

    <div class="button-group">
        <button id="toggle-simplified-btn" class="toggle-btn">Simplified View</button>
        <button id="toggle-schedule-btn" class="toggle-btn">Show Home Games Schedule</button>
        <button id="toggle-chart-btn" class="toggle-btn">Show Actual Sold Trend</button>
    </div>

    <div id="chart-container">
        <div class="chart-header">
            <h3>Actual Sold Trend Line</h3>
        </div>
        <canvas id="salesChart"></canvas>
    </div>
    
    <div id="schedule-container">
        <h3>Boise State Upcoming Home Events - <?php echo $current_year; ?> Season</h3>
        <?php if (empty($home_events_list)): ?>
            <p>No **upcoming** home events found. Schedule status: <?php echo htmlspecialchars($api_status_message); ?></p>
        <?php else: ?>
            <?php foreach ($home_events_list as $game): ?>
                <div class="schedule-item">
                    **<?php echo htmlspecialchars($game['sport']); ?>** | **<?php echo htmlspecialchars($game['day']); ?>**, <?php echo htmlspecialchars($game['date']); ?>
                    | **Opponent:** <?php echo htmlspecialchars($game['opponent']); ?>
                    | **Start Time:** <?php echo htmlspecialchars($game['time']); ?>
                    | **Est. Attendance:** **<?php echo htmlspecialchars($game['attendance']); ?>**
                </div>
            <?php endforeach; ?>
        <?php endif; ?>
    </div>

    <?php if ($is_home_game_day): ?>
        <div class="game-alert">
            🚨 **TODAY IS A BSU HOME GAME!** (Factor into sales prediction)
        </div>
    <?php endif; ?>

    <h1>Daily Chicken Logs</h1>
    <a href="log_entry.html">Add New Log</a>
    
    <table id="logs-table">
        <tr>
            <th class="show-in-simplified">Date</th>
            <th class="show-in-simplified">Day Name</th>
            <th class="hide-in-simplified">Main Oven/Case Count</th>
            <th class="hide-in-simplified">M.O. Time</th>
            <th class="hide-in-simplified">Emergency Oven/Case Count</th>
            <th class="hide-in-simplified">E.O. Time</th>
            <th class="show-in-simplified">Run Out Time</th>
            <th class="hide-in-simplified">Harvested After Close</th>
            <th class="hide-in-simplified">Paper Prediction</th>
            <th class="hide-in-simplified">Harvested Before Close</th>
            <th class="show-in-simplified highlight-sold">Actual Sold</th>
            <th class="show-in-simplified">Notes</th>
            <th class="show-in-simplified" colspan="2">Actions</th>
        </tr>

        <?php
        if ($result && $result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $main_oven_count = $row['main_oven_case_count'] ?? 0;
                $harvested_after_close = $row['harvested_after_close'] ?? 0;
                $harvested_before_close = $row['harvested_before_close'] ?? 0;
                // Calculation: Actual Sold = Main Oven Count - Harvested After Close - Harvested Before Close
                $sold = $main_oven_count - $harvested_after_close - $harvested_before_close;
                
                // Added classes to all <td> elements based on required visibility
                echo "<tr>
                    <td class='show-in-simplified'>{$row['log_date']}</td>
                    <td class='show-in-simplified'>{$row['day_name']}</td>
                    <td class='hide-in-simplified'>{$row['main_oven_case_count']}</td>
                    <td class='hide-in-simplified'>{$row['main_oven_case_count_time']}</td>
                    <td class='hide-in-simplified'>{$row['emergency_oven_case_count']}</td>
                    <td class='hide-in-simplified'>{$row['emergency_oven_case_count_time']}</td>
                    <td class='show-in-simplified'>{$row['run_out_time']}</td>
                    <td class='hide-in-simplified'>{$row['harvested_after_close']}</td>
                    <td class='hide-in-simplified'>{$row['paper_prediction']}</td>
                    <td class='hide-in-simplified'>{$row['harvested_before_close']}</td>
                    <td class='show-in-simplified highlight-sold'>{$sold}</td>
                    <td class='show-in-simplified'>" . htmlspecialchars($row['notes'] ?? '') . "</td>
                    <td class='show-in-simplified'><a href='edit_log.php?id={$row['id']}'>Edit</a></td>
                    <td class='show-in-simplified'>
                        <form method='POST' action='delete_log.php' onsubmit=\"return confirm('Are you sure you want to delete this log?');\">
                            <input type='hidden' name='id' value='{$row['id']}'>
                            <button type='submit'>Delete</button>
                        </form>
                    </td>
                </tr>";
            }
        } else {
            echo "<tr><td colspan='14'>No logs found.</td></tr>"; // Changed colspan to 14
        }
        $mysqli->close();
        ?>
    </table>

    <script>
        document.addEventListener('DOMContentLoaded', function() {
            // --- Chart Logic (Same as before) ---
            const rawData = <?php echo $chart_data_json; ?>;
            const labels = rawData.map(item => item.date);
            const salesData = rawData.map(item => item.sales);

            const ctx = document.getElementById('salesChart').getContext('2d');
            const salesChart = new Chart(ctx, {
                type: 'line', 
                data: {
                    labels: labels,
                    datasets: [{
                        label: 'Actual Sold',
                        data: salesData,
                        borderColor: 'rgb(75, 192, 192)',
                        tension: 0.2, 
                        fill: false,
                        pointRadius: 4, 
                        pointHoverRadius: 6
                    }]
                },
                options: {
                    responsive: true,
                    maintainAspectRatio: false,
                    scales: {
                        y: {
                            beginAtZero: true,
                            title: {
                                display: true,
                                text: 'Actual Sold Count'
                            }
                        },
                        x: {
                            title: {
                                display: true,
                                text: 'Date'
                            }
                        }
                    },
                    plugins: {
                        legend: {
                            display: false
                        }
                    }
                }
            });

            // --- Toggle Logic for Chart and Schedule ---
            const chartContainer = document.getElementById('chart-container');
            const toggleChartButton = document.getElementById('toggle-chart-btn');
            
            // New elements
            const scheduleContainer = document.getElementById('schedule-container');
            const toggleScheduleButton = document.getElementById('toggle-schedule-btn');

            function toggleContainer(container, button, chartInstance = null) {
                const isHidden = container.style.display === 'none' || container.style.display === '';
                const hideAll = () => {
                    chartContainer.style.display = 'none';
                    scheduleContainer.style.display = 'none';
                    toggleChartButton.textContent = 'Show Actual Sold Trend';
                    toggleScheduleButton.textContent = 'Show Home Games Schedule';
                };
                
                hideAll(); // Hide both first

                if (isHidden) {
                    container.style.display = 'block';
                    button.textContent = `Hide ${container === chartContainer ? 'Actual Sold Trend' : 'Home Games Schedule'}`;
                    if (chartInstance) {
                        chartInstance.resize(); 
                    }
                } else {
                    button.textContent = `Show ${container === chartContainer ? 'Actual Sold Trend' : 'Home Games Schedule'}`;
                }
            }

            // Event Listeners
            toggleChartButton.addEventListener('click', function() {
                toggleContainer(chartContainer, toggleChartButton, salesChart);
            });
            
            toggleScheduleButton.addEventListener('click', function() {
                toggleContainer(scheduleContainer, toggleScheduleButton);
            });


            // --- New Simplified View Toggle Logic ---
            const logsTable = document.getElementById('logs-table');
            const toggleSimplifiedButton = document.getElementById('toggle-simplified-btn');

            function toggleSimplifiedView() {
                // Check if the table is currently in simplified view
                const isSimplified = logsTable.classList.contains('simplified');
                
                if (isSimplified) {
                    // Switch back to normal view
                    logsTable.classList.remove('simplified');
                    toggleSimplifiedButton.textContent = 'Simplified View';
                    // Re-show all columns
                    const hiddenCells = logsTable.querySelectorAll('.hide-in-simplified');
                    hiddenCells.forEach(cell => {
                        cell.style.display = 'table-cell';
                    });
                } else {
                    // Switch to simplified view
                    logsTable.classList.add('simplified');
                    toggleSimplifiedButton.textContent = 'Normal View';
                    // Hide the non-simplified columns
                    const hiddenCells = logsTable.querySelectorAll('.hide-in-simplified');
                    hiddenCells.forEach(cell => {
                        cell.style.display = 'none';
                    });
                }
            }

            toggleSimplifiedButton.addEventListener('click', toggleSimplifiedView);
        });
    </script>
</body>
</html>