-
purchase_line_id
-
purchase_line_id.id
-
partner_id
-
product_uom_qty
-
id
|
date_order_days_delta = self.env['ir.config_parameter'].sudo().get_int('purchase_stock.on_time_delivery_days') or 365
order_lines = self.env['purchase.order.line'].search([
('partner_id', 'in', self.ids),
('date_order', '>', fields.Date.today() - timedelta(date_order_days_delta)),
('qty_received', '!=', 0),
('order_id.state', '=', 'purchase'),
('date_promised', '!=', False),
('product_id', 'in', self.env['product.product'].sudo()._search([('type', '!=', 'service')]))
])
lines_quantity = defaultdict(lambda: 0)
moves = self.env['stock.move'].search([
('purchase_line_id', 'in', order_lines.ids),
('state', '=', 'done')])
order_lines.read(['date_promised', 'partner_id', 'product_uom_qty'], load='')
moves.read(['purchase_line_id', 'date'], load='')
moves = moves.filtered(lambda m: m.date.date() <= m.purchase_line_id.date_promised.date())
for move, quantity in zip(moves, moves.mapped('quantity')):
lines_quantity[move.purchase_line_id.id] += quantity
partner_dict = {}
for line in order_lines:
on_time, ordered = partner_dict.get(line.partner_id, (0, 0))
ordered += line.product_uom_qty
on_time += lines_quantity[line.id]
partner_dict[line.partner_id] = (on_time, ordered)
seen_partner = self.env['res.partner']
for partner, numbers in partner_dict.items():
seen_partner |= partner
on_time, ordered = numbers
partner.on_time_rate = on_time / ordered * 100 if ordered else -1
(self - seen_partner).on_time_rate = -1
|
|