SL/DB/Manager/Shipto.pm

   1 package SL::DB::Manager::Shipto;
   2
   3 use strict;
   4
   5 use SL::DB::Helper::Manager;
   6 use base qw(SL::DB::Helper::Manager);
   7
   8 use SL::DB::Helper::Sorted;
   9
  10 sub object_class { 'SL::DB::Shipto' }
  11
  12 __PACKAGE__->make_manager_methods;
  13
  14 sub _sort_spec {
  15   return (
  16     default        => [ 'full_address', 1 ],
  17     columns        => {
  18       SIMPLE       => 'ALL',
  19       full_address => '( lower(shipto.shiptoname) || lower(shipto.shiptostreet) || lower(shipto.shiptocity) )',
  20       map { ( $_ => "lower(shipto.shipto$_)" ) } qw(city contact country department_1 department_2 email fax name phone street zipcode)
  21     });
  22 }
  23
  24 1;