Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

Về diễn đàn này

Hỗ trợ

Sum on QWeb reports

v8 qweb reporting

3 Trả lời

46339 Lượt xem

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

Câu trả lời hay nhất

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é

Tác giả

I get RESULT=100

Zbik

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

José

Tác giả

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é

Tác giả

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é

Tác giả

I don't understand, where is my mistake?

José

Tác giả

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é

Tác giả

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é

Tác giả

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é

Tác giả

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

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

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
Problem with QWeb report v8 qweb reporting odoo8	2 thg 5 15	9785
A module with a print button so I can learn? v8 qweb print reporting	0 thg 3 15	4510
Page number qweb-pdf v8 qweb reporting pagenumber	1 thg 3 15	13592
How can I display all tasks (including completed ones) in a QWeb report in Odoo? qweb reporting	2 thg 9 24	4623
QWEB: Place full width image on page Đã xử lý v8 qweb	1 thg 6 21	9904

Câu hỏi này đã bị gắn cờ

Total: $

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!