change product sla

1 files changed, 65 insertions, 49 deletions

diff --git a/indoteknik_custom/models/product_sla.py b/indoteknik_custom/models/product_sla.py
index 988aa78f..04ad2ffd 100644
--- a/indoteknik_custom/models/product_sla.py
+++ b/indoteknik_custom/models/product_sla.py
@@ -14,51 +14,53 @@ class ProductSla(models.Model):
     product_variant_id = fields.Many2one('product.product',string='Product')
     sla_vendor_id = fields.Many2one('vendor.sla',string='Vendor', readonly=True)
     sla_vendor_duration = fields.Char(string='AVG Leadtime', related='sla_vendor_id.duration_unit')
-    avg_leadtime = fields.Char(string='AVG Leadtime', readonly=True)
-    leadtime = fields.Char(string='Leadtime', readonly=True)
+    sla_logistic = fields.Char(string='SLA Logistic', readonly=True)
+    sla_logistic_unit = fields.Selection(
+        [('jam', 'Jam'),('hari', 'Hari')],
+        string="SLA Logistic Time"
+    )
+    sla_logistic_duration_unit = fields.Char(string="SLA Logistic Duration (Unit)")
     sla = fields.Char(string='SLA', readonly=True)
     version = fields.Integer(string="Version", compute="_compute_version")
 
     def _compute_version(self):
         for sla in self:
             sla.version = sla.product_variant_id.sla_version
+            
+    
 
-    def generate_product_variant_id_sla(self, limit=5000):
-    # Filter produk non-Altama
-        
+    def generate_product_variant_id_sla(self, limit=500):
+        offset = 0
+        # while True:
         products = self.env['product.product'].search([
-            ('x_manufacture', 'not in', [10, 122, 89]),
-            ('location_id', '=', 57),
-            ('stock_move_ids', '!=', False),
-        ], order='sla_version asc', limit=limit)
+            ('active', '=', True),
+            ('sale_ok', '=', True),
+        ], order='sla_version asc', limit=limit, offset=offset)
+
+        # if not products:
+        #     break
 
-        i = 1
         for product in products:
-            _logger.info(f'Product SLA: {i}/{len(products)}')
-            i += 1
-            product.sla_version += 1
+            _logger.info(f'Memproses SLA untuk produk ID {product.id}, versi {product.sla_version}')
 
             product_sla = self.search([('product_variant_id', '=', product.id)], limit=1)
-            print(product_sla.id, product.id)
             if not product_sla:
-                product_sla = self.env['product.sla'].create({
-                    'product_variant_id': product.id,
-                })
- 
+                product_sla = self.create({'product_variant_id': product.id})
+
             product_sla.generate_product_sla()
 
+            # Tandai produk sebagai sudah diproses
+            product.sla_version += 1
+
+        offset += limit
+
+
     def generate_product_sla(self):
-        self.avg_leadtime = '-'
-        self.sla = '-'
+        # self.sla_logistic = '-'
+        # self.sla_logistic_duration_unit = '-'
+        # self.sla = '-'
 
         product = self.product_variant_id
-
-        # qty_available = 0
-        # qty_available = product.qty_onhand_bandengan
-        
-        
-        # if qty_available > 0:
-        #     self.sla = 1
             
         q_vendor = [
             ('product_id', '=', product.id),
@@ -68,6 +70,8 @@ class ProductSla(models.Model):
         vendor = self.env['purchase.pricelist'].search(q_vendor)
         
         vendor_duration = 0
+        
+        #SLA Vendor
         if vendor:
             vendor_sla = self.env['vendor.sla'].search([('id_vendor', '=', vendor.vendor_id.id)], limit=1)
             sla_vendor = int(vendor_sla.duration) if vendor_sla else 0
@@ -78,28 +82,40 @@ class ProductSla(models.Model):
                     vendor_duration = vendor_sla.duration * 60
                     
                 self.sla_vendor_id = vendor_sla.id if vendor_sla else False
+                #SLA Logistik selalu 1 hari
+                estimation_sla = (1 * 24 * 60) + vendor_duration
+                estimation_sla_days = estimation_sla / (24 * 60)
+                self.sla = math.ceil(estimation_sla_days)
+                self.sla_logistic = int(1)
+                self.sla_logistic_unit = 'hari'
+                self.sla_logistic_duration_unit = '1 hari'
+            else:
+                self.unlink()
+        else:
+            self.unlink()
+           
 
-        query = [
-            ('product_id', '=', product.id),
-            ('picking_id', '!=', False),
-            ('picking_id.location_id', '=', 57),    
-            ('picking_id.state', 'not in', ['cancel'])
-        ]
-        picking = self.env['stock.move.line'].search(query)
+        # query = [
+        #     ('product_id', '=', product.id),
+        #     ('picking_id', '!=', False),
+        #     ('picking_id.location_id', '=', 57),    
+        #     ('picking_id.state', 'not in', ['cancel'])
+        # ]
+        # picking = self.env['stock.move.line'].search(query)
         
-        leadtimes=[]     
-        for stock in picking:
-            date_delivered = stock.picking_id.driver_departure_date
-            date_do_ready = stock.picking_id.date_reserved
-            if date_delivered and date_do_ready:
-                leadtime = date_delivered - date_do_ready
-                leadtime_in_days = leadtime.days
-                leadtimes.append(leadtime_in_days)
+        # leadtimes=[]     
+        # for stock in picking:
+        #     date_delivered = stock.picking_id.driver_departure_date
+        #     date_do_ready = stock.picking_id.date_reserved
+        #     if date_delivered and date_do_ready:
+        #         leadtime = date_delivered - date_do_ready
+        #         leadtime_in_days = leadtime.days
+        #         leadtimes.append(leadtime_in_days)
         
-        if len(leadtimes) > 0:
-            avg_leadtime = sum(leadtimes) / len(leadtimes)
-            rounded_leadtime = math.ceil(avg_leadtime)
-            estimation_sla = ((rounded_leadtime * 24 * 60) + vendor_duration)/2
-            estimation_sla_days = estimation_sla / (24 * 60)
-            self.sla = math.ceil(estimation_sla_days)
-            self.avg_leadtime = int(rounded_leadtime)
\ No newline at end of file
+        # if len(leadtimes) > 0:
+        #     avg_leadtime = sum(leadtimes) / len(leadtimes)
+        #     rounded_leadtime = math.ceil(avg_leadtime)
+        #     estimation_sla = ((rounded_leadtime * 24 * 60) + vendor_duration)/2
+        #     estimation_sla_days = estimation_sla / (24 * 60)
+        #     self.sla = math.ceil(estimation_sla_days)
+        #     self.avg_leadtime = int(rounded_leadtime)
\ No newline at end of file