Home › Projects › Location Launchpad
Location Launchpad

Location Launchpad — AI Handoff

Most recent session working on the Location Launchpad. Replace entirely when a new session completes.

Latest Session

Date: 2026-06-30 (approx)   Developer: Adnan   AI: Claude

Objective

Build v1.2: reminders system, calendar view, daily digest email cron, configurable reminder intervals, recurrence dropdown, email from-address fix.

What Was Built (all on disk, not yet pushed)

  • DB: db/migrations/003_reminders_recurring_email.sql — reminders table with location_id, task_id, due_date, priority, interval_days, recurrence, email_sent
  • API: functions/api/reminders.js — GET (list by location), POST (create)
  • API: functions/api/reminders/[id].js — GET, PATCH, DELETE single reminder
  • API: functions/api/reminders/generate-location/[location_id].js — auto-generate reminders from tasks
  • API: functions/api/reminders/test-email.js — test email endpoint
  • API: functions/api/calendar.js — GET tasks + reminders in date range
  • API: functions/api/cron/daily-digest.js — daily email digest via Resend
  • Frontend: src/reminders.html — full reminders management page
  • Frontend: src/calendar.html — calendar view of tasks and reminders
  • Frontend: src/settings.html — added Reminder Intervals card and recurrence dropdown
  • Frontend: src/index.html, src/location-detail.html — updated for reminders integration
  • Config: wrangler.toml — added cron trigger 0 9 * * *

CRITICAL: How to Commit v1.2 (Task #155)

⚠️
Git index is corrupted — do this first

A previous git add from the sandbox staged v1.2 files as deleted. Before anything else, run from Windows terminal in the launchpad folder:

git restore --staged .

This clears the corrupted staging area without touching the actual files on disk.

After clearing staging, the commit must use FUSE-safe plumbing from the sandbox (Claude/Cowork). The pattern:

  1. Write each changed file to /tmp via Python (not directly to FUSE path)
  2. Hash each file: git hash-object -w --stdin < /tmp/filename
  3. Verify blob line count matches expected
  4. Build tree with Python ls_tree/mktree helpers
  5. Create commit with git commit-tree
  6. Update .git/refs/heads/main via Python file write
  7. User pushes from Windows terminal

See CLAUDE.md §1 in the CRM repo for the full procedure (same pattern applies here).

DB Migration (run after push)

wrangler d1 execute sonan-location-launchpad --remote --file=db/migrations/003_reminders_recurring_email.sql

Then verify at launchpad.sonantech.com/reminders.html.

Email Configuration

Outbound emails (daily digest) go via Resend. From-address is onboarding@resend.dev (Resend shared domain — works without verification). Set env var REMINDER_EMAIL_FROM in Cloudflare Pages settings to use a custom address. Set REMINDER_EMAIL_TO for the recipient.

Next for This Project

  1. Fix git staging (git restore --staged . from Windows terminal)
  2. FUSE-safe commit and push (task #155)
  3. Run migration on production
  4. Update this handoff and Current Dev once pushed successfully