Pharmacy management system fyp documentation

Pharmacy management system fyp documentation
complete project report
Online Pharmacy is a software which is used for small or big level organization such
as pharmacy.This software is based on online pharmacy in which customer orders a
particular medicine and get it.The main purpose of this webapp is to provide facility
to the people living in remote areas or people who uses a particular medicines
monthly but they can’t get it due to a number of reasons.So this app less their worries
and make medicines available for them.Moreover if people are unable to go to the
doctor,they also visit our website and get medicines after complete consultation of our
online doctor.It performs several other operations like adding new doctor,adding new
medicine,delete or modify a medicine approving medicine orders etc .It is made in
java so it is platform independent it can run on any platform like Windows, Unix and
MacOS etc.

1. FINAL YEAR PROJECT
ONLINE PHARMACY MANAGEMENT



SESSION 2016-2020









G1F16BSCS0042 RUKHSAR AMANULLAH
G1F16BSCS0070 NOOR FATIMA
G1F16BSCS0074 HADIA ASGHAR




BACHELOR OF SCIENCE
IN
COMPUTER SCIENCE

2. ​Pharmacy Management System


By


Rukhsar Amanullah
Noor Fatima
Hadia Asghar


Projected submitted to
Faculty of Information Technology,
University of Central Punjab,
Lahore, Pakistan.
in partial fulfillment of the requirements for the degree of



BACHELOR OF SCIENCE
IN
COMPUTER SCIENCE



Lecturer Muzammal Sadiq​ ​Prof. Shahid Saleem

___________________ _______________
​Project Advisor ​ ​Dean

3. Acknowledgement
TheSatisfactionThatAccompaniestheSuccessfulCompletionofAnyTaskWould
BeIncompleteWithouttheMentionofPeopleWHOSEContinuedCooperationMade
ItPossible,WhoseConstantGuidanceandEncouragementCrownAllEffortswith
Success.
We Are Grateful to ​Allah Almighty ​who gives us strength to do this. and then We
AreGratefultoOurProjectSupervisor“​LecturerMuzammalSadiq”Forthe
Guidance,InspirationandConstructiveSuggestionsThatHelpfulUsinthe
PreparationofThisProject.WeAlsoThankOurUniversityFellowsandOther
teachers and People Who Have Helped Us in Successful Completion of The Project.




















i

4. Dedication
WeWouldLiketoDedicateThisWorktoOurParentswhoworkhardforus,who
gavealltheirhappinesstousandourTeachers,FamilyandFriendsforTheirLove
andSupportThroughoutOurLifewhotaughtushowtolearn.EspeciallyThanksto
UniversityofCentralPunjabForGivingUsSuchAWonderful,EnergeticMoments
of Our Lives.

























ii

5. ​Abstract
OnlinePharmacyisasoftwarewhichisusedforsmallorbiglevelorganizationsuch
aspharmacy.Thissoftwareisbasedononlinepharmacyinwhichcustomerordersa
particularmedicineandgetit.Themainpurposeofthiswebappistoprovidefacility
tothepeoplelivinginremoteareasorpeoplewhousesaparticularmedicines
monthlybuttheycan’tgetitduetoanumberofreasons.Sothisapplesstheirworries
andmakemedicinesavailableforthem.Moreoverifpeopleareunabletogotothe
doctor,theyalsovisitourwebsiteandgetmedicinesaftercompleteconsultationofour
onlinedoctor.Itperformsseveralotheroperationslikeaddingnewdoctor,addingnew
medicine,deleteormodifyamedicineapprovingmedicineordersetc.Itismadein
javasoitisplatformindependentitcanrunonanyplatformlikeWindows,Unixand
MacOS etc.




















iii

