diff options
Diffstat (limited to 'addons')
5 files changed, 0 insertions, 141 deletions
diff --git a/addons/website_crm_partner_assign/__manifest__.py b/addons/website_crm_partner_assign/__manifest__.py index 6e04f7cc535..eb615286506 100644 --- a/addons/website_crm_partner_assign/__manifest__.py +++ b/addons/website_crm_partner_assign/__manifest__.py @@ -31,7 +31,6 @@ The automatic assignation is figured from the weight of partner levels and the g 'views/res_partner_views.xml', 'views/crm_lead_views.xml', 'views/website_crm_partner_assign_templates.xml', - 'report/crm_lead_report_view.xml', 'report/crm_partner_report_view.xml', ], 'demo': [ 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> diff --git a/addons/website_crm_partner_assign/security/ir.model.access.csv b/addons/website_crm_partner_assign/security/ir.model.access.csv index 8f0f0c40dba..fa992b1efba 100644 --- a/addons/website_crm_partner_assign/security/ir.model.access.csv +++ b/addons/website_crm_partner_assign/security/ir.model.access.csv @@ -1,6 +1,4 @@ id,name,model_id:id,group_id:id,perm_read,perm_write,perm_create,perm_unlink -access_crm_lead_report_assign,crm.lead.report.assign,model_crm_lead_report_assign,sales_team.group_sale_salesman,1,1,1,0 -access_crm_lead_report_assign_all,crm.lead.report.assign.all,model_crm_lead_report_assign,base.group_user,1,0,0,0 access_crm_partner_report,crm.partner.report.assign.all,model_crm_partner_report_assign,sales_team.group_sale_salesman,1,0,0,0 access_res_partner_grade,res.partner.grade,model_res_partner_grade,sales_team.group_sale_salesman,1,1,1,0 access_res_partner_grade_employee,res.partner.grade,model_res_partner_grade,base.group_user,1,0,0,0 |