Pular para o conteúdo
Esta pergunta foi sinalizada
many2onedomain_filterfilteringdropdownlistodoo17
2 Respostas
1437 Visualizações
Avatar
imrantc

Hi all, 

i have 2 models , 

Passport and Employees

class PassportManagementModels(models.Model):    
_name = 'om_hrm.passport'    
_description = 'Passport Master'    
_inherit = ['mail.thread']    
_rec_name = "passport_no"
passport_no = fields.Char(string='Passport Number',size=16,required=True)    PassportIssueDate = fields.Date(string='Passport Issue Date', required=True)    PassportExpiryDate =fields.Date(string="Expiry Date",required=True)    PassportNationality =fields.Char(string="Nationality",size=20,required=True)    Passportdob = fields.Date(string="Date of Birth",required=True)  
Passportholdername = fields.Char(string="Holder Full Name",required=True)    Passportpossesionwith = fields.Selection([("admin","Admin"),("staff","Staff"),("other","Other")],string="Possesion With!")    
passport_doc_ids = fields.Many2many('ir.attachment',string='Passport Documents',ondelete='cascade')
_sql_constraints = [        ('key_uniq', 'unique (passport_no)', 'PassportNo must be unique.')    ]
class EmployeesManagementModels(models.Model):    
_name = 'om_hrm.employee'    _description = 'Employee Master'    
_inherit = ['mail.thread']    
_rec_name = "full_Name"
employeeId = fields.Char(string='Employee id',required= True)    
passport_id = fields.Many2one('om_hrm.passport', string='Passport', ondelete='set null',domain=lambda self:[('id','=',self._get_assigned_passport_ids())])  
@api.onchange('passport_id')
def onchange_passport_id(self):        # Refresh the domain for passport_id to show only unassigned passports        
self._get_assigned_passport_ids()

@api.model    
def _get_assigned_passport_ids(self):        # Get a list of all passport IDs already assigned to any employee       
allemployees = self.search([])        
print("Employees list:",allemployees)        
assigned_passport_ids = self.search([]).mapped('passport_id.id')        print("Assigned Passport IDs:", assigned_passport_ids)        
return assigned_passport_ids

i want to see the passports which are not assigned to any employees,like fetching all passport and checking if the employee table contains the id then it shouldnt show in the dropdown list.

Any help is appreciated, thanks.

Avatar
Cancelar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Melhor resposta

Hi,

Please check the below code


Python

class EmployeesManagementModels(models.Model):    
    _name = 'om_hrm.employee'
    _description = 'Employee Master'
    _inherit = ['mail.thread']

    employeeId = fields.Char(string='Employee id',required= True)
    assigned_passport_ids = fields.Many2many(
        'om_hrm.passport', string="Assigned Passport",
        compute="_compute_assigned_passport_ids")
    passport_id = fields.Many2one(
        'om_hrm.passport', string='Passport',
        domain="[('id', 'not in', assigned_passport_ids)]")

    @api.depends('passport_id')
    def _compute_assigned_passport_ids(self):
        for rec in self:
            assigned_passport_ids = self.search([]).mapped('passport_id.id')
            rec.assigned_passport_ids = assigned_passport_ids

XML


<record id="om_hrm_employee_view_form" model="ir.ui.view">
    <field name="name">om_hrm.employee.view.form</field>
    <field name="model">om_hrm.employee</field>
    <field name="arch" type="xml">
        <form>
            <sheet>
                <group>
                    <field name="employeeId"/>
                    <field name="assigned_passport_ids"
                           widget="many2many_tags" invisible="1"/>
                    <field name="passport_id"/>
                </group>
            </sheet>
            <chatter/>
        </form>
    </field>
</record>

Hope it helps.

Avatar
Cancelar
Avatar
Manish Bohra
Melhor resposta

Hello, 

There are multiple solution but you can do one thing add one employee field in 'om_hrm.passport' table. 

When you link any employee with passport in case you map the employee. 

After you can do one thing in case of domain apply condition domain=[('employee_id','=',False)]

Thanks.

Avatar
Cancelar
Publicações relacionadas Respostas Visualizações Atividade
Domain Filtering help opposite of child_of opperator Resolvido
domain_filter filtering
Avatar
Avatar
1
mar. 15
14585
How can I dynamically filter many2one fields in Odoo 17 models? Resolvido
many2one domain_filter dynamic filter
Avatar
Avatar
Avatar
Avatar
3
ago. 25
3168
Filter product in order line using code
filtering order.lines odoo17
Avatar
Avatar
1
set. 24
1174
How to remove 'Create' and 'Edit' in the Many2one field of all models? Resolvido
views many2one odoo17
Avatar
Avatar
Avatar
3
jul. 24
4585
how to load one to many field in pos session odoo17?
pos many2one odoo17
Avatar
0
jun. 24
70