Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
many2manydomain_filterfields_view_getodoo11
2 Vastaukset
10375 Näkymät
Avatar
Jayant Bulbule

Here's my code -

@api.multi

def fields_view_get(self, cr, uid, view_id=None, view_type=False, context=None, toolbar=False, submenu=False):

        payslips = self.env['hr.payslip']

#        [data] = self.read()

        active_id = self.env.context.get('active_id')

        if active_id:

            [run_data] = self.env['hr.payslip.run'].browse(active_id).read(['date_start', 'date_end', 'credit_note'])

        from_date = run_data.get('date_start')

        to_date = run_data.get('date_end')

        if not from_date or from_date == False:

            today = datetime.today()

            to_date = datetime.date(today.year, today.month, 1) - 1

            from_date = datetime.date(to_date.year, to_date.month, 1)

        

        if not to_date or to_date == False:

            today = datetime.today()

            to_date = datetime.date(today.year, today.month, 1) - 1

            from_date = datetime.date(to_date.year, to_date.month, 1)

        

        query = """select id from hr_employee where id not in 

            (select distinct employee_id from hr_payslip where date_from = '%s' and date_to = '%s')""" % (from_date, to_date)

        query_res = self.env.cr.execute(query)

        query_res = self.env.cr.fetchall()

        

        emp_ids = []

        for each_id in query_res:

            emp_ids.append(each_id[0])

        

        return {'domain': {'employee_ids':[('id','in',emp_ids)]}}


I tried by pasting this code into the hr_payroll_payslips_by_employees.py to get the list of employees filtered while selecting employees for payslip batch. The intent is to avoid creation of duplicate payslips for the same payroll period. But getting an error as "TypeError: Cannot read property 'documentElement' of null"

Any help on this would be a great help and thanks in advance for the same.


EDIT:

Would like to add here: That, my code runs perfectly until the last line and the error is thrown only on last line when returning the domain back to my m2m field (employee_ids).

http://<ip-address>:8069/web/content/3598-e2a938e/web.assets_backend.js:585
Traceback:
TypeError: Cannot read property 'documentElement' of null
    at Class._postprocess_fvg (http://103.215.164.67:8069/web/content/3598-e2a938e/web.assets_backend.js:585:239)
    at Function._.mapObject (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:50:233)
    at Object.<anonymous> (http://103.215.164.67:8069/web/content/3598-e2a938e/web.assets_backend.js:580:189)
    at Object.<anonymous> (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:802:681)
    at fire (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:796:299)
    at Object.fireWith [as resolveWith] (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:801:198)
    at Object.<anonymous> (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:802:874)
    at fire (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:796:299)
    at Object.fireWith [as resolveWith] (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:801:198)
    at Object.<anonymous> (http://103.215.164.67:8069/web/content/3455-057e365/web.assets_common.js:802:874)
Avatar
Hylkää
Avatar
Ibrahim Boudmir
Paras vastaus
Hi, 
you can't make the fields_view_get function with a multi api because the function only displays the architecture of the view and reacts on the fields and their attributes, not their values.
Furthermore, self.env.context.get('active_id') does not return anything in fields_view_get. 
the return must be a call of the super..
You need to tell us what you want to do..
here is an example of fields_view_get from the server : 
@api.model
def fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False):
     res = super(Product, self).fields_view_get(view_id=view_id, view_type=view_type, toolbar=toolbar, submenu=submenu)
        if self._context.get('location') and isinstance(self._context['location'], (int, long)):
            location = self.env['stock.location'].browse(self._context['location'])
            fields = res.get('fields')
            if fields:
                if location.usage == 'supplier':
                    if fields.get('virtual_available'):
                        res['fields']['virtual_available']['string'] = _('Future Receipts')
                    if fields.get('qty_available'):
                        res['fields']['qty_available']['string'] = _('Received Qty')
                elif location.usage == 'internal':
                    if fields.get('virtual_available'):
                        res['fields']['virtual_available']['string'] = _('Forecasted Quantity')
                elif location.usage == 'customer':
                    if fields.get('virtual_available'):
                        res['fields']['virtual_available']['string'] = _('Future Deliveries')
                    if fields.get('qty_available'):
                        res['fields']['qty_available']['string'] = _('Delivered Qty')
                elif location.usage == 'inventory':
                    if fields.get('virtual_available'):
                        res['fields']['virtual_available']['string'] = _('Future P&L')
                    if fields.get('qty_available'):
                        res['fields']['qty_available']['string'] = _('P&L Qty')
                elif location.usage == 'procurement':
                    if fields.get('virtual_available'):
                        res['fields']['virtual_available']['string'] = _('Future Qty')
                    if fields.get('qty_available'):
                        res['fields']['qty_available']['string'] = _('Unplanned Qty')
                elif location.usage == 'production':
                    if fields.get('virtual_available'):
                        res['fields']['virtual_available']['string'] = _('Future Productions')
                    if fields.get('qty_available'):
                        res['fields']['qty_available']['string'] = _('Produced Qty')
        return res

Avatar
Hylkää
Avatar
Jayant Bulbule
Tekijä Paras vastaus

Hi Friends,

I am really stuck with this. If the above problem does not have a direct solution, any alternative solution would as well be a great help.

Regards,

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
how can filter domain with compute field?
domain_filter odoo11
Avatar
Avatar
Avatar
Avatar
3
elok. 20
16067
[11.0] Hide records from many2many
many2many domain_filter
Avatar
0
elok. 20
3005
Add column to a many2many rel table Ratkaistu
many2many odoo11
Avatar
Avatar
1
marrask. 19
6031
Unknown field in fields_view_get with custom fields Ratkaistu
domain_filter fields_view_get
Avatar
Avatar
1
maalisk. 15
9844
Filtering relationship field Selection Based on another field in CRM Module
many2many context domain_filter
Avatar
Avatar
Avatar
2
marrask. 24
3760