From 1b389be56daecec87008f791e856205d2234e053 Mon Sep 17 00:00:00 2001
From: "Indoteknik ." <it@fixcomart.co.id>
Date: Wed, 3 Sep 2025 17:53:25 +0700
Subject: (andri) add template mail & try testing

---
 indoteknik_custom/models/letter_receivable.py | 102 +++++++++++++++++++++++++-
 1 file changed, 101 insertions(+), 1 deletion(-)

(limited to 'indoteknik_custom/models')

diff --git a/indoteknik_custom/models/letter_receivable.py b/indoteknik_custom/models/letter_receivable.py
index 550aa9e3..4159ecc2 100644
--- a/indoteknik_custom/models/letter_receivable.py
+++ b/indoteknik_custom/models/letter_receivable.py
@@ -1,8 +1,13 @@
 from odoo import models, fields, api, _
 from odoo.exceptions import UserError
 from odoo.exceptions import ValidationError
-from odoo.tools import mail
+from odoo.tools import mail, formatLang
 from terbilang import Terbilang
+import re
+import logging
+from datetime import timedelta
+
+_logger = logging.getLogger(__name__)
 
 class SuratPiutang(models.Model):
     _name = "surat.piutang"
@@ -27,6 +32,7 @@ class SuratPiutang(models.Model):
         ("sent", "Sent")
     ], default="draft", tracking=True)
     send_date = fields.Datetime(string="Tanggal Kirim", tracking=True)
+    seven_days_after_sent_date = fields.Char(string="7 Hari Setelah Tanggal Kirim", tracking=True)
 
     currency_id = fields.Many2one('res.currency')
 
@@ -75,6 +81,100 @@ class SuratPiutang(models.Model):
             if rec.state == "approval_pimpinan":
                 rec.state = "sent"
                 rec.send_date = fields.Datetime.now()
+                # Format tanggal + bulan (tanpa tahun)
+                month_map = {
+                    1: "Januari", 2: "Februari", 3: "Maret", 4: "April",
+                    5: "Mei", 6: "Juni", 7: "Juli", 8: "Agustus",
+                    9: "September", 10: "Oktober", 11: "November", 12: "Desember",
+                }
+                if rec.send_date:
+                    target_date = rec.send_date.date() + timedelta(days=7)
+                    rec.seven_days_after_sent_date = f"{target_date.day} {month_map[target_date.month]}"
+    
+    def action_send_letter(self):
+        self.ensure_one()
+
+        selected_lines = self.line_ids.filtered('selected')
+        if not selected_lines:
+            raise UserError(_("Tidak ada invoice yang dicentang untuk dikirim."))
+
+        if not self.tujuan_email:
+            raise UserError(_("Email tujuan harus diisi."))
+
+        template = self.env.ref('indoteknik_custom.letter_receivable_mail_template')
+        today = fields.Date.today()
+
+        month_map = {
+                    1: "Januari", 2: "Februari", 3: "Maret", 4: "April",
+                    5: "Mei", 6: "Juni", 7: "Juli", 8: "Agustus",
+                    9: "September", 10: "Oktober", 11: "November", 12: "Desember",
+                }
+        target_date = (self.send_date or fields.Datetime.now()).date() + timedelta(days=7)
+        self.seven_days_after_sent_date = f"{target_date.day} {month_map[target_date.month]}"
+        
+        perihal_map = {
+            'penagihan': 'Surat Resmi Penagihan',
+            'sp1': 'Surat Peringatan Pertama (I)',
+            'sp2': 'Surat Peringatan Kedua (II)',
+            'sp3': 'Surat Peringatan Ketiga (III)',
+        }
+        perihal_text = perihal_map.get(self.perihal, self.perihal or '')
+        
+        invoice_table_rows = ""
+        grand_total = 0
+        for line in selected_lines:
+            inv = line.invoice_id
+            if not inv:
+                continue
+            days_to_due = (line.invoice_date_due - today).days if line.invoice_date_due else 0
+            grand_total += line.amount_residual
+            invoice_table_rows += f"""
+                <tr>
+                    <td>{line.invoice_number or '-'}</td>
+                    <td>{self.partner_id.name or '-'}</td>
+                    <td>{fields.Date.to_string(line.invoice_date) or '-'}</td>
+                    <td>{fields.Date.to_string(line.invoice_date_due) or '-'}</td>
+                    <td>{days_to_due}</td>
+                    <td>{line.ref or '-'}</td>
+                    <td>{formatLang(self.env, line.amount_residual, currency_obj=line.currency_id)}</td>
+                    <td>{line.payment_term_id.name or '-'}</td>
+                </tr>
+            """
+
+        invoice_table_footer = f"""
+                <tfoot>
+                    <tr style="font-weight:bold; background-color:#f9f9f9;">
+                        <td colspan="6" align="right">Grand Total</td>
+                        <td>{formatLang(self.env, grand_total, currency_obj=self.currency_id)}</td>
+                        <td colspan="2"></td>
+                    </tr>
+                </tfoot>
+            """
+        # inject table rows ke template
+        body_html = re.sub(
+            r"<tbody[^>]*>.*?</tbody>",
+            f"<tbody>{invoice_table_rows}</tbody>{invoice_table_footer}",
+            template.body_html,
+            flags=re.DOTALL
+        ).replace('${object.name}', self.name or '') \
+         .replace('${object.partner_id.name}', self.partner_id.name or '') \
+         .replace('${object.seven_days_after_sent_date}', self.seven_days_after_sent_date or '') \
+         .replace('${object.perihal}', perihal_text or '')
+
+        values = {
+            'subject': template.subject.replace('${object.name}', self.name or ''),
+            'email_to': self.tujuan_email,
+            'email_from': 'finance@indoteknik.co.id',
+            'body_html': body_html,
+            'reply_to': 'finance@indoteknik.co.id',
+        }
+
+        template.send_mail(self.id, force_send=True, email_values=values)
+
+        _logger.info(
+            f"Surat Piutang {self.name} terkirim ke {self.tujuan_email} "
+            f"({self.partner_id.name}), total {len(selected_lines)} invoice."
+        )
 
     @api.onchange('partner_id')
     def _onchange_partner_id(self):
-- 
cgit v1.2.3