Revision 0e36c22a
Von Moritz Bunkus vor fast 11 Jahren hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 308 | 308 |
my $table = $params{vc} eq 'customer' ? 'customer' : 'vendor';
|
| 309 | 309 |
my @ids = ref $params{id} eq 'ARRAY' ? @{ $params{id} } : ($params{id});
|
| 310 | 310 |
my $placeholders = join ", ", ('?') x scalar @ids;
|
| 311 |
my $query = qq|SELECT id, name, account_number, bank, bank_code, iban, bic |
|
| 311 |
my $c_mandate = $params{vc} eq 'customer' ? ', mandator_id, mandate_date_of_signature' : '';
|
|
| 312 |
my $query = qq|SELECT id, name, account_number, bank, bank_code, iban, bic ${c_mandate}
|
|
| 312 | 313 |
FROM ${table}
|
| 313 | 314 |
WHERE id IN (${placeholders})|;
|
| 314 | 315 |
|
Auch abrufbar als: Unified diff
SEPA: Feld »Signaturdatum«; Bearbeiten der Felder in Stammdatenmasken; Speichern in sepa_export_items