<?php
// Current month and year for stats
$currentMonth = date('m');
$currentYear = date('Y');

// Calculate total hours for the month
$totalHoursQuery = "SELECT SUM(
                        TIME_TO_SEC(TIMEDIFF(toTime, fromTime))/3600 + (extraTime/60)
                    ) as totalHours 
                    FROM CINE_Plage 
                    WHERE MONTH(date) = $currentMonth AND YEAR(date) = $currentYear";
$totalHoursResult = $dbc->query($totalHoursQuery);
$totalHours = 0;
if ($totalHoursRow = $totalHoursResult->fetch_assoc()) {
    $totalHours = round($totalHoursRow['totalHours'], 1);
}

// Count entries in month
$entriesQuery = "SELECT COUNT(*) as count FROM CINE_Plage WHERE MONTH(date) = $currentMonth AND YEAR(date) = $currentYear";
$entriesResult = $dbc->query($entriesQuery);
$entriesCount = 0;
if ($entriesRow = $entriesResult->fetch_assoc()) {
    $entriesCount = $entriesRow['count'];
}
?>