Revision 53ef5f90
Von Tamino Steinert vor 6 Tagen hinzugefügt
SL/TransNumber.pm | ||
---|---|---|
92 | 92 |
$filters{table} = "oe"; |
93 | 93 |
$filters{where} = 'COALESCE(quotation, FALSE) AND (vendor_id IS NOT NULL)'; |
94 | 94 |
|
95 |
} elsif ($type =~ /^(part|service|assembly|assortment)$/) { |
|
95 |
} elsif ($type =~ /^(part|service|assembly|assortment|parent_variant|variant)$/) {
|
|
96 | 96 |
$filters{trans_number} = "partnumber"; |
97 |
my %numberfield_hash = ( service => 'servicenumber', |
|
98 |
assembly => 'assemblynumber', |
|
99 |
assortment => 'assortmentnumber', |
|
100 |
part => 'articlenumber' |
|
97 |
my %numberfield_hash = ( service => 'servicenumber', |
|
98 |
assembly => 'assemblynumber', |
|
99 |
assortment => 'assortmentnumber', |
|
100 |
parent_variant => 'parent_variant_number', |
|
101 |
variant => 'variant_number', |
|
102 |
part => 'articlenumber' |
|
101 | 103 |
); |
102 | 104 |
$filters{numberfield} = $numberfield_hash{$type}; |
103 | 105 |
$filters{table} = "parts"; |
Auch abrufbar als: Unified diff
Varianten: SQL-Scripte und ROSE-DB Dateien erstellt