X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAM.pm;h=d738dc29df297c3417c902b298350ec9393bf9f9;hb=da1893cd430d3833fb9ba28517f3bea8ceb103d9;hp=a2e201f61149afe801583e0ee474346c51b50dab;hpb=501107ad47b6385a9986aab9048b98ed5784182e;p=kivitendo-erp.git diff --git a/SL/AM.pm b/SL/AM.pm index a2e201f61..d738dc29d 100644 --- a/SL/AM.pm +++ b/SL/AM.pm @@ -1191,104 +1191,6 @@ sub delete_printer { $main::lxdebug->leave_sub(); } -sub adr { - $main::lxdebug->enter_sub(); - - my ($self, $myconfig, $form) = @_; - - # connect to database - my $dbh = $form->dbconnect($myconfig); - - my $query = qq|SELECT id, adr_description, adr_code - FROM adr - ORDER BY adr_code|; - - $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); - - while (my $ref = $sth->fetchrow_hashref(NAME_lc)) { - push @{ $form->{ALL} }, $ref; - } - - $sth->finish; - $dbh->disconnect; - - $main::lxdebug->leave_sub(); -} - -sub get_adr { - $main::lxdebug->enter_sub(); - - my ($self, $myconfig, $form) = @_; - - # connect to database - my $dbh = $form->dbconnect($myconfig); - - my $query = - qq|SELECT a.adr_description, a.adr_code - FROM adr a - WHERE a.id = $form->{id}|; - my $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); - - my $ref = $sth->fetchrow_hashref(NAME_lc); - - map { $form->{$_} = $ref->{$_} } keys %$ref; - - $sth->finish; - - $dbh->disconnect; - - $main::lxdebug->leave_sub(); -} - -sub save_adr { - $main::lxdebug->enter_sub(); - - my ($self, $myconfig, $form) = @_; - - # connect to database - my $dbh = $form->dbconnect($myconfig); - - $form->{adr_description} =~ s/\'/\'\'/g; - $form->{adr_code} =~ s/\'/\'\'/g; - - - # id is the old record - if ($form->{id}) { - $query = qq|UPDATE adr SET - adr_description = '$form->{adr_description}', - adr_code = '$form->{adr_code}' - WHERE id = $form->{id}|; - } else { - $query = qq|INSERT INTO adr - (adr_description, adr_code) - VALUES ('$form->{adr_description}', '$form->{adr_code}')|; - } - $dbh->do($query) || $form->dberror($query); - - $dbh->disconnect; - - $main::lxdebug->leave_sub(); -} - -sub delete_adr { - $main::lxdebug->enter_sub(); - - my ($self, $myconfig, $form) = @_; - - # connect to database - my $dbh = $form->dbconnect($myconfig); - - $query = qq|DELETE FROM adr - WHERE id = $form->{id}|; - $dbh->do($query) || $form->dberror($query); - - $dbh->disconnect; - - $main::lxdebug->leave_sub(); -} - sub payment { $main::lxdebug->enter_sub();