X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/1bbcb32cff12865da20d6f2dabc85d7683dca31e..51072516787d639c5f8df4d487155b4a66b16d6f:/SL/DB/Manager/Stocktaking.pm

diff --git a/SL/DB/Manager/Stocktaking.pm b/SL/DB/Manager/Stocktaking.pm
index 6e6714c87..3481343d9 100644
--- a/SL/DB/Manager/Stocktaking.pm
+++ b/SL/DB/Manager/Stocktaking.pm
@@ -1,14 +1,34 @@
-# This file has been auto-generated only because it didn't exist.
-# Feel free to modify it at will; it will not be overwritten automatically.
-
 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;