[REF] project_issue: replace report by pivot / graph views

hr.recruitment.report is not necessary anymore as it can be replaced by
classic pivot and graph views on hr.applicant model.

Applicant has been slighty modified to ease reporting

 * adding group_operator average on both days to computation;
 * adding group_operator average on working hours computation;

3 files changed, 27 insertions, 87 deletions

diff --git a/addons/project_issue/report/__init__.py b/addons/project_issue/report/__init__.py
deleted file mode 100644
index e76831f6b56..00000000000
--- a/addons/project_issue/report/__init__.py
+++ /dev/null
@@ -1,4 +0,0 @@
-# -*- coding: utf-8 -*-
-# Part of Odoo. See LICENSE file for full copyright and licensing details.
-
-from . import project_issue_report
diff --git a/addons/project_issue/report/project_issue_report.py b/addons/project_issue/report/project_issue_report.py
deleted file mode 100644
index 70389f603e8..00000000000
--- a/addons/project_issue/report/project_issue_report.py
+++ /dev/null
@@ -1,58 +0,0 @@
-# -*- coding: utf-8 -*-
-# Part of Odoo. See LICENSE file for full copyright and licensing details.
-
-from odoo import api, fields, models, tools
-
-
-class ProjectIssueReport(models.Model):
-    _name = "project.issue.report"
-    _auto = False
-
-    company_id = fields.Many2one('res.company', 'Company', readonly=True)
-    opening_date = fields.Datetime('Date of Opening', readonly=True)
-    create_date = fields.Datetime('Create Date', readonly=True)
-    date_closed = fields.Datetime('Date of Closing', readonly=True)
-    date_last_stage_update = fields.Datetime('Last Stage Update', readonly=True)
-    stage_id = fields.Many2one('project.task.type', 'Stage')
-    nbr_issues = fields.Integer('# of Issues', readonly=True)
-    working_hours_open = fields.Float('Avg. Working Hours to Open', readonly=True, group_operator="avg")
-    working_hours_close = fields.Float('Avg. Working Hours to Close', readonly=True, group_operator="avg")
-    delay_open = fields.Float('Avg. Delay to Open', digits=(16, 2), readonly=True, group_operator="avg",
-                              help="Number of Days to open the project issue.")
-    delay_close = fields.Float('Avg. Delay to Close', digits=(16, 2), readonly=True, group_operator="avg",
-                               help="Number of Days to close the project issue")
-    priority = fields.Selection([('0', 'Low'), ('1', 'Normal'), ('2', 'High')])
-    project_id = fields.Many2one('project.project', 'Project', readonly=True)
-    user_id = fields.Many2one('res.users', 'Assigned to', readonly=True)
-    partner_id = fields.Many2one('res.partner', 'Contact')
-    email = fields.Integer('# Emails', readonly=True)
-
-    @api.model_cr
-    def init(self):
-        tools.drop_view_if_exists(self._cr, 'project_issue_report')
-        self._cr.execute("""
-            CREATE OR REPLACE VIEW project_issue_report AS (
-                SELECT
-                    c.id as id,
-                    c.date_open as opening_date,
-                    c.create_date as create_date,
-                    c.date_last_stage_update as date_last_stage_update,
-                    c.user_id,
-                    c.working_hours_open,
-                    c.working_hours_close,
-                    c.stage_id,
-                    c.date_closed as date_closed,
-                    c.company_id as company_id,
-                    c.priority as priority,
-                    c.project_id as project_id,
-                    1 as nbr_issues,
-                    c.partner_id,
-                    c.day_open as delay_open,
-                    c.day_close as delay_close,
-                    (SELECT count(id) FROM mail_message WHERE model='project.issue' AND message_type IN ('email', 'comment') AND res_id=c.id) AS email
-
-                FROM
-                    project_issue c
-                LEFT JOIN project_task t on c.task_id = t.id
-                WHERE c.active= 'true'
-            )""")
diff --git a/addons/project_issue/report/project_issue_report_views.xml b/addons/project_issue/report/project_issue_report_views.xml
index 53165683b82..6178f6ba6fa 100644
--- a/addons/project_issue/report/project_issue_report_views.xml
+++ b/addons/project_issue/report/project_issue_report_views.xml
@@ -1,46 +1,30 @@
 <?xml version="1.0" encoding="utf-8"?>
 <odoo>
         <record id="view_project_issue_report_pivot" model="ir.ui.view">
