Revision 843de783
Von Kivitendo Admin vor mehr als 10 Jahren hinzugefügt
| SL/BankAccount.pm | ||
|---|---|---|
| 23 | 23 |
|
| 24 | 24 |
my $query = |
| 25 | 25 |
qq|UPDATE bank_accounts |
| 26 |
SET account_number = ?, bank_code = ?, bank = ?, iban = ?, bic = ?, chart_id = ? |
|
| 26 |
SET name= ?, account_number = ?, bank_code = ?, bank = ?, iban = ?, bic = ?, chart_id = ?
|
|
| 27 | 27 |
WHERE id = ?|; |
| 28 |
my @values = (@params{qw(account_number bank_code bank iban bic)}, conv_i($params{chart_id}), conv_i($params{id}));
|
|
| 28 |
my @values = (@params{qw(name account_number bank_code bank iban bic)}, conv_i($params{chart_id}), conv_i($params{id}));
|
|
| 29 | 29 |
|
| 30 | 30 |
do_query($form, $dbh, $query, @values); |
| 31 | 31 |
|
| ... | ... | |
| 91 | 91 |
my $dbh = $params{dbh} || $form->get_standard_dbh($myconfig);
|
| 92 | 92 |
|
| 93 | 93 |
my %sort_columns = ( |
| 94 |
'name' => [ 'ba.name', ], |
|
| 94 | 95 |
'account_number' => [ 'ba.account_number', ], |
| 95 | 96 |
'bank_code' => [ 'ba.bank_code', 'ba.account_number', ], |
| 96 | 97 |
'bank' => [ 'ba.bank', 'ba.account_number', ], |
| ... | ... | |
| 103 | 104 |
my %sort_spec = create_sort_spec('defs' => \%sort_columns, 'default' => 'bank', 'column' => $params{sortorder}, 'dir' => $params{sortdir});
|
| 104 | 105 |
|
| 105 | 106 |
my $query = |
| 106 |
qq|SELECT ba.id, ba.account_number, ba.bank_code, ba.bank, ba.iban, ba.bic, ba.chart_id, |
|
| 107 |
qq|SELECT ba.id, ba.name, ba.account_number, ba.bank_code, ba.bank, ba.iban, ba.bic, ba.chart_id,
|
|
| 107 | 108 |
c.accno AS chart_accno, c.description AS chart_description |
| 108 | 109 |
FROM bank_accounts ba |
| 109 | 110 |
LEFT JOIN chart c ON (ba.chart_id = c.id) |
Auch abrufbar als: Unified diff
Bankkonten einen Namen geben
Damit kann man seinen Bankkonten einfache Namen geben, wie z.B.
"Tagegeld", damit man bei der Auswahl nicht immer genau auf die
Kontonummer achten muß.
Bei der Bankkontenauswahl in Dropdowns ist die Beschriftung jetzt im
Format:
Name - Kontonummer, BLZ, Bank
Der nächste Schritt wäre wahrscheinlich IBAN statt Kontonummer und BLZ
zu benutzen.