Merge branch 'odoo-production' into dev/wms

# Conflicts:
#	indoteknik_custom/models/__init__.py
#	indoteknik_custom/models/stock_immediate_transfer.py
#	indoteknik_custom/models/stock_picking.py

1 files changed, 141 insertions, 20 deletions

diff --git a/indoteknik_custom/models/sale_order.py b/indoteknik_custom/models/sale_order.py
index 88c32fb6..3534306c 100755
--- a/indoteknik_custom/models/sale_order.py
+++ b/indoteknik_custom/models/sale_order.py
@@ -7,6 +7,50 @@ from collections import defaultdict
 
 _logger = logging.getLogger(__name__)
 
+class CancelReasonOrder(models.TransientModel):
+    _name = 'cancel.reason.order'
+    _description = 'Wizard for Cancel Reason order'
+
+    request_id = fields.Many2one('sale.order', string='Request')
+    reason_cancel = fields.Selection([
+        ('harga_terlalu_mahal', 'Harga barang terlalu mahal'),
+        ('harga_web_tidak_valid', 'Harga web tidak valid'),
+        ('stok_kosong', 'Stock kosong'),
+        ('tidak_mau_indent', 'Customer tidak mau indent'),
+        ('batal_rencana_pembelian', 'Customer membatalkan rencana pembelian'),
+        ('vendor_tidak_support_demo', 'Vendor tidak support demo/trial product'),
+        ('product_knowledge_kurang', 'Product knowledge kurang baik'),
+        ('barang_tidak_sesuai', 'Barang tidak sesuai/tepat'),
+        ('tidak_sepakat_pembayaran', 'Tidak menemukan kesepakatan untuk pembayaran'),
+        ('dokumen_tidak_support', 'Indoteknik tidak bisa support document yang dibutuhkan (Ex: TKDN, COO, SNI)'),
+        ('ganti_quotation', 'Ganti Quotation'),
+        ('testing_internal', 'Testing Internal'),
+        ('revisi_data', 'Revisi Data'),
+    ], string='Reason for Cancel', required=True, copy=False, index=True, tracking=3)
+    attachment_bukti = fields.Many2many(
+        'ir.attachment',
+        string="Attachment Bukti", readonly=False,
+        tracking=3, required=True
+    )
+    nomor_so_pengganti = fields.Char(string='Nomor SO Pengganti', copy=False, tracking=3)
+
+    def confirm_reject(self):
+        order = self.request_id
+        if order:
+            order.write({'reason_cancel': self.reason_cancel})
+            if not self.attachment_bukti:
+                raise UserError('Attachment bukti wajib disertakan')
+            order.write({'attachment_bukti': self.attachment_bukti})
+            order.message_post(body='Attachment Bukti Cancel',
+                                              attachment_ids=[self.attachment_bukti.id])
+            if self.reason_cancel == 'ganti_quotation':
+                if self.nomor_so_pengganti:
+                    order.write({'nomor_so_pengganti': self.nomor_so_pengganti})
+                else:
+                    raise UserError('Nomor SO pengganti wajib disertakan')
+            order.confirm_cancel_order()
+
+        return {'type': 'ir.actions.act_window_close'}
 
 class SaleOrder(models.Model):
     _inherit = "sale.order"
@@ -29,11 +73,11 @@ class SaleOrder(models.Model):
     shipping_cost_covered = fields.Selection([
         ('indoteknik', 'Indoteknik'),
         ('customer', 'Customer')
-    ], string='Shipping Covered by', help='Siapa yang menanggung biaya ekspedisi?', copy=False)
+    ], string='Shipping Covered by', help='Siapa yang menanggung biaya ekspedisi?', copy=False, tracking=3)
     shipping_paid_by = fields.Selection([
         ('indoteknik', 'Indoteknik'),
         ('customer', 'Customer')
-    ], string='Shipping Paid by', help='Siapa yang talangin dulu Biaya ekspedisi-nya?', copy=False)
+    ], string='Shipping Paid by', help='Siapa yang talangin dulu Biaya ekspedisi-nya?', copy=False, tracking=3)
     sales_tax_id = fields.Many2one('account.tax', string='Tax', domain=['|', ('active', '=', False), ('active', '=', True)])
     have_outstanding_invoice = fields.Boolean('Have Outstanding Invoice', compute='_have_outstanding_invoice')
     have_outstanding_picking = fields.Boolean('Have Outstanding Picking', compute='_have_outstanding_picking')
