How can i get sum of records between two dates?

Question

hello all,
i have date range from 01/06/2020 to 05/06/2020, in that i have 4 records each records have some calculation like, qty.
i want following result:
*Date: 01/06/2020*
*            record 1: 10 qty*
*            record 2: 20 qty*
*            total : 30 qty
*
*Date: 03/06/2020*
*            record 1: 5 qty*
*            record 2: 3 qty*
*            total : 8 qty*
*grand total : 38 qty*
*
*
How can i got this type of result?

Prakash · Accepted Answer

https://speedysense.com/create-custom-report-odoo-12/

Sample Qweb report template based on your requirement:-

<template id="template_id" name="Template">     
                    <t t-call="portal.portal_table">
                        <thead>
                            <tr>
                                <th>Date</th>
                                <th>Record No#</th>
                                <th>Quantity</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr t-foreach="record" t-as="r">
                                <td>
                                    <t t-esc="r.fieldname1"/>
                                </td>
                                <td>
                                    <t t-esc="r.fieldname2"/>
                                </td>
                                <td>
                                    <t t-esc="r.fieldname3"/>
                                </td>
                            </tr>
                        </tbody>
                        <div class="row" name="total">
                            <tr class="border-black">
                                <td colspan="3">
                                    <strong>Total qty:</strong>
                                    <t t-esc="sum([r.fieldname3 for r in record])"/>
                                </td>
                            </tr>
                        </div>
                    </t>
        </template>

Sunray Datalinks Pvt Ltd · Answer

Hello imad chaikhi,
i want this in qweb pdf report.

İlgili Gönderiler	Cevaplar	Görünümler
Calculate Date of retirement python datetime odoo odoo10.0	1 Ara 17	3376
How to make datetime.now() in seconds only? Çözüldü python date datetime odoo8.0	1 Tem 16	5439
Private functions and public functions in odoo python Çözüldü python odoo	3 Şub 25	3070
odoo ghost module python odoo	0 May 24	46
Call python method from inherit_id attribute python odoo	1 Nis 24	3122

Bu soru işaretlendi

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