# © 2016 Julien Coux (Camptocamp) # Copyright 2020 ForgeFlow S.L. (https://www.forgeflow.com) # License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl.html). import operator from datetime import date, datetime from flectra import api, models from flectra.tools import float_is_zero class OpenItemsReport(models.AbstractModel): _name = "report.account_financial_report.open_items" _description = "Open Items Report" _inherit = "report.account_financial_report.abstract_report" def _get_account_partial_reconciled(self, company_id, date_at_object): domain = [("max_date", ">", date_at_object), ("company_id", "=", company_id)] fields = [ "debit_move_id", "credit_move_id", "amount", "debit_amount_currency", "credit_amount_currency", ] accounts_partial_reconcile = self.env["account.partial.reconcile"].search_read( domain=domain, fields=fields ) debit_amount = {} debit_amount_currency = {} credit_amount = {} credit_amount_currency = {} for account_partial_reconcile_data in accounts_partial_reconcile: debit_move_id = account_partial_reconcile_data["debit_move_id"][0] credit_move_id = account_partial_reconcile_data["credit_move_id"][0] if debit_move_id not in debit_amount.keys(): debit_amount[debit_move_id] = 0.0 debit_amount_currency[debit_move_id] = 0.0 debit_amount[debit_move_id] += account_partial_reconcile_data["amount"] debit_amount_currency[debit_move_id] += account_partial_reconcile_data[ "debit_amount_currency" ] if credit_move_id not in credit_amount.keys(): credit_amount[credit_move_id] = 0.0 credit_amount_currency[credit_move_id] = 0.0 credit_amount[credit_move_id] += account_partial_reconcile_data["amount"] credit_amount_currency[credit_move_id] += account_partial_reconcile_data[ "credit_amount_currency" ] account_partial_reconcile_data.update( {"debit_move_id": debit_move_id, "credit_move_id": credit_move_id} ) return ( accounts_partial_reconcile, debit_amount, credit_amount, debit_amount_currency, credit_amount_currency, ) def _get_data( self, account_ids, partner_ids, date_at_object, only_posted_moves, company_id, date_from, ): domain = self._get_move_lines_domain_not_reconciled( company_id, account_ids, partner_ids, only_posted_moves, date_from ) ml_fields = self._get_ml_fields() move_lines = self.env["account.move.line"].search_read( domain=domain, fields=ml_fields ) journals_ids = set() partners_ids = set() partners_data = {} if date_at_object < date.today(): ( acc_partial_rec, debit_amount, credit_amount, debit_amount_currency, credit_amount_currency, ) = self._get_account_partial_reconciled(company_id, date_at_object) if acc_partial_rec: ml_ids = list(map(operator.itemgetter("id"), move_lines)) debit_ids = list( map(operator.itemgetter("debit_move_id"), acc_partial_rec) ) credit_ids = list( map(operator.itemgetter("credit_move_id"), acc_partial_rec) ) move_lines = self._recalculate_move_lines( move_lines, debit_ids, credit_ids, debit_amount, credit_amount, ml_ids, account_ids, company_id, partner_ids, only_posted_moves, debit_amount_currency, credit_amount_currency, ) move_lines = [ move_line for move_line in move_lines if move_line["date"] <= date_at_object and not float_is_zero(move_line["amount_residual"], precision_digits=2) ] open_items_move_lines_data = {} for move_line in move_lines: journals_ids.add(move_line["journal_id"][0]) acc_id = move_line["account_id"][0] # Partners data if move_line["partner_id"]: prt_id = move_line["partner_id"][0] prt_name = move_line["partner_id"][1] else: prt_id = 0 prt_name = "Missing Partner" if prt_id not in partners_ids: partners_data.update({prt_id: {"id": prt_id, "name": prt_name}}) partners_ids.add(prt_id) # Move line update original = 0 if not float_is_zero(move_line["credit"], precision_digits=2): original = move_line["credit"] * (-1) if not float_is_zero(move_line["debit"], precision_digits=2): original = move_line["debit"] if move_line["ref"] == move_line["name"]: if move_line["ref"]: ref_label = move_line["ref"] else: ref_label = "" elif not move_line["ref"]: ref_label = move_line["name"] elif not move_line["name"]: ref_label = move_line["ref"] else: ref_label = move_line["ref"] + str(" - ") + move_line["name"] move_line.update( { "date": move_line["date"], "date_maturity": move_line["date_maturity"] and move_line["date_maturity"].strftime("%d/%m/%Y"), "original": original, "partner_id": prt_id, "partner_name": prt_name, "ref_label": ref_label, "journal_id": move_line["journal_id"][0], "move_name": move_line["move_id"][1], "entry_id": move_line["move_id"][0], "currency_id": move_line["currency_id"][0] if move_line["currency_id"] else False, "currency_name": move_line["currency_id"][1] if move_line["currency_id"] else False, } ) # Open Items Move Lines Data if acc_id not in open_items_move_lines_data.keys(): open_items_move_lines_data[acc_id] = {prt_id: [move_line]} else: if prt_id not in open_items_move_lines_data[acc_id].keys(): open_items_move_lines_data[acc_id][prt_id] = [move_line] else: open_items_move_lines_data[acc_id][prt_id].append(move_line) journals_data = self._get_journals_data(list(journals_ids)) accounts_data = self._get_accounts_data(open_items_move_lines_data.keys()) return ( move_lines, partners_data, journals_data, accounts_data, open_items_move_lines_data, ) @api.model def _calculate_amounts(self, open_items_move_lines_data): total_amount = {} for account_id in open_items_move_lines_data.keys(): total_amount[account_id] = {} total_amount[account_id]["residual"] = 0.0 for partner_id in open_items_move_lines_data[account_id].keys(): total_amount[account_id][partner_id] = {} total_amount[account_id][partner_id]["residual"] = 0.0 for move_line in open_items_move_lines_data[account_id][partner_id]: total_amount[account_id][partner_id]["residual"] += move_line[ "amount_residual" ] total_amount[account_id]["residual"] += move_line["amount_residual"] return total_amount @api.model def _order_open_items_by_date( self, open_items_move_lines_data, show_partner_details, partners_data ): new_open_items = {} if not show_partner_details: for acc_id in open_items_move_lines_data.keys(): new_open_items[acc_id] = {} move_lines = [] for prt_id in open_items_move_lines_data[acc_id]: for move_line in open_items_move_lines_data[acc_id][prt_id]: move_lines += [move_line] move_lines = sorted(move_lines, key=lambda k: (k["date"])) new_open_items[acc_id] = move_lines else: for acc_id in open_items_move_lines_data.keys(): new_open_items[acc_id] = {} for prt_id in sorted( open_items_move_lines_data[acc_id], key=lambda i: partners_data[i]["name"], ): new_open_items[acc_id][prt_id] = {} move_lines = [] for move_line in open_items_move_lines_data[acc_id][prt_id]: move_lines += [move_line] move_lines = sorted(move_lines, key=lambda k: (k["date"])) new_open_items[acc_id][prt_id] = move_lines return new_open_items def _get_report_values(self, docids, data): wizard_id = data["wizard_id"] company = self.env["res.company"].browse(data["company_id"]) company_id = data["company_id"] account_ids = data["account_ids"] partner_ids = data["partner_ids"] date_at = data["date_at"] date_at_object = datetime.strptime(date_at, "%Y-%m-%d").date() date_from = data["date_from"] only_posted_moves = data["only_posted_moves"] show_partner_details = data["show_partner_details"] ( move_lines_data, partners_data, journals_data, accounts_data, open_items_move_lines_data, ) = self._get_data( account_ids, partner_ids, date_at_object, only_posted_moves, company_id, date_from, ) total_amount = self._calculate_amounts(open_items_move_lines_data) open_items_move_lines_data = self._order_open_items_by_date( open_items_move_lines_data, show_partner_details, partners_data ) return { "doc_ids": [wizard_id], "doc_model": "open.items.report.wizard", "docs": self.env["open.items.report.wizard"].browse(wizard_id), "foreign_currency": data["foreign_currency"], "show_partner_details": data["show_partner_details"], "company_name": company.display_name, "currency_name": company.currency_id.name, "date_at": date_at_object.strftime("%d/%m/%Y"), "hide_account_at_0": data["hide_account_at_0"], "target_move": data["target_move"], "journals_data": journals_data, "partners_data": partners_data, "accounts_data": accounts_data, "total_amount": total_amount, "Open_Items": open_items_move_lines_data, } def _get_ml_fields(self): return self.COMMON_ML_FIELDS + [ "amount_residual", "reconciled", "currency_id", "credit", "date_maturity", "amount_residual_currency", "debit", "amount_currency", ]