From f953c7c5915e15bd499f374d49403ef2567e0071 Mon Sep 17 00:00:00 2001
From: Azka Nathan <darizkyfaz@gmail.com>
Date: Tue, 18 Jul 2023 16:37:47 +0700
Subject: refactor bill receipt

---
 indoteknik_custom/models/bill_receipt.py | 98 +++++++++++++++-----------------
 indoteknik_custom/views/bill_receipt.xml | 20 +++----
 2 files changed, 54 insertions(+), 64 deletions(-)

diff --git a/indoteknik_custom/models/bill_receipt.py b/indoteknik_custom/models/bill_receipt.py
index 39d5f31b..b3f7f0ae 100644
--- a/indoteknik_custom/models/bill_receipt.py
+++ b/indoteknik_custom/models/bill_receipt.py
@@ -11,8 +11,8 @@ class BillReceipt(models.Model):
     _rec_name = 'number'
 
     number = fields.Char(string='Document No', index=True, copy=False, readonly=True, tracking=True)
-    vendor_id = fields.Many2one('res.partner', string="Vendor", required=True)
-    document_date = fields.Date(string="Document Date", required=True)
+    partner_id = fields.Many2one('res.partner', string="Vendor")
+    document_date = fields.Date(string="Document Date")
     description = fields.Text(string='Description')
     validated = fields.Boolean(string="Validated", readonly=True)
     bill_line = fields.One2many('bill.receipt.line', 'bill_id', string='Bill Receipt Lines')
@@ -24,8 +24,41 @@ class BillReceipt(models.Model):
         return result
     
     def validate_button(self):
-        if not self.bill_line:
-            raise UserError('Bill receipt line masih kosong')
+        if self.validated:
+            raise UserError('Sudah di validate, tidak bisa digenerate ulang')
+        if self.bill_line:
+            raise UserError('Harus hapus semua line jika ingin generate ulang')
+        if self.partner_id.parent_id:
+            raise UserError('Harus pilih parent company')
+
+        partners = []
+        partners += self.partner_id.child_ids
+        partners.append(self.partner_id)
+
+        for partner in partners:
+            query = [
+                ('move_type', '=', 'in_invoice'),
+                ('state', '=', 'posted'),
+                ('payment_state', '=', 'not_paid'),
+                ('partner_id', '=', partner.id),
+                ('date_kirim_tukar_faktur', '=', False),
+            ]
+            invoices = self.env['account.move'].search(query, order='invoice_date')
+            count = 0
+            for invoice in invoices:
+                self.env['bill.receipt.line'].create([{
+                    'bill_id': self.id,
+                    'partner_id': invoice.partner_id.id,
+                    'invoice_id': invoice.id,
+                    'date_invoice': invoice.invoice_date,
+                    'efaktur_id': invoice.efaktur_id.id,
+                    'reference': invoice.ref,
+                    'total_amt': invoice.amount_total,
+                    'open_amt': invoice.amount_residual_signed,
+                    'due_date': invoice.invoice_date_due
+                }])
+                count += 1
+            _logger.info("Bill Receipt Line generated %s" % count)
         
         self.validated = True
 
@@ -43,53 +76,12 @@ class BillReceiptLine(models.Model):
     _description = 'Bill Receipt Line'
     _order = 'bill_id, id'
 
-    bill_id = fields.Many2one('bill.receipt', string='Bill Receipt')
-    sale_order_id = fields.Many2one('sale.order', string='Sale Order')
-    po_id = fields.Many2one('purchase.order', string='PO')
-    user_id = fields.Many2one('res.users', string='Purchase Rep')
-    payment_term_id = fields.Many2one('account.payment.term', string='Payment Terms')
-    vendor_id = fields.Many2one('res.partner', string='Vendor')
-    date_approve = fields.Datetime(string='Confirmation Date')
-    date_planned = fields.Datetime(string='Receipt Date')
-    amount_untaxed = fields.Float(string='Untaxed Amount')
-    amount_total = fields.Float(string='Total')
+    bill_id = fields.Many2one('bill.receipt', string='Bill Ref', required=True, ondelete='cascade', index=True, copy=False)
+    partner_id = fields.Many2one('res.partner', string='Customer')
+    invoice_id = fields.Many2one('account.move', string='Invoice')
+    date_invoice = fields.Date(string='Invoice Date')
+    efaktur_id = fields.Many2one('vit.efaktur', string='Faktur Pajak')
     reference = fields.Char(string='Reference')
