Merge branch 'odoo-production' into feature/integrasi_biteship

# Conflicts:
#	indoteknik_custom/__manifest__.py
#	indoteknik_custom/models/__init__.py
#	indoteknik_custom/security/ir.model.access.csv

5 files changed, 380 insertions, 8 deletions

diff --git a/indoteknik_api/controllers/api_v1/flash_sale.py b/indoteknik_api/controllers/api_v1/flash_sale.py
index 00b1f2e0..6c4ad8c0 100644
--- a/indoteknik_api/controllers/api_v1/flash_sale.py
+++ b/indoteknik_api/controllers/api_v1/flash_sale.py
@@ -20,6 +20,7 @@ class FlashSale(controller.Controller):
                 query = [
                     ('pricelist_id', '=', pricelist.id)
                 ]
+                formatted_end_date = pricelist.end_date.strftime('%Y-%m-%dT%H:%M:%S.%f')[:-3] + 'Z' if pricelist.end_date else None
                 data.append({
                     'pricelist_id': pricelist.id,
                     'option': pricelist.flashsale_option,
@@ -29,6 +30,7 @@ class FlashSale(controller.Controller):
                     'banner_mobile': request.env['ir.attachment'].api_image('product.pricelist', 'banner_mobile', pricelist.id),
                     'banner_top': request.env['ir.attachment'].api_image('product.pricelist', 'banner_top', pricelist.id),
                     'duration': pricelist._remaining_time_in_second(),
+                    'end_date': formatted_end_date,
                     'product_total': request.env['product.pricelist.item'].search_count(query),
                 })
             return self.response(data)
diff --git a/indoteknik_api/controllers/api_v1/invoice.py b/indoteknik_api/controllers/api_v1/invoice.py
index 4937e8dd..4bd3746c 100644
--- a/indoteknik_api/controllers/api_v1/invoice.py
+++ b/indoteknik_api/controllers/api_v1/invoice.py
@@ -1,7 +1,7 @@
 from .. import controller
 from odoo import http
 from odoo.http import request
-
+from odoo import fields
 
 class Invoice(controller.Controller):
     PREFIX = '/api/v1/'
@@ -15,6 +15,7 @@ class Invoice(controller.Controller):
             'name': [],
             'limit': ['default:0', 'number'],
             'offset': ['default:0', 'number'],
+            'status': [],
         })
         limit = params['value']['limit']
         offset = params['value']['offset']
@@ -27,6 +28,11 @@ class Invoice(controller.Controller):
             ('state', '=', 'posted'),
             ('partner_id', 'in', partner_child_ids)
         ]
+        domain_orders = [
+            ('invoice_status', '!=', 'invoiced'),
+            ('state', '=', 'sale'),
+            ('partner_id', 'in', partner_child_ids)
+        ]
         if params['value']['name']:
             name = params['value']['name'].replace(' ', '%')
             domain += [
@@ -34,10 +40,25 @@ class Invoice(controller.Controller):
                 ('name', 'ilike', '%'+ name +'%'),
                 ('ref', 'ilike', '%'+ name +'%')
             ]
+        if params['value']['status']:
+            if params['value']['status'] == '1':
+                domain += [('payment_state', '=', 'not_paid'), ('invoice_date_due', '<', fields.Date.today())]
+            elif params['value']['status'] == '2':
+                domain += [('payment_state', '=', 'not_paid'), ('invoice_date_due', '>', fields.Date.today())]
+            elif params['value']['status'] == '3':
+                domain += [('payment_state', '=', 'paid')]
+            elif params['value']['status'] == '0':
+                domain = domain
+            elif params['value']['status'] == '4':
+                domain += [('payment_state', '=', 'not_paid')]
+
         invoices = request.env['account.move'].search(domain, offset=offset, limit=limit)
+        sale_orders = request.env['sale.order'].search(domain_orders, offset=offset, limit=limit)
         data = {
             'invoice_total': request.env['account.move'].search_count(domain),
-            'invoices': [request.env['account.move'].api_v1_single_response(x) for x in invoices]
+            'invoices': [request.env['account.move'].api_v1_single_response(x) for x in invoices],
+            'sale_order_total': request.env['sale.order'].search_count(domain_orders),
+            'sale_orders': [request.env['sale.order'].api_v1_single_response(x) for x in sale_orders]
         }
         return self.response(data)
 
