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
- Kế toán
- Tồn kho
- PoS
- Dự án
- MRP
Câu hỏi này đã bị gắn cờ
1
Trả lời
193
Lượt xem
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 |
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
How do datetime fields work in Odoo?
Đã xử lý
|
|
1
thg 11 25
|
208 | |
|
2
thg 10 25
|
33677 | ||
|
2
thg 10 25
|
952 | ||
|
1
thg 11 25
|
1456 | ||
|
0
thg 8 25
|
1457 |
