Medical Shop Management A Project Report: Submitted by
Medical Shop Management A Project Report: Submitted by
Medical Shop Management A Project Report: Submitted by
A PROJECT REPORT
Submitted by
YUVARAJ V
(REGISTER NO:112418621343)
of
SRI VENKATESWARA COLLEGE OF ENGINEERING AND TECHNOLOGY
A PROJECT REPORT
Submitted to the
ANNA UNIVERSITY
MAY- 2021
i
BONAFIDE CERTIFICATE
My sincere thanks to all the teaching and non-teaching members of the Department of
YUVARAJ V
ABSTRACT
ABSTRACT v
1 INTRODUCTION 1
2 SYSTEM ANALYSIS 2
2.1 EXISTING SYSTEM 2
2.3 FEASIBILITY STUDY 3
2.3.1 TECHNICAL FEASIBILITY 3
2.3.2 ECONOMIC FEASIBILITY 3
3 SYSTEM DESIGN 9
3.1 INPUT DESIGN 9
4 SYSTEM TESTING 14
5 CONCLUSION 16
SAMPLE SCREENSHOTS 30
6 REFERENCES 34
BOOK REFERENCES 34
WEB REFERENCES 34
CHAPTER 1
INTRODUCTION
The Project on Medical Shop Management System is to manage the details of Sells,
Medicines, Stocks, Company, billing. It manages all the information about Sells, Medical
Shop, Inventory, Sells. The project is totally built at administrative end and thus only the
administrator is guaranteed the access. The purpose of the project is to build an application
program to reduce the manual work for managing the Sells, Medicines, Medical Shop,
Stocks. It tracks all the details about the Stocks, Company, Inventory.
The main objective of the application is to automate the existing system of manually
maintained records of the counter sales, purchases, reorder levels, Supplier and Customer
monetary positions and other related transactions made by the seller.
This application can be used by any other store to automate the process of manually
maintaining the records related to the subject of maintaining the stock and liquid flows.
The main goal of this project is that managing the medicine details, stock details and billing details
very clearly. The project is aimed to develop by PHP as Front end and SQL as Back end.
CHAPTER 2
SYSTEM ANALYSIS
Currently, the medical works are based on the manual process, and each work is maintained in
the paper. The details of purchasing drugs, audits, sell reports maintained on the paper while anyone
can enter into the system and can make changes in these reports, so it is not a safe method to keep the
information on the paper. The pharmacist faces problem in searching the products from the self as it is
not an easy method to remember about the place of each medicine. There no Pharmacy Management
System which can alert the pharmacist about the end of the drugs.
Disadvantages:
1. Can’t able to handle stock details
2. More number of resources can be handling single medical shop
3. It’s not user friendly for the customer
4. Customer need to wait long time for getting billing report.
The design of the medical shop management system is based on the computer which will
simplify the maintenance of the information, accessible and efficient. The Pharmacy Management
System will provide the information about the end of the drugs in the medical so that the physician
can order them drugs before the end. The pharmacist and nurses will get more accurate results at the
time sell, about the details of the use of medicines and the dosages so that the system will become
more reliable to use than the present system. The records of each work will be secure as to access the
information the user must have to provide the ID and password in the system.
Advantages:
1. Systematically provide all the details up-to-date.
2. Easily find the daily billing details
3. We can collect the all-customer details in single applicationapplication.
9
2.3 FEASIBILITY STUDY
The feasibility of the system is analyzed in this phase and business proposal is put
forth with general plan for the project and cost estimates. During the system analysis of the
project, the feasibility study of proposed system is to be carried out. For feasibility analysis,
some understanding of the major requirements for the system is essential. Three key
considerations involved in feasibility analysis are
Technical Feasibility
Economic Feasibility
Operational Feasibility
The technical requirements of the application are simple and basic. Python is used
for the developers of the application and the framework is largely used by many, thus there
will be enough support for future enhancements. The framework is stable and the support
from the developers is constantly updated. The devices which have internet connectivity are
enough for the application.
The orders from public are submitted through email, letter or form to the
corresponding authority. The registered orders are forwarded to corresponding authority and
report about the orders is submitted. The status of orders addressed is not recorded and
maintained properly. The maps are not implemented. So, the customer does not know live
location of the package. There is need for the software which receives the orders through
online, forwarded to respective peoples for rectification and post the status of orders.
2.5 CONTEXT AND DATA FLOWDIAGRAM
LEVEL 0:
LEVEL:1
2.6 SYSTEM CONFIGURATION
Java
MySQL
MySQL was owned and sponsored by the single for-profit firm, the Swedish
company MySQL AB, now owned by Oracle Corporation. For proprietary use, several
paid editions are available, and offer additional functionality.
CHAPTER 3
SYSTEM DESIGN
The most important consideration in designing the database is how the information
will be used. The main objective of designing a database is Data Integration, Data Integrity
and Data Independence.
Data Integration
Data integrity means storing all data in one place only and how each application
access it. This approach results in more consistent information, one update being sufficient
to achieve a new record status for all applications. This leads to less data redundancy, that is
data items need not be duplicated. A reduction in the direct access storage requirement.
Data Independence
Dataindependenceistheinsulationofapplicationprogramsfromchangingaspects of
physical data organization. This objective seeks to allow changes in the content and
organizationofphysicaldatawithoutreprogrammingofapplicationandallowmodifications to
application programs without reorganizing the physical data.
3.2.1 TABLE DESIGN
The table needed for each module were designed and the specification of each and
every column was given based on the records and details collected during record
specification of the system study.
Admin
Manager
Cashier
Billing details
Medicine details
1. Admin
This module has access to create manager, only admin can able to create manager. The
admin collects the managers details register manager entry. Once the manager has created, he gave
access to login.
2. Manager
This module manager can create the cashier account, once cashier has created, he/she can
able to login and register entry for billing details. The manager create account as well as for
pharmacist.
3. Cashier
The cashier entered into the login and promote the billing. The main work for the cashier is for
check the medicine and generate the bill and collect money.
4. Billing details
This module will show the all the billing details as a date wise, once the cashier collects the
money and generate the bill it has to be shown in billing module. Manager or cashier can check the
billing details for a date wise.
5. Medicine details
A Manager or admin registered the medicine details, it’s collected all the information about
the medicine. Displayed the medicine details in the cashier dashboard.
CHAPTER 4
SYSTEM TESTING
The first step in system testing is to develop a plan that tests all aspects of
the system. Completeness, correctness, reliability and maintainability of the software
are to be tested for the best quality assurance that the system meets the specification
and requirements for its intended use and performance. System testing is the most
useful practical process of executing a program with the implicit intention of finding
errors that make the program fails. System testing is done in three phases.
Unit Testing
Integration Testing
Validation Testing
Unit testing focuses verification effort on the smallest unit of software the
module. Using the detailed design and the process specification testing is done to
registration by the user with in the boundary of the Login module. The login form
receives the username and password details and validates the value with the database.
If valid, the home page is displayed.
4.2 INTEGRATION TESTING
Validation are independent procedures that are used together for checking
that a product, service, or system meets requirements and specifications and that it
fulfills its in purpose the actual result from the expected result for the complaint process.
Select the complaint category of the complaint by user. The input given to various forms
fields are validated effectively. Each module is tested independently. It is tested that the
complaint module fields receive the correct input for the necessary details such as
complaint category, complaint id, reference name, complaint description, email for
further process.
CHAPTER 5
5.1 CONCLUSION
It gives a lot of details about the stock sell. In short, it is a medical inventory that has
made lives easier. This software is called the Medical store management system. It
provides every small to big details like customer details, employees details, sell details, bill
details, etc.
APPENDICES
APPENDIX I
SAMPLE CODE
<?php
session_start();
$sessionId = $_SESSION['id'] ?? '';
$sessionRole = $_SESSION['role'] ?? '';
echo "$sessionId $sessionRole";
if ( !$sessionId && !$sessionRole ) {
header( "location:login.php" );
die();
}
ob_start();
include_once "config.php";
$connection = mysqli_connect( DB_HOST, DB_USER, DB_PASSWORD, DB_NAME
); if ( !$connection ) {
echo mysqli_error( $connection );
throw new Exception( "Database cannot Connect" );
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=1024">
<body>
<! Secondary Navber >
<section class="topber">
<div class="topber title">
<span class="topber__title--text">
<?php
if ( 'dashboard' == $id )
{ echo "DashBoard";
} elseif ( 'addManager' == $id )
{ echo "Add Manager";
} elseif ( 'allManager' == $id )
{ echo "Managers";
} elseif ( 'addPharmacist' == $id ) {
echo "Add Pharmacist";
} elseif ( 'allPharmacist' == $id ) {
echo "Pharmacists";
} elseif ( 'addSalesman' == $id )
{ echo "Cashier";
} elseif ( 'allSalesman' == $id )
{ echo "Cashiers";
} elseif ( 'userProfile' == $id )
{ echo "Your Profile";
} elseif ( 'editManager' == $action ) {
echo "Edit Manager";
} elseif ( 'editPharmacist' == $action ) {
echo "Edit Pharmacist";
} elseif ( 'editSalesman' == $action )
{ echo "Edit Salesman";
}elseif ( 'addmedicine' == $action )
{ echo "Add Medicine";
}
elseif ( 'billing' == $action ) {
echo "Billing";
}
?>
</span>
</div>
</section>
<! #Sideber - >
</div>
<?php }?>
<?php if ( 'dashboard' == $id ) {?>
<div class="dashboard p-5">
<div class="total">
<div class="row">
<div class="col-3">
<div class="total box text-center">
<h1>2453</h1>
<h2>Total Sell</h2>
</div>
</div>
<div class="col-3">
<div class="total box text-center">
<h1>
<?php
$query = "SELECT COUNT(*) totalManager FROM managers;";
$result = mysqli_query( $connection, $query );
$totalManager = mysqli_fetch_assoc( $result );
echo $totalManager['totalManager'];
?>
</h1>
<h2>Manager</h2>
</div>
</div>
<div class="col-3">
<div class="total box text-center">
<h1>
<?php
$query = "SELECT COUNT(*) totalPharmacist FROM pharmacists;";
$result = mysqli_query( $connection, $query );
$totalPharmacist = mysqli_fetch_assoc( $result );
echo $totalPharmacist['totalPharmacist'];
?>
</h1>
<h2>Pharmacist</h2>
</div>
</div>
<div class="col-3">
<div class="total box text-center">
<h1><?php
$query = "SELECT COUNT(*) totalSalesman FROM salesmans;";
$result = mysqli_query( $connection, $query );
$totalSalesman = mysqli_fetch_assoc( $result );
echo $totalSalesman['totalSalesman'];
?></h1>
<h2>Salesman</h2>
</div>
</div>
</div>
</div>
</div>
<?php }?>
<! DashBoard >
<?php
$getManagers = "SELECT * FROM managers";
$result = mysqli_query( $connection, $getManagers );
<tr>
<td>
<center><img class="rounded-circle" width="40"
height="40" src="assets/img/<?php echo $manager['avatar']; ?>" alt=""></center>
</td>
<td><?php printf( "%s %s", $manager['fname'], $manager['lname'] );?></td>
<td><?php printf( "%s", $manager['email'] );?></td>
<td><?php printf( "%s", $manager['phone'] );?></td>
<?php if ( 'admin' == $sessionRole ) {?>
<!-- Only For Admin -->
<td><?php printf( "<a href='index.php?action=editManager&id=
%s'><i class='fas fa-edit'></i></a>", $manager['id'] )?></td>
<td><?php printf( "<a class='delete' href='index.php?action=deleteManager&id=
%s'><i class='fas fa-trash'></i></a>", $manager['id'] )?></td>
<?php }?>
</tr>
<?php }?>
</tbody>
</table>
</div>
</div>
<?php }?>
</div>
<?php }?>
scope="col">STOCK</th>
</tr>
</thead>
<tbody>
<?php
$getManagers = "SELECT * FROM managers";
$result = mysqli_query( $connection, $getManagers );
<tr>
<td>
<center><img class="rounded-circle" width="40"
height="40" src="assets/img/<?php echo $manager['avatar']; ?>" alt=""></center>
</td>
<td><?php printf( "%s %s", $manager['fname'], $manager['lname'] );?></td>
<td><?php printf( "%s", $manager['email'] );?></td>
<td><?php printf( "%s", $manager['phone'] );?></td>
</tr>
<?php }?>
</tbody>
</table>
</div>
</div>
<?php }?>
APPENDIX II
SAMPLE SCREENSHOTS
REFERENCES
BOOK REFERENCES
1. Jeff Forcier, Paul Bissex, Wesley J. Chun, (2018) “Python Web development with
Django (Developer’s Library)”, WesleyProfessional.
2. Roger S. Pressman, (2017) “Software Engineering”, Tata McGraw-Hill –Europe.
WEB REFERENCES
1. https://www.javaprogramming.net
2. https://www.w3schools.com
3. https://www.tutorialspoint.com