Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

How to keep multiple One2many fields on the same model [EDIT]

one2many relational duplication

2 ตอบกลับ

13657 มุมมอง

arthur

I opened a question yesterday (https://www.odoo.com/pt_BR/forum/help-1/question/how-to-keep-multiple-many2many-fields-on-the-same-model-145401) about how to have multiple Many2many fields. Now I am encountering the same problem with One2many fields, but can't get that right because I can't inform table_name as a relation.

My two models are the following:

class SubscriptionBasket(models.Model):

_name="subscription.basket"

name = fields.Char("Nome", required=True)

date_start = fields.Date("Data Inicial", required=True)

date_end = fields.Date("Data Final", required=True)

sales_applied = fields.One2many(

string=u'Vendas Aplicadas',

comodel_name='sale.order',

inverse_name='basket_id',

)

legumes = fields.One2many(

string=u'Legumes',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

)

frutas = fields.One2many(

string=u'Frutas',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

)

verduras = fields.One2many(

string=u'Verduras',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

)

temperos = fields.One2many(

string=u'Temperos',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

)

class SubscriptionBasketItem(models.Model):

_name = "subscription.basket.line"

name = fields.Char("Itens da Cesta")

basket_id = fields.Many2one(

string=u'Cesta',

comodel_name='subscription.basket',

)

product_id = fields.Many2one(

comodel_name='product.product',

string='Produto',

)

min_quantity = fields.Integer("Quantidade Mínima Disponível", default = 0)

When assigning different subscription.basket.line's to legumes fields to a subscription.basket record, for example, after creating the record all fields will have the same values, which is not the behavior I expect. How do I get this right on One2many fields, so each field will have its own list of subscription.basket.line itens?

As an example, I overwrote the create function to get logs:

@api.model

def create(self, vals):

_logger.info("Vals received on creation: %s", vals)

res = super(SubscriptionBasket, self).create(vals)

_logger.info("Field temperos.product_id on creation response: %s", res.temperos.product_d)

return res

Then, when creating a record, informing a product just to the fields "legumes", I get the following log for the vals I received:

Vals received on creation: {'date_end': '2019-02-06', 'name': 'Cesta', 'date_start': '2019-02-05', 'legumes': [[0, 'virtual_609', {'product_id': 1000, 'min_quantity': 0}]]}

And the following log for the field "temperos", which I would expect to be empty, on the creation response:

Field temperos.product_id on creation response: product.product(1000,)

La Jayuhni Yarsyah

คำตอบที่ดีที่สุด

Hi,,

maybe you can use related or compute fields

legumes = fields.One2many(
    string=u'Legumes',
    comodel_name='subscription.basket.line',
    inverse_name='basket_id',
)
frutas = fields.One2many(
    string=u'Frutas',
    comodel_name='subscription.basket.line',
    related="legumes",
)
verduras = fields.One2many(
    string=u'Verduras',
    comodel_name='subscription.basket.line',
    compute="_compute_value"
)
temperos = fields.One2many(
    string=u'Temperos',
    comodel_name='subscription.basket.line',
    compute="_compute_value"
)

def _compute_value(self):
    for rec in self:
        rec.temperos = rec.legumes

arthur

ผู้เขียน

Sorry, I think that I miss explained myself. Fields containing always the same values is the current behavior, but is not what I expect. My intent is to each field to have its own list of "subscription.basket.line" itens.

La Jayuhni Yarsyah

So you must define some unique criteria to identify the record based on those fields wich related to subscription.basket.line

For ex:

class SubscriptionBasketItem(models.Model):

_name = "subscription.basket.line"

# **** Your fields

data_type = fields.Selection([('legumes','Legumes'), ('frutas','Frutas'), ('verduras','Verduras'), ('temperos','Temperos')], required=True, string="Some Type")

then you can write normal one2many fields like this in SubscriptionBasket model

legumes = fields.One2many(

string=u'Legumes',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

domain=[('data_type','=','legumes')]

)

frutas = fields.One2many(

string=u'Frutas',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

domain=[('data_type','=','frutas')]

)

verduras = fields.One2many(

string=u'Verduras',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

domain=[('data_type','=','verduras')]

)

temperos = fields.One2many(

string=u'Temperos',

comodel_name='subscription.basket.line',

inverse_name='basket_id',

domain=[('data_type','=','temperos')]

)

and in view.xml maybe you can pass a default field context

for example

Regards

La Jayuhni Yarsyah

arthur

ผู้เขียน

I worked just as I wanted, thank you! If you past this last comment on an answer bellow, I will be glad to mark it

Miguel Da Silva

Hello, you are from Brazil, right?

I to hire someone with Odoo Experience, are you interested?

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
How to prefill One2many -> Many2one ? แก้ไขแล้ว one2many relationship relational	1 ก.ย. 17	4963
How to prefill One2many -> Many2one ? one2many relationship relational	0 เม.ย. 16	9
One2many or Many2many fields Inherited model one2many inherit many2many relational	0 ก.พ. 21	4437
Adding relational fields แก้ไขแล้ว many2one one2many relational foreignkey	1 เม.ย. 18	6822
how pass value to on2many field from parent form via context one2many	1 ม.ค. 25	2736

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!