use SL::DB::Helper::Manager;
use base qw(SL::DB::Helper::Manager);
+use SL::DB::Helper::Filtered;
use SL::DB::Helper::Paginated;
use SL::DB::Helper::Sorted;
sub object_class { 'SL::DB::OrderItem' }
__PACKAGE__->make_manager_methods;
+__PACKAGE__->add_filter_specs(
+ reqdate => sub {
+ my ($key, $value, $prefix) = @_;
+
+ return or => [
+ $prefix . reqdate => $value,
+ and => [
+ $prefix . reqdate => undef,
+ $prefix . 'order.reqdate' => $value,
+ ]
+ ], $prefix . 'order';
+ },
+);
+
sub _sort_spec {
return ( columns => { delivery_date => [ 'deliverydate', ],
orddate => [ 'order.orddate' ],
sellprice => [ 'sellprice' ],
discount => [ 'discount' ],
- transdate => [ 'transdate::date', 'order.reqdate' ],
+ transdate => [ 'orderitems.transdate::date', 'order.reqdate' ],
},
default => [ 'position', 1 ],
nulls => { }
);
}
-sub default_objects_per_page { 40 }
+sub default_objects_per_page { 15 }
1;