ar/ap/gl - neues Relationship "transactions"

Objekt-Verknüpfung ar/ap/gl zu acc_trans-Objekten: one-to-many

Hat man ein ar/ap/gl Objekt kann man sich jetzt alle acc_trans-Einträge
dazu holen.

Die acc_trans-Objekte werden nach acc_trans_id sortiert zurückgegeben.

Die Methode transactions aus Invoice wurde entfernt.

diff --git a/SL/DB/GLTransaction.pm b/SL/DB/GLTransaction.pm
index 078e2b98154b05d4a08901baebcdc125bbbfc8ae..52c8b6e2e28aff250d9ed84000134546d66b862a 100644 (file)
--- a/SL/DB/GLTransaction.pm
+++ b/SL/DB/GLTransaction.pm
@@ -4,11 +4,24 @@ use strict;
 
 use SL::DB::MetaSetup::GLTransaction;
 
 
 use SL::DB::MetaSetup::GLTransaction;
 

-__PACKAGE__->meta->initialize;

 
 # Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
 __PACKAGE__->meta->make_manager_class;
 
 
 # Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
 __PACKAGE__->meta->make_manager_class;
 

+__PACKAGE__->meta->add_relationship(
+  transactions   => {
+    type         => 'one to many',
+    class        => 'SL::DB::AccTransaction',
+    column_map   => { id => 'trans_id' },
+    manager_args => {
+      with_objects => [ 'chart' ],
+      sort_by      => 'acc_trans_id ASC',
+    },
+  },
+);
+
+__PACKAGE__->meta->initialize;
+

 sub abbreviation {
   my $self = shift;
 
 sub abbreviation {
   my $self = shift;
 

diff --git a/SL/DB/Invoice.pm b/SL/DB/Invoice.pm
index 7626793c2890fc8bbbc6857e49756c74c283562e..08c5809731613b643543501acbd455090d7e87cc 100644 (file)
--- a/SL/DB/Invoice.pm
+++ b/SL/DB/Invoice.pm
@@ -45,6 +45,15 @@ __PACKAGE__->meta->add_relationship(
     column_map      => { id => 'trans_id' },
     query_args      => [ module => 'AR' ],
   },
     column_map      => { id => 'trans_id' },
     query_args      => [ module => 'AR' ],
   },

+  transactions   => {
+    type         => 'one to many',
+    class        => 'SL::DB::AccTransaction',
+    column_map   => { id => 'trans_id' },
+    manager_args => {
+      with_objects => [ 'chart' ],
+      sort_by      => 'acc_trans_id ASC',
+    },
+  },

 );
 
 __PACKAGE__->meta->initialize;
 );
 
 __PACKAGE__->meta->initialize;


@@ -351,15 +360,6 @@ sub customervendor {
   goto &customer;
 }
 
   goto &customer;
 }
 

-sub transactions {
-  my ($self) = @_;
-
-  return unless $self->id;
-
-  require SL::DB::AccTransaction;
-  SL::DB::Manager::AccTransaction->get_all(query => [ trans_id => $self->id ]);
-}
-

 1;
 
 __END__
 1;
 
 __END__

diff --git a/SL/DB/PurchaseInvoice.pm b/SL/DB/PurchaseInvoice.pm
index a54f1bd4c49318aac0b271620c59d3ddf1467596..d5955c57cd8a758dc6b519a1a1ebf0b87182625f 100644 (file)
--- a/SL/DB/PurchaseInvoice.pm
+++ b/SL/DB/PurchaseInvoice.pm
@@ -31,6 +31,13 @@ __PACKAGE__->meta->add_relationship(
     column_map      => { id => 'trans_id' },
     query_args      => [ module => 'AP' ],
   },
     column_map      => { id => 'trans_id' },
     query_args      => [ module => 'AP' ],
   },

+  transactions   => {
+    type         => 'one to many',
+    class        => 'SL::DB::AccTransaction',
+    column_map   => { id => 'trans_id' },
+    manager_args => { with_objects => [ 'chart' ],
+                      sort_by      => 'acc_trans_id ASC' }
+  },

 );
 
 __PACKAGE__->meta->initialize;
 );
 
 __PACKAGE__->meta->initialize;