1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
import math
from odoo import http
from odoo.addons.http_routing.models.ir_http import slug
from odoo.addons.website_event.controllers.community import EventCommunityController
from odoo.http import request
class WebsiteEventTrackQuizCommunityController(EventCommunityController):
_visitors_per_page = 30
_pager_max_pages = 5
@http.route(['/event/<model("event.event"):event>/community/leaderboard/results',
'/event/<model("event.event"):event>/community/leaderboard/results/page/<int:page>'],
type='http', auth="public", website=True, sitemap=False)
def leaderboard(self, event, page=1, lang=None, **kwargs):
values = self._get_community_leaderboard_render_values(event, kwargs.get('search'), page)
return request.render('website_event_track_quiz.event_leaderboard', values)
@http.route('/event/<model("event.event"):event>/community/leaderboard',
type='http', auth="public", website=True, sitemap=False)
def community_leaderboard(self, event, **kwargs):
values = self._get_community_leaderboard_render_values(event, None, None)
return request.render('website_event_track_quiz.event_leaderboard', values)
@http.route('/event/<model("event.event"):event>/community',
type='http', auth="public", website=True, sitemap=False)
def community(self, event, **kwargs):
values = self._get_community_leaderboard_render_values(event, None, None)
return request.render('website_event_track_quiz.event_leaderboard', values)
def _get_community_leaderboard_render_values(self, event, search_term, page):
values = self._get_leaderboard(event, search_term)
values.update({'event': event, 'search': search_term})
user_count = len(values['visitors'])
if user_count:
page_count = math.ceil(user_count / self._visitors_per_page)
url = '/event/%s/community/leaderboard/results' % (slug(event))
if values.get('current_visitor_position') and not page:
values['scroll_to_position'] = True
page = math.ceil(values['current_visitor_position'] / self._visitors_per_page)
elif not page:
page = 1
pager = request.website.pager(url=url, total=user_count, page=page, step=self._visitors_per_page,
scope=page_count if page_count < self._pager_max_pages else self._pager_max_pages)
values['visitors'] = values['visitors'][(page - 1) * self._visitors_per_page: (page) * self._visitors_per_page]
else:
pager = {'page_count': 0}
values.update({'pager': pager})
return values
def _get_leaderboard(self, event, searched_name=None):
current_visitor = request.env['website.visitor']._get_visitor_from_request(force_create=False)
track_visitor_data = request.env['event.track.visitor'].sudo().read_group(
[('track_id', 'in', event.track_ids.ids),
('visitor_id', '!=', False),
('quiz_points', '>', 0)],
['id', 'visitor_id', 'points:sum(quiz_points)'],
['visitor_id'], orderby="points DESC")
data_map = {datum['visitor_id'][0]: datum['points'] for datum in track_visitor_data if datum.get('visitor_id')}
leaderboard = []
position = 1
current_visitor_position = False
visitors_by_id = {
visitor.id: visitor
for visitor in request.env['website.visitor'].sudo().browse(data_map.keys())
}
for visitor_id, points in data_map.items():
visitor = visitors_by_id.get(visitor_id)
if not visitor:
continue
if (searched_name and searched_name.lower() in visitor.display_name.lower()) or not searched_name:
leaderboard.append({'visitor': visitor, 'points': points, 'position': position})
if current_visitor and current_visitor == visitor:
current_visitor_position = position
position = position + 1
return {
'top3_visitors': leaderboard[:3],
'visitors': leaderboard,
'current_visitor_position': current_visitor_position,
'current_visitor': current_visitor,
'searched_name': searched_name
}
|