@@ -145,6 +189,34 @@ class SaleOrder(models.Model):
         ('PNR', 'Pareto Non Repeating'),
         ('NP', 'Non Pareto')
     ])
+    shipping_method_picking = fields.Char(string='Shipping Method Picking', compute='_compute_shipping_method_picking')
+    reason_cancel = fields.Selection([
+        ('harga_terlalu_mahal', 'Harga barang terlalu mahal'),
+        ('harga_web_tidak_valid', 'Harga web tidak valid'),
+        ('stok_kosong', 'Stock kosong'),
+        ('tidak_mau_indent', 'Customer tidak mau indent'),
+        ('batal_rencana_pembelian', 'Customer membatalkan rencana pembelian'),
+        ('vendor_tidak_support_demo', 'Vendor tidak support demo/trial product'),
+        ('product_knowledge_kurang', 'Product knowledge kurang baik'),
+        ('barang_tidak_sesuai', 'Barang tidak sesuai/tepat'),
+        ('tidak_sepakat_pembayaran', 'Tidak menemukan kesepakatan untuk pembayaran'),
+        ('dokumen_tidak_support', 'Indoteknik tidak bisa support document yang dibutuhkan (Ex: TKDN, COO, SNI)'),
+        ('ganti_quotation', 'Ganti Quotation'),
+        ('testing_internal', 'Testing Internal'),
+    ], string='Reason for Cancel', copy=False, index=True, tracking=3)
+    attachment_bukti = fields.Many2one(
+        'ir.attachment',
+        string="Attachment Bukti Cancel", readonly=False,
+    )
+    nomor_so_pengganti = fields.Char(string='Nomor SO Pengganti', copy=False, tracking=3)
+
+    def _compute_shipping_method_picking(self):
+        for order in self:
+            if order.picking_ids:
+                carrier_names = order.picking_ids.mapped('carrier_id.name')
+                order.shipping_method_picking = ', '.join(filter(None, carrier_names))
+            else:
+                order.shipping_method_picking = False
 
     @api.onchange('payment_status')
     def _is_continue_transaction(self):
@@ -541,22 +613,22 @@ class SaleOrder(models.Model):
         redirect_url = json.loads(lookup_json)['redirect_url']
         self.payment_link_midtrans = str(redirect_url)
 
-        # Generate QR code
-        qr = qrcode.QRCode(
-            version=1,
-            error_correction=qrcode.constants.ERROR_CORRECT_L,
-            box_size=10,
-            border=4,
-        )
-        qr.add_data(redirect_url)
-        qr.make(fit=True)
-        img = qr.make_image(fill_color="black", back_color="white")
+        if 'redirect_url' in response:
+            qr = qrcode.QRCode(
+                version=1,
+                error_correction=qrcode.constants.ERROR_CORRECT_L,
+                box_size=10,
+                border=4,
+            )
+            qr.add_data(redirect_url)
+            qr.make(fit=True)
+            img = qr.make_image(fill_color="black", back_color="white")
 
-        buffer = BytesIO()
-        img.save(buffer, format="PNG")
-        qr_code_img = base64.b64encode(buffer.getvalue()).decode()
+            buffer = BytesIO()
+            img.save(buffer, format="PNG")
+            qr_code_img = base64.b64encode(buffer.getvalue()).decode()
 
-        self.payment_qr_code = qr_code_img
+            self.payment_qr_code = qr_code_img
 
     @api.model
     def _generate_so_access_token(self, limit=50):
@@ -760,6 +832,7 @@ class SaleOrder(models.Model):
             
     def sale_order_approve(self):
         self.check_credit_limit()
+        self.check_limit_so_to_invoice()
         if self.validate_different_vendor() and not self.vendor_approval:
             return self._create_notification_action('Notification', 'Terdapat Vendor yang berbeda dengan MD Vendor')
         self.check_due()
@@ -817,6 +890,8 @@ class SaleOrder(models.Model):
                 order.approval_status = 'pengajuan2'
                 return self._create_approval_notification('Pimpinan')
             elif order._requires_approval_margin_manager():
+                self.check_credit_limit()
+                self.check_limit_so_to_invoice()
                 order.approval_status = 'pengajuan1'
                 return self._create_approval_notification('Sales Manager')
             
@@ -923,6 +998,29 @@ class SaleOrder(models.Model):
                         raise UserError(_("%s is in  Blocking Stage, Remaining credit limit is %s, from %s and outstanding %s")
                                         % (rec.partner_id.name, remaining_credit_limit, block_stage, outstanding_amount))
 
