use parent qw(SL::DB::Helper::Manager);
+use SL::DB::Helper::Sorted;
+
sub object_class { 'SL::DB::TimeRecording' }
__PACKAGE__->make_manager_methods;
+
+sub _sort_spec {
+ return ( default => [ 'start_time', 1 ],
+ nulls => {
+ date => 'FIRST',
+ start_time => 'FIRST',
+ end_time => 'FIRST',
+ },
+ columns => { SIMPLE => 'ALL' ,
+ start_time => [ 'date', 'start_time' ],
+ end_time => [ 'date', 'end_time' ],
+ customer => [ 'lower(customer.name)', 'date','start_time'],
+ staff_member => [ 'lower(staff_member.name)', 'date','start_time'],
+ order => [ 'order.ordnumber', 'date','start_time'],
+ part => [ 'lower(part.partnumber)', 'date','start_time'],
+ project => [ 'lower(project.projectnumber)', 'date','start_time'],
+ }
+ );
+}
+
+
1;