Research Article
Automated Drug Expiry Detection and Alert System Via Email Notifications
Ebole Alpha Friday*
,
Tiamiyu Olalekan Sorlihu
Issue:
Volume 14, Issue 1, June 2025
Pages:
1-9
Received:
10 December 2024
Accepted:
22 December 2024
Published:
24 January 2025
DOI:
10.11648/j.ajnc.20251401.11
Downloads:
Views:
Abstract: Effective pharmaceutical management is vital for healthcare systems, where timely identification of drug expiry dates is crucial to ensure patient safety and regulatory compliance. This paper presents an automated system for drug expiry date detection and email alerting, aimed at enhancing the efficiency and reliability of pharmaceutical management. Traditional manual tracking methods are often prone to errors and inefficiencies, leading to potential health risks. The proposed system automates this process, ensuring prompt notifications to relevant stakeholders. The system features a centralized database for storing drug information, barcode or QR code scanning for data entry, an expiry date detection algorithm, and an integrated email alerting mechanism. The database, managed using MySQL, contains detailed records of each drug, including its name, batch number, manufacturing date, expiry date, and quantity. Barcode or QR code scanners facilitate quick and accurate updates to the database, implemented through a Python-based application. The expiry date detection algorithm runs periodically, comparing current dates with stored expiry dates to identify drugs nearing expiration within a specified threshold, typically 30 days. Upon detection, the system triggers email alerts with detailed drug information sent to pharmacists, healthcare providers, and inventory managers, prompting timely action to prevent the use of expired medications. Testing in a controlled environment with a sample dataset demonstrated that the algorithm accurately identified drugs nearing expiry and generated appropriate email alerts. User feedback indicated significant improvements in efficiency and a reduced risk of expired drug usage. This automated system offers a proactive approach to managing drug inventories, minimizing human error, and enhancing compliance with health regulations. By automating expiry date tracking and alerting, it improves pharmaceutical safety and streamlines inventory management. Future enhancements could include additional notification methods, such as SMS alerts, and expanding the system’s capabilities to manage other aspects of pharmaceutical inventory.
Abstract: Effective pharmaceutical management is vital for healthcare systems, where timely identification of drug expiry dates is crucial to ensure patient safety and regulatory compliance. This paper presents an automated system for drug expiry date detection and email alerting, aimed at enhancing the efficiency and reliability of pharmaceutical management...
Show More
Research Article
The Role of Information and Communication Technology in Women's Decision-Making on Reproductive Health and Household Expenditures
Issue:
Volume 14, Issue 1, June 2025
Pages:
10-22
Received:
17 March 2025
Accepted:
4 May 2025
Published:
12 June 2025
DOI:
10.11648/j.ajnc.20251401.12
Downloads:
Views:
Abstract: The study investigates whether the affordability and penetration of information and communication technology among women contribute to their empowerment in Pakistan, analyzing this relationship at both provincial and residential levels. It further examines how information and communication technology influences women’s empowerment while facilitating progress towards achieving the Sustainable Development Goals. The study empirically examines the impact of information and communication technology on women’s decision-making power within households across Pakistan’s provinces, utilizing data from the Household Integrated Economic Survey 2018-19. The analysis employs a binary logit model and the classification and regression tree techniques. The findings reveal a significant and positive impact of information and communication technology on women’s decision-making power, identifying it as the most important predictor for the women’s decision regarding expenditures at household level and about her reproductive health. Furthermore, the classification and regression tree technique indicates that Punjab leads other provinces, while Balochistan furthest behind in achieving the Sustainable Development Goals Agenda 2030. While from other socioeconomic and demographic variables, the odds of number of son, women’s age, education level, residence and region are more likely and significantly associate with the women’s decision-making power. The findings of the study support the policies in favor of ICT penetration and improving women’s access to education and employment opportunities to enhance women’s autonomy in Pakistan.
Abstract: The study investigates whether the affordability and penetration of information and communication technology among women contribute to their empowerment in Pakistan, analyzing this relationship at both provincial and residential levels. It further examines how information and communication technology influences women’s empowerment while facilitatin...
Show More
