Pharmacy-Management-System

KO | EN

gitlite — search

#hacktoberfest #react #ai #typescript #llm #go #golang #machine-learning #docker #nodejs #vue #awesome-list #pytorch #open-source

Pharmacy-Management-System

(★ 55)

A web-based application implemented using PHP, MySQL, HTML5, CSS3 and JavaScript.

Pharmacy-Management-System 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 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

1. Download and Install [XAMPP](https://www.apachefriends.org/download.html)
2. Open XAMPP Control Panel and start Apache and MySQL.
3. Clone the repository to your system or download and extract the zipped folder.
4. Place the folder PHARMACY in *C:\xampp\htdocs*.
5. In web browser, open *localhost/phpmyadmin*.
6. Create a new database called 'pharmacy' in phpmyadmin.
7. Import the file 'pharmacy.sql' into the database.

## Launch

1. After successfully importing, start the project by typing the following in the web browser:  *localhost/PHARMACY/mainpage.php*   
2. The Login Page for Admin opens up by default. Login as Admin by using:
    ```
    Username: admin
	Password: password   
    ```
3. 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

### Screenshots

#### Admin Login Page

#### Admin DashBoard

### 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

### Screenshots

#### Pharmacist Login Page

#### Pharmacist DashBoard

***Check out other screenshots showing interface functionality here: [Screenshots](Screenshots)***

## 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. 
	
### ER Diagram

### Relational Database Model

## 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.

*Feel free to contact for any further queries.*

Pharmacy-Management-System

Pharmacy-Management-System 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Pharmacy-Management-System

Pharmacy-Management-System 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README