[REM] website_rating_project: move feature in project

Displaying the rating of project is moved directly
in project module, since it does not depends on website.
User may want to display rating of its support project
even without website.

2 files changed, 93 insertions, 0 deletions

diff --git a/addons/project/controllers/__init__.py b/addons/project/controllers/__init__.py
index 903b755e71e..10825353c81 100644
--- a/addons/project/controllers/__init__.py
+++ b/addons/project/controllers/__init__.py
@@ -2,3 +2,4 @@
 # Part of Odoo. See LICENSE file for full copyright and licensing details.
 
 from . import portal
+from . import rating
diff --git a/addons/project/controllers/rating.py b/addons/project/controllers/rating.py
new file mode 100644
index 00000000000..3343674c0e8
--- /dev/null
+++ b/addons/project/controllers/rating.py
@@ -0,0 +1,92 @@
+# -*- 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)
+    def index(self, **kw):
+        projects = request.env['project.project'].sudo().search([('rating_status', '!=', 'no'), ('portal_show_rating', '=', True)])
+        values = {'projects': projects}
+        return request.render('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 - create_date::date BETWEEN 0 AND 6 Then 'days_06'
+                    WHEN now()::date - create_date::date BETWEEN 0 AND 15 Then 'days_15'
+                    WHEN now()::date - create_date::date BETWEEN 0 AND 30  Then 'days_30'
+                    WHEN now()::date - create_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 create_date >= current_date - interval '90' day
+                    AND rating IN (1,5,10)
+            GROUP BY
+                rated_partner_id, rating, period
+        """ % (project_id))
+
+        raw_data = request.env.cr.dictfetchall()
+
+        # periodical statistics
+        default_period_dict = {'rating_10': 0, 'rating_5': 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_10': 0, 'rating_5': 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_10'] / 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_status != 'no') and project.portal_show_rating) and not user.sudo(user).has_group('project.group_project_manager'):
+            raise NotFound()
+
+        return request.render('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),
+        })