function multi create uangmuka pembelian on po

3 files changed, 139 insertions, 2 deletions

diff --git a/indoteknik_custom/models/__init__.py b/indoteknik_custom/models/__init__.py
index 510dd659..13d8f0b4 100755
--- a/indoteknik_custom/models/__init__.py
+++ b/indoteknik_custom/models/__init__.py
@@ -106,7 +106,7 @@ from . import po_multi_cancel
 from . import logbook_sj
 from . import report_logbook_sj
 from . import role_permission
-
+from . import purchase_order_multi_uangmuka
 from . import cust_commision
 from . import report_stock_forecasted
 from . import web_logging
diff --git a/indoteknik_custom/models/purchase_order.py b/indoteknik_custom/models/purchase_order.py
index 3a959391..8bef8274 100755
--- a/indoteknik_custom/models/purchase_order.py
+++ b/indoteknik_custom/models/purchase_order.py
@@ -116,6 +116,13 @@ class PurchaseOrder(models.Model):
         }
         return action
 
+    def open_form_multi_create_uang_muka(self):
+        action = self.env['ir.actions.act_window']._for_xml_id('indoteknik_custom.action_purchase_order_multi_uangmuka')
+        action['context'] = {
+            'po_ids': [x.id for x in self]
+        }
+        return action
+    
     def action_multi_update_paid_status(self):
         for purchase in self:
             purchase.update({
@@ -401,7 +408,6 @@ class PurchaseOrder(models.Model):
             if purchasing_job_state:
                 for purchasing_job in purchasing_job_state:
                     purchasing_job.unlink()
-               
 
 
     def _send_po_not_sync(self):
diff --git a/indoteknik_custom/models/purchase_order_multi_uangmuka.py b/indoteknik_custom/models/purchase_order_multi_uangmuka.py
new file mode 100644
index 00000000..eae92b67
--- /dev/null
+++ b/indoteknik_custom/models/purchase_order_multi_uangmuka.py
@@ -0,0 +1,131 @@
+from odoo import fields, models, _, api
+from odoo.exceptions import UserError
+from datetime import datetime
+from odoo.http import request
+
+import logging, math
+
+_logger = logging.getLogger(__name__)
+
+
+class PurchaseOrderMultiUangmuka(models.TransientModel):
+    _name = 'purchase.order.multi_uangmuka'
+    _description = 'digunakan untuk membuat Uang Muka Pembelian'
+
+    pay_amt = fields.Float(string='Uang Muka', help='berapa nilai yang terbentuk untuk COA Uang Muka Pembelian')
+    account_id = fields.Many2one('account.account', string='Bank Intransit', default=389, help='pilih COA intransit bank')
+    ongkir_amt = fields.Float(string='Ongkir', help='masukan nilai yang akan menjadi Pendapatan Ongkos Kirim')
+    selisih_amt = fields.Float(string='Selisih', help='masukan nilai yang akan menjadi Selisih Pembayaran')
+    total_amt = fields.Float(string='Total', help='Total yang akan masuk di journal entries')
+    
+    @api.onchange('pay_amt', 'ongkir_amt', 'selisih_amt')
+    def _compute_total_amt(self):
+        for o in self:
+            o.total_amt = o.pay_amt + o.ongkir_amt + o.selisih_amt
+
+    def create_uangmukapembelian(self, orders):
+        if self.pay_amt <= 0:
+            raise UserError('Payment Amount harus diisi')
+        if not self.account_id:
+            raise UserError('Bank Intransit harus diisi')
+        if not self.env.user.has_group('account.group_account_manager'):
+            raise UserError('Hanya Finance yang dapat membuat Uang Muka Pembelian')
+
+        current_time = datetime.now()
+
+        is_have_ongkir = is_have_selisih = False
+        if self.ongkir_amt > 0:
+            is_have_ongkir = True
+        if not math.isclose(self.selisih_amt, 0):
+            is_have_selisih = True
+
+        partner_name = ', '.join([rec.partner_id.name for rec in orders])
+        if any(rec.partner_id.parent_id for rec in orders):
+            partner_name = ', '.join([rec.partner_id.parent_id.name for rec in orders])
+
+        order_names = ', '.join([data.name for data in orders])  # Menggabungkan nama order menjadi satu string
+        ref_label = f'UANG MUKA PEMBELIAN {order_names} {partner_name}'
+        param_header = {
+            'ref': ref_label,
+            'date': current_time,
+            'journal_id': 11
+        }
+
+        account_move = self.env['account.move'].create([param_header])
+        debit_entries = []
+        pay_amt = 0
+
+        for order in orders:
+            _logger.info('Success Create Uang Muka Pembelian %s' % account_move.name)
+            partner_id = order.partner_id.parent_id.id if order.partner_id.parent_id else order.partner_id.id
+            partner = order.partner_id.parent_id.name if order.partner_id.parent_id else order.partner_id.name
+
+            param_debit = {
+                'move_id': account_move.id,
+                'account_id': 401,  # uang muka persediaan barang dagang
+                'partner_id': partner_id,
+                'currency_id': 12,
+                'debit': self.pay_amt,
+                'credit': 0,
+                'name': f'UANG MUKA PEMBELIAN {order.name} {partner}',
+            }
+            param_debit_ongkir = {
+                'move_id': account_move.id,
+                'account_id': 536,  # biaya ongkos kirim
+                'partner_id': partner_id,
+                'currency_id': 12,
+                'debit': self.ongkir_amt,
+                'credit': 0,
+                'name': f'UANG MUKA PEMBELIAN {order.name} {partner}',
+            }
+            param_debit_selisih = {
+                'move_id': account_move.id,
+                'account_id': 561,  # selisih pembayaran
+                'partner_id': partner_id,
+                'currency_id': 12,
+                'debit': self.selisih_amt,
+                'credit': 0,
+                'name': f'UANG MUKA PEMBELIAN {order.name} {partner}',
+            }
+
+            debit_entries.append(param_debit)
+            pay_amt += self.pay_amt
+
+            if is_have_ongkir:
+                debit_entries.append(param_debit_ongkir)
+                pay_amt += self.ongkir_amt
+
+            if is_have_selisih:
+                debit_entries.append(param_debit_selisih)
+                pay_amt += self.selisih_amt
+
+        param_credit = {
+            'move_id': account_move.id,
+            'account_id': self.account_id.id,  # bank in transit
+            'partner_id': partner_id,
+            'currency_id': 12,
+            'debit': 0,
+            'credit': pay_amt,
+            'name': f'UANG MUKA PEMBELIAN {order.name} {partner}',
+        }
+
+        debit_entries.append(param_credit)
+
+        # Create all account.move.line entries at once
+        self.env['account.move.line'].create(debit_entries)
+
+        return account_move.id
+
+    def save_multi_create_uang_muka(self):
+        po_ids = self._context['po_ids']
+        purchase = self.env['purchase.order'].browse(po_ids)
+        account_move = self.create_uangmukapembelian(purchase)
+        return {
+            'name': _('Journal Entries'),
+            'view_mode': 'form',
+            'res_model': 'account.move',
+            'target': 'current',
+            'view_id': False,
+            'type': 'ir.actions.act_window',
+            'res_id': account_move
+        }
\ No newline at end of file