Skip to Content
This question has been flagged
v6.0
1 Reply
6474 Views
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
Discard
fdim
Author

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

Avatar
Andreas Brueckl
Best Answer

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
Discard
fdim
Author

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

Related Posts Replies Views Activity
No module named psycopg2 ! Solved
v6.0
Avatar
Avatar
Avatar
Avatar
Avatar
4
जन॰ 24
40258
web service search arguments
v6.0
Avatar
Avatar
Avatar
2
मार्च 15
5579
composite filter?
v6.0
Avatar
0
मार्च 15
4813
Employee object only editable for current logged employee
v6.0
Avatar
Avatar
1
मार्च 15
5268
error in manufacturing order?
v6.0
Avatar
0
मार्च 15
4253