İçereği Atla
Bu soru işaretlendi
many2onedomain_filterfilteringdropdownlistodoo17
2 Cevaplar
1534 Görünümler
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
Vazgeç
Avatar
Cybrosys Techno Solutions Pvt.Ltd
En İyi Yanıt

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
Vazgeç
Avatar
Manish Bohra
En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
Domain Filtering help opposite of child_of opperator Çözüldü
domain_filter filtering
Avatar
Avatar
1
Mar 15
14633
How can I dynamically filter many2one fields in Odoo 17 models? Çözüldü
many2one domain_filter dynamic filter
Avatar
Avatar
Avatar
Avatar
3
Ağu 25
3402
Filter product in order line using code
filtering order.lines odoo17
Avatar
Avatar
1
Eyl 24
1221
How to remove 'Create' and 'Edit' in the Many2one field of all models? Çözüldü
views many2one odoo17
Avatar
Avatar
Avatar
3
Tem 24
4755
how to load one to many field in pos session odoo17?
pos many2one odoo17
Avatar
0
Haz 24
70