diff --git a/indoteknik_api/controllers/api_v1/partner.py b/indoteknik_api/controllers/api_v1/partner.py
index bbca471b..885cf3ec 100644
--- a/indoteknik_api/controllers/api_v1/partner.py
+++ b/indoteknik_api/controllers/api_v1/partner.py
@@ -1,7 +1,10 @@
 from .. import controller
 from odoo import http
 from odoo.http import request
-
+from odoo import fields
+import json
+import base64
+import mimetypes
 
 class Partner(controller.Controller):
     _name = 'res.partner'
@@ -135,6 +138,8 @@ class Partner(controller.Controller):
             'npwp': [],
             'alamat_lengkap_text': [],
             'street': [],
+            'email': [],
+            'mobile': []
         })
 
         # Mengambil id_user dari request
@@ -208,6 +213,32 @@ class Partner(controller.Controller):
             })
 
         return self.response(data)
+
+    @http.route(prefix + 'partner/payment_term', auth='public', methods=['GET', 'OPTIONS'])
+    @controller.Controller.must_authorized()
+    def get_partner_payment_term(self):
+        partner_industry = request.env['account.payment.term'].search([])
+        data = []
+        for industry in partner_industry:
+            if 'tempo' in industry.name.lower():
+                data.append({
+                    'id': industry.id,
+                    'name': industry.name
+                })
+
+        return self.response(data)
+
+    @http.route(prefix + 'partner/detail-tempo/<id>', auth='public', methods=['GET', 'OPTIONS'])
+    @controller.Controller.must_authorized()
+    def get_partner_detail_tempo(self, **kw):
+        params = self.get_request_params(kw, {
+            'id': ['required', 'number']
+        })
+        pengajuan_tempo = request.env['user.pengajuan.tempo'].search([('name_tempo', '=', params['value']['id'])], limit=1)
+        if not pengajuan_tempo:
+            return self.response(code=404, description='pengajuan tempo not found')
+        pengajuan_tempo = request.env['res.partner'].api_single_response(pengajuan_tempo)
+        return self.response(pengajuan_tempo)
     
     @http.route(prefix + 'check/<partner_id>/tempo', auth='public', methods=['GET', 'OPTIONS'])
     @controller.Controller.must_authorized()
@@ -222,18 +253,318 @@ class Partner(controller.Controller):
 
         if any(line.days == 0 for line in partner.property_payment_term_id.line_ids):
             return self.response(code=402, description='Partner not tempo')
-        
-        result_tempo = sum(m.amount_total_signed for m in request.env['account.move'].search([('partner_id', '=', partner.id), ('payment_state', '=', 'not_paid'), ('state', '=', 'posted')]))
-        
+
+        domain_result_tempo = [('partner_id', '=', partner.id), ('payment_state', '=', 'not_paid'), ('state', '=', 'posted')]
+        domain_result_jatuh_tempo = [('partner_id', '=', partner.id), ('payment_state', '=', 'not_paid'), ('state', '=', 'posted'), ('invoice_date_due', '<', fields.Date.today())]
+        domain_orders = [('partner_id', '=', partner.id), ('invoice_status', '!=', 'invoiced'), ('state', '=', 'sale')]
+
+        result_tempo = sum(m.amount_total_signed for m in request.env['account.move'].search(domain_result_tempo))
+        result_tempo_total = request.env['account.move'].search_count(domain_result_tempo)
+        result_jatuh_tempo = sum(m.amount_total_signed for m in request.env['account.move'].search(domain_result_jatuh_tempo))
+        result_jatuh_tempo_total = request.env['account.move'].search_count(domain_result_jatuh_tempo)
+        orders = request.env['sale.order'].search(domain_orders)
+        orders_total = request.env['sale.order'].search_count(domain_orders)
+
+        total_amount = sum(order.amount_total for order in orders)
+
         remaining_limit = partner.blocking_stage - result_tempo if partner.active_limit else None
 
         data = {
             'name': partner.name,
+            'payment_term': partner.property_payment_term_id.name,
             'amount_due': result_tempo,
+            'amount_due_total': result_tempo_total,
+            'amount_jatuh_tempo_total': result_jatuh_tempo_total,
+            'amount_jatuh_tempo': result_jatuh_tempo,
+            'amount_due_sale': total_amount,
+            'amount_due_sale_total': orders_total,
             'remaining_limit': remaining_limit
         }
