Revision 59b16044
Von Tamino Steinert vor etwa 1 Jahr hinzugefügt
| SL/TransNumber.pm | ||
|---|---|---|
|
$filters{table} = "oe";
|
||
|
$filters{where} = 'COALESCE(quotation, FALSE) AND (vendor_id IS NOT NULL)';
|
||
|
|
||
|
} elsif ($type =~ /^(part|service|assembly|assortment)$/) {
|
||
|
} elsif ($type =~ /^(part|service|assembly|assortment|parent_variant|variant)$/) {
|
||
|
$filters{trans_number} = "partnumber";
|
||
|
my %numberfield_hash = ( service => 'servicenumber',
|
||
|
assembly => 'assemblynumber',
|
||
|
assortment => 'assortmentnumber',
|
||
|
part => 'articlenumber'
|
||
|
my %numberfield_hash = ( service => 'servicenumber',
|
||
|
assembly => 'assemblynumber',
|
||
|
assortment => 'assortmentnumber',
|
||
|
parent_variant => 'parent_variant_number',
|
||
|
variant => 'variant_number',
|
||
|
part => 'articlenumber'
|
||
|
);
|
||
|
$filters{numberfield} = $numberfield_hash{$type};
|
||
|
$filters{table} = "parts";
|
||
Auch abrufbar als: Unified diff
Varianten: SQL-Scripte und ROSE-DB Dateien erstellt