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;