Employee to an other model

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

客户关系管理
e-Commerce
会计
库存
PoS
Project
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

Employee to an other model

accounting employee payslip odoo8.0

1 回复

4075 查看

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

最佳答案

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

编写者

amazing thank you !

wizardz

编写者

how can I put this on the tree view ?

wizardz

编写者

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

编写者

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).

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
How to put employee in other model. development accounting payslip odoo8.0	1 9月 16	4344
Pay slip generation odoo 8 payslip odoo8.0	0 12月 16	3040
Custom Field Calculation accounting employee timesheets	1 6月 24	1853
How get each line value from hr.salary.rule of every employe on hr.payslip model ? employee payslip salary_rule	0 3月 23	2458
How to geenrate employee pay from Payroll ? v14 已解决 accounting payroll payslip	1 12月 20	2482

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！