CivicPulse — Project Plan

Live plan — 75 tracked features across Foundation, Auth, Core, Media, Admin, Safety, Discovery, Growth, and Mobile. Each row includes status, priority, affected files, and whether it uses mock/simulated data.

Status Legend

Status	Meaning
✅ Done	Implemented, tested, in production
🔜 Planned	Designed, not yet started
📋 TODO	Accepted, queued for next sprint
🔬 Research	Design complete, build deferred

Priority Legend

Priority	Meaning
P0	Blocking — ship or nothing works
P1	High value, ship this sprint
P2	Good to have, next sprint

---

Foundation

#	Task	Status	Priority	Notes	Mock?
1	Project Scaffold & Tooling	✅ Done	P0	Vite 7 + React 19 + Express + DynamoDB	None
2	Docker Compose Setup	✅ Done	P1	Local dev with LocalStack option	None
3	CI/CD Pipeline	✅ Done	P0	GitHub Actions → S3/CloudFront + EC2	None
4	AWS Infrastructure (Terraform)	✅ Done	P1	ECS Fargate + ALB + ECR + CloudFront	None

Auth

#	Task	Status	Priority	Notes	Mock?
5	Google OAuth Integration	✅ Done	P0	google-auth-library + JWT pair	MOCK: 4 hardcoded users (Arjun/Priya/Rohit/Nisha) instead of real OAuth
6	JWT Refresh Token Flow	✅ Done	P0	15min access + 7d httpOnly refresh	None

Feature Flags

#	Task	Status	Priority	Notes	Mock?
7	Feature Flag System (localStorage)	✅ Done	P0	useFlags() hook, persists across sessions	None
8	Feature Flags DB Persistence	✅ Done	P0	DynamoDB config table + public /api/flags 60s cache	None

Core

#	Task	Status	Priority	Notes	Mock?
9	Issue Reporting	✅ Done	P0	Title/desc/category/city/priority + DynamoDB	None
10	Issue List & Filtering	✅ Done	P0	City / category / status / search filters	MOCK: 7 pre-seeded issues (picsum.photos URLs)
11	Issue Detail View	✅ Done	P0	Gallery + share + status + chat	MOCK: INITIAL_ISSUES + MOCK_MESSAGES
12	Community Chat (WebSocket)	✅ Done	P0	Socket.IO + DynamoDB history + typing indicators	MOCK: Hardcoded chat + simulated "Sanjay M." user
13	Voting / Upvotes	✅ Done	P1	One vote per user per issue	MOCK: Local React state, no backend persistence in dev

Media

#	Task	Status	Priority	Notes	Mock?
14	Photo Upload with EXIF	✅ Done	P0	Sharp resize + GPS/date/camera from EXIF + S3	MOCK: base64 dataURL in dev, picsum.photos CDN
15	Video Upload with FFmpeg	✅ Done	P1	fluent-ffmpeg thumbnail + progress	MOCK: setInterval simulates upload %
16	Geo-Tagging	✅ Done	P0	EXIF GPS or manual capture → issue card chip	MOCK: Hardcoded lat/lng for 5 Indian cities

Scoring & Leaderboard

#	Task	Status	Priority	Notes	Mock?
17	Civic Contribution Score	✅ Done	P1	Reports + votes + chat + events	MOCK: Scores hardcoded in MOCK_USERS
18	Leaderboard	✅ Done	P1	City-filtered ranking	MOCK: Static MOCK_USERS data

Discovery

#	Task	Status	Priority	Notes	Mock?
19	X/Twitter Feed Import	✅ Done	P1	API v2 Bearer token search + import to issues. X_HANDLE / VITE_X_HANDLE env vars control which account is monitored. Live mode badge in Social Wall. tweetUrl stored on converted issues for "View on X ↗" link in Detail. /test-x developer page.	MOCK: 5 hardcoded MOCK_TWEETS — falls back when no Bearer Token or credits
57	Location-Based Issue Browsing	✅ Done	P0	useUserLocation + Haversine + Near Me sort + distance badges	MOCK: Geo coords hardcoded in INITIAL_ISSUES
58	Nearby Issues in Report Form	✅ Done	P1	Count issues within 500m when GPS captured	MOCK: Compares against INITIAL_ISSUES geo

