addons/stock/wizard/stock_fill_inventory.py

   1 # -*- coding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    OpenERP, Open Source Management Solution
   5 #    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
   6 #
   7 #    This program is free software: you can redistribute it and/or modify
   8 #    it under the terms of the GNU Affero General Public License as
   9 #    published by the Free Software Foundation, either version 3 of the
  10 #    License, or (at your option) any later version.
  11 #
  12 #    This program is distributed in the hope that it will be useful,
  13 #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  14 #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15 #    GNU Affero General Public License for more details.
  16 #
  17 #    You should have received a copy of the GNU Affero General Public License
  18 #    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  19 #
  20 ##############################################################################
  21
  22 from osv import fields, osv
  23 from tools.translate import _
  24
  25 class stock_fill_inventory(osv.osv_memory):
  26     _name = "stock.fill.inventory"
  27     _description = "Import Inventory"
  28     _columns = {
  29         'location_id': fields.many2one('stock.location', 'Location', required=True),
  30         'recursive': fields.boolean("Include children",help="If checked, products contained in child locations of selected location will be included as well."),
  31         'set_stock_zero': fields.boolean("Set to zero",help="If checked, all product quantities will be set to zero to help ensure a real physical inventory is done"),
  32     }
  33     def view_init(self, cr, uid, fields_list, context=None):
  34         """
  35          Creates view dynamically and adding fields at runtime.
  36          @param self: The object pointer.
  37          @param cr: A database cursor
  38          @param uid: ID of the user currently logged in
  39          @param context: A standard dictionary
  40          @return: New arch of view with new columns.
  41         """
  42         if context==None:
  43             context={}
  44         res = super(stock_fill_inventory, self).view_init(cr, uid, fields_list, context=context)
  45         if context.get('active_id', False):
  46             stock = self.pool.get('stock.inventory').browse(cr, uid, context.get('active_id', False))
  47             if stock.state=='done':
  48                 raise osv.except_osv(_('Error!'), _('Stock Inventory is done'))
  49         True
  50
  51     def fill_inventory(self, cr, uid, ids, context=None):
  52         """ To Import stock inventory according to products available in the selected locations.
  53         @param self: The object pointer.
  54         @param cr: A database cursor
  55         @param uid: ID of the user currently logged in
  56         @param ids: the ID or list of IDs if we want more than one
  57         @param context: A standard dictionary
  58         @return:
  59         """
  60         if context is None:
  61             context = {}
  62         inventory_line_obj = self.pool.get('stock.inventory.line')
  63         location_obj = self.pool.get('stock.location')
  64         product_obj = self.pool.get('product.product')
  65         stock_location_obj = self.pool.get('stock.location')
  66         if ids and len(ids):
  67             ids = ids[0]
  68         else:
  69              return {'type': 'ir.actions.act_window_close'}
  70         fill_inventory = self.browse(cr, uid, ids, context=context)
  71         res = {}
  72         res_location = {}
  73         if fill_inventory.recursive :
  74             location_ids = location_obj.search(cr, uid, [('location_id',
  75                              'child_of', fill_inventory.location_id.id)])
  76             for location in location_ids :
  77                 res = location_obj._product_get(cr, uid, location)
  78                 res_location[location] = res
  79         else:
  80             context.update({'compute_child': False})
  81             res = location_obj._product_get(cr, uid,
  82                         fill_inventory.location_id.id, context=context)
  83             res_location[fill_inventory.location_id.id] = res
  84
  85         product_ids = []
  86         for location in res_location.keys():
  87             res = res_location[location]
  88             for product_id in res.keys():
  89                 prod = product_obj.browse(cr, uid, product_id, context=context)
  90                 uom = prod.uom_id.id
  91                 context.update(uom=uom, compute_child=False)
  92                 amount = stock_location_obj._product_get(cr, uid,
  93                          location, [product_id], context=context)[product_id]
  94                 if(amount):
  95                     if fill_inventory.set_stock_zero:
  96                         amount = 0
  97                     line_ids=inventory_line_obj.search(cr, uid,
  98                         [('inventory_id', '=', context['active_ids']),
  99                          ('location_id', '=', location),
 100                          ('product_id', '=', product_id),
 101                          ('product_uom', '=', uom),
 102                         ('product_qty', '=', amount)])
 103                     if not len(line_ids):
 104                         inventory_line = {
 105                             'inventory_id': context['active_ids'][0],
 106                             'location_id': location,
 107                             'product_id': product_id,
 108                             'product_uom': uom,
 109                             'product_qty': amount
 110                         }
 111                         inventory_line_obj.create(cr, uid, inventory_line)
 112                     product_ids.append(product_id)
 113
 114         if(len(product_ids) == 0):
 115             raise osv.except_osv(_('Message !'), _('No product in this location.'))
 116         return {'type': 'ir.actions.act_window_close'}
 117
 118 stock_fill_inventory()
 119
 120 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: