SL/DB/Manager/TimeRecording.pm

   1 # This file has been auto-generated only because it didn't exist.
   2 # Feel free to modify it at will; it will not be overwritten automatically.
   3
   4 package SL::DB::Manager::TimeRecording;
   5
   6 use strict;
   7
   8 use parent qw(SL::DB::Helper::Manager);
   9
  10 use SL::DB::Helper::Sorted;
  11
  12 sub object_class { 'SL::DB::TimeRecording' }
  13
  14 __PACKAGE__->make_manager_methods;
  15
  16
  17 sub _sort_spec {
  18   return ( default => [ 'start_time', 1 ],
  19            nulls   => {
  20              date       => 'FIRST',
  21              start_time => 'FIRST',
  22              end_time   => 'FIRST',
  23            },
  24            columns => { SIMPLE       => 'ALL' ,
  25                         start_time   => [ 'date', 'start_time' ],
  26                         end_time     => [ 'date', 'end_time' ],
  27                         customer     => [ 'lower(customer.name)', 'date','start_time'],
  28                         staff_member => [ 'lower(staff_member.name)', 'date','start_time'],
  29                         order        => [ 'order.ordnumber', 'date','start_time'],
  30                         part         => [ 'lower(part.partnumber)', 'date','start_time'],
  31                         project      => [ 'lower(project.projectnumber)', 'date','start_time'],
  32            }
  33   );
  34 }
  35
  36
  37 1;