diff options
| author | Pratima Gupta <pgu@odoo.com> | 2018-09-17 10:20:37 +0530 |
|---|---|---|
| committer | Thibault Delavallée <tde@odoo.com> | 2018-09-19 13:17:42 +0200 |
| commit | 8eec468c19e40db23c8a5c5ff03e3da7a0af382f (patch) | |
| tree | 95e612ffa3960abb109fe71a544efed55452ef83 /addons/website_crm_partner_assign/report | |
| parent | a6ad87a4d9604af20d6f15231b03849d2ae5fefb (diff) | |
[REF] website_crm_partner_assign: remove crm.lead.report.assign report
As all information present in this report can be found in the opportunities
dashboard this report can be removed.
This commit is related to task #1878516 and PR #26929 .
Diffstat (limited to 'addons/website_crm_partner_assign/report')
3 files changed, 0 insertions, 138 deletions
diff --git a/addons/website_crm_partner_assign/report/__init__.py b/addons/website_crm_partner_assign/report/__init__.py index f511955e14f..98897a641f1 100644 --- a/addons/website_crm_partner_assign/report/__init__.py +++ b/addons/website_crm_partner_assign/report/__init__.py @@ -1,5 +1,4 @@ # -*- coding: utf-8 -*- # Part of Odoo. See LICENSE file for full copyright and licensing details. -from . import crm_lead_report from . import crm_partner_report diff --git a/addons/website_crm_partner_assign/report/crm_lead_report.py b/addons/website_crm_partner_assign/report/crm_lead_report.py deleted file mode 100644 index 4ab819746f7..00000000000 --- a/addons/website_crm_partner_assign/report/crm_lead_report.py +++ /dev/null @@ -1,76 +0,0 @@ -# -*- coding: utf-8 -*- -# Part of Odoo. See LICENSE file for full copyright and licensing details. - -from odoo import api, fields, models -from odoo import tools -from odoo.addons.crm.models import crm_stage - - -class CrmLeadReportAssign(models.Model): - """ CRM Lead Report """ - _name = "crm.lead.report.assign" - _auto = False - _description = "CRM Lead Report" - - partner_assigned_id = fields.Many2one('res.partner', 'Partner', readonly=True) - grade_id = fields.Many2one('res.partner.grade', 'Grade', readonly=True) - user_id = fields.Many2one('res.users', 'User', readonly=True) - country_id = fields.Many2one('res.country', 'Country', readonly=True) - team_id = fields.Many2one('crm.team', 'Sales Team', oldname='section_id', readonly=True) - company_id = fields.Many2one('res.company', 'Company', readonly=True) - date_assign = fields.Date('Assign Date', readonly=True) - delay_open = fields.Float('Delay to Assign', digits=(16, 2), readonly=True, group_operator="avg", help="Number of Days to open the case") - delay_close = fields.Float('Delay to Close', digits=(16, 2), readonly=True, group_operator="avg", help="Number of Days to close the case") - delay_expected = fields.Float('Overpassed Deadline', digits=(16, 2), readonly=True, group_operator="avg") - probability = fields.Float('Avg Probability', digits=(16, 2), readonly=True, group_operator="avg") - probability_max = fields.Float('Max Probability', digits=(16, 2), readonly=True, group_operator="max") - planned_revenue = fields.Float('Planned Revenue', digits=(16, 2), readonly=True) - probable_revenue = fields.Float('Probable Revenue', digits=(16, 2), readonly=True) - tag_ids = fields.Many2many('crm.lead.tag', 'crm_lead_tag_rel', 'lead_id', 'tag_id', 'Tags') - partner_id = fields.Many2one('res.partner', 'Customer', readonly=True) - opening_date = fields.Datetime('Opening Date', readonly=True) - date_closed = fields.Datetime('Close Date', readonly=True) - nbr_cases = fields.Integer('# of Cases', readonly=True, oldname='nbr') - priority = fields.Selection(crm_stage.AVAILABLE_PRIORITIES, 'Priority') - type = fields.Selection([ - ('lead', 'Lead'), - ('opportunity', 'Opportunity') - ], 'Type', help="Type is used to separate Leads and Opportunities") - - @api.model_cr - def init(self): - """ - CRM Lead Report - @param cr: the current row, from the database cursor - """ - tools.drop_view_if_exists(self._cr, 'crm_lead_report_assign') - self._cr.execute(""" - CREATE OR REPLACE VIEW crm_lead_report_assign AS ( - SELECT - c.id, - c.date_open as opening_date, - c.date_closed as date_closed, - c.date_assign, - c.user_id, - c.probability, - c.probability as probability_max, - c.type, - c.company_id, - c.priority, - c.team_id, - c.partner_id, - c.country_id, - c.planned_revenue, - c.partner_assigned_id, - p.grade_id, - p.date as partner_date, - c.planned_revenue*(c.probability/100) as probable_revenue, - 1 as nbr_cases, - c.create_date as create_date, - extract('epoch' from (c.write_date-c.create_date))/(3600*24) as delay_close, - extract('epoch' from (c.date_deadline - c.date_closed))/(3600*24) as delay_expected, - extract('epoch' from (c.date_open-c.create_date))/(3600*24) as delay_open - FROM - crm_lead c - left join res_partner p on (c.partner_assigned_id=p.id) - )""") diff --git a/addons/website_crm_partner_assign/report/crm_lead_report_view.xml b/addons/website_crm_partner_assign/report/crm_lead_report_view.xml deleted file mode 100644 index 409b3291223..00000000000 --- a/addons/website_crm_partner_assign/report/crm_lead_report_view.xml +++ /dev/null @@ -1,61 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> -<odoo> - - <!-- Opportunity tree view --> - <record id="view_report_crm_lead_assign_filter" model="ir.ui.view"> - <field name="name">crm.lead.report.assign.select</field> - <field name="model">crm.lead.report.assign</field> - <field name="arch" type="xml"> - <search string="Leads Analysis"> - <field name="team_id" context="{'invisible_team': False}"/> - <field name="grade_id"/> - <field name="user_id"/> - <field name="partner_assigned_id"/> - <group expand="0" string="Extended Filters..."> - <field name="partner_id"/> - <separator/> - <field name="company_id" options="{'no_create': True}" groups="base.group_multi_company"/> - <field name="opening_date"/> - <field name="date_closed"/> - </group> - <group expand="1" string="Group By"> - <filter string="Salesperson" name="user" - context="{'group_by':'user_id'}" /> - <filter string="Sales Team" name="sales_channel" context="{'group_by':'team_id'}"/> - <filter string="Country" name="country" context="{'group_by':'country_id'}" /> - <filter string="Company" name="company" context="{'group_by':'company_id'}" /> - <separator/> - <filter string="Assign Date" name="assign_month" context="{'group_by':'date_assign:month'}"/> - </group> - </search> - </field> - </record> - -<!-- Crm Lead Assign report pivot View --> - - <record id="view_report_crm_lead_assign_pivot" model="ir.ui.view"> - <field name="name">crm.lead.assign.pivot</field> - <field name="model">crm.lead.report.assign</field> - <field name="arch" type="xml"> - <pivot string="Lead Assign" disable_linking="True"> - <field name="date_assign" interval="month" type="col"/> - <field name="delay_open" type="measure"/> - <field name="probability" type="measure"/> - </pivot> - </field> - </record> - -<!-- Crm Lead Assign report Graph View --> - - <record id="view_report_crm_lead_assign_graph" model="ir.ui.view"> - <field name="name">crm.lead.assign.graph</field> - <field name="model">crm.lead.report.assign</field> - <field name="arch" type="xml"> - <graph string="Lead Assign"> - <field name="date_assign"/> - <field name="delay_open" type="measure"/> - </graph> - </field> - </record> - -</odoo> |
