import csv
+from datetime import datetime
from io import StringIO
from django.conf import settings
from django.http import HttpResponse
response = HttpResponse(content_type='text/csv; charset=cp1250')
response['Content-Disposition'] = 'attachment; filename=export.csv'
writer = csv.writer(response)
- writer.writerow([
- 'Identyfikator płatności (IDP)',
- 'Nazwa Płatnika',
- '',
- 'Adres Płatnika Ulica + numer domu',
- 'Adres Płatnika kod+miejscowość',
- 'Numer kierunkowy banku Płatnika',
- 'Numer rachunku bankowego Płatnika',
- 'Identyfikator Odbiorcy (NIP Odbiorcy)',
- 'Osobowość prawna Płatnika (Osoba fizyczna)'
- ])
-
- # TODO: ansi encoding
for obj in queryset:
writer.writerow([
return response
+def parse_payment_feedback(f):
+ lines = csv.reader(StringIO(f.read().decode('cp1250')))
+ for line in lines:
+ print(line)
+ assert line[0] in ('1', '2')
+ if line[0] == '1':
+ # Totals line.
+ continue
+ booking_date = line[3]
+ booking_date = datetime.strptime(booking_date, '%Y%m%d')
+ payment_id = line[7]
+ is_dd = line[16] == 'DD'
+ realised = line[17] == '1'
+ reject_code = line[18]
+ yield payment_id, booking_date, is_dd, realised, reject_code
+
+
+
+
def parse_export_feedback(f):
+ # The AU file.
lines = csv.reader(StringIO(f.read().decode('cp1250')))
for line in lines:
payment_id = line[0]
yield payment_id, status, comment
-def bank_order(date, queryset):
+
+
+def bank_order(date, sent_at, queryset):
response = HttpResponse(content_type='application/octet-stream')
response['Content-Disposition'] = 'attachment; filename=order.PLD'
rows = []
no_dates = []
no_amounts = []
+ cancelled = []
if date is None:
raise ValueError('Payment date not set yet.')
no_dates.append(debit)
if debit.amount is None:
no_amounts.append(debit)
+ if debit.cancelled_at and debit.cancelled_at.date() <= date and (sent_at is None or debit.cancelled_at < sent_at):
+ cancelled.append(debit)
- if no_dates or no_amounts:
+ if no_dates or no_amounts or cancelled:
t = ''
if no_dates:
t += 'Bank acceptance not received for: '
for debit in no_amounts
)
t += '. '
+ if cancelled:
+ t += 'Debits have been cancelled: '
+ t += ', '.join(
+ '<a href="/admin/pz/directdebit/{}/change">{}</a>'.format(
+ debit.pk, debit
+ )
+ for debit in cancelled
+ )
+ t += '. '
raise ValueError(mark_safe(t))
for debit in queryset: