Zeiterfassung: Erweiterung f. Datum und Dauer: DB-Upgrade/Rose; Berichtsanzeige

[mfinanz.git] / SL / DB / Manager / TimeRecording.pm

diff --git a/SL/DB/Manager/TimeRecording.pm b/SL/DB/Manager/TimeRecording.pm
index e1e9b84e15ae8b0eefea74e672c26e507755610b..6992aa10d6345357b4aaad5e50c16e758c21622c 100644 (file)
--- a/SL/DB/Manager/TimeRecording.pm
+++ b/SL/DB/Manager/TimeRecording.pm
@@ -16,8 +16,15 @@ __PACKAGE__->make_manager_methods;
 
 sub _sort_spec {
   return ( default => [ 'start_time', 1 ],
 
 sub _sort_spec {
   return ( default => [ 'start_time', 1 ],

-           columns => { SIMPLE    => 'ALL' ,
-                        customer  => [ 'lower(customer.name)', ],
+           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'],

            }
   );
 }
            }
   );
 }