-    partner_ref = fields.Char(string='Vendor Reference')
-
-    @api.onchange('po_id')
-    def onchange_partner_ref(self):
-        self.partner_ref = self.po_id.partner_ref
-
-    @api.onchange('po_id')
-    def onchange_vendor_id(self):
-        self.vendor_id = self.po_id.partner_id
-
-    @api.onchange('po_id')
-    def onchange_date_approve(self):
-        self.date_approve = self.po_id.date_approve
-
-    @api.onchange('po_id')
-    def onchange_date_planned(self):
-        self.date_planned = self.po_id.date_planned
-
-    @api.onchange('po_id')
-    def onchange_amount_untaxed(self):
-        self.amount_untaxed = self.po_id.amount_untaxed
-
-    @api.onchange('po_id')
-    def onchange_user_id(self):
-        self.user_id = self.po_id.user_id
-
-    @api.onchange('po_id')
-    def onchange_sale_order_id(self):
-        self.sale_order_id = self.po_id.sale_order_id
-
-    @api.onchange('po_id')
-    def onchange_payment_term_id(self):
-        self.payment_term_id = self.po_id.payment_term_id
-
-    @api.onchange('po_id')
-    def onchange_amount_total(self):
-        self.amount_total = self.po_id.amount_total
-
-
+    total_amt = fields.Float(string='Total Amount')
+    open_amt = fields.Float(string='Open Amount')
+    due_date = fields.Date(string='Due Date')
\ No newline at end of file
diff --git a/indoteknik_custom/views/bill_receipt.xml b/indoteknik_custom/views/bill_receipt.xml
index c73802c2..138bd0a0 100644
--- a/indoteknik_custom/views/bill_receipt.xml
+++ b/indoteknik_custom/views/bill_receipt.xml
@@ -6,7 +6,7 @@
         <field name="arch" type="xml">
             <tree>
                 <field name="number"/>
-                <field name="vendor_id"/>
+                <field name="partner_id"/>
                 <field name="document_date"/>
                 <field name="description"/>
                 <field name="validated"/>
@@ -19,16 +19,14 @@
         <field name="model">bill.receipt.line</field>
         <field name="arch" type="xml">
             <tree>
-                <field name="partner_ref"/>
-                <field name="po_id"/>
-                <field name="sale_order_id"/>
-                <field name="user_id"/>
-                <field name="vendor_id"/>
-                <field name="date_approve"/>
-                <field name="date_planned"/>
+                <field name="partner_id"/>
+                <field name="invoice_id"/>
+                <field name="date_invoice"/>
+                <field name="efaktur_id"/>
                 <field name="reference"/>
-                <field name="amount_untaxed"/>
-                <field name="amount_total"/>
+                <field name="total_amt"/>
+                <field name="open_amt"/>
+                <field name="due_date"/>
             </tree>
         </field>
     </record>
@@ -51,7 +49,7 @@
                 <sheet>
                     <group>
                         <group>
-                            <field name="vendor_id" attrs="{'readonly': [('validated', '=', True)]}"/>
+                            <field name="partner_id" attrs="{'readonly': [('validated', '=', True)]}"/>
                             <field name="document_date" attrs="{'readonly': [('validated', '=', True)]}"/>
                             <field name="description" attrs="{'readonly': [('validated', '=', True)]}"/>
                         </group>
-- 
cgit v1.2.3


From ce1c11b9be9274cf281a00cc340969f094a698be Mon Sep 17 00:00:00 2001
From: Azka Nathan <darizkyfaz@gmail.com>
Date: Fri, 21 Jul 2023 10:00:16 +0700
Subject: update receipt bill

---
 indoteknik_custom/models/bill_receipt.py | 98 ++++++++++++++++++++++----------
 indoteknik_custom/views/bill_receipt.xml | 57 ++++++++++++++-----
 2 files changed, 110 insertions(+), 45 deletions(-)

diff --git a/indoteknik_custom/models/bill_receipt.py b/indoteknik_custom/models/bill_receipt.py
index b3f7f0ae..5e03fdce 100644
--- a/indoteknik_custom/models/bill_receipt.py
+++ b/indoteknik_custom/models/bill_receipt.py
@@ -1,30 +1,68 @@
 from odoo import models, api, fields
 from odoo.exceptions import AccessError, UserError, ValidationError
-from datetime import timedelta, date
+from datetime import timedelta
 import logging
 
 _logger = logging.getLogger(__name__)
 
+
 class BillReceipt(models.Model):
-    _name = "bill.receipt"
-    _description = "Bill Receipt"
-    _rec_name = 'number'
+    _name = 'bill.receipt'
+    _description = 'Bill Receipt'
+    _order = 'bill_date desc, id desc'
 
