|
|
default_vals = dict(total_views=0, total_votes=0, total_time=0, total_slides=0)
keys = ['nbr_%s' % slide_category for slide_category in self.env['slide.slide']._fields['slide_category'].get_values(self.env)]
default_vals.update(dict((key, 0) for key in keys))
result = dict((cid, dict(default_vals)) for cid in self.ids)
read_group_res = self.env['slide.slide']._read_group(
[('active', '=', True), ('is_published', '=', True), ('channel_id', 'in', self.ids), ('is_category', '=', False)],
['channel_id', 'slide_category'],
aggregates=['__count', 'likes:sum', 'dislikes:sum', 'total_views:sum', 'completion_time:sum'])
for channel, slide_category, count, likes_sum, dislikes_sum, total_views_sum, completion_time_sum in read_group_res:
channel_dict = result[channel.id]
channel_dict['total_votes'] += likes_sum
channel_dict['total_votes'] -= dislikes_sum
channel_dict['total_views'] += total_views_sum
channel_dict['total_time'] += completion_time_sum
if slide_category:
channel_dict[f'nbr_{slide_category}'] = count
channel_dict['total_slides'] += count
for record in self:
record.update(result.get(record.id, default_vals))
|
|
