Pharmacy

Pharmacy-Management-System

The project aims to assist a pharmacy in managing its inventory, details of customers, employees and suppliers as well as keeping track of its purchases and sales. It is a web-based application implemented using PHP with MySQL as the Database Management System. User Interface is designed using HTML5, CSS3 and JavaScript.

Getting Started

Installation and Setup

Download and Install XAMPP
Open XAMPP Control Panel and start Apache and MySQL.
Clone the repository to your system or download and extract the zipped folder.
Place the folder PHARMACY in C:\xampp\htdocs.
In web browser, open localhost/phpmyadmin.
Create a new database called ‘pharmacy’ in phpmyadmin.
Import the file ‘pharmacy.sql’ into the database.

Launch

After successfully importing, start the project by typing the following in the web browser: localhost/PHARMACY/mainpage.php
The Login Page for Admin opens up by default. Login as Admin by using:
```
 Username: admin
 Password: password   
```
For Pharmacist Login, refer to the ‘emplogin’ table in the database. Example:
```
 Username: varshini
 Password: pass7
```

About the Project

Introduction

Pharmacia, a Pharmacy Management System aims to help in maintaining and managing the records for a pharmaceutical store by improving efficiency, accuracy and security.

Pharmacies need to maintain details of medicine stock, suppliers, employees, customers, any stock purchased by the pharmacy and any sales made by the pharmacy. The previous manual methods require the pharmacists to manually monitor all the records lists and transactions and to verify the presence of the each drug in the pharmacy. Searching for any required drug may be difficult.

Using the Pharmacy Management System, one can maintain stock and inventory, oversee transactions, manage suppliers and employees and maintains records of its customers. The system will help prevent waste of time and resources, allow easy access to medicines, as well as ensure more security and reliability for the data compared to the manual systems. The system assists the pharmacy in handling the daily requirements in a smoother, better and effective manner.

Objectives

The main objectives/features of the system are:

Ease of use
Deals with automation of tasks
Provides fast searching capabilities
Time and resources utilization is maximized via digitalisation
Generate alerts and reports as required on sales and medicines.

Users of the System

The system is developed for use by either the Admin or Pharmacists.

Admin Capabilities:

Access and update the list of available medicines/drugs
Access and modify drug suppliers’ data
Access and update any details of new purchases of stock for the company
Access and update all employees’ details
Access and update all customers’ details
Keep track of all sale transactions
Generate and view reports based on the data

Pharmacist Capabilities:

View the inventory of medicines, their price, quantity and other details – no changes are allowed from a pharmacist point of view
View minimal details regarding existing customers
Add a new customer to their database
Make a new sale and register the sale details onto the database

Database Architecture

MEDS: Contains details regarding the list of all medicines, mainly their type, the quantity currently present in the store and their price.

SUPPLIERS: Contains details regarding any of the drug suppliers who supply stock to the pharmacy.

PURCHASE: Contains details regarding any stock purchased by the company. Purchasing a stock consists of placing an order for multiple medicines and multiple suppliers via a single purchase on an online platform on a date as specified by purchase date (based on date of delivery). It also contains the manufacturing and expiry dates for the purchased items.

EMPLOYEES: Contains details regarding all employees, including Admin, Managers and Pharmacists.

CUSTOMERS: Contains details of all customers for ease during sales transactions.

SALES: Contains details regarding all sales made by the pharmacy. It keeps track of the sale invoice number, the customer ID of the customer, the employee ID of the employee who conducted the sales, the total amount of sale and the sale date and time.

SALES_ITEMS: Contains details regarding the particular medicines sold during each sale. It keeps track of the sale invoice number, the medicine ID, the quantity of that medicine purchased and total cost for that particular sale.

ADMIN: Contains the employee ID, the username and password for the Admin. Only a single record exists. Admin capabilities can be implemented only by this login.

EMPLOGIN: Contains the employee ID, the employee username and password for all the pharmacists and managers, apart from Admin. Pharmacist capabilities can be implemented by using any of the login details in the table.

Additional Information

Check the triggers, procedures and functions for further understanding.
If a new employee has been added, login details for a new employee can only be added using the database server.
Admin login details can only be changed using the database server.
For major changes, please open an issue first to discuss what you would like to change.

Live page

https://rashi7903.github.io/Pharmacy/ http://localhost/pharmacy/mainpage.php

Feel free to contact for any further queries.