Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
many2onedomain_filterfilteringdropdownlistodoo17
2 Odgovori
1004 Prikazi
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
Opusti
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

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
Opusti
Avatar
Manish Bohra
Best Answer

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
Opusti
Related Posts Odgovori Prikazi Aktivnost
Domain Filtering help opposite of child_of opperator Solved
domain_filter filtering
Avatar
Avatar
1
mar. 15
14007
How can I dynamically filter many2one fields in Odoo 17 models? Solved
many2one domain_filter dynamic filter
Avatar
Avatar
Avatar
Avatar
3
avg. 25
1858
Filter product in order line using code
filtering order.lines odoo17
Avatar
Avatar
1
sep. 24
864
How to remove 'Create' and 'Edit' in the Many2one field of all models? Solved
views many2one odoo17
Avatar
Avatar
Avatar
3
jul. 24
3258
how to load one to many field in pos session odoo17?
pos many2one odoo17
Avatar
0
jun. 24
70