Revision 52f5223a
Von Jan Büren vor mehr als 4 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 526 | 526 |
push @bind_vars, @cvar_values; |
| 527 | 527 |
} |
| 528 | 528 |
|
| 529 |
# simple search for assemblies by items used in assemblies |
|
| 530 |
if ($form->{bom} eq '2' && $form->{l_assembly}) {
|
|
| 531 |
# nuke where clause and bind vars |
|
| 532 |
$where_clause = ' 1=1 AND p.id in (SELECT id from assembly where parts_id IN ' . |
|
| 533 |
' (select id from parts where 1=1 AND '; |
|
| 534 |
@bind_vars = (); |
|
| 535 |
# use only like filter for items used in assemblies |
|
| 536 |
foreach (@like_filters) {
|
|
| 537 |
next unless $form->{$_};
|
|
| 538 |
$form->{"l_$_"} = '1'; # show the column
|
|
| 539 |
$where_clause .= " $_ ILIKE ? "; |
|
| 540 |
push @bind_vars, like($form->{$_});
|
|
| 541 |
} |
|
| 542 |
$where_clause .='))'; |
|
| 543 |
} |
|
| 544 |
|
|
| 529 | 545 |
my $query = <<" SQL"; |
| 530 | 546 |
SELECT DISTINCT $select_clause |
| 531 | 547 |
FROM parts p |
| locale/de/all | ||
|---|---|---|
| 2803 | 2803 |
'Search AR Aging' => 'Offene Forderungen', |
| 2804 | 2804 |
'Search bank transactions' => 'Filter für Bankbuchungen', |
| 2805 | 2805 |
'Search contacts' => 'Personensuche', |
| 2806 |
'Search for Items used in Assemblies' => 'Suche nach in Erzeugnissen verbauten Artikeln', |
|
| 2806 | 2807 |
'Search parts by customer partnumber in sales order forms' => 'Artikel nach Kunden-Art.-Nr. in Verkaufsbelegen suchen', |
| 2807 | 2808 |
'Search parts by vendor partnumber (model) in purchase order forms' => 'Artikel nach Lieferanten-Art.-Nr. in Einkaufsbelegen suchen', |
| 2808 | 2809 |
'Search term' => 'Suchbegriff', |
| templates/webpages/ic/search.html | ||
|---|---|---|
| 102 | 102 |
<td colspan="3"> |
| 103 | 103 |
[% L.radio_button_tag('bom', id='bom_0', value=0, checked=1, label=LxERP.t8('Top Level Designation only')) %]
|
| 104 | 104 |
[% L.radio_button_tag('bom', id='bom_1', value=1, label=LxERP.t8('Individual Items')) %]
|
| 105 |
[% L.radio_button_tag('bom', id='bom_2', value=2, label=LxERP.t8('Search for Items used in Assemblies')) %]
|
|
| 105 | 106 |
</td> |
| 106 | 107 |
</tr> |
| 107 | 108 |
|
Auch abrufbar als: Unified diff
Artikelsuche: Suche nach in Erzeugnis verbauten Artikeln
Als Ergebnis werden Erzeugnisse und deren Bestandteile angezeigt.
Gültige Suchkriterien sind aktuell nur die Spalten in parts