X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/65c9feda79d2b2c94cb7dcd561318a83fd796f0a..48a6d2ddc3e5ce215beddd6369f01598651ad216:/src/club/models.py?ds=inline diff --git a/src/club/models.py b/src/club/models.py index 1f47d587b..c09769a95 100644 --- a/src/club/models.py +++ b/src/club/models.py @@ -1,79 +1,152 @@ +# This file is part of Wolne Lektury, licensed under GNU Affero GPLv3 or later. +# Copyright © Fundacja Wolne Lektury. 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.conf import settings from django.contrib.sites.models import Site -from django.core.mail import send_mail +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 get_language +from django_countries.fields import CountryField from catalogue.utils import get_random_hash -from .payment_methods import methods, method_by_slug +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 Plan(models.Model): - """ Plans are set up by administrators. """ - MONTH = 30 - YEAR = 365 - PERPETUAL = 999 - intervals = [ - (MONTH, _('a month')), - (YEAR, _('a year')), - (PERPETUAL, _('in perpetuity')), - ] - - interval = models.SmallIntegerField(_('inteval'), choices=intervals) - min_amount = models.DecimalField(_('min amount'), max_digits=10, decimal_places=2) - default_amount = models.DecimalField(_('default amount'), max_digits=10, decimal_places=2) - allow_recurring = models.BooleanField(_('allow recurring')) - allow_one_time = models.BooleanField(_('allow one time')) - active = models.BooleanField(_('active'), default=True) +class Club(models.Model): + min_amount = models.IntegerField('minimalna kwota') + min_for_year = models.IntegerField('minimalna kwota na rok') + default_single_amount = models.IntegerField('domyślna kwota dla pojedynczej wpłaty') + default_monthly_amount = models.IntegerField('domyślna kwota dla miesięcznych wpłat') class Meta: - verbose_name = _('plan') - verbose_name_plural = _('plans') - + verbose_name = 'towarzystwo' + verbose_name_plural = 'towarzystwa' + def __str__(self): - return "%s %s" % (self.min_amount, self.get_interval_display()) + 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 + +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 = ('interval',) + ordering = ['amount'] - def payment_methods(self): - for method in methods: - if self.allow_recurring and method.is_recurring or self.allow_one_time and not method.is_recurring: - yield method +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): + order = models.IntegerField() + active = models.BooleanField(default=True) + text = models.CharField(max_length=2048) + required = models.BooleanField() + + class Meta: + ordering = ['order'] + + def __str__(self): + return self.text - def get_next_installment(self, date): - if self.interval == self.PERPETUAL: - return datetime.max - timedelta(1) - elif self.interval == self.YEAR: - return date.replace(year=date.year + 1) - elif self.interval == self.MONTH: - day = date.day - date = (date.replace(day=1) + timedelta(31)).replace(day=1) + timedelta(day - 1) - if date.day != day: - date = date.replace(day=1) - return date - class Schedule(models.Model): """ Represents someone taking up a plan. """ - key = models.CharField(_('key'), max_length=255, unique=True) - email = models.EmailField(_('email')) - membership = models.ForeignKey('Membership', verbose_name=_('membership'), null=True, blank=True, on_delete=models.PROTECT) - plan = models.ForeignKey(Plan, verbose_name=_('plan'), on_delete=models.PROTECT) - amount = models.DecimalField(_('amount'), max_digits=10, decimal_places=2) - method = models.CharField(_('method'), max_length=255, choices=[(method.slug, method.name) for method in methods]) - is_cancelled = models.BooleanField(_('cancelled'), default=False) - started_at = models.DateTimeField(_('started at'), auto_now_add=True) - expires_at = models.DateTimeField(_('expires_at'), null=True, blank=True) + key = models.CharField('klucz', max_length=255, unique=True) + email = models.EmailField('e-mail') + membership = models.ForeignKey( + 'Membership', verbose_name='członkostwo', + null=True, blank=True, on_delete=models.SET_NULL) + amount = models.DecimalField('kwota', max_digits=10, decimal_places=2) + method = models.CharField('metoda płatności', max_length=32, choices=[ + (m.slug, m.name) for m in methods + ]) + monthly = models.BooleanField('miesięcznie', default=True) + yearly = models.BooleanField('rocznie', default=False) + + source = models.CharField('źródło', max_length=255, blank=True) + + is_cancelled = models.BooleanField('anulowany', default=False) + payed_at = models.DateTimeField('opłacona', null=True, blank=True) + started_at = models.DateTimeField('start', auto_now_add=True) + expires_at = models.DateTimeField('wygasa', null=True, blank=True) email_sent = models.BooleanField(default=False) + first_name = models.CharField(max_length=255, blank=True) + last_name = models.CharField(max_length=255, blank=True) + phone = models.CharField(max_length=255, blank=True) + postal = models.CharField(max_length=255, blank=True) + postal_code = models.CharField(max_length=255, blank=True) + postal_town = models.CharField(max_length=255, blank=True) + postal_country = CountryField(default='PL', blank=True) + + consent = models.ManyToManyField(Consent) + class Meta: - verbose_name = _('schedule') - verbose_name_plural = _('schedules') + verbose_name = 'harmonogram' + verbose_name_plural = 'harmonogramy' def __str__(self): return self.key @@ -81,7 +154,12 @@ class Schedule(models.Model): def save(self, *args, **kwargs): if not self.key: self.key = get_random_hash(self.email) - return super(Schedule, self).save(*args, **kwargs) + 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) @@ -96,14 +174,59 @@ class Schedule(models.Model): return reverse('club_thanks', args=[self.key]) def get_payment_method(self): - return method_by_slug[self.method] + 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() def is_active(self): - return self.expires_at is not None and self.expires_at > now() + return self.payed_at is not None and (self.expires_at is None or self.expires_at > now()) + def is_recurring(self): + return self.monthly or self.yearly + + def set_payed(self): + since = self.expires_at + n = now() + if since is None or since < n: + since = n + new_exp = self.get_next_installment(since) + if self.payed_at is None: + self.payed_at = n + if self.expires_at is None or self.expires_at < new_exp: + self.expires_at = new_exp + self.save() + + if not self.email_sent: + self.send_email() + + def get_next_installment(self, date): + if self.yearly: + return utils.add_year(date) + if self.monthly: + return utils.add_month(date) + club = Club.objects.first() + if club is not None and self.amount >= club.min_for_year: + 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( @@ -113,20 +236,64 @@ 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: + level = Level.TRIED + since = self.started_at + else: + since = self.payed_at + if self.is_recurring(): + level = Level.RECURRING + else: + level = Level.SINGLE + Contact.update(self.email, level, since, self.expires_at) + + + + class Membership(models.Model): """ Represents a user being recognized as a member of the club. """ - user = models.OneToOneField(settings.AUTH_USER_MODEL, verbose_name=_('user'), on_delete=models.CASCADE) - created_at = models.DateTimeField(_('created at'), auto_now_add=True) - name = models.CharField(max_length=255, blank=True) - honorary = models.BooleanField(default=False) + user = models.OneToOneField(settings.AUTH_USER_MODEL, verbose_name='użytkownik', on_delete=models.CASCADE) + created_at = models.DateTimeField('utworzone', auto_now_add=True) + name = models.CharField('nazwa', max_length=255, blank=True) + manual = models.BooleanField('ustawione ręcznie', default=False) + notes = models.CharField('notatki', max_length=2048, blank=True) + updated_at = models.DateField('aktualizacja', auto_now=True, blank=True) class Meta: - verbose_name = _('membership') - verbose_name_plural = _('memberships') + verbose_name = 'członkostwo' + verbose_name_plural = 'członkostwa' def __str__(self): - return u'tow. ' + str(self.user) + return str(self.user) + + def save(self, *args, **kwargs): + super().save(*args, **kwargs) + self.update_contact() + + def update_contact(self): + email = self.user.email + if not email: + return + + Contact = apps.get_model('messaging', 'Contact') + if self.manual: + Contact.update(email, Level.MANUAL_MEMBER, datetime.combine(self.updated_at, datetime.min.time(), utc)) + else: + Contact.reset(email) @classmethod def is_active_for(cls, user): @@ -136,7 +303,7 @@ class Membership(models.Model): membership = user.membership except cls.DoesNotExist: return False - if membership.honorary: + if membership.manual: return True return Schedule.objects.filter( expires_at__gt=now(), @@ -145,22 +312,36 @@ class Membership(models.Model): class ReminderEmail(models.Model): - days_before = models.SmallIntegerField(_('days before')) - subject = models.CharField(_('subject'), max_length=1024) - body = models.TextField(_('body')) + days_before = models.SmallIntegerField('dni przed') + subject = models.CharField('temat', max_length=1024) + body = models.TextField('treść') class Meta: - verbose_name = _('reminder email') - verbose_name_plural = _('reminder emails') + verbose_name = 'email z przypomnieniem' + verbose_name_plural = 'e-maile z przypomnieniem' ordering = ['days_before'] def __str__(self): if self.days_before >= 0: - return ungettext('a day before expiration', '%d days before expiration', n=self.days_before) + return '%d dni przed wygaśnięciem' % self.days_before else: - return ungettext('a day after expiration', '%d days after expiration', n=-self.days_before) + return '%d dni po wygaśnięciu' % -self.days_before + +class Ambassador(models.Model): + name = models.CharField('imię i nazwisko', max_length=255) + photo = models.ImageField('zdjęcie', blank=True) + text = models.CharField('tekst', max_length=1024) + class Meta: + verbose_name = 'ambasador' + verbose_name_plural = 'ambasadorowie' + ordering = ['name'] + + def __str__(self): + return self.name + + ######## # # # PayU # @@ -179,13 +360,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 Wolnych Lektur') + return 'Wolne Lektury' def is_recurring(self): return self.schedule.get_payment_method().is_recurring @@ -198,16 +374,138 @@ 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': - since = self.schedule.expires_at or now() - new_exp = self.schedule.plan.get_next_installment(since) - if self.schedule.expires_at is None or self.schedule.expires_at < new_exp: - self.schedule.expires_at = new_exp - self.schedule.save() - - if not self.schedule.email_sent: - self.schedule.send_email() + 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, 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, + completed_at__year=year, + notifications=True).order_by('completed_at').first() + if funding is None: + print('no notifications') + 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') + return + optout = contact.wl_optout_url() + + qs = cls.objects.filter(status='COMPLETED', schedule__email=email, completed_at__year=year).order_by('completed_at') + for order in qs: + payments.append({ + 'timestamp': order.completed_at, + '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, + completed_at__year=year + ).order_by('completed_at') + for funding in fundings: + payments.append({ + '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']) + + ctx = { + "email": email, + "year": year, + "next_year": year + 1, + "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, { + "wl.eps": os.path.join(settings.STATIC_ROOT, "img/wl.eps"), + }) + + message = EmailMessage( + 'Odlicz darowiznę na Wolne Lektury od podatku', + template.loader.render_to_string('club/receipt_email.txt', ctx), + settings.CLUB_CONTACT_EMAIL, [email] + ) + with open(temp.name, 'rb') as f: + message.attach('wolnelektury-darowizny.pdf', f.read(), 'application/pdf') + message.send() + os.unlink(f.name) class PayUCardToken(payu_models.CardToken):