receipt date schema

1 files changed, 124 insertions, 22 deletions

diff --git a/indoteknik_custom/models/purchase_order.py b/indoteknik_custom/models/purchase_order.py
index 45134939..27aca0d1 100755
--- a/indoteknik_custom/models/purchase_order.py
+++ b/indoteknik_custom/models/purchase_order.py
@@ -92,6 +92,11 @@ class PurchaseOrder(models.Model):
 
     is_cab_visible = fields.Boolean(string='Tampilkan Tombol CAB', compute='_compute_is_cab_visible')
 
+    reason_change_date_planned = fields.Selection([
+        ('delay', 'Delay By Vendor'),
+        ('urgent', 'Urgent Delivery'),
+    ], string='Reason Change Date Planned', tracking=True)
+
     # picking_ids = fields.One2many('stock.picking', 'purchase_id', string='Pickings')
 
     bu_related_count = fields.Integer(
@@ -100,9 +105,68 @@ class PurchaseOrder(models.Model):
     )
     manufacturing_id = fields.Many2one('mrp.production', string='Manufacturing Orders')
 
+    complete_bu_in_count = fields.Integer(
+        string="Complete BU In Count",
+        compute='_compute_complete_bu_in_count'
+    )
+
+    def _compute_complete_bu_in_count(self):
+        for order in self:
+            if order.state not in ['done', 'cancel']:
+                order.complete_bu_in_count = 1
+            else:
+                relevant_pickings = order.picking_ids.filtered(
+                    lambda p: p.state != 'done'
+                    and p.state != 'cancel'
+                    and p.picking_type_code == 'incoming'
+                    and p.origin == order.name
+                    and p.name.startswith('BU/IN')
+                )
+                order.complete_bu_in_count = len(relevant_pickings)
+
     def _has_vcm(self):
         if self.id:
             self.vcm_id = self.env['tukar.guling.po'].search([('origin', '=', self.name)], limit=1)
+            
+    @api.depends('order_line.date_planned')
+    def _compute_date_planned(self):
+        """ date_planned = the earliest date_planned across all order lines. """
+        for order in self:
+            order.date_planned = False
+
+    @api.constrains('date_planned')
+    def constrains_date_planned(self):
+        for rec in self:
+            if not self.env.user.has_group('indoteknik_custom.group_role_purchasing'):
+                raise ValidationError("Hanya dapat diisi oleh Purchasing")
+            
+            base_bu = self.env['stock.picking'].search([
+                ('name', 'ilike', 'BU/'),
+                ('origin', 'ilike', rec.name),
+                ('group_id', '=', rec.group_id.id),
+                ('state', 'not in', ['cancel','done'])
+            ])
+
+            for bu in base_bu:
+                bu.write({
+                    'scheduled_date': rec.date_planned,
+                    'reason_change_date_planned': rec.reason_change_date_planned
+                })
+            
+            rec.sync_date_planned_to_so()
+
+    def sync_date_planned_to_so(self):
+        for line in self.order_sales_match_line:
+            other_sales_match = self.env['purchase.order.sales.match'].search([
+                # ('product_id', '=', line.product_id.id),
+                ('sale_id', '=', line.sale_id.id),
+                # ('sale_line_id', '=', line.sale_line_id.id)
+            ])
+
+            dates = [d for d in other_sales_match.mapped('purchase_order_id.date_planned') if d]
+            if dates:
+                date_planned = max(dates)
+                line.sale_id.write({'et_products': date_planned, 'reason_change_date_planned': line.purchase_order_id.reason_change_date_planned})
 
     @api.depends('name')
     def _compute_bu_related_count(self):
@@ -677,13 +741,6 @@ class PurchaseOrder(models.Model):
         for order in self:
             order.has_active_invoice = any(invoice.state != 'cancel' for invoice in order.invoice_ids)
 
-    # def _compute_has_active_invoice(self):
-    #     for order in self:
-    #         related_invoices = order.invoice_ids.filtered(
-    #             lambda inv: inv.purchase_order_id.id == order.id and inv.move_type == 'in_invoice' and inv.state != 'cancel'
-    #         )
-    #         order.has_active_invoice = bool(related_invoices)
-
     def add_product_to_pricelist(self):
         i = 0
         for line in self.order_line:
