X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/930e5ecb0d071e20e9fc57e6050859a0a7a5a98d..c92dddcbac622bd6462daff812d73685ad8a2a75:/SL/DB/Customer.pm diff --git a/SL/DB/Customer.pm b/SL/DB/Customer.pm index 55a1ee434..186ad9750 100644 --- a/SL/DB/Customer.pm +++ b/SL/DB/Customer.pm @@ -14,16 +14,27 @@ __PACKAGE__->meta->add_relationship( class => 'SL::DB::Shipto', column_map => { id => 'trans_id' }, manager_args => { sort_by => 'lower(shipto.shiptoname)' }, - query_args => [ 'module' => 'CT' ], + query_args => [ module => 'CT' ], + }, + contacts => { + type => 'one to many', + class => 'SL::DB::Contact', + column_map => { id => 'cp_cv_id' }, + manager_args => { sort_by => 'lower(contacts.cp_name)' }, }, business => { type => 'one to one', class => 'SL::DB::Business', column_map => { business_id => 'id' }, }, + custom_variables => { + type => 'one to many', + class => 'SL::DB::CustomVariable', + column_map => { id => 'trans_id' }, + query_args => [ config_id => [ \"(SELECT custom_variable_configs.id FROM custom_variable_configs WHERE custom_variable_configs.module = 'CT')" ] ], + }, ); -__PACKAGE__->meta->make_manager_class; __PACKAGE__->meta->initialize; __PACKAGE__->before_save('_before_save_set_customernumber'); @@ -32,6 +43,7 @@ sub _before_save_set_customernumber { my ($self) = @_; $self->create_trans_number if $self->customernumber eq ''; + return 1; } sub short_address {