Revision fdf5b8ae
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 287 | 287 |
push @values, conv_date($form->{expected_billing_date_to});
|
| 288 | 288 |
} |
| 289 | 289 |
|
| 290 |
if ($form->{parts_partnumber}) {
|
|
| 291 |
$query .= <<SQL; |
|
| 292 |
AND EXISTS ( |
|
| 293 |
SELECT orderitems.trans_id |
|
| 294 |
FROM orderitems |
|
| 295 |
LEFT JOIN parts ON (orderitems.parts_id = parts.id) |
|
| 296 |
WHERE (orderitems.trans_id = o.id) |
|
| 297 |
AND (parts.partnumber ILIKE ?) |
|
| 298 |
LIMIT 1 |
|
| 299 |
) |
|
| 300 |
SQL |
|
| 301 |
push @values, like($form->{parts_partnumber});
|
|
| 302 |
} |
|
| 303 |
|
|
| 304 |
if ($form->{parts_description}) {
|
|
| 305 |
$query .= <<SQL; |
|
| 306 |
AND EXISTS ( |
|
| 307 |
SELECT orderitems.trans_id |
|
| 308 |
FROM orderitems |
|
| 309 |
WHERE (orderitems.trans_id = o.id) |
|
| 310 |
AND (orderitems.description ILIKE ?) |
|
| 311 |
LIMIT 1 |
|
| 312 |
) |
|
| 313 |
SQL |
|
| 314 |
push @values, like($form->{parts_description});
|
|
| 315 |
} |
|
| 316 |
|
|
| 290 | 317 |
if ($form->{all}) {
|
| 291 | 318 |
my @tokens = parse_line('\s+', 0, $form->{all});
|
| 292 | 319 |
# ordnumber quonumber customer.name vendor.name transaction_description |
| bin/mozilla/oe.pl | ||
|---|---|---|
| 906 | 906 |
transaction_description transdatefrom transdateto type vc employee_id salesman_id |
| 907 | 907 |
reqdatefrom reqdateto projectnumber project_id periodic_invoices_active periodic_invoices_inactive |
| 908 | 908 |
business_id shippingpoint taxzone_id reqdate_unset_or_old insertdatefrom insertdateto |
| 909 |
order_probability_op order_probability_value expected_billing_date_from expected_billing_date_to); |
|
| 909 |
order_probability_op order_probability_value expected_billing_date_from expected_billing_date_to |
|
| 910 |
parts_partnumber parts_description); |
|
| 910 | 911 |
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;
|
| 911 | 912 |
|
| 912 | 913 |
my @keys_for_url = grep { $form->{$_} } @hidden_variables;
|
| ... | ... | |
| 989 | 990 |
push @options, $locale->text('Transaction description') . " : $form->{transaction_description}" if $form->{transaction_description};
|
| 990 | 991 |
push @options, $locale->text('Quick Search') . " : $form->{all}" if $form->{all};
|
| 991 | 992 |
push @options, $locale->text('Shipping Point') . " : $form->{shippingpoint}" if $form->{shippingpoint};
|
| 993 |
push @options, $locale->text('Part Description') . " : $form->{parts_description}" if $form->{parts_description};
|
|
| 994 |
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}" if $form->{parts_partnumber};
|
|
| 992 | 995 |
if ( $form->{transdatefrom} or $form->{transdateto} ) {
|
| 993 | 996 |
push @options, $locale->text('Order Date');
|
| 994 | 997 |
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if $form->{transdatefrom};
|
| templates/webpages/oe/search.html | ||
|---|---|---|
| 81 | 81 |
</tr> |
| 82 | 82 |
<tr> |
| 83 | 83 |
<th align="right">[% 'Transaction description' | $T8 %]</th> |
| 84 |
<td colspan="3"><input name="transaction_description" style="width: 250px"></td> |
|
| 84 |
<td><input name="transaction_description" style="width: 250px"></td> |
|
| 85 |
|
|
| 86 |
<th align="right">[% 'Part Description' | $T8 %]</th> |
|
| 87 |
<td><input name="parts_description" style="width: 250px"></td> |
|
| 85 | 88 |
</tr> |
| 86 | 89 |
<tr> |
| 87 | 90 |
<th align="right">[% 'Project Number' | $T8 %]</th> |
| 88 |
<td colspan="3">
|
|
| 91 |
<td> |
|
| 89 | 92 |
[%- INCLUDE 'generic/multibox.html' |
| 90 | 93 |
name = MYCONFIG.vclimit < ALL_PROJECTS.size ? 'projectnumber' : 'project_id', |
| 91 | 94 |
style = "width: 250px", |
| ... | ... | |
| 97 | 100 |
allow_textbox = 1, |
| 98 | 101 |
-%] |
| 99 | 102 |
</td> |
| 103 |
|
|
| 104 |
<th align="right">[% 'Part Number' | $T8 %]</th> |
|
| 105 |
<td><input name="parts_partnumber" style="width: 250px"></td> |
|
| 100 | 106 |
</tr> |
| 101 | 107 |
[%- UNLESS ALL_BUSINESS_TYPES.size == 0 %] |
| 102 | 108 |
<tr> |
Auch abrufbar als: Unified diff
Angebote/Aufträge: Suche nach Artikelnummer/-beschreibung in Positionen