def get_purchases():
kitchen_purchases = KitchenStockPurchase.read(KitchenStockPurchase)
kitchen_items = KitchenStock.read(KitchenStock)
drink_items = Brand.read(Brand)
brand_purchases = Purchase.read(Purchase)
total_purchases = KitchenStockPurchase.get_total_price(KitchenStockPurchase) + Purchase.get_total_price(Purchase)
return render_template("manager/purchases.html", mod=module, total_purchases=total_purchases, kitchen_purchases=kitchen_purchases, kitchen_items=kitchen_items, drink_items=drink_items, brand_purchases=brand_purchases)
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_sales():
if request.method == "GET":
cashiers = Cashier.read(Cashier)
waiters = Waiter.read(Waiter)
items = Food.read(Food) + Brand.read(Brand)
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(9999, 12, 31)
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("manager/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 filter():
if request.method == "GET":
kitchen_items = KitchenStock.read(KitchenStock)
drink_items = Brand.read(Brand)
kitchen_purchases = []
brand_purchases = []
item = request.args.get("item")
_from = request.args.get("from")
to = request.args.get("to")
place = request.args.get("place")
filter_kitchen, filter_bar = True, True
if place == "kitchen": filter_bar = False
elif place == "bar": filter_kitchen = False
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:
item_type, id = item.split("-")
if item_type == "kitchen":
kitchen_purchases = KitchenStockPurchase.filter2(KitchenStockPurchase, id, _from, to, filter_kitchen)
elif item_type == "drink":
brand_purchases = Purchase.filter(Purchase, id, _from, to, filter_bar)
else:
kitchen_purchases = KitchenStockPurchase.filter2(KitchenStockPurchase, "", _from, to, filter_kitchen)
brand_purchases = Purchase.filter(Purchase, "", _from, to, filter_bar)
print(">>>>>>>>>>>>>>>>>", kitchen_purchases, brand_purchases)
total_purchases = KitchenStockPurchase.get_total_price(KitchenStockPurchase, purchases=kitchen_purchases) + Purchase.get_total_price(Purchase, purchases=brand_purchases)
return render_template("manager/purchases.html", mod=module, kitchen_purchases=kitchen_purchases, total_purchases=total_purchases, kitchen_items=kitchen_items, drink_items=drink_items, item_id=item, brand_purchases=brand_purchases, tomorrow=to, today=_from)
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 get_brands():
brands = Brand.read(Brand)
categories = Category.read(Category)
return render_template("manager/brands.html", mod=module, brands=brands, categories=categories)
