I created a new PDF report and I want the datetime fields to show the time in my customer's timezone, not mine.
Version: 19
Related forum post: How do datetime fields work in Odoo?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Knjigovodstvo
- Zaloga
- PoS
- Projekt
- MRP
This question has been flagged
1
Odgovori
307
Prikazi
Step 1: Show timezone field for contacts
By default, contacts are generated with the timezone of the user that creates it. If needed, we can change the timezone for each contact in the database.
Step 2: Indentify or generate your datetime and contact fields
For this use case, we will use a project task that has:
- a datetime field (x_studio_datetime)
- a customer field (partner_id) from which we will get the language.
You can custom the next code based on the technical name of your fields.
Step 3: Generate/edit a PDF report using Studio and add a code like this:
<t t-if="doc.x_studio_datetime">
<!-- Set variables for date and time format based on customer and user language -->
<t t-set="partner_language" t-value="env['res.lang'].search([('code', '=', doc.partner_id.lang)])"/>
<t t-set="partner_dateformat" t-value="partner_language.date_format if partner_language else '%d/%m/%Y'"/>
<t t-set="partner_timeformat" t-value="partner_language.time_format if partner_language else '%H:%M'"/>
<t t-set="user_language" t-value="env['res.lang'].search([('code', '=', user.lang)])"/>
<t t-set="user_dateformat" t-value="user_language.date_format if user_language else '%d/%m/%Y'"/>
<t t-set="user_timeformat" t-value="user_language.time_format if user_language else '%H:%M'"/>
<!-- Set difference between UTC and customer timezone -->
<t t-set="delta" t-value="int(doc.partner_id.tz_offset) / 100"/>
<!-- Set final customer date based on difference from UTC -->
<t t-set="formatted_date" t-value="doc.x_studio_datetime + datetime.timedelta(hours=delta)"/>
<!-- Show date based on customer timezone and format it in customer language -->
<span>Customer Date (<span t-field="doc.partner_id.tz"/>): </span>
<span t-out="formatted_date.strftime(partner_dateformat + ' ' + partner_timeformat )"/>
<!-- Show date and time in user timezone, formatted in user language -->
<div class="oe_structure">User's Date:
<span t-field="doc.x_studio_datetime"/>
</div>
<!-- Show date and time in UTC and format it in user language -->
<div class="oe_structure">UTC Date:
<span t-out="doc.x_studio_datetime.strftime(user_dateformat + ' ' + user_timeformat)"/>
</div>
</t>
Final PDF report result
| Language | Timezone |
Customer | English (US) | Tokyo, Japan |
User | Spanish (Latin America) | Mexico City, Mexico |
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Prijavi| Related Posts | Odgovori | Prikazi | Aktivnost | |
|---|---|---|---|---|
|
|
1
nov. 25
|
331 | ||
|
2
okt. 25
|
33782 | ||
|
2
okt. 25
|
998 | ||
|
1
nov. 25
|
1538 | ||
|
0
avg. 25
|
1513 |
