initial commit 2

1 files changed, 36 insertions, 0 deletions

diff --git a/addons/mass_mailing_sms/models/mailing_list.py b/addons/mass_mailing_sms/models/mailing_list.py
new file mode 100644
index 00000000..9e48fa7d
--- /dev/null
+++ b/addons/mass_mailing_sms/models/mailing_list.py
@@ -0,0 +1,36 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import models
+
+
+class MailingList(models.Model):
+    _inherit = 'mailing.list'
+
+    def _compute_contact_nbr(self):
+        if self.env.context.get('mailing_sms') and self.ids:
+            self.env.cr.execute('''
+select list_id, count(*)
+from mailing_contact_list_rel r
+left join mailing_contact c on (r.contact_id=c.id)
+left join phone_blacklist bl on c.phone_sanitized = bl.number and bl.active
+where
+    list_id in %s
+    AND COALESCE(r.opt_out,FALSE) = FALSE
+    AND c.phone_sanitized IS NOT NULL
+    AND bl.id IS NULL
+group by list_id''', (tuple(self.ids), ))
+            data = dict(self.env.cr.fetchall())
+            for mailing_list in self:
+                mailing_list.contact_nbr = data.get(mailing_list.id, 0)
+            return
+        return super(MailingList, self)._compute_contact_nbr()
+
+    def action_view_contacts(self):
+        if self.env.context.get('mailing_sms'):
+            action = self.env["ir.actions.actions"]._for_xml_id("mass_mailing_sms.mailing_contact_action_sms")
+            action['domain'] = [('list_ids', 'in', self.ids)]
+            context = dict(self.env.context, search_default_filter_valid_sms_recipient=1, default_list_ids=self.ids)
+            action['context'] = context
+            return action
+        return super(MailingList, self).action_view_contacts()