2100) $year = (int)date('Y'); if ($month < 1 || $month > 12) $month = (int)date('n'); // Scope toggle $scope = $_GET['scope'] ?? 'mine'; if (!$is_super && $scope === 'all') $scope = 'mine'; // Compute month bounds (extended by ±7 days so we catch out-of-month // days that show in the leading/trailing rows of the grid) $first_of_month = sprintf('%04d-%02d-01', $year, $month); $range_start = date('Y-m-d', strtotime("-7 days", strtotime($first_of_month))); $range_end = date('Y-m-d', strtotime("+7 days", strtotime("last day of $first_of_month"))); // Load tasks in scope $where = ['t.due_date IS NOT NULL', 't.due_date BETWEEN :s AND :e']; $params = ['s' => $range_start, 'e' => $range_end]; switch ($scope) { case 'all': // No further restriction (super only) break; case 'mine': default: $where[] = '(t.assigned_to = :me1 OR (t.assigned_to IS NULL AND t.created_by = :me2))'; $params['me1'] = $me['id']; $params['me2'] = $me['id']; break; } $tasks = db_all( "SELECT t.id, t.title, t.status, t.priority, t.due_date, t.assigned_to, t.created_by FROM admin_tasks t WHERE " . implode(' AND ', $where) . " ORDER BY FIELD(t.priority,'urgent','high','normal','low'), t.due_date, t.id", $params ); // Build events array indexed by date $events = []; $today = date('Y-m-d'); foreach ($tasks as $t) { $cls = 'task-' . $t['status']; if ($t['status'] === 'open' || $t['status'] === 'in_progress') { if ($t['due_date'] < $today) { $cls = 'task-overdue'; } } $events[$t['due_date']][] = [ 'label' => $t['title'], 'url' => 'task-edit.php?id=' . (int)$t['id'], 'class' => $cls, ]; } // Counts for scope toggle $mine_total = (int)db_value( "SELECT COUNT(*) FROM admin_tasks WHERE due_date IS NOT NULL AND due_date BETWEEN :s AND :e AND (assigned_to = :me1 OR (assigned_to IS NULL AND created_by = :me2))", ['s' => $range_start, 'e' => $range_end, 'me1' => $me['id'], 'me2' => $me['id']] ); $all_total = (int)db_value( "SELECT COUNT(*) FROM admin_tasks WHERE due_date IS NOT NULL AND due_date BETWEEN :s AND :e", ['s' => $range_start, 'e' => $range_end] ); ?>

Calendar

My tasks All tasks
'calendar.php?scope=' . urlencode($scope)]) ?>
Open In progress Done Overdue SA public holiday Weekend

Tasks without a due date don't appear on the calendar. View all tasks →