代码之家 › 专栏 › 技术社区 › Developer Marius Å½ilÄnas

按res合作伙伴类别的Odoo销售报告管道过滤器

odoo-10 odoo report pivot python

Developer Marius Å½ilÄnas · 技术社区 · 6 年前

在里面 Sales -> Reports -> Pipeline 我想允许按res.partner进行筛选。类别

在奥多 res.partner 有一个字段 category_id

category_id = fields.Many2many('res.partner.category', column1='partner_id',
                                column2='category_id', string='Tags', default=_default_category)

我试着复制

category_id = fields.Many2many('res.partner.category', column1='partner_id',
                                column2='category_id', string='Tags', default=_default_category)` to my crm_opportunity_report (that has inherited crm.opportunity.report) but I get errors.

已尝试添加字段

category_ids = fields.Many2many(comodel_name='res.partner.category', relation="res_partner_res_partner_category_rel",
                                column1='category_id', column2='partner_id')

这也失败了。

如何将类别名称作为筛选器添加到crm\u opportunity\u报告中?如何允许按类别过滤?

1 回复 | 直到 6 年前

Developer Marius Å½ilÄnas 6 年前

这里有一些解决方案(基于讨论:参见对问题的评论)。它生成一个字符串(“'Tagname1';'Tagname2';'Tagname3';…”)从要筛选的标记名。

             SELECT                        
                        c.id,
                        c.name as name,
                        c.date_deadline,

                        c.date_open as opening_date,
                        c.date_closed as date_closed,
                        c.date_last_stage_update as date_last_stage_update,

                        c.user_id,
                        c.probability,
                        c.stage_id,
                        stage.name as stage_name,
                        c.type,
                        c.company_id,
                        c.priority,
                        c.team_id,
                        (SELECT COUNT(*)
                         FROM mail_message m
                         WHERE m.model = 'crm.lead' and m.res_id = c.id) as nbr_activities,
                        c.active,
                        c.campaign_id,
                        c.source_id,
                        c.medium_id,
                        c.partner_id,
                        c.city,
                        c.country_id,
                        c.planned_revenue as total_revenue,
                        c.planned_revenue*(c.probability/100) as expected_revenue,
                        c.create_date as create_date,
                        extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as  delay_close,
                        abs(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,
                        c.lost_reason,
                        c.date_conversion as date_conversion,

                        COALESCE(rp.customer, FALSE) as is_customer,
                        COALESCE(x.Categories, '') AS Categories

                    FROM
                        "crm_lead" c

                    LEFT JOIN "res_partner" rp ON rp.id = c.partner_id
                    LEFT JOIN "crm_stage" stage ON stage.id = c.stage_id
                    LEFT JOIN
                    (
SELECT rp.id AS partner_id, array_to_string(array_agg(''''||rpc.name||'''' ORDER BY rp.id, rpc.name),';') AS Categories
  FROM res_partner_res_partner_category_rel rpcl 
  JOIN res_partner_category rpc ON rpc.id = rpcl.category_id
  JOIN res_partner rp ON rp.id = rpcl.partner_id  
  GROUP BY rp.id
  ORDER BY rp.id

  ) AS x ON x.partner_id = c.partner_id

                    GROUP BY c.id, stage.name, COALESCE(rp.customer, FALSE), COALESCE(x.Categories, '')
                    ORDER BY c.partner_id