Skip to Content
This question has been flagged
dateinheritanceqwebtemplatesodoov11
5 Replies
6837 Zobrazenia
Avatar
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.

Avatar
Zrušiť
faOtools

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

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

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



Avatar
Zrušiť
Avatar
Benjamin Cherpas
Autor Best Answer

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 !

Avatar
Zrušiť
faOtools

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

Benjamin Cherpas
Autor

Done. Thanks !

Benjamin Cherpas
Autor

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
Autor

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

Regards.

Related Posts Replies Zobrazenia Aktivita
Template inheritance not working in Odoo 15
inheritance qweb templates v15
Avatar
Avatar
1
mar 22
8066
How to inherit purchase order body view?
v8 inheritance qweb templates
Avatar
Avatar
2
mar 15
8557
how to change tooltip question mark symbol? Solved
web inheritance qweb templates frontend
Avatar
1
dec 23
2521
How to remove template changes made by other addons?
inheritance qweb templates overwriting overriding
Avatar
Avatar
1
sep 22
6550
Odoo 11: custom report generate empty pdf (html works fine) Solved
pdf qweb templates v11.0 odoov11
Avatar
Avatar
Avatar
Avatar
Avatar
11
feb 19
23831