Design and Evaluation of an Integrated Electronic System for Prescription Management, User–Pharmacy Connectivity, and Drug Inventory Management in Libya
DOI:
https://doi.org/10.65405/p9xtcj96Keywords:
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
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











