project

ServiceDesk Pro

Open-source IT service desk application built for internal operations. Full ticket lifecycle management, role-based access, WhatsApp/Twilio integration, QR customer lookup, Chart.js analytics, Excel/PDF exports, geolocation tagging, leads, and DVR/equipment tracking.

Role: Full Stack Developer Type: Open Source / Internal Year: 2024 Status: Internal Deployment

Next.js 15MongoDB Material UIChart.js TwilioWhatsApp API JWT AuthRBAC

↗ GitHub Profile

Admin Dashboard

Real-time overview of ticket volume, resolution trends, and team performance. Charts powered by react-chartjs-2 with live data from MongoDB aggregation pipelines.

servicedesk.local / dashboard

Open

In Progress

184

Resolved

Closed

Tickets Created vs Resolved (7 days)

Created

Resolved

Status Distribution

Open47

In Progress23

Resolved184

Closed91

Ticket Management

Full-featured ticket list with status filters, priority indicators, customer assignment, and one-click WhatsApp notifications via Twilio.

Tickets List: All Open & In Progress

              ↓ Export XLS
              + New
            

ID Subject Customer Assignee Priority Status Created

#1042 Network switch not responding Sharma Pvt Ltd Ravi K. High In Progress Mar 14

#1041 CCTV camera offline, block B Mehta Exports Ankit S. High Open Mar 14

#1040 EPABX extension setup TechnoFab India Priya D. Medium In Progress Mar 13

#1039 Firewall rule config update GlobalTech Corp Ravi K. Low Resolved Mar 13

#1038 Access card reader not reading Patel Industries Ankit S. Medium Open Mar 12

#1037 Structured cabling, new floor Orbit Realty Priya D. High Open Mar 12

Customer Management: QR Lookup

Customers

All (128)

Active

+ Add Customer

Sharma Pvt Ltd

📍 Andheri, Mumbai

⬛ QR12 tickets

Mehta Exports

📍 Bandra, Mumbai

⬛ QR7 tickets

TechnoFab India

📍 Thane, MH

⬛ QR5 tickets

GlobalTech Corp

📍 BKC, Mumbai

⬛ QR19 tickets

Patel Industries

📍 Borivali, MH

⬛ QR3 tickets

Orbit Realty

📍 Powai, Mumbai

⬛ QR8 tickets

Key Features

🎫

Full Ticket Lifecycle

Open → In Progress → Resolved → Closed workflow with assignments, comments, and escalation support.

🔐

Role-Based Access

Admin and Employee roles with separate capabilities. Admins manage users and config; employees handle assigned tickets.

💬

WhatsApp / Twilio

Automatic WhatsApp notifications to customers on ticket status changes via Twilio Messaging API.

⬛

QR Customer Lookup

Each customer gets a unique QR code. Scan on-site to instantly pull up their ticket and contact history.

📊

Chart.js Analytics

Line charts (ticket trends), bar charts (status distribution), and resolution rate tracking for team insights.

📁

Excel & PDF Export

One-click export of ticket lists, customer data, and reports to Excel or PDF for sharing and auditing.

📍

Geolocation Tagging

Capture site GPS coordinates on customer records and field visits for accurate service location data.

📷

DVR / Equipment

Track installed DVR units, cameras, and other equipment per customer with service history logs.

Technical Breakdown

Next.js 15 (App Router)

Server-side rendering for dashboard pages, API routes for all backend logic, middleware for JWT session validation.

MongoDB + Mongoose

Document model for tickets, customers, employees, and audit events. Aggregation pipelines for analytics queries.

Material UI (MUI)

MUI dark theme for consistent, professional UI. DataGrid for ticket/customer tables with server-side pagination.

Chart.js / react-chartjs-2

Real-time charts fetching aggregated data. Ticket volume trends, status breakdown, and employee performance.

Twilio / WhatsApp

Twilio Messaging API configured for WhatsApp Business. Triggered on ticket creation and status transitions.

QR Code Generation

Server-side QR code generation per customer using qrcode npm package. Printable cards with scan-to-lookup.