X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FBankAccount.pm;h=3178b2a312741ca9a3ba230a21ea42d762c739f9;hb=63b5c301058ad46c5a35d0156935c3ac85aa914e;hp=f17ec1ede293d0812caa52c85ae1ed56fa783856;hpb=ebd37c0ea7536ff0b41bda6e259d6348063edea9;p=kivitendo-erp.git diff --git a/SL/BankAccount.pm b/SL/BankAccount.pm index f17ec1ede..3178b2a31 100644 --- a/SL/BankAccount.pm +++ b/SL/BankAccount.pm @@ -23,9 +23,9 @@ sub save { my $query = qq|UPDATE bank_accounts - SET account_number = ?, bank_code = ?, bank = ?, iban = ?, bic = ?, chart_id = ? + SET name= ?, account_number = ?, bank_code = ?, bank = ?, iban = ?, bic = ?, chart_id = ? WHERE id = ?|; - my @values = (@params{qw(account_number bank_code bank iban bic)}, conv_i($params{chart_id}), conv_i($params{id})); + my @values = (@params{qw(name account_number bank_code bank iban bic)}, conv_i($params{chart_id}), conv_i($params{id})); do_query($form, $dbh, $query, @values); @@ -91,6 +91,7 @@ sub list { my $dbh = $params{dbh} || $form->get_standard_dbh($myconfig); my %sort_columns = ( + 'name' => [ 'ba.name', ], 'account_number' => [ 'ba.account_number', ], 'bank_code' => [ 'ba.bank_code', 'ba.account_number', ], 'bank' => [ 'ba.bank', 'ba.account_number', ], @@ -103,7 +104,7 @@ sub list { my %sort_spec = create_sort_spec('defs' => \%sort_columns, 'default' => 'bank', 'column' => $params{sortorder}, 'dir' => $params{sortdir}); my $query = - qq|SELECT ba.id, ba.account_number, ba.bank_code, ba.bank, ba.iban, ba.bic, ba.chart_id, + qq|SELECT ba.id, ba.name, ba.account_number, ba.bank_code, ba.bank, ba.iban, ba.bic, ba.chart_id, c.accno AS chart_accno, c.description AS chart_description FROM bank_accounts ba LEFT JOIN chart c ON (ba.chart_id = c.id)