X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/168218647abacbfb5599be7beae82ae832cf2efb..e7367fb51e706abc8c54495e1623a5e1d2aca7fa:/SL/Form.pm diff --git a/SL/Form.pm b/SL/Form.pm index 4472dfcc6..921832edd 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -2496,12 +2496,12 @@ sub save_history { &get_employee($self, $dbh); } - my $query = - qq|INSERT INTO history_erp (trans_id, employee_id, addition, what_done, snumbers) | . - qq|VALUES (?, ?, ?, ?, ?)|; - my @values = (conv_i($self->{id}), conv_i($self->{employee_id}), - $self->{addition}, $self->{what_done}, "$self->{snumbers}"); - do_query($self, $dbh, $query, @values); +my $query = + qq|INSERT INTO history_erp (trans_id, employee_id, addition, what_done, snumbers) | . + qq|VALUES (?, (SELECT id FROM employee WHERE login = ?), ?, ?, ?)|; + my @values = (conv_i($self->{id}), $self->{login}, + $self->{addition}, $self->{what_done}, "$self->{snumbers}"); + do_query($self, $dbh, $query, @values); $main::lxdebug->leave_sub(); }