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 },
- ],
-
- primary_key_columns => [ 'id' ],
-
- foreign_keys => [
- ar_chart => {
- class => 'SL::DB::Chart',
- key_columns => { ar_chart_id => 'id' },
- },
-
- oe => {
- 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;