STOCK MANAGEMENT Ivestigatory Project Class 12

STOCK MANAGEMENT
Abstract
Stock management is the practice of ordering, storing, tracking, and controlling
inventory.Stock management applies to every item a business uses to produce its products
or services – from raw materials to finished goods. In other words, stock management
covers every aspect of a business’s inventory.
The project contains following modules:-
1. Product Management: This module is used to add, update and delete the products.
2. Purchase Management: This module is used to manage the purchase system.
3. Sales Management: This module is used to manage the sale of the products.
4. User Management: This module is used to add/delete the user/staff.
5. Database setup: This module is used to setup the database in the system for the first
time.
Technologies Used:
SOFTWARE SPECIFICATION:-
Operating System : Windows 7
Platform : Python IDLE 2.7
Database : MySQL
Languages : Python
HARDWARE SPECIFICATION:-
Processor : Dual Core and above

Hard Disk : 40GB
Ram : 1024 MB
Note: For Python-MySQL connectivity, following data have been used:-

Host- localhost, user- root, password- 12345, database- stock
CODING
# STOCK MANAGEMENT
importos
importmysql.connector
importdatetime
now = datetime.datetime.now()
defproduct_mgmt( ):
while True :
print("\t\t\t 1. Add New Product")
print("\t\t\t 2. List Product")
print("\t\t\t 3. Update Product")
print("\t\t\t 4. Delete Product")
print("\t\t\t 5. Back (Main Menu)")
p=int (input("\t\tEnter Your Choice :"))
if p==1:
add_product()
if p==2:
search_product()
if p==3:
update_product()
if p==4:
delete_product()
if p== 5 :
break
defpurchase_mgmt( ):
while True :
print("\t\t\t 1. Add Order")
print("\t\t\t 2. List Order")
o=int (input("\t\tEnter Your Choice :"))
if o==1 :
add_order()
if o==2 :
list_order()
if o== 3 :
break
defsales_mgmt( ):
while True :
print("\t\t\t 1. Sale Items")
print("\t\t\t 2. List Sales")
s=int (input("\t\tEnter Your Choice :"))
if s== 1 :
sale_product()
if s== 2 :
list_sale()
if s== 3 :
break
defuser_mgmt( ):
while True :
print("\t\t\t 1. Add user")
print("\t\t\t 2. List user")
u=int (input("\t\tEnter Your Choice :"))
if u==1:
add_user()
if u==2:
list_user()
if u==3:
break
defcreate_database():
mydb=mysql.connector.connect(host="localhost",user="root",passwd="12345
",database="stock")
mycursor=mydb.cursor()
print(" Creating PRODUCT table")
sql = "CREATE TABLE if not exists product (\
pcodeint(4) PRIMARY KEY,\
pname char(30) NOT NULL,\
pprice float(8,2) ,\
pqtyint(4) ,\
pcatchar(30));"
mycursor.execute(sql)
print(" Creating ORDER table")
sql = "CREATE TABLE if not exists orders (\
orderidint(4)PRIMARY KEY ,\
orderdate DATE ,\
pcode char(30) NOT NULL , \
pqtyint(4) ,\
supplier char(50),\
pcatchar(30));"
print(" ORDER table created")
print(" Creating SALES table")

sql = "CREATE TABLE if not exists sales (\
salesidint(4) PRIMARY KEY ,\
salesdate DATE ,\
pcode char(30) references product(pcode), \
pqtyint(4) ,\
Total double(8,2)\
);"
print(" SALES table created")
sql = "CREATE TABLE if not exists user (\
uid char(6) PRIMARY KEY,\
uname char(30) NOT NULL,\
upwdchar(30));"
print(" USER table created")
deflist_database():
",database="stock")
sql="show tables;"
fori in mycursor:
print(i)
defadd_order():
",database="stock")
now = datetime.datetime.now()
sql="INSERT INTO orders(orderid,orderdate,pcode,pprice,pqty,supplier,pcat)
values (%s,%s,%s,%s,%s,%s,%s)"
code=int(input("Enter product code :"))
oid=now.year+now.month+now.day+now.hour+now.minute+now.second
qty=int(input("Enter product quantity : "))
price=float(input("Enter Product unit price: "))
cat=input("Enter product category: ")
supplier=input("Enter Supplier details: ")
val=(oid,now,code,price,qty,supplier,cat)
mycursor.execute(sql,val)
mydb.commit()
deflist_order():
",database="stock")
sql="SELECT * from orders"
print("\t\t\t\t\t\t\t ORDER DETAILS")
print("-"*85)
print("orderid Date Product code price quantity Supplier
Category")
print("-"*85)
for i in mycursor:
print(i[0],"\t",i[1],"\t",i[2],"\t ",i[3],"\t",i[4],"\t ",i[5],"\t",i[6])
print("-"*85)
defdb_mgmt( ):
while True :
print("\t\t\t 1. Database creation")
print("\t\t\t 2. List Database")
p=int (input("\t\tEnter Your Choice :"))
if p==1 :
create_database()
if p==2 :
list_database()
if p== 3 :
break
defadd_product():
",database="stock")
sql="INSERT INTO product(pcode,pname,pprice,pqty,pcat) values (%s,%s,%s,
%s,%s)"
code=int(input("\t\tEnter product code :"))
search="SELECT count(*) FROM product WHERE pcode=%s;"
val=(code,)
mycursor.execute(search,val)
for x in mycursor:
cnt=x[0]
ifcnt==0:
name=input("\t\tEnter product name :")
qty=int(input("\t\tEnter product quantity :"))
price=float(input("\t\tEnter product unit price :"))
cat=input("\t\tEnter Product category :")
val=(code,name,price,qty,cat)
mydb.commit()
else:
print("\t\t Product already exist")
defupdate_product():
",database="stock")
code=int(input("Enter the product code :"))
qty=int(input("Enter the quantity :"))
sql="UPDATE product SET pqty=pqty+%s WHERE pcode=%s;"
val=(qty,code)
mydb.commit()
print("\t\t Product details updated")
defdelete_product():
",database="stock")
code=int(input("Enter the product code :"))
sql="DELETE FROM product WHERE pcode = %s;"
val=(code,)
mydb.commit()
print(mycursor.rowcount," record(s) deleted");
defsearch_product():
while True :
print("\t\t\t 1. List all product")
print("\t\t\t 2. List product code wise")
print("\t\t\t 3. List product categoty wise")
s=int (input("\t\tEnter Your Choice :"))
if s==1 :
list_product()
if s==2 :
code=int(input(" Enter product code :"))
list_prcode(code)
if s==3 :
cat=input("Enter category :")
list_prcat(cat)
if s== 4 :
break
deflist_product():
",database="stock")
sql="SELECT * from product"
print("\t\t\t\t PRODUCT DETAILS")
print("\t\t","-"*47)
print("\t\t code name price quantity category")
print("\t\t","-"*47)
fori in mycursor:
print("\t\t",i[0],"\t",i[1],"\t",i[2],"\t ",i[3],"\t\t",i[4])
print("\t\t","-"*47)
deflist_prcode(code):
",database="stock")
sql="SELECT * from product WHERE pcode=%s"
val=(code,)
print("\t\t","-"*47)
print("\t\t","-"*47)
fori in mycursor:
print("\t\t","-"*47)
defsale_product():
",database="stock")
pcode=input("Enter product code: ")
sql="SELECT count(*) from product WHERE pcode=%s;"
val=(pcode,)
for x in mycursor:
cnt=x[0]
ifcnt !=0 :
sql="SELECT * from product WHERE pcode=%s;"
val=(pcode,)
for x in mycursor:
print(x)
price=int(x[2])
pqty=int(x[3])
qty=int(input("Enter no of quantity :"))
ifqty<= pqty:
total=qty*price;
print ("Collect Rs. ", total)
sql="INSERT into sales values(%s,%s,%s,%s,%s,%s)"
val=(int(cnt)+1,datetime.datetime.now(),pcode,price,qty,total)
sql="UPDATE product SET pqty=pqty-%s WHERE pcode=%s"
val=(qty,pcode)
mydb.commit()
else:
print(" Quantity not Available")
else:
print(" Product is not avalaible")
deflist_sale():
",database="stock")
sql="SELECT * FROM sales"
print(" \t\t\t\tSALES DETAILS")
print("-"*80)
print("Sales id Date Product Code Price Quantity Total")
print("-"*80)
for x in mycursor:
print(x[0],"\t",x[1],"\t",x[2],"\t ",x[3],"\t\t",x[4],"\t\t",x[5])
print("-"*80)
deflist_prcat(cat):
",database="stock")
print (cat)
sql="SELECT * from product WHERE pcat =%s"
val=(cat,)
clrscr()
print("\t\t","-"*47)
print("\t\t","-"*47)
fori in mycursor:
print("\t\t","-"*47)
defadd_user():
",database="stock")
uid=input("Enter emaid id :")
name=input(" Enter Name :")
paswd=input("Enter Password :")
sql="INSERT INTO user values (%s,%s,%s);"
val=(uid,name,paswd)
mydb.commit()
print(mycursor.rowcount, " user created")
deflist_user():
",database="stock")
sql="SELECT uid,uname from user"
clrscr()
print("\t\t\t\t USER DETAILS")
print("\t\t","-"*27)
print("\t\t UID name ")
print("\t\t","-"*27)
fori in mycursor:
print("\t\t",i[0],"\t",i[1])
print("\t\t","-"*27)
defclrscr():
print("\n"*5)
while True:
clrscr()
print("\t\t\t STOCK MANAGEMENT")
print("\t\t\t ****************\n")
print("\t\t 1. PRODUCT MANAGEMENT")
print("\t\t 2. PURCHASE MANAGEMENT")
print("\t\t 3. SALES MANAGEMENT")
print("\t\t 4. USER MANAGEMENT")
print("\t\t 5. DATABASE SETUP")
print("\t\t 6. EXIT\n")
n=int(input("Enter your choice :"))
if n== 1:
product_mgmt()
if n== 2:
os.system('cls')
purchase_mgmt()
if n== 3:
sales_mgmt()
if n== 4:
user_mgmt()
if n==5:
db_mgmt()
if n== 6:
break

STOCK MANAGEMENT Ivestigatory Project Class 12

Uploaded by

Copyright:

Available Formats

STOCK MANAGEMENT Ivestigatory Project Class 12

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

STOCK MANAGEMENT Ivestigatory Project Class 12

Uploaded by

Copyright:

Available Formats

STOCK MANAGEMENT

Processor : Dual Core and above

Note: For Python-MySQL connectivity, following data have been used:-

print(" Creating SALES table")

You might also like