def getOrders(username):
db = sqlite3.connect("users.db")
c = db.cursor()
c.execute("SELECT isbn,quantity FROM orders WHERE username = ?", (username,))
books = []
for isbn, quantity in c.fetchall():
book = bookhelper.getBook(isbn)
book["quantity"] = quantity
books.append(book)
return books
def bookDetail(isbn):
if bookhelper.getBook(isbn) != None:
bookDetailFile = open("bookDetail.html", "r")
bookDetail = bookDetailFile.read()
bookDetailFile.close()
book = bookhelper.getBook(isbn)
book["header"] = getHeader()
book["releasedate"] = fancyDate(book["releasedate"])
if userhelper.isLoggedIn():
book["disabled"] = ""
book["cartmessage"] = "Add to Cart"
else:
book["disabled"] = "disabled"
book["cartmessage"] = "Login to purchase"
book["username"] = userhelper.getCurrentUser()
return bookDetail % book
else:
return error()
def getOrdersPrice(username):
db = sqlite3.connect("users.db")
c = db.cursor()
c.execute("SELECT isbn,quantity FROM orders WHERE username = ?", (username,))
price = 0.0
for isbn, quantity in c.fetchall():
book = bookhelper.getBook(isbn)
bookPrice = float(book["price"][1:])
price += bookPrice*quantity
if price == 0:
return ""
return "${0:.2f}".format(round(price,2))
