Implementasi Sistem Informasi Apotek Berbasis Web untuk Pengelolaan Data Obat

Abstract

Drug data management in most small and medium-sized pharmacies in Indonesia is still carried out manually through ledger books or separate electronic spreadsheets for purchasing, sales, and inventory data. This condition creates various challenges, including recording errors, delays in report preparation, difficulties in monitoring minimum stock levels, and the risk of expired medicines not being detected at an early stage. This study aims to design and implement a web-based pharmacy information system capable of integrating drug data management, purchase transactions, sales transactions, inventory monitoring, and reporting within a single platform. The system development method employed was the waterfall model, consisting of requirements analysis, system design using Unified Modeling Language (UML) and Entity Relationship Diagram (ERD), implementation using the PHP programming language with a MySQL database, and system testing using the black box testing method with the equivalence partitioning technique. The results show that the developed system successfully performs all major functions, including managing drug, category, and supplier data; recording purchase and sales transactions; automatically updating inventory; providing notifications for minimum stock levels and medicines approaching their expiration dates; and printing transaction reports. Black box testing of 15 functional scenarios showed that all scenarios operated as expected and were considered valid. The system is expected to improve data accuracy, accelerate transaction processes, and support decision-making in pharmaceutical procurement at pharmacies.