Hello, i'm in odoo 10 in qweb report I want to browse my invoices records ( ) and i want to sum the total_amount for all invoices where the date_invoice is in january, then for february etc... I've tried this: But there is the following error SyntaxError: unexpected EOF while parsing Error when compiling AST SyntaxError: unexpected EOF while parsing

Try this: = datetime.date(2019,1,1) and rec.date_invoice

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

Qweb comprehension list if date between

date qweb between sum

9 ตอบกลับ

6086 มุมมอง

Thomas DUPORT

Hello, i'm in odoo 10 in qweb report

I want to browse my invoices records ( <tr t-foreach="docs" t-as="o">)

and i want to sum the total_amount for all invoices where the date_invoice is in january, then for february etc...

I've tried this:

<t t-set="adquat_janvier" t-value="sum([o.amount_total for o in docs if date_invoice in ('20190101','20190131') ])"/>

But there is the following error

SyntaxError: unexpected EOF while parsing

Error when compiling AST
SyntaxError: unexpected EOF while parsing (<unknown>, line 0)
Template: 1126
Path: /templates/t/t/t/t[2]
Node: <t t-content="True"/>

I've tried this too :

<t t-set="adquat_janvier" t-value="sum([(date_invoice in ('20190101','20190131') and o.amount_total)  for o in docs ])"/>

How can i set debug mode ? (with pdb ?)

Thomas DUPORT

ผู้เขียน คำตอบที่ดีที่สุด

Ok so I completely change my method :

I've done a class and a method to teturn all the data I need :


class ReportCalendrierAdherent(models.AbstractModel):
    _name = 'report.adquat_distribinox_report.report_calendrier_adherent'

    @api.model
    def get_report_values(self, docids, data=None):

...

    docargs = {
        'doc_ids': docids,
        'doc_model': 'account.invoice',
        'docs': self.env['account.invoice'].browse(docids),
        'arg_partner': invoices[0].partner_id,
        'arg_lines': lines,
        'arg_line_total': line_total,
    }
    return docargs

Hilar Andikkadavath

Try this:

<t t-set="adquat_janvier"
   t-value="sum([docs.filtered(lambda rec: rec.date_invoice >= datetime.date(2019,1,1) and rec.date_invoice <= datetime.date(2019,1,31)).mapped('amount_total')])"/>

Thomas DUPORT

ผู้เขียน

Sorry it doesn't whork, this is the error :

Error to render compiling AST

TypeError: unsupported operand type(s) for +: 'int' and 'list'

Template: 1154

Path: /templates/t/t/t/table/tbody/tr/t

Node: <t t-set="adquat_janvier" t-value="sum([docs.filtered(lambda rec: rec.date_invoice in ('20190101','20190131')).mapped('amount_total')])"/>

Hilar Andikkadavath

what are docs here?

Hilar Andikkadavath

you should update rec.date_invoice in ('20190101','20190131') with proper date comparison

Thomas DUPORT

ผู้เขียน

docs are account.invoices

how can i do proper date comparison please?

Thomas DUPORT

ผู้เขียน

Do you know if i can do all my treatment in python and return the correct values at qweb at the end ?

Hilar Andikkadavath

for example:

str(datetime.date(2019,1,1)) in ('2019-01-01') or datetime.date(2019,1,1) == date(2019,1,1) or datetime.date(2019,1,1) in [datetime.date(2019,1,1),datetime.date(2019,1,2)]

Hilar Andikkadavath

check my updated answer, maybe you need this.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
QWeb report : calculate number of days late for task deadlines date qweb	2 ต.ค. 21	8634
Qweb report compare a field date with today date แก้ไขแล้ว date qweb report	1 ก.พ. 25	2425
how to take purchase order of a partner in between two dates? date purchase_order between	0 ต.ค. 24	3101
Problem with date filter BETWEEN two dates filter date between v18	2 พ.ค. 25	2145
How to avoid unicode transformation of my data passed to a report parser? แก้ไขแล้ว date qweb format unicode	2 ก.พ. 16	6893

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!