1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from datetime import date
import calendar
from dateutil.relativedelta import relativedelta
from odoo import models, api, _
from odoo.osv import expression
from odoo.tools import date_utils
class AccountMove(models.Model):
_inherit = "account.account"
@api.model
def _get_date_period_boundaries(self, date_period, company):
period_type = date_period["range_type"]
year = date_period.get("year")
month = date_period.get("month")
quarter = date_period.get("quarter")
day = date_period.get("day")
if period_type == "year":
fiscal_day = company.fiscalyear_last_day
fiscal_month = int(company.fiscalyear_last_month)
if not (fiscal_day == 31 and fiscal_month == 12):
year += 1
max_day = calendar.monthrange(year, fiscal_month)[1]
current = date(year, fiscal_month, min(fiscal_day, max_day))
start, end = date_utils.get_fiscal_year(current, fiscal_day, fiscal_month)
elif period_type == "month":
start = date(year, month, 1)
end = start + relativedelta(months=1, days=-1)
elif period_type == "quarter":
first_month = quarter * 3 - 2
start = date(year, first_month, 1)
end = start + relativedelta(months=3, days=-1)
elif period_type == "day":
fiscal_day = company.fiscalyear_last_day
fiscal_month = int(company.fiscalyear_last_month)
end = date(year, month, day)
start, _ = date_utils.get_fiscal_year(end, fiscal_day, fiscal_month)
return start, end
def _build_spreadsheet_formula_domain(self, formula_params):
codes = [code for code in formula_params["codes"] if code]
if not codes:
return expression.FALSE_DOMAIN
company_id = formula_params["company_id"] or self.env.company.id
company = self.env["res.company"].browse(company_id)
start, end = self._get_date_period_boundaries(
formula_params["date_range"], company
)
balance_domain = [
("account_id.include_initial_balance", "=", True),
("date", "<=", end),
]
pnl_domain = [
("account_id.include_initial_balance", "=", False),
("date", ">=", start),
("date", "<=", end),
]
# It is more optimized to (like) search for code directly in account.account than in account_move_line
code_domain = expression.OR(
[
("code", "=like", f"{code}%"),
]
for code in codes
)
account_ids = self.env["account.account"].with_company(company_id).search(code_domain).ids
code_domain = [("account_id", "in", account_ids)]
period_domain = expression.OR([balance_domain, pnl_domain])
domain = expression.AND([code_domain, period_domain, [("company_id", "=", company_id)]])
if formula_params["include_unposted"]:
domain = expression.AND(
[domain, [("move_id.state", "!=", "cancel")]]
)
else:
domain = expression.AND(
[domain, [("move_id.state", "=", "posted")]]
)
return domain
@api.model
def spreadsheet_move_line_action(self, args):
domain = self._build_spreadsheet_formula_domain(args)
return {
"type": "ir.actions.act_window",
"res_model": "account.move.line",
"view_mode": "list",
"views": [[False, "list"]],
"target": "current",
"domain": domain,
"name": _("Journal items for account prefix %s", ", ".join(args["codes"])),
}
@api.model
def spreadsheet_fetch_debit_credit(self, args_list):
"""Fetch data for ODOO.CREDIT, ODOO.DEBIT and ODOO.BALANCE formulas
The input list looks like this:
[{
date_range: {
range_type: "year"
year: int
},
company_id: int
codes: str[]
include_unposted: bool
}]
"""
results = []
for args in args_list:
company_id = args["company_id"] or self.env.company.id
domain = self._build_spreadsheet_formula_domain(args)
MoveLines = self.env["account.move.line"].with_company(company_id)
[(debit, credit)] = MoveLines._read_group(domain, aggregates=['debit:sum', 'credit:sum'])
results.append({'debit': debit or 0, 'credit': credit or 0})
return results
@api.model
def get_account_group(self, account_types):
data = self._read_group(
[
*self._check_company_domain(self.env.company),
("account_type", "in", account_types),
],
['account_type'],
['code:array_agg'],
)
mapped = dict(data)
return [mapped.get(account_type, []) for account_type in account_types]
|
