change view requisition match

1 files changed, 5 insertions, 7 deletions

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index 0ab78530..704ae8c0 100644
--- a/indoteknik_custom/models/requisition.py
+++ b/indoteknik_custom/models/requisition.py
@@ -13,26 +13,24 @@ class RequisitionMatchPO(models.Model):
     _rec_name = 'purchase_id'
 
     id = fields.Integer(string='ID')
-    requisition_id = fields.Many2one('requisition', string='Requisition')
-    line_id = fields.Many2one('requisition.line', string='Requisition Line')
     product_id = fields.Many2one('product.product', string='Product')
-    partner_id = fields.Many2one('res.partner', string='Partner')
-    purchase_id = fields.Many2one('purchase.order', string='Purchase Order')
+    qty_rpo = fields.Float(string='Qty RPO', help='Qty RPO yang sudah di PO namun SO masih Draft')
 
     def init(self):
         tools.drop_view_if_exists(self.env.cr, self._table)
         self.env.cr.execute("""
             create or replace view %s as
-            select rpm.id as id, r.id as requisition_id, rl.id as line_id, rl.product_id, rl.partner_id,
-            rpm.order_id as purchase_id, r.sale_order_id as sale_id
+            select rl.product_id as id, rl.product_id, sum(rl.qty_purchase) as qty_rpo
             from requisition_line rl
             join requisition r on r.id = rl.requisition_id
             join requisition_purchase_match rpm on rpm.requisition_id = r.id
             join purchase_order po on po.id = rpm.order_id
             join sale_order so on so.id = r.sale_order_id
-            where r.date_doc >= '2024-11-11'
+            where 1=1
+            and r.date_doc >= '2024-11-11'
             and po.state in ('done', 'purchase')
             and so.state in ('draft', 'sent')
+            group by rl.product_id
         """ % self._table)