For upgrades
[wolnelektury.git] / src / club / models.py
index 6fd58e0..8c6c8db 100644 (file)
-# This file is part of Wolnelektury, licensed under GNU Affero GPLv3 or later.
-# Copyright © Fundacja Nowoczesna Polska. See NOTICE for more information.
+# 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 datetime import datetime, timedelta, timezone
+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.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.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.translation import get_language
+from django_countries.fields import CountryField
 from catalogue.utils import get_random_hash
 from messaging.states import Level
 from catalogue.utils import get_random_hash
 from messaging.states import Level
-from .payment_methods import recurring_payment_method, single_payment_method
+from reporting.utils import render_to_pdf
+from .payment_methods import methods
 from .payu import models as payu_models
 from .payu import models as payu_models
+from .civicrm import report_activity
 from . import utils
 
 
 class Club(models.Model):
 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'))
+    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:
 
     class Meta:
-        verbose_name = _('club')
-        verbose_name_plural = _('clubs')
+        verbose_name = 'towarzystwo'
+        verbose_name_plural = 'towarzystwa'
     
     def __str__(self):
         return 'Klub'
     
     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):
+    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
 
 
 class Schedule(models.Model):
     """ Represents someone taking up a plan. """
 
 
 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)
-    amount = models.DecimalField(_('amount'), max_digits=10, decimal_places=2)
-    monthly = models.BooleanField(_('monthly'), default=True)
-    yearly = models.BooleanField(_('yearly'), default=False)
-    
-    is_cancelled = models.BooleanField(_('cancelled'), default=False)
-    payed_at = models.DateTimeField(_('payed at'), null=True, blank=True)
-    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)
 
     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:
     class Meta:
-        verbose_name = _('schedule')
-        verbose_name_plural = _('schedules')
+        verbose_name = 'harmonogram'
+        verbose_name_plural = 'harmonogramy'
 
     def __str__(self):
         return self.key
 
     def __str__(self):
         return self.key
@@ -68,6 +157,19 @@ class Schedule(models.Model):
         super(Schedule, self).save(*args, **kwargs)
         self.update_contact()
 
         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 is_custom_amount(self):
+        club = Club.objects.first()
+        if not self.amount:
+            return False
+        if self.monthly:
+            return not club.monthlyamount_set.filter(amount=self.amount).exists()
+        else:
+            return not club.singleamount_set.filter(amount=self.amount).exists()
+
     def initiate_payment(self, request):
         return self.get_payment_method().initiate(request, self)
 
     def initiate_payment(self, request):
         return self.get_payment_method().initiate(request, self)
 
@@ -81,7 +183,14 @@ class Schedule(models.Model):
         return reverse('club_thanks', args=[self.key])
 
     def get_payment_method(self):
         return reverse('club_thanks', args=[self.key])
 
     def get_payment_method(self):
-        return recurring_payment_method if self.monthly or self.yearly else single_payment_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_expired(self):
         return self.expires_at is not None and self.expires_at <= now()
@@ -92,6 +201,35 @@ class Schedule(models.Model):
     def is_recurring(self):
         return self.monthly or self.yearly
 
     def is_recurring(self):
         return self.monthly or self.yearly
 
+    def n_paypal_payments(self, since, until):
+        # TODO: pull BA payments.
+        t = self.payed_at
+        if t is None: return 0
+        c = 0
+        until = min(until, now())
+        t += timedelta(days=1)
+        while t < until:
+            if t >= since:
+                c += 1
+            m = datetime(t.year, t.month, 1)
+            t += ((m + timedelta(days=31)).replace(day=1)) - m
+        return c
+
+    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)
     def get_next_installment(self, date):
         if self.yearly:
             return utils.add_year(date)
@@ -102,6 +240,16 @@ class Schedule(models.Model):
             return utils.add_year(date)
         return utils.add_month(date)
 
             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(
     def send_email(self):
         ctx = {'schedule': self}
         send_mail(
@@ -111,6 +259,17 @@ class Schedule(models.Model):
         self.email_sent = True
         self.save()
 
         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:
     def update_contact(self):
         Contact = apps.get_model('messaging', 'Contact')
         if not self.payed_at:
@@ -125,20 +284,40 @@ class Schedule(models.Model):
         Contact.update(self.email, level, since, self.expires_at)
 
 
         Contact.update(self.email, level, since, self.expires_at)
 
 
+
+
+
 class Membership(models.Model):
     """ Represents a user being recognized as a member of the club. """
 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:
 
     class Meta:
-        verbose_name = _('membership')
-        verbose_name_plural = _('memberships')
+        verbose_name = 'członkostwo'
+        verbose_name_plural = 'członkostwa'
 
     def __str__(self):
         return str(self.user)
 
 
     def __str__(self):
         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(), timezone.utc))
