diff options
Diffstat (limited to 'addons/website_project/controllers')
| -rw-r--r-- | addons/website_project/controllers/__init__.py | 4 | ||||
| -rw-r--r-- | addons/website_project/controllers/rating.py | 98 |
2 files changed, 102 insertions, 0 deletions
diff --git a/addons/website_project/controllers/__init__.py b/addons/website_project/controllers/__init__.py new file mode 100644 index 00000000000..7367c6c8192 --- /dev/null +++ b/addons/website_project/controllers/__init__.py @@ -0,0 +1,4 @@ +# -*- coding: utf-8 -*- +# Part of Odoo. See LICENSE file for full copyright and licensing details. + +from . import rating diff --git a/addons/website_project/controllers/rating.py b/addons/website_project/controllers/rating.py new file mode 100644 index 00000000000..7e0c3d5dda2 --- /dev/null +++ b/addons/website_project/controllers/rating.py @@ -0,0 +1,98 @@ +# -*- coding: utf-8 -*- +# Part of Odoo. See LICENSE file for full copyright and licensing details. + +from werkzeug.exceptions import NotFound + +from odoo import http +from odoo.http import request + + +class RatingProject(http.Controller): + + @http.route(['/project/rating'], type='http', auth="public", website=True, sitemap=True) + def index(self, **kw): + projects = request.env['project.project'].sudo().search([ + ('rating_active', '=', True), + ('is_published', '=', True)]) + values = {'projects': projects} + return request.render('website_project.rating_index', values) + + def _calculate_period_partner_stats(self, project_id): + # get raw data: number of rating by rated partner, by rating value, by period + request.env.cr.execute(""" + SELECT + rated_partner_id, + rating, + COUNT(rating) as rating_count, + CASE + WHEN now()::date - write_date::date BETWEEN 0 AND 6 Then 'days_06' + WHEN now()::date - write_date::date BETWEEN 0 AND 15 Then 'days_15' + WHEN now()::date - write_date::date BETWEEN 0 AND 30 Then 'days_30' + WHEN now()::date - write_date::date BETWEEN 0 AND 90 Then 'days_90' + END AS period + FROM + rating_rating + WHERE + parent_res_model = 'project.project' + AND parent_res_id = %s + AND res_model = 'project.task' + AND rated_partner_id IS NOT NULL + AND write_date >= current_date - interval '90' day + AND rating IN (1, 3, 5) + GROUP BY + rated_partner_id, rating, period + """, (project_id, )) + + raw_data = request.env.cr.dictfetchall() + + # periodical statistics + default_period_dict = {'rating_5': 0, 'rating_3': 0, 'rating_1': 0, 'total': 0} + period_statistics = { + 'days_06': dict(default_period_dict), + 'days_15': dict(default_period_dict), + 'days_30': dict(default_period_dict), + 'days_90': dict(default_period_dict), + } + for period_statistics_key in period_statistics.keys(): + for row in raw_data: + if row['period'] <= period_statistics_key: + period_statistics[period_statistics_key]['rating_%s' % (int(row['rating']),)] += row['rating_count'] + period_statistics[period_statistics_key]['total'] += row['rating_count'] + + # partner statistics + default_partner_dict = {'rating_5': 0, 'rating_3': 0, 'rating_1': 0, 'total': 0, 'rated_partner': None, 'percentage_happy': 0.0} + partner_statistics = {} + for row in raw_data: + if row['period'] <= 'days_15': + if row['rated_partner_id'] not in partner_statistics: + partner_statistics[row['rated_partner_id']] = dict(default_partner_dict) + partner_statistics[row['rated_partner_id']]['rated_partner'] = request.env['res.partner'].sudo().browse(row['rated_partner_id']) + partner_statistics[row['rated_partner_id']]['rating_%s' % (int(row['rating']),)] += row['rating_count'] + partner_statistics[row['rated_partner_id']]['total'] += row['rating_count'] + + for partner_id, stat_values in partner_statistics.items(): + stat_values['percentage_happy'] = (stat_values['rating_5'] / float(stat_values['total'])) * 100 if stat_values['total'] else 0.0 + + return { + 'partner_statistics': partner_statistics, + 'period_statistics': period_statistics, + } + + @http.route(['/project/rating/<int:project_id>'], type='http', auth="public", website=True) + def page(self, project_id=None, **kw): + user = request.env.user + project = request.env['project.project'].sudo().browse(project_id) + # to avoid giving any access rights on projects to the public user, let's use sudo + # and check if the user should be able to view the project (project managers only if it's unpublished or has no rating) + if not (project.rating_active and project.is_published) and not user.with_user(user).has_group('project.group_project_manager'): + raise NotFound() + + return request.render('website_project.rating_project_rating_page', { + 'project': project, + 'ratings': request.env['rating.rating'].sudo().search([ + ('consumed', '=', True), + ('parent_res_model', '=', 'project.project'), + ('parent_res_id', '=', project_id) + ], order='write_date DESC', limit=50), + 'statistics': self._calculate_period_partner_stats(project_id), + }) |