Revision 19522de1
Von Bernd Bleßmann vor etwa 2 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 218 | 218 |
push @values, like($form->{parts_description});
|
| 219 | 219 |
} |
| 220 | 220 |
|
| 221 |
if ($form->{chargenumber}) {
|
|
| 222 |
push @where, <<SQL; |
|
| 223 |
EXISTS ( |
|
| 224 |
SELECT delivery_order_items_stock.id |
|
| 225 |
FROM delivery_order_items_stock |
|
| 226 |
LEFT JOIN delivery_order_items ON (delivery_order_items.id = delivery_order_items_stock.delivery_order_item_id) |
|
| 227 |
WHERE delivery_order_items.delivery_order_id = dord.id |
|
| 228 |
AND delivery_order_items_stock.chargenumber ILIKE ? |
|
| 229 |
LIMIT 1 |
|
| 230 |
) |
|
| 231 |
SQL |
|
| 232 |
push @values, like($form->{chargenumber});
|
|
| 233 |
} |
|
| 234 |
|
|
| 221 | 235 |
if ($form->{all}) {
|
| 222 | 236 |
my @tokens = parse_line('\s+', 0, $form->{all});
|
| 223 | 237 |
# ordnumber quonumber customer.name vendor.name transaction_description |
| bin/mozilla/do.pl | ||
|---|---|---|
| 771 | 771 |
push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber serialnumber cusordnumber
|
| 772 | 772 |
transaction_description transdatefrom transdateto reqdatefrom reqdateto |
| 773 | 773 |
type vc employee_id salesman_id project_id parts_partnumber parts_description |
| 774 |
insertdatefrom insertdateto business_id all department_id); |
|
| 774 |
insertdatefrom insertdateto business_id all department_id chargenumber);
|
|
| 775 | 775 |
|
| 776 | 776 |
my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables);
|
| 777 | 777 |
|
| ... | ... | |
| 847 | 847 |
if ($form->{parts_partnumber}) {
|
| 848 | 848 |
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}";
|
| 849 | 849 |
} |
| 850 |
if ($form->{chargenumber}) {
|
|
| 851 |
push @options, $locale->text('Chargenumber') . " : $form->{chargenumber}";
|
|
| 852 |
} |
|
| 850 | 853 |
if ( $form->{transdatefrom} or $form->{transdateto} ) {
|
| 851 | 854 |
push @options, $locale->text('Delivery Order Date');
|
| 852 | 855 |
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if $form->{transdatefrom};
|
| templates/webpages/do/search.html | ||
|---|---|---|
| 88 | 88 |
|
| 89 | 89 |
<tr> |
| 90 | 90 |
<th align="right">[% 'Serial Number' | $T8 %]</th> |
| 91 |
<td colspan="3"><input name="serialnumber" class="fixed_width"></td> |
|
| 91 |
<td><input name="serialnumber" class="fixed_width"></td> |
|
| 92 |
<th align="right">[% 'Chargenumber' | $T8 %]</th> |
|
| 93 |
<td><input name="chargenumber" class="fixed_width"></td> |
|
| 92 | 94 |
</tr> |
| 93 | 95 |
|
| 94 | 96 |
[%- IF ALL_BUSINESS_TYPES.size %] |
Auch abrufbar als: Unified diff
Berichte-Lieferscheine: Filtern nach Charge (in Lagerinfos).