Vector — Sand Trading & Logistics Platform
A multi-role B2B platform for live sand trading, dispatch, and billing. Buyers, traders, suppliers, drivers, and admins each get a dedicated dashboard backed by Supabase, with Gemini AI handling smart-matching, assignment suggestions, and document extraction.
What it does
| Role | What they can do |
|---|
| Buyer | Browse listings, place orders, track dispatch in real time |
| Trader | Match buyers and suppliers, set margins, manage active deals |
| Supplier | List inventory, receive orders, confirm dispatch |
| Driver / Truck-driver | Receive assignments, update trip status |
| Admin | Oversee users, run analytics, generate monthly bills, seed/reset data |
Key features
- Role-based auth & routing — Supabase Auth + middleware-enforced route protection across six roles
- AI assistants (Gemini) — smart buyer-supplier matching, assignment suggestions, document extraction (OCR for invoices/dockets)
- Document generation — PDF e-challans (
pdf-lib) and Excel monthly bills (exceljs / xlsx)
- Maps integration — Google Maps Places autocomplete for dispatch locations
- Margin analysis — per-deal P&L surfaced to traders and admins
Tech stack
- Framework: Next.js 16 (App Router) · React 19 · TypeScript
- Database & Auth: Supabase (Postgres, RLS policies, edge functions)
- AI: Google Gemini (
@google/generative-ai)
- Styling: Tailwind CSS v4
- Maps: Google Maps JS API
- Documents: pdf-lib · exceljs · xlsx
Run locally
Prerequisites: Node.js 20+, a Supabase project, a Gemini API key, a Google Maps JS API key.
git clone https://github.com/MadhuramAgarwal/vector.git
cd vector
npm install
Create .env.local:
NEXT_PUBLIC_SUPABASE_URL=...
NEXT_PUBLIC_SUPABASE_ANON_KEY=...
SUPABASE_SERVICE_ROLE_KEY=...
GOOGLE_GEMINI_API_KEY=...
NEXT_PUBLIC_GOOGLE_MAPS_API_KEY=...
Apply the Supabase schema (in the Supabase SQL editor):
supabase/schema.sql- Files in
supabase/migrations/ in order
supabase/RUN_SEED_DATA.sql (optional — demo data)
Then:
npm run dev
Open http://localhost:3000.
Project structure
app/
buyer/ trader/ supplier/ driver/ truck-driver/ admin/ Role dashboards
api/ Server actions
login/ page.tsx layout.tsx Auth + shell
lib/
supabase/ SSR + browser clients
createNotification.ts Notification helper
proxy.ts Auth middleware (route gate by role)
supabase/ Schema, migrations, seed scripts, edge functions
API routes
app/api/ exposes server endpoints for: margin analysis, Excel export, document extraction, e-challan generation, monthly bill generation, smart matching, assignment suggestions, buyer suggestions, and data reset.
