package SL::DB::Manager::Contact;

use strict;

use SL::DB::Helper::Manager;
use base qw(SL::DB::Helper::Manager);

use SL::DB::Helper::Sorted;

sub object_class { 'SL::DB::Contact' }

__PACKAGE__->make_manager_methods;

sub _sort_spec {
  return (
    default     => [ 'full_name', 1 ],
    columns     => {
      SIMPLE    => 'ALL',
      full_name => [ 'lower(contacts.cp_name)', 'lower(contacts.cp_givenname)', ],
      map { ( $_ => "lower(contacts.cp_$_)" ) } qw(abteilung city email fax givenname mobile1 mobile2 name phone1 phone2 position privatemail privatphone project satfax satphone street title zipcode)
    });
}

1;