Employee to an other model

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Employee to an other model

accounting employee payslip odoo8.0

1 Odpowiedz

4010 Widoki

wizardz

I want to put the employee name to the 'account.analytic.line' model.

For that I need to go to 'hr.payslip' and get the "number" field value. With this value I need to compare this value to the 'account.analytic.line' "ref" field value. So that I know to wich record what employee is set.

step:

compare hr.payslip(number) with account.analytic.line(number)

Then get the employee name and put that in the account.analytic.line(testing) - new field.

This is my code:

from openerp import models, fields, api, osv
from openerp.http import requestfrom openerp import SUPERUSER_ID

class account_analytic_line(models.Model):
    _inherit = ['account.analytic.line']
     testing = fields.Integer(compute="employee")

     @api.one
     def employee(self):
         cr, uid, context, pool = request.cr, request.uid, request.context, request.cr
         model_obj = self.pool.get('hr.payslip')
         test = self.env['account.analytic.line']
         #record = model_obj.browse(cr, uid, your id, context = context)
         rec_ids = model_obj.search(cr, uid, [(test.ref, '=', 'number')], context=context)
         for record in model_obj.browse(cr, uid, rec_ids, context=context):
             record.ref
             print record.ref

The final result should be, that the employee should be on the account.analytic.line.

Martin Varela

Najlepsza odpowiedź

Try this:

class account_analytic_line(models.Model):
    _inherit = ['account.analytic.line']    
    testing = fields.Char(compute='_get_employee')
    
    @api.depends('ref')
    def _get_employee(self):
        for record in self:
            payslip_obj = self.env['hr.payslip']
            payslip = payslip_obj.search([('number', '=', record.ref)], limit=1)
            if payslip:
                record.testing = payslip.employee_id.name
            else:
                record.testing = False

wizardz

Autor

amazing thank you !

wizardz

Autor

how can I put this on the tree view ?

wizardz

Autor

ValueError

Expected singleton: account.analytic.line(3713, 3714, 3715, 3755, 3873, 3746, 3747, 3748, 3749, 3750, 3879, 3752, 3881, 3882, 3883, 3837, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3794, 3875, 3876, 3877, 3835, 3878, 3751, 3831, 3880, 3795, 3829, 3830, 3753, 3832, 3833, 3834, 3874, 3836, 3754, 3838, 3839)

Martin Varela

I changed the code:

record.ref (before was self.ref that was wrong)

record.testing (before was self.testing that was wrong)

wizardz

Autor

thank you Martin! what was the problem before?

Martin Varela

self is the entire recordset, in tree view are all the lines. In form view worked because it´s only one record. The correct way is to define a loop for each record (for record in self:) and calculate it´s value. The previous answer was wrong because in your tree view self was account.analytic.line(3713, 3714, 3715, 3755, 3873,...) and you can´t ask for a value of multiple records at one time (self.ref).

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to put employee in other model. development accounting payslip odoo8.0	1 wrz 16	4302
Pay slip generation odoo 8 payslip odoo8.0	0 gru 16	2989
Custom Field Calculation accounting employee timesheets	1 cze 24	1704
How get each line value from hr.salary.rule of every employe on hr.payslip model ? employee payslip salary_rule	0 mar 23	2348
How to geenrate employee pay from Payroll ? v14 Rozwiązane accounting payroll payslip	1 gru 20	2429

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!