-        
+
+        return self.response(data)
+
+    @http.route(prefix + 'check/<partner_id>/tempo_progress', auth='public', methods=['GET', 'OPTIONS'])
+    @controller.Controller.must_authorized()
+    def get_check_tempo_partner_progres(self, **kw):
+        partner_id = int(kw.get('partner_id'))
+        partner = request.env['res.partner'].search([('id', '=', partner_id)], limit=1)
+        pengajuan_tempo = request.env['user.pengajuan.tempo'].search([('name_tempo', '=', partner.id)], limit=1)
+        if not pengajuan_tempo:
+            return self.response(code=404, description='Partner not found')
+
+        data = True if pengajuan_tempo.id else False
         return self.response(data)
 
+    @http.route(prefix + 'partner/pengajuan_tempo', auth='public', methods=['POST'], csrf=False)
+    @controller.Controller.must_authorized()
+    def write_pengajuan_tempo(self, **kw):
+        id = int(kw.get('partner_id'))
+        user_id = int(kw.get('user_id'))
+        tempo_request = True if kw.get('tempo_request') == 'true' else False
+        pengajuan_tempo = request.env['user.pengajuan.tempo'].search([('name_tempo', '=', user_id)], limit=1)
+        user = request.env['res.partner'].search([('id', '=', user_id)], limit=1)
+        company_name = kw.get('name', pengajuan_tempo.name_tempo.name)
+        partner_id = request.env['res.partner'].search([('name', 'like', company_name)], limit=1)
+        user_account = self.get_user_by_email(user.email)
 
