Electronic Shop Management Project
Electronic Shop Management Project
Electronic Shop Management Project
01 ACKNOWLEDGEMENT 04
02 INTRODUCTION 05
04 PROPOSED SYSTEM 06
07 FLOW CHART 15
08 SOURCE CODE 16
09 OUTPUT 19
10 TESTING 20
12 BIBLIOGRAPHY 24
ACKNOWLEDGEMENT
1
Apart from the efforts of me, the success of any project depends largely on
the encouragement and guidelines of many others. I take this opportunity to express
my gratitude to the people who have been instrumental in the successful completion
of this project.
I express deep sense of gratitude to almighty God for giving me strength for
the successful completion of the project.
I shall fail in my duty if I didn’t thank Ms. Smitha Balakrishnan, Project In-
charge, A guide, Mentor all the above a friend, who critically reviewed my project
and helped in solving each and every problem, occurred during implementation of
the project
The guidance and support received from all the members who contributed
and who are contributing to this project, was vital for the success of the project. I am
grateful for their constant support and help.
2
PROJECT ON ELECTRONIC SHOP MANAGEMENT
INTRODUCTION
this programme consists a user name login & employee name and login .
there are certain amount products which are kept as a basic products. The user can
login themselves and start buying the products, whereas the shop owner can
The objective of this project is to let the students apply the programming
knowledge into a real- world situation/problem and exposed the students how
3
PROPOSED SYSTEM
Today one cannot afford to rely on the fallible human beings of be really
wants to stand against today’s merciless competition where not to wise saying “to
err is human” no longer valid, it’s out-dated to rationalize your mistake. So, to keep
pace with time, to bring about the best result without malfunctioning and greater
One has to use the data management software. Software has been an ascent
markets, which have helped in making the organizations work easier and efficiently.
Data management initially had to maintain a lot of ledgers and a lot of paperwork has
to be done but now software production this organization has made their work faster
and easier. Now only this software has to be loaded on the computer and work can
be done.
This prevents a lot of time and money. The work becomes fully automated
and any information regarding the organization can be obtained by clicking the
4
SOURCE CODE
import datetime
conn=sql.connect(host='localhost',user='root',passwd='manager'
,database='electronics')
#if conn.is_connected():
# print("Successfully Connected")
c1=conn.cursor()
t_date=datetime.date.today()
t_time=datetime.datetime.now()
print("DATE:",t_date.day,"/",t_date.month,"/",t_date.year,"TIM
E:",t_time.hour ,":",t_time.minute )
print('1.YES')
print('2.NO')
if ch==1:
System')
print('1.SIGN IN')
print('3.DELETE ACCOUNT')
print('4.VIEW DETAILS')
print('5.EXIT')
5
ch1=int(input('ENTER YOUR CHOICE:'))
if ch1==1:
System")
print("2.USER LOGIN")
print("3.EXIT")
choice=int(input("ENTER UR CHOICE:"))
if choice==1:
f=[]
if passw==paas:
dat=c1.fetchall()
hi=list(dat)
if hi==f:
else:
import purchase
elif choice==2:
6
k=[]
if p1==p2:
dat1=c1.fetchall()
hi1=list(dat1)
if hi1==k:
print('1.YES')
print('2.NO')
NOT:'))
if c8==1:
import elecshop
else:
print("Thank you")
print("=======================================================
=======================")
else:
7
import purchase
elif choice==3:
print("Thank you")
print("=======================================================
=======================")
else:
print("Invalid choice")
print("=======================================================
=======================")
elif ch1==2:
print("1.USER ACCOUNT")
print("2.EMPLOYEE ACCCOUNT")
print("3.EXIT")
if ch2==1:
x=[]
print("DATE:",t_date.day,"/",t_date.month,"/",t_date.year,"TIM
E:",t_time.hour ,":",t_time.minute )
8
u=int(input("ENTER A USER CODE:"))
user_code="+str(u))
hat=c1.fetchall()
h2=list(hat)
if h2!=x:
print('1.YES')
print('2.NO')
NOT:'))
if c8==1:
import elecshop
else:
print("Thank you")
print("=======================================================
=======================")
else:
9
pse=int(input("ENTER A PASSWORD(in 8
digits):"))
password="+str(pse))
dat=c1.fetchall()
h1=list(dat)
if h1!=x:
print('1.YES')
print('2.NO')
NOT:'))
if c9==1:
import elecshop
elif c9==2:
print("Thank you")
print("=======================================================
=======================")
else:
print("Invalid choice")
10
print("=======================================================
=======================")
else:
numbers):"))
if pse==ps2:
values({},'{}',{},'{}',{})".format(u,n,pse,c,z))
conn.commit()
SUCCESSFULLY")
print('1.YES')
print('2.NO')
OR NOT:'))
if c0==1:
import elecshop
elif c0==2:
print("Thank you")
print("=======================================================
=======================")
11
else:
print("Invalid choice")
print("=======================================================
=======================")
if ch2==2:
pur=0
fd=[]
print("DATE:",t_date.day,"/",t_date.month,"/",t_date.year,"TIM
E:",t_time.hour ,":",t_time.minute )
we=input("ENTER PASSWORD:")
if we=='vijay':
digits):"))
emp_code="+str(cd))
hat=c1.fetchall()
h3=list(hat)
if h3!=fd:
print('1.YES')
print('2.NO')
12
c10=int(input('DO YOU WANT TO CONTINUE OR
NOT:'))
if c10==1:
import elecshop
elif c10==2:
print("Thank you")
print("=======================================================
=======================")
else:
print("Invalid choice")
print("=======================================================
=======================")
else:
pre=int(input("ENTER A PASSWORD(in 8
digits):"))
password="+str(pre))
13
dat=c1.fetchall()
h6=list(dat)
if h6!=fd:
print('1.YES')
print('2.NO')
NOT:'))
if c76==1:
import elecshop
elif c76==2:
print("Thank you")
print("=======================================================
=======================")
else:
print("Invalid choice")
print("=======================================================
=======================")
else:
14
ps4=int(input("REENTER YOUR PASSWORD(in
numbers):"))
if pre==ps4:
values({},'{}',{},{})".format(cd,r,pre,pur))
conn.commit()
SUCCESSFULLY")
print('1.YES')
print('2.NO')
OR NOT:'))
if c0==1:
import elecshop
elif c0==2:
print("Thank you")
print("=======================================================
=======================")
else:
print("Invalid choice")
15
print("=======================================================
=======================")
elif ch1==3:
print("1.USER ACCOUNT")
print("2.EMPLOYEE ACCCOUNT")
print("3.EXIT")
if ch71==1:
DELETED:"))
c1.execute("select user_code,user_name,city,ph_no
data=c1.fetchall()
print(" USER_CODE:",row[0])
print(" USER_NAME:",row[1])
print(" CITY:",row[2])
print(" PHONE_NO:",row[3])
conn.commit()
print("1.YES")
print("2.NO")
if chi8==1:
16
c1.execute("delete from users where
user_code={}".format(de))
SUCCESSFULLY")
conn.commit()
elif chi8==2:
print("THANK YOU")
print("=======================================================
================")
else:
print("INVALID CHOICE")
print("THANK YOU")
print("=======================================================
==================")
elif ch71==2:
DELETED:"))
where emp_code="+str(da))
data2=c1.fetchall()
print(" EMPLOYEE_CODE:",row[0])
17
print(" EMPLOYEE_NAME:",row[1])
conn.commit()
print("1.YES")
print("2.NO")
if chi8==1:
emp_code={}".format(da))
SUCCESSFULLY")
conn.commit()
elif chi8==2:
print("THANK YOU")
print("=======================================================
================")
else:
print("INVALID CHOICE")
print("THANK YOU")
print("=======================================================
==================")
elif ch1==4:
print("1.USER DETAILS")
18
print("2.EMPLOYEE DETAILS")
print("3.EXIT")
if che34==1:
TO BE DISPLAYED:"))
c1.execute("select user_code,user_name,city,ph_no
dare=c1.fetchall()
print(" CITY:",row[2])
print(" PHONE_NO:",row[3])
elif che34==2:
DETAILS TO BE DISPLAYED:"))
c1.execute("select emp_code,user_name,purchased
dare2=c1.fetchall()
print(" PURCHASED:",row[2])
19
elif che34==3:
print("THANK YOU")
print("=======================================================
============================")
else:
print("INVALID CHOICE")
print("=======================================================
======================")
elif ch1==5:
print("THANK YOU")
ELECTRONICS SHOP")
print("=======================================================
======================")
else:
print("INVALID CHOICE")
ELECTRONICS SHOP")
20
print("=======================================================
======================")
elif ch==2:
print("Thank you")
print("=======================================================
=======================")
else:
print("INVALID CHOICE")
ELECTRONICS SHOP")
print("=======================================================
======================")
21
OUTPUT
# welcome page
22
#creating account
#delete account
#view details
23
#sign in
24
HARDWARE AND SOFTWARE REQUIREMENTS
25
VII. FLOPPY DRIVE 1.44 MB : (If Backup required)
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python
INSTALLATION PROCESS
26
6. For further more details on how to use our
software, please read “Project - Class 11 –
electronic shop management”.
27
BIBLIOGRAPHY
***
28