1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
# -*- coding: utf-8 -*-
##############################################################################
#
# OpenERP, Open Source Management Solution
# Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
# Copyright (C) 2010-2012 Camptocamp Austria (<http://www.camptocamp.at>)
#
# 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 osv import fields, osv
import decimal_precision as dp
import one2many_sorted
import logging
class stock_inventory(osv.osv):
_inherit= "stock.inventory"
_columns = {
#'inventory_line_id': fields.one2many('stock.inventory.line', 'inventory_id', 'Inventories', states={'done': [('readonly', True)]}),
'inventory_line_id': one2many_sorted.one2many_sorted
( 'stock.inventory.line'
, 'inventory_id'
, 'Inventories'
, states={'done': [('readonly', True)]}
, order = 'product_id.name' ),
'inventory_line_loc_id': one2many_sorted.one2many_sorted
( 'stock.inventory.line'
, 'inventory_id'
, 'Inventories'
, states={'done': [('readonly', True)]}
, order = 'location_id.name, product_id.name' ),
'move_ids': one2many_sorted.many2many_sorted('stock.move', 'stock_inventory_move_rel', 'inventory_id', 'move_id', 'Created Moves' , order = 'product_id.name, prodlot_id.prefix, prodlot_id.name')
}
_order = 'date desc'
stock_inventory()
class stock_inventory_line(osv.osv):
_inherit = "stock.inventory.line"
_columns = \
{ 'product_qty_calc': fields.float
('Quantity Calculated', digits_compute=dp.get_precision('Product UoM'),readonly=True )
}
stock_inventory_line()
class stock_fill_inventory(osv.osv_memory):
_inherit = "stock.fill.inventory"
_logger = logging.getLogger(__name__)
_columns = {'display_with_zero_qty' : fields.boolean('Display lines with zero')}
def view_init(self, cr, uid, fields_list, context=None):
super(stock_fill_inventory, self).view_init(cr, uid, fields_list, context=context)
return True
def fill_inventory(self, cr, uid, ids, context=None):
#unfortunately not hook
inventory_id = context['id']
self._logger.debug('FGF fill inventory ids, context %s, %s' % (ids,context))
display_with_zero_qty = None
# FIXME - display_with_zero_qty access not possible
#fill_inventory = self.browse(cr, uid, ids, context=context)
#display_with_zero_qty = fill_inventory.display_with_zero_qty
res_all = super(stock_fill_inventory, self).fill_inventory(cr, uid, ids, context)
inventory_line_obj = self.pool.get('stock.inventory.line')
if not display_with_zero_qty:
ids_zero = inventory_line_obj.search(cr, uid, [('inventory_id','=', inventory_id), ('product_qty','=', '0')])
inventory_line_obj.unlink(cr, uid, ids_zero)
ids_update = inventory_line_obj.search(cr, uid, [('inventory_id','=', inventory_id)])
ids2 = ','.join([str(id) for id in ids_update])
if ids_update:
cr.execute("""update stock_inventory_line
set product_qty_calc = product_qty
where id in (%s)""" % ids2)
return res_all
stock_fill_inventory()
|