Revision f525facb
Von Tamino Steinert vor mehr als 2 Jahren hinzugefügt
| SL/File/Backend/Webdav.pm | ||
|---|---|---|
|
purchase_order => 'lieferantenbestellungen',
|
||
|
sales_delivery_order => 'verkaufslieferscheine',
|
||
|
purchase_delivery_order => 'einkaufslieferscheine',
|
||
|
purchase_reclamation => 'einkaufsreklamation',
|
||
|
sales_reclamation => 'verkaufsreklamation',
|
||
|
credit_note => 'gutschriften',
|
||
|
invoice => 'rechnungen',
|
||
|
invoice_for_advance_payment => 'rechnungen',
|
||
| ... | ... | |
|
purchase_order => 'Order',
|
||
|
sales_delivery_order => 'DeliveryOrder',
|
||
|
purchase_delivery_order => 'DeliveryOrder',
|
||
|
sales_reclamation => 'Reclamation',
|
||
|
pursales_reclamation => 'Reclamation',
|
||
|
credit_note => 'Invoice',
|
||
|
invoice => 'Invoice',
|
||
|
invoice_for_advance_payment => 'Invoice',
|
||
| ... | ... | |
|
my %model_to_number = (
|
||
|
Order => 'ordnumber',
|
||
|
DeliveryOrder => 'ordnumber',
|
||
|
Reclamation => 'record_number',
|
||
|
Invoice => 'invnumber',
|
||
|
PurchaseInvoice => 'invnumber',
|
||
|
Part => 'partnumber',
|
||
| sql/Pg-upgrade2/file_storage_reclamation.sql | ||
|---|---|---|
|
-- @tag: file_storage_reclamation
|
||
|
-- @description: Dateispeicher auch für Reklamationen anbieten
|
||
|
-- @depends: file_storage_partial_invoices
|
||
|
|
||
|
ALTER TABLE files
|
||
|
DROP CONSTRAINT valid_type;
|
||
|
ALTER TABLE files
|
||
|
ADD CONSTRAINT valid_type CHECK (
|
||
|
(object_type = 'credit_note' ) OR (object_type = 'invoice' ) OR (object_type = 'sales_order' )
|
||
|
OR (object_type = 'sales_quotation' ) OR (object_type = 'sales_delivery_order' ) OR (object_type = 'request_quotation' )
|
||
|
OR (object_type = 'purchase_order' ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice' )
|
||
|
OR (object_type = 'vendor' ) OR (object_type = 'customer' ) OR (object_type = 'part' )
|
||
|
OR (object_type = 'gl_transaction' ) OR (object_type = 'dunning' ) OR (object_type = 'dunning1' )
|
||
|
OR (object_type = 'dunning2' ) OR (object_type = 'dunning3' ) OR (object_type = 'dunning_orig_invoice' )
|
||
|
OR (object_type = 'dunning_invoice' ) OR (object_type = 'draft' ) OR (object_type = 'statement' )
|
||
|
OR (object_type = 'shop_image' ) OR (object_type = 'letter' ) OR (object_type = 'project' )
|
||
|
OR (object_type = 'invoice_for_advance_payment') OR (object_type = 'final_invoice')
|
||
|
OR (object_type = 'sales_reclamation') OR (object_type = 'purchase_reclamation')
|
||
|
);
|
||
Auch abrufbar als: Unified diff
Reclamation: add reclamation to file_storage constrain and Webdav