Revision 41a03969
Von Thomas Kasulke vor mehr als 17 Jahren hinzugefügt
SL/Form.pm | ||
---|---|---|
2488 | 2488 |
qq|SELECT h.employee_id, h.itime::timestamp(0) AS itime, h.addition, h.what_done, emp.name, h.snumbers, h.trans_id AS id | . |
2489 | 2489 |
qq|FROM history_erp h | . |
2490 | 2490 |
qq|LEFT JOIN employee emp ON (emp.id = h.employee_id) | . |
2491 |
qq|WHERE trans_id = ? |. $order |
|
2492 |
. $restriction; |
|
2493 |
|
|
2491 |
qq|WHERE trans_id = | . $trans_id |
|
2492 |
. $restriction . qq| | |
|
2493 |
. $order; |
|
2494 |
|
|
2494 | 2495 |
my $sth = $dbh->prepare($query) || $self->dberror($query); |
2495 | 2496 |
|
2496 |
$sth->execute($trans_id) || $self->dberror("$query ($trans_id)");
|
|
2497 |
$sth->execute() || $self->dberror("$query");
|
|
2497 | 2498 |
|
2498 | 2499 |
while(my $hash_ref = $sth->fetchrow_hashref()) { |
2499 | 2500 |
$hash_ref->{addition} = $main::locale->text($hash_ref->{addition}); |
Auch abrufbar als: Unified diff
Verbesserung der Suchfunktionen der Historie und Visualisierung der Sortierreihenfolge.