def index(self): c = TemplateContext() c.heading = _('Statistics') c.members = len(self.mf.getUserList()) activeMembers = self.mf.getActiveMemberList() c.activeMembers = len(activeMembers) c.formerMembers = c.members - c.activeMembers c.paymentsOk = 0 for uid in activeMembers: last_payment = None try: last_payment = self.db.query(Payment).filter( and_(Payment.uid == uid, Payment.verified == 1)).order_by( Payment.date.desc()).limit(1)[0] except Exception as e: ''' Don't care if there is no payment ''' pass if last_payment: d = last_payment.date today = datetime.datetime.now().date() if d.year > today.year or (d.year == today.year and d.month >= today.month): c.paymentsOk += 1 c.paymentsNotOk = c.activeMembers - c.paymentsOk return self.render('/statistics/index.mako', template_context=c)
def index(self): c = TemplateContext() c.heading = _("Statistics") c.members = len(self.mf.getUserList()) activeMembers = self.mf.getActiveMemberList() c.activeMembers = len(activeMembers) c.formerMembers = c.members - c.activeMembers c.paymentsOk = 0 for uid in activeMembers: last_payment = None try: last_payment = ( self.db.query(Payment) .filter(and_(Payment.uid == uid, Payment.verified == 1)) .order_by(Payment.date.desc()) .limit(1)[0] ) except Exception as e: """ Don't care if there is no payment """ pass if last_payment: d = last_payment.date today = datetime.datetime.now().date() if d.year > today.year or (d.year == today.year and d.month >= today.month): c.paymentsOk += 1 c.paymentsNotOk = c.activeMembers - c.paymentsOk return self.render("/statistics/index.mako", template_context=c)