Odoo浮点字段未在树状图上显示值

Question

我在表单中添加了自定义浮动字段，并使用该字段在树状视图中显示

但实际上在表单内部，字段的计算值正确，工作正常，但在树状视图列中，所有记录的值都为0.00。。为什么?

以下是我的模型代码：

from odoo import models, fields, api

class PickingTotalQty(models.Model):
    _inherit = 'stock.picking'

    sum_dmd_qty = fields.Float(compute='calculate_dmd_qty', string='Total Demand Quantity')
    sum_reserved_qty = fields.Float(compute='calculate_reserved_qty', string='Total Reserved Quantity')
    reserved_qty_per = fields.Float(compute='calculate_reserved_per', string='Reserved (%)')

    def calculate_dmd_qty(self):
        for rs in self:
            dmdqty = 0
            for line in rs.move_lines:
                dmdqty += line.product_uom_qty
        rs.sum_dmd_qty = dmdqty

    def calculate_reserved_qty(self):
        for rs in self:
            reservedqty = 0
            for line in rs.move_lines:
                reservedqty += line.reserved_availability
        rs.sum_reserved_qty = reservedqty

    @api.depends('sum_reserved_qty', 'sum_dmd_qty')
    def calculate_reserved_per(self):
        for rec in self:
            if rec.sum_dmd_qty > 0:
                rec.reserved_qty_per = rec.sum_reserved_qty / rec.sum_dmd_qty

下面是XML视图代码：

<?xml version="1.0" encoding="utf-8"?>
<odoo>
    <data>
        <record id="inherit_stock_picking_form_view" model="ir.ui.view">
            <field name="name">Stock Picking</field>
            <field name="model">stock.picking</field>
            <field name="inherit_id" ref="stock.view_picking_form"/>
            <field name="arch" type="xml">
                <xpath expr="/form/sheet/notebook" position="after">
                    <group>
                        <group>
                            <field name="reserved_qty_per" nolabel="0"/>
                        </group>
                    </group>
                </xpath>
            </field>
        </record>
        <record id="inherit_stock_picking_tree_view2" model="ir.ui.view">
            <field name="name">Stock Picking2</field>
            <field name="model">stock.picking</field>
            <field name="inherit_id" ref="stock.vpicktree"/>
            <field name="arch" type="xml">
                <xpath expr="//field[@name='state']" position="after">
                      <field name="reserved_qty_per"/>
                </xpath>
            </field>
        </record>
    </data>
</odoo>

Answer 1

将为每个记录重新初始化sum值，并将其分配到for循环之外，除树状视图中的最后一条记录外，计算将不起作用。这些方法是用一个记录集调用的，在表单视图中，它是用一个只包含一条记录的记录集调用的，这就是为什么它在表单视图中工作而不是在树视图中工作的原因

要更正该问题，请在第一个循环中移动前两个方法的最后一行

缺少decorator，请尝试添加它

示例：

@api.depends("move_lines.product_uom_qty")
def calculate_dmd_qty(self):
    for rs in self:
        dmdqty = 0
        for line in rs.move_ids_without_package:
            dmdqty += line.product_uom_qty
        rs.sum_dmd_qty = dmdqty

@api.depends("move_lines.reserved_availability")
def calculate_reserved_qty(self):
    for rs in self:
        reservedqty = 0
        for line in rs.move_ids_without_package:
            reservedqty += line.reserved_availability
        rs.sum_reserved_qty = reservedqty

编辑：

<odoo>
    <record id="view_picking_form" model="ir.ui.view">
        <field name="name">view.picking.form</field>
        <field name="model">stock.picking</field>
        <field name="inherit_id" ref="stock.view_picking_form"/>
        <field name="arch" type="xml">
            <xpath expr='//notebook' position="after">
                <group>
                    <field name="reserved_qty_per"/>
                </group>
            </xpath>
        </field>
    </record>

    <record id="vpicktree" model="ir.ui.view">
        <field name="name">view.vpicktree</field>
        <field name="model">stock.picking</field>
        <field name="inherit_id" ref="stock.vpicktree"/>
        <field name="arch" type="xml">
            <field name="state" position="before">
                <field name="reserved_qty_per"/>
            </field>
        </field>
    </record>
</odoo>