X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FManager%2FLetter.pm;h=a412cd81beb407d5c4365d480e7ce8ba69845d5d;hb=6822ef0577c60a43d5daf6041936ac962d78bb0b;hp=7be6138543bc1fbc522d7880d799e27a38b2a527;hpb=ebac0f0e96bdd9f2e967c563db1c9a8917d3d146;p=kivitendo-erp.git diff --git a/SL/DB/Manager/Letter.pm b/SL/DB/Manager/Letter.pm index 7be613854..a412cd81b 100644 --- a/SL/DB/Manager/Letter.pm +++ b/SL/DB/Manager/Letter.pm @@ -12,12 +12,26 @@ use SL::DB::Helper::Sorted; sub object_class { 'SL::DB::Letter' } __PACKAGE__->make_manager_methods; +__PACKAGE__->add_filter_specs( + is_sales => sub { + my ($key, $value, $prefix) = @_; + __PACKAGE__->is_sales_filter($value, $prefix); + }, +); + +sub is_sales_filter { + my ($class, $value, $prefix) = @_; + + return () if !defined $value; + return ($prefix . 'customer_id' => { gt => 0 }) if $value; + return ($prefix . 'vendor_id' => { gt => 0 }) if !$value; +} sub _sort_spec { return ( columns => { SIMPLE => 'ALL', customer => [ 'lower(customer.name)', ], }, - default => [ 'date', 1 ], + default => [ 'date', 0 ], nulls => { } ); }