[FEAT] Auto-progress goals from real commit data

[Priyanshu-byte-coder]

Summary

Weekly goals with a type: commits should auto-fill their current value from the actual GitHub commit count for that week, instead of requiring manual updates.

What to build

• Add a type column to the goals Supabase table: commits | prs | manual
• Update GET /api/goals:
  • For goals with type = commits: fetch commit count for the current week from GitHub and set current dynamically
  • For goals with type = prs: fetch merged PR count for the week
  • For type = manual: leave current as stored
• Update GoalTracker to show goal type badge next to each goal label

Supabase migration needed

ALTER TABLE goals ADD COLUMN type text NOT NULL DEFAULT 'manual';

Acceptance criteria

• Migration file added to supabase/migrations/
• GET /api/goals returns correct current for auto types
• GoalTracker shows type badge
• POST /api/goals accepts optional type field

Difficulty

Medium — requires DB migration + API logic change.

[Muragesh-24]

@Priyanshu-byte-coder please assign this to me, I would like to fix it.