"""
import logging
+from pylons import request
from bluechips.lib.base import *
from bluechips.lib.totals import *
-import sqlalchemy
+import sqlalchemy as sa
from sqlalchemy import orm
log = logging.getLogger(__name__)
def index(self):
c.title = 'History'
+ c.tags = meta.Session.query(model.Tag).order_by([sa.func.lower(model.Tag.name)])
c.expenditures = meta.Session.query(model.Expenditure).\
options(orm.eagerload('splits')).all()
c.transfers = meta.Session.query(model.Transfer).all()
return render('/history/index.mako')
+
+
+ def tag(self, id=None):
+ c.title = 'History'
+
+ c.tags = meta.Session.query(model.Tag).order_by([sa.func.lower(model.Tag.name)])
+ c.tag = meta.Session.query(model.Tag).filter_by(id=id).all()[0]
+ c.expenditures = c.tag.expenditures
+ c.total = sum([e.amount for e in c.expenditures])
+ c.share = sum([e.share(request.environ['user']) for e in c.expenditures])
+
+ return render('/history/tag.mako')