Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
2 Odpowiedzi
25335 Widoki
Awatar
Mohssin Bouktaib

Hello Community ,I'm facing a probleme ,i want to create an invoice wich show the list of product sales grouped by category 

i tried this

<t t-foreach="o.order_line" t-as="l">

<t t-if="l.product_id.categ_id">

<tr>  <td>

<span t-field="l.product_id.categ_id"/>

</td> </tr> </t>


but dosen't groub all products it show this result:

category 1

product 1

category 1

product 2


i want this resulat 

category 1

product 1

product 2

etc ...

thanks in advance


Awatar
Odrzuć
Awatar
Jusab Sida (jsi)
Najlepsza odpowiedź

Here is the code for grouping...

<t t-set="product_category" t-value="[]"/>
<t t-foreach="o.order_line" t-as="l">
    <t t-set="product_category" t-value="product_category+[l.product_id.categ_id]"/>
</t>
<t t-foreach="set(product_category)" t-as="category">
    <div><strong t-esc="category.name"/></div>
    <t t-foreach="o.order_line" t-as="l">
        <t t-if="category.id==l.product_id.categ_id.id">
            <div><span t-field="l.product_id"/></div>
        </t>
    </t>
</t>
Awatar
Odrzuć
Giezel Esteves

Thanks so much Jusab. Big help.

IGNACIO RODRIGUEZ DIAZ

This idea remains valid 8 years later with Odoo 17. It has been a great help. Thank you!

Awatar
CHIOZZA GIOVANNI
Najlepsza odpowiedź

Hello,
what have I to do group on main product that has several optional products connected ?
Now I got something like this in Order and Invoice.
Main product x ------ 0
Opt prod 1 --- 10€
Opt prod 3 --- 22€
.... so on

I would like to have a grouping on main product like this 

Main product x ------ 32€
Main product y ------ 56€
Main product z ------ 34€
Totale ----------------122€

Thanks

Awatar
Odrzuć