one2one relational field is deprecated in OpenERP version>5 but you can achieve the same using many2one relational field. You can achieve it in following two ways :
1) using many2one field in both the objects (http://tutorialopenerp.wordpress.com/2014/04/23/one2one/)
2) using inheritance by deligation
You can easily find the first solution with little search over internet so let's start with 2nd solution.
Scenario :
I want to create a one2one relation between two objects of openerp
hr.employee
and
hr.employee.medical.details
What I should do
i. Add _inherits section in hr_employee class
ii. Add field medical_detail_id in hr_employee class
class hr_employee(osv.osv):
_name = 'hr.employee'
_inherits = {'hr.employee.medical.details': "medical_detail_id"}
_inherit = 'hr.employee'
_columns = {
'emp_code':fields.char('Employee Code', size=6, readonly=True),
'medical_detail_id':fields.many2one('hr.employee.medical.details', 'Medical
Details',help="Link this employee to it's medical details", ondelete="cascade", required=True),
Details',help="Link this employee to it's medical details", ondelete="cascade", required=True),
............
}
You don't have to do anything with 'hr.employee.medical.details' object
iii. Add fields in hr_employee_view.xml file
<group col="4" string="Medical Details">
<field name="medical_detail_id" invisible="1" required="0" colspan="4" />
<field name="blood_group" />
<field name="medicine" />
<field name="medicine_desc" />
<field name="allergies" />
<field name="allergies_desc" />
</group>
and you are done. It will create exactly one record each employee entry in
hr.employee.medical.details table.
Please let me know if you are facing any issue to implement it.
hr.employee.medical.details table.
Please let me know if you are facing any issue to implement it.
Thanks!!!!!!!!!!!!!!!! Enjoy Programming :)
hello , first of all thank you for this tuto,
ReplyDeleteI am trying to do the same thing except I inversed the roles so I have a hr.employee and a physician class ,
I added _inherits section in physician class and field employee_id in physician class,
but I'm gettinh en error while creating new records
any suggestions?!
Which Odoo version you are using.....OpenERP 7.0 or Odoo 8.0? Above mentioned workaround works only in version 7.0 and doesn't support version 8.
DeleteFirstly i would say this is an awesome blog for odoo. I have a custom module which imports employee, salary details that i have already in a csv file, now i want these details to refelct in hr, accounting module instead of manually creating a pay slip. I want the salary details in my file be reflected to employee payslip.
ReplyDeleteIn fact we already have a software for computing the salary, so we want to bypass the salary computation in odoo.
Help me out
thanks.
Hi Anilraj, For custom module development best approach in Odoo is to connect your functions with already running functionality of Odoo. In your case, try to make a salary related entry from Odoo and check how the flow/control is going and then override those functions in your module. You can change salary calculation by overriding it's function. Hope you got it!
DeleteVery Good!
ReplyDeleteUsefull!!!
I used this as a reference for create withholdings one2one per invoice!
Thanks a lot!
Hi, I've added 3 fields in "HR>Employee" and same three fields in "Project > Task", so now I want; when I will select an employee from "cust_uname" field
ReplyDeletefrom "Project > Task"; then 'Bill ID' and 'E-mail' field will get data automaticaly. Is that possible? so please
help!
+ Human Resource > Employee
In xml file:
hr.employee.view.form.inherit.familyinfo
hr.employee
In .py file:
class res_partner(osv.osv):
_name = 'hr.employee'
_inherit = 'hr.employee'
_columns = {
'cust_uname':fields.char('User Name'),
'cust_bill_id':fields.char('Bill ID'),
'cust_mail':fields.char('E-mail'),
}
Hi, I've added 3 fields in "HR>Employee" and same three fields in "Project > Task", so now I want; when I will select an employee from "cust_uname" field
ReplyDeletefrom "Project > Task"; then 'Bill ID' and 'E-mail' field will get data automaticaly. Is that possible? so please
help!
+ Human Resource > Employee
In xml file:
hr.employee.view.form.inherit.familyinfo
hr.employee
In .py file:
class res_partner(osv.osv):
_name = 'hr.employee'
_inherit = 'hr.employee'
_columns = {
'cust_uname':fields.char('User Name'),
'cust_bill_id':fields.char('Bill ID'),
'cust_mail':fields.char('E-mail'),
}
Yes, you can achieve this using on_change even handler in Odoo. http://www.odoo.yenthevg.com/on_change-event-in-odoo-8/
DeleteNow, in 2019, how this can be done in Odoo 12?
ReplyDeleteSeems like you are fond of writing since a long, therefore your posted content is well formulated in a proper way of writing. It's an amazing experience to read your blog post as you have shared a piece of meaningful and required information with the use of proper statics and beautiful words. Thanks for sharing!!
ReplyDeleteHire Odoo developers India
Thanks for sharing the article.
ReplyDeleteNice post and feel good to read.
ReplyDelete