Find all customers with a balance due

[smirolo]

Create a page and API endpoint for a provider to find all subscribers with a balance due.

References:

• https://djaodjin-saas.readthedocs.io/en/latest/ledger.html
• https://github.com/djaodjin/djaodjin-saas/blob/45def252d7694073b19c0837614bd414161fa700/saas/models.py#L3534
• https://www.djaodjin.com/docs/guides/accounts/

[Deep-Chill]

Potential approach:

New View: SubscribersWithBalanceDueView

• Inherits from:
  • OrganizationSmartListMixin
  • For search and ordering
  • SubscribersQuerysetMixin
  • Filters organizations that are subscribed to the provider
  • ListAPIView
  • A basic API view for listing items.
• Serializer_class: OrganizationWithBalanceDueSerializer
• Filter_backends: (SearchFilter, OrderingFilter)
• Get_queryset:
  • Subscribed_organizations: Gets list of subscribed organizations to that organization from super SubscriberQuerysetMixin
  • Organizations_with_balance_due_ids: List of ids of organizations with balances due
  • For loop: For each organization that is subscribed to you, find balances due, if a balance exists, add the ID of the organization to the list above(Maybe this can be optimized better)
  • Return organizations with ids in the list above, which would be subscribers with due balances

New Serializer: OrganizationWithBalanceDueSerializer

• Inherits from:
  • OrganizationWithSubscriptionsSerializer:
  • Provides operational information on an Organization, bundled with its subscriptions.
• balance_due = serializers.SerializerMethodField()
  • uses Transaction.objects.get_statement_balances(obj, until=until) for subscribers
• def get_balance_due
  • Calculate the balance due for a specific organization (obj)
• Class Meta: OrganizationSerializer.Meta
  • Inherits the metadata settings from the parent serializer, OrganizationSerializer

Then an API URL