Diseño e implementación de una aplicación web, que permita la gestión de clientes, cotización on-line, ventas e inventarios de la farmacia “Farmamedic”.

Abstract

The objective of this project was to provide a specific, simple, and efficient web application that allows the pharmaceutical biochemist the proper management of their pharmacy, automating the sales process, inventories, customer management, and offering the customer a service of online quote as well. Following the SCRUM methodology, we developed the whole application, using free software tools such as: JAVA, Servlets, PostgreSQL, Payara Server 4.1, Bootstrap and Restful web services. The implemented system was evaluated according to ISO / IEC 25010 regarding performance efficiency in its three sub characteristics, we carried out a statistical study for time behavior using the Wilcoxon Test, resulting in that the sales time with the application is less compared to the sales time without the app, rated as HIGH. For the resource utilization, the use of hardware was measured with the task manager in the three main browsers, determining that the usage is LOW and the browser which is recommended is Firefox. We performed a stress test for capacity with the ApacheJMeter application in which it was demonstrated that the responsiveness of the application is 1000 users using the application in 1 second, thus, considering the capacity and performance efficiency as HIGH. The system allows the pharmacist to perform all the activities carried out in a pharmacy such as: sales, proper stock management, reports for inventory management and customer management with a friendly and intuitive interface. The client collaborated during the whole project. We recommend adding the invoicing module with the SRI, which is essential for a growing business.