fix suggest po

2 files changed, 26 insertions, 3 deletions

diff --git a/indoteknik_custom/models/purchase_order_line.py b/indoteknik_custom/models/purchase_order_line.py
index ca0e77ab..9406f85f 100755
--- a/indoteknik_custom/models/purchase_order_line.py
+++ b/indoteknik_custom/models/purchase_order_line.py
@@ -33,10 +33,21 @@ class PurchaseOrderLine(models.Model):
     indent = fields.Boolean(string='Indent', help='centang ini jika barang indent')
     is_ltc = fields.Boolean(string='Sudah di LTC', default=False, help='centang ini jika barang sudah di LTC')
     note = fields.Char(string='Note')
+    qty_reserved = fields.Float(string='Qty Reserved', compute='_compute_qty_reserved')
+
+    def _compute_qty_reserved(self):
+        for line in self:
+            sale_line = self.env['sale.order.line'].search([
+                ('product_id', '=', line.product_id.id),
+                ('order_id', '=', line.order_id.sale_order_id.id)
+            ])
+
+            reserved_qty = sum(line.qty_reserved for line in sale_line)
+            line.qty_reserved = reserved_qty
     
     def suggest_purchasing(self):
-        for line in self:
-            if line.qty_available < line.product_qty:
+        for line in self: 
+            if line.product_id.qty_available_bandengan + line.qty_reserved < line.product_qty:
                 line.suggest = 'harus beli'
             else:
                 line.suggest = 'masih cukup'
diff --git a/indoteknik_custom/models/sale_order_line.py b/indoteknik_custom/models/sale_order_line.py
index eda003c7..358cbfe2 100644
--- a/indoteknik_custom/models/sale_order_line.py
+++ b/indoteknik_custom/models/sale_order_line.py
@@ -27,7 +27,19 @@ class SaleOrderLine(models.Model):
     note_procurement = fields.Char(string='Note Detail', help="Harap diisi jika ada keterangan tambahan dari Procurement, agar dapat dimonitoring")
     vendor_subtotal = fields.Float(string='Vendor Subtotal', compute="_compute_vendor_subtotal")
     amount_voucher_disc = fields.Float(string='Voucher Discount')
-    
+    qty_reserved = fields.Float(string='Qty Reserved', compute='_compute_qty_reserved')
+
+    def _compute_qty_reserved(self):
+        for line in self:
+            stock_moves = self.env['stock.move.line'].search([
+                ('product_id', '=', line.product_id.id),
+                ('picking_id.sale_id', '=', line.order_id.id),
+                ('picking_id.state', 'not in', ['cancel', 'done']),
+            ])
+
+            reserved_qty = sum(move.product_uom_qty for move in stock_moves)
+            line.qty_reserved = reserved_qty
+
     def _compute_vendor_subtotal(self):
         for line in self:
             if line.purchase_price > 0 and line.product_uom_qty > 0: