Revision 71dab322
Von Moritz Bunkus vor mehr als 9 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 370 | 370 |
(SELECT SUM(sei.amount) |
| 371 | 371 |
FROM sepa_export_items sei |
| 372 | 372 |
WHERE (sei.sepa_export_id = se.id)) AS sum_amounts, |
| 373 |
(SELECT string_agg(semi.message_id, ', ') |
|
| 374 |
FROM sepa_export_message_ids semi |
|
| 375 |
WHERE semi.sepa_export_id = se.id) AS message_ids, |
|
| 373 | 376 |
e.name AS employee |
| 374 | 377 |
FROM sepa_export se |
| 375 | 378 |
LEFT JOIN ( |
| bin/mozilla/sepa.pl | ||
|---|---|---|
| 237 | 237 |
'closed' => { 'text' => $locale->text('Closed'), },
|
| 238 | 238 |
num_invoices => { 'text' => $locale->text('Number of invoices'), },
|
| 239 | 239 |
sum_amounts => { 'text' => $locale->text('Sum of all amounts'), },
|
| 240 |
message_ids => { 'text' => $locale->text('SEPA message IDs'), },
|
|
| 240 | 241 |
); |
| 241 | 242 |
|
| 242 |
my @columns = qw(selected id export_date employee executed closed invoices netamount);
|
|
| 243 |
my @columns = qw(selected id export_date employee executed closed num_invoices sum_amounts message_ids);
|
|
| 243 | 244 |
my %column_alignment = map { ($_ => 'right') } qw(num_invoices sum_amounts);
|
| 244 | 245 |
|
| 245 | 246 |
foreach my $name (qw(id export_date employee executed closed)) {
|
| locale/de/all | ||
|---|---|---|
| 2254 | 2254 |
'SEPA XML download' => 'SEPA-XML-Download', |
| 2255 | 2255 |
'SEPA creditor ID' => 'SEPA-Kreditoren-Identifikation', |
| 2256 | 2256 |
'SEPA exports:' => 'SEPA-Exporte:', |
| 2257 |
'SEPA message IDs' => 'SEPA-Nachrichten-IDs', |
|
| 2257 | 2258 |
'SEPA strings' => 'SEPA-Überweisungen', |
| 2258 | 2259 |
'Saldo Credit' => 'Saldo Haben', |
| 2259 | 2260 |
'Saldo Debit' => 'Saldo Soll', |
Auch abrufbar als: Unified diff
SEPA-Suche: Nachrichten-IDs als Spalte anzeigen