kivitendo/SL/DB/Manager/Shipto.pm @ 2d9aec57
| 5b8e9fcb | Moritz Bunkus | package SL::DB::Manager::Shipto;
|
|
use strict;
|
|||
use SL::DB::Helper::Manager;
|
|||
use base qw(SL::DB::Helper::Manager);
|
|||
use SL::DB::Helper::Sorted;
|
|||
sub object_class { 'SL::DB::Shipto' }
|
|||
__PACKAGE__->make_manager_methods;
|
|||
sub _sort_spec {
|
|||
return (
|
|||
default => [ 'full_address', 1 ],
|
|||
columns => {
|
|||
SIMPLE => 'ALL',
|
|||
full_address => '( lower(shipto.shiptoname) || lower(shipto.shiptostreet) || lower(shipto.shiptocity) )',
|
|||
map { ( $_ => "lower(shipto.shipto$_)" ) } qw(city contact country department_1 department_2 email fax name phone street zipcode)
|
|||
});
|
|||
}
|
|||
1;
|