+        params = self.get_request_params(kw, {
+
+            # informasi perusahaan
+            # 'name': ['required', 'alias:name_tempo'],
+            'industryId': ['alias:industry_id_tempo'],
+            'street': ['alias:street_tempo'],
+            'state': ['alias:state_id_tempo'],
+            'city': ['alias:city_id_tempo'],
+            'district': ['alias:district_id_tempo'],
+            'subDistrict': ['alias:subDistrict_id_tempo'],
+            'zip': ['alias:zip_tempo'],
+            'mobile': ['alias:mobile_tempo'],
+            'bankName': ['alias:bank_name_tempo'],
+            'accountName': ['alias:account_name_tempo'],
+            'accountNumber': ['alias:account_number_tempo'],
+            'website': ['alias:website_tempo'],
+            'estimasi': ['alias:estimasi_tempo'],
+            'portal': ['alias:portal'],
+            'bersedia': ['alias:bersedia'],
+            'tempoDuration': ['alias:tempo_duration'],
+            'tempoLimit': ['alias:tempo_limit'],
+
+            # informasi perusahaan
+            'direkturTittle': ['alias:direktur_tittle'],
+            'direkturName': ['alias:direktur_name'],
+            'direkturMobile': ['alias:direktur_mobile'],
+            'direkturEmail': ['alias:direktur_email'],
+            'purchasingTittle': ['alias:purchasing_tittle'],
+            'purchasingName': ['alias:purchasing_name'],
+            'purchasingMobile': ['alias:purchasing_mobile'],
+            'purchasingEmail': ['alias:purchasing_email'],
+            'financeTittle': ['alias:finance_tittle'],
+            'financeName': ['alias:finance_name'],
+            'financeMobile': ['alias:finance_mobile'],
+            'financeEmail': ['alias:finance_email'],
+
+            # Pengiriman
+            'PICTittle': ['alias:pic_tittle'],
+            'PICName': ['alias:pic_name'],
+            'streetPengiriman': ['alias:street_pengiriman'],
+            'statePengiriman': ['alias:state_id_pengiriman'],
+            'cityPengiriman': ['alias:city_id_pengiriman'],
+            'districtPengiriman': ['alias:district_id_pengiriman'],
+            'subDistrictPengiriman': ['alias:subDistrict_id_pengiriman'],
+            'zipPengiriman': ['alias:zip_pengiriman'],
+            'invoicePicTittle': ['alias:invoice_pic_tittle'],
+            'invoicePic': ['alias:invoice_pic'],
+            'streetInvoice': ['alias:street_invoice'],
+            'stateInvoice': ['alias:state_id_invoice'],
+            'cityInvoice': ['alias:city_id_invoice'],
+            'districtInvoice': ['alias:district_id_invoice'],
+            'subDistrictInvoice': ['alias:subDistrict_id_invoice'],
+            'zipInvoice': ['alias:zip_invoice'],
+            'isSameAddrees':['alias:is_same_address'],
+            'isSameAddreesStreet':['alias:is_same_address_street'],
+        })
+
+        # # Konversi nilai 'true' ke boolean True
+        # is_same_address = kw.get('isSameAddrees', 'false').lower() == 'true'
+        # is_same_address_street = kw.get('isSameAddreesStreet', 'false').lower() == 'true'
+        #
+        # # Tambahkan nilai yang dikonversi ke params
+        # if 'isSameAddress' in kw:
+        #     params['value']['is_same_address'] = is_same_address
+        # if 'is_same_address_street' in kw:
+        #     params['value']['is_same_address_street'] = is_same_address_street
+
+        if not params['valid']:
+            return self.response(code=400, description=params)
+        if params['value']['portal']:
+            if params['value']['portal'] == 'ada':
+                params['value']['portal'] = True
+            else:
+                params['value']['portal'] = False
+        # Filter data baru yang dikirim (non-kosong, boolean False tetap masuk)
+        new_data = {key: value for key, value in params['value'].items() if value != ''}
+
+        if pengajuan_tempo:
+            # Jika pengajuan_tempo sudah ada, hanya write data baru yang non-kosong
+            pengajuan_tempo.write(new_data)
+        else:
+            # Jika belum ada, buat record baru
+            pengajuan_tempo = request.env['user.pengajuan.tempo'].create(new_data)
+            pengajuan_tempo.partner_id = user_id
+
+        if partner_id:
+            pengajuan_tempo.name_tempo = partner_id
+
+        form_supplier_data = kw.get('formSupplier', False)
+
+        if form_supplier_data:
+            try:
+                form_supplier_data = json.loads(form_supplier_data)
+
+                supplier_ids_to_add = []
+                for item in form_supplier_data:
+                    supplier_name = item.get("supplier")
+                    pic_name = item.get("pic")
+                    phone = item.get("telepon")
+                    tempo_duration = item.get("durasiTempo")
+                    credit_limit = item.get("creditLimit")
+
+                    new_data = {
+                        'name_supplier': supplier_name,
+                        'pic_name': pic_name,
+                        'phone': phone,
+                        'tempo_duration': tempo_duration,
+                        'credit_limit': credit_limit,
+                    }
+                    new_supplier_data = request.env['user.pengajuan.tempo.line'].create(new_data)
+
+                    supplier_ids_to_add.append(new_supplier_data.id)
+
+                pengajuan_tempo.write({'supplier_ids': [(6, 0, supplier_ids_to_add)]})
+
+            except json.JSONDecodeError:
+                return http.Response(status=400, json_body={'error': 'Invalid JSON format for formSupplier'})
+        category_produk_ids = kw.get('categoryProduk', False)
+        category_ids = ''
+        if category_produk_ids:
+            category_ids = list(map(int, category_produk_ids.split(',')))
+            pengajuan_tempo.category_produk_ids = [(6, 0, category_ids)]
+
+        tukar_invoice_input = kw.get('tukarInvoiceInput')
+        if tukar_invoice_input:
+            pengajuan_tempo.tukar_invoice = tukar_invoice_input
+
+        tukar_invoice_input_pembayaran = kw.get('tukarInvoiceInputPembayaran')
+        if tukar_invoice_input_pembayaran:
+            pengajuan_tempo.jadwal_bayar = tukar_invoice_input_pembayaran
+
+        dokumen_kirim = [
+            'Surat Tanda Terima Barang (STTB)',
+            'Good Receipt (GR)',
+            'Surat Terima Barang (STB)',
+            'Lembar Penerimaan Barang (LPB)'
+        ]
+
+        dokumen_kirim_barang_ids = kw.get('dokumenPengiriman')
+        dokumen_kirim_input = kw.get('dokumenKirimInput', '')
+        dokumen_kirim_barang_input = kw.get('dokumenPengirimanInput', '')
+        dokumen_kirim_barang = []
+
+        if dokumen_kirim_barang_ids:
+            dokumen_kirim_ids = list(map(int, dokumen_kirim_barang_ids.split(',')))
+            dokumen_kirim_barang = [dokumen_kirim[i] for i in dokumen_kirim_ids if 0 <= i < len(dokumen_kirim)]
+        if dokumen_kirim_input:
+            input_items = [item.strip() for item in dokumen_kirim_input.split(',')]
+            dokumen_kirim_barang.extend(item for item in input_items if item and item not in dokumen_kirim_barang)
+            pengajuan_tempo.dokumen_kirim_input = dokumen_kirim_input
+        if dokumen_kirim_barang:
+            pengajuan_tempo.dokumen_pengiriman = ', '.join(dokumen_kirim_barang)
+        if dokumen_kirim_barang_input:
+            pengajuan_tempo.dokumen_pengiriman_input = dokumen_kirim_barang_input
+
+        dokumen = [
+            'Invoice Pembelian',
+            'Surat Jalan',
+            'Berita Acara Serah Terima (BAST)',
+            'Faktur Pajak',
+            'Good Receipt (GR)'
+        ]
+
+        dokumen_invoice = kw.get('dokumenPengirimanInvoice', '')
+        if dokumen_invoice:
+            pengajuan_tempo.dokumen_invoice = dokumen_invoice
+        user_tempo_request = []
+        if tempo_request:
+            user_tempo_request = request.env['user.pengajuan.tempo.request'].create({
+                'user_id': id,
+                'pengajuan_tempo_id': pengajuan_tempo.id,
+                'user_company_id': partner_id.id,
+                'tempo_duration': pengajuan_tempo.tempo_duration.id,
+                'tempo_limit': pengajuan_tempo.tempo_limit,
+            })
+
+        form_dokumen_data = kw.get('formDocs', False)
+        if form_dokumen_data:
+            try:
+                form_dokumen = json.loads(form_dokumen_data)
+
+                for dokumen in form_dokumen:
+                    if dokumen['details']['base64'] != '':
+                        mimetype, _ = mimetypes.guess_type(dokumen['details']['name'])
+                        mimetype = mimetype or 'application/octet-stream'
+                        data = base64.b64decode(dokumen['details']['base64'])
+                        sppkp_attachment = request.env['ir.attachment'].create({
+                            'name': dokumen['details']['name'],
+                            'type': 'binary',
+                            'datas': base64.b64encode(data),
+                            'res_model': 'user.pengajuan.tempo',
+                            'res_id': pengajuan_tempo.id,
+                            'mimetype': mimetype
+                        })
+
+                        if dokumen['documentName'] == 'dokumenNib':
+                            pengajuan_tempo.dokumen_nib = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenSiup':
+                            pengajuan_tempo.dokumen_siup = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenTdp':
+                            pengajuan_tempo.dokumen_tdp = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenSkdp':
+                            pengajuan_tempo.dokumen_skdp = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenSkt':
+                            pengajuan_tempo.dokumen_skt = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenNpwp':
+                            pengajuan_tempo.dokumen_npwp = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenSppkp':
+                            pengajuan_tempo.dokumen_sppkp = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenAktaPerubahan':
+                            pengajuan_tempo.dokumen_akta_perubahan = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenKtpDirut':
+                            pengajuan_tempo.dokumen_ktp_dirut = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenAktaPendirian':
+                            pengajuan_tempo.dokumen_akta_pendirian = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenLaporanKeuangan':
+                            pengajuan_tempo.dokumen_laporan_keuangan = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenFotoKantor':
+                            pengajuan_tempo.dokumen_foto_kantor = [(6, 0, [sppkp_attachment.id])]
+
+                        elif dokumen['documentName'] == 'dokumenTempatBekerja':
+                            pengajuan_tempo.dokumen_tempat_bekerja = [(6, 0, [sppkp_attachment.id])]
+
+                        formatted_text = ''.join([' ' + char if char.isupper() and i != 0 else char for i, char in
+                                                  enumerate(dokumen['documentName'])])
+                        teks = formatted_text.strip().title()
+                        pengajuan_tempo.message_post(body=teks, attachment_ids=[sppkp_attachment.id])
+                        if tempo_request:
+                            user_tempo_request.message_post(body=teks, attachment_ids=[sppkp_attachment.id])
+
+
+            except json.JSONDecodeError:
+                return http.Response(status=400, json_body={'error': 'Invalid JSON format for formDokumen'})
+
+        if tempo_request:
+            # pengajuan_tempo.user_id = id
+            template = pengajuan_tempo.env.ref('indoteknik_custom.mail_template_res_user_company_request_tempo_review')
+            template.send_mail(pengajuan_tempo.id, force_send=True)
+            template2 = pengajuan_tempo.env.ref('indoteknik_custom.mail_template_res_user_company_new_tempo_to_sales')
+            template2.send_mail(pengajuan_tempo.id, force_send=True)
+        return self.response({
+            'id': pengajuan_tempo.id,
+            'user_id': user_id,
+        })
 
