Fiture Over Due Limit

1 files changed, 121 insertions, 0 deletions

diff --git a/indoteknik_custom/models/account_move_due_extension.py b/indoteknik_custom/models/account_move_due_extension.py
new file mode 100644
index 00000000..1de34408
--- /dev/null
+++ b/indoteknik_custom/models/account_move_due_extension.py
@@ -0,0 +1,121 @@
+from odoo import models, api, fields
+from odoo.exceptions import AccessError, UserError, ValidationError
+from datetime import timedelta, date
+import logging
+
+_logger = logging.getLogger(__name__)
+
+class DueExtension(models.Model):
+    _name = "due.extension"
+    _rec_name = 'number'
+
+    number = fields.Char(string='Document No', index=True, copy=False, readonly=True)
+    partner_id = fields.Many2one('res.partner', string="Customer")
+    order_id = fields.Many2one('sale.order', string="SO", readonly=True)
+    due_line = fields.One2many('due.extension.line', 'due_id', string='Due Extension Lines', auto_join=True)
+    old_due = fields.Date(string="Old Due")
+    is_approve = fields.Boolean(string="Is Approve", readonly=True)
+    day_extension = fields.Selection([
+        ('3', '3 Hari'),
+        ('7', '7 Hari'),
+        ('14', '14 Hari'),
+    ], string='Day Extension', help='Menambah Due Date yang sudah limit dari hari ini')
+
+    @api.model
+    def create(self, vals):
+        vals['number'] = self.env['ir.sequence'].next_by_code('due.extension') or '0'
+        result = super(DueExtension, self).create(vals)
+        return result
+    
+    def approve_new_due(self):
+        if self.env.user.is_accounting:
+            if not self.day_extension:
+                raise UserError('Day Extension is not set.')
+            if not self.due_line:
+                raise UserError('Tidak ada data di due line.')
+                
+            self.is_approve = True
+
+            if self.partner_id:
+                if self.day_extension:
+                    day_extension = int(self.day_extension)
+                    new_due = date.today() + timedelta(days=day_extension)
+                
+                for line in self.due_line:
+                    line.invoice_id.invoice_date_due = new_due
+            
+            if self.order_id._notification_margin_leader():
+                self.order_id.approval_status = 'pengajuan2'
+                return self.order_id._notification_has_margin_leader()
+
+            if self.order_id._notification_margin_manager():
+                self.order_id.approval_status = 'pengajuan1'
+                return self.order_id._notification_has_margin_manager()
+            
+            sales = self.env['sale.order'].search([
+            ('id', '=', self.order_id.id)
+            ])
+            
+            sales.action_confirm()
+        else:
+            raise UserError('Hanya Finance Yang Bisa Approve')
+        
+    def generate_due_line(self):
+        if self.is_approve:
+            raise UserError('Sudah di approve, tidak bisa digenerate ulang')
+        if self.due_line:
+            raise UserError('Harus hapus semua line jika ingin generate ulang')
+        if self.partner_id.parent_id:
+            raise UserError('Harus pilih parent company')
+
+
+        partners = []
+        partners += self.partner_id.child_ids
+        partners.append(self.partner_id)
+
+
+        for partner in partners:
+            query = [
+                ('partner_id', '=', partner.id),
+                ('state', '=', 'posted'),
+                ('move_type', '=', 'out_invoice'),
+                ('amount_residual_signed', '>', 0)
+            ]
+            invoices = self.env['account.move'].search(query, order='invoice_date')
+            count = 0
+                   
+            for invoice in invoices:
+                if invoice.invoice_day_to_due < 0:
+                    self.env['due.extension.line'].create([{
+                        'due_id': self.id,
+                        'partner_id': invoice.partner_id.id,
+                        'invoice_id': invoice.id,
+                        'date_invoice': invoice.invoice_date,
+                        'efaktur_id': invoice.efaktur_id.id,
+                        'reference': invoice.ref,
+                        'total_amt': invoice.amount_total,
+                        'open_amt': invoice.amount_residual_signed,
+                        'due_date': invoice.invoice_date_due
+                    }])
+                    count += 1
+                _logger.info("Due Extension Line generated %s" % count)
+        
+class DueExtensionLine(models.Model):
+    _name = 'due.extension.line'
+    _description = 'Due Extension Line'
+    _order = 'due_id, id'
+
+    due_id = fields.Many2one('due.extension', string='Dunning Ref', required=True, ondelete='cascade', index=True, copy=False)
+    partner_id = fields.Many2one('res.partner', string='Customer')
+    invoice_id = fields.Many2one('account.move', string='Invoice')
+    date_invoice = fields.Date(string='Invoice Date')
+    efaktur_id = fields.Many2one('vit.efaktur', string='Faktur Pajak')
+    reference = fields.Char(string='Reference')
+    total_amt = fields.Float(string='Total Amount')
+    open_amt = fields.Float(string='Open Amount')
+    due_date = fields.Date(string='Due Date')
+    day_to_due = fields.Integer(string='Day To Due', compute="_compute_day_to_due")
+
+    def _compute_day_to_due(self):
+        for line in self:
+            line.day_to_due = line.invoice_id.invoice_day_to_due