Project On “Fashion Store”
Nishant kumar singh
DBMS: MySQL
Host: localhost
User: root
Pass: root
DataBase: fashion
Table Structure: (Images Bellow)Product
Table:
Purchase Table:
Note: In Purchase table take the purchase ID as varchar (16)
Stock Table;
Sales Table:
Note: In Purchase table take the sale_id as varchar (16)
Python Code:
import os import
platform import
[Link] import
pandas as pd import
datetime
mydb=[Link](host="localhost",\
user="root",\
passwd="root",\
database="fashion")
mycursor=[Link]()
def AddProduct():
L=[]
stk=[]
pid=input("Enter the Product ID : ")
[Link](pid)
IName=input("Enter the Product Name : ")
[Link](IName)
brnd=input("Enter the Product Brand Name : ") [Link](brnd)
fr=input("Enter Male/Female/Kids : ")
[Link](fr)
sn=input("Enter Winter/Summer : ")
[Link](sn)
rate=int(input("Enter the Rates for Product :")) [Link](rate) product=(L) sql="Insert into
product (product_id,PName,brand,Product_for,Season,rate)values(%s,%s,%s,%s,%s,%s)"
[Link](sql,product) [Link]() [Link](pid) [Link](0) [Link]("No")
st=(stk) sql="insert into stock(item_id, Instock, status) values(%s,%s,%s)" [Link](sql,st)
[Link]() print("One Product inserted ")
def EditProduct():
pid=input("Enter product ID to be edited : ")
sql="select * from product where product_id=%s"
ed=(pid,) [Link](sql,ed)
res=[Link]() for x in res: print(x)
print("") fld=input("Enter the field which you want
to edit : ") val=input("Enter the value you want to
set : ")
sql="Update product set " + fld +"='" + val + "' where product_id='" + pid + "'"
sq=[Link](sql) print("Editing Don : ") print("After correction
the record is : ") sql="select * from product where product_id=%s"
ed=(pid,)
[Link](sql,ed)
res=[Link]()
for x in res: print(x)
[Link]()
def DelProduct():
pid=input("Enter the Product)id to be deleted : ")
sql="delete from sales where item_id=%s"
id=(pid,) [Link](sql,id)
[Link]() sql="delete from purchase
where item_id=%s" [Link](sql,id)
[Link]() sql="delete from stock where
item_id=%s" [Link](sql,id)
[Link]() sql="delete from product where
product_id=%s" [Link](sql,id)
[Link]() print("One Item Deleted")
def ViewProduct(): print("Display Menu: Select the category
to display the data") print("1. All Details") print("2. Product
Name:") print("3. Product Brand:") print("4. Product For:")
print("5. Product Season:") print("6. Product ID:") x=0
ch=int(input("Enter your choice to display : ")) if ch==1:
sql="select * from product"
[Link](sql)
res=[Link]() for x in res:
print(x) x=1 elifch==2:
var='PName' val=input("Enter the name
of Product : ") elifch==3: var='brand'
val=input("Enter the name of Brand : ")
elifch==4:
var='Product_for'
val=input("Enter Male/Femal/Kids : ")
elifch==5: var='season'
val=input("Enter the Season : ")
elifch==6:
var='product_id'
val=input("Enter the Product_id : ")
if x==0:
sql="select * from product where " + var + " = %s"
sq=sqltp=(val,) [Link](sq,tp)
res=[Link]() for x in res: print(x)
def PurchaseProduct():
mn="" dy=""
now=[Link]()
purchaseID="P"+str([Link])+str([Link])+str([Link])+str([Link])+str([Link])+str([Link])
L=[]
Lst=[]
[Link](purchaseID)
itemId=input("Enter Product ID : ")
[Link](itemId)
itemNo=int(input("Enter the number of Items : "))
[Link](itemNo) sql="select rate from product
where product_id=%s" pid=(itemId,)
[Link](sql,pid) res=[Link]()
for x in res:
print("rate is : ", x) amount=x*itemNo
print("Amount is :", amount)
[Link](amount)
mnth=[Link] if
mnth<=9:
mn="0"+str(mnth) else:
mn=str(mnth)
day=[Link] if
day<=9:
dy="0"+str(day) else:
dy=str(day)
dt=str([Link])+"-"+mn+"-
"+[Link](dt) tp=(L)
sql="insert into purchase(purchase_id,item_id,no_of_items,amount,Purchase_date)values(%s,%s,%s,%s,%s)"
[Link](sql,tp) [Link]() sql="Select Instock from stock where item_id=%s"
[Link](sql,pid) res=[Link]() status="No" for x in res: print(x)
instock=x[0]+itemNo if
instock>0:
status="Yes"
[Link](instock)
[Link](status)
[Link](itemId) tp=(Lst)
sql="update stock set instock=%s,status=%s where item_id=%s"
[Link](sql,tp) [Link]() print("1 Item
purchased and saved in Database")
def ViewPurchase():
item=input("Enter Product Name : ")
sql="select product.product_id,
[Link],[Link],purchase.no_of_items,purchase.purchase_date,[Link] from product
INNER JOIN purchase ON product.product_id=purchase.item_id and [Link]=%s" itm=(item,)
[Link](sql,itm) res=[Link]() for x in res: print(x)
def ViewStock():
item=input("Enter Product Name : ") sql="select
product.product_id,[Link],[Link],\
[Link] from stock, product where \
product.product_id=stock.item_id and [Link]=%s" itm=(item,)
[Link](sql,itm)
res=[Link]()
for x in res: print(x)
def SaleProduct():
now=[Link]()
saleID="S"+str([Link])+str([Link])+str([Link])+str([Link])+str([Link])+str([Link])
L=[]
[Link](saleID)
itemId=input("Enter Product ID : ")
[Link](itemId)
itemNo=int(input("Enter the number of Items : "))
[Link](itemNo) sql="select rate from product
where product_id=%s" pid=(itemId,)
[Link](sql,pid) res=[Link]()
for x in res:
print("The rate of item is :",x)
dis=int(input("Enter the discount : "))
saleRate=x[0]-(x[0]*dis/100)
[Link](saleRate)
amount=itemNo*[Link](am
ount) mnth=[Link] if
mnth<=9:
mn="0"+str(mnth) else:
mn=str(mnth)
day=[Link] if
day<=9:
dy="0"+str(day)
else:
dy=str(day)
dt=str([Link])+"-"+mn+"-"+[Link](dt) tp=(L)
sql="insert into sales (sale_id, item_id,no_of_item_sold,\
sale_rate,amount,date_of_sale) values(%s,%s,%s,%s,%s,%s)"
[Link](sql,tp) [Link]()
sql="Select Instock from stock where item_id=%s"
[Link](sql,pid) res=[Link]()
for x in res:
print("Total Items in Stock are : ",x)
instock=x[0]-itemNo
if instock>0: status="Yes" tp=(instock,status,itemId)
sql="update stock set instock=%s,status=%s where item_id=%s"
print("Remaining Items in Stock are : ",instock)
[Link](sql,tp) [Link]()
def ViewSales():
item=input("Enter Product Name : ") sql="select
product.product_id, [Link],[Link],\
sales.no_of_item_sold,sales.date_of_sale,[Link] \ from
sales, product where product.product_id=sales.item_id \ and
[Link]=%s" itm=(item,) [Link](sql,itm)
res=[Link]() for x in res: print(x)
def MenuSet(): #Function For The SFashion Store System
print("Enter 1 : To Add Product ") print("Enter 2 : To
Edit Product ") print("Enter 3 : To Delete Product ")
print("Enter 4 : To View Product ") print("Enter 5 : To
Purchase Product") print("Enter 6 : To View
Purchases") print("Enter 7 : To View Stock Detials")
print("Enter 8 : To Sale the item") print("Enter 9 : To
View Sales Detials")
try: #Using Exceptions For Validation userInput = int(input("Please Select An
Above Option: ")) #Will Take Input From User except ValueError:
exit("\nHy! That's Not A Number") #Error Message else:
print("\n") #Print New Line
if(userInput == 1):
AddProduct()
elif(userInput == 2):
EditProduct() elif
(userInput==3):
DelProduct() elif
(userInput==4):
ViewProduct() elif
(userInput==5):
PurchaseProduct() elif
(userInput==6):
ViewPurchase() elif
(userInput==7):
ViewStock() elif
(userInput==8):
SaleProduct() elif
(userInput==9):
ViewSales() else:
print("Enter correct choice. . . ")
print("*"*80) print("* * * * * * * Welcome to the Project of Fashion Store
* * * * * * * ") print("* * * * Developed by: Neha Tyagi, PGT CS, KV no. 5
Jaipur : * * * * ") print("*"*80) print("")
MenuSet()
def runAgain():
runAgn = input("\nwant To Run Again Y/n: ")
while([Link]() == 'y'):
if([Link]() == "Windows"):
print([Link]('cls'))
else:
print([Link]('clear')) MenuSet()
runAgn = input("\nwant To Run Again Y/n: ")
runAgain()
Output: (Main Menu)
(Add Product)
(Edit
Product)
(Delete Product) (View Product)
(Purchase Product) (View Purchase)
(View Stock
Details)
(Sale Item)
(View Sales Details)
