Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
fieldsumodoo11Char
1 Vastaa
3921 Näkymät
Avatar
Steven Salty

Hi forum!


I have this char field:

overtime = fields.Char(readonly=True, default='00:00')

I would need to summarize the values ​​of the overtime field, and I want to print this value in a new field.

This is how the values ​​appear in the overtime field:

02:00
00:00
01:00
00:00
03:00
00:00
00:00
02:00
00:00
01:00
01:00

Is it possible to do it?


Thanks for your help!

Regards,

Steven

Avatar
Hylkää
Avatar
Paresh Wagh
Paras vastaus

Hi Steven:

Here's an example of how it can be done. You will need to replace the array with the appropriate recordset returned by a search statement.

from datetime import time

ots = ['02:00','01:50','00:10','03:15']

tot = 0
for ot in ots:
    t = time.fromisoformat(ot)
    tot += t.hour*60 + t.minute

print('%s:%s' % (str(int(tot/60)).zfill(2), str(tot%60).zfill(2)))

Hope this helps.

Avatar
Hylkää
Steven Salty
Tekijä

Thank you Paresh Wagh! Thanks for the great help!

Steven Salty
Tekijä

I had to convert the string type to a float. But when I reference the sum_50_overtime field with a related field, it doesn't get the value.

0 is the value of the sum_50_overtime field, but i don't know why.

But when I print to the console, it gets the correct value, only the related field does not.

sum_50_overtime = fields.Float(compute='_compute_sum_50')

@api.multi
@api.depends('overtime_50', 'sum_50_overtime')
def _compute_sum_50(self):
ots = []
for record in self:
ots.append(record.overtime_50)
tot = 0
for ot in ots:
t = parser.parse(ot)
tot += t.hour * 60 + t.minute
s = ('%s:%s' % (str(int(tot / 60)).zfill(2), str(tot % 60).zfill(2)))
time = float(s.replace(":", ""))
record.sum_50_overtime = time
print(record.sum_50_overtime)

The related field :

overtime_weekdays = fields.Float(related='attendance_ids.sum_50_overtime')

Thank you for your help!

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Make a custom dropdown field with create and edit Ratkaistu
field odoo11
Avatar
Avatar
1
maalisk. 18
7949
[Solved] [Odoo 11] How to add an editable field in a treeview. Ratkaistu
treeview editable field odoo11
Avatar
3
heinäk. 24
24091
Calculated Field in Odoo Studio: Sum of a Field Related to Tags in Contacts
field customizing personalization sum Studio
Avatar
Avatar
Avatar
3
helmik. 25
1806
create backorder odoo after validate purchase shipment ? Ratkaistu
odoo11
Avatar
Avatar
1
lokak. 25
12178
Project module or fields
field
Avatar
0
helmik. 25
2374