Merge lp:~acsone-openerp/stock-logistic-warehouse/7.0-inventory-hierarchical-location-generate-inventory-lga into lp:~numerigraphe-team/stock-logistic-warehouse/7.0-inventory-hierarchical

[Laetitia Gangloff (Acsone)]

Hello,

I add a wizard to easily create inventory and sub-inventory.

[lp:~acsone-openerp/stock-logistic-warehouse/7.0-inventory-hierarchical-location-generate-inventory-lga]

43. By Laetitia Gangloff (Acsone) on 2014-06-19

generate_inventory: prefix to the created inventories / include internal location

[Laetitia Gangloff (Acsone) (laetitia-gangloff)]

Following Loïc idea:
- I add the possibility to choose a prefix for the inventory name. This prefix will concatenate with the location name.
- I add the possibility to include internal location.

[lp:~acsone-openerp/stock-logistic-warehouse/7.0-inventory-hierarchical-location-generate-inventory-lga]

44. By Laetitia Gangloff (Acsone) on 2014-06-20

generate_inventory : rename include internal in only view and adapt code following the change

[Laetitia Gangloff (Acsone) (laetitia-gangloff)]

Following some comments of Loïc:
- I change the possibility to include internal location by the possibility to use only view !

Sorry, for the mistake and thank you to Loïc for his help.

[Loïc Bellier - Numérigraphe (lb-b)]

Work perfectly ! Thanks.

review: Approve (testing, code review)

