Basic idea: *Hide few fields in client form view for OpenERP users which are not defined as VIP users in my custom many2many table (user_id, partner_id)* What I've already done: *In res.partner form view:* *My custom module which adds many2many relationship for res.partner module:* from openerp.osv import orm, fields from osv import fields, osv class res_partner_users_vip_rel2(osv.osv): _inherit = 'res.partner' _descripti

I have try this and working : XXXXXXX res.partner

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

How to hide some fields in Form View if no record found in many2many relationship?

filter attrs domain many2many

7 Răspunsuri

21852 Vizualizări

Juris Malinens

Basic idea: Hide few fields in client form view for OpenERP users which are not defined as VIP users in my custom many2many table (user_id, partner_id)

What I've already done:

In res.partner form view:

My custom module which adds many2many relationship for res.partner module:

from openerp.osv import orm, fields
from osv import fields, osv
class res_partner_users_vip_rel2(osv.osv):
    _inherit = 'res.partner'
    _description = "VIP status for partner (users)"
    _columns = {
        'vip_ids': fields.many2many(
            'res.users',
            'res_partner_users_vip_rel2',
            'partner_id',
            'users_id',
            'VIP status'),
    }
res_partner_users_vip_rel2()

In Form View I can successfully save multiple users in newly created field, but I am stuck at hiding other fields for users who are not defined in my many2many relationship.

As I understand, I need to use attrs attribute but I don't understand how to use it with many2many relationship.

This doesn't work:

<field name="mobile" attrs="{'invisible': [('uid','in', vip_ids)]}"/>
<field name="fax" attrs="{'invisible': [('uid','in', vip_ids)]}"/>
<field name="email" widget="email" attrs="{'invisible': [('uid','in', vip_ids)]}"/>

Any advice would be greatly appreciated :)

aharoen

Cel mai bun răspuns

I have try this and working :

       <record id="view_0001" model="ir.ui.view">  
            <field name="name">XXXXXXX</field>
            <field name="model">res.partner</field>
            <field name="arch" type="xml">
                <form string="XXXXXXXXXX" version="7.0">
                    <group col="4" colspan="2">
                        <field name="ids_count"/> 
                        <field name="mobile" attrs="{'invisible': [('ids_count','=', 0)]}"/>
                        <field name="fax" attrs="{'invisible': [('ids_count','=', 0)]}"/>
                        <field name="email" widget="email" attrs="{'invisible': [('ids_count','=',0)]}"/> 
                    </group>
                    <field name="vip_ids"></field>

                </form> 
            </field>
       </record>

with modified model definiton

from openerp.osv import fields, osv
class res_partner_users_vip_rel2(osv.osv):
    _inherit = 'res.partner'
    _description = "VIP status for partner (users)"
    def getcount(self, cr, uid,ids,name,arg,context):
        res={}
        sql="""
            SELECT partner_id id, count(*) cnt FROM res_partner_users_vip_rel2 
            WHERE partner_id = """+str(ids[0])+""" GROUP BY partner_id """
        cr.execute(sql)
        res.update(dict(cr.fetchall()))
        if res!={}:
            return res 
        return {ids[0]:0}
    _columns = {                
        'ids_count':fields.function(getcount,type="integer",string='Count'),

        'vip_ids': fields.many2many(
            'res.users',
            'res_partner_users_vip_rel2',
            'partner_id',
            'users_id',
            'VIP status'),
         }

Juris Malinens

Autor

Thanks, but doesn't seem to work. Field is shown both when user is added in many2many relation and also when he s not

aharoen

I have edited my previous answer, and i have tried. It work.

Juris Malinens

Autor

thank You! Only I added AND users_id= """+str(uid)+""" to the query

Alf Olsen

You can also just compare to an empty array (I'm using Odoo 11)

<div attrs="{'invisible':[ ('boats', '=', []) ]}">
    <label for="boats" class="o_ff_header"/>
    <field name="boats"/>
</div>

CARLOS ALBERTO GARCIA BRIZUELA

This way works great for me in Odoo 11, thanks !!

Yogesh

Hello,

It could be achieved without function field and only with xml. You can use attrs attribute like

attrs="{'invisible': [('m2m_field', '=', [(6, False, [])])]}"attrs="{'invisible': [('m2m_field', '=', [(6, False, [])])]}"

On webclient m2m field outputs like [(6, False, [list_of_record_ids])], when there is no record list becomes empty and it outputs like [(6, False, [])] . It can be used in xml condition.

Juris Malinens

Autor

Thanks aharoen. Yesteday evening I came up with similar solution:

def _get_active_ids(self, cr, uid, ids, field_name, arg, context=None):
      result = {}
      for clase in self.browse(cr, uid, ids, context=context):
         result[clase.id] = False
         for membre in clase.vip_ids:
            if membre.id == uid:
                result[clase.id] = True
      return result

class res_partner_users_vip_rel2(osv.osv):
    _inherit = 'res.partner'
    _description = "VIP2 status for partner (users)"
    _columns = {
        'vip_ids': fields.many2many(
            'res.users',
            'res_partner_users_vip_rel2',
            'partner_id',
            'users_id',
            'VIP2 status'),
        'is_current_user_vip': fields.function(
            _get_active_ids,
            type='boolean',
            string="Does current user have VIP access?"),
    }

res_partner_users_vip_rel2()

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
What is diff between domain, domain filter and attr ? filter attrs domain	1 ian. 24	16021
How to Use Domain Filter with Many2Many field filter domain many2many	1 aug. 24	8597
filter many2many field filter domain many2many v14	1 sept. 23	2990
Fied be Invisible if Many2Many value is selected. Rezolvat filter domain many2many invisible	7 iun. 20	7635
How to filter Many2Many field containing zero items filter domain many2many followers	2 iul. 17	4098

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!