X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FHelper%2FTransNumberGenerator.pm;h=9684677c22cfcd3be8db456e654e536e32d37f62;hb=89ade8da54d47af2cbf100fac07bf88ed9f23c43;hp=cc5fc327c4e095a7017c872c40ad578ec91b318a;hpb=45659209a7151609c68e28281fe06407076cea5f;p=kivitendo-erp.git diff --git a/SL/DB/Helper/TransNumberGenerator.pm b/SL/DB/Helper/TransNumberGenerator.pm index cc5fc327c..9684677c2 100644 --- a/SL/DB/Helper/TransNumberGenerator.pm +++ b/SL/DB/Helper/TransNumberGenerator.pm @@ -22,18 +22,18 @@ sub parts_scoping { SL::DB::Manager::Part->type_filter($_[0]); } -my %specs = ( ar => { number_column => 'invnumber', fill_holes_in_range => 1 }, - sales_quotation => { number_column => 'quonumber', number_range_column => 'sqnumber', scoping => \&oe_scoping, }, - sales_order => { number_column => 'ordnumber', number_range_column => 'sonumber', scoping => \&oe_scoping, }, - request_quotation => { number_column => 'quonumber', number_range_column => 'rfqnumber', scoping => \&oe_scoping, }, - purchase_order => { number_column => 'ordnumber', number_range_column => 'ponumber', scoping => \&oe_scoping, }, - sales_delivery_order => { number_column => 'donumber', number_range_column => 'sdonumber', scoping => \&do_scoping, fill_holes_in_range => 1 }, - purchase_delivery_order => { number_column => 'donumber', number_range_column => 'pdonumber', scoping => \&do_scoping, fill_holes_in_range => 1 }, - customer => { number_column => 'customernumber', number_range_column => 'customernumber', }, - 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 => 'assemblynumber', scoping => \&parts_scoping }, +my %specs = ( ar => { number_column => 'invnumber', }, + sales_quotation => { number_column => 'quonumber', number_range_column => 'sqnumber', scoping => \&oe_scoping, }, + sales_order => { number_column => 'ordnumber', number_range_column => 'sonumber', scoping => \&oe_scoping, }, + request_quotation => { number_column => 'quonumber', number_range_column => 'rfqnumber', scoping => \&oe_scoping, }, + purchase_order => { number_column => 'ordnumber', number_range_column => 'ponumber', scoping => \&oe_scoping, }, + sales_delivery_order => { number_column => 'donumber', number_range_column => 'sdonumber', scoping => \&do_scoping, }, + purchase_delivery_order => { number_column => 'donumber', number_range_column => 'pdonumber', scoping => \&do_scoping, }, + customer => { number_column => 'customernumber', number_range_column => 'customernumber', }, + 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 => 'assemblynumber', scoping => \&parts_scoping, }, ); sub get_next_trans_number { @@ -46,7 +46,7 @@ sub get_next_trans_number { my $number = $self->$number_column; my $number_range_column = $spec->{number_range_column} || $number_column; my $scoping_conditions = $spec->{scoping}; - my $fill_holes_in_range = $spec->{fill_holes_in_range}; + my $fill_holes_in_range = !$spec->{keep_holes_in_range}; return $number if $self->id && $number; @@ -75,7 +75,7 @@ sub get_next_trans_number { my $range_table = $business ? $business : SL::DB::Default->get; my $start_number = $range_table->$number_range_column; $start_number = $range_table->articlenumber if ($number_range_column eq 'assemblynumber') && (length($start_number) < 1); - my $sequence = SL::PrefixedNumber->new(number => $start_number); + my $sequence = SL::PrefixedNumber->new(number => $start_number // 0); if (!$fill_holes_in_range) { my @numbers = map { $_->$number_column } @{ $self->_get_manager_class->get_all(%conditions) }; @@ -139,8 +139,7 @@ prefix, if present, will be kept intact. Now the number itself is increased as often as neccessary to create a unique one by comparing the generated numbers with the existing ones retrieved in the first step. In this step gaps in the assigned numbers -are filled for some tables (e.g. invoices) but not for others -(e.g. sales orders). +are filled for all currently supported tables. After creating the unique record number this function can update C<$self> and the C table if requested. This is controlled