Se rendre au contenu
Cette question a été signalée
v6.0
1 Répondre
6499 Vues
Avatar
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?

Avatar
Ignorer
fdim
Auteur

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

Avatar
Andreas Brueckl
Meilleure réponse

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
Avatar
Ignorer
fdim
Auteur

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

Publications associées Réponses Vues Activité
No module named psycopg2 ! Résolu
v6.0
Avatar
Avatar
Avatar
Avatar
Avatar
4
janv. 24
40355
web service search arguments
v6.0
Avatar
Avatar
Avatar
2
mars 15
5603
composite filter?
v6.0
Avatar
0
mars 15
4838
Employee object only editable for current logged employee
v6.0
Avatar
Avatar
1
mars 15
5295
error in manufacturing order?
v6.0
Avatar
0
mars 15
4270