Admin Portal

#	Task	Status	Priority	Notes	Mock?
20	Admin Route & Auth	✅ Done	P0	/admin — separate JWT, sessionStorage	None
21	Superadmin Seed Script	✅ Done	P0	backend/scripts/seed-superadmin.js — run once	None
22	Admin CRUD (Superadmin Only)	✅ Done	P0	Invite/remove admins, set roles	None
23	No-Access Screen	✅ Done	P0	Ban icon + clear message for non-admins	None
24	Feature Flags Admin UI	✅ Done	P0	Toggle flags live → DynamoDB	None
25	Site Content Admin UI	✅ Done	P1	Title, tagline, contact, GitHub URL	None
26	Donation Config Admin UI	✅ Done	P0	Upload QR (base64), set UPI ID	None
27	Notifications Admin UI	✅ Done	P0	Broadcast push to all or by city	None
68	Separate Admin Bundle (MPA)	✅ Done	P0	Vite MPA — admin/index.html → admin-main.jsx → BrowserRouter basename="/admin" — no shared JS with main app	None
69	Ward / Officials Data (CRUD)	✅ Done	P1	JSON file storage at backend/data/ward-officials.json, full CRUD in WardDataView, CSV import/export	MOCK: JSON flat file instead of DynamoDB
70	Public Submission Queue	✅ Done	P1	POST /api/ward-officials/submit → pending queue → approve/reject in admin	None
71	Ward Lookup for Issue Assignment	✅ Done	P1	GET /api/ward-lookup?city&pincode&category → AssignmentPanel in Detail view, deep-links for X/WhatsApp/email	MOCK: No officials seeded by default
72	Admin Portal Link on Sign-in Card	✅ Done	P2	Subtle 🔒 Admin Portal link at bottom of auth card + Support Us button	None

Landing Page

#	Task	Status	Priority	Notes	Mock?
30	Supported By Section	✅ Done	P1	Logo grid + "Your logo here" CTA	MOCK: SVG lettermark placeholder
31	Donate Section	✅ Done	P0	QR + UPI + donor wall	MOCK: Hardcoded donor array + placeholder QR SVG
32	Collaborate Section	✅ Done	P1	GitHub / Claude / beta team cards	None
73	Landing Section Reorder	✅ Done	P2	Supported By + Support Us moved above Features for social proof above fold	None
74	Support Us Button in Landing Nav	✅ Done	P2	Bypasses login, sets guestMode=true and navigates to support view	None

Support Page

#	Task	Status	Priority	Notes	Mock?
75	Support Page Guest Access	✅ Done	P1	Support page reachable without login via landing nav or sign-in card; guestMode=true shows full content	None
76	Get Started CTA for Guests	✅ Done	P1	Gradient banner with "Get Started — It's Free" + "Browse Issues First" buttons shown to non-logged-in visitors	None
77	How Can I Help Section	✅ Done	P1	3-column grid: Citizen Reporter / NGO / Corporate CSR — each with action bullets and email/browse CTA	None
78	Upcoming Projects Section	✅ Done	P1	Schools (accountability + world-class goal) and Hospitals (hygiene/dignity audit) cards with feature tags, Q3/Q4 pilot goals, Volunteer + CSR Sponsor CTAs	None

Donors

#	Task	Status	Priority	Notes	Mock?
33	Donor Management	✅ Done	P0	Add/edit/remove from admin	None
34	Twitter Profile Pictures	✅ Done	P1	API v2 400×400 avatar fetch + DynamoDB cache	MOCK: Placeholder avatars in dev

Analytics & Notifications

#	Task	Status	Priority	Notes	Mock?
35	Google Analytics 4	✅ Done	P0	gtag.js + anonymize_ip	None
36	Custom Event Tracking	✅ Done	P1	10 civic events, no PII	None
37	Service Worker	✅ Done	P0	Network-first + push handler	None
38	usePushNotifications Hook	✅ Done	P0	VAPID subscription management	None
39	Push Bell in Nav	✅ Done	P0	Bell/BellOff toggle	None
40	Backend Notification Service	✅ Done	P0	web-push v3.6.7	None
41	Notification API Routes	✅ Done	P0	Subscribe/unsubscribe/send/broadcast	None
42	Push Subscriptions DynamoDB Table	✅ Done	P0	Auto-remove stale 410 Gone	None

