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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

'Int' value is not return in function for odoo 8

python python2.7 odooV8 odoo8.0

1 الرد

4965 أدوات العرض

Pawan Kumar Sharma

Hii All,

I want to show total numbers of record on screen. For this i have write query language for function and i get desire result on Ubuntu 14.04 command line screen by printing that value from python code. But when i return this value in function then it shows me error pop-up message "TypeError: 'int' object is not iterable". So, anyone can give me proper solution for this problem. My python code for function and field is below.

Python code:

def get_count(self, cr, uid, ids, sequence, arg, context=None):

cr.execute('SELECT count(*) from sun_helpdesk')

u_data = cr.fetchall()

print "cr:", u_data

print "res:",int(u_data[0][0])

return int(u_data[0][0])

_columns = {

'sequence': fields.function(get_count, method=True, string='Total Tickets', type='integer'),

}

XML code:

In XML this field added simply.

Result on the Ubuntu Screen is:

cr: [(101L,)]

res: 101

new_values = dict(values)

TypeError: 'int' object is not iterable

Dan Čermák

If you want to show the result on the screen, you have to return a view from get_count. That means, that you return a dictionary where you specify certain fields for odoo, e.g.:

 return {
            'name': _('View title'),
            'type': 'ir.actions.act_window',
            'view_type': 'form',
            'view_mode': 'form',
            'res_model': 'some_model',
            'target': 'new',
         }

For this to work, you'll have to define a model (ideally you'll want to create a wizard, since, I guess, you don't want to store the result), add a filed for your return value (a fields.Integer) and then pass the return value also in your dictionary. There you have two choices: either in the context as a default or you'll create a new record before the return and pass its id in the 'res_id' key.
Since this is only a very brief explanation, please ask if you would like to know further details.

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
For "Duplicate" button record state is not changed. تم الحل python python2.7 odooV8 odoo8.0	2 يوليو 19	5959
Team Manager python python2.7 odoo8.0	0 أغسطس 17	3622
How to add domain filter for the Analytic Account in Sales Order python2.7 odooV8	1 أبريل 25	4581
How to change subtotal rounding in invoice ? تم الحل python2.7 odooV8	3 ديسمبر 22	12813
How to get current url from bowser? تم الحل python2.7 odooV8	5 أبريل 24	43533

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!