fix sale monitoring detail query

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