Skip to Content
This question has been flagged
many2onecompanyrule
1 Reply
995 Views
Avatar
Uday Sankar k 
driver_store_id = fields.Many2one(
    'res.store',
    string='Driver Store'
)
<field name="driver_store_id"
       attrs="{'invisible': [('collection_required', '!=', 'yes')]}"
       domain="[('is_driver_available', '=', True),
                ('country_id', '=', smr_store_country_id)]"/>


Normally, driver_store_id shows only stores from the user’s current company,

I want to auto-suggest (auto-fill) a driver store that may belong to:

the same company or any other company (ALL companies).

I want to avoid computed fields, stored helper fields, or heavy domain computations, as they may cause performance issues.

Avatar
Discard
Codesphere Tech

Hello,
Have you tried company_dependent=False ?

Uday Sankar k
Author

Yes ,it doesn’t solve this case.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,
To show driver stores from all companies, you need to add company_dependent=False to the driver_store_id field in your Python model, which tells Odoo to ignore company restrictions for that field. To automatically suggest a store, you'll create an @api.onchange method in your Python model that watches for changes in fields like collection_required and smr_store_country_id; when these change, the method will search for an available store matching your criteria and automatically fill it into the driver_store_id field.
code:
from odoo import fields, models, api

class YourModel(models.Model): # Replace YourModel with the actual name of your model
    _name = 'your.model.name' # Replace your.model.name with the actual technical name of your model
    _description = 'Your Model Description'

    driver_store_id = fields.Many2one(
        'res.store',
        string='Driver Store',
        company_dependent=False,
    )
    collection_required = fields.Selection([('yes', 'Yes'), ('no', 'No')], string='Collection Required')
    smr_store_country_id = fields.Many2one('res.country', string='SMR Store Country')

    @api.onchange('collection_required', 'smr_store_country_id')
    def _onchange_suggest_driver_store(self):
        if self.collection_required == 'yes' and self.smr_store_country_id:
            # Search for an available driver store in the specified country
            # The domain here should match your XML domain for consistency
            suggested_store = self.env['res.store'].search([
                ('is_driver_available', '=', True),
                ('country_id', '=', self.smr_store_country_id.id)
            ], limit=1) # limit=1 to get the first matching store

            if suggested_store:
                self.driver_store_id = suggested_store
            else:
                # If no store is found, clear the field or set a default
                self.driver_store_id = False
        else:
            # Clear the field if conditions for suggestion are not met
            self.driver_store_id = False

Hope it helps.

Avatar
Discard
Related Posts Replies Views Activity
record rule object access
error many2one rule
Avatar
Avatar
1
Jun 15
4906
How to Use Selection on Many2one Field ? Solved
many2one selection rule funtion
Avatar
Avatar
Avatar
Avatar
3
Jan 24
18623
value not pass from many2one field to form Solved
many2one
Avatar
Avatar
Avatar
Avatar
3
May 26
4005
Display values of dropdown in a many2one field Solved
many2one
Avatar
Avatar
2
Feb 25
9005
creation of company Solved
company
Avatar
Avatar
1
Oct 24
14572