X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FVendor.pm;h=53ac297b5f3182dfe4d2917a81c994502674afe6;hb=9d6a2ef23cd5586ed4ea3d5a8d59362220251d68;hp=d1d972a1586e881f250f5c8e6223cbbdfc2fc952;hpb=f87763cd84d89aafc4c4110ba42d041b02ce4371;p=kivitendo-erp.git diff --git a/SL/DB/Vendor.pm b/SL/DB/Vendor.pm index d1d972a15..53ac297b5 100644 --- a/SL/DB/Vendor.pm +++ b/SL/DB/Vendor.pm @@ -13,13 +13,25 @@ __PACKAGE__->meta->add_relationship( class => 'SL::DB::Shipto', column_map => { id => 'trans_id' }, manager_args => { sort_by => 'lower(shipto.shiptoname)' }, - query_args => [ 'shipto.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;