AmaNA-byte/pau-workflow-system

# PAU Digital Workflow Automation System A fully functional digital workflow automation system for **Pan African University (PAU)** built with React, Netlify Functions, and Supabase. --- ## Overview Three complete approval workflows: - **Finance Fee Adjustment & Waiver** — Multi-stage approval with Finance Officer → Bursar escalation - **IT Support Ticketing** — Auto-assignment, SLA tracking, duplicate detection, critical escalation - **Library Clearance** — Automatic approval for clean records, manual review for outstanding items/fines --- ## Tech Stack | Layer | Technology | |-------|-----------| | Frontend | React 18 | | Backend | Netlify Functions (Node.js serverless) | | Database | PostgreSQL on Supabase (free tier) | | Auth | Supabase Auth | | Email | Resend (free tier — 3,000 emails/month) | | Deployment | Netlify (free tier) | --- ## Deployment Guide ### Prerequisites - GitHub account - Supabase account (free) - Netlify account (free) - Resend account (free, optional for email) --- ### Step 1: Set Up Supabase 1. Go to supabase.com and create a new project 2. Wait for the project to initialize (~2 minutes) 3. Go to **Settings → API** and copy: - `Project URL` → your `SUPABASE_URL` - `anon public` key → your `SUPABASE_ANON_KEY` - `service_role` key → your `SUPABASE_SERVICE_ROLE_KEY` *(keep this secret!)* --- ### Step 2: Run the Database Schema 1. In your Supabase project, go to **SQL Editor** 2. Click **New query** 3. Copy the entire contents of `database/schema.sql` and paste it 4. Click **Run** 5. You should see: `Success. No rows returned` --- ### Step 3: Create Test User Accounts In Supabase Dashboard, go to **Authentication → Users → Add User** (Invite user) and create these accounts **one by one**: | Full Name | Email | Password | |-----------|-------|----------| | Kwame Mensah | kwame.mensah@student.pau.edu.gh | Test@1234 | | Kofi Boateng | kofi.boateng@pau.edu.gh | Test@1234 | | Abena Owusu | finance.officer@pau.edu.gh | Test@1234 | …