Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How can I pass on an attribute to childs and then after various sub relations make a select for the "add" tab of a sub sub sub c

By
Sascha Pfeiffer
on 7/1/14, 3:52 AM 605 views

Hi,

thanks to all who are reading and trying to help. I have a very complicated structure of tables and relation but it looks like:

res.partner -- o2m --> invoiceposition -- o2m --> invoiceversion -- m2m --> shortcodes <-- o2m -- res,partner

When I assign a shortcode to a invoiceversion, I only want to show those shortcodes, where :

res.partner.shortcode.partner_id = res.partner.invoicepositon.invoiceversion.partner_id

Below are my module and my xml file shortened to the essential parts. Would be awesome if someone could tell me how to alter them. Please keep in mind that this is my first openerp module, so a code example and where to put it exactly would be SUPER helpful.

 

class sh_partnerdetails(osv.osv):
    _name='res.partner'
    _inherit='res.partner'

    _columns = {
        [...]
        'invoiceposition': fields.one2many('sh.invoiceposition','company','Invoiceposition', help='Invoiceposition of this user.'),
        'shortcodes': fields.one2many('sh.shortcodes','shortcodecompany','Assigned Shortcodes', help='A list of assigned shortcodes.')
    }

class sh_invoiceposition(osv.osv):
    _name = 'sh.invoiceposition'

    _columns = {
        'company': fields.many2one('res.partner', 'Company', help="Belongs to which company / partner?", required=True),
        
        'comment': fields.char('Comment', size=120, help='Why did you update the billing details?', required=True),
        
        'invoicepositionversions': fields.one2many('sh.invoicepositionversions','isinvoicepositionversionof','Invoiceposition Version', help='A list of assigned invoiceposition versions.')
    }
    
sh_invoiceposition()

class sh_invoicepositionversions(osv.osv):
    _name = 'sh.invoicepositionversions'
    
    _columns = {
        'isinvoicepositionversionof': fields.many2one('sh.invoiceposition','Is invoicepositionversion of', help='This invoiceposition version Belongs to which invoiceposition?'),
        
        [...]
        
        'shortcodes': fields.many2many('sh.shortcodes', 'sh_invoicepositionversions_shortcodes_rel', 'operatorshowinvoicesetting_id', 'shortcode_id', 'Assign shortcode', help='A List of shortcodes assigned to this Version')
    }
sh_invoicepositionversions()

[...]


class sh_shortcodes(osv.osv):
    _name = 'sh.shortcodes'

    _columns = {
        'shortcodecompany': fields.many2one('res.partner','Is shortcode of which company', help='This shortcode number belongs to which company?', required=True),
        'isassignedinwhichoperatorinvoiceversion': fields.many2many('sh.invoicepositionversions', 'sh_invoicepositionversions_shortcodes_rel', 'shortcode_id', 'operatorshowinvoicesetting_id','Is used in which operatorinvoiceversion?', help='This shortcode is used in which operator invoice version?'),
        
        [...]
    }
    
    _sql_constraints = [
        ('uniq_number', 'unique(number)', "This shortcode number alraedy exists. A shortcode can only be assigned to one company")
    ]

sh_shortcodes()

 

my xml file looks like this:

 

<record id="sunhill_partnerdetails" model="ir.ui.view">
    <field name="name">res.partner.form</field>
    <field name="model">res.partner</field>
    <field name="type">form</field>
    <field name="inherit_id" ref="base.view_partner_form" />
    <field name="arch" type="xml">
        <notebook position="inside">
            <page string="Billing Details" attrs="{'invisible': [('is_company','=',False),('parent_id','!=',False)]}">
                [...]
                <separator string="Invoicepositions" colspan="4"/>
                <field name="invoiceposition" widget="one2many_list" nolabel="1" class="oe_inline oe_no_button" context="{'default_company': active_id}">
                    <tree string="invoiceposition">
                        <field name="comment"/>
                    </tree>
                </field>
                
                <separator string="Shortcodes" colspan="4"/>
                <field name="shortcodes" widget="one2many_list" nolabel="1" class="oe_inline oe_no_button" context="{'default_shortcodecompany': active_id}">
                    <tree string="shortcodes">
                        <field name="number"/>
                        <field name="description" />
                    </tree>
                </field>
            </page>
        </notebook>
    </field>
