From d37525b0dbdec49d2e812fc1945fb6a81a570e94 Mon Sep 17 00:00:00 2001
From: unknown <it@fixcomart.co.id>
Date: Wed, 17 Sep 2025 11:09:35 +0700
Subject: (andri) add numbering + testing

---
 indoteknik_custom/models/account_move.py                   | 13 +++++++++----
 indoteknik_custom/views/mail_template_invoice_reminder.xml |  1 +
 2 files changed, 10 insertions(+), 4 deletions(-)

diff --git a/indoteknik_custom/models/account_move.py b/indoteknik_custom/models/account_move.py
index b20e07c8..f10ca23f 100644
--- a/indoteknik_custom/models/account_move.py
+++ b/indoteknik_custom/models/account_move.py
@@ -203,6 +203,7 @@ class AccountMove(models.Model):
             ('invoice_date_due', 'in', target_dates),
             ('date_terima_tukar_faktur', '!=', False),
             ('invoice_payment_term_id.name', 'ilike', 'tempo')])
+        _logger.info(f"Found {len(invoices)} invoices due for reminder {invoices}.")
         if not invoices:
             _logger.info("Tidak ada invoice yang due")
             return
@@ -217,7 +218,9 @@ class AccountMove(models.Model):
             ('payment_state', 'not in', ['paid', 'in_payment', 'reversed']),
             ('invoice_date_due', '<', today),
             ('date_terima_tukar_faktur', '!=', False),
-            ('invoice_payment_term_id.name', 'ilike', 'tempo')])
+            ('invoice_payment_term_id.name', 'ilike', 'tempo'),
+            ('partner_id', 'in', [94603])])
+        _logger.info(f"Found {len(invoices)} invoices overdue for reminder {invoices}.")
         if not invoices:
             _logger.info("Tidak ada invoice yang overdue")
             return
@@ -281,11 +284,12 @@ class AccountMove(models.Model):
 
             invoice_table_rows = ""
             grand_total = 0
-            for inv in invs:
+            for idx, inv in enumerate(invs, start=1):  # numbering
                 days_to_due = (inv.invoice_date_due - today).days if inv.invoice_date_due else 0
                 grand_total += inv.amount_total
                 invoice_table_rows += f"""
                     <tr>
+                        <td>{idx}</td>
                         <td>{inv.partner_id.name}</td>
                         <td>{inv.ref or '-'}</td>
                         <td>{inv.name}</td>
@@ -296,6 +300,7 @@ class AccountMove(models.Model):
                         <td>{days_to_due}</td>
                     </tr>
                 """
+
             invoice_table_footer = f"""
                 <tfoot>
                     <tr style="font-weight:bold; background-color:#f9f9f9;">
@@ -428,10 +433,10 @@ class AccountMove(models.Model):
             }
 
             template.send_mail(invs[0].id, force_send=True, email_values=values)
-            _logger.info(f"Mengirim email ke: {values['email_to']} > email CC: {values['email_cc']}")
+            # _logger.info(f"Mengirim email ke: {values['email_to']} > email CC: {values['email_cc']}")
             _logger.info(f"Reminder terkirim ke {partner.name} ({values['email_to']}) → {len(invs)} invoice (dtd = {dtd})")
             # flag
-            invs.write({'reminder_sent_date': today})
+            # invs.write({'reminder_sent_date': today})
             # Post ke chatter
             user_system = self.env['res.users'].browse(25)
             system_id = user_system.partner_id.id if user_system else False
diff --git a/indoteknik_custom/views/mail_template_invoice_reminder.xml b/indoteknik_custom/views/mail_template_invoice_reminder.xml
index 13c02a08..3534f7f6 100644
--- a/indoteknik_custom/views/mail_template_invoice_reminder.xml
+++ b/indoteknik_custom/views/mail_template_invoice_reminder.xml
@@ -17,6 +17,7 @@
                  style="border-collapse:collapse; font-size:12px; border:1px solid #ddd;">
             <thead>
               <tr style="background-color:#f2f2f2; text-align:left;">
+                <th style="border:1px solid #ddd;">No.</th>
                 <th style="border:1px solid #ddd;">Customer</th>
                 <th style="border:1px solid #ddd;">No. PO</th>
                 <th style="border:1px solid #ddd;">Invoice Number</th>
-- 
cgit v1.2.3