Revision f525facb
Von Tamino Steinert vor etwa 2 Jahren hinzugefügt
SL/File/Backend/Webdav.pm | ||
---|---|---|
119 | 119 |
purchase_order => 'lieferantenbestellungen', |
120 | 120 |
sales_delivery_order => 'verkaufslieferscheine', |
121 | 121 |
purchase_delivery_order => 'einkaufslieferscheine', |
122 |
purchase_reclamation => 'einkaufsreklamation', |
|
123 |
sales_reclamation => 'verkaufsreklamation', |
|
122 | 124 |
credit_note => 'gutschriften', |
123 | 125 |
invoice => 'rechnungen', |
124 | 126 |
invoice_for_advance_payment => 'rechnungen', |
... | ... | |
143 | 145 |
purchase_order => 'Order', |
144 | 146 |
sales_delivery_order => 'DeliveryOrder', |
145 | 147 |
purchase_delivery_order => 'DeliveryOrder', |
148 |
sales_reclamation => 'Reclamation', |
|
149 |
pursales_reclamation => 'Reclamation', |
|
146 | 150 |
credit_note => 'Invoice', |
147 | 151 |
invoice => 'Invoice', |
148 | 152 |
invoice_for_advance_payment => 'Invoice', |
... | ... | |
163 | 167 |
my %model_to_number = ( |
164 | 168 |
Order => 'ordnumber', |
165 | 169 |
DeliveryOrder => 'ordnumber', |
170 |
Reclamation => 'record_number', |
|
166 | 171 |
Invoice => 'invnumber', |
167 | 172 |
PurchaseInvoice => 'invnumber', |
168 | 173 |
Part => 'partnumber', |
sql/Pg-upgrade2/file_storage_reclamation.sql | ||
---|---|---|
1 |
-- @tag: file_storage_reclamation |
|
2 |
-- @description: Dateispeicher auch für Reklamationen anbieten |
|
3 |
-- @depends: file_storage_partial_invoices |
|
4 |
|
|
5 |
ALTER TABLE files |
|
6 |
DROP CONSTRAINT valid_type; |
|
7 |
ALTER TABLE files |
|
8 |
ADD CONSTRAINT valid_type CHECK ( |
|
9 |
(object_type = 'credit_note' ) OR (object_type = 'invoice' ) OR (object_type = 'sales_order' ) |
|
10 |
OR (object_type = 'sales_quotation' ) OR (object_type = 'sales_delivery_order' ) OR (object_type = 'request_quotation' ) |
|
11 |
OR (object_type = 'purchase_order' ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice' ) |
|
12 |
OR (object_type = 'vendor' ) OR (object_type = 'customer' ) OR (object_type = 'part' ) |
|
13 |
OR (object_type = 'gl_transaction' ) OR (object_type = 'dunning' ) OR (object_type = 'dunning1' ) |
|
14 |
OR (object_type = 'dunning2' ) OR (object_type = 'dunning3' ) OR (object_type = 'dunning_orig_invoice' ) |
|
15 |
OR (object_type = 'dunning_invoice' ) OR (object_type = 'draft' ) OR (object_type = 'statement' ) |
|
16 |
OR (object_type = 'shop_image' ) OR (object_type = 'letter' ) OR (object_type = 'project' ) |
|
17 |
OR (object_type = 'invoice_for_advance_payment') OR (object_type = 'final_invoice') |
|
18 |
OR (object_type = 'sales_reclamation') OR (object_type = 'purchase_reclamation') |
|
19 |
); |
Auch abrufbar als: Unified diff
Reclamation: add reclamation to file_storage constrain and Webdav