+
+
+@register.simple_tag
+def club_count_recurring():
+ return Schedule.objects.exclude(monthly=False, yearly=False).filter(expires_at__gt=now()).count()
+
+@register.simple_tag
+def club_active_monthly_count():
+ return Schedule.objects.filter(
+ expires_at__gt=now(),
+ monthly=True,
+ is_cancelled=False
+ ).count()
+
+@register.simple_tag
+def club_active_monthly_sum():
+ return Schedule.objects.filter(
+ expires_at__gt=now(),
+ monthly=True,
+ is_cancelled=False
+ ).aggregate(s=Sum('amount'))['s'] or 0
+
+@register.simple_tag
+def club_active_yearly_count():
+ return Schedule.objects.filter(
+ expires_at__gt=now(),
+ yearly=True,
+ is_cancelled=False
+ ).count()
+
+@register.simple_tag
+def club_active_yearly_sum():
+ return Schedule.objects.filter(
+ expires_at__gt=now(),
+ yearly=True,
+ is_cancelled=False
+ ).aggregate(s=Sum('amount'))['s'] or 0
+
+@register.simple_tag
+def club_active_30day_count():
+ return Schedule.objects.filter(
+ yearly=False, monthly=False,
+ payed_at__gte=now() - timedelta(days=30)
+ ).count()
+
+@register.simple_tag
+def club_active_30day_sum():
+ return Schedule.objects.filter(
+ yearly=False, monthly=False,
+ payed_at__gte=now() - timedelta(days=30)
+ ).aggregate(s=Sum('amount'))['s'] or 0
+
+
+@register.simple_tag
+def club_monthly_since(start):
+ return Schedule.objects.filter(
+ monthly=True, payed_at__gte=start).count()
+
+
+@register.simple_tag
+def club_monthly_missing_since(start, target):
+ return target - Schedule.objects.filter(
+ monthly=True, payed_at__gte=start).count()