odoo14-addon-web-widget-x2many-2d-matrix 14.0.1.1.1

Example

You need a data structure already filled with values. Let’s assume we want to use this widget in a wizard that lets the user fill in planned hours for one task per project per user. In this case, we can use project.task as our data model and point to it from our wizard. The crucial part is that we fill the field in the default function:

from odoo import fields, models

class MyWizard(models.TransientModel):
    _name = 'my.wizard'

    def _default_task_ids(self):
        # your list of project should come from the context, some selection
        # in a previous wizard or wherever else
        projects = self.env['project.project'].browse([1, 2, 3])
        # same with users
        users = self.env['res.users'].browse([1, 2, 3])
        return [
            (0, 0, {
                'name': 'Sample task name',
                'project_id': p.id,
                'user_id': u.id,
                'planned_hours': 0,
                'message_needaction': False,
                'date_deadline': fields.Date.today(),
            })
            # if the project doesn't have a task for the user,
            # create a new one
            if not p.task_ids.filtered(lambda x: x.user_id == u) else
            # otherwise, return the task
            (4, p.task_ids.filtered(lambda x: x.user_id == u)[0].id)
            for p in projects
            for u in users
        ]

    task_ids = fields.Many2many('project.task', default=_default_task_ids)

Now in our wizard, we can use:

<field name="task_ids" widget="x2many_2d_matrix" field_x_axis="project_id" field_y_axis="user_id" field_value="planned_hours">
    <tree>
        <field name="task_ids"/>
        <field name="project_id"/>
        <field name="user_id"/>
        <field name="planned_hours"/>
    </tree>
</field>

Note that all values in the matrix must exist, so you need to create them previously if not present, but you can control visually the editability of the fields in the matrix through field_att_disabled option with a control field.

12.0.1.0.1 (2018-12-07)

• [FIX] Cells are unable to render property. (#1126)

12.0.1.0.0 (2018-11-20)

• [12.0][MIG] web_widget_x2many_2d_matrix (#1101)

Authors

• Therp BV

• Tecnativa

• Camptocamp

• CorporateHub

Contributors

• Holger Brunn <hbrunn@therp.nl>

• Pedro M. Baeza <pedro.baeza@tecnativa.com>

• Artem Kostyuk <a.kostyuk@mobilunity.com>

• Simone Orsi <simone.orsi@camptocamp.com>

• Timon Tschanz <timon.tschanz@camptocamp.com>

• Jairo Llopis <jairo.llopis@tecnativa.com>

• Dennis Sluijk <d.sluijk@onestein.nl>

• CorporateHub

  • Alexey Pelykh <alexey.pelykh@corphub.eu>

• Adrià Gil Sorribes <adria.gil@forgeflow.com>

Maintainers

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

This module is part of the OCA/web project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.