İçereği Atla
Bu soru işaretlendi
pythonodoo-13
2 Cevaplar
6701 Görünümler
Avatar
Bryan

I'm creating a custom report in the Invoice module.

<span class="text-nowrap" t-esc="doc.invoice_payments_widget" />

I added the above code and it returns jSON format. But I need to get the amount only.

{"title": "Less Payment", "outstanding": false, "content": [{"name": "Customer Payment: INV/2021/0006", "journal_name": "Bank", "amount": 500.0, "currency": "$", "digits": [69, 2], "position": "before", "date": "2021-03-26", "payment_id": 25, "account_payment_id": 2, "payment_method_name": "Manual", "move_id": 11, "ref": "BNK1/2021/0002 (INV/2021/0006)"}]}

Avatar
Vazgeç
Avatar
Akshay
En İyi Yanıt 
<t t-set="total" t-value="0"/>
<t t-set="payments_vals" t-value="doc.sudo()._get_reconciled_info_JSON_values()"/>
<t t-foreach="payments_vals" t-as="payment_vals">
    <t t-set="total" t-value="total + payment_vals['amount']" />
</t>
<span class="text-nowrap" t-esc="total" />

there will be cases where you will have more than one payment line. So its better to use the above code.
Avatar
Vazgeç
Bryan
Üretici

Is it possible to display the currency as well?

Akshay

<span class="text-nowrap" t-esc="total" t-options='{"widget": "monetary", "display_currency": doc.currency_id}' />

Bryan
Üretici

Thank you! My first time to develop in Odoo.

Avatar
Equick ERP
En İyi Yanıt

Hello 

In json format you are getting the "account_payment_id". so using this account payment id you will get amount from the account payment.

Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
new python env
python
Avatar
0
Mar 25
1379
What means "Too many values to unpack" message? Çözüldü
python
Avatar
Avatar
Avatar
Avatar
Avatar
4
Nis 24
174294
have no data in screen. read data in my own module from different model
python
Avatar
0
Ara 23
2173
How to insert value to a one2many field in table with create method? Çözüldü
python
Avatar
Avatar
Avatar
Avatar
Avatar
5
Tem 25
228094
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Avatar
Avatar
1
Ağu 23
4593