Revision cc14c2da
Von Moritz Bunkus vor mehr als 9 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 326 | 326 |
$joins_sub{$arap} = 1;
|
| 327 | 327 |
} |
| 328 | 328 |
|
| 329 |
if ($filter->{message_id}) {
|
|
| 330 |
push @values, '%' . $filter->{message_id} . '%';
|
|
| 331 |
push @where, <<SQL; |
|
| 332 |
se.id IN ( |
|
| 333 |
SELECT sepa_export_id |
|
| 334 |
FROM sepa_export_message_ids |
|
| 335 |
WHERE message_id ILIKE ? |
|
| 336 |
) |
|
| 337 |
SQL |
|
| 338 |
} |
|
| 339 |
|
|
| 329 | 340 |
if ($filter->{vc}) {
|
| 330 | 341 |
push @where_sub, "vc.name ILIKE ?"; |
| 331 | 342 |
push @values_sub, '%' . $filter->{vc} . '%';
|
| bin/mozilla/sepa.pl | ||
|---|---|---|
| 209 | 209 |
|
| 210 | 210 |
my %filter = map +( $_ => $form->{"f_${_}"} ),
|
| 211 | 211 |
grep { $form->{"f_${_}"} }
|
| 212 |
(qw(vc invnumber), |
|
| 212 |
(qw(vc invnumber message_id),
|
|
| 213 | 213 |
map { ("${_}_date_from", "${_}_date_to") }
|
| 214 | 214 |
qw(export requested_execution execution)); |
| 215 | 215 |
$filter{executed} = $form->{l_executed} ? 1 : 0 if ($form->{l_executed} != $form->{l_not_executed});
|
| 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 ID' => 'SEPA-Nachrichten-ID', |
|
| 2257 | 2258 |
'SEPA message IDs' => 'SEPA-Nachrichten-IDs', |
| 2258 | 2259 |
'SEPA strings' => 'SEPA-Überweisungen', |
| 2259 | 2260 |
'Saldo Credit' => 'Saldo Haben', |
| templates/webpages/sepa/bank_transfer_search.html | ||
|---|---|---|
| 17 | 17 |
<td><input name="f_invnumber"></td> |
| 18 | 18 |
</tr> |
| 19 | 19 |
|
| 20 |
<tr> |
|
| 21 |
<td align="right">[% LxERP.t8("SEPA message ID") %]</td>
|
|
| 22 |
<td>[% L.input_tag("f_message_id") %]</td>
|
|
| 23 |
</tr> |
|
| 24 |
|
|
| 20 | 25 |
<tr> |
| 21 | 26 |
<td align="right">[% 'Export date from' | $T8 %]</td> |
| 22 | 27 |
<td> |
Auch abrufbar als: Unified diff
SEPA-Suche: nach Nachrichten-ID suchen können