"""
days_to_due_message = ""
closing_message = ""
if mode == "due":
if dtd > 0:
days_to_due_message = (
f"Kami ingin mengingatkan bahwa tagihan anda akan jatuh tempo dalam {dtd} hari ke depan, "
"dengan rincian sebagai berikut:"
)
closing_message = (
"Kami mengharapkan pembayaran dapat dilakukan tepat waktu untuk mendukung kelancaran "
"hubungan kerja sama yang baik antara kedua belah pihak. "
"Mohon konfirmasi apabila pembayaran telah dijadwalkan. "
"Terima kasih atas perhatian dan kerja samanya."
)
elif dtd == 0:
days_to_due_message = (
"Kami ingin mengingatkan bahwa tagihan anda telah memasuki tanggal jatuh tempo pada hari ini, "
"dengan rincian sebagai berikut:"
)
closing_message = (
"Mohon kesediaannya untuk segera melakukan pembayaran tepat waktu guna menghindari status "
"keterlambatan dan menjaga kelancaran hubungan kerja sama yang telah terjalin dengan baik. "
"Apabila pembayaran telah dijadwalkan atau diproses, mohon dapat dikonfirmasi kepada kami. "
"Terima kasih atas perhatian dan kerja samanya."
)
else: # mode overdue
days_to_due_message = (
f"Kami ingin mengingatkan bahwa beberapa tagihan anda telah jatuh tempo, "
"dengan rincian sebagai berikut:"
)
closing_message = (
"Mohon kesediaan Bapak/Ibu untuk segera melakukan pembayaran guna menghindari keterlambatan "
"dan menjaga kelancaran kerja sama yang telah terjalin dengan baik. "
"Apabila pembayaran sudah dilakukan, mohon konfirmasi dan lampirkan bukti transfer agar dapat kami proses lebih lanjut. "
"Terima kasih atas perhatian dan kerja samanya."
)
body_html = re.sub(
r"]*>.*?",
f"{invoice_table_rows}{invoice_table_footer}",
template.body_html,
flags=re.DOTALL
).replace('${object.name}', partner.name) \
.replace('${object.partner_id.name}', partner.name) \
.replace('${days_to_due_message}', days_to_due_message) \
.replace('${closing_message}', closing_message) \
.replace('${limit_info_html}', limit_info_html)
cc_list = [
'finance@indoteknik.co.id',
'akbar@indoteknik.co.id',
'stephan@indoteknik.co.id',
'darren@indoteknik.co.id'
]
sales_email = invs[0].invoice_user_id.partner_id.email if invs[0].invoice_user_id else None
if sales_email and sales_email not in cc_list:
cc_list.append(sales_email)
# Siapkan email values
values = {
'subject': f"Reminder Invoice Due - {partner.name}",
# 'email_to': 'andrifebriyadiputra@gmail.com',
'email_to': email_to,
'email_from': 'finance@indoteknik.co.id',
'email_cc': ",".join(sorted(set(cc_list))),
'body_html': body_html,
'reply_to': 'finance@indoteknik.co.id',
}
template.send_mail(invs[0].id, force_send=True, email_values=values)
_logger.info(f"Mengirim email ke: {values['email_to']} > email CC: {values['email_cc']}")
_logger.info(f"Reminder terkirim ke {partner.name} ({values['email_to']}) → {len(invs)} invoice (dtd = {dtd})")
# flag
invs.write({'reminder_sent_date': today})
# Post ke chatter
user_system = self.env['res.users'].browse(25)
system_id = user_system.partner_id.id if user_system else False
for inv in invs:
inv.message_post(
subject=values['subject'],
body=body_html,
subtype_id=self.env.ref('mail.mt_note').id,
author_id=system_id,
)
@api.onchange('invoice_date')
def _onchange_invoice_date(self):
if self.invoice_date:
self.date = self.invoice_date
@api.onchange('date')
def _onchange_date(self):
if self.date:
self.invoice_date = self.date
@api.depends('refund_so_ids')
def _compute_refund_so_links(self):
for rec in self:
links = []
for so in rec.refund_so_ids:
url = f"/web#id={so.id}&model=sale.order&view_type=form"
name = html_escape(so.name or so.display_name)
links.append(f'{name}')
rec.refund_so_links = ', '.join(links) if links else "-"
@api.depends('refund_so_ids')
def _compute_has_refund_so(self):
for rec in self:
rec.has_refund_so = bool(rec.refund_so_ids)
# def compute_length_of_payment(self):
# for rec in self:
# payment_term = rec.invoice_payment_term_id.line_ids[0].days
# terima_faktur = rec.date_terima_tukar_faktur
# payment = self.search([('ref', '=', rec.name), ('move_type', '=', 'entry')], limit=1)
# if payment and terima_faktur:
# date_diff = terima_faktur - payment.date
# rec.length_of_payment = date_diff.days + payment_term
# else:
# rec.length_of_payment = 0
def compute_length_of_payment(self):
for rec in self:
payment_term = 0
if rec.invoice_payment_term_id and rec.invoice_payment_term_id.line_ids:
payment_term = rec.invoice_payment_term_id.line_ids[0].days
terima_faktur = rec.date_terima_tukar_faktur
payment = self.search([('ref', '=', rec.name), ('move_type', '=', 'entry')], limit=1)
if payment and terima_faktur:
date_diff = terima_faktur - payment.date
rec.length_of_payment = date_diff.days + payment_term
else:
rec.length_of_payment = 0
def _update_line_name_from_ref(self):
"""Update all account.move.line name fields with ref from account.move"""
for move in self:
if move.move_type == 'entry' and move.ref and move.line_ids:
for line in move.line_ids:
line.name = move.ref
def compute_other_taxes(self):
for rec in self:
rec.other_taxes = round(rec.other_subtotal * 0.12, 2)
def compute_other_subtotal(self):
for rec in self:
rec.other_subtotal = round(rec.amount_untaxed * (11 / 12))
@api.model
def generate_attachment(self, record):
# Fetch the binary field
file_content = record.efaktur_document
file_name = "efaktur_document_{}.pdf".format(record.id) # Adjust the file extension if necessary
attachment = self.env['ir.attachment'].create({
'name': file_name,
'type': 'binary',
'datas': file_content,
'res_model': record._name,
'res_id': record.id,
})
return attachment
@api.constrains('efaktur_document')
def send_scheduled_email(self):
# Get the records for which emails need to be sent
records = self.search([('id', 'in', self.ids)])
template = self.env.ref('indoteknik_custom.mail_template_efaktur_document')
for record in records:
if record.invoice_payment_term_id.id == 26:
attachment = self.generate_attachment(record)
email_values = {
'attachment_ids': [(4, attachment.id)]
}
template.send_mail(record.id, email_values=email_values, force_send=True)
# @api.model
# def create(self, vals):
# vals['nomor_kwitansi'] = self.env['ir.sequence'].next_by_code('nomor.kwitansi') or '0'
# result = super(AccountMove, self).create(vals)
# # result._update_line_name_from_ref()
# return result
@api.model
def create(self, vals):
vals['nomor_kwitansi'] = self.env['ir.sequence'].next_by_code('nomor.kwitansi') or '0'
result = super(AccountMove, self).create(vals)
# Tambahan: jika ini Vendor Bill dan tanggal belum diisi
if result.move_type == 'in_invoice' and not vals.get('invoice_date') and not vals.get('date'):
po = result.purchase_order_id
if po:
# Cari receipt dari PO
picking = self.env['stock.picking'].search([
('purchase_id', '=', po.id),
('picking_type_code', '=', 'incoming'),
('state', '=', 'done'),
('date_done', '!=', False),
], order='date_done desc', limit=1)
if picking:
receipt_date = picking.date_done
result.invoice_date = receipt_date
result.date = receipt_date
return result
def compute_so_shipping_paid_by(self):
for record in self:
record.so_shipping_paid_by = record.sale_id.shipping_paid_by
record.so_shipping_covered_by = record.sale_id.shipping_cost_covered
record.so_delivery_amt = record.sale_id.delivery_amt
def compute_flag_delivery_amt(self):
for record in self:
if record.sale_id.delivery_amt > 0:
record.flag_delivery_amt = True
else:
record.flag_delivery_amt = False
def compute_delivery_amt_text(self):
tb = Terbilang()
for record in self:
res = ''
try:
if record.sale_id.delivery_amt > 0:
tb.parse(int(record.sale_id.delivery_amt))
res = tb.getresult().title()
record.delivery_amt_text = res + ' Rupiah'
except:
record.delivery_amt_text = res
@api.constrains('bills_efaktur_document')
def _constrains_efaktur_document(self):
for move in self:
current_time = datetime.utcnow()
move.bills_date_efaktur = current_time
move.bills_efaktur_exporter = self.env.user.id
move.is_efaktur_uploaded = True
@api.constrains('bills_invoice_document')
def _constrains_invoice_efaktur(self):
for move in self:
current_time = datetime.utcnow()
move.bills_date_invoice = current_time
move.bills_invoice_exporter = self.env.user.id
move.is_invoice_uploaded = True
@api.constrains('partner_id')
def _constrains_real_invoice(self):
for move in self:
move.real_invoice_id = move.sale_id.real_invoice_id
@api.constrains('efaktur_document')
def _constrains_date_efaktur(self):
for move in self:
current_time = datetime.utcnow()
move.date_efaktur_upload = current_time
def open_form_multi_create_reklas_penjualan(self):
action = self.env['ir.actions.act_window']._for_xml_id('indoteknik_custom.action_view_invoice_reklas_penjualan')
invoice = self.env['invoice.reklas.penjualan'].create([{
'name': '-',
}])
for move in self:
sale_id = move.sale_id.id
self.env['invoice.reklas.penjualan.line'].create([{
'invoice_reklas_id': invoice.id,
'name': move.name,
'partner_id': move.partner_id.id,
'sale_id': move.sale_id.id,
'amount_untaxed_signed': move.amount_untaxed_signed,
'amount_total_signed': move.amount_total_signed,
}])
action['res_id'] = invoice.id
return action
def _compute_mark_upload_efaktur(self):
for move in self:
if move.efaktur_document:
move.mark_upload_efaktur = 'sudah_upload'
else:
move.mark_upload_efaktur = 'belum_upload'
def _compute_due_line(self):
for invoice in self:
invoice.due_line = self.env['due.extension.line'].search([
('invoice_id', '=', invoice.id),
('due_id.approval_status', '=', 'approved')
])
def unlink(self):
res = super(AccountMove, self).unlink()
for rec in self:
if rec.state == 'posted':
raise UserError('Data Hanya Bisa Di Cancel')
return res
def button_cancel(self):
res = super(AccountMove, self).button_cancel()
if self.move_type == 'entry':
po = self.env['purchase.order'].search([
('move_id', 'in', [self.id])
])
for order in po:
if order:
order.is_create_uangmuka = False
if self.id and not self.env.user.is_accounting:
raise UserError('Hanya Accounting yang bisa Cancel')
return res
def button_draft(self):
res = super(AccountMove, self).button_draft()
if not self.env.user.is_accounting:
raise UserError('Hanya Accounting yang bisa Reset to Draft')
for rec in self.line_ids:
if rec.write_date != rec.create_date:
if rec.statement_line_id and not rec.statement_line_id.statement_id.is_edit and rec.statement_line_id.statement_id.state == 'confirm':
raise UserError('Bank Statement di Lock, Minta admin reconcile untuk unlock')
return res
def action_post(self):
if self._name != 'account.move':
return super(AccountMove, self).action_post()
# validation cant qty invoice greater than qty order
if self.move_type == 'out_invoice':
query = ["&",("name","=",self.invoice_origin),"|",("state","=","sale"),("state","=","done")]
sale_order = self.env['sale.order'].search(query, limit=1)
sum_qty_invoice = sum_qty_order = 0
for line in sale_order.order_line:
sum_qty_invoice += line.qty_invoiced
sum_qty_order += line.product_uom_qty
if sum_qty_invoice > sum_qty_order:
raise UserError('Error Qty Invoice akan lebih besar dari Qty Order jika lanjut Posting')
elif self.move_type == 'in_invoice':
query = ["&",("name","=",self.invoice_origin),"|",("state","=","purchase"),("state","=","done")]
purchase_order = self.env['purchase.order'].search(query, limit=1)
sum_qty_invoice = sum_qty_order = 0
for line in purchase_order.order_line:
sum_qty_invoice += line.qty_invoiced
sum_qty_order += line.product_qty
if sum_qty_invoice > sum_qty_order:
raise UserError('Error Qty Invoice akan lebih besar dari Qty Order jika lanjut Posting')
res = super(AccountMove, self).action_post()
# if not self.env.user.is_accounting:
# raise UserError('Hanya Accounting yang bisa Posting')
# if self._name == 'account.move':
for entry in self:
entry.date_completed = datetime.utcnow()
for line in entry.line_ids:
line.date_maturity = entry.date
return res
def button_draft(self):
res = super(AccountMove, self).button_draft()
if not self.env.user.is_accounting:
raise UserError("Hanya Finence yang bisa ubah data")
return res
def _compute_invoice_day_to_due(self):
for invoice in self:
invoice_day_to_due = 0
new_invoice_day_to_due = 0
if invoice.payment_state not in ['paid', 'in_payment', 'reversed'] and invoice.invoice_date_due:
invoice_day_to_due = invoice.invoice_date_due - date.today()
new_invoice_day_to_due = invoice.invoice_date_due - date.today()
if invoice.new_due_date:
invoice_day_to_due = invoice.new_due_date - date.today()
invoice_day_to_due = invoice_day_to_due.days
new_invoice_day_to_due = new_invoice_day_to_due.days
invoice.invoice_day_to_due = invoice_day_to_due
invoice.new_invoice_day_to_due = new_invoice_day_to_due
def _compute_bill_day_to_due(self):
for rec in self:
rec.bill_day_to_due = rec.payment_schedule or rec.invoice_date_due
@api.onchange('date_kirim_tukar_faktur')
def change_date_kirim_tukar_faktur(self):
for invoice in self:
if not invoice.date_kirim_tukar_faktur:
return
tukar_date = invoice.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
@api.constrains('date_terima_tukar_faktur')
def change_date_terima_tukar_faktur(self):
for invoice in self:
if not invoice.date_terima_tukar_faktur:
return
tukar_date = invoice.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
def open_form_multi_update(self):
action = self.env['ir.actions.act_window']._for_xml_id('indoteknik_custom.action_account_move_multi_update')
action['context'] = {
'move_ids': [x.id for x in self]
}
return action
def open_form_multi_update_bills(self):
action = self.env['ir.actions.act_window']._for_xml_id('indoteknik_custom.action_account_move_multi_update_bills')
action['context'] = {
'move_ids': [x.id for x in self]
}
return action
@api.constrains('efaktur_id', 'ref', 'date', 'journal_id', 'name')
def constrains_edit(self):
for rec in self.line_ids:
if rec.statement_line_id and not rec.statement_line_id.statement_id.is_edit and rec.statement_line_id.statement_id.state == 'confirm':
raise UserError('Bank Statement di Lock, Minta admin reconcile untuk unlock')
# def write(self, vals):
# res = super(AccountMove, self).write(vals)
# for rec in self.line_ids:
# if rec.write_date != rec.create_date:
# if rec.statement_line_id and not rec.statement_line_id.statement_id.is_edit and rec.statement_line_id.statement_id.state == 'confirm':
# raise UserError('Bank Statement di Lock, Minta admin reconcile untuk unlock')
# return res
def validate_faktur_for_export(self):
invoices = self.filtered(lambda inv: not inv.is_efaktur_exported and
inv.state == 'posted' and
inv.move_type == 'out_invoice')
invalid_invoices = self - invoices
if invalid_invoices:
invalid_ids = ", ".join(str(inv.id) for inv in invalid_invoices)
raise UserError((
"Faktur dengan ID berikut tidak valid untuk diekspor: {}.\n"
"Pastikan faktur dalam status 'posted', belum diekspor, dan merupakan 'out_invoice'.".format(invalid_ids)
))
return invoices
def export_faktur_to_xml(self):
valid_invoices = self
coretax_faktur = self.env['coretax.faktur'].create({})
response = coretax_faktur.export_to_download(
invoices=valid_invoices,
down_payments=[inv.down_payment for inv in valid_invoices],
)
valid_invoices.write({
'is_efaktur_exported': True,
'date_efaktur_exported': datetime.utcnow(),
})
return response
class SyncPromiseDateWizard(models.TransientModel):
_name = "sync.promise.date.wizard"
_description = "Sync Janji Bayar Wizard"
invoice_id = fields.Many2one('account.move', string="Invoice Utama", required=True)
promise_date = fields.Date(string="Janji Bayar", related="invoice_id.customer_promise_date", readonly=True)
line_ids = fields.One2many('sync.promise.date.wizard.line', 'wizard_id', string="Invoices Terkait")
def action_check_all(self):
for line in self.line_ids:
line.sync_check = True
return {
'type': 'ir.actions.act_window',
'res_model': 'sync.promise.date.wizard',
'view_mode': 'form',
'res_id': self.id,
'target': 'new',
}
def action_uncheck_all(self):
for line in self.line_ids:
line.sync_check = False
return {
'type': 'ir.actions.act_window',
'res_model': 'sync.promise.date.wizard',
'view_mode': 'form',
'res_id': self.id,
'target': 'new',
}
def action_confirm(self):
self.ensure_one()
selected_lines = self.line_ids.filtered(lambda l: l.sync_check)
selected_invoices = selected_lines.mapped('invoice_id')
if not selected_invoices:
raise UserError("Tidak ada invoice dipilih untuk sinkronisasi.")
# Update hanya invoice yang dipilih
for inv in selected_invoices:
inv.write({'customer_promise_date': self.promise_date})
inv.message_post(
body=f"Janji Bayar {self.promise_date} disinkronkan dari invoice {self.invoice_id.name}."
)
# Log di invoice utama
self.invoice_id.message_post(
body=f"Janji Bayar {self.promise_date} disinkronkan ke {len(selected_invoices)} invoice lain: {', '.join(selected_invoices.mapped('name'))}."
)
return {'type': 'ir.actions.act_window_close'}
class SyncPromiseDateWizardLine(models.TransientModel):
_name = "sync.promise.date.wizard.line"
_description = "Sync Janji Bayar Wizard Line"
wizard_id = fields.Many2one('sync.promise.date.wizard', string="Wizard")
invoice_id = fields.Many2one('account.move', string="Invoice")
sync_check = fields.Boolean(string="Sync?")
invoice_name = fields.Char(related="invoice_id.name", string="Nomor Invoice", readonly=True)
invoice_date_due = fields.Date(related="invoice_id.invoice_date_due", string="Due Date", readonly=True)
invoice_day_to_due = fields.Integer(related="invoice_id.invoice_day_to_due", string="Day to Due", readonly=True)
new_invoice_day_to_due = fields.Integer(related="invoice_id.new_invoice_day_to_due", string="New Day Due", readonly=True)
date_terima_tukar_faktur = fields.Date(related="invoice_id.date_terima_tukar_faktur", string="Tanggal Terima Tukar Faktur", readonly=True)
amount_total = fields.Monetary(related="invoice_id.amount_total", string="Total", readonly=True)
currency_id = fields.Many2one(related="invoice_id.currency_id", readonly=True)