You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 lines
1.2 KiB
40 lines
1.2 KiB
from odoo import models,fields,api,tools
|
|
|
|
|
|
class ProductBrand(models.Model):
|
|
_inherit = 'product.template'
|
|
|
|
brand_id = fields.Many2one('product.brand',string='Brand')
|
|
|
|
class BrandProduct(models.Model):
|
|
_name = 'product.brand'
|
|
|
|
name= fields.Char(String="Name")
|
|
brand_image = fields.Binary()
|
|
member_ids = fields.One2many('product.template','brand_id')
|
|
product_count = fields.Char(String='Product Count',compute='get_count_products',store=True)
|
|
|
|
@api.depends('member_ids')
|
|
def get_count_products(self):
|
|
self.product_count = len(self.member_ids)
|
|
|
|
class PurchaseBrandPivot(models.Model):
|
|
_inherit = 'purchase.report'
|
|
|
|
brand_id = fields.Many2one('product.brand',string='Brand')
|
|
|
|
|
|
def _select(self):
|
|
res = super(PurchaseBrandPivot,self)._select()
|
|
query = res.split('t.categ_id as category_id,',1)
|
|
rese = query[0] + 't.categ_id as category_id,t.brand_id as brand_id,' + query[1]
|
|
return rese
|
|
|
|
|
|
|
|
def _group_by(self):
|
|
res=super (PurchaseBrandPivot ,self)._group_by ()
|
|
query = res.split('t.categ_id,',1)
|
|
res = query[0] + 't.categ_id,t.brand_id,' + query[1]
|
|
print(res)
|
|
return res
|
|
|