Merge branch 'production' into CR/quotation-noPo

# Conflicts:
#	indoteknik_custom/models/user_company_request.py

1 files changed, 45 insertions, 2 deletions

diff --git a/indoteknik_custom/models/product_template.py b/indoteknik_custom/models/product_template.py
index e64b63d7..2e80beec 100755
--- a/indoteknik_custom/models/product_template.py
+++ b/indoteknik_custom/models/product_template.py
@@ -61,6 +61,7 @@ class ProductTemplate(models.Model):
     sni = fields.Boolean(string='SNI')
     tkdn = fields.Boolean(string='TKDN')
     short_spesification = fields.Char(string='Short Spesification')
+    merchandise_ok = fields.Boolean(string='Product Promotion')
     
     @api.constrains('name', 'internal_reference', 'x_manufacture')
     def required_public_categ_ids(self):
@@ -374,6 +375,10 @@ class ProductProduct(models.Model):
     is_edited = fields.Boolean(string='Is Edited')
     qty_sold = fields.Float(string='Sold Quantity', compute='_get_qty_sold')
     short_spesification = fields.Char(string='Short Spesification')
+    max_qty_reorder = fields.Float(string='Max Qty Reorder', compute='_get_max_qty_reordering_rule')
+    qty_rpo = fields.Float(string='Qty RPO', compute='_get_qty_rpo')
+    plafon_qty = fields.Float(string='Max Plafon', compute='_get_plafon_qty_product')
+    merchandise_ok = fields.Boolean(string='Product Promotion')
 
     def _get_clean_website_description(self):
         for rec in self:
@@ -487,6 +492,16 @@ class ProductProduct(models.Model):
             qty = sum(qty_incoming.mapped('product_uom_qty'))
             product.qty_incoming_bandengan = qty
 
+    def _get_qty_incoming_bandengan_with_exclude(self):
+        for product in self:
+            qty_incoming = self.env['stock.move'].search([
+                            ('product_id', '=', product.id),
+                            ('location_dest_id', 'in', [57, 83]),
+                            ('state', 'not in', ['done', 'cancel'])
+                        ])
+            qty = sum(qty_incoming.mapped('product_uom_qty'))
+            product.qty_incoming_bandengan = qty
+
     def _get_qty_outgoing_bandengan(self):
         for product in self:
             qty_incoming = self.env['stock.move'].search([
@@ -510,13 +525,41 @@ class ProductProduct(models.Model):
     def _get_qty_available_bandengan(self):
         for product in self:
             qty_available = product.qty_incoming_bandengan + product.qty_onhand_bandengan - product.qty_outgoing_bandengan
-            product.qty_available_bandengan = qty_available
+            product.qty_available_bandengan = qty_available or 0
 
     def _get_qty_free_bandengan(self):
         for product in self:
             qty_free = product.qty_onhand_bandengan - product.qty_outgoing_bandengan
             product.qty_free_bandengan = qty_free
-            
+
+    def _get_max_qty_reordering_rule(self):
+        for product in self:
+            reordering = self.env['stock.warehouse.orderpoint'].search([
+                ('product_id', '=', product.id)
+            ], limit=1)
+            if not reordering:
+                product.max_qty_reorder = 0
+            else:
+                product.max_qty_reorder = reordering.product_max_qty
+
+    def _get_qty_rpo(self):
+        for product in self:
+            rpo = self.env['v.requisition.match.po'].search([
+                ('product_id', '=', product.id)
+            ], limit=1)
+            if not rpo:
+                product.qty_rpo = 0
+            else:
+                product.qty_rpo = rpo.qty_rpo
+
+    def _get_plafon_qty_product(self):
+        for product in self:
+            qty_available = product.qty_available_bandengan
+            max_qty = product.max_qty_reorder
+            qty_rpo = product.qty_rpo
+            product.plafon_qty = max_qty - qty_available + qty_rpo
+
+
     # def write(self, vals):
     #     if 'solr_flag' not in vals:
     #         for variant in self: