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
- 회계
- 재고 관리
- PoS
- 프로젝트
- MRP
신고된 질문입니다
1
회신
316
화면
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 |
| 관련 게시물 | 답글 | 화면 | 활동 | |
|---|---|---|---|---|
|
|
1
11월 25
|
340 | ||
|
2
10월 25
|
33791 | ||
|
2
10월 25
|
998 | ||
|
1
11월 25
|
1542 | ||
|
0
8월 25
|
1513 |
