<hafid> refund system sisa uang muka

1 files changed, 64 insertions, 16 deletions

diff --git a/indoteknik_custom/models/sale_order.py b/indoteknik_custom/models/sale_order.py
index aa534d0c..2acee890 100755
--- a/indoteknik_custom/models/sale_order.py
+++ b/indoteknik_custom/models/sale_order.py
@@ -358,7 +358,6 @@ class SaleOrder(models.Model):
         help="Tanggal pertama kali barang berhasil di-reservasi pada DO (BU/PICK/) yang berstatus Siap Dikirim."
     )
     refund_ids = fields.Many2many('refund.sale.order', compute='_compute_refund_ids', string='Refunds')
-    has_refund = fields.Boolean(string='Has Refund', compute='_compute_has_refund')
     refund_count = fields.Integer(string='Refund Count', compute='_compute_refund_count')
     advance_payment_move_id = fields.Many2one(
         'account.move',
@@ -3197,9 +3196,35 @@ class SaleOrder(models.Model):
     
     def button_refund(self):
         self.ensure_one()
+        moves = self.env['account.move'].search([
+            ('sale_id', '=', self.id),
+            ('journal_id', '=', 11),
+            ('state', '=', 'posted'),
+        ])
+
+        # Default 0
+        total_uang_muka = 0.0  
 
+        has_moves = bool(moves)
+        has_settlement = self.payment_status == 'settlement'
+
+        if has_moves and has_settlement:
+            total_uang_muka = sum(moves.mapped('amount_total_signed')) + self.gross_amount
+        elif has_moves:
+            total_uang_muka = sum(moves.mapped('amount_total_signed'))
+        elif has_settlement:
+            total_uang_muka = self.gross_amount
+        else:
+            raise UserError(
+                "Tidak bisa melakukan refund karena SO tidak memiliki Record Uang Masuk "
+                "(Journal Uang Muka/Midtrans Payment)."
+            )
         invoice_ids = self.invoice_ids.filtered(lambda inv: inv.state != 'cancel')
-        total_so = sum(self.mapped('amount_total'))
+        total_refunded = sum(self.refund_ids.mapped('amount_refund')) or 0.0
+        sisa_uang_muka = total_uang_muka - total_refunded
+
+        if sisa_uang_muka <= 0:
+            raise UserError("❌ Tidak ada sisa transaksi untuk di-refund. Semua dana sudah dikembalikan.")
 
         return {
             'name': 'Refund Sale Order',
@@ -3210,9 +3235,9 @@ class SaleOrder(models.Model):
             'context': {
                 'default_sale_order_ids': [(6, 0, [self.id])],
                 'default_invoice_ids': [(6, 0, invoice_ids.ids)],
-                'default_uang_masuk': total_so,
+                'default_uang_masuk': sisa_uang_muka,
                 'default_ongkir': self.delivery_amt or 0.0,
-                'default_bank': '',  # bisa isi default bank kalau mau
+                'default_bank': '',  
                 'default_account_name': '',
                 'default_account_no': '',
                 'default_refund_type': '',
@@ -3231,15 +3256,43 @@ class SaleOrder(models.Model):
         if len(invoice_status_set) > 1:
             raise UserError("Tidak dapat membuat refund untuk SO dengan status invoice berbeda. Harus memiliki status invoice yang sama.")
         
-        already_refunded = self.filtered(lambda so: so.has_refund)
-        if already_refunded:
-            so_names = ', '.join(already_refunded.mapped('name'))
-            raise UserError(f"❌ Tidak bisa refund ulang. {so_names} sudah melakukan refund.")
+        refunded_orders = self.filtered(lambda so: self.env['refund.sale.order'].search([('sale_order_ids', 'in', so.id)], limit=1))
+        if refunded_orders:
+            raise ValidationError(
+                f"SO {', '.join(refunded_orders.mapped('name'))} sudah pernah di-refund dan tidak bisa ikut dalam refund Multi SO."
+            )
+        
+        total_uang_masuk = 0.0
+        invalid_orders=[]
+        for order in self:
+            moves = self.env['account.move'].search([
+                ('sale_id', '=', order.id),
+                ('journal_id', '=', 11),
+                ('state', '=', 'posted'),
+            ])
+
+            total_uang_muka = 0.0  
+
+            if moves and order.payment_status == 'settlement':
+                total_uang_muka = order.gross_amount + sum(moves.mapped('amount_total_signed')) or 0.0
+            elif moves:
+                total_uang_muka = sum(moves.mapped('amount_total_signed')) or 0.0
+            elif order.payment_status == 'settlement':
+                total_uang_muka = order.gross_amount
+            else:
+                invalid_orders.append(order.name)
+
+            total_uang_masuk += total_uang_muka
+
+        if invalid_orders:
+            raise ValidationError(
+                f"Tidak dapat membuat refund untuk SO {', '.join(invalid_orders)} karena tidak memiliki Record Uang Masuk (Journal Uang Muka/Midtrans).\n"
+                "Pastikan semua SO yang dipilih sudah memiliki Record pembayaran yang valid."
+            )
+        
 
         invoice_ids = self.mapped('invoice_ids').filtered(lambda inv: inv.state != 'cancel')
         delivery_total = sum(self.mapped('delivery_amt'))
-        total_invoice = sum(invoice_ids.mapped('amount_total_signed'))
-        total_so = sum(self.mapped('amount_total'))
 
         return {
             'type': 'ir.actions.act_window',
@@ -3250,7 +3303,7 @@ class SaleOrder(models.Model):
             'context': {
                 'default_sale_order_ids': [(6, 0, self.ids)],
                 'default_invoice_ids': [(6, 0, invoice_ids.ids)],
-                'default_uang_masuk': total_so,
+                'default_uang_masuk': total_uang_masuk,
                 'default_ongkir': delivery_total,
                 'default_bank': '',
                 'default_account_name': '',
@@ -3259,11 +3312,6 @@ class SaleOrder(models.Model):
             }
         }
     
-    @api.depends('refund_ids')
-    def _compute_has_refund(self):
-        for so in self:
-            so.has_refund = bool(so.refund_ids)
-
     def action_view_related_refunds(self):
         self.ensure_one()
         return {