Performing arithmetic on fields

onchange Interest

2 Replies

6165 Tampilan

Arjun Khode

Hi, I'm trying to write a module that calculates interest on a certain principal amount given a rate of interest, and displays the new amount to be returned in a field.

This is my python code:

class record(osv.Model):
    _name="record"
    _columns={
              'investment_id':fields.many2one('investment.model','Name of Investment'),
              'investor_id':fields.many2one('res.partner','Investor Name'),
              'start_date':fields.date('Start Date'),
              #'end_date':fields.date('End Date'),
              'amount':fields.float('Amount Paid'),
              'roi':fields.float('Rate of Interest in fraction'),
              'returns':fields.float('Amount to be returned')
              }

I want 'returns' field to be like: returns=amount+amount*roi

Here is my XML:

<record id="record_form_view" model="ir.ui.view">
            <field name="name">record.form.view</field>
            <field name="view_type">form</field>
            <field name="model">record</field>
            <field name="arch" type="xml">
                <form string="Record">
                <group>
                    <field name="investment_id"/>
                    <field name="investor_id"/>
                    <field name="start_date"/>
                    
                    <field name="roi"/>
                    <field name="amount"/>
                    <field name="returns"/>
                    
                    <button name="%(register_payment_button_action)d" string="Register Payment" type="action"/>
                    <button name="%(pay_investor_button_action)d" string="Pay Investor" type="action"/>

                </group>
                </form>
               </field>
        </record>

How to write or modify my code so that it will calculate the 'returns' field?
I also want to display the updated value of return.

Arjun Khode

Penulis Jawaban Terbai

Thankyou Cyril. The solution is perfect. This solved a big problem of mine.

Also, there were two parantheses missing but I added them.

Here's the code with correct parantheses:

import openerp.addons.decimal_precision as dp
from openerp.osv import orm

class record(orm.Model):
_name="record"

    def _amount_returns(self, cr, uid, ids, field, arg, context=None):

        context = context or {}

res = {}

for record in self.browse(cr, uid, ids, context=context):

            res[record.id] = (record.amount or 0.0) * (1 + (record.roi or 0.0))

        return res

    _columns={
              'investment_id':fields.many2one('investment.model','Name of Investment'),
              'investor_id':fields.many2one('res.partner','Investor Name'),
              'start_date':fields.date('Start Date'),
              #'end_date':fields.date('End Date'),
              'amount':fields.float('Amount Paid'),
              'roi':fields.float('Rate of Interest in fraction'),
              'returns':fields.function(_amount_returns, digits_compute=dp.get_precision('Account'), string='Amount to be returned',
            store={
                'record': (lambda self, cr, uid, ids, c={}: ids, ['amount', 'roi'], 10),
                   },)
              }

Cyril Gaspard (GEM)

Hi, no need to add a button for that, just use a field type function and a store parameter that depends of 2 fields you use to update the field returns when one of this 2 fields changes:

import openerp.addons.decimal_precision as dp

from openerp.osv import orm

class record(orm.Model):
_name="record"

def _amount_returns(self, cr, uid, ids, field, arg, context=None):

context = context or {}

res = {}

for record in self.browse(cr, uid, ids, context=context:

res[record.id] = (record.amount or 0.0) * (1 + (record.roi or 0.0))

return res

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
trying to auto correct a wrong users value onchange	1 Okt 23	3671
"Wrong value for %s: %r" % (self, value) Diselesaikan onchange	2 Okt 23	3994
How to add domain in onchange function for a One2many field Diselesaikan onchange	2 Agu 23	6267
How to create dynamic domain on many2one fields with onchange function? Diselesaikan onchange	4 Agu 23	22972
Odoo onchange method is not saving values in readonly fields Diselesaikan onchange	3 Okt 22	13453

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!