X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/3f527019946f993c9d1cadd41e80c2c7eac188ed..a9226097c8eea0591fd3249f62a71becc6d2be93:/src/club/models.py diff --git a/src/club/models.py b/src/club/models.py index 77d1bb260..8fe3e4798 100644 --- a/src/club/models.py +++ b/src/club/models.py @@ -2,6 +2,7 @@ # 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 @@ -11,23 +12,22 @@ from django.core.mail import send_mail, EmailMessage 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: @@ -36,12 +36,67 @@ class Club(models.Model): 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.wide: + # Do we have space for xl? + if wide_spot < 2: + p.box_variant = 'xl' + wide_spot += 2 + else: + p.box_variant = 'card' + wide_spot += 1 + narrow_spot = 0 + elif p.description: + p.box_variant = 'card' + if narrow_spot: + amounts[i-1].box_variant = 'bar' + wide_spot += 1 + narrow_spot = 0 + else: + p.box_variant = 'half' + wide_spot += 1 + narrow_spot += 1 + wide_spot %= 3 + narrow_spot %= 2 + c[tag] = amounts + c[f'{tag}_wide_spot'] = wide_spot + return c + + def get_description_for_amount(self, amount, monthly): + amounts = self.monthlyamount_set if monthly else self.singleamount_set + amount = amounts.all().filter(amount__lte=amount).last() + return amount.description if amount is not None else '' + + @property + def paypal_enabled(self): + print("ENABLED?", settings.PAYPAL_ENABLED) + return settings.PAYPAL_ENABLED - 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): @@ -100,6 +155,10 @@ class Schedule(models.Model): super(Schedule, self).save(*args, **kwargs) self.update_contact() + def get_description(self): + club = Club.objects.first() + return club.get_description_for_amount(self.amount, self.monthly) + def initiate_payment(self, request): return self.get_payment_method().initiate(request, self) @@ -115,6 +174,13 @@ class Schedule(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() @@ -149,6 +215,16 @@ class Schedule(models.Model): 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( @@ -158,6 +234,17 @@ class Schedule(models.Model): 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: @@ -202,7 +289,7 @@ class Membership(models.Model): 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) @@ -271,13 +358,8 @@ class PayUOrder(payu_models.Order): "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 @@ -290,28 +372,72 @@ class PayUOrder(payu_models.Order): 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') @@ -325,16 +451,31 @@ class PayUOrder(payu_models.Order): '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']) @@ -346,17 +487,18 @@ class PayUOrder(payu_models.Order): "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') @@ -370,30 +512,3 @@ class PayUCardToken(payu_models.CardToken): 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') -