Add function to send TransferWise monthly statements to treasurer

TransferWise doesn't send statements automatically, and downloading them
is limited by the single-user-per-account-system. But since their API
allows downloading of a PDF statement between arbitrary dates, use that
to download the statements once per month and email them as an
attachment.

The function is optional and turned on/off on a per-paymentmethod basis.

1 files changed, 12 insertions, 0 deletions

diff --git a/postgresqleu/transferwise/models.py b/postgresqleu/transferwise/models.py
index 4c4382d3..fbca49ad 100644
--- a/postgresqleu/transferwise/models.py
+++ b/postgresqleu/transferwise/models.py
@@ -52,3 +52,15 @@ class TransferwisePayout(models.Model):
     sentat = models.DateTimeField(null=True, blank=True)
     completedat = models.DateTimeField(null=True, blank=True)
     completedtrans = models.ForeignKey(TransferwiseTransaction, blank=True, null=True)
+
+
+class TransferwiseMonthlyStatement(models.Model):
+    paymentmethod = models.ForeignKey(InvoicePaymentMethod, blank=False, null=False)
+    month = models.DateField(null=False, blank=False)
+    downloaded = models.DateTimeField(null=False, blank=False, auto_now_add=True)
+    contents = models.BinaryField(null=False)
+
+    class Meta:
+        unique_together = (
+            ('month', 'paymentmethod'),
+        )