-            <field name="name">project.issue.report.pivot</field>
-            <field name="model">project.issue.report</field>
+            <field name="name">project.issue.pivot</field>
+            <field name="model">project.issue</field>
             <field name="arch" type="xml">
                 <pivot string="Project Issue" disable_linking="True">
                     <field name="project_id" type="row"/>
                     <field name="create_date" interval="month" type="col"/>
-                    <field name="nbr_issues" type="measure"/>
                 </pivot>
             </field>
         </record>
 
         <record id="view_project_issue_report_graph" model="ir.ui.view">
-            <field name="name">project.issue.report.graph</field>
-            <field name="model">project.issue.report</field>
+            <field name="name">project.issue.graph</field>
+            <field name="model">project.issue</field>
             <field name="arch" type="xml">
                 <graph string="Project Issue">
                     <field name="project_id" type="row"/>
                     <field name="create_date" interval="month" type="col"/>
-                    <field name="nbr_issues" type="measure"/>
                 </graph>
             </field>
         </record>
 
-        <!-- Custom reports (aka filters) -->
-        <record id="filter_issue_report_delay" model="ir.filters">
-            <field name="name">Delay</field>
-            <field name="model_id">project.issue.report</field>
-            <field name="user_id" eval="False"/>
-            <field name="context">{'group_by': ['project_id'], 'measures': ['delay_close', 'delay_open']}</field>
-        </record>
-        <record id="filter_issue_report_responsible" model="ir.filters">
-            <field name="name">By Responsible</field>
-            <field name="model_id">project.issue.report</field>
-            <field name="user_id" eval="False"/>
-            <field name="context">{'group_by': ['project_id', 'user_id']}</field>
-        </record>
-
         <record id="view_project_issue_report_filter" model="ir.ui.view">
-            <field name="name">project.issue.report.select</field>
-            <field name="model">project.issue.report</field>
+            <field name="name">project.issue.search</field>
+            <field name="model">project.issue</field>
             <field name="arch" type="xml">
                 <search string="Search">
                     <field name="project_id"/>
@@ -63,18 +47,36 @@
 
         <record id="action_project_issue_report" model="ir.actions.act_window">
             <field name="name">Issues Analysis</field>
-            <field name="res_model">project.issue.report</field>
+            <field name="res_model">project.issue</field>
             <field name="view_type">form</field>
             <field name="view_mode">graph,pivot</field>
             <field name="context">{'search_default_year':1,'search_default_This Month':1,'search_default_project':1}</field>
             <field name="search_view_id" ref="view_project_issue_report_filter"/>
-            <field name="view_id"></field>  <!-- force empty -->
+            <field name="view_ids" eval="[(5, 0, 0),
+                (0, 0, {'view_mode': 'pivot', 'view_id': ref('view_project_issue_report_pivot')}),
+                (0, 0, {'view_mode': 'graph', 'view_id': ref('view_project_issue_report_graph')})]"/>
             <field name="help">This report on the project issues allows you to analyse the quality of your support or after-sales services. You can track the issues per age. You can analyse the time required to open or close an issue, the number of email to exchange and the time spent on average by issues.</field>
         </record>
 
+        <!-- Custom reports (aka filters) -->
+        <record id="filter_issue_report_delay" model="ir.filters">
+            <field name="name">Delay</field>
+            <field name="model_id">project.issue</field>
+            <field name="user_id" eval="False"/>
+            <field name="action_id" ref="action_project_issue_report"/>
+            <field name="context">{'group_by': ['project_id'], 'measures': ['delay_close', 'delay_open']}</field>
+        </record>
+        <record id="filter_issue_report_responsible" model="ir.filters">
+            <field name="name">By Responsible</field>
+            <field name="model_id">project.issue</field>
+            <field name="user_id" eval="False"/>
+            <field name="action_id" ref="action_project_issue_report"/>
+            <field name="context">{'group_by': ['project_id', 'user_id']}</field>
+        </record>
+
         <record id="action_project_issue_report_filtered" model="ir.actions.act_window">
             <field name="name">Issues Analysis</field>
-            <field name="res_model">project.issue.report</field>
+            <field name="res_model">project.issue</field>
             <field name="view_type">form</field>
             <field name="view_mode">graph,pivot</field>
             <field name="context">{