-    number = fields.Char(string='Document No', index=True, copy=False, readonly=True, tracking=True)
-    partner_id = fields.Many2one('res.partner', string="Vendor")
-    document_date = fields.Date(string="Document Date")
-    description = fields.Text(string='Description')
-    validated = fields.Boolean(string="Validated", readonly=True)
-    bill_line = fields.One2many('bill.receipt.line', 'bill_id', string='Bill Receipt Lines')
+    number = fields.Char(string='Document No', index=True, copy=False, readonly=True)
+    bill_date = fields.Date(string='Bill Date', required=True)
+    partner_id = fields.Many2one(
+        'res.partner', string='Vendor',
+        required=True, change_default=True, index=True, tracking=1)
+    bill_line = fields.One2many('bill.receipt.line', 'bill_id', string='Bill Receipt Lines', auto_join=True)
+    # dunning_level = fields.Integer(string='Bill Level', default=30, help='30 hari sebelum jatuh tempo invoice')
+    date_kirim_tukar_faktur = fields.Date(string='Kirim Faktur')
+    resi_tukar_faktur = fields.Char(string='Resi Faktur')
+    date_terima_tukar_faktur = fields.Date(string='Terima Faktur')
+    shipper_faktur_id = fields.Many2one('delivery.carrier', string='Shipper Faktur')
+    is_validated = fields.Boolean(string='Validated')
+    notification = fields.Char(string='Notification')
 
-    @api.model
-    def create(self, vals):
-        vals['number'] = self.env['ir.sequence'].next_by_code('bill.receipt') or '0'
-        result = super(BillReceipt, self).create(vals)
-        return result
-    
-    def validate_button(self):
-        if self.validated:
+    def copy_date_faktur(self):
+        if not self.is_validated:
+            raise UserError('Harus di validate dulu')
+        for line in self.bill_line:
+            invoice = line.invoice_id
+            if not invoice.date_kirim_tukar_faktur and self.date_kirim_tukar_faktur:
+                invoice.date_kirim_tukar_faktur = self.date_kirim_tukar_faktur
+                tukar_date = self.date_kirim_tukar_faktur
+                term = invoice.invoice_payment_term_id
+                add_days = 0
+                for line in term.line_ids:
+                    add_days += line.days
+                due_date = tukar_date + timedelta(days=add_days)
+                invoice.invoice_date_due = due_date
+            if not invoice.resi_tukar_faktur:
+                invoice.resi_tukar_faktur = self.resi_tukar_faktur
+            if not invoice.date_terima_tukar_faktur and self.date_terima_tukar_faktur:
+                invoice.date_terima_tukar_faktur = self.date_terima_tukar_faktur
+                tukar_date = self.date_terima_tukar_faktur
+                term = invoice.invoice_payment_term_id
+                add_days = 0
+                for line in term.line_ids:
+                    add_days += line.days
+                due_date = tukar_date + timedelta(days=add_days)
+                invoice.invoice_date_due = due_date
+            if not invoice.shipper_faktur_id:
+                invoice.shipper_faktur_id = self.shipper_faktur_id
+        self.notification = 'Berhasil copy tanggal terima faktur ke setiap invoice %s' % self.date_terima_tukar_faktur
+
+    def validate_bill(self):
+        if not self.bill_line:
+            raise UserError('Bill Line masih kosong, generate dulu')
+        else:
+            self.is_validated = True
+            self.notification = 'Jangan lupa klik Copy Date jika sudah ada tanggal kirim / tanggal terima faktur'
+
+    def generate_bill_line(self):
+        if self.is_validated:
             raise UserError('Sudah di validate, tidak bisa digenerate ulang')
         if self.bill_line:
             raise UserError('Harus hapus semua line jika ingin generate ulang')
@@ -39,8 +77,8 @@ class BillReceipt(models.Model):
             query = [
                 ('move_type', '=', 'in_invoice'),
                 ('state', '=', 'posted'),
-                ('payment_state', '=', 'not_paid'),
                 ('partner_id', '=', partner.id),
+                ('payment_state', '=', 'not_paid'),
                 ('date_kirim_tukar_faktur', '=', False),
             ]
             invoices = self.env['account.move'].search(query, order='invoice_date')
@@ -58,19 +96,15 @@ class BillReceipt(models.Model):
                     'due_date': invoice.invoice_date_due
                 }])
                 count += 1
-            _logger.info("Bill Receipt Line generated %s" % count)
-        
-        self.validated = True
+            _logger.info("Bill Line generated %s" % count)
+
+    @api.model
+    def create(self, vals):
+        vals['number'] = self.env['ir.sequence'].next_by_code('bill.receipt') or '0'
+        result = super(BillReceipt, self).create(vals)
+        return result
 
-    def cancel_button(self):
-        if not self.bill_line:
-            raise UserError('Bill receipt line masih kosong')
-        
-        if self.validated != True:
-            raise UserError('Document ini belum di validate')
 
-        self.validated = False
-    
 class BillReceiptLine(models.Model):
     _name = 'bill.receipt.line'
     _description = 'Bill Receipt Line'
