X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FBankAccount.pm;h=3178b2a312741ca9a3ba230a21ea42d762c739f9;hb=6e351f3279ef4d5b782eb48e902002f87fe85d59;hp=4194d5c5cc4b17db44e3421029879c90c468ab63;hpb=0ce1b04e2a9bbd52692e118debb272e628f327f4;p=kivitendo-erp.git

diff --git a/SL/BankAccount.pm b/SL/BankAccount.pm
index 4194d5c5c..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);
 
@@ -57,6 +57,28 @@ sub retrieve {
   return $account;
 }
 
+sub delete {
+  $::lxdebug->enter_sub();
+
+  my $self     = shift;
+  my %params   = @_;
+
+  Common::check_params(\%params, qw(id));
+
+  my $dbh = $params{dbh} || $::form->get_standard_dbh(%::myconfig);
+
+  my $query = '
+    DELETE
+    FROM bank_accounts
+    WHERE id = ?';
+
+  do_query($::form, $dbh, $query, conv_i($params{id}));
+
+  $dbh->commit();
+
+  $::lxdebug->leave_sub();
+}
+
 sub list {
   $main::lxdebug->enter_sub();
 
@@ -69,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', ],
@@ -81,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)