Task Tracker

A collaborative weekly work schedule tracker built with Flutter, powered by Supabase (auth, Postgres, realtime, row-level security).

Modeled after the AppFlowy database/field/cell pipeline, but rendered as a week-per-analyst grid with inline editors, drag-and-drop, comments, notifications, and an activity audit trail.

Features

• Weekly schedule grid — one row per analyst, seven day columns
• Tasks with typed fields: text, number, date, checkbox, select, multiselect, and checklist
• Inline editors — checklist and multiselect render directly in the task popover with tappable checkboxes/tags, add-item inputs, and hover-red delete buttons (AppFlowy-style, no separate editor view)
• Recurring tasks (RFC 5545 subset) with repeat icon indicator
• Drag & drop — move tasks between days and analysts; drag a "+ New Task" pill onto a cell to create one
• Draggable analyst rows — reorder analysts via a dedicated drag handle on each row label (closed-fist cursor on hover), persisted atomically via a Postgres RPC; the current user's own row is pinned to the top
• Bulk selection — multi-select tasks for batch delete and batch move (pick a target analyst + date)
• Comments — per-task threaded comments with realtime sync
• Notifications — in-app bell with unread badge, swipe-to-dismiss, clear-all, and a right-side sidebar panel
• Roles — analyst (own rows) and supervisor (all rows, manage users)
• Users panel — assigned per-user colors (view + change via picker), roster status, role management, name editing, add-to/remove-from schedule, search filter, live online indicator on the user's avatar, and a user-count header
• Activity audit trail — semantic history of every task/cell change with collapsible view
• Search — filter tasks by text with amber highlights and a live match count
• Keyboard shortcuts — Ctrl+N (new task, on hovered date), Ctrl+D (duplicate the open task), Ctrl+T (today), ← → (navigate weeks)
• Loading skeletons — animated placeholder cards during week load
• Presence — live online indicator on analyst rows and as a badge on each user's avatar in the Users list, resilient to auth token refresh
• TV display mode — read-only kiosk view that auto-rotates through analysts that don't fit on screen (cascade slide-in)
• Themes — light/dark
• 12-hour clock — live clock in the app bar with AM/PM
• Auto-update — while the app is open it periodically checks Forgejo for a newer release, notifies the user, then automatically downloads, applies and relaunches if needed. Release notes are shown on the next launch.

Quick start

flutter pub get
dart run build_runner build     # generate app_database.g.dart
flutter run                     # macOS / Linux / Windows desktop
flutter test
dart analyze lib/

Configuration

Supabase connection is configured in lib/main.dart:

const _supabaseConfig = SupabaseConfig(
  url: 'https://supabase.sladertech.cloud',
  publishableKey: 'sb_publishable_...',
);

Set your own URL and publishable key to point at your Supabase project.

Database setup

Apply these migrations in the Supabase SQL Editor (in order):

1. supabase_migration.sql — core schema + RLS
2. supabase_notification_migration.sql — notifications table + triggers
3. supabase_roles_migration.sql — analyst/supervisor roles + RLS
4. supabase_audit_migration.sql — activity audit trail
5. supabase_due_date_migration.sql — due-date notifications
6. supabase_analyst_name_migration.sql — analyst name column
7. supabase_security_cleanup.sql — remove legacy anon policies
8. supabase_reorder_migration.sql — atomic reorder_analysts RPC
9. supabase_security_fix.sql — revoke trigger functions + tighten insert policies (resolves Security Advisor warnings)

Promote your first supervisor:

update public.profiles set role = 'supervisor' where email = 'admin@example.com';

Releases & self-update

The app self-updates from Forgejo releases on the configured remote. While the app is open it checks periodically (every 30 minutes) for a newer release; when one is found it notifies the user, then automatically downloads the platform binary, applies it, and relaunches if needed. Release notes are shown once on the next launch.

Building a release

1. Bump the version in pubspec.yaml (e.g. 1.1.0) to match the tag.

2. Build the binaries for each platform you ship:

   flutter build linux --release          # build/linux/x64/release/bundle
   flutter build windows --release        # build/windows/x64/runner/Release
   flutter build macos --release          # build/macos/Build/Products/Release
   

3. Create a Forgejo release tagged like vX.Y.Z, attach the platform binaries as release assets, and write the release notes in the body.

Asset naming

The updater picks the asset for the running platform by keyword in the filename/URL: linux / .AppImage, windows / .exe / .msi, macos / .dmg, android / .apk. Name your assets accordingly, e.g. task_tracker-linux.AppImage, task_tracker-windows.zip, task_tracker-macos.dmg.

How the client decides

The client compares the release tag (v1.2.0) against its own running version (package_info_plus). A strictly newer tag triggers the update. Version comparison and release parsing are covered by tests in test/domain/update/ and test/data/update_service_test.dart.

Architecture

lib/
├── domain/        # Pure-Dart models: field types, cell codecs, task,
│                  # analyst, comment, notification, audit entry
├── data/
│   ├── storage/   # drift schema (local fallback), AppPrefs
│   ├── repositories/  # interfaces + Drift/Supabase implementations
│   └── bootstrap/     # AppBootstrap — wires the active backend
├── logic/         # BLoCs: schedule, field, analyst, auth, comments,
│                  # notification, profiles, theme, display-mode, presence
└── ui/            # screens, widgets, theme

The app runs primarily on Supabase. A local SQLite (Drift) backend still exists behind the same repository interfaces for offline/testing use.

Documentation

• DEVELOPER_GUIDE.md — in-depth architecture and implementation notes for AI-assisted development.
• docs/RESEARCH.md — AppFlowy architecture study and original design decisions.