Revision b0c61725
Von Bernd Bleßmann vor etwa 1 Jahr hinzugefügt
| SL/Controller/TopQuickSearch/GLTransaction.pm | ||
|---|---|---|
|
my $limit = $::form->{limit} || 40; # max number of results per type (AR/AP/GL)
|
||
|
my $term = $::form->{term} || '';
|
||
|
|
||
|
my $descriptionquery = { ilike => like($term) };
|
||
|
my $referencequery = { ilike => like($term) };
|
||
|
my $apinvnumberquery = { ilike => like($term) };
|
||
|
my $namequery = { ilike => like($term) };
|
||
|
my $arinvnumberquery = { ilike => '%' . SL::Util::trim($term) };
|
||
|
my $descriptionquery = { ilike => like($term) };
|
||
|
my $referencequery = { ilike => like($term) };
|
||
|
my $apinvnumberquery = { ilike => like($term) };
|
||
|
my $namequery = { ilike => like($term) };
|
||
|
my $arinvnumber_left_query = { ilike => '%' . SL::Util::trim($term) };
|
||
|
my $arinvnumber_right_query = { ilike => SL::Util::trim($term) . '%' };
|
||
|
# ar match is more restrictive. Left fuzzy beginning so it also matches "Storno zu $INVNUMBER"
|
||
|
# and numbers like 000123 if you only enter 123. Right beginning searches from the begin.
|
||
| ... | ... | |
|
my (@glfilter, @arfilter, @apfilter);
|
||
|
|
||
|
push( @glfilter, (or => [ description => $descriptionquery, reference => $referencequery ] ) );
|
||
|
push( @arfilter, (or => [ invnumber => $arinvnumberquery, invnumber => $arinvnumber_right_query, name => $namequery ] ) );
|
||
|
push( @arfilter, (or => [ invnumber => $arinvnumber_left_query, invnumber => $arinvnumber_right_query, name => $namequery ] ) );
|
||
|
push( @apfilter, (or => [ invnumber => $apinvnumberquery, name => $namequery ] ) );
|
||
|
|
||
|
my $gls = SL::DB::Manager::GLTransaction->get_all( query => [ @glfilter ], limit => $limit, sort_by => 'transdate DESC');
|
||
Auch abrufbar als: Unified diff
Kosmetik: Ausrichtung und Variable umbenannt