Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Add records in existing one2many field using wizard

wizard one2many records

2 Răspunsuri

22796 Vizualizări

Chints

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

Cel mai bun răspuns

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!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
How to open wizard from "Add a line" link of One2many field? wizard one2many	1 iun. 24	443
One2many through wizard, (without errors, but no add to the record) wizard one2many	1 feb. 16	5823
one2many field change number of records value Rezolvat one2many records record_rules	1 sept. 23	4383
One2many field on wizard opens by itself wizard one2many print	1 sept. 23	2933
Insert One2many in wizard, TransientModel Rezolvat wizard one2many transientmodel	2 sept. 24	14296

Această întrebare a fost marcată

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