Skip to Content
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
All Posts Люди Значки
Мітки (View all)
odoo accounting v14 pos v15
Про цей форум
Це запитання позначене
dateqwebbetweensum
9 Відповіді
6045 Переглядів
Аватар
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
8609
Qweb report compare a field date with today date Вирішено
date qweb report
Аватар
Аватар
1
лют. 25
2401
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
2138
How to avoid unicode transformation of my data passed to a report parser? Вирішено
date qweb format unicode
Аватар
Аватар
2
лют. 16
6881