Sahel Noix Production Tracking System

Production tracking system for Sahel Noix SARL, a cashew processing company in Korhogo, Cote d'Ivoire.

Setup

1. Clone the repository
2. Copy .env.example to .env and configure your database URL
3. Install dependencies: npm install
4. Generate Prisma client: npx prisma generate
5. Push schema to database: npx prisma db push
6. Seed the database: npx prisma db seed
7. Start the dev server: npm run dev

Tech Stack

• Next.js 14 (Pages Router)
• Express.js API
• PostgreSQL + Prisma ORM
• TypeScript
• Vitest for testing

API Routes

• GET /api/batches -- List all batches
• GET /api/batches/:id -- Get batch details
• POST /api/batches -- Create a batch
• PATCH /api/batches/:id -- Update batch stage
• GET /api/cooperatives -- List cooperatives
• GET /api/cooperatives/:id -- Get cooperative details
• GET /api/quality-checks -- List quality checks (filter by batch_id)
• POST /api/quality-checks -- Record a quality check
• GET /api/shipments -- List shipments
• POST /api/shipments -- Create a shipment
• PATCH /api/shipments/:id -- Update shipment status
• GET /api/export-certificates -- List certificates
• POST /api/export-certificates -- Generate a certificate