Pharmear

PHARMEAR an open-source software for Pharmacy Store

PHARMEAR is open source, free to use, it offers a modern UI, with less clutter, easy to learn, easy to use, makes bills fast, shows you the status of your store, has intellisense to make bills with ease, user management and a lot more.

PHARMEAR is made using JAVA in Apache NetBeans, uses MySQL Server as the database, and libraries like jFreeChart, jCommon, and MySQL Connector/J for Bar Graphs and connection to the database. Git has been used for version control. Icons8, coolors.co are used for UI. We have implemented intellisense/autosuggestion in the program that helps users while bill making and managing stocks.

The theme of the project revolves around Medication. PHARMEAR is a simple program to use that can be used in a very low-end machine. It has very less to learn for users and much to offer them. We have just given the users what they want like Bill Making, Medicine Management, User Permission Control. We have a pre-made database of 4000+ medicines to help users while inserting medicine to the store. It also has a Pharmacy Status corner to tell users about their store.

Requirements

1. MySQL Database version 8.0
2. MySQL should be installed default location
3. MySQL Database Password
4. Microsoft Office Package

Installing

For the setup you need to download the pharmear_setup.exe and mysql_database.exe the you need to first install the MySQL Database and then install the Pharmear Program. While installing the MySQL you need to note down the admin password because while setting up the pharmear you need the password to connect to the database.Installing Pharmear is as simple as installing any other program in windows.

Setup

After installing pharemear you will get a setup screen where you need to add the MySQL database password and then test the conection, if you are successfully connected then with for the database to restore, you will get a confirmation that the database is restored and then you can proceed further.

Add User

To add the user we need fill a small form that contains the name of the user, user-type, and the username and the password then just click add. You can add as much users as you want. Then click next.

User Permission Control:

• Owner : Can access all the parts of Pharmear
• Medicine/Bill Manager : Can access all the parts except for the sales report
• Medicine : Can access all except for Bill, and sales report
• Bill : Can access all except for Medicine and sales Reprot

Shop Details

In Shop Details you can add the details of your shop, shop name, address, contact number and vat number. Then just press set.

Finish

Once you are in the finish screen you just need to press Complete button to finilize the setup. The program will close once you press comoplete and then you need to reopen it for login page.

Login Page

After the setup is completed Pharmear will open a login screen for you to input the credentials and you are in the program. You will be assigned with the permission according to the type of user you are.

Welcome Page

This will be the page that will come first to you when open the program from here you can navigate yourself to the tabs you want also there is a Status of your pharmacy to get information about the out of stock, expired, total cost, total quantity, total medcicine in your pharmacy.

Medicine Manage

In Medcine Manage you can add, view and delete medicines in your store.

• It has a find tab to search medicine you can also type * to view all the medicines in your pharmacy.
• The table shows the result of the search.
• You can select a row in the medicine to delete it.
• Clear button clears the table and other text feilds.
• Medicine Details is used to add medicines to your store, you just need to fill the details and click add.
• Medicine Details has Intellisese to make the process easy.

Bill Making

This is the main part of pharmear that makes the bill.

• On top we have the invoice number and date.
• There a table that shows the medicine in the bill when you add it.
• Patient details is the area where you add the name of the paitent/customer.
• Add Medicine is where you add the medicine to the bill, just input the quantity and name of medicine then press add.
• Command center is the area where you can control the functionalities like saving, printing and saving.

Sales Report

Here you can see the total cost of medicine, total cost of sold medicine and total quantity, total sold quantity.

User Account

• User Account you change your name, username and password.
• You can also change the shop name, address, contact and vat no.
• In the right side there is a Pharmacy Status.