All Posts People Badges

Ključne besede (View all)

About this forum

Pomoč

Add records in existing one2many field using wizard

wizard one2many records

2 Odgovori

24673 Prikazi

Chintan Panchal

Hello everyone,

My doubt is what I am trying to do is, I have one2many field named `salary_ids` in my module like this :

salary_ids = fields.One2many('team.salary', 'employee_id', 'Salaries')

And inverse model employee_id like this:

class Salary(models.Model):
    _name = 'team.salary'
    _description = 'Salary'

    month = fields.Selection([(str(ele), str(ele)) for ele in range(1, 13)], 'Month')
    basic = fields.Float('Basic', tracking=True)
    allowance = fields.Float('Allowance')
    deduction = fields.Float('Deduction', tracking=True)
    employee_id = fields.Many2one('team.team', 'Employee')
    # employee_id = fields.Many2one('team.team', 'Employee', ondelete='cascade')
    gross_sal = fields.Float('Gross', compute='_calc_net_gross')
    net_sal = fields.Float('Net', compute='_calc_net_gross')

Now I want to add new records using wizard for this one2many fields so that when I select new month new basic and all it will added to that particular employees. I am not trying to update existing records but add new records to it. How can I??

Below is what I have tried so for using wizard.

class UpdateSalary(models.TransientModel):

    _name = 'update.sal'
    _description = 'Update Salaries for Particular employee'

    salary_id = fields.Many2one('team.salary')
    # salary_ids = fields.One2many('team.salary', 'employee_id', 'Salaries')
    employee_id = fields.Many2one('team.team', 'Employee')
    month = fields.Selection([(str(ele), str(ele)) for ele in range(1, 13)], 'Month')
    basic = fields.Float('Basic', tracking=True)
    allowance = fields.Float('Allowance')
    deduction = fields.Float('Deduction', tracking=True)

    def update_sal(self):
        """
        Add salary record for particular employee
        """
        print("salary_id: ", self.salary_id)
        print('self.env.context', self.env.context)

Kartik Patel

Best Answer

Hello,

First you need to create a record of team.salary from the wizard and then add that record into one2many field of respective model.

Please look the below code.

def update_sal(self):

"""

Add salary record for particular employee

"""

team_salary_id = self.env['team.salary'].create({

'employee_id': self.employee_id,

'month': self.month,

'basic': self.basic,

'allowance': self.allowance,

'deduction': self.deduction,

})

# now you need to add above created team_salary record in respective model where you need to update its one2many(i.e salary_ids) field.

self.env['your_model'].write({'

'salary_ids': [(4, team_salary_id.id)] # link to existing record with id = ID (adds a relationship)

'})

All the Best,

Thanks.

Hilar Andikkadavath

These are the flags which is used for updating Odoo One2many or Many2many fields.

(0, 0, { values }) link to a new record that needs to be created with the given values dictionary

(1, ID, { values }) update the linked record with id = ID (write values on it)

(2, ID) remove and delete the linked record with id = ID (calls unlink on ID, that will delete the object completely, and the link to it as well)

(3, ID) cut the link to the linked record with id = ID (delete the relationship between the two objects but does not delete the target object itself)

(4, ID) link to existing record with id = ID (adds a relationship)

(5) unlink all (like using (3,ID) for all linked records)

(6, 0, [IDs]) replace the list of linked IDs (like using (5) then (4,ID) for each ID in the list of IDs)

Here is an example that updates seller one2many with details.

self.product_service.write({'seller_ids': [
    (0, 0, {'name': self.asustec.id, 'product_code': 'ASUCODE'}),
    (0, 0, {'name': self.camptocamp.id, 'product_code': 'C2CCODE'}),
]})

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi

Related Posts	Odgovori	Prikazi
How to open wizard from "Add a line" link of One2many field? wizard one2many	1 jun. 24	443
One2many through wizard, (without errors, but no add to the record) wizard one2many	1 feb. 16	6895
one2many field change number of records value Solved one2many records record_rules	1 sep. 23	5289
One2many field on wizard opens by itself wizard one2many print	1 sep. 23	3757
Insert One2many in wizard, TransientModel Solved wizard one2many transientmodel	2 sep. 24	15784

This question has been flagged

Enjoying the discussion? Don't just read, join in!