6. Table of Contents
Acknowledgement i
Dedication ii
Abstract iii
1.​ ​Introduction 1
1.1​ ​Product 1
1.2​ ​Scope 1
1.3​ ​Business Goals 1
2.​ ​Overall Description 2
2.1​ ​Product Features 2
2.2​ ​User Classes and Characteristics 2
2.3​ ​Operating Environment 3
2.4​ ​Design and Implementation Constraints 3
3.​ ​Functional Requirements 4
4.​ ​Non-Functional Requirements 4
4.1​ ​Performance Requirements 4
4.2​ ​Safety Requirements 4
4.3​ ​Security Requirements 4
4.4​ ​Other Requirements 5
5.​ ​Software Development Model (SDM) 6
6.​ ​System Development Diagrams 7
6.1​ ​Use Case Diagram 7
6.2​ ​DFD Level-0 8
6.3​ ​Flow Chart 9
6.4​ ​Activity Diagrams 10
6.4.1​ ​Login 10
6.4.2​ ​Creating an account 11
6.4.3​ ​Change password 12
6.4.4​ ​Add new doctor 13
6.4.5​ ​Add new medicine brand 14
6.4.6​ ​Add to cart 15
6.4.7​ ​Delete medicine 16

7. 6.4.8​ ​Delete patient 17
6.4.9​ ​Add medicine 18
6.4.10​ ​Manage order 19
6.4.11 Search medicine 20
6.4.12 ​ ​Update medicine 21
​6.5​ ​DFD Level-1 22
6.6​ ​DFD Level-2 23
6.6.1​ ​Medicine data 23
6.7​ ​Entity Relationship Diagram 24
6.8​ ​Class Diagram 25
7.​ ​Tools and Technologies 26
7.1​ ​Back end development 26
7.2​ ​Front end development 26
7.3​ ​Database 26
7.4​ ​XAMPP 26
8.​ ​Screens 27
8.1​ ​Home page 27
8.2​ ​Create account 28
8.3​ ​Login 29
8.4​ ​Manage medicine 30
8.5​ ​Manage stock 31
8.6​ ​Medicine categories 32
8.7​ ​Medicine brands 33
8.8​ ​Manage specialization 34
8.9​ ​Doctor registration 35
8.10​ ​Manage patient 36
8.11​ ​Manage orders 37
8.12​ ​Change password 38
8.13​ ​Help 3​9
9. References​ ​ 40

8. 1.Introduction
1.1 Product
Thissoftwareisacompletepackageofmedicinesinwhichacustomerordersamedicineby
registeringhimselffirst.Moreoverhecanalsoconsultwithadoctorifhehasanyqueryabout
aparticularmedicinethroughemail.Ourthisproductmainlycaterstothepeoplelivingin
remote areas who have no pharmacy near them.
1.2 Scope
Thesoftwareproducttobeproducedisanonlinepharmacywhichwillautomatemajor
medicalstoreoperations.Keepingrecordsofthemedicines,numberofstocks,Quantityof
medicine.some other operations are as follows:
1. Modify the attributes of medicines.
2.Adding a new doctor.
3. Deleting a medicine.
4.Viewing Registered patients detail.
5.Approving orders.
1.3 Business Goals
MainbusinessgoalwhichwecanachievebyOnlinePharmacyistomaintaintherecordsof
allcustomers/patientswhopurchasemedicinesfromusandbyprovidingthemthefacilityof
consultationfromouronlinedoctors.Moreover,ourmainpurposeistoprovidemedicinesto
thepeoplewhoareunabletogotopharmacystoreduetoanyreasonbuttheyreallyinneed
of medicines.So by visiting our website they can order medicines easily.
1

9. 2.Overall Description
2.1 Product Features
Features of online Pharmacy are as follows:
• Keeping records of all medicines
• Keeping records of all patients.
• Keeping records of all doctors Adding or removing records of new medicines ,patients
• Adding new categories and brands of medicines
• Approving the orders of customers
• Providing doctors consultation if needed.
2.2 User Classes and Characteristics
Admin
1.Admin can add,view ,update ,delete medicines.
2. Admin can add new medicine brands and categories.
3. Admin can add new doctors.
4.Admin can view ,delete patient records.
5. Admin can view all approved and pending orders.
6.Admin can change medicine stock.
Doctor
1. Doctors can view all the approval requests for orders.
2. Doctors can send approval comments on medicine.
3.Doctors can chat with customers through email.
Patient
1. Patients can search for a medicine.
2.Patients can register themselves to order a medicine.
3.Patients can consult about medicine from a doctor.
4.Patient can view his order in order to decide whether his orders get approved or not.
2

