src/pz/bank.py

   1 import csv
   2 from datetime import datetime
   3 from io import StringIO
   4 from django.conf import settings
   5 from django.http import HttpResponse
   6 from django.utils.safestring import mark_safe
   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
  14     for obj in queryset:
  15         writer.writerow([
  16             obj.payment_id,
  17             obj.full_name,
  18             '',
  19             obj.street_address,
  20             ' '.join([obj.postal_code, obj.town]).strip(),
  21             obj.iban[2:10],
  22             obj.iban,
  23             settings.PZ_NIP,
  24             'OF'
  25         ])
  26     return response
  27
  28
  29 def parse_payment_feedback(f):
  30     lines = csv.reader(StringIO(f.read().decode('cp1250')))
  31     for line in lines:
  32         if not line: continue
  33         print(line)
  34         assert line[0] in ('1', '2')
  35         if line[0] == '1':
  36             # Totals line.
  37             continue
  38         booking_date = line[3]
  39         booking_date = datetime.strptime(booking_date, '%Y%m%d')
  40         payment_id = line[7]
  41         is_dd = line[16] == 'DD'
  42         realised = line[17] == '1'
  43         reject_code = line[18]
  44         yield payment_id, booking_date, is_dd, realised, reject_code
  45
  46
  47
  48
  49 def parse_export_feedback(f):
  50     # The AU file.
  51     lines = csv.reader(StringIO(f.read().decode('cp1250')))
  52     for line in lines:
  53         if not line: continue
  54         payment_id = line[0]
  55         status = int(line[8])
  56         comment = line[9]
  57         yield payment_id, status, comment
  58
  59
  60
  61
  62 def bank_order(date, sent_at, queryset):
  63     response = HttpResponse(content_type='application/octet-stream')
  64     response['Content-Disposition'] = 'attachment; filename=order.PLD'
  65     rows = []
  66
  67     no_dates = []
  68     no_amounts = []
  69     cancelled = []
  70
  71     if date is None:
  72         raise ValueError('Payment date not set yet.')
  73
  74     for debit in queryset:
  75         if debit.bank_acceptance_date is None:
  76             no_dates.append(debit)
  77         if debit.amount is None:
  78             no_amounts.append(debit)
  79         if debit.cancelled_at and debit.cancelled_at.date() <= date and (sent_at is None or debit.cancelled_at < sent_at):
  80             cancelled.append(debit)
  81
  82     if no_dates or no_amounts or cancelled:
  83         t = ''
  84         if no_dates:
  85             t += 'Bank acceptance not received for: '
  86             t += ', '.join(
  87                 '<a href="/admin/pz/directdebit/{}/change">{}</a>'.format(
  88                     debit.pk, debit
  89                 )
  90                 for debit in no_dates
  91             )
  92             t += '. '
  93         if no_amounts:
  94             t += 'Amount not set for: '
  95             t += ', '.join(
  96                 '<a href="/admin/pz/directdebit/{}/change">{}</a>'.format(
  97                     debit.pk, debit
  98                 )
  99                 for debit in no_amounts
 100             )
 101             t += '. '
 102         if cancelled:
 103             t += 'Debits have been cancelled: '
 104             t += ', '.join(
 105                 '<a href="/admin/pz/directdebit/{}/change">{}</a>'.format(
 106                     debit.pk, debit
 107                 )
 108                 for debit in cancelled
 109             )
 110             t += '. '
 111         raise ValueError(mark_safe(t))
 112
 113     for debit in queryset:
 114         rows.append(
 115             '{order_code},{date},{amount},{dest_bank_id},0,"{dest_iban}","{user_iban}",'
 116             '"{dest_addr}","{user_addr}",0,{user_bank_id},'
 117             '"/NIP/{dest_nip}/IDP/{payment_id}|/TXT/{payment_desc}||",'
 118             '"","","01"'.format(
 119                 order_code=210,
 120                 date=date.strftime('%Y%m%d'),
 121
 122                 amount=debit.amount * 100,
 123                 dest_bank_id=settings.PZ_IBAN[2:10],
 124                 dest_iban=settings.PZ_IBAN,
 125                 user_iban=debit.iban,
 126                 dest_addr=settings.PZ_ADDRESS_STRING,
 127                 user_bank_id=debit.iban[2:10],
 128                 dest_nip=settings.PZ_NIP,
 129                 payment_id=debit.payment_id,
 130                 payment_desc=settings.PZ_PAYMENT_DESCRIPTION,
 131                 user_addr = '|'.join((
 132                     debit.full_name,
 133                     '',
 134                     debit.street_address,
 135                     ' '.join((debit.postal_code, debit.town))
 136                 ))
 137             )
 138         )
 139     response.write('\r\n'.join(rows).encode('cp1250'))
 140
 141     return response