Merge branch 'production' into iman/pengajuan-tempo

# Conflicts:
#	indoteknik_custom/__manifest__.py
#	indoteknik_custom/models/__init__.py
#	indoteknik_custom/security/ir.model.access.csv

1 files changed, 79 insertions, 5 deletions

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index c4104ec5..32a9f94f 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,33 @@ import logging
 _logger = logging.getLogger(__name__)
 
 
+class RequisitionMatchPO(models.Model):
+    _name = 'v.requisition.match.po'
+    _auto = False
+    _rec_name = 'product_id'
+
+    id = fields.Integer(string='ID')
+    product_id = fields.Many2one('product.product', string='Product')
+    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 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 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)
+
+
 class Requisition(models.Model):
     _name = 'requisition'
     _order = 'id desc'
@@ -20,21 +47,61 @@ class Requisition(models.Model):
     notification = fields.Char(string='Notification')
     is_po = fields.Boolean(string='Is PO')
     requisition_match = fields.One2many('requisition.purchase.match', 'requisition_id', string='Matches', auto_join=True)
-    sale_order_id = fields.Many2one('sale.order', string='SO', help='harus diisi nomor SO yang ingin digenerate', 
-                                    domain="[('state', '=', 'sale')]")
+    sale_order_id = fields.Many2one('sale.order', string='SO', help='harus diisi nomor SO yang ingin digenerate')
+    sales_approve = fields.Boolean(string='Sales Approve', tracking=3, copy=False)
+    merchandise_approve = fields.Boolean(string='Merchandise Approve', tracking=3, copy=False)
+
+    def generate_requisition_from_so(self):
+        state = ['done', 'sale']
+        if not self.sale_order_id:
+            raise UserError('Sale Order Wajib Diisi dan Harus Draft')
+        if self.sale_order_id.state in state:
+            raise UserError('SO sudah Confirm, akan berakibat double Purchase melalui PJ')
+        if not self.sale_order_id.order_line:
+            raise UserError('Line SO masih kosong, harus diisi dulu')
+        for order_line in self.sale_order_id.order_line:
+            param = {
+                'requisition_id': self.id,
+                'product_id': order_line.product_id.id,
+                'partner_id': order_line.vendor_id.id,
+                'qty_purchase': order_line.product_uom_qty,
+                'price_unit': order_line.purchase_price,
+                'taxes_id': order_line.purchase_tax_id.id,
+                'subtotal': order_line.purchase_price * order_line.product_uom_qty,
+                'brand_id': order_line.product_id.x_manufacture.id
+            }
+            self.env['requisition.line'].create([param])
 
     @api.model
     def create(self, vals):
         vals['number'] = self.env['ir.sequence'].next_by_code('requisition') or '0'
         result = super(Requisition, self).create(vals)
         return result
-
+    
+    def button_approve(self):
+        state = ['done', 'sale']
+        if self.sale_order_id.state in state:
+            raise UserError('SO sudah Confirm, akan berakibat double Purchase melalui PJ')
+        if self.env.user.id not in [377, 19]:
+            raise UserError('Hanya Vita dan Darren Yang Bisa Approve')
+        if self.env.user.id == 377:
+            self.sales_approve = True
+        elif self.env.user.id == 19:
+            if not self.sales_approve:
+                raise UserError('Vita Belum Approve')
+            self.merchandise_approve = True
 
     def create_po_from_requisition(self):
+        if not self.sales_approve:
+            raise UserError('Harus Di Approve oleh Vita')
+        if not self.merchandise_approve:
+            raise UserError('Harus Di Approve oleh Darren')
         if not self.requisition_lines:
             raise UserError('Tidak ada Lines, belum bisa create PO')
         if self.is_po:
             raise UserError('Sudah pernah di create PO')
+        if not 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), 
@@ -101,13 +168,20 @@ class Requisition(models.Model):
                     'product_id': product.id,
                     'product_qty': line.qty_purchase,
                     'product_uom_qty': line.qty_purchase,
-                    'name': product.name,
+                    'name': product.display_name,
                     'price_unit': line.price_unit,
                     'taxes_id': tax,
                 }
                 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):