X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FPeriodicInvoicesConfig.pm;h=9cb9998afd40196f237940d6fee9099d5c47b02a;hb=3f90c9cac7fea1568957718eba46dfe5f9a621ce;hp=8860e8c8054104ec6563ac5335839b18d1747775;hpb=6061749dc0ece2873ef61a0c14af1b8a9e46034a;p=kivitendo-erp.git

diff --git a/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm b/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm
index 8860e8c80..9cb9998af 100644
--- a/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm
+++ b/SL/DB/MetaSetup/PeriodicInvoicesConfig.pm
@@ -4,44 +4,56 @@ package SL::DB::PeriodicInvoicesConfig;
 
 use strict;
 
-use base qw(SL::DB::Object);
-
-__PACKAGE__->meta->setup(
-  table   => 'periodic_invoices_configs',
-
-  columns => [
-    id                      => { type => 'integer', not_null => 1, sequence => 'id' },
-    oe_id                   => { type => 'integer', not_null => 1 },
-    periodicity             => { type => 'varchar', length => 10, not_null => 1 },
-    print                   => { type => 'boolean', default => 'false' },
-    printer_id              => { type => 'integer' },
-    copies                  => { type => 'integer' },
-    active                  => { type => 'boolean', default => 'true' },
-    start_date              => { type => 'date' },
-    ar_chart_id             => { type => 'integer', not_null => 1 },
-    terminated              => { type => 'boolean', default => 'false' },
-    end_date                => { type => 'date' },
-    extend_automatically_by => { type => 'integer' },
-  ],
-
-  primary_key_columns => [ 'id' ],
-
-  foreign_keys => [
-    ar_chart => {
-      class       => 'SL::DB::Chart',
-      key_columns => { ar_chart_id => 'id' },
-    },
-
-    order => {
-      class       => 'SL::DB::Order',
-      key_columns => { oe_id => 'id' },
-    },
-
-    printer => {
-      class       => 'SL::DB::Printer',
-      key_columns => { printer_id => 'id' },
-    },
-  ],
+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 },
+  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' ]);
+
+__PACKAGE__->meta->foreign_keys(
+  ar_chart => {
+    class       => 'SL::DB::Chart',
+    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' },
+  },
+
+  printer => {
+    class       => 'SL::DB::Printer',
+    key_columns => { printer_id => 'id' },
+  },
 );
 
 1;