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
|
# Part of Odoo. See LICENSE file for full copyright and licensing details.
import json
from odoo import fields, models, _
from odoo.osv import expression
class Project(models.Model):
_inherit = "project.project"
purchase_orders_count = fields.Integer('# Purchase Orders', compute='_compute_purchase_orders_count', groups='purchase.group_purchase_user', export_string_translation=False)
def _compute_purchase_orders_count(self):
purchase_orders_per_project = dict(
self.env['purchase.order']._read_group(
domain=[('project_id', 'in', self.ids)],
groupby=['project_id'],
aggregates=['id:array_agg'],
)
)
purchase_orders_count_per_project_from_lines = dict(
self.env['purchase.order.line']._read_group(
domain=[
('order_id', 'not in', [order_id for values in purchase_orders_per_project.values() for order_id in values]),
('analytic_distribution', 'in', self.account_id.ids),
],
groupby=['analytic_distribution'],
aggregates=['__count'],
)
)
projects_no_account = self.filtered(lambda project: not project.account_id)
for project in projects_no_account:
project.purchase_orders_count = len(purchase_orders_per_project.get(project, []))
purchase_orders_per_project = {project.account_id.id: len(orders) for project, orders in purchase_orders_per_project.items()}
for project in (self - projects_no_account):
project.purchase_orders_count = purchase_orders_per_project.get(project.account_id.id, 0) + purchase_orders_count_per_project_from_lines.get(project.account_id.id, 0)
# ----------------------------
# Actions
# ----------------------------
def action_open_project_purchase_orders(self):
purchase_orders = self.env['purchase.order.line'].search([
'|',
('analytic_distribution', 'in', self.account_id.ids),
('order_id.project_id', '=', self.id),
]).order_id
action_window = {
'name': self.env._('Purchase Orders'),
'type': 'ir.actions.act_window',
'res_model': 'purchase.order',
'views': [[False, 'list'], [False, 'form']],
'domain': [('id', 'in', purchase_orders.ids)],
'context': {
'default_project_id': self.id,
},
'help': "<p class='o_view_nocontent_smiling_face'>%s</p><p>%s</p>" % (
_("No purchase order found. Let's create one."),
_("Once you ordered your products from your supplier, confirm your request for quotation and it will turn "
"into a purchase order."),
),
}
if len(purchase_orders) == 1 and not self.env.context.get('from_embedded_action'):
action_window['views'] = [[False, 'form']]
action_window['res_id'] = purchase_orders.id
return action_window
def action_profitability_items(self, section_name, domain=None, res_id=False):
if section_name == 'purchase_order':
action = {
'name': self.env._('Purchase Order Items'),
'type': 'ir.actions.act_window',
'res_model': 'purchase.order.line',
'views': [[False, 'list'], [False, 'form']],
'domain': domain,
'context': {
'create': False,
'edit': False,
},
}
if res_id:
action['res_id'] = res_id
if 'views' in action:
action['views'] = [
(view_id, view_type)
for view_id, view_type in action['views']
if view_type == 'form'
] or [False, 'form']
action['view_mode'] = 'form'
return action
return super().action_profitability_items(section_name, domain, res_id)
# ----------------------------
# Project Updates
# ----------------------------
def _get_stat_buttons(self):
buttons = super(Project, self)._get_stat_buttons()
if self.env.user.has_group('purchase.group_purchase_user'):
self_sudo = self.sudo()
buttons.append({
'icon': 'credit-card',
'text': self.env._('Purchase Orders'),
'number': self_sudo.purchase_orders_count,
'action_type': 'object',
'action': 'action_open_project_purchase_orders',
'show': self_sudo.purchase_orders_count > 0,
'sequence': 36,
})
return buttons
def _get_profitability_aal_domain(self):
return expression.AND([
super()._get_profitability_aal_domain(),
['|', ('move_line_id', '=', False), ('move_line_id.purchase_line_id', '=', False)],
])
def _add_purchase_items(self, profitability_items, with_action=True):
return False
def _get_profitability_labels(self):
labels = super()._get_profitability_labels()
labels['purchase_order'] = self.env._('Purchase Orders')
return labels
def _get_profitability_sequence_per_invoice_type(self):
sequence_per_invoice_type = super()._get_profitability_sequence_per_invoice_type()
sequence_per_invoice_type['purchase_order'] = 10
return sequence_per_invoice_type
def _get_profitability_items(self, with_action=True):
profitability_items = super()._get_profitability_items(with_action)
if self.account_id:
invoice_lines = self.env['account.move.line'].sudo().search_fetch([
('parent_state', 'in', ['draft', 'posted']),
('analytic_distribution', 'in', self.account_id.ids),
('purchase_line_id', '!=', False),
], ['parent_state', 'currency_id', 'price_subtotal', 'analytic_distribution'])
purchase_order_line_invoice_line_ids = self._get_already_included_profitability_invoice_line_ids()
with_action = with_action and (
self.env.user.has_group('purchase.group_purchase_user')
or self.env.user.has_group('account.group_account_invoice')
or self.env.user.has_group('account.group_account_readonly')
)
if invoice_lines:
amount_invoiced = amount_to_invoice = 0.0
purchase_order_line_invoice_line_ids.extend(invoice_lines.ids)
for line in invoice_lines:
price_subtotal = line.currency_id._convert(line.price_subtotal, self.currency_id, self.company_id)
# an analytic account can appear several time in an analytic distribution with different repartition percentage
analytic_contribution = sum(
percentage for ids, percentage in line.analytic_distribution.items()
if str(self.account_id.id) in ids.split(',')
) / 100.
cost = price_subtotal * analytic_contribution * (-1 if line.is_refund else 1)
if line.parent_state == 'posted':
amount_invoiced -= cost
else:
amount_to_invoice -= cost
costs = profitability_items['costs']
section_id = 'purchase_order'
purchase_order_costs = {'id': section_id, 'sequence': self._get_profitability_sequence_per_invoice_type()[section_id], 'billed': amount_invoiced, 'to_bill': amount_to_invoice}
if with_action:
args = [section_id, [('id', 'in', invoice_lines.purchase_line_id.ids)]]
if len(invoice_lines.purchase_line_id) == 1:
args.append(invoice_lines.purchase_line_id.id)
action = {'name': 'action_profitability_items', 'type': 'object', 'args': json.dumps(args)}
purchase_order_costs['action'] = action
costs['data'].append(purchase_order_costs)
costs['total']['billed'] += amount_invoiced
costs['total']['to_bill'] += amount_to_invoice
domain = [
('move_id.move_type', 'in', ['in_invoice', 'in_refund']),
('parent_state', 'in', ['draft', 'posted']),
('price_subtotal', '>', 0),
('id', 'not in', purchase_order_line_invoice_line_ids),
]
self._get_costs_items_from_purchase(domain, profitability_items, with_action=with_action)
return profitability_items
|
