kivitendo/SL/DB/Manager/Contact.pm @ 43749680
| 3816bb51 | Moritz Bunkus | 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;
|