X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FGL.pm;h=bf9e1c96c164fa9236d91f2626ba04de9671a29b;hb=67ca0f93194b1d0c8f0a3d090c6c1f604670837d;hp=cdd9d406ffcd6380852677cae3f8096e42f6b8aa;hpb=7e7a13692ac4dd952cf85a972d2919eed80edca1;p=kivitendo-erp.git diff --git a/SL/GL.pm b/SL/GL.pm index cdd9d406f..bf9e1c96c 100644 --- a/SL/GL.pm +++ b/SL/GL.pm @@ -51,9 +51,8 @@ sub delete_transaction { # connect to database my $dbh = $form->dbconnect_noauto($myconfig); - my @values = (conv_i($form->{id})); - do_query($form, $dbh, qq|DELETE FROM acc_trans WHERE trans_id = ?|, @values); - do_query($form, $dbh, qq|DELETE FROM gl WHERE id = ?|, @values); + # acc_trans entries are deleted by database triggers. + do_query($form, $dbh, qq|DELETE FROM gl WHERE id = ?|, conv_i($form->{id})); # commit and redirect my $rc = $dbh->commit; @@ -110,7 +109,6 @@ sub post_transaction { } my ($null, $department_id) = split(/--/, $form->{department}); - $department_id *= 1; $form->{ob_transaction} *= 1; $form->{cb_transaction} *= 1; @@ -123,7 +121,7 @@ sub post_transaction { WHERE id = ?|; @values = ($form->{reference}, $form->{description}, $form->{notes}, - conv_date($form->{transdate}), $department_id, $form->{taxincluded} ? 't' : 'f', + conv_date($form->{transdate}), conv_i($department_id), $form->{taxincluded} ? 't' : 'f', $form->{storno} ? 't' : 'f', conv_i($form->{storno_id}), $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f', conv_i($form->{id})); do_query($form, $dbh, $query, @values); @@ -186,7 +184,7 @@ sub post_transaction { } # safety check datev export - if ($::lx_office_conf{datev_check}{check_on_gl_transaction}) { + if ($::instance_conf->get_datev_check_on_gl_transaction) { my $transdate = $::form->{transdate} ? DateTime->from_lxoffice($::form->{transdate}) : undef; $transdate ||= DateTime->today;