src/club/models.py

   1 # This file is part of Wolnelektury, licensed under GNU Affero GPLv3 or later.
   2 # Copyright © Fundacja Nowoczesna Polska. See NOTICE for more information.
   3 #
   4 from datetime import datetime, timedelta
   5 import os
   6 import tempfile
   7 from django.apps import apps
   8 from django.conf import settings
   9 from django.contrib.sites.models import Site
  10 from django.core.mail import send_mail, EmailMessage
  11 from django.urls import reverse
  12 from django.db import models
  13 from django import template
  14 from django.utils.timezone import now
  15 from django.utils.translation import ugettext_lazy as _, ungettext, ugettext, get_language
  16 from catalogue.utils import get_random_hash
  17 from messaging.states import Level
  18 from reporting.utils import render_to_pdf
  19 from .payment_methods import recurring_payment_method, single_payment_method
  20 from .payu import models as payu_models
  21 from . import utils
  22
  23
  24 class Club(models.Model):
  25     min_amount = models.IntegerField(_('minimum amount'))
  26     min_for_year = models.IntegerField(_('minimum amount for year'))
  27     single_amounts = models.CharField(_('proposed amounts for single payment'), max_length=255)
  28     default_single_amount = models.IntegerField(_('default single amount'))
  29     monthly_amounts = models.CharField(_('proposed amounts for monthly payments'), max_length=255)
  30     default_monthly_amount = models.IntegerField(_('default monthly amount'))
  31
  32     class Meta:
  33         verbose_name = _('club')
  34         verbose_name_plural = _('clubs')
  35
  36     def __str__(self):
  37         return 'Klub'
  38
  39     def proposed_single_amounts(self):
  40         return [int(x) for x in self.single_amounts.split(',')]
  41
  42     def proposed_monthly_amounts(self):
  43         return [int(x) for x in self.monthly_amounts.split(',')]
  44
  45
  46 class Schedule(models.Model):
  47     """ Represents someone taking up a plan. """
  48     key = models.CharField(_('key'), max_length=255, unique=True)
  49     email = models.EmailField(_('email'))
  50     membership = models.ForeignKey('Membership', verbose_name=_('membership'), null=True, blank=True, on_delete=models.PROTECT)
  51     amount = models.DecimalField(_('amount'), max_digits=10, decimal_places=2)
  52     monthly = models.BooleanField(_('monthly'), default=True)
  53     yearly = models.BooleanField(_('yearly'), default=False)
  54
  55     is_cancelled = models.BooleanField(_('cancelled'), default=False)
  56     payed_at = models.DateTimeField(_('payed at'), null=True, blank=True)
  57     started_at = models.DateTimeField(_('started at'), auto_now_add=True)
  58     expires_at = models.DateTimeField(_('expires_at'), null=True, blank=True)
  59     email_sent = models.BooleanField(default=False)
  60
  61     class Meta:
  62         verbose_name = _('schedule')
  63         verbose_name_plural = _('schedules')
  64
  65     def __str__(self):
  66         return self.key
  67
  68     def save(self, *args, **kwargs):
  69         if not self.key:
  70             self.key = get_random_hash(self.email)
  71         super(Schedule, self).save(*args, **kwargs)
  72         self.update_contact()
  73
  74     def initiate_payment(self, request):
  75         return self.get_payment_method().initiate(request, self)
  76
  77     def pay(self, request):
  78         return self.get_payment_method().pay(request, self)
  79
  80     def get_absolute_url(self):
  81         return reverse('club_schedule', args=[self.key])
  82
  83     def get_thanks_url(self):
  84         return reverse('club_thanks', args=[self.key])
  85
  86     def get_payment_method(self):
  87         return recurring_payment_method if self.monthly or self.yearly else single_payment_method
  88
  89     def is_expired(self):
  90         return self.expires_at is not None and self.expires_at <= now()
  91
  92     def is_active(self):
  93         return self.payed_at is not None and (self.expires_at is None or self.expires_at > now())
  94
  95     def is_recurring(self):
  96         return self.monthly or self.yearly
  97
  98     def get_next_installment(self, date):
  99         if self.yearly:
 100             return utils.add_year(date)
 101         if self.monthly:
 102             return utils.add_month(date)
 103         club = Club.objects.first()
 104         if club is not None and self.amount >= club.min_for_year:
 105             return utils.add_year(date)
 106         return utils.add_month(date)
 107
 108     def send_email(self):
 109         ctx = {'schedule': self}
 110         send_mail(
 111             template.loader.render_to_string('club/email/thanks_subject.txt', ctx).strip(),
 112             template.loader.render_to_string('club/email/thanks.txt', ctx),
 113             settings.CONTACT_EMAIL, [self.email], fail_silently=False)
 114         self.email_sent = True
 115         self.save()
 116
 117     def update_contact(self):
 118         Contact = apps.get_model('messaging', 'Contact')
 119         if not self.payed_at:
 120             level = Level.TRIED
 121             since = self.started_at
 122         else:
 123             since = self.payed_at
 124             if self.is_recurring():
 125                 level = Level.RECURRING
 126             else:
 127                 level = Level.SINGLE
 128         Contact.update(self.email, level, since, self.expires_at)
 129
 130
 131 class Membership(models.Model):
 132     """ Represents a user being recognized as a member of the club. """
 133     user = models.OneToOneField(settings.AUTH_USER_MODEL, verbose_name=_('user'), on_delete=models.CASCADE)
 134     created_at = models.DateTimeField(_('created at'), auto_now_add=True)
 135     name = models.CharField(max_length=255, blank=True)
 136     honorary = models.BooleanField(default=False)
 137
 138     class Meta:
 139         verbose_name = _('membership')
 140         verbose_name_plural = _('memberships')
 141
 142     def __str__(self):
 143         return str(self.user)
 144
 145     @classmethod
 146     def is_active_for(cls, user):
 147         if user.is_anonymous:
 148             return False
 149         try:
 150             membership = user.membership
 151         except cls.DoesNotExist:
 152             return False
 153         if membership.honorary:
 154             return True
 155         return Schedule.objects.filter(
 156                 expires_at__gt=now(),
 157                 membership__user=user,
 158             ).exists()
 159
 160
 161 class ReminderEmail(models.Model):
 162     days_before = models.SmallIntegerField(_('days before'))
 163     subject = models.CharField(_('subject'), max_length=1024)
 164     body = models.TextField(_('body'))
 165
 166     class Meta:
 167         verbose_name = _('reminder email')
 168         verbose_name_plural = _('reminder emails')
 169         ordering = ['days_before']
 170
 171     def __str__(self):
 172         if self.days_before >= 0:
 173             return ungettext('a day before expiration', '%d days before expiration', n=self.days_before)
 174         else:
 175             return ungettext('a day after expiration', '%d days after expiration', n=-self.days_before)
 176
 177
 178 class Ambassador(models.Model):
 179     name = models.CharField(_('name'), max_length=255)
 180     photo = models.ImageField(_('photo'), blank=True)
 181     text = models.CharField(_('text'), max_length=1024)
 182
 183     class Meta:
 184         verbose_name = _('ambassador')
 185         verbose_name_plural = _('ambassadors')
 186         ordering = ['name']
 187
 188     def __str__(self):
 189         return self.name
 190
 191
 192 ########
 193 #      #
 194 # PayU #
 195 #      #
 196 ########
 197
 198 class PayUOrder(payu_models.Order):
 199     schedule = models.ForeignKey(Schedule, on_delete=models.CASCADE)
 200
 201     def get_amount(self):
 202         return self.schedule.amount
 203
 204     def get_buyer(self):
 205         return {
 206             "email": self.schedule.email,
 207             "language": get_language(),
 208         }
 209
 210     def get_continue_url(self):
 211         return "https://{}{}".format(
 212             Site.objects.get_current().domain,
 213             self.schedule.get_thanks_url())
 214
 215     def get_description(self):
 216         return ugettext('Towarzystwo Przyjaciół Wolnych Lektur')
 217
 218     def is_recurring(self):
 219         return self.schedule.get_payment_method().is_recurring
 220
 221     def get_card_token(self):
 222         return self.schedule.payucardtoken_set.order_by('-created_at').first()
 223
 224     def get_notify_url(self):
 225         return "https://{}{}".format(
 226             Site.objects.get_current().domain,
 227             reverse('club_payu_notify', args=[self.pk]))
 228
 229     def status_updated(self):
 230         if self.status == 'COMPLETED':
 231             since = self.schedule.expires_at
 232             n = now()
 233             if since is None or since < n:
 234                 since = n
 235             new_exp = self.schedule.get_next_installment(since)
 236             if self.schedule.payed_at is None:
 237                 self.schedule.payed_at = n
 238             if self.schedule.expires_at is None or self.schedule.expires_at < new_exp:
 239                 self.schedule.expires_at = new_exp
 240                 self.schedule.save()
 241
 242             if not self.schedule.email_sent:
 243                 self.schedule.send_email()
 244
 245     @classmethod
 246     def send_receipt(cls, email, year):
 247         qs = cls.objects.filter(status='COMPLETED', schedule__email=email, completed_at__year=year).order_by('completed_at')
 248         if not qs.exists(): return
 249         ctx = {
 250             "email": email,
 251             "year": year,
 252             "next_year": year + 1,
 253             "total": qs.aggregate(s=models.Sum('schedule__amount'))['s'],
 254             "orders": qs,
 255         }
 256         temp = tempfile.NamedTemporaryFile(prefix='receipt-', suffix='.pdf', delete=False)
 257         temp.close()
 258         render_to_pdf(temp.name, 'club/receipt.texml', ctx, {
 259             "fnp.eps": os.path.join(settings.STATIC_ROOT, "img/fnp.eps"),
 260             })
 261
 262         message = EmailMessage(
 263                 f'Odlicz od podatku swoje darowizny przekazane dla Wolnych Lektur',
 264                 template.loader.render_to_string('club/receipt_email.txt', ctx),
 265                 settings.CONTACT_EMAIL, [email]
 266             )
 267         with open(temp.name, 'rb') as f:
 268             message.attach('wolnelektury-darowizny.pdf', f.read(), 'application/pdf')
 269         message.send()
 270         os.unlink(f.name)
 271
 272
 273 class PayUCardToken(payu_models.CardToken):
 274     schedule = models.ForeignKey(Schedule, on_delete=models.CASCADE)
 275
 276
 277 class PayUNotification(payu_models.Notification):
 278     order = models.ForeignKey(PayUOrder, models.CASCADE, related_name='notification_set')
 279
 280