INDEX
[Link] overview of the project
[Link] of computerisation
[Link] and hardware requirement
[Link] of the project
[Link] source code
[Link] Database
[Link] screens
[Link]
FOOD MANAGEMENT
SYSTEM
BRIEF OVERVIEW OF PROJECT
The main objective of the python project on
food management system is to manage the
details of booking ,menu,payment,and order.
The project is totally built to administive end
only administrator.
Is guaranteed the access. The purpose of the
project is o built an application program to
reduce the manual work for managing the
booking,discounts,and payments.
It tracks all the details about menu,discount
and payment; it also prints various report as
per input given by the user.
INPUT DATA AND VALIDATION OF
PROJECT
[Link] the fields such as order payments discounts are
validated and does not take invalid values.
[Link] form of sales,discount,booking cannot accept
the blank values.
[Link] errors in data
[Link] amount of input.
NEED OF COMPUTERISATION
Over the decades computers and food bookings
have developed gradually, changed with time.
But nobody knew that a time will come when
both these fields will complement each other
well. Today food booking has reached new
heights by computer aided methods of design. As
a result of which, computer industry has got its
new customer. Computer technology is making
waves in the food booking zone.
Computers are a vital component of the food
booking counters. Computer aided design (CAD)
programs reduce the demand for manual
sketches. New software programs continue to
replace old manual skills. Those who lag in math
can now breathe a little easier. Manually figuring
of food insists that knowledge.
Software programs constantly evolve. A program
used today may be obsolete within several years.
Being trained on today's software does not
guarantee it will be used when you are ready to
go out into the field. Understanding calculations
is timeless, as is computer competency. Software,
however, shifts rapidly.
SOFTWARE AND
HARDWARD REQUIRMENT
HARDWARE
[Link] computer/ Laptop
[Link] Phone
SOFTWARE
[Link]
[Link]
[Link] connector module
ADVANTAGES OF THE
PROJECT
1. It generates the report on sales, discounts
and menu.
2. Provides filter report on payments and
food booking.
3. We can easily export PDF on sales,
products and stocks.
4. Applications can also provide excel export
for bookings and discounts.
5. It deals with monitoring the information
and transaction of food bookings.
6. It increases the efficiency of food booking
and discount.
7. It has higher efficiency of editing, adding
and updating of records.
8. Provides the searching facilities on
various factors.
PYTHON
CODE
SOURCE
import [Link]
import os, platform
# Connection to Database
mydb = [Link](
host="localhost",
user="root",
password="monish2009",
database="Monish"
)
mycursor = [Link]()
# ---------------- Customer ----------------
def Customer():
L=[]
c_id=int(input("Enter Customer ID: "))
[Link](c_id)
name=input("Enter Customer Name: ")
[Link](name)
cphone=input("Enter Customer Phone: ")
[Link](cphone)
payment=input("Enter Payment Method
(Credit/Debit): ")
[Link](payment)
pstatus=input("Enter Payment Status
(Paid/Unpaid): ")
[Link](pstatus)
email=input("Enter Email: ")
[Link](email)
orderid=input("Enter Order ID: ")
[Link](orderid)
date=input("Enter Date (YYYY-MM-DD): ")
[Link](date)
sql="INSERT INTO Customer
(C_id,cname,cphone,payment,pstatus,email,orderid,date
)VALUES (%s,%s,%s,%s,%s,%s,%s,%s)"
[Link](sql, L)
[Link]()
print("Customer Added Successfully")
# ---------------- Employee ----------------
def Employee():
L=[]
Emp_id=int(input("Enter Employee ID: "))
[Link](Emp_id)
ename=input("Enter Employee Name: ")
[Link](ename)
emp_g=input("Enter Gender: ")
[Link](emp_g)
eage=int(input("Enter Age: "))
[Link](eage)
emp_phone=input("Enter Phone: ")
[Link](emp_phone)
pwd=input("Enter Password: ")
[Link](pwd)
sql="INSERT INTO Employee
(Emp_id,ename,emp_g,eage,emp_phone,pwd) VALUES (%s,
%s,%s,%s,%s,%s)"
[Link](sql,L)
[Link]()
print("Employee Added Successfully")
# ---------------- Food ----------------
def food():
L=[]
food_id=int(input("Enter food ID: "))
[Link](food_id)
foodname=input("Enter food Name: ")
[Link](foodname)
food_size=input("Enter food Size: ")
[Link](food_size)
prize=int(input("Enter Price: "))
[Link](prize)
sql="INSERT INTO Food
(food_id,foodname,food_size,prize) VALUES (%s,%s,%s,
%s)"
[Link](sql,L)
[Link]()
print("Food Added Successfully")
# ---------------- OrderFood ----------------
def OrderFood():
L=[]
OrderF_id=int(input("Enter Order ID: "))
[Link](OrderF_id)
C_id=int(input("Enter Customer ID: "))
[Link](C_id)
Emp_id=int(input("Enter Employee ID: "))
[Link](Emp_id)
Food_id=int(input("Enter Food ID: "))
[Link](Food_id)
Food_qty=int(input("Enter Quantity: "))
[Link](Food_qty)
Total_price=int(input("Enter Total Price: "))
[Link](Total_price)
sql="INSERT INTO OrderFood
(OrderF_id,C_id,Emp_id,Food_id,Food_qty,Total_price)
VALUES (%s,%s,%s,%s,%s,%s)"
[Link](sql,L)
[Link]()
print("Order Placed Successfully")
# ---------------- View ----------------
def View():
print("1. Employee")
print("2. Customer")
print("3. food")
print("4. Orders")
ch=int(input("Enter Choice: "))
if ch==1:
[Link]("SELECT * FROM Employee")
elif ch==2:
[Link]("SELECT * FROM Customer")
elif ch==3:
[Link]("SELECT * FROM food")
elif ch==4:
[Link]("SELECT * FROM OrderFood")
else:
print("Invalid Choice")
return
res=[Link]()
for row in res:
print(row)
# ---------------- Menu ----------------
def MenuSet():
print("\n------ FOOD MANAGEMENT SYSTEM ------")
print("1. Add Employee")
print("2. Add Customer")
print("3. Add Food")
print("4. Place Order")
print("5. View Records")
choice=int(input("Enter Your Choice: "))
if choice==1:
Employee()
elif choice==2:
Customer()
elif choice==3:
food()
elif choice==4:
OrderFood()
elif choice==5:
View()
else:
print("Invalid Choice")
def runAgain():
ch=input("\nDo You Want To Run Again? (y/n): ")
while [Link]()=="y":
if [Link]()=="Windows":
[Link]("cls")
else:
[Link]("clear")
MenuSet()
ch=input("\nDo You Want To Run Again? (y/n):
")
print("Good Bye... Have a Nice Day!")
# Main Program
MenuSet()
runAgain()
MYSQL
DATABAS
E
FOOD MANAGEMENT
SYSTEM
CUSTOMER
TABLE
EMPLOYEE
TABLE
FOOD TABLE
ORDERFOOD
TABLE
OUTPU
T
REFERENC
ES
[Link]://[Link],com/
[Link]://[Link]
[Link]://[Link]
4. class 11th and 12th computer science books