X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=t%2Fdb_helper%2Frecord_links.t;h=5df89a405bfd2a268779d4da6c97a5188c04a9fe;hb=1b78cf64795c68736a33059dfa0ad81cbc50e812;hp=851f9cb5ce10a739f6b733b3edda831367412616;hpb=f5701b02123494f8dacbea8c5de00cf7a6edba70;p=kivitendo-erp.git diff --git a/t/db_helper/record_links.t b/t/db_helper/record_links.t index 851f9cb5c..5df89a405 100644 --- a/t/db_helper/record_links.t +++ b/t/db_helper/record_links.t @@ -1,4 +1,4 @@ -use Test::More tests => 43; +use Test::More tests => 49; use strict; @@ -9,6 +9,7 @@ use Carp; use Data::Dumper; use Support::TestSetup; use Test::Exception; +use List::Util qw(max); use SL::DB::Buchungsgruppe; use SL::DB::Currency; @@ -19,35 +20,44 @@ use SL::DB::Order; use SL::DB::DeliveryOrder; use SL::DB::Part; use SL::DB::Unit; +use SL::DB::TaxZone; -my ($customer, $currency_id, $buchungsgruppe, $employee, $vendor); +my ($customer, $currency_id, $buchungsgruppe, $employee, $vendor, $taxzone); my ($link, $links, $o1, $o2, $d, $i); -sub reset_state { - my %params = @_; - - $params{$_} ||= {} for qw(buchungsgruppe unit customer part tax); - +sub clear_up { SL::DB::Manager::DeliveryOrder->delete_all(all => 1); SL::DB::Manager::Order->delete_all(all => 1); SL::DB::Manager::Invoice->delete_all(all => 1); + SL::DB::Manager::Part->delete_all(all => 1); SL::DB::Manager::Customer->delete_all(all => 1); SL::DB::Manager::Vendor->delete_all(all => 1); +}; + +sub reset_state { + my %params = @_; + + $params{$_} ||= {} for qw(buchungsgruppe unit customer part tax); + + clear_up(); $buchungsgruppe = SL::DB::Manager::Buchungsgruppe->find_by(description => 'Standard 19%', %{ $params{buchungsgruppe} }) || croak "No accounting group"; $employee = SL::DB::Manager::Employee->current || croak "No employee"; + $taxzone = SL::DB::Manager::TaxZone->find_by( description => 'Inland') || croak "No taxzone"; $currency_id = $::instance_conf->get_currency_id; $customer = SL::DB::Customer->new( name => 'Test Customer', currency_id => $currency_id, + taxzone_id => $taxzone->id, %{ $params{customer} } )->save; $vendor = SL::DB::Vendor->new( name => 'Test Vendor', currency_id => $currency_id, + taxzone_id => $taxzone->id, %{ $params{vendor} } )->save; } @@ -60,7 +70,7 @@ sub new_order { currency_id => $currency_id, employee_id => $employee->id, salesman_id => $employee->id, - taxzone_id => 0, + taxzone_id => $taxzone->id, quotation => 0, %params, )->save; @@ -74,7 +84,7 @@ sub new_delivery_order { currency_id => $currency_id, employee_id => $employee->id, salesman_id => $employee->id, - taxzone_id => 0, + taxzone_id => $taxzone->id, %params, )->save; } @@ -88,8 +98,8 @@ sub new_invoice { employee_id => $employee->id, salesman_id => $employee->id, gldate => DateTime->today_local->to_kivitendo, - taxzone_id => 0, invoice => 1, + taxzone_id => $taxzone->id, type => 'invoice', %params, )->save; @@ -99,7 +109,6 @@ Support::TestSetup::login(); reset_state(); - $o1 = new_order(); $i = new_invoice(); @@ -167,7 +176,10 @@ $i = new_invoice(); $o2->link_to_record($d); $d->link_to_record($i); - +# at this point the structure is: +# +# o1 <--> o2 ---> d ---> i +# $links = $d->linked_records(direction => 'both', to => 'Invoice', from => 'Order', sort_by => 'customer_id', sort_dir => 1); is $links->[0]->id, $o2->id, 'both with different from/to 1'; @@ -181,6 +193,10 @@ $links = $o2->linked_records(direction => 'to', to => 'DeliveryOrder'); is @$links, 1, 'double link is only added once 1'; $d->link_to_record($o2, bidirectional => 1); +# at this point the structure is: +# +# o1 <--> o2 <--> d ---> i +# $links = $o2->linked_records(direction => 'to', to => 'DeliveryOrder'); is @$links, 1, 'double link is only added once 2'; @@ -203,8 +219,12 @@ $links = $o1->linked_records(direction => 'from', from => 'Order'); is $links->[0]->{_record_link_direction}, 'from', '_record_link_direction from'; is $links->[0]->{_record_link}->to_id, $o1->id, '_record_link from'; -# check if bidi returns an array of links +# check if bidi returns an array of links even if aready existing my @links = $d->link_to_record($o2, bidirectional => 1); +# at this point the structure is: +# +# o1 <--> o2 <--> d ---> i +# is @links, 2, 'bidi returns array of links in array context'; # via @@ -219,15 +239,16 @@ is $links->[0]->id, $i->id, 'simple case via links (2 hops)'; # multiple links in the same direction from one object $o1->link_to_record($d); -$links = $o2->linked_records(direction => 'to', to => 'Invoice', via => 'DeliveryOrder'); -is $links->[0]->id, $i->id, 'simple case via links (string)'; - # at this point the structure is: # -# o1 <--> o2 ---> d ---> i +# o1 <--> o2 <--> d ---> i # \____________,^ # +$links = $o2->linked_records(direction => 'to', to => 'Invoice', via => 'DeliveryOrder'); +is $links->[0]->id, $i->id, 'simple case via links (string)'; + + # o1 must have 2 linked records now: $links = $o1->linked_records(direction => 'to'); is @$links, 2, 'more than one link'; @@ -278,4 +299,25 @@ is_deeply $sorted, [$o2, $i, $o1, $d], 'sorting by transdate'; $sorted = SL::DB::Helper::LinkedRecords->sort_linked_records('date', 0, @records); is_deeply $sorted, [$d, $o1, $i, $o2], 'sorting by transdate desc'; +# now recursive stuff 2, with backlinks +$links = $o1->linked_records(direction => 'to', recursive => 1, save_path => 1); +is @$links, 4, 'recursive finds all 4 (backlink to self because of bidi o1<->o2)'; + +# because of the link o1->d the longest path should be legth 2. test that +is max(map { $_->{_record_link_depth} } @$links), 2, 'longest path is 2'; + +$links = $o2->linked_records(direction => 'to', recursive => 1); +is @$links, 4, 'recursive from o2 finds 4'; + +$links = $o1->linked_records(direction => 'from', recursive => 1, save_path => 1); +is @$links, 3, 'recursive from o1 finds 3 (not i)'; + +$links = $i->linked_records(direction => 'from', recursive => 1, save_path => 1); +is @$links, 3, 'recursive from i finds 3 (not i)'; + +$links = $o1->linked_records(direction => 'both', recursive => 1, save_path => 1); +is @$links, 4, 'recursive dir=both does not give duplicates'; + +clear_up(); + 1;