package SL::DB::Manager::DeliveryTerm;

use strict;

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

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

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

__PACKAGE__->make_manager_methods;

sub _sort_spec {
  return ( default => [ 'sortkey', 1 ],
           columns => { SIMPLE => 'ALL',
                        map { ( $_ => "lower(delivery_terms.${_})" ) } qw(description description_long),
                      });
}

sub get_valid {
  my ($class, $with_this_id) = @_;

  my @conditions = (obsolete => 0);

  if ($with_this_id) {
    @conditions = (
      or => [
        id => $with_this_id,
        @conditions,
      ]);
  }

  return $class->get_all_sorted(query => \@conditions);
}

1;