X-Git-Url: https://asedeno.scripts.mit.edu/gitweb/?a=blobdiff_plain;ds=sidebyside;f=bluechips%2Fcontrollers%2Fstatus.py;h=f3373ddc398ba93fcb3c6ebbc512d80be532189a;hb=3b864c81e804769f2be45b38c319895d1735aef9;hp=5d92d2f26194aa670ce2a887ee9732f35310ea2b;hpb=9bff8b8b19f3579d1ff654255e98826e7340a40e;p=bluechips.git diff --git a/bluechips/controllers/status.py b/bluechips/controllers/status.py index 5d92d2f..f3373dd 100644 --- a/bluechips/controllers/status.py +++ b/bluechips/controllers/status.py @@ -10,7 +10,8 @@ from bluechips.lib.totals import * import sqlalchemy from datetime import date, timedelta -from decimal import Decimal + +from bluechips.model.types import Currency from pylons import request @@ -49,7 +50,7 @@ class StatusController(BaseController): return render('/status/index.mako') def _total(self, where): - return (meta.Session.execute(sqlalchemy.sql.select([ + return Currency(meta.Session.execute(sqlalchemy.sql.select([ sqlalchemy.func.sum(model.expenditures.c.amount).\ label('total')]).\ - where(where)).scalar() or Decimal("0.00")) / 100 + where(where)).scalar() or 0)