approval invoice date

3 files changed, 86 insertions, 1 deletions

diff --git a/indoteknik_custom/models/__init__.py b/indoteknik_custom/models/__init__.py
index 935a0aa0..08fa9803 100755
--- a/indoteknik_custom/models/__init__.py
+++ b/indoteknik_custom/models/__init__.py
@@ -149,3 +149,4 @@ from . import sales_order_koli
 from . import stock_backorder_confirmation
 from . import account_payment_register
 from . import stock_inventory
+from . import approval_invoice_date
diff --git a/indoteknik_custom/models/approval_invoice_date.py b/indoteknik_custom/models/approval_invoice_date.py
new file mode 100644
index 00000000..48546e55
--- /dev/null
+++ b/indoteknik_custom/models/approval_invoice_date.py
@@ -0,0 +1,46 @@
+from odoo import models, api, fields
+from odoo.exceptions import AccessError, UserError, ValidationError
+from datetime import timedelta, date, datetime  
+import logging
+
+_logger = logging.getLogger(__name__)
+
+class ApprovalInvoiceDate(models.Model):
+    _name = "approval.invoice.date"
+    _description = "Approval Invoice Date"
+    _rec_name = 'number'
+
+    picking_id = fields.Many2one('stock.picking', string='Picking')
+    number = fields.Char(string='Document No', index=True, copy=False, readonly=True, tracking=True)
+    date_invoice = fields.Datetime(
+        string='Invoice Date',
+        copy=False
+    )
+    date_doc_do = fields.Datetime(
+        string='Tanggal Kirim di SJ',
+        copy=False
+    )
+    state = fields.Selection([('draft', 'Draft'), ('done', 'Done'), ('cancel', 'Cancel')], string='State', default='draft', tracking=True)
+    approve_date = fields.Datetime(string='Approve Date', copy=False)
+    approve_by = fields.Many2one('res.users', string='Approve By', copy=False)
+    sale_id = fields.Many2one('sale.order', string='Sale Order')
+    partner_id = fields.Many2one('res.partner', string='Partner')
+    move_id = fields.Many2one('account.move', string='Invoice')
+    note = fields.Char(string='Note')
+
+    def button_approve(self):
+        if not self.env.user.is_accounting:
+            raise UserError("Hanya Accounting Yang Bisa Approve")
+        self.move_id.invoice_date = self.date_doc_do
+        self.state = 'done'
+        self.approve_date = datetime.utcnow()
+        self.approve_by = self.env.user.id
+
+    def button_cancel(self):
+        self.state = 'cancel'
+
+    @api.model
+    def create(self, vals):
+        vals['number'] = self.env['ir.sequence'].next_by_code('approval.invoice.date') or '0'
+        result = super(ApprovalInvoiceDate, self).create(vals)
+        return result
diff --git a/indoteknik_custom/models/stock_picking.py b/indoteknik_custom/models/stock_picking.py
index 923c56f5..0701a989 100644
--- a/indoteknik_custom/models/stock_picking.py
+++ b/indoteknik_custom/models/stock_picking.py
@@ -248,11 +248,40 @@ class StockPicking(models.Model):
     final_seq = fields.Float(string='Remaining Time')
     shipping_method_so_id = fields.Many2one('delivery.carrier', string='Shipping Method SO', related='sale_id.carrier_id')
     state_packing = fields.Selection([('not_packing', 'Belum Packing'), ('packing_done', 'Sudah Packing')], string='Packing Status')
+    approval_invoice_date_id = fields.Many2one('approval.invoice.date', string='Approval Invoice Date')
 
     @api.constrains('date_doc_kirim')
     def _constrains_date_doc_kirim(self):
         for rec in self:
             rec.calculate_line_no()
+
+            invoice = self.env['account.move'].search([('sale_id', '=', rec.sale_id.id)], limit=1, order='create_date desc')
+
+            if invoice:
+                if rec.date_doc_kirim != invoice.invoice_date:
+                    get_approval_invoice_date = self.env['approval.invoice.date'].search([('picking_id', '=', rec.id),('state', '=', 'draft')], limit=1)
+
+                    if get_approval_invoice_date and get_approval_invoice_date.state == 'draft':
+                        get_approval_invoice_date.date_doc_do = rec.date_doc_kirim
+                    else:
+                        approval_invoice_date = self.env['approval.invoice.date'].create({
+                            'picking_id': rec.id,
+                            'date_invoice': invoice.invoice_date,
+                            'date_doc_do': rec.date_doc_kirim,
+                            'sale_id': rec.sale_id.id,
+                            'move_id': invoice.id,
+                            'partner_id': rec.partner_id.id
+                        })
+
+                        rec.approval_invoice_date_id = approval_invoice_date.id
+
+                        if approval_invoice_date:
+                            return {
+                                'type': 'ir.actions.client',
+                                'tag': 'display_notification',
+                                'params': { 'title': 'Notification', 'message': 'Invoice Date Tidak Sesuai, Document Approval Invoice Date Terbuat', 'next': {'type': 'ir.actions.act_window_close'} },
+                            }
+                
     
     @api.constrains('scan_koli_lines')
     def _constrains_scan_koli_lines(self):
@@ -1002,6 +1031,8 @@ class StockPicking(models.Model):
             raise UserError('Hanya MD yang bisa Approve')
 
     def button_validate(self):
+        self.check_invoice_date()
+        threshold_datetime = waktu(2025, 4, 11, 6, 26)
         group_id = self.env.ref('indoteknik_custom.group_role_merchandiser').id
         users_in_group = self.env['res.users'].search([('groups_id', 'in', [group_id])])
         active_model = self.env.context.get('active_model')
@@ -1013,7 +1044,6 @@ class StockPicking(models.Model):
             if self.location_id.id == 47 and self.env.user.id in users_in_group.mapped('id'):
                 self.state_approve_md = 'done'
 
-        threshold_datetime = waktu(2025, 4, 11, 6, 26)
 
         if (len(self.konfirm_koli_lines) == 0 
             and 'BU/OUT/' in self.name 
@@ -1129,6 +1159,14 @@ class StockPicking(models.Model):
         self.send_mail_bills()
         return res
     
+    def check_invoice_date(self):
+        for picking in self:
+            invoice = self.env['account.move'].search([('sale_id', '=', picking.sale_id.id)])
+
+            if invoice:
+                if picking.date_doc_kirim.date() != invoice.invoice_date:
+                    raise UserError("Tanggal Kirim tidak sesuai dengan Invoice")
+    
     def set_picking_code_out(self):
         for picking in self:
             # Check if picking meets criteria