Back to Projects
SaaS

ISP Management System

Built a full-stack ISP management system with Next.js, Prisma, MySQL, role-based access control, and inventory tracking.

6+
Equipment categories tracked
2
User roles (Admin/Manager)
Multi-branch
Branch isolation

Overview

Developed a production-ready management system for an Internet Service Provider, covering client management, branch operations, team coordination, and comprehensive stock/inventory tracking for networking equipment.

The Challenge

The ISP managed clients, staff, and networking equipment across multiple branches using spreadsheets and manual processes. Stock tracking for ONU devices, cable reels, patch cords, and other networking hardware was error-prone. There was no centralized system for branch-level operations or team assignments.

The Solution

Built a full-stack application with Next.js and Prisma ORM connected to MySQL, featuring role-based access control (Admin/Manager), branch-level data isolation, and real-time inventory tracking. Deployed with Docker and Nginx.

Tech Stack

Frontend

Next.jsTypeScriptTailwind CSSRadix UIReact Hook FormZod

Backend

Next.js API routesPrisma ORM

Database

MySQL

Auth

JWT with RBAC (Admin/Manager roles)

Testing

JestPlaywright e2e

Deployment

DockerNginx

Key Features

Client Management

Registration, service tracking, and billing.

Branch Management

Multi-branch operations with branch-level data isolation.

Team Management

Staff assignment and team coordination.

Stock/Inventory Tracking

ONU devices, cable reels, patch cords, switches, splitters, and adapters.

Team Stock Assignments

Equipment allocation per team.

Asset Tracking with Audit Logs

Full audit trail for all stock movements.

Role-Based Access

Admin and Manager roles with branch-level control.

Dashboard Views

Separate admin and manager dashboard perspectives.

Map View

Geographic visualization of branches and assets.

Reports & Analytics

Operational reporting and data analytics.

My Role

Full-Stack Developer

Full-stack development—designed the database schema, implemented API routes with Prisma, built the frontend dashboard, set up role-based access control, and deployed with Docker.

Results & Impact

  • Eliminated spreadsheet-based inventory tracking
  • Real-time stock visibility across all branches
  • Role-based access ensuring branch-level data security
  • Comprehensive audit trail for all stock movements
  • Deployed and running in production with Docker