+        else:
+            Contact.reset(email)
+
     @classmethod
     def is_active_for(cls, user):
         if user.is_anonymous:
     @classmethod
     def is_active_for(cls, user):
         if user.is_anonymous:
@@ -147,7 +326,7 @@ class Membership(models.Model):
             membership = user.membership
         except cls.DoesNotExist:
             return False
             membership = user.membership
         except cls.DoesNotExist:
             return False
-        if membership.honorary:
+        if membership.manual:
             return True
         return Schedule.objects.filter(
                 expires_at__gt=now(),
             return True
         return Schedule.objects.filter(
                 expires_at__gt=now(),
@@ -156,30 +335,30 @@ class Membership(models.Model):
 
 
 class ReminderEmail(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:
 
     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:
         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:
         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):
 
 
 class Ambassador(models.Model):
-    name = models.CharField(_('name'), max_length=255)
-    photo = models.ImageField(_('photo'), blank=True)
-    text = models.CharField(_('text'), max_length=1024)
+    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:
 
     class Meta:
-        verbose_name = _('ambassador')
-        verbose_name_plural = _('ambassadors')
+        verbose_name = 'ambasador'
+        verbose_name_plural = 'ambasadorowie'
         ordering = ['name']
     
     def __str__(self):
         ordering = ['name']
     
     def __str__(self):
@@ -204,13 +383,8 @@ class PayUOrder(payu_models.Order):
             "language": get_language(),
         }
 
             "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):
     def get_description(self):
-        return ugettext('Towarzystwo Wolnych Lektur')
+        return 'Wolne Lektury'
 
     def is_recurring(self):
         return self.schedule.get_payment_method().is_recurring
 
     def is_recurring(self):
         return self.schedule.get_payment_method().is_recurring
@@ -223,21 +397,155 @@ class PayUOrder(payu_models.Order):
             Site.objects.get_current().domain,
             reverse('club_payu_notify', args=[self.pk]))
 
             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':
     def status_updated(self):
         if self.status == 'COMPLETED':
-            since = self.schedule.expires_at
-            n = now()
-            if since is None or since < n:
-                since = n
-            new_exp = self.schedule.get_next_installment(since)
-            if self.schedule.payed_at is None:
-                self.schedule.payed_at = n
-            if self.schedule.expires_at is None or self.schedule.expires_at < new_exp:
-                self.schedule.expires_at = new_exp
-                self.schedule.save()
+            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 generate_receipt(cls, email, year):
+        # TODO: abstract out
+        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 = []
 
 
-            if not self.schedule.email_sent:
-                self.schedule.send_email()
+        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=timezone.utc),
+                'amount': Decimal(str(pa.debit.amount) + '.00')
+            })
+
+    
+        if not payments: return
+
+        payments.sort(key=lambda x: x['timestamp'])
+
+        ctx = {
+            "email": email,
+            "year": year,
+            "total": sum(x['amount'] for x in payments),
+            "payments": payments,
+        }
+        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"),
+            })
+
+        with open(temp.name, 'rb') as f:
+            content = f.read()
+        os.unlink(f.name)
+        return content, optout, payments
+
+    @classmethod
+    def send_receipt(cls, email, year, resend=False):
+        receipt = cls.generate_receipt(email, year)
+        if receipt:
+            content, optout, payments = receipt
+        else:
+            return
+        ctx = {
+            "email": email,
+            "year": year,
+            "next_year": year + 1,
+            "total": sum(x['amount'] for x in payments),
+            "payments": payments,
+            "optout": optout,
+            "resend": resend,
+        }
+        message = EmailMessage(
+                'Odlicz darowiznę na Wolne Lektury od podatku',
+                template.loader.render_to_string('club/receipt_email.txt', ctx),
+                settings.CLUB_CONTACT_EMAIL, [email]
+            )
+        message.attach('wolnelektury-darowizny.pdf', content, 'application/pdf')
+        message.send()
 
 
 class PayUCardToken(payu_models.CardToken):
 
 
 class PayUCardToken(payu_models.CardToken):
@@ -246,5 +554,3 @@ class PayUCardToken(payu_models.CardToken):
 
 class PayUNotification(payu_models.Notification):
     order = models.ForeignKey(PayUOrder, models.CASCADE, related_name='notification_set')
 
 class PayUNotification(payu_models.Notification):
     order = models.ForeignKey(PayUOrder, models.CASCADE, related_name='notification_set')
-
-