X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/385bc4be4a927753ba4f1c7a426ede8fbed67123..22f2c3e86aeea63b9e25b6ba249ca9062ae337f8:/SL/DB/Manager/TimeRecording.pm

diff --git a/SL/DB/Manager/TimeRecording.pm b/SL/DB/Manager/TimeRecording.pm
index f0c7f429e..6992aa10d 100644
--- a/SL/DB/Manager/TimeRecording.pm
+++ b/SL/DB/Manager/TimeRecording.pm
@@ -7,8 +7,27 @@ use strict;
 
 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'],
+           }
+  );
+}
+
+
 1;