def orderInfo(request): print(request.POST) if not request.session['loggedIn']: return redirect('store_front') else: with connection.cursor() as cursor: cursor.execute( "SELECT p.Name, p.Price, p.ID FROM store_product p, store_cart c, store_cart_Product_ID cp WHERE c.Customer_Email_id=%s AND c.id = cp.cart_id AND cp.product_id = p.id", [request.session['userName']]) cartItems = cursor.fetchall() cursor.execute( "SELECT SUM(p.Price) FROM store_product p, store_cart c, store_cart_Product_ID cp WHERE c.Customer_Email_id=%s AND c.id = cp.cart_id AND cp.product_id = p.id", [request.session['userName']]) totalPrice = cursor.fetchone()[0] cursor.execute("SELECT Address FROM store_customer WHERE Email = %s", [request.session['userName']]) address = cursor.fetchone()[0] if request.method == 'POST' and 'placeOrder' in request.POST: print('working') newOrder = Order() newOrder.Total_Price = totalPrice newOrder.Shipping_Info = request.POST['shippingAddress'] newOrder.Billing_Info = request.session['ccNum'] request.session['ccNum'] = None newOrder.Placed_By = Customer.objects.get(pk=request.session['userName']) newOrder.save() for item in cartItems: newOrder.Product_ID.add(item[2]) myCart = Cart.objects.get(Customer_Email=request.session['userName']) myCart.Product_ID.clear() return order(request, newOrder.Order_Number) return render(request, 'store/orderInfo.html', {'cartItems': cartItems, 'total': totalPrice, 'shippingAddress': address, 'creditCard': request.session['ccNum']})