X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/7ad1e269182ce7d30dc5aa96b9b0f2c9427dac95..3286cd61909f63baf8b4b655d69e91bbde00e08c:/src/pz/models.py?ds=inline

diff --git a/src/pz/models.py b/src/pz/models.py
index 8b6db0e35..45e6c6208 100644
--- a/src/pz/models.py
+++ b/src/pz/models.py
@@ -1,15 +1,18 @@
+import re
 from django.db import models
+from django.utils.timezone import now
 from django.utils.translation import ugettext_lazy as _
+from .bank import parse_export_feedback
 
 
 class Campaign(models.Model):
     name = models.CharField(_('name'), max_length=255, unique=True)
     description = models.TextField(_('description'), blank=True)
 
-    class Meta: 
+    class Meta:
         verbose_name = _('campaign')
         verbose_name_plural = _('campaigns')
-   
+
     def __str__(self):
         return self.name
 
@@ -17,7 +20,7 @@ class Campaign(models.Model):
 class Fundraiser(models.Model):
     name = models.CharField(_('name'), max_length=255, unique=True)
 
-    class Meta: 
+    class Meta:
         verbose_name = _('fundraiser')
         verbose_name_plural = _('fundraisers')
 
@@ -61,7 +64,7 @@ class DirectDebit(models.Model):
     notes = models.TextField(_('notes'), blank=True)
 
     needs_redo = models.BooleanField(_('needs redo'), default=False)
-    is_cancelled = models.BooleanField(_('is cancelled'), default=False)
+    cancelled_at = models.DateTimeField(_('cancelled at'), null=True, blank=True)
     optout = models.BooleanField(_('optout'), default=False)
 
     campaign = models.ForeignKey(Campaign, models.PROTECT, null=True, blank=True, verbose_name=_('campaign'))
@@ -70,6 +73,9 @@ class DirectDebit(models.Model):
         verbose_name = _('direct debit')
         verbose_name_plural = _('direct debits')
 
+    def __str__(self):
+        return self.payment_id
+
     def save(self, **kwargs):
         self.iban_valid = not self.iban_warning() if self.iban else None
         super().save(**kwargs)
@@ -93,6 +99,20 @@ class DirectDebit(models.Model):
                 break
         return payment_id
 
+    @property
+    def full_name(self):
+        return ' '.join((self.first_name, self.last_name)).strip()
+
+    @property
+    def street_address(self):
+        street_addr = self.street
+        if self.building:
+            street_addr += ' ' + self.building
+        if self.flat:
+            street_addr += ' m. ' + self.flat
+        street_addr = street_addr.strip()
+        return street_addr
+
     def iban_warning(self):
         if not self.iban:
             return 'No IBAN'
@@ -102,3 +122,41 @@ class DirectDebit(models.Model):
             return 'This IBAN number looks invalid'
         return ''
     iban_warning.short_description = ''
+
+
+class BankExportFeedback(models.Model):
+    created_at = models.DateTimeField(auto_now_add=True)
+    csv = models.FileField(upload_to='pz/feedback/')
+
+    def save(self, **kwargs):
+        super().save(**kwargs)
+        for payment_id, status, comment in parse_export_feedback(self.csv):
+            debit = DirectDebit.objects.get(payment_id = payment_id)
+            b, created = self.bankexportfeedbackline_set.get_or_create(
+                debit=debit,
+                defaults={
+                    "status": status,
+                    "comment": comment,
+                }
+            )
+            if not created:
+                b.status = status
+                b.comment = comment
+                b.save()
+            if status == 1 and not debit.bank_acceptance_date:
+                debit.bank_acceptance_date = now().date()
+                debit.save()
+
+
+class BankExportFeedbackLine(models.Model):
+    feedback = models.ForeignKey(BankExportFeedback, models.CASCADE)
+    debit = models.ForeignKey(DirectDebit, models.CASCADE)
+    status = models.SmallIntegerField()
+    comment = models.CharField(max_length=255)
+
+
+
+class BankOrder(models.Model):
+    payment_date = models.DateField(null=True, blank=True)
+    sent = models.DateTimeField(null=True, blank=True)
+    debits = models.ManyToManyField(DirectDebit, blank=True)