Inventur: Eingabemaske und Journal im Inventory-Controller

[kivitendo-erp.git] / SL / DB / Manager / Stocktaking.pm

diff --git a/SL/DB/Manager/Stocktaking.pm b/SL/DB/Manager/Stocktaking.pm
index 6e6714c..3481343 100644 (file)
--- 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;