Africa Sojourners of Hope

Web Platform — Technical Project Report

Version 1.0 | June 2026
https://www.africasojournersofhope.org

The ASOH platform is a production MVP for a Kenyan NGO. It provides public donation processing (Paystack), multi-step application forms, a secure admin dashboard, blog CMS, visitor analytics, and automated email notifications.

2. Technology Stack

Layer	Technology	Purpose
Frontend	Next.js 16, React 19, Tailwind CSS v4	Server and client rendering, routing, UI
Backend	Next.js API Routes (Node.js)	REST endpoints, webhooks, form handling
Database	Supabase PostgreSQL	Data storage with Row Level Security
Auth	Supabase Auth	Admin login and session management
Payments	Paystack	Card, M-Pesa, bank transfer donations
Email	SMTP (Nodemailer)	Receipts, confirmations, admin alerts
Storage	Supabase Storage	Application document uploads
Hosting	Vercel	CDN, SSL, serverless deployment
Analytics	Custom page views + Vercel Analytics	Visitor footprint tracking

Layer

Technology

Purpose

Frontend

Next.js 16, React 19, Tailwind CSS v4

Server and client rendering, routing, UI

Backend

Next.js API Routes (Node.js)

REST endpoints, webhooks, form handling

Database

Supabase PostgreSQL

Data storage with Row Level Security

Auth

Supabase Auth

Admin login and session management

Payments

Paystack

Card, M-Pesa, bank transfer donations

SMTP (Nodemailer)

Receipts, confirmations, admin alerts

Storage

Supabase Storage

Application document uploads

Hosting

Vercel

CDN, SSL, serverless deployment

Analytics

Custom page views + Vercel Analytics

Visitor footprint tracking

3. Project Structure

app/ admin/(dashboard)/ Admin pages (donations, cases, blog, etc.) api/ Public and admin API routes apply/ Programme, volunteer, sponsor, case forms blog/ Public blog (CMS-driven) donate/ Paystack donation flow components/admin/ Dashboard tables, panels, scoring lib/supabase/ Database clients (anon + service role) lib/services/ Email, Paystack checkout supabase/PRODUCTION.sql Single production database script

4. Database Tables

Table	Purpose
admin_users	Admin accounts (admin / super_admin roles)
donations	Paystack donations with status tracking
programme_applications	Education programme applications
volunteer_applications	Volunteer interest forms
sponsorship_requests	Corporate and individual sponsorship
case_assessments	Case assessment intake and workflow
contact_messages	Contact form submissions
blog_posts	CMS blog content
scoring_criteria / application_scores	Weighted applicant scoring
site_page_views	Visitor footprint analytics
newsletter_subscribers	Email newsletter list
audit_logs	Admin action audit trail

Table

Purpose

admin_users

Admin accounts (admin / super_admin roles)

donations

Paystack donations with status tracking

programme_applications

Education programme applications

volunteer_applications

Volunteer interest forms

sponsorship_requests

Corporate and individual sponsorship

case_assessments

Case assessment intake and workflow

contact_messages

Contact form submissions

blog_posts

CMS blog content

scoring_criteria / application_scores

Weighted applicant scoring

site_page_views

Visitor footprint analytics

newsletter_subscribers

Email newsletter list

audit_logs

Admin action audit trail

5. Payment Integration

Callback URL: https://www.africasojournersofhope.org/donate/callback

Webhook URL: https://www.africasojournersofhope.org/api/paystack/webhook

Donor submits form → POST /api/paystack/initialize

Paystack popup completes payment

GET /api/paystack/verify confirms and updates donations table

Webhook provides async backup confirmation

Admin views donation at /admin/donations (super_admin)

Event	Recipient
Application submitted	Applicant confirmation + ADMIN_EMAIL alert
Donation completed	Donor receipt + admin (+ optional donations/treasurer CC)
Contact form	Sender auto-reply + admin notification
Case status update	Referrer email
Application decision	Applicant status email

Event

Recipient

Application submitted

Applicant confirmation + ADMIN_EMAIL alert

Donation completed

Donor receipt + admin (+ optional donations/treasurer CC)

Contact form

Sender auto-reply + admin notification

Case status update

Referrer email

Application decision

Applicant status email

7. Admin Dashboard

Dashboard — pending counts, recent activity

Applications / Volunteers / Sponsorships / Cases — review, score, approve

Blog — create posts published to /blog

Contacts — reply and archive messages

Donations — full payment history (super_admin)

Analytics — visitor footprint from site_page_views

Settings — admin users + 5-step case scoring criteria

8. Security

Row Level Security on all tables; anon has no direct table access

Service role used server-side only for public form inserts

Rate limiting on public API endpoints

Paystack webhook HMAC signature verification

CSRF protection on state-changing routes

Security headers (CSP, X-Frame-Options, nosniff)

Production console output stripped (removeConsole)

Africa Sojourners of Hope

1. Executive Summary

2. Technology Stack

3. Project Structure

4. Database Tables

5. Payment Integration

6. Email Routing

7. Admin Dashboard

8. Security

9. SEO

10. Deployment