778 lines
37 KiB
Python
Executable File
778 lines
37 KiB
Python
Executable File
# -*- coding: utf-8 -*-
|
|
# Part of Odoo. See LICENSE file for full copyright and licensing details.
|
|
|
|
import json
|
|
|
|
from odoo import api, fields, models, _, _lt
|
|
from odoo.exceptions import ValidationError, AccessError
|
|
from odoo.osv import expression
|
|
from odoo.tools import Query
|
|
from odoo.tools.misc import unquote
|
|
|
|
from datetime import date
|
|
from functools import reduce
|
|
|
|
class Project(models.Model):
|
|
_inherit = 'project.project'
|
|
|
|
def _domain_sale_line_id(self):
|
|
domain = expression.AND([
|
|
self.env['sale.order.line']._sellable_lines_domain(),
|
|
[
|
|
('is_service', '=', True),
|
|
('is_expense', '=', False),
|
|
('state', 'in', ['sale', 'done']),
|
|
('order_partner_id', '=?', unquote("partner_id")),
|
|
'|', ('company_id', '=', False), ('company_id', '=', unquote("company_id")),
|
|
],
|
|
])
|
|
return domain
|
|
|
|
allow_billable = fields.Boolean("Billable")
|
|
sale_line_id = fields.Many2one(
|
|
'sale.order.line', 'Sales Order Item', copy=False,
|
|
compute="_compute_sale_line_id", store=True, readonly=False, index='btree_not_null',
|
|
domain=lambda self: str(self._domain_sale_line_id()),
|
|
help="Sales order item that will be selected by default on the tasks and timesheets of this project,"
|
|
" except if the employee set on the timesheets is explicitely linked to another sales order item on the project.\n"
|
|
"It can be modified on each task and timesheet entry individually if necessary.")
|
|
sale_order_id = fields.Many2one(string='Sales Order', related='sale_line_id.order_id', help="Sales order to which the project is linked.")
|
|
has_any_so_to_invoice = fields.Boolean('Has SO to Invoice', compute='_compute_has_any_so_to_invoice')
|
|
sale_order_count = fields.Integer(compute='_compute_sale_order_count', groups='sales_team.group_sale_salesman')
|
|
has_any_so_with_nothing_to_invoice = fields.Boolean('Has a SO with an invoice status of No', compute='_compute_has_any_so_with_nothing_to_invoice')
|
|
invoice_count = fields.Integer(compute='_compute_invoice_count', groups='account.group_account_readonly')
|
|
vendor_bill_count = fields.Integer(related='analytic_account_id.vendor_bill_count', groups='account.group_account_readonly')
|
|
|
|
@api.model
|
|
def _map_tasks_default_valeus(self, task, project):
|
|
defaults = super()._map_tasks_default_valeus(task, project)
|
|
defaults['sale_line_id'] = False
|
|
return defaults
|
|
|
|
@api.depends('partner_id')
|
|
def _compute_sale_line_id(self):
|
|
self.filtered(
|
|
lambda p:
|
|
p.sale_line_id and (
|
|
not p.partner_id or p.sale_line_id.order_partner_id.commercial_partner_id != p.partner_id.commercial_partner_id
|
|
)
|
|
).update({'sale_line_id': False})
|
|
|
|
def _get_projects_for_invoice_status(self, invoice_status):
|
|
""" Returns a recordset of project.project that has any Sale Order which invoice_status is the same as the
|
|
provided invoice_status.
|
|
|
|
:param invoice_status: The invoice status.
|
|
"""
|
|
self.env.cr.execute("""
|
|
SELECT id
|
|
FROM project_project pp
|
|
WHERE pp.active = true
|
|
AND ( EXISTS(SELECT 1
|
|
FROM sale_order so
|
|
JOIN project_task pt ON pt.sale_order_id = so.id
|
|
WHERE pt.project_id = pp.id
|
|
AND pt.active = true
|
|
AND so.invoice_status = %(invoice_status)s)
|
|
OR EXISTS(SELECT 1
|
|
FROM sale_order so
|
|
JOIN sale_order_line sol ON sol.order_id = so.id
|
|
WHERE sol.id = pp.sale_line_id
|
|
AND so.invoice_status = %(invoice_status)s))
|
|
AND id in %(ids)s""", {'ids': tuple(self.ids), 'invoice_status': invoice_status})
|
|
return self.env['project.project'].browse([x[0] for x in self.env.cr.fetchall()])
|
|
|
|
@api.depends('sale_order_id.invoice_status', 'tasks.sale_order_id.invoice_status')
|
|
def _compute_has_any_so_to_invoice(self):
|
|
"""Has any Sale Order whose invoice_status is set as To Invoice"""
|
|
if not self.ids:
|
|
self.has_any_so_to_invoice = False
|
|
return
|
|
|
|
project_to_invoice = self._get_projects_for_invoice_status('to invoice')
|
|
project_to_invoice.has_any_so_to_invoice = True
|
|
(self - project_to_invoice).has_any_so_to_invoice = False
|
|
|
|
@api.depends('sale_order_id', 'task_ids.sale_order_id')
|
|
def _compute_sale_order_count(self):
|
|
sale_order_items_per_project_id = self._fetch_sale_order_items_per_project_id({'project.task': [('is_closed', '=', False)]})
|
|
for project in self:
|
|
project.sale_order_count = len(sale_order_items_per_project_id.get(project.id, self.env['sale.order.line']).order_id)
|
|
|
|
def _compute_invoice_count(self):
|
|
query = self.env['account.move.line']._search([('move_id.move_type', 'in', ['out_invoice', 'out_refund'])])
|
|
query.add_where('analytic_distribution ?| %s', [[str(project.analytic_account_id.id) for project in self]])
|
|
query.order = None
|
|
query_string, query_param = query.select(
|
|
'jsonb_object_keys(account_move_line.analytic_distribution) as account_id',
|
|
'COUNT(DISTINCT move_id) as move_count',
|
|
)
|
|
query_string = f"{query_string} GROUP BY jsonb_object_keys(account_move_line.analytic_distribution)"
|
|
self._cr.execute(query_string, query_param)
|
|
data = {int(row.get('account_id')): row.get('move_count') for row in self._cr.dictfetchall()}
|
|
for project in self:
|
|
project.invoice_count = data.get(project.analytic_account_id.id, 0)
|
|
|
|
|
|
def action_view_sos(self):
|
|
self.ensure_one()
|
|
all_sale_orders = self._fetch_sale_order_items({'project.task': [('is_closed', '=', False)]}).order_id
|
|
action_window = {
|
|
"type": "ir.actions.act_window",
|
|
"res_model": "sale.order",
|
|
'name': _("%(name)s's Sales Order", name=self.name),
|
|
"context": {"create": False, "show_sale": True},
|
|
}
|
|
if len(all_sale_orders) == 1:
|
|
action_window.update({
|
|
"res_id": all_sale_orders.id,
|
|
"views": [[False, "form"]],
|
|
})
|
|
else:
|
|
action_window.update({
|
|
"domain": [('id', 'in', all_sale_orders.ids)],
|
|
"views": [[False, "tree"], [False, "kanban"], [False, "calendar"], [False, "pivot"],
|
|
[False, "graph"], [False, "activity"], [False, "form"]],
|
|
})
|
|
return action_window
|
|
|
|
def action_get_list_view(self):
|
|
action = super().action_get_list_view()
|
|
if self.allow_billable:
|
|
action['views'] = [(self.env.ref('sale_project.project_milestone_view_tree').id, 'tree'), (False, 'form')]
|
|
return action
|
|
|
|
def action_profitability_items(self, section_name, domain=None, res_id=False):
|
|
if section_name in ['service_revenues', 'other_revenues']:
|
|
view_types = ['list', 'kanban', 'form']
|
|
action = {
|
|
'name': _('Sales Order Items'),
|
|
'type': 'ir.actions.act_window',
|
|
'res_model': 'sale.order.line',
|
|
'context': {'create': False, 'edit': False},
|
|
}
|
|
if res_id:
|
|
action['res_id'] = res_id
|
|
view_types = ['form']
|
|
else:
|
|
action['domain'] = domain
|
|
action['views'] = [(False, v) for v in view_types]
|
|
return action
|
|
return super().action_profitability_items(section_name, domain, res_id)
|
|
|
|
@api.depends('sale_order_id.invoice_status', 'tasks.sale_order_id.invoice_status')
|
|
def _compute_has_any_so_with_nothing_to_invoice(self):
|
|
"""Has any Sale Order whose invoice_status is set as No"""
|
|
if not self.ids:
|
|
self.has_any_so_with_nothing_to_invoice = False
|
|
return
|
|
|
|
project_nothing_to_invoice = self._get_projects_for_invoice_status('no')
|
|
project_nothing_to_invoice.has_any_so_with_nothing_to_invoice = True
|
|
(self - project_nothing_to_invoice).has_any_so_with_nothing_to_invoice = False
|
|
|
|
def action_create_invoice(self):
|
|
action = self.env["ir.actions.actions"]._for_xml_id("sale.action_view_sale_advance_payment_inv")
|
|
so_ids = (self.sale_order_id | self.task_ids.sale_order_id).filtered(lambda so: so.invoice_status in ['to invoice', 'no']).ids
|
|
action['context'] = {
|
|
'active_id': so_ids[0] if len(so_ids) == 1 else False,
|
|
'active_ids': so_ids
|
|
}
|
|
if not self.has_any_so_to_invoice:
|
|
action['context']['default_advance_payment_method'] = 'percentage'
|
|
return action
|
|
|
|
def action_open_project_invoices(self):
|
|
query = self.env['account.move.line']._search([('move_id.move_type', 'in', ['out_invoice', 'out_refund'])])
|
|
query.add_where('analytic_distribution ? %s', [str(self.analytic_account_id.id)])
|
|
query.order = None
|
|
query_string, query_param = query.select('DISTINCT move_id')
|
|
self._cr.execute(query_string, query_param)
|
|
invoice_ids = [line.get('move_id') for line in self._cr.dictfetchall()]
|
|
action = {
|
|
'name': _('Invoices'),
|
|
'type': 'ir.actions.act_window',
|
|
'res_model': 'account.move',
|
|
'views': [[False, 'tree'], [False, 'form'], [False, 'kanban']],
|
|
'domain': [('id', 'in', invoice_ids)],
|
|
'context': {
|
|
'create': False,
|
|
}
|
|
}
|
|
if len(invoice_ids) == 1:
|
|
action['views'] = [[False, 'form']]
|
|
action['res_id'] = invoice_ids[0]
|
|
return action
|
|
|
|
# ----------------------------
|
|
# Project Updates
|
|
# ----------------------------
|
|
|
|
def _fetch_sale_order_items_per_project_id(self, domain_per_model=None):
|
|
if not self:
|
|
return {}
|
|
if len(self) == 1:
|
|
return {self.id: self._fetch_sale_order_items(domain_per_model)}
|
|
query_str, params = self._get_sale_order_items_query(domain_per_model).select('id', 'ARRAY_AGG(DISTINCT sale_line_id) AS sale_line_ids')
|
|
query = f"""
|
|
{query_str}
|
|
GROUP BY id
|
|
"""
|
|
self._cr.execute(query, params)
|
|
return {row['id']: self.env['sale.order.line'].browse(row['sale_line_ids']) for row in self._cr.dictfetchall()}
|
|
|
|
def _fetch_sale_order_items(self, domain_per_model=None, limit=None, offset=None):
|
|
return self.env['sale.order.line'].browse(self._fetch_sale_order_item_ids(domain_per_model, limit, offset))
|
|
|
|
def _fetch_sale_order_item_ids(self, domain_per_model=None, limit=None, offset=None):
|
|
if not self or not self.filtered('allow_billable'):
|
|
return []
|
|
query = self._get_sale_order_items_query(domain_per_model)
|
|
query.limit = limit
|
|
query.offset = offset
|
|
query_str, params = query.select('DISTINCT sale_line_id')
|
|
self._cr.execute(query_str, params)
|
|
return [row[0] for row in self._cr.fetchall()]
|
|
|
|
def _get_sale_orders(self):
|
|
return self._get_sale_order_items().order_id
|
|
|
|
def _get_sale_order_items(self):
|
|
return self._fetch_sale_order_items()
|
|
|
|
def _get_sale_order_items_query(self, domain_per_model=None):
|
|
if domain_per_model is None:
|
|
domain_per_model = {}
|
|
billable_project_domain = [('allow_billable', '=', True)]
|
|
project_domain = [('id', 'in', self.ids), ('sale_line_id', '!=', False)]
|
|
if 'project.project' in domain_per_model:
|
|
project_domain = expression.AND([
|
|
domain_per_model['project.project'],
|
|
project_domain,
|
|
billable_project_domain,
|
|
])
|
|
project_query = self.env['project.project']._where_calc(project_domain)
|
|
self._apply_ir_rules(project_query, 'read')
|
|
project_query_str, project_params = project_query.select('id', 'sale_line_id')
|
|
|
|
Task = self.env['project.task']
|
|
task_domain = [('project_id', 'in', self.ids), ('sale_line_id', '!=', False)]
|
|
if Task._name in domain_per_model:
|
|
task_domain = expression.AND([
|
|
domain_per_model[Task._name],
|
|
task_domain,
|
|
])
|
|
task_query = Task._where_calc(task_domain)
|
|
Task._apply_ir_rules(task_query, 'read')
|
|
task_query_str, task_params = task_query.select(f'{Task._table}.project_id AS id', f'{Task._table}.sale_line_id')
|
|
|
|
ProjectMilestone = self.env['project.milestone']
|
|
milestone_domain = [('project_id', 'in', self.ids), ('allow_billable', '=', True), ('sale_line_id', '!=', False)]
|
|
if ProjectMilestone._name in domain_per_model:
|
|
milestone_domain = expression.AND([
|
|
domain_per_model[ProjectMilestone._name],
|
|
milestone_domain,
|
|
billable_project_domain,
|
|
])
|
|
milestone_query = ProjectMilestone._where_calc(milestone_domain)
|
|
ProjectMilestone._apply_ir_rules(milestone_query)
|
|
milestone_query_str, milestone_params = milestone_query.select(
|
|
f'{ProjectMilestone._table}.project_id AS id',
|
|
f'{ProjectMilestone._table}.sale_line_id',
|
|
)
|
|
|
|
query = Query(self._cr, 'project_sale_order_item', ' UNION '.join([project_query_str, task_query_str, milestone_query_str]))
|
|
query._where_params = project_params + task_params + milestone_params
|
|
return query
|
|
|
|
def get_panel_data(self):
|
|
panel_data = super().get_panel_data()
|
|
return {
|
|
**panel_data,
|
|
'sale_items': self._get_sale_items(),
|
|
}
|
|
|
|
def get_sale_items_data(self, domain=None, offset=0, limit=None, with_action=True):
|
|
if not self.user_has_groups('project.group_project_user'):
|
|
return {}
|
|
sols = self.env['sale.order.line'].sudo().search(
|
|
domain or self._get_sale_items_domain(),
|
|
offset=offset,
|
|
limit=limit,
|
|
)
|
|
# filter to only get the action for the SOLs that the user can read
|
|
action_per_sol = sols.sudo(False)._filter_access_rules_python('read')._get_action_per_item() if with_action else {}
|
|
|
|
def get_action(sol_id):
|
|
""" Return the action vals to call it in frontend if the user can access to the SO related """
|
|
action, res_id = action_per_sol.get(sol_id, (None, None))
|
|
return {'action': {'name': action, 'resId': res_id, 'buttonContext': json.dumps({'active_id': sol_id, 'default_project_id': self.id})}} if action else {}
|
|
|
|
return [{
|
|
**sol_read,
|
|
**get_action(sol_read['id']),
|
|
} for sol_read in sols.with_context(with_price_unit=True).read(['display_name', 'product_uom_qty', 'qty_delivered', 'qty_invoiced', 'product_uom'])]
|
|
|
|
def _get_sale_items_domain(self, additional_domain=None):
|
|
sale_items = self.sudo()._get_sale_order_items()
|
|
domain = [
|
|
('order_id', 'in', sale_items.sudo().order_id.ids),
|
|
('is_downpayment', '=', False),
|
|
('state', 'in', ['sale', 'done']),
|
|
('display_type', '=', False),
|
|
'|',
|
|
'|',
|
|
('project_id', 'in', self.ids),
|
|
('project_id', '=', False),
|
|
('id', 'in', sale_items.ids),
|
|
]
|
|
if additional_domain:
|
|
domain = expression.AND([domain, additional_domain])
|
|
return domain
|
|
|
|
def _get_sale_items(self, with_action=True):
|
|
domain = self._get_sale_items_domain()
|
|
return {
|
|
'total': self.env['sale.order.line'].sudo().search_count(domain),
|
|
'data': self.get_sale_items_data(domain, limit=5, with_action=with_action),
|
|
}
|
|
|
|
def _show_profitability(self):
|
|
self.ensure_one()
|
|
return self.allow_billable and super()._show_profitability()
|
|
|
|
def _get_profitability_labels(self):
|
|
return {
|
|
**super()._get_profitability_labels(),
|
|
'service_revenues': _lt('Other Services'),
|
|
'other_revenues': _lt('Materials'),
|
|
'other_invoice_revenues': _lt('Other Revenues'),
|
|
}
|
|
|
|
def _get_profitability_sequence_per_invoice_type(self):
|
|
return {
|
|
**super()._get_profitability_sequence_per_invoice_type(),
|
|
'service_revenues': 6,
|
|
'other_revenues': 7,
|
|
'other_invoice_revenues': 8,
|
|
}
|
|
|
|
def _get_service_policy_to_invoice_type(self):
|
|
return {
|
|
'ordered_prepaid': 'service_revenues',
|
|
'delivered_milestones': 'service_revenues',
|
|
'delivered_manual': 'service_revenues',
|
|
}
|
|
|
|
def _get_profitability_sale_order_items_domain(self, domain=None):
|
|
if domain is None:
|
|
domain = []
|
|
return expression.AND([
|
|
[
|
|
('product_id', '!=', False),
|
|
('is_expense', '=', False),
|
|
('is_downpayment', '=', False),
|
|
('state', 'in', ['sale', 'done']),
|
|
'|', ('qty_to_invoice', '>', 0), ('qty_invoiced', '>', 0),
|
|
],
|
|
domain,
|
|
])
|
|
|
|
def _get_revenues_items_from_sol(self, domain=None, with_action=True):
|
|
sale_line_read_group = self.env['sale.order.line'].sudo()._read_group(
|
|
self._get_profitability_sale_order_items_domain(domain),
|
|
['product_id', 'ids:array_agg(id)', 'untaxed_amount_to_invoice', 'untaxed_amount_invoiced', 'currency_id'],
|
|
['product_id', 'currency_id'],
|
|
lazy=False,
|
|
)
|
|
display_sol_action = with_action and len(self) == 1 and self.user_has_groups('sales_team.group_sale_salesman')
|
|
revenues_dict = {}
|
|
total_to_invoice = total_invoiced = 0.0
|
|
if sale_line_read_group:
|
|
# Get conversion rate from currencies of the sale order lines to currency of project
|
|
currency_ids = list(set([line['currency_id'][0] for line in sale_line_read_group] + [self.currency_id.id]))
|
|
rates = self.env['res.currency'].browse(currency_ids)._get_rates(self.company_id, date.today())
|
|
conversion_rates = {cid: rates[self.currency_id.id] / rate_from for cid, rate_from in rates.items()}
|
|
|
|
sols_per_product = {}
|
|
for group in sale_line_read_group:
|
|
product_id = group['product_id'][0]
|
|
currency_id = group['currency_id'][0]
|
|
sols_total_amounts = sols_per_product.setdefault(product_id, (0, 0, []))
|
|
sols_current_amounts = (
|
|
group['untaxed_amount_to_invoice'] * conversion_rates[currency_id],
|
|
group['untaxed_amount_invoiced'] * conversion_rates[currency_id],
|
|
group['ids'],
|
|
)
|
|
sols_per_product[product_id] = tuple(reduce(lambda x, y: x + y, pair) for pair in zip(sols_total_amounts, sols_current_amounts))
|
|
product_read_group = self.env['product.product'].sudo()._read_group(
|
|
[('id', 'in', list(sols_per_product))],
|
|
['invoice_policy', 'service_type', 'type', 'ids:array_agg(id)'],
|
|
['invoice_policy', 'service_type', 'type'],
|
|
lazy=False,
|
|
)
|
|
service_policy_to_invoice_type = self._get_service_policy_to_invoice_type()
|
|
general_to_service_map = self.env['product.template']._get_general_to_service_map()
|
|
for res in product_read_group:
|
|
product_ids = res['ids']
|
|
service_policy = None
|
|
if res['type'] == 'service':
|
|
service_policy = general_to_service_map.get(
|
|
(res['invoice_policy'], res['service_type']),
|
|
'ordered_prepaid')
|
|
for product_id, (amount_to_invoice, amount_invoiced, sol_ids) in sols_per_product.items():
|
|
if product_id in product_ids:
|
|
invoice_type = service_policy_to_invoice_type.get(service_policy, 'other_revenues')
|
|
revenue = revenues_dict.setdefault(invoice_type, {'invoiced': 0.0, 'to_invoice': 0.0})
|
|
revenue['to_invoice'] += amount_to_invoice
|
|
total_to_invoice += amount_to_invoice
|
|
revenue['invoiced'] += amount_invoiced
|
|
total_invoiced += amount_invoiced
|
|
if display_sol_action and invoice_type in ['service_revenues', 'other_revenues']:
|
|
revenue.setdefault('record_ids', []).extend(sol_ids)
|
|
|
|
if display_sol_action:
|
|
section_name = 'other_revenues'
|
|
other_revenues = revenues_dict.get(section_name, {})
|
|
sale_order_items = self.env['sale.order.line'] \
|
|
.browse(other_revenues.pop('record_ids', [])) \
|
|
._filter_access_rules_python('read')
|
|
if sale_order_items:
|
|
if sale_order_items:
|
|
args = [section_name, [('id', 'in', sale_order_items.ids)]]
|
|
if len(sale_order_items) == 1:
|
|
args.append(sale_order_items.id)
|
|
action_params = {
|
|
'name': 'action_profitability_items',
|
|
'type': 'object',
|
|
'args': json.dumps(args),
|
|
}
|
|
other_revenues['action'] = action_params
|
|
sequence_per_invoice_type = self._get_profitability_sequence_per_invoice_type()
|
|
return {
|
|
'data': [{'id': invoice_type, 'sequence': sequence_per_invoice_type[invoice_type], **vals} for invoice_type, vals in revenues_dict.items()],
|
|
'total': {'to_invoice': total_to_invoice, 'invoiced': total_invoiced},
|
|
}
|
|
|
|
def _get_revenues_items_from_invoices_domain(self, domain=None):
|
|
if domain is None:
|
|
domain = []
|
|
included_invoice_line_ids = self._get_already_included_profitability_invoice_line_ids()
|
|
return expression.AND([
|
|
domain,
|
|
[('move_id.move_type', 'in', self.env['account.move'].get_sale_types()),
|
|
('parent_state', 'in', ['draft', 'posted']),
|
|
('price_subtotal', '!=', 0),
|
|
('is_downpayment', '=', False),
|
|
('id', 'not in', included_invoice_line_ids)],
|
|
])
|
|
|
|
def _get_revenues_items_from_invoices(self, excluded_move_line_ids=None):
|
|
"""
|
|
Get all revenues items from invoices, and put them into their own
|
|
"other_invoice_revenues" section.
|
|
If the final total is 0 for either to_invoice or invoiced (ex: invoice -> credit note),
|
|
we don't output a new section
|
|
|
|
:param excluded_move_line_ids a list of 'account.move.line' to ignore
|
|
when fetching the move lines, for example a list of invoices that were
|
|
generated from a sales order
|
|
"""
|
|
if excluded_move_line_ids is None:
|
|
excluded_move_line_ids = []
|
|
query = self.env['account.move.line'].sudo()._search(
|
|
self._get_revenues_items_from_invoices_domain([('id', 'not in', excluded_move_line_ids)]),
|
|
)
|
|
query.add_where('account_move_line.analytic_distribution ? %s', [str(self.analytic_account_id.id)])
|
|
# account_move_line__move_id is the alias of the joined table account_move in the query
|
|
# we can use it, because of the "move_id.move_type" clause in the domain of the query, which generates the join
|
|
# this is faster than a search_read followed by a browse on the move_id to retrieve the move_type of each account.move.line
|
|
query_string, query_param = query.select('price_subtotal', 'parent_state', 'account_move_line.currency_id', 'account_move_line.analytic_distribution', 'account_move_line__move_id.move_type')
|
|
self._cr.execute(query_string, query_param)
|
|
invoices_move_line_read = self._cr.dictfetchall()
|
|
if invoices_move_line_read:
|
|
|
|
# Get conversion rate from currencies to currency of the project
|
|
currency_ids = {iml['currency_id'] for iml in invoices_move_line_read + [{'currency_id': self.currency_id.id}]}
|
|
rates = self.env['res.currency'].browse(list(currency_ids))._get_rates(self.company_id, date.today())
|
|
conversion_rates = {cid: rates[self.currency_id.id] / rate_from for cid, rate_from in rates.items()}
|
|
|
|
amount_invoiced = amount_to_invoice = 0.0
|
|
for moves_read in invoices_move_line_read:
|
|
price_subtotal = self.currency_id.round(moves_read['price_subtotal'] * conversion_rates[moves_read['currency_id']])
|
|
analytic_contribution = moves_read['analytic_distribution'][str(self.analytic_account_id.id)] / 100.
|
|
if moves_read['parent_state'] == 'draft':
|
|
if moves_read['move_type'] == 'out_invoice':
|
|
amount_to_invoice += price_subtotal * analytic_contribution
|
|
else: # moves_read['move_type'] == 'out_refund'
|
|
amount_to_invoice -= price_subtotal * analytic_contribution
|
|
else: # moves_read['parent_state'] == 'posted'
|
|
if moves_read['move_type'] == 'out_invoice':
|
|
amount_invoiced += price_subtotal * analytic_contribution
|
|
else: # moves_read['move_type'] == 'out_refund'
|
|
amount_invoiced -= price_subtotal * analytic_contribution
|
|
# don't display the section if the final values are both 0 (invoice -> credit note)
|
|
if amount_invoiced != 0 or amount_to_invoice != 0:
|
|
section_id = 'other_invoice_revenues'
|
|
invoices_revenues = {
|
|
'id': section_id,
|
|
'sequence': self._get_profitability_sequence_per_invoice_type()[section_id],
|
|
'invoiced': amount_invoiced,
|
|
'to_invoice': amount_to_invoice,
|
|
}
|
|
return {
|
|
'data': [invoices_revenues],
|
|
'total': {
|
|
'invoiced': amount_invoiced,
|
|
'to_invoice': amount_to_invoice,
|
|
},
|
|
}
|
|
return {'data': [], 'total': {'invoiced': 0.0, 'to_invoice': 0.0}}
|
|
|
|
def _get_profitability_items(self, with_action=True):
|
|
profitability_items = super()._get_profitability_items(with_action)
|
|
sale_items = self.sudo()._get_sale_order_items()
|
|
domain = [
|
|
('order_id', 'in', sale_items.order_id.ids),
|
|
'|',
|
|
'|',
|
|
('project_id', 'in', self.ids),
|
|
('project_id', '=', False),
|
|
('id', 'in', sale_items.ids),
|
|
]
|
|
revenue_items_from_sol = self._get_revenues_items_from_sol(
|
|
domain,
|
|
with_action,
|
|
)
|
|
revenues = profitability_items['revenues']
|
|
revenues['data'] += revenue_items_from_sol['data']
|
|
revenues['total']['to_invoice'] += revenue_items_from_sol['total']['to_invoice']
|
|
revenues['total']['invoiced'] += revenue_items_from_sol['total']['invoiced']
|
|
|
|
sale_line_read_group = self.env['sale.order.line'].sudo()._read_group(
|
|
self._get_profitability_sale_order_items_domain(domain),
|
|
['ids:array_agg(id)'],
|
|
['product_id'],
|
|
)
|
|
revenue_items_from_invoices = self._get_revenues_items_from_invoices(
|
|
excluded_move_line_ids=self.env['sale.order.line'].browse(
|
|
[sol_id for sol_read in sale_line_read_group for sol_id in sol_read['ids']]
|
|
).sudo().invoice_lines.ids
|
|
)
|
|
revenues['data'] += revenue_items_from_invoices['data']
|
|
revenues['total']['to_invoice'] += revenue_items_from_invoices['total']['to_invoice']
|
|
revenues['total']['invoiced'] += revenue_items_from_invoices['total']['invoiced']
|
|
return profitability_items
|
|
|
|
def _get_stat_buttons(self):
|
|
buttons = super(Project, self)._get_stat_buttons()
|
|
if self.user_has_groups('sales_team.group_sale_salesman_all_leads'):
|
|
buttons.append({
|
|
'icon': 'dollar',
|
|
'text': _lt('Sales Orders'),
|
|
'number': self.sale_order_count,
|
|
'action_type': 'object',
|
|
'action': 'action_view_sos',
|
|
'show': self.sale_order_count > 0,
|
|
'sequence': 1,
|
|
})
|
|
if self.user_has_groups('account.group_account_readonly'):
|
|
buttons.append({
|
|
'icon': 'pencil-square-o',
|
|
'text': _lt('Invoices'),
|
|
'number': self.invoice_count,
|
|
'action_type': 'object',
|
|
'action': 'action_open_project_invoices',
|
|
'show': bool(self.analytic_account_id) and self.invoice_count > 0,
|
|
'sequence': 30,
|
|
})
|
|
if self.user_has_groups('account.group_account_readonly'):
|
|
buttons.append({
|
|
'icon': 'pencil-square-o',
|
|
'text': _lt('Vendor Bills'),
|
|
'number': self.vendor_bill_count,
|
|
'action_type': 'object',
|
|
'action': 'action_open_project_vendor_bills',
|
|
'show': self.vendor_bill_count > 0,
|
|
'sequence': 48,
|
|
})
|
|
return buttons
|
|
|
|
def action_open_project_vendor_bills(self):
|
|
query = self.env['account.move.line']._search([('move_id.move_type', 'in', ['in_invoice', 'in_refund'])])
|
|
query.add_where('analytic_distribution ? %s', [str(self.analytic_account_id.id)])
|
|
query.order = None
|
|
query_string, query_param = query.select('DISTINCT move_id')
|
|
self._cr.execute(query_string, query_param)
|
|
vendor_bill_ids = [line.get('move_id') for line in self._cr.dictfetchall()]
|
|
action_window = {
|
|
'name': _('Vendor Bills'),
|
|
'type': 'ir.actions.act_window',
|
|
'res_model': 'account.move',
|
|
'views': [[False, 'tree'], [False, 'form'], [False, 'kanban']],
|
|
'domain': [('id', 'in', vendor_bill_ids)],
|
|
'context': {
|
|
'create': False,
|
|
}
|
|
}
|
|
if len(vendor_bill_ids) == 1:
|
|
action_window['views'] = [[False, 'form']]
|
|
action_window['res_id'] = vendor_bill_ids[0]
|
|
return action_window
|
|
|
|
class ProjectTask(models.Model):
|
|
_inherit = "project.task"
|
|
|
|
def _domain_sale_line_id(self):
|
|
domain = expression.AND([
|
|
self.env['sale.order.line']._sellable_lines_domain(),
|
|
[
|
|
('company_id', '=', unquote('company_id')),
|
|
'|', ('order_partner_id', 'child_of', unquote('commercial_partner_id if commercial_partner_id else []')),
|
|
('order_partner_id', '=?', unquote('partner_id')),
|
|
('is_service', '=', True), ('is_expense', '=', False), ('state', 'in', ['sale', 'done']),
|
|
],
|
|
])
|
|
return domain
|
|
|
|
sale_order_id = fields.Many2one('sale.order', 'Sales Order', compute='_compute_sale_order_id', store=True, help="Sales order to which the task is linked.")
|
|
sale_line_id = fields.Many2one(
|
|
'sale.order.line', 'Sales Order Item',
|
|
copy=True, tracking=True, index='btree_not_null', recursive=True,
|
|
compute='_compute_sale_line', store=True, readonly=False,
|
|
domain=lambda self: str(self._domain_sale_line_id()),
|
|
help="Sales Order Item to which the time spent on this task will be added in order to be invoiced to your customer.\n"
|
|
"By default the sales order item set on the project will be selected. In the absence of one, the last prepaid sales order item that has time remaining will be used.\n"
|
|
"Remove the sales order item in order to make this task non billable. You can also change or remove the sales order item of each timesheet entry individually.")
|
|
project_sale_order_id = fields.Many2one('sale.order', string="Project's sale order", related='project_id.sale_order_id')
|
|
task_to_invoice = fields.Boolean("To invoice", compute='_compute_task_to_invoice', search='_search_task_to_invoice', groups='sales_team.group_sale_salesman_all_leads')
|
|
|
|
# Project sharing fields
|
|
display_sale_order_button = fields.Boolean(string='Display Sales Order', compute='_compute_display_sale_order_button')
|
|
|
|
@property
|
|
def SELF_READABLE_FIELDS(self):
|
|
return super().SELF_READABLE_FIELDS | {'sale_order_id', 'sale_line_id', 'display_sale_order_button'}
|
|
|
|
@api.depends('sale_line_id', 'project_id', 'commercial_partner_id')
|
|
def _compute_sale_order_id(self):
|
|
for task in self:
|
|
sale_order_id = task.sale_order_id or self.env["sale.order"]
|
|
if task.sale_line_id:
|
|
sale_order_id = task.sale_line_id.sudo().order_id
|
|
elif task.project_id.sale_order_id:
|
|
sale_order_id = task.project_id.sale_order_id
|
|
if task.commercial_partner_id != sale_order_id.partner_id.commercial_partner_id:
|
|
sale_order_id = False
|
|
if sale_order_id and not task.partner_id:
|
|
task.partner_id = sale_order_id.partner_id
|
|
task.sale_order_id = sale_order_id
|
|
|
|
@api.depends('commercial_partner_id', 'sale_line_id.order_partner_id', 'parent_id.sale_line_id', 'project_id.sale_line_id', 'milestone_id.sale_line_id')
|
|
def _compute_sale_line(self):
|
|
for task in self:
|
|
if not task.sale_line_id:
|
|
# if the display_project_id is set then it means the task is classic task or a subtask with another project than its parent.
|
|
task.sale_line_id = task.display_project_id.sale_line_id or task.parent_id.sale_line_id or task.project_id.sale_line_id or task.milestone_id.sale_line_id
|
|
# check sale_line_id and customer are coherent
|
|
if task.sale_line_id.order_partner_id.commercial_partner_id != task.partner_id.commercial_partner_id:
|
|
task.sale_line_id = False
|
|
|
|
@api.depends('sale_order_id')
|
|
def _compute_display_sale_order_button(self):
|
|
if not self.sale_order_id:
|
|
self.display_sale_order_button = False
|
|
return
|
|
try:
|
|
sale_orders = self.env['sale.order'].search([('id', 'in', self.sale_order_id.ids)])
|
|
for task in self:
|
|
task.display_sale_order_button = task.sale_order_id in sale_orders
|
|
except AccessError:
|
|
self.display_sale_order_button = False
|
|
|
|
@api.constrains('sale_line_id')
|
|
def _check_sale_line_type(self):
|
|
for task in self.sudo():
|
|
if task.sale_line_id:
|
|
if not task.sale_line_id.is_service or task.sale_line_id.is_expense:
|
|
raise ValidationError(_(
|
|
'You cannot link the order item %(order_id)s - %(product_id)s to this task because it is a re-invoiced expense.',
|
|
order_id=task.sale_line_id.order_id.name,
|
|
product_id=task.sale_line_id.product_id.display_name,
|
|
))
|
|
|
|
# ---------------------------------------------------
|
|
# Actions
|
|
# ---------------------------------------------------
|
|
|
|
def _get_action_view_so_ids(self):
|
|
return self.sale_order_id.ids
|
|
|
|
def action_view_so(self):
|
|
so_ids = self._get_action_view_so_ids()
|
|
action_window = {
|
|
"type": "ir.actions.act_window",
|
|
"res_model": "sale.order",
|
|
"name": _("Sales Order"),
|
|
"views": [[False, "tree"], [False, "kanban"], [False, "form"]],
|
|
"context": {"create": False, "show_sale": True},
|
|
"domain": [["id", "in", so_ids]],
|
|
}
|
|
if len(so_ids) == 1:
|
|
action_window["views"] = [[False, "form"]]
|
|
action_window["res_id"] = so_ids[0]
|
|
|
|
return action_window
|
|
|
|
def action_project_sharing_view_so(self):
|
|
self.ensure_one()
|
|
if not self.display_sale_order_button:
|
|
return {}
|
|
return {
|
|
"name": "Portal Sale Order",
|
|
"type": "ir.actions.act_url",
|
|
"url": self.sale_order_id.access_url,
|
|
}
|
|
|
|
def _rating_get_partner(self):
|
|
partner = self.partner_id or self.sale_line_id.order_id.partner_id
|
|
return partner or super()._rating_get_partner()
|
|
|
|
@api.depends('sale_order_id.invoice_status', 'sale_order_id.order_line')
|
|
def _compute_task_to_invoice(self):
|
|
for task in self:
|
|
if task.sale_order_id:
|
|
task.task_to_invoice = bool(task.sale_order_id.invoice_status not in ('no', 'invoiced'))
|
|
else:
|
|
task.task_to_invoice = False
|
|
|
|
@api.model
|
|
def _search_task_to_invoice(self, operator, value):
|
|
query = """
|
|
SELECT so.id
|
|
FROM sale_order so
|
|
WHERE so.invoice_status != 'invoiced'
|
|
AND so.invoice_status != 'no'
|
|
"""
|
|
operator_new = 'inselect'
|
|
if(bool(operator == '=') ^ bool(value)):
|
|
operator_new = 'not inselect'
|
|
return [('sale_order_id', operator_new, (query, ()))]
|
|
|
|
@api.onchange('sale_line_id')
|
|
def _onchange_partner_id(self):
|
|
if not self.partner_id and self.sale_line_id:
|
|
self.partner_id = self.sale_line_id.order_partner_id
|
|
|
|
class ProjectTaskRecurrence(models.Model):
|
|
_inherit = 'project.task.recurrence'
|
|
|
|
def _new_task_values(self, task):
|
|
values = super(ProjectTaskRecurrence, self)._new_task_values(task)
|
|
task = self.sudo().task_ids[0]
|
|
values['sale_line_id'] = self._get_sale_line_id(task)
|
|
return values
|
|
|
|
def _get_sale_line_id(self, task):
|
|
return task.sale_line_id.id
|