add public holiday

1 files changed, 39 insertions, 9 deletions

diff --git a/indoteknik_custom/models/sale_order.py b/indoteknik_custom/models/sale_order.py
index d0b57a3d..d956e93a 100755
--- a/indoteknik_custom/models/sale_order.py
+++ b/indoteknik_custom/models/sale_order.py
@@ -93,11 +93,13 @@ class SaleOrder(models.Model):
     applied_voucher_shipping_id = fields.Many2one(comodel_name='voucher', string='Applied Voucher', copy=False)
     amount_voucher_shipping_disc = fields.Float(string='Voucher Discount')
     source_id = fields.Many2one('utm.source', 'Source', domain="[('id', 'in', [32, 59, 60, 61])]", required=True)
-    estimated_arrival_days = fields.Integer('Estimated Arrival Days', default=0)
+    estimated_arrival_days = fields.Integer('Estimated Arrival To', default=0)
+    estimated_arrival_days_start = fields.Integer('Estimated Arrival From', default=0)
     email = fields.Char(string='Email')
     picking_iu_id = fields.Many2one('stock.picking', 'Picking IU')
     helper_by_id = fields.Many2one('res.users', 'Helper By')
-    eta_date = fields.Datetime(string='ETA Date', copy=False, compute='_compute_eta_date')
+    eta_date_start = fields.Datetime(string='ETA Date start', copy=False, compute='_compute_eta_start_date')
+    eta_date = fields.Datetime(string='ETA Date end', copy=False, compute='_compute_eta_date')
     flash_sale = fields.Boolean(string='Flash Sale', help='Data dari web')
     is_continue_transaction = fields.Boolean(string='Button Transaction', help='Data dari web')
     web_approval = fields.Selection([
@@ -146,9 +148,7 @@ class SaleOrder(models.Model):
     ])
     estimated_ready_ship_date = fields.Datetime(
         string='ET Ready to Ship compute',
-        compute='_compute_etrts_date',
-        store=True
-        
+        compute='_compute_etrts_date'
     )
     expected_ready_to_ship = fields.Datetime(
         string='ET Ready to Ship',
@@ -156,7 +156,7 @@ class SaleOrder(models.Model):
         store=True
     )
     shipping_method_picking = fields.Char(string='Shipping Method Picking', compute='_compute_shipping_method_picking')
-
+    
     def _compute_shipping_method_picking(self):
         for order in self:
             if order.picking_ids:
@@ -383,13 +383,43 @@ class SaleOrder(models.Model):
 
             rec.compute_fullfillment = True
 
-    @api.depends('date_order', 'estimated_arrival_days', 'state')
+    @api.depends('date_order', 'estimated_arrival_days', 'state', 'estimated_arrival_days_start')
     def _compute_eta_date(self):
          for rec in self:
             if rec.date_order and rec.state not in ['cancel'] and rec.estimated_arrival_days:
                 rec.eta_date = rec.date_order + timedelta(days=rec.estimated_arrival_days)
+                rec.eta_date_start = rec.date_order + timedelta(days=rec.estimated_arrival_days_start)
             else:
                 rec.eta_date = False
+                rec.eta_date_start = False
+                
+    @api.depends('date_order', 'state', 'estimated_arrival_days_start')
+    def _compute_eta_start_date(self):
+        for rec in self:
+            if rec.date_order and rec.state not in ['cancel'] and rec.estimated_arrival_days_start:
+                rec.eta_date_start = rec.date_order + timedelta(days=rec.estimated_arrival_days_start)
+            else:
+                rec.eta_date_start = False
+                
+    def get_days_until_next_business_day(self,start_date=None, *args, **kwargs):
+        today = start_date or datetime.today().date()
+        offset = 0  # Counter jumlah hari yang ditambahkan
+        holiday = self.env['hr.public.holiday']
+
+        while True :
+            today += timedelta(days=1)
+            offset += 1
+            
+            if today.weekday() >= 5:
+                continue
+
+            is_holiday = holiday.search([("start_date", "=", today)])
+            if is_holiday:
+                continue
+            
+            break
+
+        return offset
 
     @api.depends("order_line.product_id") 
     def _compute_etrts_date(self): #Function to calculate Estimated Ready To Ship Date
@@ -401,7 +431,7 @@ class SaleOrder(models.Model):
                 max_slatime = max(max_slatime, slatime)
 
             if rec.date_order:
-                eta_date = datetime.now() + timedelta(days=max_slatime)
+                eta_date = rec.date_order + timedelta(days=self.get_days_until_next_business_day(rec.date_order)) + timedelta(days=max_slatime)
                 rec.estimated_ready_ship_date = eta_date
                 rec.commitment_date = eta_date
                 # Jika expected_ready_to_ship kosong, set nilai default
@@ -1470,7 +1500,7 @@ class SaleOrder(models.Model):
     def create(self, vals):
         # Ensure partner details are updated when a sale order is created
         order = super(SaleOrder, self).create(vals)
-        # order._compute_etrts_date()
+        order._compute_etrts_date()
         # order._update_partner_details()
         return order