62 |
62 |
$filters{trans_number} = "ordnumber";
|
63 |
63 |
$filters{numberfield} = $type eq 'sales_order' ? "sonumber" : "ponumber";
|
64 |
64 |
$filters{table} = "oe";
|
65 |
|
$filters{where} = 'NOT COALESCE(quotation, FALSE)';
|
66 |
|
$filters{where} .= $type =~ /^sales/ ? ' AND (customer_id IS NOT NULL)' : ' AND (vendor_id IS NOT NULL)';
|
|
65 |
$filters{where} = "record_type = ?";
|
|
66 |
$filters{values} = [ $::form->{type} ];
|
67 |
67 |
|
68 |
68 |
} elsif ($type =~ /^sales_order_intake$/) {
|
69 |
69 |
$filters{trans_number} = "ordnumber";
|
70 |
70 |
$filters{numberfield} = "soinumber";
|
71 |
71 |
$filters{table} = "oe";
|
72 |
|
$filters{where} = 'NOT COALESCE(quotation, FALSE)';
|
73 |
|
$filters{where} .= $type =~ /^sales/ ? ' AND (customer_id IS NOT NULL)' : ' AND (vendor_id IS NOT NULL)';
|
|
72 |
$filters{where} = "record_type = ?";
|
|
73 |
$filters{values} = $type;
|
74 |
74 |
|
75 |
75 |
} elsif ($type =~ /^purchase_order_confirmation$/) {
|
76 |
76 |
$filters{trans_number} = "ordnumber";
|
... | ... | |
83 |
83 |
$filters{trans_number} = "quonumber";
|
84 |
84 |
$filters{numberfield} = $type eq 'sales_quotation' ? "sqnumber" : "rfqnumber";
|
85 |
85 |
$filters{table} = "oe";
|
86 |
|
$filters{where} = 'COALESCE(quotation, FALSE)';
|
87 |
|
$filters{where} .= $type =~ /^sales/ ? ' AND (customer_id IS NOT NULL)' : ' AND (vendor_id IS NOT NULL)';
|
|
86 |
$filters{where} = "record_type = ?";
|
|
87 |
$filters{values} = $type;
|
88 |
88 |
|
89 |
89 |
} elsif ($type =~ /^purchase_quotation_intake$/) {
|
90 |
90 |
$filters{trans_number} = "quonumber";
|
91 |
91 |
$filters{numberfield} = "pqinumber";
|
92 |
92 |
$filters{table} = "oe";
|
93 |
|
$filters{where} = 'COALESCE(quotation, FALSE) AND (vendor_id IS NOT NULL)';
|
|
93 |
$filters{where} = "record_type = ?";
|
|
94 |
$filters{values} = $type;
|
94 |
95 |
|
95 |
96 |
} elsif ($type =~ /^(part|service|assembly|assortment)$/) {
|
96 |
97 |
$filters{trans_number} = "partnumber";
|
Alter Auftrags/Angebotscontroller weitere quotations die gestört haben
rausgenommen