def borrowReturn(userid):
#userid = user_input.user_id()
#data = checkUser(userid)
#print("Welcome back",data[1],data[2])
itemid = user_input.integer_number(
"Enter item ID of item you want to return")
itemnum = user_input.integer_number(
"Enter the number of items you want to return")
try:
print("Returning...")
item.makeReturn(userid, itemid, itemnum)
except:
print("Error returning item!")
def adminWelcomeDialog(userin):
adminPrintChoices()
userin = user_input.integer_number("Input your choice:")
try:
userin = int(userin)
choices = (1, 2, 3, 4, 5, 6, 7, 8)
while (userin not in choices):
clear_screen()
print("Wrong input,try again!")
adminPrintChoices()
userin = user_input.integer_number("Input your choice:")
return int(userin)
except:
print("Wrong Input,try again")
def delUser():
mycursor = mydb.cursor()
userid = user_input.integer_number("Input ID of user you want to delete:")
if checkUser(userid) != "Error":
data = checkUser(userid)
data = int(data[4])
if data == 0:
try:
sql = "DELETE FROM users WHERE id = (%s);"
val = [userid]
mycursor.execute(sql, val)
try:
mydb.commit()
except:
print("MySQL error has occured!")
print("User deleted sucessfully!")
except:
print("Id is not in the correct format!")
else:
print("Can't delete user,not all items returned")
def addItem():
userdata = ["", "", "", "", ""]
userdata[0] = user_input.text_string("Input item name:")
userdata[1] = user_input.float_number("Input item price:")
userdata[2] = user_input.integer_number(
"Input ammount of Items that you are adding:")
userdata[3] = user_input.text_string(
"Input Row placement for item").upper()
userdata[4] = user_input.text_string(
"Input Column placement for item").upper()
sql = "INSERT INTO items (itemName,itemPrice,totalAmount,availableAmount,itemLocationRow,itemLocationColumn) VALUES (%s,%s,%s,%s,%s,%s)"
val = [
userdata[0],
float(userdata[1]),
int(userdata[2]),
int(userdata[2]), userdata[3], userdata[4]
]
mycursor = mydb.cursor()
mycursor.execute(sql, val)
try:
mydb.commit()
except:
print("MySQL error has occured")
print("Item added sucesfully")
def borrow(userid):
#userid = user_input.user_id()
try:
data = checkUser(userid)
if data[0] == 0:
print("Sorry,you are not registered.Contact admin support")
else:
itemid = user_input.integer_number(
"Enter item ID of item you want to borrow")
n = user_input.integer_number(
"Enter ammount of items you want to borrow")
try:
print("Borrowing...")
item.makeBorrow(userid, itemid, n)
except:
print("Error while borrowing item")
pass
except:
print("Id is not in the correct format!")
def welcomeDialog(isAdmin):
print("You can...")
print("\t0.Log off")
print("\t1.See list of available items")
print("\t2.Borrow an item")
print("\t3.Return an item")
print("\t4.See list of borrowed items")
if isAdmin == True:
print("\t5.Go to Administrator area")
userin = user_input.integer_number("Input your choice")
try:
if isAdmin == True:
choices = (0, 1, 2, 3, 4, 5)
else:
choices = (0, 1, 2, 3, 4)
while (userin not in choices):
print("Wrong input,try again")
welcomeDialog(isAdmin)
userin = user_input.integer_number("Input your choice")
return int(userin)
except:
print("Wrong Input,try again")
def delItem():
item_id = user_input.integer_number(
"Input the ID of item you want to delete:")
data = checkItem(item_id)
if data != "Error": # if item does exist
if data[1] != data[2]: #not all items are returned
userchoice = user_input.text_string(
"Not all items are returned,do you want to proceed, input y or n"
)
if userchoice.lower() == "y":
#delete item
mycursor = mydb.cursor()
sql = "DELETE from items where id = (%s);"
val = [item_id]
mycursor.execute(sql, val)
mydb.commit()
"""
#delete item from borrowed table?
sql ="DELETE from borrowed where item_id = ('%s');"
mycursor.execute(sql,val)
mydb.commit()
"""
else:
pass
else:
#delete item
mycursor = mydb.cursor()
sql = "DELETE from items where id = (%s);"
val = [item_id]
mycursor.execute(sql, val)
mydb.commit()
"""
#delete item from borrowed table?
sql ="DELETE from borrowed where item_id = ('%s');"
mycursor.execute(sql,val)
mydb.commit()
"""
else: #item does not exist
print("This item does not exist!")
passwd="motobecane2",
database="ivica3730k_test_app")
import user_input
from user_input import clear_screen
print("Welcome to the python borrow system!!!")
import dialogs
import database
import item
#print(item.checkBorrowedAmount(1,2))
#item.makeBorrow(1,2,5)
#quit()
while (1):
id_user = user_input.integer_number("Input your Id to log in")
data = database.checkUser(id_user)
if data == "Error":
print("User does not exist:")
else:
isAdmin = bool(data[6])
userid = int(data[0])
if isAdmin: #user is an admin
adminPass = user_input.text_string(
"Since you are an Admin, you need to input your password here:"
)
if database.checkAdminPass(id_user, adminPass):
print("Welcome back, Admin")
isAdmin = True
break
else: