Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision cd160f80

Von Tamino Steinert vor etwa 2 Jahren hinzugefügt

  • ID cd160f800ac12e37884f0bbb148979bd2b2090ee
  • Vorgänger a2028e5c
  • Nachfolger 491fcf0c

Reclamation: add reclamation to file_storage constrain and Webdav

Unterschiede anzeigen:

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