def cart_total_amount(cls, customer_id):
total = session.query(func.sum(cls.total))\
.filter_by(
customer_id=customer_id,
is_ordered=False
).scalar()
return total if total else 0
def index(self):
customer_number = session.query(func.count(db.Customer.id)).scalar()
resturant_number = session.query(func.count(db.Resturant.id)).scalar()
sales_amount = session.query(func.count(db.Sales.amount)).scalar()
products_sold = session.query(func.sum(db.Sales.quantity)).scalar()
if customer_number is None:
customer_number = 0
if resturant_number is None:
resturant_number = 0
if sales_amount is None:
sales_amount = 0
if products_sold is None:
products_sold = 0
return self.render("admin/index.html",
customer_number=customer_number,
resturant_number=resturant_number,
sales_amount=sales_amount,
products_sold=products_sold)
def customer_order_items_total(cls, order_id):
total = session.query(func.sum(cls.total))\
.filter_by(
order_id=order_id
).scalar()
return total if total else 0
def read_sales_sum(cls, attr, *args):
sales_sum = session.query(func.sum(attr)).filter(*args).scalar()
return sales_sum if sales_sum else 0