Sum on QWeb reports

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

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Project
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

Sum on QWeb reports

v8 qweb reporting

3 Réponses

43437 Vues

José

Hello, I have Odoo 8 and I am developing a QWeb report. Is there any way to sum any field in a t-foreach loop and then display the result of the sum? How?

Thanks!

EDIT

...            
       <t t-set="total" t-value="0" />

            <table class="table table-condensed">
                <thead>
                    <tr>
                        <th>Fecha</th>
                        <th>Documento</th>
                        <th>Detalle</th>
                        <th>Total sin impuestos</th>
                        <th>Total con impuestos</th>
                    </tr>
               </thead>
               <tbody class="sale_tbody">

                    <tr t-foreach="docs" t-as="l">
                        <td>
                           <span t-field="l.date_order"/>
                        </td>
                        <td>
                            <span t-field="l.name"/>
                        </td>
                        <td>
                            <table class="table table-condensed">
                                <thead>
                                    <tr>
                                        <th>Producto</th>
                                        <th>Cantidad</th>
                                        <th>Precio unitario</th>
                                        <th>Fecha del viaje</th>
                                        <th>Destino</th>
                                        <th>Remito SyE</th>
                                        <th>Chofer</th>
                                        <th>Subtotal</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr t-foreach="l.order_line" t-as="a">
                                        <td>
                                            <span t-field="a.product_id" />
                                        </td>
                                        <td>
                                            <span t-field="a.product_uom_qty" />
                                        </td>
                                        <td>
                                            <span t-field="a.price_unit" />
                                        </td>
                                        <td>
                                            <span t-field="a.fecha" />
                                        </td>
                                        <td>
                                            <span t-field="a.destino" />
                                        </td>
                                        <td>
                                            <span t-field="a.numero_remito" />
                                        </td>
                                        <td>
                                            <span t-field="a.chofer" />
                                        </td>
                                        <td>
                                            <span t-field="a.price_subtotal" />
                                        </td>
                                    </tr>   
                                </tbody>
                            </table>
                        </td>
                        <tr>
                            <td /><td /><td />
                            <td>
                                <span t-field="l.amount_untaxed" />
                            </td>
                            <td>
                                <span t-field="l.amount_total" />
                            </td>

                            <t t-set="total" t-value="total+l.amount_total" />

                        </tr>
                    </tr>                    
                </tbody>
            </table>

            <h3>Total: $<t t-esc="total" /></h3>

In bold I mark the lines where I do the sum.

Vasanth

Hi jose: In py file: def funct_total(self, form): result = [] res = {} res = { 'tot_num1': tot['num1'], 'tot_num1': tot['num2'], 'tot_total': tot['num1'] + tot['num2'], } result.append(res) return result In xml file( report file):

Zbik

Meilleure réponse

Try like this:

<t t-set="test_variable" t-value="100"/>
<p t-foreach="[10, 20, 30]" t-as="i"> 
  <t t-set="test_variable" t-value="test_variable+i"/> 
</p> 
<h1>RESULT=<t t-esc="test_variable"/></h1>

José

Auteur

I get RESULT=100

Zbik

You update your code, see this commit: https://github.com/odoo/odoo/commit/4a698da8b37055922be75a85f76d750dfbbadd42

José

Auteur

I do: Loop... (Where "l" is the item on which loop) End of loop...

Total: $

and I get total: 0 at the end. Why? l.amount_total is not 0, I display these values and there are not 0.

Zbik

Your code? PS. test_variable must be defined before loop

Zbik

Variable "l" after loop no more exists in global context!

José

Auteur

See the code in my question, I edit it. Here is the complete code.

Zbik

You loops many object .... foreach="docs" ... probably variable scope is only one object, I test later.

Zbik

In my test system, total with ... foreach="docs" ... works ok!

José

Auteur

I don't understand, where is my mistake?

José

Auteur

I try your code, I copy it exactly, and I get "RESULT=100"... so what is the problem?

Zbik

Your system is updated and include commit to which I gave the link?

José

Auteur

Probably my system is not updated. What is the best way to update Odoo without losing information?

Zbik

Update procedure depends on what you are running linux or windows, and how it is being installed See https://doc.odoo.com/install/linux/updating/

José

Auteur

I have Windows 7 x64. If I download the branch, https://github.com/odoo/odoo it is for Windows?

Zbik

My suggestion, you use http://nightly.odoo.com/ and read https://www.odoo.com/documentation/8.0/setup/install.html

José

Auteur

It works! Please check if I updated Odoo correctly. 1) Download nightly latest version .exe. 2) Copy "addons" folder to temp directory. 3) Delete old version of Odoo. 4) Install new version of Odoo. 5) Copy "addons" folder to the addons folder of the new version of Odoo. At the moment, all works OK, I do the update correctly? Thanks you a lot!

Zbik

next step... update all modules ... or select as admin, module "base" (from module list) and update it.

Kirubanidhi Rajarathinam

Calculate total fine amount code. Book_id is a one2many fields.

<t t-set="test_variable" t-value="test_variable+l.fine" />

<span t-field="l.fine" />

</td>

</t>

Rathan

Qweb code to sum the amount by column:

<td>

    <t t-set="sum_row2" t-value="0"/>
    <t t-foreach="doc.line_ids" t-as="line">
        <t t-set="sum_row2" t-value="sum_row2+line.amount_2"/>
    </t>
    <t t-esc="sum_row2"/>

</td>

For example (sum Amount_2 column):

Amount_1	Amount_2
0	10
0	20
	30

joyanto

thanks

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
Problem with QWeb report v8 qweb reporting odoo8	2 mai 15	7515
A module with a print button so I can learn? v8 qweb print reporting	0 mars 15	2611
Page number qweb-pdf v8 qweb reporting pagenumber	1 mars 15	11480
How can I display all tasks (including completed ones) in a QWeb report in Odoo? qweb reporting	2 sept. 24	1565
QWEB: Place full width image on page Résolu v8 qweb	1 juin 21	7741

Cette question a été signalée

Total: $

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !