def getAllTransactions(orderby="dated"):
"""Retourne tous les transactions présentes dans la base"""
db = dbUtils.createConnexion()
if orderby == "dated":
orderby = "dated DESC"
else:
orderby = orderby + " ASC"
allTransactions = db.select("transactions", order=orderby)
categoriesList = category.getAllCategories()
transactions = []
for transaction in allTransactions:
myCategory = categoriesList[transaction["categoryID"]]
transaction["category"] = myCategory
transactions.append(transaction)
return transactions
def getCategoriesStats(dateDebut, dateFin):
"""Récupère les stats pour les catégories // calcule la répartition par catégorie"""
transactions = transaction.getTransactionsByDate(dateDebut, dateFin)
categoriesList = category.getAllCategories()
stats = [{},{}]
for myTransaction in transactions:
myCategory = categoriesList[myTransaction["categoryID"]]
value = int(myTransaction["value"])
if value > 0:
n = 1
else:
value = 0 - value
n = 0
if myCategory in stats[n].keys():
stats[n][myCategory] = stats[n][myCategory] + 1
else:
stats[n][myCategory] = 1
return stats
