Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
exporttimefloat_time
3 Antworten
35559 Ansichten
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
Verwerfen
Avatar
Prakash
Autor Beste Antwort

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
Verwerfen
Avatar
Lucas Huber
Beste Antwort

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
Verwerfen
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
Beste Antwort

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

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
Convert Hours and Minute into Float value Gelöst
time float_time V13
Avatar
Avatar
1
Apr. 20
17230
How to subtract two 'float_time' field values?
time float float_time odoo10
Avatar
Avatar
4
Jan. 20
7049
Exporting large amount of data
error export time long
Avatar
0
Juli 15
5024
exporteren
export
Avatar
Avatar
1
Juli 25
2505
How can I list/export more than 80 items? Gelöst
export
Avatar
Avatar
Avatar
3
Feb. 25
16085