X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FHelper%2FTransNumberGenerator.pm;h=a6f4e2e85badc41c1e902b557e6841ffce765f48;hb=701674940c1daf886257a14c5e933fcda2a1883d;hp=4b4fe126d50ad3547b75135af5d630ee2532edc9;hpb=6858b66bb7d401245459f5148c2c1ea28f71bfca;p=kivitendo-erp.git diff --git a/SL/DB/Helper/TransNumberGenerator.pm b/SL/DB/Helper/TransNumberGenerator.pm index 4b4fe126d..a6f4e2e85 100644 --- a/SL/DB/Helper/TransNumberGenerator.pm +++ b/SL/DB/Helper/TransNumberGenerator.pm @@ -8,7 +8,7 @@ our @EXPORT = qw(get_next_trans_number create_trans_number); use Carp; use List::Util qw(max); -use SL::DB::Default; +use SL::PrefixedNumber; sub oe_scoping { SL::DB::Manager::Order->type_filter($_[0]); @@ -33,7 +33,7 @@ my %specs = ( ar => { number_column => 'invnumber', vendor => { number_column => 'vendornumber', number_range_column => 'vendornumber', }, part => { number_column => 'partnumber', number_range_column => 'articlenumber', scoping => \&parts_scoping }, service => { number_column => 'partnumber', number_range_column => 'servicenumber', scoping => \&parts_scoping }, - assembly => { number_column => 'partnumber', number_range_column => 'articlenumber', scoping => \&parts_scoping }, + assembly => { number_column => 'partnumber', number_range_column => 'assemblynumber', scoping => \&parts_scoping }, ); sub get_next_trans_number { @@ -50,34 +50,24 @@ sub get_next_trans_number { return $number if $self->id && $number; - my $re = '^(.*?)(\d+)$'; - my %conditions = $scoping_conditions ? ( query => [ $scoping_conditions->($spec_type) ] ) : (); - my @numbers = map { $_->$number_column } @{ $self->_get_manager_class->get_all(%conditions) }; - my %numbers_in_use = map { ( $_ => 1 ) } @numbers; - @numbers = grep { $_ } map { my @matches = m/$re/; @matches ? $matches[-1] * 1 : undef } @numbers; - - my $defaults = SL::DB::Default->get; - my $number_range = $defaults->$number_range_column; - my @matches = $number_range =~ m/$re/; - my $prefix = (2 != scalar(@matches)) ? '' : $matches[ 0]; - my $ref_number = !@matches ? '1' : $matches[-1]; - my $min_places = length($ref_number); - - my $new_number = $fill_holes_in_range ? $ref_number : max($ref_number, @numbers); - my $new_number_full = undef; - - while (1) { - $new_number = $new_number + 1; - my $new_number_s = $new_number; - $new_number_s =~ s/\.\d+//g; - $new_number_full = $prefix . ('0' x max($min_places - length($new_number_s), 0)) . $new_number_s; - last if !$numbers_in_use{$new_number_full}; - } - - $defaults->update_attributes($number_range_column => $new_number_full) if $params{update_defaults}; - $self->$number_column($new_number_full) if $params{update_record}; - - return $new_number_full; + my %conditions = $scoping_conditions ? ( query => [ $scoping_conditions->($spec_type) ] ) : (); + my @numbers = map { $_->$number_column } @{ $self->_get_manager_class->get_all(%conditions) }; + my %numbers_in_use = map { ( $_ => 1 ) } @numbers; + + require SL::DB::Default; + my $defaults = SL::DB::Default->get; + $number_range_column = 'articlenumber' if $number_range_column eq 'assemblynumber' and length($defaults->$number_range_column) < 1; + my $sequence = SL::PrefixedNumber->new(number => ($defaults->$number_range_column || 1)); + + $sequence->set_to_max(@numbers) if !$fill_holes_in_range; + + my $new_number = $sequence->get_next; + $new_number = $sequence->get_next while $numbers_in_use{$new_number}; + + $defaults->update_attributes($number_range_column => $new_number) if $params{update_defaults}; + $self->$number_column($new_number) if $params{update_record}; + + return $new_number; } sub create_trans_number {