def sale_guides(): if request.method == "POST": unit = request.form["sale-unit"] price = request.form["sale-price"] quantity_in_purchase_unit = request.form["quantity-in-purchase-unit"] brand_id = request.form['brand'] brand = Brand.read_one(Brand, brand_id) SaleGuide(unit, price, quantity_in_purchase_unit, brand) session.close() return redirect('/brand/sale-guides?brand=' + str(brand_id)) else: brand_id = request.args["brand"] brand = Brand.read_one(Brand, brand_id) return render_template("manager/sale-guides.html", mod=module, brand=brand)
def add_purchase_guide(): unit = request.form["purchase-unit"] price = request.form["purchase-price"] brand_id = request.form['brand-id'] brand = Brand.read_one(Brand, brand_id) PurchaseGuide(unit, price, brand) return redirect(url_for('brand.get_brands'))
def add_sale_guide(): unit = request.form["sale-unit"] price = request.form["sale-price"] quantity_in_purchase_unit = request.form["quantity-in-purchase-unit"] brand_id = request.form['brand-id'] brand = Brand.read_one(Brand, brand_id) SaleGuide(unit, price, quantity_in_purchase_unit, brand) return redirect(url_for('brand.get_brands'))
def add_sales(): if request.method == "POST": sales = request.form["sales"] waiter_id = request.form["waiter"] cashier_id = request.form["cashier"] customer = request.form["customer"] waiter = Waiter.read_one(Waiter, waiter_id) cashier = Cashier.read_one(Cashier, cashier_id) new_order = Order(customer, waiter, cashier) sales = json.loads(sales) food_sales = sales["food_items"] drink_sales = sales["drink_items"] verified_bill = 0 for drink_sale in drink_sales.values(): brand = Brand.read_one(Brand, drink_sale["id"]) reduce_quantity = float(drink_sale["quantity"]) / float( drink_sale["quantity_ratio"]) Sale(drink_sale["sale_unit"], drink_sale["sale_price"], drink_sale["quantity"], new_order, waiter, cashier, brand=brand, reduce_quantity=reduce_quantity, sale_guide_id=drink_sale["sale_guide_id"]) verified_bill += int(drink_sale["quantity"]) * int( drink_sale["sale_price"]) for food_sale in food_sales.values(): food = Food.read_one(Food, food_sale["id"]) reduce_quantity = float(food_sale["quantity"]) / float( food_sale["quantity_ratio"]) Sale(food_sale["sale_unit"], food_sale["sale_price"], food_sale["quantity"], new_order, waiter, cashier, food=food, reduce_quantity=reduce_quantity) verified_bill += int(food_sale["quantity"]) * int( food_sale["sale_price"]) new_order.bill = verified_bill current_session = Session.get_current_session(Session, current_user.cashier) current_session.orders.append(new_order) session.commit() flash("Order submitted successfully", "success") order_id = new_order.id session.close() return redirect(url_for('order.get_order', id=order_id))
def edit_brand(): if request.method == "POST": category_id = request.form["category"] brand_id = request.form["brand-id"] brand_name = request.form["brand"] purchase_unit = request.form["purchase-unit"] purchase_price = request.form["purchase-price"] c = Category.read_one(Category, category_id) b = Brand.read_one(Brand, brand_id) pg = PurchaseGuide.read_one(PurchaseGuide, b.purchase_guide_id) Brand.update(b, brand_name, c) pg.update(purchase_unit, purchase_price) session.close() return redirect(url_for('brand.get_brands')) else: brand_id = request.args["brand"] brand = Brand.read_one(Brand, brand_id) categories = Category.read(Category) return render_template("manager/edit-brand.html", mod=module, brand=brand, categories=categories)
def reduce_stock(): if request.method == "POST": quantity = request.form['quantity'] brand_id = request.form['brand'] brand = Brand.read_one(Brand, brand_id) try: if int(quantity) < 1: flash("Invalid Input!", 'danger') else: brand.add_quantity(0-int(quantity)) flash("Reduced "+quantity+" units of "+brand.name+" from stock", 'info') session.close() return redirect(url_for('brand.get_brands')) except Exception as e: flash("Invalid Input!", 'danger') return redirect(url_for('brand.reduce_stock')+'?brand=1') else: brand_id = request.args["brand"] brand = Brand.read_one(Brand, brand_id) return render_template("manager/reduce-stock.html", mod=module, brand=brand)
def add_stock(): if request.method == "POST": quantity = request.form['quantity'] brand_id = request.form['brand'] brand = Brand.read_one(Brand, brand_id) try: if int(quantity) < 1: flash("Invalid Input!", 'danger') else: brand.add_quantity(quantity) Purchase(brand.purchase_guide.purchase_unit, brand.purchase_guide.purchase_price, quantity, brand) flash("Added "+quantity+" units of "+brand.name+" successfully", 'success') session.close() return redirect(url_for('brand.get_brands')) except Exception as e: flash("Invalid Input!", 'danger') return redirect(url_for('brand.add_stock')+'?brand='+brand_id) else: brand_id = request.args["brand"] brand = Brand.read_one(Brand, brand_id) return render_template("manager/add-stock.html", mod=module, brand=brand)
def delete_brand(): brand_id = request.form["brand-id"] b = Brand.read_one(Brand, brand_id) Brand.delete(b) session.close() return redirect(url_for('brand.get_brands'))
def edit_order(id): if request.method == "GET": order = Order.read_one(Order, id) if order.open: # get drink categories dict drink_categories = Category.read(Category) # get food categories dict food_categories = FoodCategory.read(FoodCategory) # get_order sold_items = {"food_items": {}, "drink_items": {}} for sale in order.sales: if sale.food_id: sold_items["food_items"][sale.food_id] = sale.quantity elif sale.brand_id: sold_items["drink_items"][sale.brand_id] = [sale.sale_guide_id, sale.quantity] return render_template('cashier/edit-order.html', order_id=id, categories=drink_categories, food_categories=food_categories, order=order, sold_items=sold_items, mod=module) return redirect(url_for('order.get_order', id=id)) elif request.method == "POST": order = Order.read_one(Order, id) old_sales = order.sales for sale in old_sales: sale_quantity = sale.quantity sale_guide = SaleGuide.read_one(SaleGuide, id=sale.sale_guide_id) if sale_guide: # convert to sale_quantity to purchase unit purchase_unit_quantity = sale_quantity/sale_guide.quantity_in_purchase_unit brand = Brand.read_one(Brand, id=sale.brand_id) brand.update_quantity(purchase_unit_quantity) else: units = sale.quantity food = Food.read_one(Food, id=sale.food_id) food.update_units(units) # delete the sale session.delete(sale) session.commit() sales = request.form["sales"] sales = json.loads(sales) food_sales = sales["food_items"] drink_sales = sales["drink_items"] verified_bill = 0 for drink_sale in drink_sales.values(): brand = Brand.read_one(Brand, drink_sale["id"]) sale_guide = SaleGuide.read_one(SaleGuide, id=drink_sale["sale_guide_id"]) reduce_quantity = float(drink_sale["quantity"]) / float(sale_guide.quantity_in_purchase_unit) Sale(drink_sale["sale_unit"], drink_sale["sale_price"], drink_sale["quantity"], order, order.waiter, order.cashier, brand=brand, reduce_quantity=reduce_quantity, sale_guide_id=drink_sale["sale_guide_id"]) verified_bill += int(drink_sale["quantity"]) * int(drink_sale["sale_price"]) for food_sale in food_sales.values(): food = Food.read_one(Food, food_sale["id"]) reduce_quantity = float(food_sale["quantity"]) Sale(food_sale["sale_unit"], food_sale["sale_price"], food_sale["quantity"], order, order.waiter, order.cashier, food=food, reduce_quantity=reduce_quantity) verified_bill += int(food_sale["quantity"]) * int(food_sale["sale_price"]) order.bill = verified_bill session.commit() return redirect(url_for('order.get_order', id=id))