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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Sum on QWeb reports

v8 qweb reporting

3 Odpowiedzi

44908 Widoki

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

Najlepsza odpowiedź

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é

Autor

I get RESULT=100

Zbik

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

José

Autor

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é

Autor

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é

Autor

I don't understand, where is my mistake?

José

Autor

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é

Autor

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é

Autor

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é

Autor

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

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Problem with QWeb report v8 qweb reporting odoo8	2 maj 15	8538
A module with a print button so I can learn? v8 qweb print reporting	0 mar 15	3512
Page number qweb-pdf v8 qweb reporting pagenumber	1 mar 15	12633
How can I display all tasks (including completed ones) in a QWeb report in Odoo? qweb reporting	2 wrz 24	3157
QWEB: Place full width image on page Rozwiązane v8 qweb	1 cze 21	8810

To pytanie dostało ostrzeżenie

Total: $

Podoba Ci się ta dyskusja? Dołącz do niej!