+    def get_user_by_email(self, email):
+        return request.env['res.users'].search([
+            ('login', '=', email),
+            ('active', 'in', [True, False])
+        ])
\ No newline at end of file
diff --git a/indoteknik_api/controllers/api_v1/state.py b/indoteknik_api/controllers/api_v1/state.py
index 598ef70b..958359a7 100644
--- a/indoteknik_api/controllers/api_v1/state.py
+++ b/indoteknik_api/controllers/api_v1/state.py
@@ -8,7 +8,11 @@ class District(controller.Controller):
     @http.route(prefix + 'state', auth='public', methods=['GET', 'OPTIONS'])
     @controller.Controller.must_authorized()
     def get_state(self, **kw):
+        tempo = kw.get('tempo')
         parameters = []
+        if tempo == 'true':
+            parameters.append(('country_id', '=', 100))
+
         
         name = kw.get('name')
         if name:
@@ -18,7 +22,7 @@ class District(controller.Controller):
         states = request.env['res.country.state'].search(parameters)
         data = []
         for state in states:
-            data.append({ 'id': state.id, 'name': state.name })
+            data.append({ 'id': state.id, 'name': state.name})
         
         return self.response(data)
 
diff --git a/indoteknik_api/controllers/api_v1/user.py b/indoteknik_api/controllers/api_v1/user.py
index 3be874fa..addf2c9f 100644
--- a/indoteknik_api/controllers/api_v1/user.py
+++ b/indoteknik_api/controllers/api_v1/user.py
@@ -403,6 +403,20 @@ class User(controller.Controller):
             'user': self.response_with_token(user)
         })
 
+    @http.route(prefix + 'user/<id>/after_request_tempo', auth='public', methods=['PUT', 'OPTIONS'], csrf=False)
+    @controller.Controller.must_authorized()
+    def update_user_tempo_after_request(self, **kw):
+        id = kw.get('id')
+
+        user = request.env['res.users'].search([('id', '=', id)], limit=1)
+        if not user:
+            return self.response(code=404, description='User not found')
+
+
+        return self.response({
+            'user': self.response_with_token(user)
+        })
+
     @http.route(prefix + 'user/<id>/address', auth='public', methods=['GET', 'OPTIONS'])
     @controller.Controller.must_authorized()
     def get_user_address_by_id(self, **kw):