initial commit 2

1 files changed, 29 insertions, 0 deletions

diff --git a/addons/bus/models/res_partner.py b/addons/bus/models/res_partner.py
new file mode 100644
index 00000000..71f2f8fb
--- /dev/null
+++ b/addons/bus/models/res_partner.py
@@ -0,0 +1,29 @@
+# -*- coding: utf-8 -*-
+
+from odoo import api, fields, models
+from odoo.addons.bus.models.bus_presence import AWAY_TIMER
+from odoo.addons.bus.models.bus_presence import DISCONNECTION_TIMER
+
+
+class ResPartner(models.Model):
+    _inherit = 'res.partner'
+
+    im_status = fields.Char('IM Status', compute='_compute_im_status')
+
+    def _compute_im_status(self):
+        self.env.cr.execute("""
+            SELECT
+                U.partner_id as id,
+                CASE WHEN max(B.last_poll) IS NULL THEN 'offline'
+                    WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval %s THEN 'offline'
+                    WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval %s THEN 'away'
+                    ELSE 'online'
+                END as status
+            FROM bus_presence B
+            RIGHT JOIN res_users U ON B.user_id = U.id
+            WHERE U.partner_id IN %s AND U.active = 't'
+         GROUP BY U.partner_id
+        """, ("%s seconds" % DISCONNECTION_TIMER, "%s seconds" % AWAY_TIMER, tuple(self.ids)))
+        res = dict(((status['id'], status['status']) for status in self.env.cr.dictfetchall()))
+        for partner in self:
+            partner.im_status = res.get(partner.id, 'im_partner')  # if not found, it is a partner, useful to avoid to refresh status in js