# Copyright © Fundacja Nowoczesna Polska. See NOTICE for more information.
#
from datetime import datetime, timedelta
+from decimal import Decimal
import os
import tempfile
from django.apps import apps
from django.urls import reverse
from django.db import models
from django import template
-from django.utils.timezone import now
-from django.utils.translation import ugettext_lazy as _, ungettext, ugettext, get_language
+from django.utils.timezone import now, utc
+from django.utils.translation import gettext_lazy as _, ngettext, gettext, get_language
from django_countries.fields import CountryField
from catalogue.utils import get_random_hash
from messaging.states import Level
from reporting.utils import render_to_pdf
from .payment_methods import methods
from .payu import models as payu_models
+from .civicrm import report_activity
from . import utils
class Club(models.Model):
min_amount = models.IntegerField(_('minimum amount'))
min_for_year = models.IntegerField(_('minimum amount for year'))
- single_amounts = models.CharField(_('proposed amounts for single payment'), max_length=255)
default_single_amount = models.IntegerField(_('default single amount'))
- monthly_amounts = models.CharField(_('proposed amounts for monthly payments'), max_length=255)
default_monthly_amount = models.IntegerField(_('default monthly amount'))
class Meta:
def __str__(self):
return 'Klub'
+
+ def get_amounts(self):
+ c = {}
+ single = list(self.singleamount_set.all())
+ monthly = list(self.monthlyamount_set.all())
+ for tag, amounts in ('single', single), ('monthly', monthly):
+ wide_spot = narrow_spot = 0
+ for i, p in enumerate(amounts):
+ if p.description or p.wide:
+ if not p.description:
+ p.narrow_wide = True
+ if narrow_spot == 1:
+ amounts[i-1].narrow_wide = True
+ narrow_spot = 0
+ if p.wide:
+ if wide_spot == 2:
+ p.wide_not_wide = True
+ wide_spot += 1
+ else:
+ wide_spot += 2
+ else:
+ wide_spot += 1
+ wide_spot %= 3
+ c[tag] = amounts
+ c[f'{tag}_wide_spot'] = wide_spot
+ return c
+
- def proposed_single_amounts(self):
- return [int(x) for x in self.single_amounts.split(',')]
- def proposed_monthly_amounts(self):
- return [int(x) for x in self.monthly_amounts.split(',')]
+class SingleAmount(models.Model):
+ club = models.ForeignKey(Club, models.CASCADE)
+ amount = models.IntegerField()
+ description = models.TextField(blank=True)
+ wide = models.BooleanField(default=False)
+
+ class Meta:
+ ordering = ['amount']
+
+class MonthlyAmount(models.Model):
+ club = models.ForeignKey(Club, models.CASCADE)
+ amount = models.IntegerField()
+ description = models.TextField(blank=True)
+ wide = models.BooleanField(default=False)
+
+ class Meta:
+ ordering = ['amount']
class Consent(models.Model):
def get_payment_method(self):
return [m for m in methods if m.slug == self.method][0]
+ def get_payment_methods(self):
+ for method in methods:
+ if (self.monthly or self.yearly) and method.is_recurring:
+ yield method
+ elif not (self.monthly or self.yearly) and method.is_onetime:
+ yield method
+
def is_expired(self):
return self.expires_at is not None and self.expires_at <= now()
return utils.add_year(date)
return utils.add_month(date)
+ def get_other_active_recurring(self):
+ schedules = type(self).objects.exclude(
+ monthly=False, yearly=False
+ ).filter(is_cancelled=False, expires_at__gt=now()).exclude(pk=self.pk)
+ mine_q = models.Q(email=self.email)
+ if self.membership is not None:
+ mine_q |= models.Q(membership__user=self.membership.user)
+ schedules = schedules.filter(mine_q)
+ return schedules.order_by('-expires_at').first()
+
def send_email(self):
ctx = {'schedule': self}
send_mail(
self.email_sent = True
self.save()
+ def send_email_failed_recurring(self):
+ ctx = {
+ 'schedule': self,
+ 'other': self.get_other_active_recurring(),
+ }
+ send_mail(
+ 'Darowizna na Wolne Lektury — problem z płatnością',
+ template.loader.render_to_string('club/email/failed_recurring.txt', ctx),
+ settings.CONTACT_EMAIL, [self.email], fail_silently=False
+ )
+
def update_contact(self):
Contact = apps.get_model('messaging', 'Contact')
if not self.payed_at:
Contact = apps.get_model('messaging', 'Contact')
if self.manual:
- Contact.update(email, Level.MANUAL_MEMBER, self.updated_at)
+ Contact.update(email, Level.MANUAL_MEMBER, datetime.combine(self.updated_at, datetime.min.time(), utc))
else:
Contact.reset(email)
"language": get_language(),
}
- def get_continue_url(self):
- return "https://{}{}".format(
- Site.objects.get_current().domain,
- self.schedule.get_thanks_url())
-
def get_description(self):
- return ugettext('Towarzystwo Przyjaciół Wolnych Lektur')
+ return 'Wolne Lektury'
def is_recurring(self):
return self.schedule.get_payment_method().is_recurring
Site.objects.get_current().domain,
reverse('club_payu_notify', args=[self.pk]))
+ def get_thanks_url(self):
+ return self.schedule.get_thanks_url()
+
def status_updated(self):
if self.status == 'COMPLETED':
self.schedule.set_payed()
+
+ elif self.status == 'CANCELED' or self.status.startswith('ERR-'):
+ if self.is_recurring() and self.schedule.expires_at:
+ self.schedule.send_email_failed_recurring()
+ self.report_activity()
+
+ @property
+ def updated_at(self):
+ try:
+ return self.notification_set.all().order_by('-received_at')[0].received_at
+ except IndexError:
+ return None
+
+ def report_activity(self):
+ if self.status not in ['COMPLETED', 'CANCELED', 'REJECTED']:
+ return
+
+ if self.status != 'COMPLETED':
+ name = settings.CIVICRM_ACTIVITIES['Failed contribution']
+ elif self.is_recurring():
+ name = settings.CIVICRM_ACTIVITIES['Recurring contribution']
+ else:
+ name = settings.CIVICRM_ACTIVITIES['Contribution']
+
+ report_activity.delay(
+ self.schedule.email,
+ self.schedule.key,
+ f'payu:{self.id}',
+ name,
+ self.updated_at,
+ {
+ 'kwota': self.schedule.amount,
+ }
+ )
@classmethod
- def send_receipt(cls, email, year):
+ def send_receipt(cls, email, year, resend=False):
Contact = apps.get_model('messaging', 'Contact')
Funding = apps.get_model('funding', 'Funding')
+ BillingAgreement = apps.get_model('paypal', 'BillingAgreement')
+ DirectDebit = apps.get_model('pz', 'DirectDebit')
+ Payment = apps.get_model('pz', 'Payment')
+
payments = []
+ optout = None
try:
contact = Contact.objects.get(email=email)
except Contact.DoesNotExist:
funding = Funding.objects.filter(
email=email,
- payed_at__year=year,
- notifications=True).order_by('payed_at').first()
+ completed_at__year=year,
+ notifications=True).order_by('completed_at').first()
if funding is None:
print('no notifications')
- return
- optout = funding.wl_optout_url()
+ if not DirectDebit.objects.filter(email=email, optout=False).exists():
+ return
+ else:
+ optout = funding.wl_optout_url()
else:
if contact.level == Level.OPT_OUT:
print('opt-out')
'amount': order.get_amount(),
})
+ for ba in BillingAgreement.objects.filter(schedule__email=email):
+ payments.extend(ba.get_donations(year))
+
fundings = Funding.objects.filter(
email=email,
- payed_at__year=year
- ).order_by('payed_at')
+ completed_at__year=year
+ ).order_by('completed_at')
for funding in fundings:
payments.append({
- 'timestamp': funding.payed_at,
+ 'timestamp': funding.completed_at,
'amount': funding.amount,
})
+ for pa in Payment.objects.filter(
+ debit__email=email,
+ realised=True,
+ is_dd=True,
+ booking_date__year=year
+ ):
+ payments.append({
+ 'timestamp': datetime(pa.booking_date.year, pa.booking_date.month, pa.booking_date.day, tzinfo=utc),
+ 'amount': Decimal(str(pa.debit.amount) + '.00')
+ })
+
+
if not payments: return
payments.sort(key=lambda x: x['timestamp'])
"total": sum(x['amount'] for x in payments),
"payments": payments,
"optout": optout,
+ "resend": resend,
}
temp = tempfile.NamedTemporaryFile(prefix='receipt-', suffix='.pdf', delete=False)
temp.close()
render_to_pdf(temp.name, 'club/receipt.texml', ctx, {
- "fnp.eps": os.path.join(settings.STATIC_ROOT, "img/fnp.eps"),
+ "wl.eps": os.path.join(settings.STATIC_ROOT, "img/wl.eps"),
})
message = EmailMessage(
- f'Odlicz od podatku swoje darowizny przekazane dla Wolnych Lektur',
+ 'Odlicz darowiznę na Wolne Lektury od podatku',
template.loader.render_to_string('club/receipt_email.txt', ctx),
- settings.CONTACT_EMAIL, [email]
+ settings.CLUB_CONTACT_EMAIL, [email]
)
with open(temp.name, 'rb') as f:
message.attach('wolnelektury-darowizny.pdf', f.read(), 'application/pdf')
class PayUNotification(payu_models.Notification):
order = models.ForeignKey(PayUOrder, models.CASCADE, related_name='notification_set')
-
-
-class DirectDebit(models.Model):
- first_name = models.CharField(_('first name'), max_length=255, blank=True)
- last_name = models.CharField(_('last name'), max_length=255, blank=True)
- sex = models.CharField(_('sex'), max_length=1, blank=True, choices=[
- ('M', 'M'),
- ('F', 'F'),
- ])
- date_of_birth = models.DateField(_('date of birth'), null=True, blank=True)
- street = models.CharField(_('street'), max_length=255, blank=True)
- building = models.CharField(_('building'), max_length=255, blank=True)
- flat = models.CharField(_('flat'), max_length=255, blank=True)
- town = models.CharField(_('town'), max_length=255, blank=True)
- postal_code = models.CharField(_('postal code'), max_length=255, blank=True)
- phone = models.CharField(_('phone'), max_length=255, blank=True)
- email = models.CharField(_('e-mail'), max_length=255, blank=True)
- iban = models.CharField(_('IBAN'), max_length=255, blank=True)
- payment_id = models.CharField(_('payment identifier'), max_length=255, blank=True)
- agree_newsletter = models.BooleanField(_('agree newsletter'))
- date = models.DateField(_('date'))
- amount = models.IntegerField(_('amount'))
-
- class Meta:
- verbose_name = _('direct debit')
- verbose_name_plural = _('direct debits')
-