+ year = options['year']
+ emails = set(
+ PayUOrder.objects.filter(
+ completed_at__year=year
+ ).order_by('schedule__email').values_list(
+ 'schedule__email', flat=True
+ ).distinct()
+ )
+ emails.update(
+ BillingAgreement.objects.all().order_by(
+ 'schedule__email').values_list(
+ 'schedule__email', flat=True
+ ).distinct()
+ )
+ emails.update(
+ Funding.objects.exclude(email='').filter(
+ completed_at__year=year
+ ).order_by('email').values_list(
+ 'email', flat=True
+ ).distinct()
+ )
+ emails.update(
+ Payment.objects.exclude(debit__email='').filter(
+ realised=True,
+ is_dd=True,
+ booking_date__year=year,
+ ).order_by('debit__email').values_list(
+ 'debit__email', flat=True
+ ).distinct()
+ )
+
+ if options['emails']:
+ emails = options['emails'].split(',')
+
+ for email in emails: