Skip ke Konten
Pertanyaan ini telah diberikan tanda
pythoncustomcompute
1 Balas
5116 Tampilan
Avatar
Sam F

i have 2 fields, one we will pick a date, i would like the other to automatically compute -5 weeks from the selected date. i have played with the compute field in studio but have had no luck getting anything to work.

so far i have:


for record in self:

  record[("x_studio_field_CgBpj")] = record.x_studio_field_47ZJc - datetime.timedelta(weeks=+5)

Avatar
Buang
Avatar
DHA Medic
Jawaban Terbai

Odoo 11, Python 3.5

from datetime import datetime, timedelta
from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT

class Test(models.Model):
    _name = "dhac.rad.project"

    test1 = fields.Datetime(string="Date Time A")
    test2 = fields.Datetime(string="Date Time B", compute="dp_test1")

    @api.depends('test1')
    def dp_test1(self):
        if self.test1:
            raw = datetime.strptime(self.test1, DEFAULT_SERVER_DATETIME_FORMAT)  - timedelta(weeks=5)
            self.test2 = str(raw)
Avatar
Buang
Sam F
Penulis

which parts of this will i need to change for my custom fields?

DHA Medic

You should share the code you are currently editing.

Thanks

Sam F
Penulis

i have, its in the original post.

im using the compute field in the studio.

DHA Medic

from datetime import datetime, timedelta

from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT

for record in self:

record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)

DHA Medic

Try it bro, i don't test it

[tab]record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)

DHA Medic

My code: pastebin.com/yYTL4E5h

Sam F
Penulis

getting the error:

File "/odoo/odoo-server/odoo/tools/safe_eval.py", line 189, in assert_valid_codeobj

raise ValueError("forbidden opcode(s) in %r: %s" % (expr, ', '.join(opname[x] for x in codes)))

ValueError: forbidden opcode(s) in 'from datetime import datetime, timedelta\r\nfrom odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT\r\nfor record in self:\r\n record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)': IMPORT_NAME, IMPORT_FROM

Gerardo Busch

Are both fields of the same type? (Datetime or Date). If not, you need to convert it. I tried something similar and this was the problem I had.

Post Terkait Replies Tampilan Aktivitas
How to get a person's age from his date of birth in Odoo? Diselesaikan
python compute
Avatar
Avatar
Avatar
2
Mei 20
6895
How can I do in compute method to differ two datetime ? Diselesaikan
python compute odoo
Avatar
Avatar
1
Jan 17
5920
How do I configure Sales Tax so that it is based on product cost, not the selling price? Diselesaikan
python tax custom formula
Avatar
Avatar
1
Feb 25
1282
compute field not working properly
python model compute technical
Avatar
Avatar
Avatar
2
Jun 23
5297
How can I add custom fields that calculate a combination of other fields? Like Sales Margin as a percentage? Without a module. Diselesaikan
python fields custom v9
Avatar
Avatar
2
Apr 23
24457