2 files changed, 92 insertions, 1 deletions
diff --git a/indoteknik_custom/models/__init__.py b/indoteknik_custom/models/__init__.py
index ba3dbad9..c8910669 100755
--- a/indoteknik_custom/models/__init__.py
+++ b/indoteknik_custom/models/__init__.py
@@ -157,4 +157,5 @@ from . import refund_sale_order
 from . import tukar_guling
 from . import tukar_guling_po
 from . import update_date_planned_po_wizard
-from . import unpaid_invoice_view
-\ No newline at end of file
+from . import unpaid_invoice_view
+from . import letter_receivable
+\ No newline at end of file
diff --git a/indoteknik_custom/models/letter_receivable.py b/indoteknik_custom/models/letter_receivable.py
new file mode 100644
index 00000000..541f64ff
--- /dev/null
+++ b/indoteknik_custom/models/letter_receivable.py
@@ -0,0 +1,90 @@
+from odoo import models, fields, api
+
+class SuratPiutang(models.Model):
+    _name = "surat.piutang"
+    _description = "Surat Piutang"
+    _inherit = ['mail.thread', 'mail.activity.mixin']
+
+    name = fields.Char(string="Nomor Surat", readonly=True, copy=False)
+    partner_id = fields.Many2one("res.partner", string="Customer", required=True)
+    tujuan_nama = fields.Char(string="Nama Tujuan")
+    tujuan_email = fields.Char(string="Email Tujuan")
+    perihal = fields.Selection([
+        ('sp1', 'Surat Peringatan Piutang'),
+        ('sp2', 'Surat Peringatan Piutang ke-2'),
+        ('sp3', 'Surat Peringatan Piutang ke-3')
+    ], string="Perihal", required=True, tracking=True)
+    line_ids = fields.One2many("surat.piutang.line", "surat_id", string="Invoice Lines")
+    state = fields.Selection([
+        ("draft", "Draft"),
+        ("sent", "Sent")
+    ], default="draft", tracking=True)
+    send_date = fields.Datetime(string="Tanggal Kirim", tracking=True)
+
+    currency_id = fields.Many2one('res.currency')
+
+    # Grand total (total sisa semua line yang dicentang)
+    grand_total = fields.Monetary(
+        string='Total Sisa',
+        currency_field='currency_id',
+        compute='_compute_grand_total',
+    )
+
+    @api.depends('line_ids.amount_residual', 'line_ids.selected')
+    def _compute_grand_total(self):
+        for rec in self:
+            rec.grand_total = sum(
+                line.amount_residual or 0.0 for line in rec.line_ids if line.selected
+            )
+
+    @api.onchange('partner_id')
+    def _onchange_partner_id(self):
+        if self.partner_id:
+            invoice_lines = self.env['unpaid.invoice.view'].search(
+                [('partner_id', '=', self.partner_id.id)],
+                order='new_invoice_day_to_due asc'
+            )
+            lines = [(0, 0, {
+                'invoice_view_id': inv.id,
+                'invoice_id': inv.invoice_id.id,
+                'invoice_number': inv.invoice_number,
+                'invoice_date': inv.invoice_date,
+                'invoice_date_due': inv.invoice_date_due,
+                'invoice_day_to_due': inv.invoice_day_to_due,
+                'ref': inv.ref,
+                'amount_residual': inv.amount_residual,
+                'currency_id': inv.currency_id.id,
+                'payment_term_id': inv.payment_term_id.id,
+                'selected': False
+            }) for inv in invoice_lines]
+            self.line_ids = lines
+
+    @api.model
+    def create(self, vals):
+        # Generate nomor surat otomatis
+        if not vals.get("name"):
+            seq = self.env["ir.sequence"].next_by_code("surat.piutang") or "000"
+            today = fields.Date.today()
+            bulan_romawi = ["I","II","III","IV","V","VI","VII","VIII","IX","X","XI","XII"][today.month-1]
+            tahun = today.strftime("%y")
+            vals["name"] = f"{seq}/LO/FAT/IDG/{bulan_romawi}/{tahun}"
+
+        return super().create(vals)
+
+class SuratPiutangLine(models.Model):
+    _name = 'surat.piutang.line'
+    _description = 'Surat Piutang Line'
+
+    surat_id = fields.Many2one('surat.piutang', string='Surat Piutang', ondelete='cascade')
+    invoice_view_id = fields.Many2one('unpaid.invoice.view', string='Unpaid Invoice')
+    invoice_id = fields.Many2one('account.move', string='Invoice')
+    selected = fields.Boolean(string="Pilih", default=False)
+
+    invoice_number = fields.Char(string='Invoice Number')
+    invoice_date = fields.Date(string='Invoice Date')
+    invoice_date_due = fields.Date(string='Due Date')
+    invoice_day_to_due = fields.Integer(string='Day to Due')
+    ref = fields.Char(string='Reference')
+    amount_residual = fields.Monetary(string='Amount Due Signed')
+    currency_id = fields.Many2one('res.currency')
+    payment_term_id = fields.Many2one('account.payment.term', string='Payment Terms')