def orderJson(): if session: data = request.get_json(force=True) stock_item = Products.query.filter_by(id=data['product_id']).first() if int(data['quantity']) > int(stock_item.quantity): flash('Quantity ordered is higher than stock remaining', 'danger') return 'We have an error', 400 else: # update the product's stock quantity when an order is made stock_item.quantity = int(stock_item.quantity) - int( data['quantity']) db.session.add(stock_item) db.session.commit() o = Orders(email=session['email'], quantity=data['quantity'], total=data['total'], product_id=data['product_id'], company=session['companyname'], customer_id=session['uid']) o.create_record() return 'Order successfully saved', 200
def cust_home(): allproducts = Products.fetch_all() if 'email' in session: if request.method == 'POST': email = session['email'] product = request.form['productname'] company = request.form['name'] qun = request.form['quantity'] date = request.form['date'] # check for the product quantity # product_to_check = Products.query.filter_by(name=product).first() if qun > 0: flash('Quantity ordered is higher than stock remaining', 'danger') return redirect(url_for('cust_home')) else: ch = Orders(email=email, product=product, orderdate=date, customer_id=session['uid'], company=company) ch.create_record() flash('Order successfully made', 'success') return redirect(url_for('cust_home')) return render_template('customerorder.html', products=allproducts) else: flash('Please login', 'danger') return redirect(url_for('login'))
def orderJson(): data = request.get_json(force=True) o = Orders(email=session['email'], quantity=data['quantity'], total=data['total'], product_id=data['product_id'], company=data['company']) #,customer_id=session['uid'] o.create_record() return 'Order successfully saved'
def customers(): allproducts = Products.fetch_all() if request.method == 'POST': email = request.form['email'] products = request.form['productname'] date = request.form['date'] company = request.form['company'] o = Orders(email=email, product=products, orderdate=date, company=company) o.create_record() flash('Order successfull made', 'success') return redirect(url_for('customers')) return render_template('customers.html', products=allproducts)
def cust_home(): allproducts = Products.fetch_all() if 'email' in session: if request.method == 'POST': email = session['email'] product = request.form['productname'] company = request.form['name'] qun = request.form['quantity'] date = request.form['date'] ch = Orders(email=email, product=product, orderdate=date, customer_id=session['uid'], company=company) ch.create_record() flash('Order successfully made', 'success') return redirect(url_for('cust_home')) return render_template('customerorder.html', products=allproducts) else: flash('Please login', 'danger') return redirect(url_for('login'))