diff options
Diffstat (limited to 'addons/bus/models/res_partner.py')
| -rw-r--r-- | addons/bus/models/res_partner.py | 29 |
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 |
