如何将值从one2many下拉数据绑定到odoo 12中的列字段? [英] How to bind value from one2many dropdown data to column field in odoo 12?

问题描述

我试图从one2many下拉关系中将名为"price"的字段添加到父表中，这是我将第二个表与many2one关系相关联吗?我可以这样做吗?如果是，该怎么做?

这是我的销售订单类代码:

# -*- coding: utf-8 -*-

from odoo import models, fields, api

class SalesorderSalesorder(models.Model):
    _name = 'salesorder.salesorder'

    no_faktur = fields.Char(String='No Faktur', required=True)
    kd_dealer = fields.Char(String='Kode Dealer', required=True)
    nm_dealer = fields.Char(String='Nama Dealer', required=True)
    tanggal_faktur = fields.Datetime(string='Tgl Faktur', default=fields.Datetime.now())
    keterangan = fields.Html(string='Keterangan')
    kd_sales = fields.Many2one('res.users', string='Kode Sales')
    details = fields.One2many('salesorderdetails','no_faktur','List Item')

这是我的salesorderdetails:

# -*- coding: utf-8 -*-

from odoo import models, fields, api

class SalesOrderDetails(models.Model):
    _name = 'salesorderdetails'

    no_faktur = fields.Many2one('salesorder.salesorder')
    kd_produk = fields.Many2one('ms_produk.ms_produk','Kode Produk',required=True)
    nm_produk = fields.Char(String='Nama Produk', required=True)
    qty = fields.Integer(String='Qty', required=True)
    price= fields.Float(String='Price', required=True)
    subtotal = fields.Float('Subtotal (Rp)', readonly=True, compute='compute_subtotal', store=True)

    @api.one
    @api.depends('qty', 'price')
    def compute_subtotal(self):
        if self.qty and self.price:
            qty = self.qty
            price = self.price
            self.subtotal = qty * price

我如何更新此行

Price= fields.Float(String='Price', required=True)

在此"ms_produk.ms_produk"表中也已经有一个名为Price的值吗?

解决方案

do you mean you want to update the price in salesorderdetails and refer to ms_produk.ms_produk? 如果是这样，您可以签出正式文件.

相关字段

计算字段的特殊情况是相关(代理)字段，它们提供当前记录中子字段的值.它们是通过设置相关参数来定义的，并且像常规计算字段一样可以存储: 使用相关属性可以达到目的.

 nickname = fields.Char(related='user_id.partner_id.name', store=True)
 

当您确认kd_produk中的项目时， 它将自动从中加载数据.

 Price= fields.Float(String='Price', required=True, related='kd_produk.price')
 

i trying to add field named "price" from one2many dropdown relationship to the parent table, which is i relate the second table with many2one relationship? can i do this? if yes, how to do this?

here is my salesorder class code :

# -*- coding: utf-8 -*-

from odoo import models, fields, api

class SalesorderSalesorder(models.Model):
    _name = 'salesorder.salesorder'

    no_faktur = fields.Char(String='No Faktur', required=True)
    kd_dealer = fields.Char(String='Kode Dealer', required=True)
    nm_dealer = fields.Char(String='Nama Dealer', required=True)
    tanggal_faktur = fields.Datetime(string='Tgl Faktur', default=fields.Datetime.now())
    keterangan = fields.Html(string='Keterangan')
    kd_sales = fields.Many2one('res.users', string='Kode Sales')
    details = fields.One2many('salesorderdetails','no_faktur','List Item')

and here is my salesorderdetails :

# -*- coding: utf-8 -*-

from odoo import models, fields, api

class SalesOrderDetails(models.Model):
    _name = 'salesorderdetails'

    no_faktur = fields.Many2one('salesorder.salesorder')
    kd_produk = fields.Many2one('ms_produk.ms_produk','Kode Produk',required=True)
    nm_produk = fields.Char(String='Nama Produk', required=True)
    qty = fields.Integer(String='Qty', required=True)
    price= fields.Float(String='Price', required=True)
    subtotal = fields.Float('Subtotal (Rp)', readonly=True, compute='compute_subtotal', store=True)

    @api.one
    @api.depends('qty', 'price')
    def compute_subtotal(self):
        if self.qty and self.price:
            qty = self.qty
            price = self.price
            self.subtotal = qty * price

how do i update this line

Price= fields.Float(String='Price', required=True)

with a value named Price too that i already have in this 'ms_produk.ms_produk' table?

解决方案

do you mean you want to update the price in salesorderdetails and refer to ms_produk.ms_produk? if so, you can check out official document.

Related fields

A special case of computed fields are related (proxy) fields, which provide the value of a sub-field on the current record. They are defined by setting the related parameter and like regular computed fields they can be stored: use related attribute can attain this.

nickname = fields.Char(related='user_id.partner_id.name', store=True)

while you confirm the item in kd_produk, it will auto load data form it.

Price= fields.Float(String='Price', required=True, related='kd_produk.price')

这篇关于如何将值从one2many下拉数据绑定到odoo 12中的列字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！