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
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from datetime import datetime
from odoo import api, fields, models
class MailTracking(models.Model):
_name = 'mail.tracking.value'
_description = 'Mail Tracking Value'
_rec_name = 'field_id'
_order = 'id DESC'
field_id = fields.Many2one(
'ir.model.fields', required=False, readonly=True,
index=True, ondelete='set null')
field_info = fields.Json('Removed field information')
old_value_integer = fields.Integer('Old Value Integer', readonly=True)
old_value_float = fields.Float('Old Value Float', readonly=True)
old_value_char = fields.Char('Old Value Char', readonly=True)
old_value_text = fields.Text('Old Value Text', readonly=True)
old_value_datetime = fields.Datetime('Old Value DateTime', readonly=True)
new_value_integer = fields.Integer('New Value Integer', readonly=True)
new_value_float = fields.Float('New Value Float', readonly=True)
new_value_char = fields.Char('New Value Char', readonly=True)
new_value_text = fields.Text('New Value Text', readonly=True)
new_value_datetime = fields.Datetime('New Value Datetime', readonly=True)
currency_id = fields.Many2one('res.currency', 'Currency', readonly=True, ondelete='set null',
help="Used to display the currency when tracking monetary values")
mail_message_id = fields.Many2one('mail.message', 'Message ID', required=True, index=True, ondelete='cascade')
def _filter_has_field_access(self, env):
""" Return the subset of self for which the user in env has access. As
this model is admin-only, it is generally accessed as sudo and we need
to distinguish context environment from tracking values environment.
If tracking is linked to a field, user should have access to the field.
Otherwise only members of "base.group_system" can access it. """
def has_field_access(tracking):
if not tracking.field_id:
return env.is_system()
model_field = env[tracking.field_id.model]._fields.get(tracking.field_id.name)
return model_field.is_accessible(env) if model_field else False
return self.filtered(has_field_access)
def _filter_free_field_access(self):
""" Return the subset of self which is available for all users: trackings
linked to an existing field without access group. It is used notably
when sending tracking summary through notifications. """
def has_free_access(tracking):
if not tracking.field_id:
return False
model_field = self.env[tracking.field_id.model]._fields.get(tracking.field_id.name)
return model_field and not model_field.groups
return self.filtered(has_free_access)
@api.model
def _create_tracking_values(self, initial_value, new_value, col_name, col_info, record):
""" Prepare values to create a mail.tracking.value. It prepares old and
new value according to the field type.
:param initial_value: field value before the change, could be text, int,
date, datetime, ...;
:param new_value: field value after the change, could be text, int,
date, datetime, ...;
:param str col_name: technical field name, column name (e.g. 'user_id);
:param dict col_info: result of fields_get(col_name);
:param <record> record: record on which tracking is performed, used for
related computation e.g. finding currency of monetary fields;
:return: a dict values valid for 'mail.tracking.value' creation;
"""
field = self.env['ir.model.fields']._get(record._name, col_name)
if not field:
raise ValueError(f'Unknown field {col_name} on model {record._name}')
values = {'field_id': field.id}
if col_info['type'] in {'integer', 'float', 'char', 'text', 'datetime'}:
values.update({
f'old_value_{col_info["type"]}': initial_value,
f'new_value_{col_info["type"]}': new_value
})
elif col_info['type'] == 'monetary':
values.update({
'currency_id': record[col_info['currency_field']].id,
'old_value_float': initial_value,
'new_value_float': new_value
})
elif col_info['type'] == 'date':
values.update({
'old_value_datetime': initial_value and fields.Datetime.to_string(datetime.combine(fields.Date.from_string(initial_value), datetime.min.time())) or False,
'new_value_datetime': new_value and fields.Datetime.to_string(datetime.combine(fields.Date.from_string(new_value), datetime.min.time())) or False,
})
elif col_info['type'] == 'boolean':
values.update({
'old_value_integer': initial_value,
'new_value_integer': new_value
})
elif col_info['type'] == 'selection':
values.update({
'old_value_char': initial_value and dict(col_info['selection']).get(initial_value, initial_value) or '',
'new_value_char': new_value and dict(col_info['selection'])[new_value] or ''
})
elif col_info['type'] == 'many2one':
values.update({
'old_value_integer': initial_value.id if initial_value else 0,
'new_value_integer': new_value.id if new_value else 0,
'old_value_char': initial_value.display_name if initial_value else '',
'new_value_char': new_value.display_name if new_value else ''
})
elif col_info['type'] in {'one2many', 'many2many'}:
values.update({
'old_value_char': ', '.join(initial_value.mapped('display_name')) if initial_value else '',
'new_value_char': ', '.join(new_value.mapped('display_name')) if new_value else '',
})
else:
raise NotImplementedError(f'Unsupported tracking on field {field.name} (type {col_info["type"]}')
return values
def _tracking_value_format(self):
""" Return structure and formatted data structure to be used by chatter
to display tracking values. Order it according to asked display, aka
ascending sequence (and field name).
:return list: for each tracking value in self, their formatted display
values given as a dict;
"""
model_map = {}
for tracking in self:
model = tracking.field_id.model or tracking.mail_message_id.model
model_map.setdefault(model, self.browse())
model_map[model] += tracking
formatted = []
for model, trackings in model_map.items():
formatted += trackings._tracking_value_format_model(model)
return formatted
def _tracking_value_format_model(self, model):
""" Return structure and formatted data structure to be used by chatter
to display tracking values. Order it according to asked display, aka
ascending sequence (and field name).
:return list: for each tracking value in self, their formatted display
values given as a dict;
"""
if not self:
return []
# fetch model-based information
if model:
TrackedModel = self.env[model]
tracked_fields = TrackedModel.fields_get(self.field_id.mapped('name'), attributes={'string', 'type'})
model_sequence_info = dict(TrackedModel._mail_track_order_fields(tracked_fields)) if model else {}
else:
tracked_fields, model_sequence_info = {}, {}
# generate sequence of trackings
fields_sequence_map = dict(
{
tracking.field_info['name']: tracking.field_info.get('sequence', 100)
for tracking in self.filtered('field_info')
},
**model_sequence_info,
)
# generate dict of field information, if available
fields_col_info = (
tracked_fields.get(tracking.field_id.name) or {
'string': tracking.field_info['desc'] if tracking.field_info else self.env._('Unknown'),
'type': tracking.field_info['type'] if tracking.field_info else 'char',
} for tracking in self
)
formatted = [
{
'changedField': col_info['string'],
'id': tracking.id,
'fieldName': tracking.field_id.name or (tracking.field_info['name'] if tracking.field_info else 'unknown'),
'fieldType': col_info['type'],
'newValue': {
'currencyId': tracking.currency_id.id,
'value': tracking._format_display_value(col_info['type'], new=True)[0],
},
'oldValue': {
'currencyId': tracking.currency_id.id,
'value': tracking._format_display_value(col_info['type'], new=False)[0],
},
}
for tracking, col_info in zip(self, fields_col_info)
]
formatted.sort(
key=lambda info: (fields_sequence_map.get(info['fieldName'], 100), info['fieldName']),
reverse=False,
)
return formatted
def _format_display_value(self, field_type, new=True):
""" Format value of 'mail.tracking.value', according to the field type.
:param str field_type: Odoo field type;
:param bool new: if True, display the 'new' value. Otherwise display
the 'old' one.
"""
field_mapping = {
'boolean': ('old_value_integer', 'new_value_integer'),
'date': ('old_value_datetime', 'new_value_datetime'),
'datetime': ('old_value_datetime', 'new_value_datetime'),
'char': ('old_value_char', 'new_value_char'),
'float': ('old_value_float', 'new_value_float'),
'integer': ('old_value_integer', 'new_value_integer'),
'monetary': ('old_value_float', 'new_value_float'),
'text': ('old_value_text', 'new_value_text'),
}
result = []
for record in self:
value_fname = field_mapping.get(
field_type, ('old_value_char', 'new_value_char')
)[bool(new)]
value = record[value_fname]
if field_type in {'integer', 'float', 'char', 'text', 'monetary'}:
result.append(value)
elif field_type in {'date', 'datetime'}:
if not record[value_fname]:
result.append(value)
elif field_type == 'date':
result.append(fields.Date.to_string(value))
else:
result.append(f'{value}Z')
elif field_type == 'boolean':
result.append(bool(value))
else:
result.append(value)
return result
|
