Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Why is the date displayed like this? QWEB

date inheritance qweb templates odoov11

5 Antwoorden

6840 Weergaven

Benjamin Cherpas

Hi,

I want to display the activity date deadline but it takes a wrong format. I work on French odoo but the date is displayed in English, with the following format and time set to 00:00:00 but this is a date field not datetime...

Format : Wed Dec 18 2019 00:00:00 GMT+2

This is weird because even in my database, the date is displayed like 18/09/2019, so why is it displayed like that when I call the field in inherited qweb template?

Here is my qweb inheritance:

<?xml version="1.0" encoding="UTF-8"?>
<templates>
    <t t-extend="mail.KanbanActivityDropdown">
        <t t-jquery=".fa-clock-o" t-operation="after">
            <t t-if="log.date_deadline > new Date() and log.activity_type_id[1] != 3">
                <span><t t-esc="log.date_deadline" /></span>
            </t>
        </t>
    </t>
</templates>

Hope that anyone can help me. Thanks !

UPDATE:

I already tried t-field, t-options, t-field-options with format or widget: no effect...

Bye.

faOtools

Try using the widget 'date', e.g.:

<span t-field="log.date_deadline" t-options='{"widget": "date"}'/>

faOtools

Beste antwoord

Okay, it seems that is because of default: date is kept with time zone in the database (not UTC).

I guess the simplest way to replace timezone is to re-calculate date in Python (or alternative apply fields_utils in Javascript). Something like (not tested):

@api.multi

@api.depends("date_deadline")

def _compute_no_tz_date(self):

for record in self:

record.no_tz_date = fields.Date.to_string(record.date_deadline.date())

# perhaps also better to apply time zone transformation

# have a look at the method _compute_state_from_date in the same file

no_tz_date = fields.Date(compute=_compute_no_tz_date)

Then, this no_tz_date should be shown in XML just as a string without time or time zone

Benjamin Cherpas

Auteur

It has no effect (see updated answer) I don't understand why...

UPDATE:

date_deadline field in MailActivity object (in mail_activity.py file):

date_deadline = fields.Date('Due Date', index=True, required=True, default=fields.Date.context_today)

Log declaration (I don't know if it is declared in some JS file or not):

<li t-if="!_.isEmpty(records)">
        <ul class="nav o_activity_log">
            <t t-foreach="_.keys(records)" t-as="key">
                <t t-set="logs" t-value="records[key]" />
                <li class="o_activity_label">
                    <strong t-attf-class="o_activity_color_#{key}">
                        <t t-esc="selection[key]" /> (<t t-esc="logs.length"/>)
                    </strong>
                </li>
                <li t-foreach="logs" t-as="log" t-att-data-activity-id="log.id" class="o_schedule_activity">
                    <div class="o_activity_title pull-left">
                        <span t-attf-class="fa #{log.icon} fa-fw" />
                        <strong>
                            <t t-esc="log.title_action or log.activity_type_id[1]" />
                        </strong>
                        <div>
                            <span class="fa fa-clock-o fa-fw" />
                            <span t-att-title="log.date_deadline"><t t-esc="log.label_delay" /></span>
                            <t t-if="log.user_id[0] != uid">
                                <span class="ml4 fa fa-user" />
                                <span><t t-esc="log.user_id[1]" /></span>
                            </t>
                        </div>
                    </div>
                    <div class="pull-right">
                        <span class="o_mark_as_done o_activity_link o_activity_link_kanban fa fa-check-circle fa-2x mt4" t-att-data-activity-id="log.id" title="Mark as done" />
                    </div>
                </li>
            </t>
        </ul>
    </li>

Thank you for help !

faOtools

Share then the field date_deadline Python declaration or Javascript code (depending on what is log - Odoo class or Javascript object).

Benjamin Cherpas

Auteur

Done. Thanks !

Benjamin Cherpas

Auteur

Thank you so much it works ! But I used from_string instead of to_string (sorry I can't reply your comment above, just mine). You have been helpful so I'm disappointed to not have enough karma to upvote your answer. Thaaaanks again !!!

faOtools

You are welcome. As for karma: I upvoted your question - the situation is quite interesing. Besides, if you need karma in the Future, you can pass a few learning courses - https://www.odoo.com/slides/all

Benjamin Cherpas

Auteur

Oh nice! I'll think about that! Thanks a lot!

Regards.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Template inheritance not working in Odoo 15 inheritance qweb templates v15	1 mrt. 22	8067
How to inherit purchase order body view? v8 inheritance qweb templates	2 mrt. 15	8558
how to change tooltip question mark symbol? Opgelost web inheritance qweb templates frontend	1 dec. 23	2521
How to remove template changes made by other addons? inheritance qweb templates overwriting overriding	1 sep. 22	6552
Odoo 11: custom report generate empty pdf (html works fine) Opgelost pdf qweb templates v11.0 odoov11	11 feb. 19	23833

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!