X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FDraft.pm;h=6c0110ab350f5b4652aa22fe8594a41aeedda989;hb=965a8ee142a6cd21c3056eacaa01a01818032c3e;hp=a450e2c9f58375a44e0af26f7458969004342e8f;hpb=46aa98a931708ad5ee5003437af92f0358e582b3;p=kivitendo-erp.git 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 }