Skip ke Konten
Pertanyaan ini telah diberikan tanda
methodfunction_field
1 Balas
8057 Tampilan
Avatar
Grf
0

I have this function that calculates qty_incoming, but there is an outgoing_qty field that I want to calculate with the same function and not to create separate function for its calculation. how can I do this?

 _columns = {
            '
            'incoming_qty': fields.function(_product_inc_out_qty, type='float',
                digits_compute=dp.get_precision('Product Unit of Measure'),
                string='Incoming'
            ),
            'outgoing_qty': fields.function(_product_inc_out_qty, type='float',
                digits_compute=dp.get_precision('Product Unit of Measure'),
                string='Outgoing'
            ),
        }

function:

def _product_inc_out_qty(self, cr, uid, ids, field_names=None, arg=False, context=None):
        if context is None:
            context = {}

        res = {}
        for move_id in ids:
            move = self.browse(cr, uid, move_id, context=context)

            res[move.id] = move.product_id.incoming_qty or 0.0
        return res



if I do something like this, then I get error TypeError: float() argument must be a string or a number


def _product_inc_out_qty(self, cr, uid, ids, field_names=None, arg=False, context=None):
        if context is None:
            context = {}

        res = {}
        vals = {
            'outgoing_qty': 0.0,
            'incoming_qty': 0.0,


        }
        for move_id in ids:
            move = self.browse(cr, uid, move_id, context=context)
            vals['outgoing_qty'] = move.product_id.qty_available or 0.0
            vals['incoming_qty'] = move.product_id.incoming_qty or 0.0
            res[move.id] = vals

        return res

Avatar
Buang
Avatar
Niyas Raphy (Walnut Software Solutions)
Jawaban Terbai

Hi,

In the sales module you can see similar sample in which for multiple field values are computed using the same function, have a look at those function and you can update your case.


See the sample:

amount_tax = fields.Monetary(string='Taxes', store=True, readonly=True, compute='_amount_all')
amount_total = fields.Monetary(string='Total', store=True, readonly=True, compute='_amount_all', track_visibility='always', track_sequence=6)

Compute function: 

@api.depends('order_line.price_total')
def _amount_all(self):
    """
    Compute the total amounts of the SO.
    """
    for order in self:
        amount_untaxed = amount_tax = 0.0
        for line in order.order_line:
            amount_untaxed += line.price_subtotal
            amount_tax += line.price_tax
        order.update({
            'amount_untaxed': amount_untaxed,
            'amount_tax': amount_tax,
            'amount_total': amount_untaxed + amount_tax,
        })


You can see same code in v8 here in this file: https://github.com/odoo/odoo/blob/8.0/addons/sale/sale.py

Thanks

Avatar
Buang
Grf
Penulis

I updated my question, I tried something similar but getting error

Grf
Penulis

TypeError: float() argument must be a string or a number

Post Terkait Replies Tampilan Aktivitas
Expected singleton Diselesaikan
method
Avatar
Avatar
Avatar
Avatar
9
Mar 20
42931
Triggering method
method
Avatar
Avatar
2
Okt 18
4700
adding lines without overwriting existing
method
Avatar
Avatar
1
Okt 17
5021
i want to write in database
method
Avatar
Avatar
1
Mar 15
5439
Write method
method
Avatar
Avatar
Avatar
2
Mar 15
7605