Sarpras SMKN 11 Bandung
June 15, 2023
Inventory management system for SMKN 11 Bandung to manage school warehouse items and equipment efficiently.
Overview
Sarpras (Sarana Prasarana) is an inventory management system developed for SMKN 11 Bandung to streamline the management of school warehouse items and equipment.
Features
- Inventory Tracking: Track all school equipment and supplies
- Item Management: Add, update, and remove items from inventory
- User Management: Role-based access control for staff
- Reporting: Generate reports on inventory status
- Search & Filter: Easy search and filtering of items
Technical Implementation
Built using traditional web technologies with a focus on simplicity and reliability:
- Frontend: HTML, CSS, JavaScript for responsive user interface
- Backend: PHP for server-side logic
- Database: MySQL for data storage
- Architecture: MVC pattern for organized code structure
Challenges & Solutions
Challenge 1: Data Consistency
Ensuring inventory data remains accurate across multiple users.
Solution: Implemented transaction-based updates and validation checks.
Challenge 2: User Experience
Making the system easy to use for non-technical staff.
Solution: Created intuitive interface with clear navigation and helpful tooltips.
Impact
This system helped SMKN 11 Bandung:
- Reduce time spent on manual inventory tracking
- Improve accuracy of equipment records
- Streamline the borrowing and return process
- Generate reports for school administration
Learning Outcomes
- Practical experience with full-stack web development
- Understanding of database design and normalization
- User-centered design principles
- Project management and documentation