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
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from lxml.builder import E
from odoo import api, fields, models, _
from odoo.exceptions import ValidationError
from odoo.osv.expression import OR
class AnalyticPlanFields(models.AbstractModel):
""" Add one field per analytic plan to the model """
_name = 'analytic.plan.fields.mixin'
_description = 'Analytic Plan Fields'
account_id = fields.Many2one(
'account.analytic.account',
'Project Account',
ondelete='restrict',
index=True,
check_company=True,
)
# Magic column that represents all the plans at the same time, except for the compute
# where it is context dependent, and needs the id of the desired plan.
# Used as a syntactic sugar for search views, and magic field for one2many relation
auto_account_id = fields.Many2one(
comodel_name='account.analytic.account',
string='Analytic Account',
compute='_compute_auto_account',
inverse='_inverse_auto_account',
search='_search_auto_account',
)
@api.depends_context('analytic_plan_id')
def _compute_auto_account(self):
plan = self.env['account.analytic.plan'].browse(self.env.context.get('analytic_plan_id'))
for line in self:
line.auto_account_id = bool(plan) and line[plan._column_name()]
def _inverse_auto_account(self):
for line in self:
line[line.auto_account_id.plan_id._column_name()] = line.auto_account_id
def _search_auto_account(self, operator, value):
project_plan, other_plans = self.env['account.analytic.plan']._get_all_plans()
return OR([
[(plan._column_name(), operator, value)]
for plan in project_plan + other_plans
])
def _get_plan_fnames(self):
project_plan, other_plans = self.env['account.analytic.plan']._get_all_plans()
return [fname for plan in project_plan + other_plans if (fname := plan._column_name()) in self]
def _get_analytic_accounts(self):
return self.env['account.analytic.account'].browse([
self[fname].id
for fname in self._get_plan_fnames()
if self[fname]
])
def _get_analytic_distribution(self):
account_ids = self._get_analytic_accounts().ids
return {} if not account_ids else {",".join(str(account_id) for account_id in account_ids): 100}
def _get_mandatory_plans(self, company, business_domain):
return [
{
'name': plan['name'],
'column_name': plan['column_name'],
}
for plan in self.env['account.analytic.plan']
.sudo().with_company(company)
.get_relevant_plans(business_domain=business_domain, company_id=company.id)
if plan['applicability'] == 'mandatory'
]
def _get_plan_domain(self, plan):
return [('plan_id', 'child_of', plan.id)]
@api.constrains(lambda self: self._get_plan_fnames())
def _check_account_id(self):
fnames = self._get_plan_fnames()
for line in self:
if not any(line[fname] for fname in fnames):
raise ValidationError(_("At least one analytic account must be set"))
@api.model
def fields_get(self, allfields=None, attributes=None):
fields = super().fields_get(allfields, attributes)
if not self._context.get("studio") and self.env['account.analytic.plan'].has_access('read'):
project_plan, other_plans = self.env['account.analytic.plan']._get_all_plans()
for plan in project_plan + other_plans:
fname = plan._column_name()
if fname in fields:
fields[fname]['string'] = plan.name
fields[fname]['domain'] = repr(self._get_plan_domain(plan))
return fields
def _get_view(self, view_id=None, view_type='form', **options):
arch, view = super()._get_view(view_id, view_type, **options)
return self._patch_view(arch, view, view_type)
def _patch_view(self, arch, view, view_type):
if not self._context.get("studio") and self.env['account.analytic.plan'].has_access('read'):
project_plan, other_plans = self.env['account.analytic.plan']._get_all_plans()
# Find main account nodes
account_node = arch.find('.//field[@name="account_id"]')
account_filter_node = arch.find('.//filter[@name="account_id"]')
# Force domain on main account node as the fields_get doesn't do the trick
if account_node is not None and view_type == 'search':
account_node.set('domain', repr(self._get_plan_domain(project_plan)))
# If there is a main node, append the ones for other plans
if account_node is not None or account_filter_node is not None:
for plan in other_plans[::-1]:
fname = plan._column_name()
if account_node is not None:
account_node.addnext(E.field(**{
'optional': 'show',
**account_node.attrib,
'name': fname,
'domain': repr(self._get_plan_domain(plan))
}))
if account_filter_node is not None:
account_filter_node.addnext(E.filter(name=fname, context=f"{{'group_by': '{fname}'}}"))
return arch, view
class AccountAnalyticLine(models.Model):
_name = 'account.analytic.line'
_inherit = 'analytic.plan.fields.mixin'
_description = 'Analytic Line'
_order = 'date desc, id desc'
_check_company_auto = True
name = fields.Char(
'Description',
required=True,
)
date = fields.Date(
'Date',
required=True,
index=True,
default=fields.Date.context_today,
)
amount = fields.Monetary(
'Amount',
required=True,
default=0.0,
)
unit_amount = fields.Float(
'Quantity',
default=0.0,
)
product_uom_id = fields.Many2one(
'uom.uom',
string='Unit of Measure',
domain="[('category_id', '=', product_uom_category_id)]",
)
product_uom_category_id = fields.Many2one(
related='product_uom_id.category_id',
string='UoM Category',
readonly=True,
)
partner_id = fields.Many2one(
'res.partner',
string='Partner',
check_company=True,
)
user_id = fields.Many2one(
'res.users',
string='User',
default=lambda self: self.env.context.get('user_id', self.env.user.id),
index=True,
)
company_id = fields.Many2one(
'res.company',
string='Company',
required=True,
readonly=True,
default=lambda self: self.env.company,
)
currency_id = fields.Many2one(
related="company_id.currency_id",
string="Currency",
readonly=True,
store=True,
compute_sudo=True,
)
category = fields.Selection(
[('other', 'Other')],
default='other',
)
|
