Skip to Content
This question has been flagged
methodfunction_field
1 Respondre
8043 Vistes
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
Descartar
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

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
Descartar
Grf
Autor

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

Grf
Autor

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

Related Posts Respostes Vistes Activitat
Expected singleton Solved
method
Avatar
Avatar
Avatar
Avatar
9
de març 20
42921
Triggering method
method
Avatar
Avatar
2
d’oct. 18
4684
adding lines without overwriting existing
method
Avatar
Avatar
1
d’oct. 17
5008
i want to write in database
method
Avatar
Avatar
1
de març 15
5426
Write method
method
Avatar
Avatar
Avatar
2
de març 15
7596