@@ -80,8 +114,10 @@ class BillReceiptLine(models.Model):
     partner_id = fields.Many2one('res.partner', string='Customer')
     invoice_id = fields.Many2one('account.move', string='Invoice')
     date_invoice = fields.Date(string='Invoice Date')
+    # due_date = fields.Date(string='Due Date')
     efaktur_id = fields.Many2one('vit.efaktur', string='Faktur Pajak')
     reference = fields.Char(string='Reference')
     total_amt = fields.Float(string='Total Amount')
     open_amt = fields.Float(string='Open Amount')
-    due_date = fields.Date(string='Due Date')
\ No newline at end of file
+    due_date = fields.Date(string='Due Date')
+
diff --git a/indoteknik_custom/views/bill_receipt.xml b/indoteknik_custom/views/bill_receipt.xml
index 138bd0a0..c9ab492a 100644
--- a/indoteknik_custom/views/bill_receipt.xml
+++ b/indoteknik_custom/views/bill_receipt.xml
@@ -6,10 +6,13 @@
         <field name="arch" type="xml">
             <tree>
                 <field name="number"/>
+                <field name="bill_date"/>
                 <field name="partner_id"/>
-                <field name="document_date"/>
-                <field name="description"/>
-                <field name="validated"/>
+                <field name="is_validated" readonly="1"/>
+                <field name="date_kirim_tukar_faktur"/>
+                <field name="resi_tukar_faktur"/>
+                <field name="date_terima_tukar_faktur"/>
+                <field name="shipper_faktur_id"/>
             </tree>
         </field>
     </record>
@@ -37,29 +40,41 @@
         <field name="arch" type="xml">
             <form>
                 <header>
-                    <button name="validate_button"
+                    <button name="generate_bill_line"
+                        string="Generate"
+                        type="object"
+                        class="mr-2 oe_highlight oe_edit_only"
+                    />
+                    <button name="validate_bill"
                         string="Validate"
                         type="object"
+                        class="mr-2 oe_highlight oe_edit_only"
                     />
-                    <button name="cancel_button"
-                            string="Cancel"
-                            type="object"
+                    <button name="copy_date_faktur"
+                        string="Copy Date"
+                        type="object"
+                        class="oe_highlight oe_edit_only"
                     />
                 </header>
                 <sheet>
                     <group>
                         <group>
-                            <field name="partner_id" attrs="{'readonly': [('validated', '=', True)]}"/>
-                            <field name="document_date" attrs="{'readonly': [('validated', '=', True)]}"/>
-                            <field name="description" attrs="{'readonly': [('validated', '=', True)]}"/>
+                            <field name="number"/>
+                            <field name="partner_id"/>
+                            <field name="bill_date"/>
+                            <field name="notification" readonly="1"/>
                         </group>
                         <group>
-                            <field name="validated" readonly="1"/>    
+                            <field name="is_validated" readonly="1"/>
+                            <field name="date_kirim_tukar_faktur"/>
+                            <field name="resi_tukar_faktur"/>
+                            <field name="date_terima_tukar_faktur"/>
+                            <field name="shipper_faktur_id"/>    
                         </group>
                     </group>
                     <notebook>
-                        <page string="Bill Line" name="bill_line">
-                            <field name="bill_line" attrs="{'readonly': [('validated', '=', True)]}"/>
+                        <page string="Bills">
+                            <field name="bill_line" attrs="{'readonly': [('is_validated', '=', True)]}"/>
                         </page>
                     </notebook>
                 </sheet>
@@ -67,16 +82,30 @@
         </field>
     </record>
 
+    <record id="view_bill_receipt_filter" model="ir.ui.view">
+        <field name="name">bill.receipt.list.select</field>
+        <field name="model">bill.receipt</field>
+        <field name="priority" eval="15"/>
+        <field name="arch" type="xml">
+            <search string="Search Bills">
+                <field name="number"/>  
+                <field name="partner_id"/>
+                <field name="bill_line" string="Bill" filter_domain="[('bill_line.invoice_id', 'ilike', self)]"/>
+           </search>
+        </field>
+    </record>
+
     <record id="bill_receipt_action" model="ir.actions.act_window"> 
         <field name="name">Bill Line</field>
         <field name="type">ir.actions.act_window</field>
         <field name="res_model">bill.receipt</field>
+        <field name="search_view_id" ref="view_bill_receipt_filter"/>
         <field name="view_mode">tree,form</field>
     </record>
 
     <menuitem
         id="menu_bill_receipt"
-        name="Bill Line"
+        name="Bill Receipt"
         parent="account.menu_finance_reports"
         sequence="250"
         action="bill_receipt_action"
-- 
cgit v1.2.3