Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision f525facb

Von Tamino Steinert vor mehr als 2 Jahren hinzugefügt

  • ID f525facb7e20b6ab9a1f952a7468780a1f7f961a
  • Vorgänger 5df3efd0
  • Nachfolger e5edfe15

Reclamation: add reclamation to file_storage constrain and Webdav

Unterschiede anzeigen:

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