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
  34     def fill_inventory(self, cr, uid, ids, context):
  35         """ To Import stock inventory according to products available in the selected locations.
  36         @param self: The object pointer.
  37         @param cr: A database cursor
  38         @param uid: ID of the user currently logged in
  39         @param ids: the ID or list of IDs if we want more than one
  40         @param context: A standard dictionary
  41         @return:
  42         """
  43         inventory_line_obj = self.pool.get('stock.inventory.line')
  44         location_obj = self.pool.get('stock.location')
  45         product_obj = self.pool.get('product.product')
  46         stock_location_obj = self.pool.get('stock.location')
  47         if ids and len(ids):
  48             ids = ids[0]
  49         else:
  50              return {}
  51         fill_inventory = self.browse(cr, uid, ids)
  52         res = {}
  53         res_location = {}
  54         if fill_inventory.recursive :
  55             location_ids = location_obj.search(cr, uid, [('location_id',
  56                              'child_of', fill_inventory.location_id.id)])
  57             for location in location_ids :
  58                 res = location_obj._product_get(cr, uid, location)
  59                 res_location[location] = res
  60         else:
  61             context.update({'compute_child': False})
  62             res = location_obj._product_get(cr, uid,
  63                         fill_inventory.location_id.id, context=context)
  64             res_location[fill_inventory.location_id.id] = res
  65
  66         product_ids = []
  67         for location in res_location.keys():
  68             res = res_location[location]
  69             for product_id in res.keys():
  70                 prod = product_obj.browse(cr, uid, [product_id])[0]
  71                 uom = prod.uom_id.id
  72                 context.update(uom=uom, compute_child=False)
  73                 amount = stock_location_obj._product_get(cr, uid,
  74                          location, [product_id], context=context)[product_id]
  75                 if(amount):
  76                     if fill_inventory.set_stock_zero:
  77                         amount = 0
  78                     line_ids=inventory_line_obj.search(cr, uid,
  79                         [('inventory_id', '=', context['active_ids']),
  80                          ('location_id', '=', location),
  81                          ('product_id', '=', product_id),
  82                          ('product_uom', '=', uom),
  83                         ('product_qty', '=', amount)])
  84                     if not len(line_ids):
  85                         inventory_line = {
  86                             'inventory_id': context['active_ids'][0],
  87                             'location_id': location,
  88                             'product_id': product_id,
  89                             'product_uom': uom,
  90                             'product_qty': amount
  91                         }
  92                         inventory_line_obj.create(cr, uid, inventory_line)
  93                     product_ids.append(product_id)
  94
  95         if(len(product_ids) == 0):
  96             raise osv.except_osv(_('Message !'), _('No product in this location.'))
  97         return {}
  98
  99 stock_fill_inventory()
 100
 101 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: