Revision 59b16044
Von Tamino Steinert vor 3 Monaten 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