initial commit 2

2 files changed, 87 insertions, 0 deletions

diff --git a/addons/mass_mailing_sale/models/__init__.py b/addons/mass_mailing_sale/models/__init__.py
new file mode 100644
index 00000000..9733ab53
--- /dev/null
+++ b/addons/mass_mailing_sale/models/__init__.py
@@ -0,0 +1,4 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from . import mailing_mailing
diff --git a/addons/mass_mailing_sale/models/mailing_mailing.py b/addons/mass_mailing_sale/models/mailing_mailing.py
new file mode 100644
index 00000000..6d8137d9
--- /dev/null
+++ b/addons/mass_mailing_sale/models/mailing_mailing.py
@@ -0,0 +1,83 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+
+from odoo import api, fields, models, _, tools
+
+
+class MassMailing(models.Model):
+    _name = 'mailing.mailing'
+    _inherit = 'mailing.mailing'
+
+    sale_quotation_count = fields.Integer('Quotation Count', groups='sales_team.group_sale_salesman', compute='_compute_sale_quotation_count')
+    sale_invoiced_amount = fields.Integer('Invoiced Amount', groups='sales_team.group_sale_salesman', compute='_compute_sale_invoiced_amount')
+
+    @api.depends('mailing_domain')
+    def _compute_sale_quotation_count(self):
+        has_so_access = self.env['sale.order'].check_access_rights('read', raise_exception=False)
+        for mass_mailing in self:
+            mass_mailing.sale_quotation_count = self.env['sale.order'].search_count(mass_mailing._get_sale_utm_domain()) if has_so_access else 0
+
+    @api.depends('mailing_domain')
+    def _compute_sale_invoiced_amount(self):
+        for mass_mailing in self:
+            if self.user_has_groups('sales_team.group_sale_salesman') and self.user_has_groups('account.group_account_invoice'):
+                domain = mass_mailing._get_sale_utm_domain() + [('state', 'not in', ['draft', 'cancel'])]
+                moves = self.env['account.move'].search_read(domain, ['amount_untaxed_signed'])
+                mass_mailing.sale_invoiced_amount = sum(i['amount_untaxed_signed'] for i in moves)
+            else:
+                mass_mailing.sale_invoiced_amount = 0
+
+    def action_redirect_to_quotations(self):
+        action = self.env["ir.actions.actions"]._for_xml_id("sale.action_quotations_with_onboarding")
+        action['domain'] = self._get_sale_utm_domain()
+        action['context'] = {'create': False}
+        return action
+
+    def action_redirect_to_invoiced(self):
+        action = self.env["ir.actions.actions"]._for_xml_id("account.action_move_out_invoice_type")
+        moves = self.env['account.move'].search(self._get_sale_utm_domain())
+        action['context'] = {
+            'create': False,
+            'edit': False,
+            'view_no_maturity': True
+        }
+        action['domain'] = [
+            ('id', 'in', moves.ids),
+            ('move_type', 'in', ('out_invoice', 'out_refund', 'in_invoice', 'in_refund', 'out_receipt', 'in_receipt')),
+            ('state', 'not in', ['draft', 'cancel'])
+        ]
+        action['context'] = {'create': False}
+        return action
+
+    def _get_sale_utm_domain(self):
+        res = []
+        if self.campaign_id:
+            res.append(('campaign_id', '=', self.campaign_id.id))
+        if self.source_id:
+            res.append(('source_id', '=', self.source_id.id))
+        if self.medium_id:
+            res.append(('medium_id', '=', self.medium_id.id))
+        if not res:
+            res.append((0, '=', 1))
+        return res
+
+    def _prepare_statistics_email_values(self):
+        self.ensure_one()
+        values = super(MassMailing, self)._prepare_statistics_email_values()
+        if not self.user_id:
+            return values
+
+        self_with_company = self.with_company(self.user_id.company_id)
+        currency = self.user_id.company_id.currency_id
+        formated_amount = tools.format_decimalized_amount(self_with_company.sale_invoiced_amount, currency)
+
+        values['kpi_data'][1]['kpi_col2'] = {
+            'value': self.sale_quotation_count,
+            'col_subtitle': _('QUOTATIONS'),
+        }
+        values['kpi_data'][1]['kpi_col3'] = {
+            'value': formated_amount,
+            'col_subtitle': _('INVOICED'),
+        }
+        return values