Alla inlägg Personer Utmärkelser

Etiketter (Visa alla)

Om detta forum

Hjälp

[Odoo 10.0]QWeb Report: Remove trailing Zeros from product quantity

qweb report zero 10.0

5 Svar

9934 Vyer

Ermin Trevisan

When printing invoices and order documents, I would like to remove trailing zeros, in order to get the following results:

- Odoo quantity: 1.000 -> printed quantity: 1
- Odoo quantity: 1.500 -> printed quantity: 1.5
- Odoo quantity: 2.750 -> printed quantity: 2.75

Based on Steve Mack's answer I tried the following in my QWeb amendment of the invoice document:

<xpath expr="//span[@t-field='l.quantity']" position="replace">
                <t>
                    <t t-set="mod_qty">
                        formatLang(l.quantity, digit=0)
                    </t>
                    <t t-if="mod_qty == l.quantity">
                        <span><t t-esc="mod_qty"/></span>
                    </t>
                    <t t-if="mod_qty != l.quantity">
                        <span><t t-esc="(l.quantity * 1)"/></span>
                    </t>
                </t>
            </xpath>

But the result is not as desired, instead of "1", I receive "1.0", the other examples work properly. My result is:

https://imgur.com/a/kemkwbg

https://vishnu-v-nath.odoo.com/, Vishnu V Nath

Hii,try this
you will get wot u need :)
create new field 'quantity_new' and give onchange function for quantity

@api.onchange('quantity')
def onchange_quantity_for_demo(self):
a = self.quantity
b = str(a)
x=b.split(".")
if int(x[1])>0:
self.quantity_new = b
else:
self.quantity_new = str(x[0])

thank you

Pandya Rahul

Bästa svar

Hello, Decimal Precision will help to set the required number of digits in the amount.

<span>
	<t t-esc="mod_qty" t-options='{"widget": "float", "precision": 2}'/>
</span>

Pandya Rahul

Dessertwerks, Vlad Ignatov

Added my code in the comment to the accepted answer. That code got me the answer that the post was asking for.

1.000 >> 1

1.100 >> 1.1

1.110 >> 1.11

1.111 >>> 1.111

Fawzy Ahmed

Hi,

Please try this

<span t-esc="'%.0f'% line.qty"/>

Thanks !!!

Aswini @ iWesabe

Ermin Trevisan

Författare

Thank you for your answer, but this does not work of course. You can test and check it yourself:

- Odoo quantity: 1.000 -> result in report: 1

- Odoo quantity: 2.000 -> result in report: 2, but:

- Odoo quantity: 1.500 -> result in report: 2 (instead of 1.5)

- Odoo quantity: 2.750 -> result in report: 3 (instead of 2.75)

Dessertwerks, Vlad Ignatov

SlyK

You could use Python to convert a `float` into a `str` and then strip it of the trailing zeros. For example:

>>> for x in (1, 2.000, 2.750): str(x)
... 
'1'
'2.0'
'2.75'

So we can define a function like this:

def parse_num(x):
    x = str(x)
    integer, decimals = x.split('.') if '.' in x else (x, None)    
    if decimals in ('0', None):
        return integer
    else:
        return x

Which results in:

>>> for x in (1, 2.000, 2.750): parse_num(x)
... 
'1'
'2'
'2.75'

So maybe you could try with this:

<t t-set="mod_qty">
    formatLang(l.quantity, digit=0)
</t>
<t t-if="mod_qty == l.quantity">
    <span><t t-esc="parse_num(mod_qty)"/></span>
</t>
<t t-if="mod_qty != l.quantity">
    <span><t t-esc="parse_num(l.quantity * 1)"/></span>
</t>

Rajkumar

Try this:

<t t-if="mod_qty == l.quantity">
<span><t t-esc="int(float(mod_qty))"/></span>
</t>
<t t-if="mod_qty != l.quantity">
<span><t t-esc="int(float(l.quantity * 1))"/></span>
</t>

Ermin Trevisan

Författare

Unfortunately, this does not work either, as it always delivers a number without any decimals (but not rounded).

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
odoo 16 report target new page scss qweb report	1 apr. 25	4098
Missing external identifier on new external layout template Löst qweb report	2 mars 25	4870
Translate month name in t-esc Qweb report Löst qweb report	4 nov. 24	10061
QWeb Report Shows Different When Edit And Print Review Löst qweb report	1 mars 24	4711
How display the currency symbol before the subtotal value on Quotation report? Löst qweb report	3 sep. 23	27801

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!