Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 9cd3d899

Von Werner Hahn vor 10 Monaten hinzugefügt

  • ID 9cd3d8991a679a91797ef297a3d5758ec321b9b7
  • Vorgänger 23bb6a8c
  • Nachfolger b0c61725

TopQuickSearch: GL Suche Verkaufrechnungen auch vom Anfang suchen

behebt #657

Unterschiede anzeigen:

SL/Controller/TopQuickSearch/GLTransaction.pm
30 30
  my $apinvnumberquery = { ilike => like($term) };
31 31
  my $namequery        = { ilike => like($term) };
32 32
  my $arinvnumberquery = { ilike => '%' . SL::Util::trim($term) };
33
  my $arinvnumber_right_query = { ilike => SL::Util::trim($term) . '%' };
33 34
  # ar match is more restrictive. Left fuzzy beginning so it also matches "Storno zu $INVNUMBER"
34
  # and numbers like 000123 if you only enter 123.
35
  # When used in quicksearch short numbers like 1 or 11 won't match because of the
36
  # ajax autocomplete minlimit of 3 characters
35
  # and numbers like 000123 if you only enter 123. Right beginning searches from the begin.
37 36

  
38 37
  my (@glfilter, @arfilter, @apfilter);
39 38

  
40 39
  push( @glfilter, (or => [ description => $descriptionquery, reference => $referencequery ] ) );
41
  push( @arfilter, (or => [ invnumber   => $arinvnumberquery, name      => $namequery ] ) );
40
  push( @arfilter, (or => [ invnumber   => $arinvnumberquery, invnumber => $arinvnumber_right_query, name      => $namequery ] ) );
42 41
  push( @apfilter, (or => [ invnumber   => $apinvnumberquery, name      => $namequery ] ) );
43 42

  
44 43
  my $gls = SL::DB::Manager::GLTransaction->get_all(  query => [ @glfilter ], limit => $limit, sort_by => 'transdate DESC');

Auch abrufbar als: Unified diff