From 3c5b4bbecca6614c0b6f894e41e9551793957b00 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 11 Nov 2024 13:24:11 +0700
Subject: bug fix match requisition and purchase order

---
 indoteknik_custom/models/requisition.py | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index c4104ec5..92b222a8 100644
--- a/indoteknik_custom/models/requisition.py
+++ b/indoteknik_custom/models/requisition.py
@@ -108,6 +108,13 @@ class Requisition(models.Model):
                 new_po_line = self.env['purchase.order.line'].create([param_line])
                 line.current_po_id = new_po.id
                 line.current_po_line_id = new_po_line.id
+
+            self.env['requisition.purchase.match'].create([{
+                            'requisition_id': self.id,
+                            'order_id': new_po.id
+                        }])
+            self.is_po = True
+
         return po_ids
     
     # def create_po_from_requisition(self):
-- 
cgit v1.2.3


From c8359019759d78dcddea6d419c4a8f8eebe23c69 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 11 Nov 2024 13:27:04 +0700
Subject: validasi SO harus diisi pada saat create PO di requisition

---
 indoteknik_custom/models/requisition.py | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index 92b222a8..576857df 100644
--- a/indoteknik_custom/models/requisition.py
+++ b/indoteknik_custom/models/requisition.py
@@ -35,6 +35,8 @@ class Requisition(models.Model):
             raise UserError('Tidak ada Lines, belum bisa create PO')
         if self.is_po:
             raise UserError('Sudah pernah di create PO')
+        if self.sale_order_id:
+            raise UserError('Tidak ada link dengan Sales Order, tidak bisa dihitung sebagai Plafon Qty di PO')
         
         vendor_ids = self.env['requisition.line'].read_group([
             ('requisition_id', '=', self.id), 
-- 
cgit v1.2.3


From beefbce9a41d0210582cf8ceb6e4e7a6a5bc8fef Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 11 Nov 2024 13:41:46 +0700
Subject: add view of requisition match po

---
 indoteknik_custom/models/requisition.py | 26 +++++++++++++++++++++++++-
 1 file changed, 25 insertions(+), 1 deletion(-)

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index 576857df..e5053d34 100644
--- a/indoteknik_custom/models/requisition.py
+++ b/indoteknik_custom/models/requisition.py
@@ -1,4 +1,4 @@
-from odoo import models, fields, api, _
+from odoo import models, fields, api, tools, _
 from odoo.exceptions import UserError
 from datetime import datetime
 import math
@@ -7,6 +7,30 @@ import logging
 _logger = logging.getLogger(__name__)
 
 
+class RequisitionMatchPO(models.Model):
+    _name = 'v.requisition.match.po'
+    _auto = False
+    _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')
+
+    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
+            from requisition_line rl
+            join requisition r on r.id = rl.requisition_id
+            join requisition_purchase_match rpm on rpm.requisition_id = r.id
+        """ % self._table)
+
+
 class Requisition(models.Model):
     _name = 'requisition'
     _order = 'id desc'
-- 
cgit v1.2.3


From 03e9f9e8997836e37a5ab38798edb310ce6a6c76 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 11 Nov 2024 13:43:48 +0700
Subject: add sale order

---
 indoteknik_custom/models/requisition.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index e5053d34..68c57e4c 100644
--- a/indoteknik_custom/models/requisition.py
+++ b/indoteknik_custom/models/requisition.py
@@ -24,7 +24,7 @@ class RequisitionMatchPO(models.Model):
         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
+            rpm.order_id as purchase_id, r.sale_order_id as sale_id
             from requisition_line rl
             join requisition r on r.id = rl.requisition_id
             join requisition_purchase_match rpm on rpm.requisition_id = r.id
-- 
cgit v1.2.3