prepare("
SELECT
hc.completion_date,
c.name AS champion_name,
h.title AS habit_title,
h.is_bounty
FROM habit_completions hc
JOIN champions c ON hc.champion_id = c.id
JOIN habits h ON hc.habit_id = h.id
WHERE MONTH(hc.completion_date) = ? AND YEAR(hc.completion_date) = ?
ORDER BY hc.completion_date ASC
");
$stmt->execute([$month, $year]);
$completions = $stmt->fetchAll();
// Group completions by date
$byDate = [];
foreach ($completions as $row) {
$byDate[$row['completion_date']][] = $row;
}
?>
Calendar