68376728120ca9816323aa2d400f6bb20b7a17cb
[wolnelektury.git] / src / pz / bank.py
1 import csv
2 from io import StringIO
3 from django.conf import settings
4 from django.http import HttpResponse
5 from django.utils.safestring import mark_safe
6 from django.utils.translation import ugettext_lazy as _
7
8
9 def bank_export(modeladmin, request, queryset):
10     response = HttpResponse(content_type='text/csv; charset=cp1250')
11     response['Content-Disposition'] = 'attachment; filename=export.csv'
12     writer = csv.writer(response)
13     writer.writerow([
14         'Identyfikator płatności (IDP)',
15         'Nazwa Płatnika',
16         '',
17         'Adres Płatnika Ulica + numer domu',
18         'Adres Płatnika kod+miejscowość',
19         'Numer kierunkowy banku Płatnika',
20         'Numer rachunku bankowego Płatnika',
21         'Identyfikator Odbiorcy (NIP Odbiorcy)',
22         'Osobowość prawna Płatnika (Osoba fizyczna)'
23     ])
24
25     # TODO: ansi encoding
26
27     for obj in queryset:
28         writer.writerow([
29             obj.payment_id,
30             obj.full_name,
31             '',
32             obj.street_address,
33             ' '.join([obj.postal_code, obj.town]).strip(),
34             obj.iban[2:10],
35             obj.iban,
36             settings.PZ_NIP,
37             'OF'
38         ])
39     return response
40
41
42 def parse_export_feedback(f):
43     lines = csv.reader(StringIO(f.read().decode('cp1250')))
44     for line in lines:
45         payment_id = line[0]
46         status = int(line[8])
47         comment = line[9]
48         yield payment_id, status, comment
49
50
51 def bank_order(date, queryset):
52     response = HttpResponse(content_type='application/octet-stream')
53     response['Content-Disposition'] = 'attachment; filename=order.PLD'
54     rows = []
55
56     no_dates = []
57     no_amounts = []
58
59     if date is None:
60         raise ValueError('Payment date not set yet.')
61
62     for debit in queryset:
63         if debit.bank_acceptance_date is None:
64             no_dates.append(debit)
65         if debit.amount is None:
66             no_amounts.append(debit)
67
68     if no_dates or no_amounts:
69         t = ''
70         if no_dates:
71             t += 'Bank acceptance not received for: '
72             t += ', '.join(
73                 '<a href="/admin/pz/directdebit/{}/change">{}</a>'.format(
74                     debit.pk, debit
75                 )
76                 for debit in no_dates
77             )
78             t += '. '
79         if no_amounts:
80             t += 'Amount not set for: '
81             t += ', '.join(
82                 '<a href="/admin/pz/directdebit/{}/change">{}</a>'.format(
83                     debit.pk, debit
84                 )
85                 for debit in no_amounts
86             )
87             t += '. '
88         raise ValueError(mark_safe(t))
89
90     for debit in queryset:
91         rows.append(
92             '{order_code},{date},{amount},{dest_bank_id},0,"{dest_iban}","{user_iban}",'
93             '"{dest_addr}","{user_addr}",0,{user_bank_id},'
94             '"/NIP/{dest_nip}/IDP/{payment_id}|/TXT/{payment_desc}||",'
95             '"","","01"'.format(
96                 order_code=210,
97                 date=date.strftime('%Y%m%d'),
98
99                 amount=debit.amount * 100,
100                 dest_bank_id=settings.PZ_IBAN[2:10],
101                 dest_iban=settings.PZ_IBAN,
102                 user_iban=debit.iban,
103                 dest_addr=settings.PZ_ADDRESS_STRING,
104                 user_bank_id=debit.iban[2:10],
105                 dest_nip=settings.PZ_NIP,
106                 payment_id=debit.payment_id,
107                 payment_desc=settings.PZ_PAYMENT_DESCRIPTION,
108                 user_addr = '|'.join((
109                     debit.full_name,
110                     '',
111                     debit.street_address,
112                     ' '.join((debit.postal_code, debit.town))
113                 ))
114             )
115         )
116     response.write('\r\n'.join(rows).encode('cp1250'))
117
118     return response