Revision 3d433e1f
Von Tamino Steinert vor 11 Monaten hinzugefügt
- ID 3d433e1f69add82bd4c654e7ca6b1071a35e0c86
- Vorgänger 9da868aa
| 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