-
product_tmpl_id
-
product_tmpl_id.id
-
id
|
res = {k: {'nbr_reordering_rules': 0, 'reordering_min_qty': 0, 'reordering_max_qty': 0} for k in self.ids}
product_data = self.env['stock.warehouse.orderpoint']._read_group([('product_id.product_tmpl_id', 'in', self.ids)], ['product_id'], ['__count', 'product_min_qty:sum', 'product_max_qty:sum'])
for product, count, product_min_qty, product_max_qty in product_data:
product_tmpl_id = product.product_tmpl_id.id
res[product_tmpl_id]['nbr_reordering_rules'] += count
res[product_tmpl_id]['reordering_min_qty'] = product_min_qty
res[product_tmpl_id]['reordering_max_qty'] = product_max_qty
for template in self:
if not template.id:
template.nbr_reordering_rules = 0
template.reordering_min_qty = 0
template.reordering_max_qty = 0
continue
template.nbr_reordering_rules = res[template.id]['nbr_reordering_rules']
template.reordering_min_qty = res[template.id]['reordering_min_qty']
template.reordering_max_qty = res[template.id]['reordering_max_qty']
|
|