- my $limit = $::form->{limit} || 20;
- my $type = $::form->{type} || {};
- my $query = { ilike => "%$::form->{term}%" };
- my @filter;
- push @filter, SL::DB::Manager::Part->type_filter($type);
- push @filter, ($::form->{column})
- ? ($::form->{column} => $query)
- : (or => [ partnumber => $query, description => $query ]);
+ my $value = $::form->{column} || 'description';
+
+ # if someone types something, and hits enter, assume he entered the full name.
+ # if something matches, treat that as sole match
+ # unfortunately get_models can't do more than one per package atm, so we d it
+ # the oldfashioned way.
+ if ($::form->{prefer_exact}) {
+ my $exact_matches;
+ if (1 == scalar @{ $exact_matches = SL::DB::Manager::Part->get_all(
+ query => [
+ obsolete => 0,
+ SL::DB::Manager::Part->type_filter($::form->{filter}{type}),
+ or => [
+ description => { ilike => $::form->{filter}{'all:substr::ilike'} },
+ partnumber => { ilike => $::form->{filter}{'all:substr::ilike'} },
+ ]
+ ],
+ limit => 2,
+ ) }) {
+ $self->parts($exact_matches);
+ }
+ }