Design and Evaluation of an Integrated Electronic System for Prescription Management, User–Pharmacy Connectivity, and Drug Inventory Management in Libya

Authors

  • Huda Dakhl Allah Jomma Department of Computer, College of Electronic Technology, Tripoli, Libya Author
  • Suheer Ramadhan Abdulsalam Department of Computer, College of Electronic Technology, Tripoli, Libya Author

DOI:

https://doi.org/10.65405/p9xtcj96

Keywords:

drug inventory management, medicine availability, stock reservation, transaction integrity.

Abstract

Reliable medicine searches depend on linking availability information to the stock committed to an order. Roshita was developed and evaluated in Libya to help users find nearby pharmacies with the required medicines and connect their orders to pharmacy inventory management. Requirements came from 150 questionnaire responses and interviews and observation in five Tripoli pharmacies. Development followed an Agile incremental approach. The system comprises three applications sharing Firebase services: an Android mobile application for users, a Windows desktop application for pharmacy management, and a React web application for administration. Backend transactions coordinate reservations, partial offers, invoices, collection, and internal insurance records. Evaluation covered functionality, integration, transaction integrity, access control, and performance. Functional and component integration tests passed in 26/26 user cases, 39/40 pharmacy cases, and 15/15 administrative cases. All 12 executed system integration scenarios passed out of 14 planned. Targeted tests confirmed single allocation of contested stock, prevention of duplicate invoices, and consistent terminal order outcomes; three pharmacy corrections passed retesting. A five-minute local-emulator workload reaching 25 virtual users recorded an order-confirmation P95 of 331.29 ms against a 3,000-ms limit, with a maximum of 10.94 seconds. The error rate was 1.10%, exceeding the 1% ceiling. Dashboard loading averaged 3,287.46 ms against a 3,000-ms target. These findings support functional feasibility and the tested transaction controls. The contribution is an evaluated workflow connecting pharmacy selection by medicine availability and distance with stock reservation and fulfilment across three applications, providing a foundation for field evaluation.

Downloads

Download data is not yet available.

References

Barrington, J., Wereko-Brobby, O., Ward, P., Mwafongo, W., & Kungulwe, S. (2010). SMS for Life: A pilot project to improve anti-malarial drug supply management in rural Tanzania using standard technology. Malaria Journal, 9, Article 298. https://doi.org/10.1186/1475-2875-9-298

Google. (n.d.-a). Cloud Firestore triggers. Cloud Functions for Firebase Documentation. Retrieved October 8, 2026, from https://firebase.google.com/docs/functions/firestore-events

Google. (n.d.-b). Text recognition v2. ML Kit Documentation. Retrieved October 8, 2026, from https://developers.google.com/ml-kit/vision/text-recognition/v2

Google. (n.d.-c). Transactions and batched writes. Firebase Documentation. Retrieved October 8, 2026, from https://firebase.google.com/docs/firestore/manage-data/transactions

Google. (n.d.-d). Writing conditions for Cloud Firestore Security Rules. Firebase Documentation. Retrieved October 8, 2026, from https://firebase.google.com/docs/firestore/security/rules-conditions

Grafana Labs. (n.d.). Thresholds. Grafana k6 Documentation. Retrieved October 8, 2026, from https://grafana.com/docs/k6/latest/using-k6/thresholds/

International Organization for Standardization & International Electrotechnical Commission. (2023). Systems and software engineering—Systems and software Quality Requirements and Evaluation (SQuaRE)—Product quality model (ISO/IEC 25010:2023). https://www.iso.org/standard/78176.html

International Organization for Standardization, International Electrotechnical Commission, & Institute of Electrical and Electronics Engineers. (2022). Software and systems engineering—Software testing—Part 1: General concepts (ISO/IEC/IEEE 29119-1:2022). https://www.iso.org/standard/81291.html

Lundhaug, K., Faxvaag, A., Stokke, R., & Andreassen, H. K. (2025). Collaboration routines and workflows in a national electronic prescription system: Qualitative study. Journal of Medical Internet Research, 27, Article e56558. https://doi.org/10.2196/56558

Peffers, K., Tuunanen, T., Rothenberger, M. A., & Chatterjee, S. (2007). A design science research methodology for information systems research. Journal of Management Information Systems, 24(3), 45–77. https://doi.org/10.2753/MIS0742-1222240302

Sattar, A., Rehman, H., Naveed, S., Khadim, S., Khan, N., Kazi, A. F., Syed, W., Al-Rawi, M. B. A., & Jamshed, S. (2025). Trustworthiness of web-based pharmacy apps in Pakistan based on the Mobile App Rating Scale: Content analysis and quality evaluation. JMIR mHealth and uHealth, 13, Article e59884. https://doi.org/10.2196/59884

Soeno, S., Liu, K., Watanabe, S., Sonoo, T., & Goto, T. (2024). Development of novel optical character recognition system to reduce recording time for vital signs and prescriptions: A simulation-based study. PLOS ONE, 19(1), Article e0296319. https://doi.org/10.1371/journal.pone.0296319

World Health Organization. (2019). WHO guideline: Recommendations on digital interventions for health system strengthening. https://www.who.int/publications/i/item/9789241550505

Wondmagegn, M. T., Nabaasa, E., Melesse, E. A., & Kassaw, E. A. (2023). A framework for locating prescribed medication at pharmacies. Integrated Pharmacy Research and Practice, 12, 127–136. https://doi.org/10.2147/IPRP.S415674

Downloads

Published

2026-11-15

How to Cite

Design and Evaluation of an Integrated Electronic System for Prescription Management, User–Pharmacy Connectivity, and Drug Inventory Management in Libya. (2026). Comprehensive Journal of Science, 11(42), 2350-2360. https://doi.org/10.65405/p9xtcj96