Merge branch 'release' of bitbucket.org:altafixco/indoteknik-addons into release

1 files changed, 17 insertions, 2 deletions

diff --git a/indoteknik_custom/models/procurement_monitoring_detail.py b/indoteknik_custom/models/procurement_monitoring_detail.py
index 97d35faf..6031e04a 100644
--- a/indoteknik_custom/models/procurement_monitoring_detail.py
+++ b/indoteknik_custom/models/procurement_monitoring_detail.py
@@ -21,6 +21,20 @@ class SaleMonitoringDetail(models.Model):
     qty_po = fields.Integer(string='Qty PO')
     date_order = fields.Datetime(string="Date Order")
     status = fields.Char(string="Status")
+    po_ids = fields.Many2many('purchase.order', string='PO', compute='_compute_po')
+
+    def _compute_po(self):
+        for line in self:
+            query = [
+                ('order_id.sale_order_id', '=', line.sale_order_id.id),
+                ('order_id.approval_status', '=', 'approved'),
+                ('product_id', '=', line.product_id.id),
+            ]
+            pos = self.env['purchase.order.line'].search(query)
+            po_ids = []
+            for po in pos:
+                po_ids.append(po.order_id.id)
+            line.po_ids = po_ids
 
     def init(self):
         tools.drop_view_if_exists(self.env.cr, self._table)
@@ -29,7 +43,8 @@ class SaleMonitoringDetail(models.Model):
             SELECT 
                 *,
                 a.qty_so-a.qty_reserved as qty_suggest,
-                case when a.qty_so-a.qty_reserved > 0 then 'harus beli'
+                case when a.qty_po >= a.qty_so then 'cukup'
+                when a.qty_so-a.qty_reserved > 0 then 'harus beli'
                 else 'cukup' end as status
             FROM
             (
@@ -53,6 +68,6 @@ class SaleMonitoringDetail(models.Model):
                     AND so.create_date >= '2022-08-10'
                     and so.so_status not in ('terproses')
             ) a
-            where a.qty_po < a.qty_so
+            --where a.qty_po < a.qty_so
         )
         """ % self._table)