Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

show supplier name in product tree view

v6.0

1 Răspunde

6493 Vizualizări

fdim

I try to show supplier name in product tree view so i create this function :

class product_product(osv.osv):

    _inherit = 'product.product'

    def get_supplier_name(self, cr, uid, *args):
        cr.execute("select pt.name from res_partner pt  join product_supplierinfo fr on (fr.name=pt.id)  where fr.sequence = 1")
        res = cr.fetchone()
        return res

    _columns = {
      'supplier_name': fields.function(get_supplier_name, method=True,string="Supplier name",type="many2one", store = True),
      }


product_product()

But I have this error :

    Traceback (most recent call last): File "netsvc.pyo", line 489, in dispatch File "service\web_services.pyo", line 599, in dispatch File "osv\osv.pyo", line 122, in wrapper File "osv\osv.pyo", line 176, in execute File "osv\osv.pyo", line 167, in execute_cr File "osv\orm.pyo", line 2940, in read File "osv\orm.pyo", line 3060, in _read_flat File "osv\fields.pyo", line 799, 
in get AttributeError: 'tuple' object has no attribute 'values'

What can I do?

fdim

Autor

I rectify the type of the field "supplier_name" to char and I've thie error : TypeError: int argument required

Andreas Brueckl

Try this method (assuming, that the type of the function field is many2one):

def get_supplier_name(self, cursor, user, ids, name, arg, context=None):
    res = {}
    for product in self.browse(cursor, user, ids, context=context):
        if product.seller_ids:
          res[product.id] = product.seller_ids[0].id
        else:
          res[product.id] = False
    return res

fdim

Autor

I tried your method but : get AttributeError: 'NoneType' object has no attribute 'name_get'

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
No module named psycopg2 ! Rezolvat v6.0	4 ian. 24	40324
web service search arguments v6.0	2 mar. 15	5590
composite filter? v6.0	0 mar. 15	4833
Employee object only editable for current logged employee v6.0	1 mar. 15	5287
error in manufacturing order? v6.0	0 mar. 15	4265

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!