package SL::DB::Manager::Stocktaking;

use strict;

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

use SL::DB::Helper::Filtered;
use SL::DB::Helper::Paginated;
use SL::DB::Helper::Sorted;

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

__PACKAGE__->make_manager_methods;

sub _sort_spec {
  return (
    default        => [ 'itime', 1 ],
    columns        => {
      SIMPLE       => 'ALL',
      comment      => 'lower(comment)',
      chargenumber => 'lower(chargenumber)',
      employee     => 'lower(employee.name)',
      ean          => 'lower(parts.ean)',
      partnumber   => 'lower(parts.partnumber)',
      part         => 'lower(parts.description)',
      bin          => ['lower(warehouse.description)', 'lower(bin.description)'],
    });
}

sub default_objects_per_page {
  20;
}

1;