def order_book(isbn13, customerid): form = AddOrderForm(request.form) if request.method == 'POST': order = Order.create(customer_id=customerid) flash('You, {}, have ordered a book!'.format( customerid), 'success') # order = Order.query.filter_by(customer_id=customerid) # order = order.first() OrderConsistsOf.create(consists_order_id=order.id, consists_isbn13=isbn13, consists_qty=form.qty.data) flash('You have ordered the book: {}!'.format( isbn13), 'success') return "Good job!" else: flash_errors(form) return render_template('orders/addorder.html', form=form)
def order_book(isbn13): customerid = current_user.get_id() form = AddOrderForm(request.form) if request.method == 'POST': order = Order.create(customer_id=customerid) flash('You, {}, have ordered a book!'.format(customerid), 'success') # order = Order.query.filter_by(customer_id=customerid) # order = order.first() OrderConsistsOf.create(consists_order_id=order.id, consists_isbn13=isbn13, consists_qty=form.qty.data) flash('You have ordered the book: {}!'.format(isbn13), 'success') return redirect(url_for('book.browse')) else: flash_errors(form) RECOMMENDATIONS = [] """Get book recommendation.""" if current_user.is_authenticated: id = current_user.get_id() # get the book rec q1 = db.session.query(OrderConsistsOf.consists_order_id).filter(OrderConsistsOf.consists_isbn13 == isbn13).\ filter(OrderConsistsOf.consists_order_id != id).all() for q in q1: isbn13_list = db.session.query(OrderConsistsOf.consists_isbn13).filter(OrderConsistsOf.consists_order_id == q[0]).\ filter(OrderConsistsOf.consists_isbn13 != isbn13).all() if isbn13_list != []: for i in isbn13_list: RECOMMENDATIONS.append( db.session.query(Book).filter( Book.isbn13 == i[0]).first()) return render_template('orders/addorder.html', form=form, recommendations=RECOMMENDATIONS)