Skip to main content

Odoo/OpenERP: one2one relational field example

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

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.


Thanks!!!!!!!!!!!!!!!! Enjoy Programming :)

Comments

  1. hello , first of all thank you for this tuto,
    I 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?!

    ReplyDelete
    Replies
    1. 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.

      Delete
  2. Firstly 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.
    In fact we already have a software for computing the salary, so we want to bypass the salary computation in odoo.
    Help me out
    thanks.

    ReplyDelete
    Replies
    1. 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!

      Delete
  3. Very Good!
    Usefull!!!
    I used this as a reference for create withholdings one2one per invoice!
    Thanks a lot!

    ReplyDelete
  4. 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

    from "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'),
    }



    ReplyDelete
  5. 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

    from "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'),
    }




    ReplyDelete
    Replies
    1. Yes, you can achieve this using on_change even handler in Odoo. http://www.odoo.yenthevg.com/on_change-event-in-odoo-8/

      Delete
  6. Now, in 2019, how this can be done in Odoo 12?

    ReplyDelete
  7. Seems 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!!
    Hire Odoo developers India

    ReplyDelete
  8. Thanks for sharing the article.

    ReplyDelete
  9. Nice post and feel good to read.

    ReplyDelete

Post a Comment

Thanks for your valuable comments.

Popular posts from this blog

How to draw Dynamic Line or Timeseries Chart in Java using jfreechart library?

Today we are going to write a code to draw a dynamic timeseries-cum-line chart in java.   The only difference between simple and dynamic chart is that a dynamic event is used to create a new series and update the graph. In out example we are using timer which automatically calls a funtion after every 1/4 th second and graph is updated with random data. Let's try with the code : Note : I had tried my best to provide complete documentation along with code. If at any time anyone have any doubt or question please post in comments section. DynamicLineAndTimeSeriesChart.java import java.awt.BorderLayout; import java.awt.Color; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.Timer; import javax.swing.JPanel; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartPanel; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.ValueAxis; import org.jfree.chart.plot.XYPlot; import...

pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]

Recently, I faced this error in our Docker-Container environment. All the necessary packages were already installed but still, I was facing this clueless error. I search a bit and after an hour and so I found the exact reason and solution for this error. To know more about this error in detail. Please follow this Github thread. https://github.com/mkleehammer/pyodbc/issues/610 https://github.com/mkleehammer/pyodbc/issues/610#issuecomment-587523802 Solution: It's because the   server's certificate has too weak a key. In case you are using Linux env directly/not the Docker one.  Just edited /etc/ssl/openssl.cnf and change these 2 lines. MinProtocol = TLSv1.0 CipherString = DEFAULT@SECLEVEL=1 In case you are also using a container, please add these three lines to your Docker file. RUN chmod +rwx /etc/ssl/openssl.cnf RUN sed -i ' s/TLSv1.2/TLSv1/g ' /etc/ssl/openssl.cnf RUN sed -i ' s/SECLEVEL=2/SECLEVEL=1/g ' /etc/ssl/openssl.cnf Thanks!! Enjoy Programming! Refer...