=== modified file 'stock_inventory_hierarchical_location/__openerp__.py'
--- stock_inventory_hierarchical_location/__openerp__.py	2014-06-12 18:19:17 +0000
+++ stock_inventory_hierarchical_location/__openerp__.py	2014-06-20 13:46:20 +0000
@@ -42,6 +42,7 @@
     """,
     "data": [
         "inventory_hierarchical_location_view.xml",
+        "wizard/generate_inventory_view.xml",
     ],
     "test": ["tests/inventory_hierarchical_location_test.yml"],
     "demo": ["inventory_hierarchical_location_demo.xml"],
 
=== modified file 'stock_inventory_hierarchical_location/wizard/__init__.py'
--- stock_inventory_hierarchical_location/wizard/__init__.py	2014-06-12 18:19:17 +0000
+++ stock_inventory_hierarchical_location/wizard/__init__.py	2014-06-20 13:46:20 +0000
@@ -19,3 +19,4 @@
 ##############################################################################
 
 from . import stock_fill_location_inventory
+from . import generate_inventory
 
=== added file 'stock_inventory_hierarchical_location/wizard/generate_inventory.py'
--- stock_inventory_hierarchical_location/wizard/generate_inventory.py	1970-01-01 00:00:00 +0000
+++ stock_inventory_hierarchical_location/wizard/generate_inventory.py	2014-06-20 13:46:20 +0000
@@ -0,0 +1,134 @@
+# -*- coding: utf-8 -*-
+#
+#
+#    Authors: Laetitia Gangloff
+#    Copyright (c) 2014 Acsone SA/NV (http://www.acsone.eu)
+#    All Rights Reserved
+#
+#    WARNING: This program as such is intended to be used by professional
+#    programmers who take the whole responsibility of assessing all potential
+#    consequences resulting from its eventual inadequacies and bugs.
+#    End users who are looking for a ready-to-use solution with commercial
+#    guarantees and support are strongly advised to contact a Free Software
+#    Service Company.
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+#
+
+from openerp.osv import fields, orm
+from openerp.tools.translate import _
+
+
+class GenerateInventoryWizard(orm.TransientModel):
+    """ This wizard generate an inventory and all related sub-inventories for the specified location and level
+    Example: location = Stock / level = 1 => 1 inventory on Stock (similar to create)
+             location = Stock / level = 2 => 1 inventory on Stock, 1 sub-inventory on Shelf1, 1 sub-inventory on Shelf2
+    """
+
+    _name = "stock.generate.inventory"
+    _description = "Generate Inventory"
+
+    _columns = {
+        'prefix_inv_name': fields.char('Inventory prefix', help="Optional prefix for all created inventory"),
+        'location_id': fields.many2one('stock.location', 'Location', required=True),
+        'level': fields.integer("Level", help="number of level between inventory on location_id and sub-inventory"),
+        'only_view': fields.boolean('Only view', help="If set, only inventory on view location can be created"),
+    }
+
+    def _default_location(self, cr, uid, ids, context=None):
+        """Default stock location
+
+        @return: id of the stock location of the first warehouse of the
+        default company"""
+        location_id = False
+        company_id = self.pool['res.company']._company_default_get(
+            cr, uid, 'stock.warehouse', context=context)
+        warehouse_id = self.pool['stock.warehouse'].search(
+            cr, uid, [('company_id', '=', company_id)], limit=1)
+        if warehouse_id:
+            location_id = self.pool['stock.warehouse'].read(
+                cr, uid, warehouse_id[0], ['lot_stock_id'])['lot_stock_id'][0]
+        return location_id
+
+    _defaults = {
+        'location_id': _default_location,
+        'level': 1,
+        'only_view': True,
+    }
+
+    _sql_constraints = [
+        ('level', 'CHECK (level>0)', 'Level must be positive!'),
+    ]
+
+    def _create_subinventory(self, cr, uid, inventory_ids, prefix_inv_name, only_view, context):
+        new_inventory_ids = []
+        for inventory_id in inventory_ids:
+            location_id = self.pool['stock.inventory'].read(cr, uid, inventory_id, ['location_id'], context=context)['location_id'][0]
+            domain = [('location_id', '=', location_id)]
+            if only_view:
+                domain.append(('usage', '=', 'view'))
+            location_ids = self.pool['stock.location'].search(cr, uid, domain, context=context)
+            for location_id in location_ids:
+                location_name = self.pool['stock.location'].read(cr, uid, location_id, ['name'], context=context)['name']
+                new_inventory_ids.append(self.pool['stock.inventory'].create(cr, uid, {'name': prefix_inv_name + location_name,
+                                                                                       'exhaustive': True,
+                                                                                       'location_id': location_id,
+                                                                                       'parent_id': inventory_id}, context=context))
+        return new_inventory_ids
+
+    def generate_inventory(self, cr, uid, ids, context=None):
+        """ Generate inventory and sub-inventories for specified location and level
+
+        @param self: The object pointer.
+        @param cr: A database cursor
+        @param uid: ID of the user currently logged in
+        @param ids: the ID or list of IDs if we want more than one
+        @param context: A standard dictionary
+        @return:
+        """
+        if context is None:
+            context = {}
+
+        if ids and len(ids):
+            ids = ids[0]
+        else:
+            return {'type': 'ir.actions.act_window_close'}
+        generate_inventory = self.browse(cr, uid, ids, context=context)
+        # create first level inventory
+        prefix_inv_name = generate_inventory.prefix_inv_name or ''
+        location_id = generate_inventory.location_id.id
+        only_view = generate_inventory.only_view
+        parent_inventory_id = self.pool['stock.inventory'].create(cr, uid, {'name': prefix_inv_name + generate_inventory.location_id.name,
+                                                                            'exhaustive': True,
+                                                                            'location_id': location_id}, context=context)
+
+        inventory_ids = [parent_inventory_id]
+        for i in range(1, generate_inventory.level):
+            inventory_ids = self._create_subinventory(cr, uid, inventory_ids, prefix_inv_name, only_view, context)
+
+        mod_obj = self.pool['ir.model.data']
+        result = mod_obj.get_object_reference(cr, uid, 'stock', 'view_inventory_form')
+        view_id = result and result[1] or False
+        return {'name': _('Inventory generated'),
+                'view_mode': 'form',
+                'view_type': 'form',
+                'res_model': 'stock.inventory',
+                'type': 'ir.actions.act_window',
+                'view_id': view_id,
+                'res_id': int(parent_inventory_id),
+                }
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 
=== added file 'stock_inventory_hierarchical_location/wizard/generate_inventory_view.xml'
--- stock_inventory_hierarchical_location/wizard/generate_inventory_view.xml	1970-01-01 00:00:00 +0000
+++ stock_inventory_hierarchical_location/wizard/generate_inventory_view.xml	2014-06-20 13:46:20 +0000
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+           <record id="view_stock_generate_inventory" model="ir.ui.view">
+            <field name="name">Generate Inventory</field>
+            <field name="model">stock.generate.inventory</field>
+            <field name="arch" type="xml">
+              <form string="Generate Inventory" version="7.0">
+                  <separator string="Generate inventory"/>
+                  <group>
+                      <field name="prefix_inv_name"/>
+                      <field name="location_id"/>
+                      <field name="only_view"/>
+                      <field name="level"/>
+                  </group>
+                  <footer>
+                      <button name="generate_inventory" string="Generate Inventory" type="object" class="oe_highlight"/>
+                      or
+                      <button string="Cancel" class="oe_link" special="cancel" />
+                  </footer>
+              </form>
+            </field>
+        </record>
+
+        <record id="action_view_stock_generate_inventory" model="ir.actions.act_window">
+            <field name="name">Generate Inventory</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">stock.generate.inventory</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">form</field>
+            <field name="view_id" ref="view_stock_generate_inventory"/>
+            <field name="target">new</field>
+        </record>
+
+    <menuitem action="action_view_stock_generate_inventory"
+              id="menu_action_stock_generate_inventory_form"
+              parent="stock.menu_stock_inventory_control"
+              sequence="20"
+              groups="stock.group_locations"/>
+
+    </data>
+</openerp>