SOFTWARE GHOSTS
PHARMACY MANAGEMENT WEB APPLICATION
- PHARMAX is a web application designed to manage pharmacies and meet all their needs. The application is built on a carefully designed and optimized database and a solid system that combines powerful performance with great UI experience.
- PHARMAX improves your pharmacy management experience with all the functions it comes with, such as viewing data tables, adding or modifying data via simple forms that are very user friendly, choosing between multiple themes that gives you the best color experience, securing your data and providing different account types with different privileges that satisfy managers’ needs. Moreover, this application is being developed and improved by time as we try to improve our ideas and get best out of users’ feedbacks. We hope you will have a great experience using PHARMAX and get best out of it.
- This application is created by Software Ghosts ; a team of five 3 rd year Computer Engineering students “ Ahmed Bally, Abdelrahman Abdelhamid, Abdelrahman Metwaly, Mohamed Adam and Mona Mardy ” supervised by Prof. Dr. Amany Sarhan.
(Admin) Full Access
- View all data tables.
- Add, update or remove existing data.
(Pharmacist) Partial Access
- Create invoices.
- View customers, medicines and inventory data
- Manage medicines, inventory and customers data.
(Sales) Partial Access
- View pharmacies, customers, invoices, inventories and suppliers’ data.
- Manage medicines, customers and suppliers data.
(1) Navbar Buttons
- Notifications – alerting medicines status.
- Account Settings – quick access to account, app settings and logout.
(2) Recent Stats Panels
- New Customers – no. of new customers registered within last week.
- New Invoices – no. of new invoices printed within last week.
- Need Restock – no. of medicines running out of stock
- Expire Soon – no. of medicines expiring in 3 months.
(3) Statistics
- Sales Comparison – total sales from each pharmacy branch.
- Branches Sales – total no. of items sold from each pharmacy branch.
- Sales – advanced sales charts.
- Logs – saving all employees action for further reviews by managers. Both reports sections are not available yet.
- Display data stored in the pharmacy database.
- Tables as displayed are summarized in the following structure:
- Inventory table shows products in stock for each different pharmacy branch.
[Table] - Displayed Columns
[Pharmacies]: Pharmacy | Location | Phones | Admin | Admin Phone
[Employees]: Employee ID | Pharmacy | First Name | Last Name | Employee Phone | Address | Type | Salary | Shift | Hire Date | Photo
[Customers]: Customer ID | Name | Address | Phone | Score
[Invoices]: Invoice ID | Items | Employee Name | Customer Name | Print Date | Total | Pharmacy
[Inventory]: Product ID | Name | Price Quantity | Expire Date | Barcode
[Medicines]: Medicine ID | Name | Description | Supplier ID | Supplier Name
[Suppliers]: Supplier ID | Name | Phone Address | Email
- Data tables are displayed according to user type (privilege dependent).
- Clear and not confusing display of data for each table.
- Dynamic search within all columns that works on typing, for each table.
- Choose number of rows to be displayed per page.
- All tables support sorting by any column.
- Manage selling process by creating new invoices for customers through the Invoices Panel – Management > Invoices. 1. Adding medicines a. Search for medicines by their name or barcode. b. Results will show up on typing, must click the medicine name to add. c. Only medicines in current user’s pharmacy’s inventory will appear. 2. Modifying invoice list a. You can modify quantity of each medicine as desired. b. Delete button is available to remove a medicine from the invoice. c. Total price will be updated on any change. 3. Registering customer (optional) a. Register a new customer or assign existing one to this invoice. b. On typing the customer’s phone number, the number would show up by auto completion if it already exists in the database, must click the result for rest of the customer’s data to be filled automatically. c. Click Confirm & Print to print the invoice.
- Add , Update or Delete data to / from the tables: Pharmacies, Employees, Customers, Inventory, Medicines and Suppliers.
-
Adding a new branch to the database requires the new branch’s address and phone number(s) then Submit. Pharmacy number should be ignored. Administrator employee is assigned to the new branch after creation, using modify an existing branch form.
-
To Modify an existing branch, select the pharmacy from the list, change desired values and Admin Employee then apply changes. You can remove this branch from the database using Remove Branch button.
Supplier Management is very similar in functionality to the previous example.
Rest of management pages “Employees – Customers – Inventory – Medicines” are similar, with two sections on each page, one for adding and another one for modifying , but there are few differences:
- Modifying any data record from the previous tables using modify section in each one’s page requires searching for the desired record with the specified value in placeholder , and then must click on a result that is shown by auto completion to select that record.
- Adding a new item to any of these tables is similar, simply fill form with the required data then click Submit Button.
NOTE that a Success message will always show up on cases of successful operation, for any of the app functions. Failure message will show up otherwise.
- In PHARMAX medicines and products are not the same.
- Medicines represent the data from which we create products; this solves problems like having different units from the same medicine with different production and expire dates or different barcodes.
- To add a medicine product (that can be added to invoices):
- Add the medicine to your database using Add form in Medicines management page, as shown in previous example. This requires Medicine’s name , description and Supplier.
- Note that you must specify the supplier, therefore you must make sure the medicine’s supplier is added previously using Supplier management page. If not, you might need to add it first. 3. After adding the medicine, go to Inventory management page, where you can add new products to selected pharmacy’s inventory (or update existing products, of course). 4. You will need to search for the medicine and must click on one result from the auto completion, select the pharmacy and enter product’s price , quantity , expire__date and barcode , then submit.
- Adding or modifying any data as shown before is a simple process. However, you must know the accepted data formats or patterns to have a proper accepted input. The following table shows the accepted format for each field you would see in any of the forms.
Field Name Accepted Format Name A string in English alphabet with spaces allowed between words. First Name A string in English alphabet up to 25 characters. Last Name A string in English alphabet up to 25 characters. Username A string starting with (A-Z, a-z) character, followed by same characters, numbers, backslash, underscore or dots. Maximum 20 characters. Password A string in any characters with minimum length of 5. Address A string in any characters. Salary A number in 0 to 9 with minimum length of 3. Phone A number in 0 to 9 only, with minimum length of 7 and maximum length of 15. Description A string in any characters. Email Address A string in proper email address format, e.g. name@site.com
- Notifications page displays tables containing the following data: 1. Expire Soon – all medicines expiring in less than 3 months. 2. Expired – all medicines that are already passed expire date. 3. Need Restock – all medicines which quantity are below 10.
- Each section displays info related to its notification.
- All Table Features work on notifications tables as well.
- This feature is not available yet but is expected to be added in next versions to help scheduling and managing the pharmacy process and its related work.
- PHARMAX cares about UI and user experience using the application, therefore it supports theming. In App Settings page you can find 4 different themes to choose from.
- The Popup buttons are added to preview success or error popups.
- There are two sections in Account Settings page
- Current Info – displays information about the user currently logged- in and displays the profile picture.
- Update Info – contains a form that allows you to update your data, password or profile picture. You must enter your current password to be able to save any changes.