Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
qwebreportzero10.0trailing
5 Antworten
8594 Ansichten
Avatar
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




Avatar
Verwerfen
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

Avatar
Pandya Rahul
Beste Antwort

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>

Avatar
Verwerfen
Pandya Rahul

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

Avatar
Vlad Ignatov
Beste Antwort

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

Avatar
Verwerfen
Avatar
Fawzy Ahmed
Beste Antwort

Hi,

Please try this

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


Thanks !!!  

Aswini @ iWesabe
Avatar
Verwerfen
Ermin Trevisan
Autor

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)

Vlad Ignatov

<t>
<t t-if="round(line.quantity,0) == line.quantity">
<span t-esc="'%.0f'% line.quantity"></span>
</t>
<t t-else="">
<span t-esc="(line.quantity * 1)"></span>
</t>
</t>

Avatar
SlyK
Beste Antwort

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>


Avatar
Verwerfen
Avatar
Rajkumar
Beste Antwort 
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>


Avatar
Verwerfen
Ermin Trevisan
Autor

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

Verknüpfte Beiträge Antworten Ansichten Aktivität
odoo 16 report target new page scss
qweb report
Avatar
Avatar
1
Apr. 25
2196
Missing external identifier on new external layout template Gelöst
qweb report
Avatar
Avatar
2
März 25
2793
Translate month name in t-esc Qweb report Gelöst
qweb report
Avatar
Avatar
Avatar
Avatar
Avatar
4
Nov. 24
8158
QWeb Report Shows Different When Edit And Print Review Gelöst
qweb report
Avatar
Avatar
1
März 24
2969
How display the currency symbol before the subtotal value on Quotation report? Gelöst
qweb report
Avatar
Avatar
Avatar
3
Sept. 23
25989