X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FTransNumber.pm;h=9d6d2993aa43e7e8e264604e2298906b08174edf;hb=4252995520f5020735ca33d3fbbe63d9f6d4ef0b;hp=22d96cd3f0dc430ea8db1c47d3e23e1d4a6b5854;hpb=90fb6995eedba7a1f204498e1d7897b6593b95aa;p=kivitendo-erp.git diff --git a/SL/TransNumber.pm b/SL/TransNumber.pm index 22d96cd3f..9d6d2993a 100644 --- a/SL/TransNumber.pm +++ b/SL/TransNumber.pm @@ -69,8 +69,8 @@ sub _get_filters { } elsif ($type =~ /part|service|assembly/) { $filters{trans_number} = "partnumber"; $filters{numberfield} = $type eq 'service' ? 'servicenumber' : 'articlenumber'; + $filters{numberfield} = $type eq 'assembly' ? 'assemblynumber' : $filters{numberfield}; $filters{table} = "parts"; - $filters{where} = $type =~/assembly/ ? 'assembly ' : 'COALESCE(inventory_accno_id, 0) ' . ($type eq 'service' ? '=' : '<>') . ' 0'; } return %filters; @@ -129,6 +129,10 @@ SQL ($business_number) = selectfirst_array_query($form, $self->dbh, qq|SELECT customernumberinit FROM business WHERE id = ?|, $self->business_id) if $self->business_id; my $number = $business_number; ($number) = selectfirst_array_query($form, $self->dbh, qq|SELECT $filters{numberfield} FROM defaults|) if !$number; + if ($filters{numberfield} eq 'assemblynumber' and length($number) < 1) { + $filters{numberfield} = 'articlenumber'; + ($number) = selectfirst_array_query($form, $self->dbh, qq|SELECT $filters{numberfield} FROM defaults|) if !$number; + } $number ||= ''; my $sequence = SL::PrefixedNumber->new(number => $number);