We need a new report that takes a start_date and end_date (defaults to month boundaries) and displays a report of all revenue in that period.
Data Set: UserBill.objects.filter(due_date__range=(start_date,end_date))
Total: sum of bill amounts
Total Paid: sum of payments
Total Outstanding: difference (displayed and highlighted if not 0)
Memberships Total: sum of SubscriptionLineItems
Memberships by Resource: for each SubscriptionLineItem.resource
Overages Total: sum of CoworkingDayLineItems and EventLineItems
Coworking Overages: sum of CoworkingDayLineItems
Events/Meeting Overages: sum of EventLineItems
Non-Member Total: Bills where user is not an active member in the period
List all open or unpaid bills. A clean report shouldn't have any.
We need a new report that takes a start_date and end_date (defaults to month boundaries) and displays a report of all revenue in that period.
Data Set: UserBill.objects.filter(due_date__range=(start_date,end_date))
Total: sum of bill amounts Total Paid: sum of payments Total Outstanding: difference (displayed and highlighted if not 0) Memberships Total: sum of SubscriptionLineItems Memberships by Resource: for each SubscriptionLineItem.resource Overages Total: sum of CoworkingDayLineItems and EventLineItems Coworking Overages: sum of CoworkingDayLineItems Events/Meeting Overages: sum of EventLineItems Non-Member Total: Bills where user is not an active member in the period
List all open or unpaid bills. A clean report shouldn't have any.