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:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Qweb comprehension list if date between

date qweb between sum

9 Răspunsuri

6034 Vizualizări

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

Autor Cel mai bun răspuns

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

Autor

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

Autor

docs are account.invoices

how can i do proper date comparison please?

Thomas DUPORT

Autor

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.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
QWeb report : calculate number of days late for task deadlines date qweb	2 oct. 21	8607
Qweb report compare a field date with today date Rezolvat date qweb report	1 feb. 25	2399
how to take purchase order of a partner in between two dates? date purchase_order between	0 oct. 24	3101
Problem with date filter BETWEEN two dates filter date between v18	2 mai 25	2137
How to avoid unicode transformation of my data passed to a report parser? Rezolvat date qweb format unicode	2 feb. 16	6877

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!