10. 2.3 Operating Environment
Ourwebsitehasafriendlyoperatingenvironmentanditcanrunsmoothlyonwebbrowsers
likegooglechrome,Opera,MozillaFirefoxwithgoodconnectivitytotheinternet.Itmaylose
its functionality when run on older Internet explorer versions.
2.4 Design and Implementation Constraints
OnlinePharmacyisdevelopedaspercurrentstructureofcertainpharmacies,butinfutureif
thisstructurehavetochangethenwewillchangeitaccordingtotherequirements.Aswehave
madeourwebsiteusinghtml,php,Csssowecanoperateitonlineusinggoodconnectivityof
internet.MoreoverifwehavetomadeMobapp,thenwewillmadeittoousingandroid
development.
3

11. 3.Functional Requirements
All users will have their login to access the system, user can be admin,doctor,patient.
●Admincanaddnewmedicines,registernewdoctors,viewrecordsofpatients,deletingthe
medicine,managetheorders,viewingapprovedandpendingorders,modifyingtheattributes
of medicine,deleting or changing the status of any medicine,changing his password.
●Doctorscanviewallthemedicinesthatarewaitingforapproval.afterdoctorapprovedthe
medicinethatmedicinewillmovetotheapprovedordersmenu.Doctorcanalsocontactthe
patient if the patient wants to consult about a particular medicine through email.
●Patientswillregisterthemselvesfirst,afterthattheycansearchamedicineinthesearchbar
,ifthatmedicineexistsinourdatabaseitwillbedisplayed.Patientsmakeordersbyclicking
ontheaddtocartbuttonandthenconfirmtheirorder.Moreovertheycanalsoseetheir
previous records of medicines which they purchased.
4.Non-Functional Requirements
4.1 Performance Requirements
Oursystemwillperformallitsfunctionalitysmoothlyandcorrectlyevenifithasahuge
amountofrecordsofpatients,doctorsandmedicines.Increasednumberofmedicines,orders
will never affect its performance.It runs smoothly.
4.2 Safety Requirements
Minimumdataoftheprevious10yearsshouldberetainedinthedatabasesafelysothatatthe
end of these 10 years data can be stored in CDs or Hard Drives.
4.3 Security Requirements
Systemshouldbeaccessedbyauthenticusernamesandpasswordssothatdataandoperations
ofsystemcanstoreandoperatebyauthenticusersofsystemlikeadminusehisown
passwordandusernamenoneotherthanadminwillallowtoviewallrecordsrelatedto
medicines,patients,orders.Similarly,doctorandpatientswillalsousetheirownusername
andpasswordsensuringthattheenteredpasswordandusernameiscorrect.Incaseofwrong
entryofpasswordandusernameoursystemwillnotallowthemtoaccessfurtherinformation
.
4

12. 4.4 Other Requirements
Systemshouldberunonanyplatform(operatingsystem)sothatallthetasksofthesystem
can be performed easily.
5

13. 5.Software Development Model (SDM)
WeuseWaterfallModelfordevelopmentofoursystem,becauseourrequirementsfor
thesystemarewellknownandunderstand.Andourprojectisnottoolargesoitsuitsbestfor
ourproject.Itiseasytomanageduetotherigidityofthemodelaseachphasehasspecific
deliverables and a review process.

6

14. 6.System Development Diagrams
6.1 Use Case Diagram


7

15. 6.2 DFD Level-0






8

16. 6.3 Flow Chart








9

17. 6.4 Activity Diagrams
6.4.1 Login







10

18. 6.4.2 Creating an account





11

19. 6.4.3 Change Password



12

20. 6.4.4 Add new doctor






13

21. 6.4.5 Add new medicine brand



14

22. 6.4.6 Add to cart




15

23. 6.4.7 Delete Medicine




16

24. 6.4.8 Delete Patient


17

25. 6.4.9 Add Medicine


18

26. 6.4.10 Manage Order




19

27. 6.4.11 Search Medicine









20

28. 6.4.12 Update Medicine




21

29. 6.5 DFD Level-1






22

30. 6.6 DFD Level-2
6.6.1 Medicine Data





23

31. 6.7 Entity Relationship Diagram


24

32. 6.8 Class Diagram














25

