Wiederkerende Rechnungen: Konfiguration für automatischen Versand via E-Mail

[kivitendo-erp.git] / SL / DB / MetaSetup / PeriodicInvoicesConfig.pm

diff --git a/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm b/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm
index 0c05453..9cb9998 100644 (file)
--- a/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm
+++ b/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm
@@ -9,21 +9,27 @@ use parent qw(SL::DB::Object);
 __PACKAGE__->meta->table('periodic_invoices_configs');
 
 __PACKAGE__->meta->columns(
-  active                  => { type => 'boolean', default => 'true' },
-  ar_chart_id             => { type => 'integer', not_null => 1 },
-  copies                  => { type => 'integer' },
-  direct_debit            => { type => 'boolean', default => 'false', not_null => 1 },
-  end_date                => { type => 'date' },
-  extend_automatically_by => { type => 'integer' },
-  first_billing_date      => { type => 'date' },
-  id                      => { type => 'integer', not_null => 1, sequence => 'id' },
-  oe_id                   => { type => 'integer', not_null => 1 },
-  order_value_periodicity => { type => 'varchar', length => 1, not_null => 1 },
-  periodicity             => { type => 'varchar', length => 1, not_null => 1 },
-  print                   => { type => 'boolean', default => 'false' },
-  printer_id              => { type => 'integer' },
-  start_date              => { type => 'date' },
-  terminated              => { type => 'boolean', default => 'false' },
+  active                     => { type => 'boolean', default => 'true' },
+  ar_chart_id                => { type => 'integer', not_null => 1 },
+  copies                     => { type => 'integer' },
+  direct_debit               => { type => 'boolean', default => 'false', not_null => 1 },
+  email_body                 => { type => 'text' },
+  email_recipient_address    => { type => 'text' },
+  email_recipient_contact_id => { type => 'integer' },
+  email_sender               => { type => 'text' },
+  email_subject              => { type => 'text' },
+  end_date                   => { type => 'date' },
+  extend_automatically_by    => { type => 'integer' },
+  first_billing_date         => { type => 'date' },
+  id                         => { type => 'integer', not_null => 1, sequence => 'id' },
+  oe_id                      => { type => 'integer', not_null => 1 },
+  order_value_periodicity    => { type => 'varchar', length => 1, not_null => 1 },
+  periodicity                => { type => 'varchar', length => 1, not_null => 1 },
+  print                      => { type => 'boolean', default => 'false' },
+  printer_id                 => { type => 'integer' },
+  send_email                 => { type => 'boolean', default => 'false', not_null => 1 },
+  start_date                 => { type => 'date' },
+  terminated                 => { type => 'boolean', default => 'false' },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'id' ]);
@@ -34,6 +40,11 @@ __PACKAGE__->meta->foreign_keys(
     key_columns => { ar_chart_id => 'id' },
   },
 
+  email_recipient_contact => {
+    class       => 'SL::DB::Contact',
+    key_columns => { email_recipient_contact_id => 'cp_id' },
+  },
+
   order => {
     class       => 'SL::DB::Order',
     key_columns => { oe_id => 'id' },