X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/46aa98a931708ad5ee5003437af92f0358e582b3..c954dea7c1b814d66b8c31d04fa70a1bbbcce71e:/SL/Controller/Draft.pm diff --git a/SL/Controller/Draft.pm b/SL/Controller/Draft.pm index a450e2c9f..6c0110ab3 100644 --- a/SL/Controller/Draft.pm +++ b/SL/Controller/Draft.pm @@ -68,6 +68,7 @@ sub action_save { $self->js ->flash('info', t8("Draft saved.")) ->dialog->close('#save_draft') + ->val('#draft_id', $draft->id) ->render; } } @@ -131,11 +132,12 @@ sub _build_form { sub draft_list { my ($self) = @_; - my $result = selectall_hashref_query($::form, $::form->get_standard_dbh, <module, $self->submodule); - SELECT d.*, date(d.itime) AS date, e.name AS employee_name + my $result = selectall_hashref_query($::form, $::form->get_standard_dbh, <module, $self->submodule, SL::DB::Manager::Employee->current->id); + SELECT d.*, date(d.itime) AS date FROM drafts d - LEFT JOIN employee e ON d.employee_id = e.id - WHERE (d.module = ?) AND (d.submodule = ?) + WHERE (d.module = ?) + AND (d.submodule = ?) + AND (d.employee_id = ?) ORDER BY d.itime SQL }