Fountain Gate Chapel — Solution Pastures (Website)

Public website powered by the same Supabase project as spadmin and sppod2.

Setup

1. Copy environment variables from spadmin/.env.local:

cp ../spadmin/.env.local .env.local

Required keys:

• NEXT_PUBLIC_SUPABASE_URL
• NEXT_PUBLIC_SUPABASE_ANON_KEY

Optional (later):

• NEXT_PUBLIC_PAYSTACK_PUBLIC_KEY — for inline Paystack on /give

2. Install and run:

npm install
npm run dev

Open http://localhost:3000.

Live data (connected)

Section	Supabase table
Home — latest message	episodes
Watch / messages / series	episodes, series
Devotionals	devotionals
News	announcements

Playback uses the same audio URLs as the mobile app (Supabase sermon-audio bucket or legacy Google Drive fileId in parts JSON).

Still mock data (admin modules TBD)

• Gallery, events, testimonies, bible study, column, newsletter, faith Q&A, give funds
• These pages keep v0 mock content until tables + spadmin CRUD are added

Project layout

• lib/data/ — server-side Supabase fetchers
• lib/mappers.ts — DB rows → UI types
• lib/playback-utils.ts — audio URL resolution
• components/playback-provider.tsx — web audio player state

Shared admin

Manage content in spadmin (npm run dev in ../spadmin). Changes appear on the website after revalidation (~60s) or refresh.