+    def check_limit_so_to_invoice(self):
+        for rec in self:
+            # Ambil jumlah outstanding_amount dan rec.amount_total sebagai current_total
+            outstanding_amount = rec.outstanding_amount
+            current_total = rec.amount_total + outstanding_amount
+
+            # Ambil blocking stage dari partner
+            block_stage = rec.partner_id.parent_id.blocking_stage if rec.partner_id.parent_id else rec.partner_id.blocking_stage or 0
+            is_cbd = rec.partner_id.parent_id.property_payment_term_id.id == 26 if rec.partner_id.parent_id else rec.partner_id.property_payment_term_id.id == 26 or False
+
+            # Ambil jumlah nilai dari SO yang invoice_status masih 'to invoice'
+            so_to_invoice = 0
+            for sale in rec.partner_id.sale_order_ids:
+                if sale.invoice_status == 'to invoice':
+                    so_to_invoice = so_to_invoice + sale.amount_total
+            # Hitung remaining credit limit
+            remaining_credit_limit = block_stage - current_total - so_to_invoice
+
+            # Validasi limit
+            if remaining_credit_limit <= 0 and block_stage > 0 and not is_cbd:
+                raise UserError(_("The credit limit for %s will exceed the Blocking Stage if the Sale Order is confirmed. The remaining credit limit is %s, from %s and the outstanding amount is %s.")
+                    % (rec.partner_id.name, block_stage - current_total, block_stage, outstanding_amount))
+
     def validate_different_vendor(self):
         if self.vendor_approval_id.filtered(lambda v: v.state == 'draft'):
             draft_names = ", ".join(self.vendor_approval_id.filtered(lambda v: v.state == 'draft').mapped('number'))
@@ -971,6 +1069,8 @@ class SaleOrder(models.Model):
         
     def action_confirm(self):
         for order in self:
+            order.check_credit_limit()
+            order.check_limit_so_to_invoice()
             if self.validate_different_vendor() and not self.vendor_approval:
                 return self._create_notification_action('Notification', 'Terdapat Vendor yang berbeda dengan MD Vendor')
             
@@ -1032,9 +1132,14 @@ class SaleOrder(models.Model):
         
         if self.have_outstanding_invoice:
             raise UserError("Invoice harus di Cancel dahulu")
+
+        disallow_states = ['draft', 'waiting', 'confirmed', 'assigned']
+        for picking in self.picking_ids:
+            if picking.state in disallow_states:
+                raise UserError("DO yang draft, waiting, confirmed, atau assigned harus di-cancel oleh Logistik")
         for line in self.order_line:
             if line.qty_delivered > 0:
-                raise UserError("DO harus di-cancel terlebih dahulu.")
+                raise UserError("DO yang done harus di-Return oleh Logistik")
         
         if not self.web_approval:
             self.web_approval = 'company'
@@ -1045,8 +1150,24 @@ class SaleOrder(models.Model):
         self.due_id = False
         if main_parent.use_so_approval:
             self.send_notif_to_salesperson(cancel=True)
+        for order in self:
+            if order.amount_total > 30000000:
+                return {
+                    'type': 'ir.actions.act_window',
+                    'name': _('Cancel Reason'),
+                    'res_model': 'cancel.reason.order',
+                    'view_mode': 'form',
+                    'target': 'new',
+                    'context': {'default_request_id': self.id},
+                }
         return super(SaleOrder, self).action_cancel()
-    
+
+    def confirm_cancel_order(self):
+        """Fungsi ini akan dipanggil oleh wizard setelah alasan pembatalan dipilih"""
+        if self.state != 'cancel':
+            self.state = 'cancel'
+        return super(SaleOrder, self).action_cancel()
+
     def validate_partner_invoice_due(self):
         parent_id = self.partner_id.parent_id.id
         parent_id =  parent_id if parent_id else self.partner_id.id
@@ -1078,10 +1199,10 @@ class SaleOrder(models.Model):
                     return False
             
     def _requires_approval_margin_leader(self):
-        return self.total_percent_margin <= 13 and not self.env.user.is_leader
+        return self.total_percent_margin < 15 and not self.env.user.is_leader
             
     def _requires_approval_margin_manager(self):
-        return self.total_percent_margin <= 20 and not self.env.user.is_leader and not self.env.user.is_sales_manager
+        return self.total_percent_margin >= 15 and not self.env.user.is_leader and not self.env.user.is_sales_manager
     
     def _create_approval_notification(self, approval_role):
         title = 'Warning'