Skip to Content
Menu
This question has been flagged
3 Replies
1534 Zobrazenia

I want to create a sales order where selecting a checkbox will allow me to choose specific products (in this case, products with available_for_cashback = True). I've tried many things, but I haven't been successful. Below is my code with one of the many approaches I've attempted:


class ProductTemplate(models.Model):

    _inherit = 'product.template'


    available_for_cashback = fields.Boolean(string="Redeemable with cashback")



class SaleOrder(models.Model):

    _inherit = 'sale.order'


    sale_order_cashback = fields.Boolean(string="Cashback order")


    @api.onchange('sale_order_cashback')

    def _onchange_sale_order_cashback(self):

        if self.sale_order_cashback:

            domain = [('available_for_cashback', '=', True)]

        else:

            domain = [('sale_ok', '=', True)]

        return {'domain': {'order_line.product_template_id': domain}}







Avatar
Zrušiť
Best Answer

Hi,

For creating dynamic domain , please check the below code.


class SaleOrder(models.Model):

    _inherit = 'sale.order'


    sale_order_cashback = fields.Boolean(string="Cashback order")

    cashback_products = fields.Json()


@api.onchange('sale_order_cashback')

    def _onchange_sale_order_cashback(self):

        query = """

            SELECT pp.id

            FROM product_product pp

            INNER JOIN product_template pt ON pp.product_tmpl_id = pt.id

            WHERE pt.sale_ok = true

        """

        if self.sale_order_cashback:

            query += " AND pt.available_for_cashback = true"

        self.env.cr.execute(query)

        product_ids = [row[0] for row in self.env.cr.fetchall()]

        self.cashback_products = product_ids


XML


<record id="sale_order_form" model="ir.ui.view">

        <field name="name">sale.view.order.form.inherit</field>

        <field name="model">sale.order</field>

        <field name="inherit_id" ref="sale.view_order_form"/>

        <field name="arch" type="xml">


         <xpath expr="//field[@name='order_line']//tree//field[@name='product_id']"

                       position="attributes">

                    <attribute name="domain">[('id', 'in', parent.cashback_products)]</attribute>

          </xpath>


</field>


</record>


Hope it helps

Avatar
Zrušiť
Best Answer

Hi, you can follow this: https://youtu.be/f3mq5fHRPT0

Hope it helps, Thanks

Avatar
Zrušiť
Best Answer

Thanks a lot!! This solution works perfectly for me.

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
0
mar 25
494
4
jan 25
1331
1
nov 24
1512
2
apr 25
1618
0
feb 25
523