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 get_edit_order_data(id): data = dict() foods = Food.read(Food) drinks = Brand.read(Brand) # get sale items dict sale_items_dict = utils.build_sale_items_dict(foods, drinks) data["sale_items"] = sale_items_dict # get order dict order = Order.read_one(Order, id) order_dict = utils.build_order_dict(order) data["order"] = order_dict return jsonify(data)
def get_sales(): sales = Sale.read(Sale) sale_page = Sale.read_limit(Sale, 1, 10) cashiers = Cashier.read(Cashier) waiters = Waiter.read(Waiter) items = Food.read(Food) + Brand.read(Brand) total_sales = utils.compute_sales(sales) return render_template("manager/sales.html", mod=module, sales=sales, sale_page=sale_page, total_sales=total_sales, cashiers=cashiers, waiters=waiters, items=items)
def filter_food(): if request.method == "GET": cashiers = Cashier.read(Cashier) waiters = Waiter.read(Waiter) items = Food.read(Food) item = request.args["item"] cashier = request.args["cashier"] waiter = request.args["waiter"] _from = request.args["from"] to = request.args["to"] if _from: _from = utils.convert_date_from_html(_from) else: _from = datetime.datetime(2000, 1, 1) if to: to = utils.convert_date_from_html(to) else: to = datetime.datetime(3000, 1, 1) if item == '0': return redirect(url_for('sale.get_food_sales')) sales = Sale.filter(Sale, item, cashier, waiter, _from, to) total_sales = utils.compute_sales(sales) # Avoid error on changing str to int if cashier == "": cashier = 0 if waiter == "": waiter = 0 return render_template("chef/food-sales.html", mod=module, sales=sales, total_sales=total_sales, cashiers=cashiers, waiters=waiters, items=items, today=_from, tomorrow=to, item_id=item, cashier_id=int(cashier), waiter_id=int(waiter))
def get_food_sales(): if request.args.get("page"): page = int(request.args.get("page")) if page == 0: return redirect(url_for('sale.get_food_sales')) else: page = 1 sale_page = Sale.read_food_sales(Sale, page, 10) sales = sale_page.items cashiers = Cashier.read(Cashier) waiters = Waiter.read(Waiter) items = Food.read(Food) total_sales = utils.compute_sales(sales) return render_template("chef/food-sales.html", mod=module, sales=sales, sale_page=sale_page, current_page=page, total_sales=total_sales, cashiers=cashiers, waiters=waiters, items=items)
def get_sale_page(): page = request.args.get("page") if page: page = int(page) if page == 0: return redirect(url_for('sale.get_sales')) sale_page = Sale.read_limit(Sale, page, 10) sales = sale_page.items cashiers = Cashier.read(Cashier) waiters = Waiter.read(Waiter) items = Food.read(Food) + Brand.read(Brand) total_sales = utils.compute_sales(sales) return render_template("manager/sales.html", mod=module, sales=sales, sale_page=sale_page, current_page=page, total_sales=total_sales, cashiers=cashiers, waiters=waiters, items=items) else: return redirect(url_for("sale.get_sales"))
def get_sale_items(): foods = Food.read(Food) drinks = Brand.read(Brand) sale_items = utils.build_sale_items_dict(foods, drinks) return jsonify(sale_items)
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))