Revision 2e4e2ba9
Von Moritz Bunkus vor etwa 11 Jahren hinzugefügt
SL/DO.pm | ||
---|---|---|
130 | 130 |
push @where, ($form->{delivered} ? "" : "NOT ") . "COALESCE(dord.delivered, FALSE)"; |
131 | 131 |
} |
132 | 132 |
|
133 |
if ($form->{serialnumber}) { |
|
134 |
push @where, 'dord.id IN (SELECT doi.delivery_order_id FROM delivery_order_items doi WHERE doi.serialnumber LIKE ?)'; |
|
135 |
push @values, '%' . $form->{serialnumber} . '%'; |
|
136 |
} |
|
137 |
|
|
133 | 138 |
if($form->{transdatefrom}) { |
134 | 139 |
push @where, qq|dord.transdate >= ?|; |
135 | 140 |
push @values, conv_date($form->{transdatefrom}); |
bin/mozilla/do.pl | ||
---|---|---|
507 | 507 |
my $report = SL::ReportGenerator->new(\%myconfig, $form); |
508 | 508 |
|
509 | 509 |
my @hidden_variables = map { "l_${_}" } @columns; |
510 |
push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber |
|
510 |
push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber chargenumber
|
|
511 | 511 |
transaction_description transdatefrom transdateto type vc employee_id salesman_id project_id); |
512 | 512 |
|
513 | 513 |
my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables); |
... | ... | |
565 | 565 |
if ($form->{ordnumber}) { |
566 | 566 |
push @options, $locale->text('Order Number') . " : $form->{ordnumber}"; |
567 | 567 |
} |
568 |
push @options, $locale->text('Serial Number') . " : $form->{serialnumber}" if $form->{serialnumber}; |
|
568 | 569 |
if ($form->{transaction_description}) { |
569 | 570 |
push @options, $locale->text('Transaction description') . " : $form->{transaction_description}"; |
570 | 571 |
} |
templates/webpages/do/search.html | ||
---|---|---|
98 | 98 |
</td> |
99 | 99 |
</tr> |
100 | 100 |
|
101 |
<tr> |
|
102 |
<th align="right">[% 'Serial Number' | $T8 %]</th> |
|
103 |
<td colspan="3"><input name="serialnumber" class="fixed_width"></td> |
|
104 |
</tr> |
|
105 |
|
|
101 | 106 |
<tr> |
102 | 107 |
<th align="right">[% 'From' | $T8 %]</th> |
103 | 108 |
<td> |
Auch abrufbar als: Unified diff
Lieferscheinbericht: Suchmöglichkeit nach Seriennummer