def update_salescyear(store_statues):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues,
db.starting_day_of_cyear,
db.ending_day_of_cyear)["sales"].sum())
def update_saleslyear(store_statues):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues,
db.starting_day_of_lyear,
db.ltoday.strftime('%Y-%m-%d'))["sales"].sum())
def update_salescquarter(store_statues):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues,
db.first_day_of_the_quarter,
db.last_day_of_the_quarter)["sales"].sum())
def update_saleslquarter(store_statues):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues,
db.first_day_of_the_lquarter,
db.ltoday.strftime('%Y-%m-%d'))["sales"].sum())
def update_salescmonth(store_statues):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues,
db.first_day_of_month,
db.last_day_of_month)["sales"].sum())
def update_salescweek(store_statues):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues, db.startweeks,
db.endweeks)["sales"].sum())
def update_quantity(store_statues, start_date, end_date):
return db.filter_dataframe(db.return_quantity(), store_statues, start_date,
end_date)["quantity"].sum()
def update_sales(store_statues, start_date, end_date):
return "{:0,.2f}".format(
db.filter_dataframe(db.return_sales(), store_statues, start_date,
end_date)["sales"].sum())
def update_orders(store_statues, start_date, end_date):
return db.filter_dataframe(db.return_orders(), store_statues, start_date,
end_date)["orders"].sum()