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

Tech Stack

HTML
CSS
JavaScript
PHP
MySQL

Tags

#web-app
#school-project
#inventory

AI Assistant

Ask me about Hasban