From 71dab32201ac432029963c7f0ce2b87adea2dd92 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 1 Oct 2015 14:50:05 +0200 Subject: [PATCH] SEPA-Suche: Nachrichten-IDs als Spalte anzeigen --- SL/SEPA.pm | 3 +++ bin/mozilla/sepa.pl | 3 ++- locale/de/all | 1 + 3 files changed, 6 insertions(+), 1 deletion(-) diff --git a/SL/SEPA.pm b/SL/SEPA.pm index f2599a8b6..c62c2ce7d 100644 --- a/SL/SEPA.pm +++ b/SL/SEPA.pm @@ -370,6 +370,9 @@ sub list_exports { (SELECT SUM(sei.amount) FROM sepa_export_items sei WHERE (sei.sepa_export_id = se.id)) AS sum_amounts, + (SELECT string_agg(semi.message_id, ', ') + FROM sepa_export_message_ids semi + WHERE semi.sepa_export_id = se.id) AS message_ids, e.name AS employee FROM sepa_export se LEFT JOIN ( diff --git a/bin/mozilla/sepa.pl b/bin/mozilla/sepa.pl index 8e5f807ed..a6fa2a470 100755 --- a/bin/mozilla/sepa.pl +++ b/bin/mozilla/sepa.pl @@ -237,9 +237,10 @@ sub bank_transfer_list { 'closed' => { 'text' => $locale->text('Closed'), }, num_invoices => { 'text' => $locale->text('Number of invoices'), }, sum_amounts => { 'text' => $locale->text('Sum of all amounts'), }, + message_ids => { 'text' => $locale->text('SEPA message IDs'), }, ); - my @columns = qw(selected id export_date employee executed closed invoices netamount); + my @columns = qw(selected id export_date employee executed closed num_invoices sum_amounts message_ids); my %column_alignment = map { ($_ => 'right') } qw(num_invoices sum_amounts); foreach my $name (qw(id export_date employee executed closed)) { diff --git a/locale/de/all b/locale/de/all index ff04503ba..787259ce4 100755 --- a/locale/de/all +++ b/locale/de/all @@ -2254,6 +2254,7 @@ $self->{texts} = { 'SEPA XML download' => 'SEPA-XML-Download', 'SEPA creditor ID' => 'SEPA-Kreditoren-Identifikation', 'SEPA exports:' => 'SEPA-Exporte:', + 'SEPA message IDs' => 'SEPA-Nachrichten-IDs', 'SEPA strings' => 'SEPA-Überweisungen', 'Saldo Credit' => 'Saldo Haben', 'Saldo Debit' => 'Saldo Soll', -- 2.20.1