UI/UX

#	Task	Status	Priority	Notes	Mock?
28	Icon Library Migration	✅ Done	P1	Lucide React (ISC) — Camera, Bell, Shield etc.	None
29	Font Audit	✅ Done	P1	Inter + Plus Jakarta Sans — OFL-1.1 confirmed	None

Testing & Security

#	Task	Status	Priority	Notes	Mock?
43	Frontend Tests (Vitest)	✅ Done	P0	19 tests — AdminLogin, useFlags, DonorWall	None
44	Backend Tests (Jest + Supertest)	✅ Done	P0	30 tests — auth, config, donors (DynamoDB mocked)	None
45	Test CI Integration	✅ Done	P0	Blocks deploy on failure	None
46	OWASP ZAP Scan	✅ Done	P1	Advisory mode on staging	None
47	Security Audit Script	✅ Done	P1	npm audit --audit-level=high in CI	None
48	Admin Rate Limiting	✅ Done	P0	10 attempts / 15 min / IP	None
49	Timing Attack Prevention	✅ Done	P0	Dummy bcrypt compare on unknown email	None

Safety / Content Moderation

#	Task	Status	Priority	Notes	Mock?
55	Image Flagging (Phase 1)	✅ Done	P0	Flag button on photos/videos, reason picker, flagged overlay	MOCK: mediaFlags in React state — resets on reload
56	Issue Flagging (Phase 1)	✅ Done	P0	Flag button on issues (separate from upvote)	MOCK: issueFlags in React state — resets on reload
59	Duplicate Detection	🔬 Research	P2	Haversine + dHash + Jaccard design — parked	N/A
60	Content Moderation Phase 1 — NSFWJS	🔜 Planned	P0	Client-side TF.js, ~7MB model	N/A
61	Content Moderation Phase 2 — Rekognition	🔜 Planned	P1	Backend gate before S3 save	N/A

Mobile

⚠️ TODO — Next Major Initiative: A native mobile app is the single highest-leverage feature remaining. The web PWA works on mobile browsers, but a native app unlocks background location, camera roll access, push without browser prompt, and App Store / Play Store distribution. See Roadmap for full mobile spec.

#	Task	Status	Priority	Notes	Mock?
62	Camera Capture with GPS Injection	🔜 Planned	P1	getUserMedia + live GPS overlay	N/A
63	Mobile App — React Native + Expo	📋 TODO	P0	Full spec in Roadmap. Stack: Expo Router + React Native + NativeWind. Auth: same JWT pair. API: same backend.	N/A
64	Mobile App — Phase 1 Scaffold	📋 TODO	P0	Expo Router + auth + issues list (read-only) + report form (camera + GPS) — launch target Q2 2025	N/A
79	Mobile App — Phase 2 Full Feature	📋 TODO	P1	Chat, voting, notifications (FCM), offline queue for reports, map view	N/A
80	App Store / Play Store Submission	📋 TODO	P1	ASO, privacy policy, screenshots, review guidelines compliance	N/A

Growth

#	Task	Status	Priority	Notes	Mock?
65	Social Media Validation Kit	📋 TODO	P1	Satori OG images + one-click X/WhatsApp/Instagram share	N/A
66	Marketing Integrations	📋 TODO	P2	Mailchimp waitlist + PostHog + Hotjar + UTM tracking	N/A
67	Referral & Viral Loop	📋 TODO	P2	Ref codes + city badge PNGs + social proof on detail	N/A

Rankings

#	Task	Status	Priority	Notes	Mock?
81	City Rankings Page	✅ Done	P1	Bar chart sorted by civic score, resolution %, speed; all 10 cities always shown (including zero-issue cities)	MOCK: Derived from INITIAL_ISSUES
82	Contributor Leaderboard	✅ Done	P1	Ranked cards with score breakdown, badges, sort by score/reports/resolved/upvoted; click to see full breakdown	MOCK: MOCK_CONTRIBUTORS (6 entries) in mockData.json

---

Source of truth: civicpulse-project-plan.csv on GitHub. This page is regenerated from that CSV whenever a session completes.