X-Git-Url: https://asedeno.scripts.mit.edu/gitweb/?a=blobdiff_plain;f=bluechips%2Fcontrollers%2Fstatus.py;h=faadfc5085b318fbaf2ed65dc74563eff14d9888;hb=512db6643a148932d6f734972f23ddf55a2e91ac;hp=37992e59964d7b9d077644e56624b662c82c7bdc;hpb=6811597bfdbf2dfb83694c34655066a98e7915cd;p=bluechips.git diff --git a/bluechips/controllers/status.py b/bluechips/controllers/status.py index 37992e5..faadfc5 100644 --- a/bluechips/controllers/status.py +++ b/bluechips/controllers/status.py @@ -12,6 +12,8 @@ import sqlalchemy from datetime import date, timedelta from decimal import Decimal +from pylons import request + log = logging.getLogger(__name__) class StatusController(BaseController): @@ -19,7 +21,6 @@ class StatusController(BaseController): c.debts = debts() c.settle = settle(c.debts) - c.total = self._total(True) year = date.today() - timedelta(days=365) @@ -36,6 +37,15 @@ class StatusController(BaseController): model.expenditures.c.date >= last_month, model.expenditures.c.date < this_month)) + c.expenditures = meta.Session.query(model.Expenditure).\ + filter(model.Expenditure.spender==request.environ['user']).\ + limit(10).all() + c.transfers = meta.Session.query(model.Transfer).\ + filter(sqlalchemy.or_( + model.Transfer.debtor==request.environ['user'], + model.Transfer.creditor==request.environ['user'])).\ + limit(10).all() + return render('/status/index.mako') def _total(self, where):