Revision bbe298f0
Von Moritz Bunkus vor fast 8 Jahren hinzugefügt
| SL/Controller/Draft.pm | ||
|---|---|---|
| 131 | 131 |
sub draft_list {
|
| 132 | 132 |
my ($self) = @_; |
| 133 | 133 |
|
| 134 |
my $result = selectall_hashref_query($::form, $::form->get_standard_dbh, <<SQL, $self->module, $self->submodule); |
|
| 135 |
SELECT d.*, date(d.itime) AS date, e.name AS employee_name
|
|
| 134 |
my $result = selectall_hashref_query($::form, $::form->get_standard_dbh, <<SQL, $self->module, $self->submodule, SL::DB::Manager::Employee->current->id);
|
|
| 135 |
SELECT d.*, date(d.itime) AS date |
|
| 136 | 136 |
FROM drafts d |
| 137 |
LEFT JOIN employee e ON d.employee_id = e.id |
|
| 138 |
WHERE (d.module = ?) AND (d.submodule = ?) |
|
| 137 |
WHERE (d.module = ?) |
|
| 138 |
AND (d.submodule = ?) |
|
| 139 |
AND (d.employee_id = ?) |
|
| 139 | 140 |
ORDER BY d.itime |
| 140 | 141 |
SQL |
| 141 | 142 |
} |
Auch abrufbar als: Unified diff
Entwürfe: nur die eigenen Entwürfe anzeigen