Inventory Management System

Dashboard	Report

Note: The data shown in these screenshots is dummy data for demonstration purposes. No real information is displayed.

What is this?

SIM Persediaan. A web system to manage inventory for a whole Regency, connecting multiple Dinas and Units. It handles complex data and generates reports that fully comply with Permendagri standards.

The Story

The company and the client agreed the old system was already too outdated. It still used PHP 5 and CodeIgniter 3, and the frontend was running on Bootstrap 3, which missed many modern features and components. After they decided the system needed a full rebuild, I was assigned to rewrite everything from the ground up.

What I built

• I built the backend.
• I also created the frontend.

Tech Stack

• Laravel 10
• Bootstrap 5
• PostgreSQL 14
• Docker

One cool thing I learned

I learned many things through this project, because it was actually my first real task as a Fullstack Web Developer, especially on the backend side.

The most challenging part was dealing with complex queries in PostgreSQL, especially Common Table Expression (CTE). At that time, my database knowledge was still very basic, so it felt quite difficult. Another tough part was implementing the first-in, first-out (FIFO) algorithm, because the inventory logic had many conditions and scenarios. But after discussion with my senior developer, I finally understood it and completed the system. It became a very valuable learning experience for me.