From bb75985009a318cbbe9c4410806e06ed07aae6d1 Mon Sep 17 00:00:00 2001
From: "Indoteknik ." <it@fixcomart.co.id>
Date: Tue, 26 Aug 2025 13:58:48 +0700
Subject: (andri) add limit berdasarkan blocking amount dan limit terpakai
 berdasarkan total amount invoices yang ada

---
 indoteknik_custom/models/account_move.py | 25 +++++++++++++++++++++++--
 1 file changed, 23 insertions(+), 2 deletions(-)

diff --git a/indoteknik_custom/models/account_move.py b/indoteknik_custom/models/account_move.py
index 6f3190f0..49bfe762 100644
--- a/indoteknik_custom/models/account_move.py
+++ b/indoteknik_custom/models/account_move.py
@@ -273,6 +273,27 @@ class AccountMove(models.Model):
                 </tfoot>
             """
 
+            blocking_limit = partner.blocking_stage or 0.0
+
+            outstanding_invoices = self.env['account.move'].search([
+                ('move_type', '=', 'out_invoice'),
+                ('state', '=', 'posted'),
+                ('payment_state', 'not in', ['paid', 'in_payment', 'reversed']),
+                ('partner_id', '=', partner.id),
+                ('invoice_payment_term_id.name', 'ilike', 'tempo')
+                
+            ])
+            _logger.info(f"Outstanding invoices for {partner.name}: {outstanding_invoices}")
+            outstanding_amount = sum(outstanding_invoices.mapped('amount_total'))
+            currency = invs[0].currency_id if invs else partner.company_id.currency_id
+            limit_info_html = f"""
+                <p><b>Informasi Tambahan:</b></p>
+                <ul>
+                    <li>Total Limit: {formatLang(self.env, blocking_limit, currency_obj=currency)}</li>
+                    <li>Total Limit Terpakai: {formatLang(self.env, outstanding_amount, currency_obj=currency)}</li>
+                </ul>
+            """
+
             days_to_due_message = ""
             closing_message = ""
             if dtd > 0:
@@ -319,7 +340,7 @@ class AccountMove(models.Model):
             ).replace('${object.name}', partner.name) \
             .replace('${object.partner_id.name}', partner.name) \
             .replace('${days_to_due_message}', days_to_due_message) \
-            .replace('${closing_message}', closing_message)
+            .replace('${closing_message}', closing_message + limit_info_html)
 
             cc_list = [
                 'finance@indoteknik.co.id',
@@ -333,7 +354,7 @@ class AccountMove(models.Model):
 
             # Siapkan email values
             values = {
-                'subject': f"Reminder Invoice Due - {partner.name}",
+                'subject': f"Reminder Invoice Due Test - {partner.name}",
                 'email_to': 'andrifebriyadiputra@gmail.com',
                 # 'email_to': email_to, 
                 'email_from': 'finance@indoteknik.co.id',
-- 
cgit v1.2.3