Merge branch 'production' into iman/telegram

# Conflicts:
#	indoteknik_custom/models/__init__.py
#	indoteknik_custom/models/stock_picking.py

1 files changed, 106 insertions, 5 deletions

diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index 2b148c96..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):
@@ -214,6 +288,7 @@ class RequisitionLine(models.Model):
     last_price = fields.Float(string='Last Price')
     last_order_id = fields.Many2one('purchase.order', string='Last Order')
     last_orderline_id = fields.Many2one('purchase.order.line', string='Last Order Line')
+    taxes_id = fields.Many2one('account.tax', string='Tax')
     is_po = fields.Boolean(String='Is PO')
     current_po_id = fields.Many2one('purchase.order', string='Current')
     current_po_line_id = fields.Many2one('purchase.order.line', string='Current Line')
@@ -221,6 +296,23 @@ class RequisitionLine(models.Model):
     qty_available_store = fields.Float(string='Available')
     suggest = fields.Char(string='Suggest')
 
+    def _get_valid_purchase_price(self, purchase_price):
+        price = 0
+        taxes = ''
+        human_last_update = purchase_price.human_last_update or datetime.min
+        system_last_update = purchase_price.system_last_update or datetime.min
+        
+        if  purchase_price.taxes_product_id.type_tax_use == 'purchase':
+            price = purchase_price.product_price
+            taxes = purchase_price.taxes_product_id.id
+
+        if system_last_update > human_last_update:
+            if purchase_price.taxes_system_id.type_tax_use == 'purchase':
+                price = purchase_price.system_price
+                taxes = purchase_price.taxes_system_id.id
+        
+        return price, taxes
+
     @api.onchange('price_unit')
     def _onchange_price_unit(self):
         for line in self:
@@ -230,6 +322,15 @@ class RequisitionLine(models.Model):
     def _onchange_product(self):
         for line in self:
             line.brand_id = line.product_id.product_tmpl_id.x_manufacture.id
+            purchase_pricelist = self.env['purchase.pricelist'].search([
+            ('product_id', '=', line.product_id.id)
+            ],order='count_trx_po desc, count_trx_po_vendor desc', limit=1)
+
+            price, taxes = line._get_valid_purchase_price(purchase_pricelist)
+            line.price_unit = price
+            line.taxes_id = taxes
+            line.partner_id = purchase_pricelist.vendor_id.id
+
 
 class RequisitionPurchaseMatch(models.Model):
     _name = 'requisition.purchase.match'