diff options
| -rwxr-xr-x | indoteknik_custom/models/sale_monitoring_detail.py | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/indoteknik_custom/models/sale_monitoring_detail.py b/indoteknik_custom/models/sale_monitoring_detail.py index ef2c832f..8c35b1cc 100755 --- a/indoteknik_custom/models/sale_monitoring_detail.py +++ b/indoteknik_custom/models/sale_monitoring_detail.py @@ -25,6 +25,16 @@ class SaleMonitoringDetail(models.Model): note = fields.Char(string="Note") vendor_id = fields.Many2one('res.partner', string='Vendor') + def _compute_vendor(self): + for r in self: + sale_lines = self.env['sale.order.line'].search([ + ('order_id', '=', r.sale_order_id.id), + ('product_id', '=', r.product_id.id), + ]) + + for line in sale_lines: + r.vendor_id = line.vendor_id.id + def init(self): tools.drop_view_if_exists(self.env.cr, self._table) self.env.cr.execute(""" @@ -55,8 +65,8 @@ class SaleMonitoringDetail(models.Model): get_qty_po(so.id, sol.product_id) AS qty_po, get_qty_received(so.id, sol.product_id) AS qty_po_received, get_qty_reserved(so.id, sol.product_id) as qty_reserved, - get_vendor_id(so.id, sol.product_id) as vendor_id, - sol.note_procurement as note + sol.note_procurement as note, + sol.vendor_id as vendor_id FROM sale_order so JOIN sale_order_line sol ON sol.order_id = so.id JOIN product_product p ON p.id = sol.product_id |