@@ -766,16 +823,16 @@ class PurchaseOrder(models.Model):
                     """
                     purchase_pricelist.message_post(body=message, subtype_id=self.env.ref("mail.mt_note").id)
 
-    def _compute_date_planned(self):
-        for order in self:
-            if order.date_approve:
-                leadtime = order.partner_id.leadtime
-                current_time = order.date_approve
-                delta_time = current_time + timedelta(days=leadtime)
-                delta_time = delta_time.strftime('%Y-%m-%d %H:%M:%S')
-                order.date_planned = delta_time
-            else:
-                order.date_planned = False
+    # def _compute_date_planned(self):
+    #     for order in self:
+    #         if order.date_approve:
+    #             leadtime = order.partner_id.leadtime
+    #             current_time = order.date_approve
+    #             delta_time = current_time + timedelta(days=leadtime)
+    #             delta_time = delta_time.strftime('%Y-%m-%d %H:%M:%S')
+    #             order.date_planned = delta_time
+    #         else:
+    #             order.date_planned = False
 
     def action_create_invoice(self):
         res = super(PurchaseOrder, self).action_create_invoice()
@@ -959,6 +1016,9 @@ class PurchaseOrder(models.Model):
 
         if self.amount_untaxed >= 50000000 and not self.env.user.id == 21:
             raise UserError("Hanya Rafly Hanggara yang bisa approve")
+
+        if not self.date_planned:
+            raise UserError("Receipt Date harus diisi")
             
         if self.total_percent_margin < self.total_so_percent_margin:
             self.env.user.notify_danger(
@@ -975,7 +1035,7 @@ class PurchaseOrder(models.Model):
         #     )
 
         if not self.from_apo:
-            if (not self.matches_so or not self.sale_order_id) and not self.env.user.is_purchasing_manager and not self.env.user.is_leader and not self.manufacturing_id:
+            if not self.matches_so and not self.env.user.is_purchasing_manager and not self.env.user.is_leader:
                 raise UserError("Tidak ada link dengan SO, harus di confirm oleh Purchasing Manager")
             
         send_email = False
@@ -1010,10 +1070,10 @@ class PurchaseOrder(models.Model):
         self.approve_by = self.env.user.id
 
         # override date planned added with two days
-        leadtime = self.partner_id.leadtime
-        delta_time = current_time + timedelta(days=leadtime)
-        delta_time = delta_time.strftime('%Y-%m-%d %H:%M:%S')
-        self.date_planned = delta_time
+        # leadtime = self.partner_id.leadtime
+        # delta_time = current_time + timedelta(days=leadtime)
+        # delta_time = delta_time.strftime('%Y-%m-%d %H:%M:%S')
+        # self.date_planned = delta_time
         self.date_deadline_ref_date_planned()
         self.unlink_purchasing_job_state()
 
@@ -1391,6 +1451,20 @@ class PurchaseOrder(models.Model):
         # Tambahkan pemanggilan method untuk handle pricelist system update
         self._handle_pricelist_system_update(vals)
         return res
+    
+    def action_open_change_date_wizard(self):
+        self.ensure_one()
+        return {
+            'type': 'ir.actions.act_window',
+            'res_model': 'change.date.planned.wizard',
+            'view_mode': 'form',
+            'target': 'new',
+            'context': {
+                'default_purchase_id': self.id,
+                'default_new_date_planned': self.date_planned,
+            }
+        }
+
 
     def _handle_pricelist_system_update(self, vals):
         if 'order_line' in vals or any(key in vals for key in ['state', 'approval_status']):
@@ -1479,4 +1553,32 @@ class PurchaseOrderUnlockWizard(models.TransientModel):
             order.approval_status_unlock = 'pengajuanFinance'
         return {'type': 'ir.actions.act_window_close'}
 
+class ChangeDatePlannedWizard(models.TransientModel):
+    _name = 'change.date.planned.wizard'
+    _description = 'Change Date Planned Wizard'
+
+    purchase_id = fields.Many2one('purchase.order', string="Purchase Order", required=True)
+    new_date_planned = fields.Datetime(string="New Date Planned")  # <- harus DTTM biar match
+    old_date_planned = fields.Datetime(string="Current Planned Date", related='purchase_id.date_planned', readonly=True)
+    reason = fields.Selection([
+        ('delay', 'Delay By Vendor'),
+        ('urgent', 'Urgent Delivery'),
+    ], string='Reason')
+    date_changed = fields.Boolean(string="Date Changed", compute="_compute_date_changed")
+
+    @api.depends('old_date_planned', 'new_date_planned')
+    def _compute_date_changed(self):
+        for rec in self:
+            rec.date_changed = (
+                rec.old_date_planned and rec.new_date_planned and
+                rec.old_date_planned != rec.new_date_planned
+            )
+
+    def confirm_change(self):
+        self.purchase_id.write({
+            'date_planned': self.new_date_planned,
+            'reason_change_date_planned': self.reason,
+        })
+
+