</record>

 

<!-- Start invoiceposition-->
<record model="ir.ui.view" id="invoiceposition_form">
    <field name="name">invoiceposition</field>
    <field name="model">sh.invoiceposition</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="invoiceposition">
            <field name="company" domain="[('is_company', '=', True)]"/>
            <field name="comment"/>
            <separator string="Invoiceposition Versions:" colspan="4"/>
            <field name="invoicepositionversions" colspan="4" widget="one2many_list" nolabel="1" context="{'default_isinvoicepositionversionof': active_id}">
                <tree string="invoiceposition Version">
                    [...]
                </tree>
            </field>
        </form>
    </field>
</record>

<record model="ir.ui.view" id="invoiceposition_tree">
    <field name="name">invoiceposition</field>
    <field name="model">sh.invoiceposition</field>
    <field name="type">tree</field>
    <field name="arch" type="xml">
        <tree string="invoiceposition">
            <field name="company" domain="[('is_company', '=', True)]"/>
            [...]
        </tree>
    </field>
</record>

<record model="ir.actions.act_window" id="action_invoiceposition">
    <field name="name">invoiceposition</field>
    <field name="res_model">sh.invoiceposition</field>
    <field name="view_type">form</field>
    <field name="view_mode">tree,form</field>
</record>
<!-- End-->


<!-- Start invoicepositionversions-->
<record model="ir.ui.view" id="invoicepositionversions_form">
    <field name="name">invoiceposition Versions</field>
    <field name="model">sh.invoicepositionversions</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="invoiceposition Versions">
            [...]
            <separator string="Assigned Shortcodes:" colspan="4"/>
            <field name="shortcodes" colspan="4" widget="many2many_list" nolabel="1" context="{'isassignedinwhichoperatorinvoiceversion': active_id}">
                <tree string="Assigned Shortcodes">
                    [...]
                </tree>
            </field>
        </form>
    </field>
</record>

<record model="ir.ui.view" id="invoicepositionversions_tree">
    <field name="name">invoiceposition Versions</field>
    <field name="model">sh.invoicepositionversions</field>
    <field name="type">tree</field>
    <field name="arch" type="xml">
        <tree string="invoiceposition Versions">
            [...]
        </tree>
    </field>
</record>

<record model="ir.actions.act_window" id="action_invoicepositionversions">
    <field name="name">invoiceposition Versions</field>
    <field name="res_model">sh.invoicepositionversions</field>
    <field name="view_type">form</field>
    <field name="view_mode">tree,form</field>
</record>
<!-- End-->


<!-- Start Shortcodes -->
<record model="ir.ui.view" id="shortcodes_form">
    <field name="name">Shortcodes</field>
    <field name="model">sh.shortcodes</field>
    <field name="type">form</field>
    <field name="arch" type="xml">
        <form string="Shortcodes">
            [...]
            <field name="shortcodecompany" domain="[('is_company', '=', True)]"/>
        </form>
    </field>
</record>

<record model="ir.ui.view" id="shortcodes_tree">
    <field name="name">Shortcodes</field>
    <field name="model">sh.shortcodes</field>
    <field name="type">tree</field>
    <field name="arch" type="xml">
        <tree string="Shortcodes">
            <field name="shortcodecompany" domain="[('is_company', '=', True)]"/>
            [...]
        </tree>
    </field>
</record>

<record model="ir.actions.act_window" id="action_shortcodes">
    <field name="name">Shortcodes</field>
    <field name="res_model">sh.shortcodes</field>
    <field name="view_type">form</field>
    <field name="view_mode">tree,form</field>
</record>
<!-- End-->

 

Thanks alot!

 

 

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/1/14, 3:52 AM
Seen: 605 times
Last updated: 3/16/15, 8:10 AM