33. 7.Tools and Technologies
7.1 Back end development
Weusephpandajaxfordevelopmentofbackendofonlinepharmacy.Phpisapopular
scriptinglanguagethatisspeciallydesignedfordevelopingwebsite.Ajaxconsistsofmany
web development techniques used on the client side for asynchronous web application.
7.2 Front end development
Weusehtml5,css3,bootsrap4,jquery,javascriptforthedevelopmentofthefrontend.Theseall
programminglanguagesprovideusthecompletepackageforinteractivedevelopmentof
frontend providing a user friendly interface.
7.3 Database
We use MySQL database for storing all data of patients, medicines, orders and doctors.
7.4 XAMPP
We use Xampp for server hosting and managing ports of the system.





26

34. 8.Screens:
8.1 Home Page
Thisisourfirstscreenconsistingofacompleteoverviewofthewebsite.Medicinesare
displayedhere.Usercanalsosearchanymedicinefromsearchbar.Userhavetocreatean
accountoruseloginoptionifhehavealreadymadeanaccount.So,overalltotalinformation
is provided here for the user.







27

35. 8.2 Create Account (Registration)
Inthisscreenthecustomerscreatetheiraccountbyaddingtheirinformationinorderto
purchase medicines and consult with our online doctors if needed.





28

36. 8.3 Login:
Inthisscreenusercanlogintotheiraccountbyenteringtheirusernameandpassword.User
may be admin,doctor or patient.







29

37. 8.4 Manage Medicine:
Thisscreenisusedbyadmin.Admincanaddnewmedicineswithallinformationlike
medicinename,companyname,medicinetype,expirydate,priceofmedicinethenthenew
medicineisadded.Somekindofdrugaddictivemedicinesareinitsothestatusofthese
medicinesareinactiveOthermedicinesthatareeasilyavailableareactiveanddisplayinthe
homepage screen .












30

38. 8.5 Manage Stock:
Thisscreenisalsoforadmin.Admincanmanagethemedicinesstockandprice.Here,all
medicinesthatareinthestockofpharmacyareshownalongwiththeirprice,typeof
packaging,brandandcategoryofmedicine.Stockcanbeupdatedbyclickingontheeditstock
button.













31

39. 8.6 Medicine Categories:
Thisscreenisusedbyadmin.Admincanaddnewcategoriesofmedicines.Thiscategory
can also be edited to make new changes in the stock or can also be deleted.
















32

40. 8.7 Medicine Brands:
InthisscreenadminaddthenewmedicinebrandinthewebsiteandbrandDescription.By
clickingonsubmitformbuttonthenewmedicinebrandwillbeaddedinthe
website.Medicine brand can also be edited or deleted.














33

41. Doctors Management
8.8 Manage Specialization:
Thisscreenisalsousedbyadmin.Admincanaddspecializationofdoctorsthatareavailable
in the pharmacy.Doctors who provide consultation will be active otherwise inactive.










34

42. 8.9 Doctor Registration:
InthisscreenAdmincanadddoctorsbyaddingtheirdetailsi.edoctorname,Email,
Specialization, Qualification ,CNIC,Address, Phone number .


35

43. Patients Management:
8.10 Manage Patients:
Inthisscreenthedetailsofallpatientswhoareregisteredinthewebsitewillappear.The
status of the regular patients are active and those who are not regular are inactive.















36

44. Orders Management:
8.11 Manage orders:
In this screen the details of approved and auto approved orders will appear .















37

45. 8.12 Change Password:
Admin,doctor and patient can change their passwords from this screen.















38

46. 8.13 Help:
Inthisscreentheusercanwriteafeedback,messageoranyqueryrelatedtoourwebsitein
the message box along with their name and email.


















39

47. 9. References:

1. ​Learning Php.MySql ,javaScript,CSS from
https://education.fsu.edu/wp-content/uploads/2015/04/Learning-PHP-MySQL-JavaSc
ript-and-CSS-2nd-Edition-1.pdf
2.Roger S .pressman(January 2009.)Software Engineering: A Practitioner's Approach
3.Introduction to Software Engineering by Somervile.
4.Use draw.io tool for making diagrams e.g use case ,ER ,activity,DFD
https://app.diagrams.net/
40