case 'float_time': var pattern = '%02d:%02d'; if (value < 0) { value = Math.abs(value); pattern = '-' + pattern; } var hour = Math.floor(value); var min = Math.round((value % 1) * 60); if (min == 60){ min = 0; hour = hour + 1; } return _.str.sprintf(pattern, hour, min);

In Export options export_data method how to override and apply the above float to float_time conversion formula for all widget="float_time" Field.?,,,,

Prakash

ผู้เขียน คำตอบที่ดีที่สุด

In the model override export_data ORM method and float value convert into time.

Example

import math

def float_time_convert(float_val):
    factor = float_val < 0 and -1 or 1
    val = abs(float_val)
    return (factor * int(math.floor(val)), int(round((val % 1) * 60)))

def export_data(self, cr, uid, ids, fields, context=None):
        index = range(len(fields))		
        fields_name = dict(zip(fields,index))              
        res = super(class_name, self).export_data(cr, uid, ids, fields, context=context)
        try:
            for index, val in enumerate(res['datas']):
                if fields_name.get('float_fieldname1'):
                    field1index = fields_name.get('float_fieldname1')
                    float_field1 = float(res['datas'][index][field1index])
                    hour, minute = self.float_time_convert(float_field1)
                    res['datas'][index][field1index] = '{0:02d}:{1:02d}'.format(hour, minute)
                if fields_name.get('float_fieldname2'): 
                    field2index = fields_name.get('float_fieldname2')
                    float_field2 = float(res['datas'][index][field2index])
                    hour, minute = self.float_time_convert(float_field2)
                    res['datas'][index][field2index] = '{0:02d}:{1:02d}'.format(hour, minute)
        except Exception, e:
            #print "Export Exception", e 
            pass               
        return res

Lucas Huber

I did follow the method of Prakash but got an error first. Then I did realise that the float_time_convert call has to be an @api.multi and not an api.one:

File "/opt/odoo/custom/addons9/project_scrum/models/scrum_base.py", line 180, in onchange_duration_hrs
hour, minute = self.float_time_convert(self.duration)
ValueError: need more than 1 value to unpack

my correct code:

@api.multi
def float_time_convert(self, float_val):    
    factor = float_val < 0 and -1 or 1    val = abs(float_val)    
    return (factor * int(math.floor(val)), int(round((val % 1) * 60)))
...
hour, minute = self.float_time_convert(self.duration)

But then I get a problem with adding Datetime and timedelta

start_datetime = fields.Datetime()
....
end_time = self.start_datetime + datetime.timedelta(hours=hour, minute=minute)

Python does interpret start_datetime not as datetime!

Faris Fathurrahman

i have tried this and it worked. I used datetime.combine with initial date and time.min as the start_datetime

Arsalan

I require the same thing.... did you get a way to handle such situation ??

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Convert Hours and Minute into Float value แก้ไขแล้ว time float_time V13	1 เม.ย. 20	17225
How to subtract two 'float_time' field values? time float float_time odoo10	4 ม.ค. 20	7043
Exporting large amount of data error export time long	0 ก.ค. 15	5022
exporteren export	1 ก.ค. 25	2505
How can I list/export more than 80 items? แก้ไขแล้ว export	3 ก.พ. 25	16081

คำถามนี้ถูกตั้งค่าสถานะ

File "/opt/odoo/custom/addons9/project_scrum/models/scrum_base.py", line 180, in onchange_duration_hrshour, minute = self.float_time_convert(self.duration)ValueError: need more than 1 value to unpack

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

File "/opt/odoo/custom/addons9/project_scrum/models/scrum_base.py", line 180, in onchange_duration_hrs
hour, minute = self.float_time_convert(self.duration)
ValueError: need more than 1 value to unpack