Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
exporttimefloat_time
3 Svar
36339 Vyer
Avatar
Prakash

In openerp 7,  Start Time columns created using float_time widget.

in py file,

start_time: fields.float('Start Time')

in xml file,

<field name="start_time" widget="float_time"/>

Using "Export" options  Start Time output values generated it shows in float format.

Coversion float to float_time code:-

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.?,,,,

 

Avatar
Avbryt
Avatar
Prakash
Författare Bästa svar

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

Avatar
Avbryt
Avatar
Lucas Huber
Bästa svar

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!

Avatar
Avbryt
Faris Fathurrahman

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

Avatar
Arsalan
Bästa svar

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

Avatar
Avbryt
Relaterade inlägg Svar Vyer Verksamhet
Convert Hours and Minute into Float value Löst
time float_time V13
Avatar
Avatar
1
apr. 20
17921
How to subtract two 'float_time' field values?
time float float_time odoo10
Avatar
Avatar
4
jan. 20
7648
Exporting large amount of data
error export time long
Avatar
0
juli 15
5446
exporteren
export
Avatar
Avatar
1
juli 25
2979
How can I list/export more than 80 items? Löst
export
Avatar
Avatar
Avatar
3
feb. 25
17047