ITSO Equipment Management System
A comprehensive equipment management system for school IT Services Office, featuring user management, equipment tracking, borrowing/return workflows, reservations, and automated email notifications built with CodeIgniter 4.
Project Overview
The ITSO Equipment Management System is a full-featured web application designed to streamline the management of IT equipment and gadgets for school IT Services Office. The system handles everything from user registration with email verification to equipment tracking, borrowing workflows, and automated notifications.
Built with CodeIgniter 4 framework and Bootstrap for responsive design, this system implements comprehensive CRUD operations with proper form validation, session management, and URL routing. The application manages various equipment types including laptops with chargers, DLP projectors with accessories, HDMI/VGA cables, keyboards, mice, Wacom tablets, speakers, webcams, and lab room keys.
The system features role-based access control with three user types: ITSO Personnel (full system access), Associates (borrowing and reservations), and Students (borrowing only). Each transaction triggers automated email notifications, and the system maintains detailed records for reporting and tracking equipment status and user borrowing history.
Technology Stack
Key Features
User Management Module
Complete user registration with email verification, account viewing, editing, and deactivation. Three user roles: ITSO Personnel, Associates, and Students.
Secure Authentication
Login system with password standards (minimum length, complexity). Password reset functionality for forgotten credentials.
Email Verification
Registration includes email verification to ensure valid user accounts and secure access to the system.
Equipment Management
Add, view, edit, and deactivate equipment. Manage laptops, DLP projectors, cables, peripherals, tablets, and lab keys with unique IDs.
Equipment with Accessories
Automatically track accessories (laptop chargers, DLP cables/cords/remotes, tablet pens) bundled with main equipment items.
Inventory Tracking
Real-time item count tracking to determine equipment availability status and prevent over-booking.
Borrowing Module
Process equipment borrowing for Associates and Students. Automatic email notifications sent upon successful borrowing.
Return Module
Handle equipment returns with automatic email confirmations. Updates inventory count and availability status.
Reservation System
Associates can reserve equipment for future use (minimum 1 day advance). Reservations can be cancelled or rescheduled.
Automated Email Notifications
Automatic email alerts for borrowing confirmations, return receipts, and reservation updates sent to user accounts.
Reports Module
Generate active equipment list reports, unusable equipment reports, and user borrowing history reports.
Role-Based Access Control
ITSO Personnel have full access, Associates can borrow and reserve, Students can only borrow equipment.
Comprehensive Form Validation
All input fields validated for required values, proper formats, and data integrity to ensure system reliability.
URL Routing
Clean URL routing for major pages including landing page and transaction pages using CodeIgniter 4 routing system.
Session Management
Secure session handling for user authentication and authorization throughout the application.
Pagination
Efficient data display with pagination for equipment lists, user lists, and transaction history.
File Upload with Validation
Image upload functionality with file type and size validation. Automatic thumbnail generation for uploaded images.
Database Integration
Robust MySQL database connection with proper schema design for users, equipment, transactions, and reservations.
Responsive Design
Bootstrap-powered responsive interface that works seamlessly on desktop, tablet, and mobile devices.
About Page
Informational page displaying project group name and team members who developed the system.
Screenshots
