Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
6 ตอบกลับ
12752 มุมมอง

hi i want to addition in date in odoo directives in odoov8

in reports i print invoice date using

<span t-field="o.date_invoice"/>;

now i want to add days in this date meansmy invoice date is 10/01/2015 and my pament term days is 15 so i want to add 15 days in date in report.xml file through qweb directives so output is 10/16/2015 (10/01/2015(mm/dd/yyyy) + 15days = 10/16/2015)

i get payment term days from this

<tr t-foreach="o.payment_term.line_ids" t-as="pl">

<td> <span t-field="pl.days"/> </td> 

</tr>

so how can i do addition in date in qweb directives

อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

I have solved it with this line of codes. Try it to print in invoice report

<div t-esc="( datetime.datetime.strptime(o.date_invoice, '%Y-%m-%d %H:%M:%S') + datetime.timedelta(days=15) ).strftime('%m/%d/%Y')">
 

Kind Regards,

อวตาร
ละทิ้ง

Thank you, Jaydeep.

+1 from me.

It works in Odoo 11 thank you

คำตอบที่ดีที่สุด

hi,

i have solved it with this line of codes. In my example i had adapted the report_saleorder.xml. 

<span t-set="d_delta" t-value="datetime.timedelta(days=17)"/>

<span t-set="d_dateorder" t-value="datetime.datetime.strptime(doc.date_order,'%Y-%m-%d %H:%M:%S')"/>

<span t-set="d_paydate" t-value="d_dateorder + d_delta"/>

<span t-esc="d_paydate.strftime('%d.%m.%Y')"/>

To use the datetime object you have to import the datetime object. --&gt; from datetime import datetime, timedelta this i have added to sale_report.py. 

best regards

อวตาร
ละทิ้ง
ผู้เขียน

i try with this code

but it gives following error ""'str' object has no attribute 'strptime'" while evaluating "o.date_invoice.strptime('%Y-%m-%d %H:%M:%S')"" while evaluating "translate_doc(doc_id, doc_model, 'partner_id.lang', 'account.report_without_prices_document')"
ผู้เขียน

my code is

ผู้เขียน

in my opinion you have to put your date_invoice into the braces of the strptime. Have look on the python website https://docs.python.org/2/library/time.html

Related Posts ตอบกลับ มุมมอง กิจกรรม
1
ก.พ. 25
1493
0
ธ.ค. 17
3688
1
ก.ย. 17
5216
2
ก.พ. 17
7311
1
ส.ค. 16
16702