Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

[kivitendo-erp.git] / SL / DB / Manager / TimeRecording.pm

diff --git a/SL/DB/Manager/TimeRecording.pm b/SL/DB/Manager/TimeRecording.pm
new file mode 100644 (file)
index 0000000..2a8677d
--- /dev/null
+++ b/SL/DB/Manager/TimeRecording.pm
@@ -0,0 +1,37 @@
+# This file has been auto-generated only because it didn't exist.
+# Feel free to modify it at will; it will not be overwritten automatically.
+
+package SL::DB::Manager::TimeRecording;
+
+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'],
+                        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;