import mysql.
connector
DB=mysql.connector.connect(host="localhost",
user="root",
password="diya",
database="gadget_store" )
C=DB.cursor()
def ADDGADGETS():
pname=str(input("ENTER PRODUCT NAME:"))
pid=input("ENTER PRODUCT ID:")
Qty=int(input("ENTER QUANTITY:"))
brand=input("ENTER BRAND NAME:")
catagory=input("ENTER PRODUCT CATAGORY :")
cost=int(input("ENTER PRICE:"))
C.execute("INSERT INTO available_gadget values('{}','{}',{},'{}','{}',{})".format(pname,pid,Qty,brand,catagory,cost))
DB.commit()
print("""
===================================================[ SUCCESSFULLY ADDED ]========================================================""")
n = int(input("""
Do You Want To Continue <YES:1 or NO:2> :"""))
if n == 1:
ADDGADGETS()
if n == 2:
STAFF()
def NEWSTAFF():
ID=input('ENTER STAFF ID')
fname=str(input("ENTER STAFF NAME:"))
gender=str(input("ENTER GENDER(M/F):"))
age=int(input("ENTER AGE:"))
phno=int(input("ENTER STAFF PHONE NUMBER.:"))
add=str(input("ENTER ADDRESS:"))
C.execute(("INSERT INTO EMPLOYEE_DETAILS values('{}','{}','{}',{},{},'{}')".format(ID,fname,gender,age,phno,add)))
DB.commit()
print("""===================================================[ SUCCESSFULLY ADDED ]========================================================""")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
NEWSTAFF()
if n==2:
STAFF()
def REMOVESTAFF():
n=(input("ENTER STAFF NAME TO BE REMOVED: "))
C.execute("DELETE FROM EMPLOYEE_DETAILS WHERE fName=('{}') ".format(n))
DB.commit()
print("""===================================================[ """,n,""" IS FIRED ]========================================================""")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
REMOVESTAFF()
if n==2:
STAFF()
def STAFFDETAIL():
s= "Select * from EMPLOYEE_DETAILS"
C.execute(s)
output =C.fetchall()
for x in output:
print("************************************")
print("ID :",x[0])
print("NAME :", x[1])
print("GENDER :", x[2])
print("AGE:", x[3])
print("PHONE NUMBER:", x[4])
print("ADDRESS:", x[5])
print("************************************")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
STAFFDETAIL()
if n==2:
STAFF()
def SALESREC():
C.execute("select * from SALES_REC")
for u in C:
print("*********************************************")
print("BUYER NAME: ",u[1])
print("MOBILE NUMBER: ",u[2])
print("PRODUCT PURCHASED: ",u[3])
print("QUANTITY PURCHASED: ",u[5])
print("TOTAL PRICE AMOUNT =: ",u[4])
print("**********************************************")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
SALESREC()
if n==2:
STAFF()
def RESET():
P=input("Are you sure(Y/N):").upper()
if P=="Y":
C.execute("delete from SALES_REC")
DB.commit()
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
RESET()
if n==2:
STAFF()
def TOTAL_INCOME():
C.execute("select sum(price) from SALES_REC")
for x in C:
print("TOTAL INCOME TILL DATE",x)
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
TOTAL_INCOME()
if n==2:
STAFF()
def AVAILABLEPROD():
C.execute("select * from available_gadget order by pname")
for v in C:
print("****************************************************")
print("PRODUCT NAME: ",v[0])
print("PRODUCT ID: ",v[1])
print("PRODUCT QUANTITY: ",v[2])
print("PRODUCT BRAND: ",v[3])
print("PRODUCT CATEGORY: ",v[4])
print("PRODUCT PRICE: ", v[5])
print("****************************************************")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
AVAILABLEPROD()
if n==2:
STAFF()
def CUSTOMER_DETAILS():
C.execute("select * from signup_details")
for u in C:
print("*********************************************")
print("CUSTOMER USERNAME: ",u[0])
print("CUSTOMER NAME: ",u[1])
print("PASSWORD: ",u[2])
print("PHONE NUMBER: ",u[3])
print("MAIL ID: ",u[4])
print("**********************************************")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
CUSTOMER_DETAILS()
if n==2:
STAFF()
def VIEW_FEEDBACKS():
z = "SELECT name, feedback FROM feedbacks"
C.execute(z)
feedbacks = C.fetchall()
if feedbacks:
print("""=================================================[Customer Feedbacks]==================================================""")
for i in feedbacks:
print("Name:", i[0], "\nFeedback:", i[1], "\n")
else:
print("No Feedbacks Found")
#***************************************BUYER FUNCTION********************************************#
def AVAILABLE_PROD():
C.execute("select * from available_gadget order by pname")
for v in C:
print("****************************************************")
print("PRODUCT NAME: ",v[0])
print("PRODUCT ID: ",v[1])
print("PRODUCT QUANTITY: ",v[2])
print("PRODUCT BRAND: ",v[3])
print("PRODUCT CATEGORY: ",v[4])
print("PRODUCT PRICE: ", v[5])
print("****************************************************")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n==1:
AVAILABLE_PROD()
if n==2:
BUYER()
def PURCHASE():
C.execute("SELECT * FROM available_gadget")
for i in C.fetchall():
print("****************************************************")
print("PRODUCT NAME: ", i[0])
print("PRODUCT ID: ", i[1])
print("PRODUCT QUANTITY: ", i[2])
print("PRODUCT BRAND: ", i[3])
print("PRODUCT CATEGORY: ", i[4])
print("PRODUCT PRICE: ", i[5])
print("****************************************************")
customer_name = input("ENTER CUSTOMER NAME: ")
phone_number = input("ENTER PHONE NUMBER: ")
product_name = input("ENTER PRODUCT NAME: ")
quantity = int(input("ENTER QUANTITY: "))
C.execute("SELECT Qty, cost FROM available_gadget WHERE pname = '{}'".format(product_name))
product_info = C.fetchone()
if product_info is not None:
available_quantity, unit_price = product_info
if available_quantity < quantity:
print(quantity, "PRODUCTS NOT AVAILABLE CURRENTLY!!!!")
else:
price = unit_price * quantity
C.execute("""INSERT INTO Sales_rec (customer_name, phone_number, product_name, price, quantity)
VALUES ('{}', {}, '{}', {}, {})""".format(customer_name, phone_number, product_name, price, quantity))
C.execute("""UPDATE available_gadget SET Qty = Qty - {} WHERE pname = '{}'""".format(quantity, product_name))
DB.commit()
print("""
==========================================================[ORDER IS PLACED SUCESSFULLY]========================================================
""")
else:
print("PRODUCT NOT AVAILABLE!!!!!!!")
n=int(input("""
Do You Want To Continue <YES:1 or NO:2> :""" ))
if n == 1:
PURCHASE()
if n == 2:
BUYER()
def SEARCHPRODUCT():
k = int(input("""
NAME: 1
BRAND: 2
CATEGORY: 3
COST: 4
---------------------------------
SEARCH BY: """))
# Ensure to compare input with string instead of integer
if k == 1:
o = input("ENTER PRODUCT NAME TO BE SEARCHED: ")
C.execute("SELECT * FROM available_gadget WHERE pname = '''+o+''' ")
t = C.fetchall()
if t != None:
print("""==============================================================[PRODUCT IN STOCK]================================================================"""
else:
print("""==============================================================[PRODUCT NOT IN STOCK]================================================================"
# Add additional branches for other search types
elif k == 2:
# Implement brand search
o = input("ENTER BRAND TO BE SEARCHED: ")
C.execute("SELECT * FROM available_gadget WHERE brand = '''+o+''' ")
t = C.fetchall()
if t is not None:
print("""==============================================================[PRODUCT IN STOCK]================================================================"""
else:
print("""==============================================================[PRODUCT NOT IN STOCK]================================================================"
elif k == 3:
# Implement category search
o = input("ENTER CATEGORY TO BE SEARCHED: ")
C.execute("SELECT * FROM available_gadget WHERE category = '''+o+''' ")
t = C.fetchall()
if t is not None:
print("""==============================================================[PRODUCT IN STOCK]================================================================"""
else:
print("""==============================================================[PRODUCT NOT IN STOCK]================================================================"
elif k == 4:
# Implement cost search
o = input("ENTER COST TO BE SEARCHED: ")
C.execute("SELECT * FROM available_gadget WHERE cost ='''+o+''' ")
t = C.fetchall()
if t is not None:
print("""==============================================================[PRODUCT IN STOCK]================================================================"""
n=int(input("""Want To Continue: Yes: 1 NO: 2 OPTION: """ ))
if n==1:
SEARCHPRODUCT()
if n==2:
BUYER()
def WRITE_FEEDBACK():
# Get user input
name = input("ENTER NAME: ")
feedback = input("ENTER YOUR FEEDBACK: ")
y = "INSERT INTO feedbacks (name, feedback) VALUES (%s, %s)"
C.execute(y, (name, feedback))
print("THANKS FOR YOUR FEEDBACK")
#************************************MAIN PROGRAM************************************#
def STAFF():
print("""
1:ADD PRODUCT
2.STAFF DETAIL
3.SALES RECORD
4.TOTAL INCOME
5.SEE AVAILABLE PRODUCTS
6.CUSTOMER DETAILS
7.VIEW CUSTOMER FEEDBACKS
8.EXIT""")
n=int(input("ENTER YOUR CHOICE: "))
if n==1:
ADDGADGETS()
if n==2:
print("""
1:New staff entry
2:Remove staff
3:view staff details""")
ch=int(input("ENTER YOUR CHOICE: "))
if ch==1:
NEWSTAFF()
if ch==2:
REMOVESTAFF()
if ch==3:
STAFFDETAIL()
if n==3:
print("""
1:SALES history details
2:Reset SALES history""")
t=int(input("Enter your choice:"))
if t==1:
SALESREC()
if t==2:
RESET()
if n==4:
TOTAL_INCOME()
if n==5:
AVAILABLEPROD()
if n==6:
CUSTOMER_DETAILS()
if n==7:
VIEW_FEEDBACKS()
if n==8:
return
def BUYER():
print("""
1.TO PURCHASE PRODUCT
2.TO SEARCH PRODUCT
3.TO VIEW AVAILABLE PRODUCTS
4.WRITE FEEDBACK
5.EXIT""")
r=int(input("ENTER YOUR CHOICE: "))
if r==1:
PURCHASE()
if r==2:
SEARCHPRODUCT()
if r==3:
AVAILABLE_PROD()
if r==4:
WRITE_FEEDBACK()
if r==5:
return
#MAIN PROGRAM
print(r"""
______ _______ ______ _____ _ _ __ __
|___ / |__ __| | ____| / ____| | | | | \ \ / /
/ / ______ | | | |__ | | | |__| | \ V /
/ / |______| | | | __| | | | __ | > <
/ /__ | | | |____ | |____ | | | | / . \
/_____| |_| |______| \_____| |_| |_| /_/ \_\
""")
while True:
a=int(input("""
======================================================[ ENTER AS ADMIN: 1 ]======================================================
======================================================[ ENTER AS USER: 2 ]======================================================
======================================================[ EXIT: 3 ]======================================================
Enter Choice : """ ))
if a==1:
b=input("ENTER PASSWORD :")
c="Z-TECHX2024"
if b==c:
STAFF()
else:
print('INCORRECT PASSWORD,TRY AGAIN')
if a==2:
print("""
--------------------------------------------------------------ELECTRONIC SHOP--------------------------------------------
==============================================================[ SIGN-UP: 1 ]=====================================================
==============================================================[ LOG-IN: 2 ]=====================================================""")
s=int(input("ENTER YOUR CHOICE: "))
#Sign-Up
if s==1:
user_name=input("ENTER USERNAME: ")
name=input("ENTER NAME:")
password=input("ENTER PASSWORD: ")
phone_number=int(input("ENTER PHONE NUMBER"))
mail_id=input('ENTER MAIL ID')
C.execute("insert into signup_details values('{}','{}','{}',{},'{}')".format(user_name,name,password,phone_number,mail_id))
DB.commit()
print("SIGN UP COMPLETED SUCCESSFULLY")
else:
user= input("Enter Your Username: ")
C.execute("select username from Signup_details where username='"+user+"'")
b=C.fetchone()
b1=input("Enter Your Password: ")
C.execute("select password from signup_details where password='"+b1+"'")
a2=C.fetchone()
if a2 is not None:
print("""
-------------------------------------------------------------LOGIN SUCCESFULLY--------------------------------------------------------------""")
BUYER()
if a==3:
break
