JDN Services
System for computer labs: equipment inventory by department and a ticket help desk with assigned technicians, audit log and role-based permissions.
The challenge
The labs’ technical staff was losing information and responding slowly with manual methods. They needed a system with roles, permissions and the history of every change to the equipment.
Architecture and solution
Web application in PHP and MySQL with login and per-role permissions (administrator, technician and basic user) enforced on the server. Inventory is organized by department and each ticket follows a status flow. When a technician manages a ticket, they can update the equipment’s inventory status in the same step, and the system records who resolved it and when. Every important action goes into an audit log, and reports are generated as PDF with FPDF.
Features
- Equipment inventory by department, with statuses: operational, in storage, in maintenance and out of service
- Help desk with a status flow (pending → in review → in progress → resolved → closed) and an assigned technician
- When reporting a fault, you pick the area first and only that area’s equipment is listed
- Closing a ticket can also update the equipment’s status, without going to the inventory
- Roles and permissions: basic users only see and follow their own tickets
- Safeguards: internal codes can’t repeat, and equipment with linked tickets can’t be deleted
- Dashboard with key metrics and a chart of equipment by area
- Audit log, resolution history, PDF reports and light or dark mode
Tap an image to see it full size.
