X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=t%2Fcontrollers%2Fhelpers%2Fparse_filter.t;h=2c10d036b79f22ca7c6357ca36f491c9d7dfc74f;hb=96f2dabc7d64e28c74358fb5745a6c68b18527f3;hp=0511346607ac1a35c994dc90f134da34a46a5850;hpb=05047096df7e18aad6331c61e705499c2820ddde;p=kivitendo-erp.git diff --git a/t/controllers/helpers/parse_filter.t b/t/controllers/helpers/parse_filter.t index 051134660..2c10d036b 100644 --- a/t/controllers/helpers/parse_filter.t +++ b/t/controllers/helpers/parse_filter.t @@ -1,6 +1,6 @@ use lib 't'; -use Test::More tests => 31; +use Test::More tests => 38; use Test::Deep; use Data::Dumper; @@ -179,6 +179,44 @@ test { } }, 'deep laundering, check for laundered hash', target => 'launder', launder_to => { }; +test { + part => { + 'sellprice:number' => '2', + 'sellprice:number::' => 'le', + } +}, { + part => { + 'sellprice:number' => '2', + 'sellprice:number::' => 'le', + } +}, 'laundering of indirect filters does not alter', target => 'filter', launder_to => { }; + +test { + part => { + 'sellprice:number' => '2', + 'sellprice:number::' => 'le', + } +}, { + part => { + 'sellprice_number' => '2', + 'sellprice_number__' => 'le', + } +}, 'laundering of indirect filters', target => 'launder', launder_to => { }; + +test { + part => { + 'sellprice:number' => '2', + 'sellprice:number::' => 'le', + } +}, { + part => { + 'sellprice:number' => '2', + 'sellprice:number::' => 'le', + 'sellprice_number' => '2', + 'sellprice_number__' => 'le', + } +}, 'laundering of indirect filters - inplace', target => 'filter'; + ### bug: sub objects test { @@ -291,7 +329,8 @@ test { 'part.partnumber', { ilike => '%1%' } - ] + ], + with_objects => [ 'part' ], }, 'Regression check: prefixing of fallback filtering in relation with custom filters', class => 'SL::DB::Manager::OrderItem'; test { 'description:substr:multi::ilike' => 'term1 term2', @@ -334,3 +373,50 @@ test { ] ] }, ':multi with complex tokenizing'; + +# test tokenizing for custom filters by monkeypatching a custom filter into Part +SL::DB::Manager::Part->add_filter_specs( + test => sub { + my ($key, $value, $prefix, @additional) = @_; + return "$prefix$key" => { @additional, $value }; + } +); + +test { + 'part.test.what' => 2, +}, { + query => [ + 'part.test' => { 'what', 2 }, + ] +}, 'additional tokens', class => 'SL::DB::Manager::OrderItem'; + +test { + 'part.test.what:substr::ilike' => 2, +}, { + query => [ + 'part.test' => { 'what', { ilike => '%2%' } }, + ] +}, 'additional tokens + filters + methods', class => 'SL::DB::Manager::OrderItem'; + +test { + 'orderitems.part.test.what:substr::ilike' => 2, +}, { + query => [ + 'orderitems.part.test' => { 'what', { ilike => '%2%' } }, + ] +}, 'relationship + additional tokens + filters + methods', class => 'SL::DB::Manager::Order'; + +test { + part => { + 'obsolete::lazy_bool_eq' => '0', + }, +}, { + query => [ + or => [ + 'part.obsolete' => undef, + 'part.obsolete' => 0 + ], + ], + with_objects => [ 'part' ], +}, 'complex methods modifying the key'; +