Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
odoo8
4 Odgovori
9335 Prikazi
Avatar
Nischal

using the below code, i want to display unique packages and not duplicate them. But still i have one package gets duplicated if result_package_id is same for first and last iteration of pack_operation_ids. Is there a way to save all the result_package_id in a array and then match it in every loop of pack_operation_ids

            <?xml version="1.0"?>

            <t t-name="stock.report_picking_packaging">

            <t t-call="report.html_container">

            <t t-foreach="docs" t-as="o"> 

            <t t-set="prev" t-value="0" />

            <p> <t t-esc="prev"/><b>Prev: </b></p>

              <tr t-foreach="o.pack_operation_ids" t-as="n">

              <t t-set="new" t-value="n.result_package_id" />

                 <p><t t-esc="new"/><b>new: </b></p>

                 <p t-if="new != prev"><b>Package name: </b><span t-field="n.result_package_id"/></p>

                 <t t-set="prev" t-value="n.result_package_id" />

                <p> <t t-esc="prev"/><b>Prev: </b></p>

           <br/>

            </tr>

           </t>

          </t>

           </t>


below is the display

0Prev:

stock.quant.package(21,)new:

Package name: BOX0018

stock.quant.package(21,)Prev:

stock.quant.package(20,)new:

Package name: BOX0017

stock.quant.package(20,)Prev:

stock.quant.package(20,)new:

stock.quant.package(20,)Prev:

stock.quant.package(19,)new:

Package name: BOX0016

stock.quant.package(19,)Prev:

stock.quant.package(19,)new:

stock.quant.package(19,)Prev:

stock.quant.package(21,)new:

Package name: BOX0018

stock.quant.package(21,)Prev:




 Working code, help from Jaydeep Barot.

                   <t t-name="stock.report_picking_packaging">

                   <t t-foreach="docs" t-as="o">

                  <t t-call="report.html_container">

                 <h1>PACKAGES</h1>

                     <table class="table table-condensed" t-if="o.pack_operation_ids">

                     <thead>

                       <tr>

                       <th><strong>Package Name</strong></th>

                        </tr>

                       </thead>

                      <tbody>

                      <t t-set="package" t-value="list(set([ pack.result_package_id for pack in o.pack_operation_ids if                      pack.result_package_id]))"/>

                         <tr t-foreach="package" t-as="p">

                         <td><span t-esc="p.name"/>

                               <p><b>Package size (LXWXH): </b><span t-field="p.length"/><b>X</b><span t-field="p.width"/><b>X</b><span t-field="p.height"/></p>

                                 <p><b>Package net_weight: </b><span t-field="p.total_estim_weight_net"/><b>Package gross_weight: </b>                                    <span t-field="p.total_estim_weight"/></p>

                                      </td>

                                   <tr t-foreach="p.quant_ids" t-as="q">

                                    <td><p><b>Product Inside: </b><span t-field="q.product_id"/><b>Product Qty: </b><span t-field="q.qty"/>                                      </p></td>

                                     </tr>

                                       </tr>

                                     </tbody>

                                      </table>

                              </t>

                              </t>

                               </t>

Avatar
Opusti
Nischal
Avtor

with help from Jaydeep Barot, i got below code to work, which might help others looking for help

PACKAGES

Package Name

Package size (LXWXH): XX

Package net_weight: Package gross_weight:

Product Inside: Product Qty:

Nischal
Avtor

PACKAGES

Package Name

Package size (LXWXH): XX

Package net_weight: Package gross_weight:

Product Inside: Product Qty:

Avatar
Jaydeep Barot (jar)
Best Answer

Hello Nischal,

Using this code :

<?xml version="1.0"?>

<t t-name="stock.report_picking_packaging">

<t t-call="report.html_container">

<t t-foreach="docs" t-as="o">

<t t-set="prev" t-value="0" />

<p> <t t-esc="prev"/><b>Prev: </b></p>

<tr t-foreach="o.pack_operation_ids" t-as="n">

<t t-set="new" t-value="n.result_package_id.id" />

<p><t t-esc="new"/><b>new: </b></p>

<p t-if="new != prev"><b>Package name: </b><span t-field="n.result_package_id"/></p>

<t t-set="prev" t-value="n.result_package_id.id" />

<p> <t t-esc="prev"/><b>Prev: </b></p>

<br/>

</tr>

</t>

</t>

</t>


It's display below: 

==============

0Prev:

21 new:

Package name: BOX0018

21 Prev:

20 new:

Package name: BOX0017

20 Prev:

19 new:

Package name: BOX0016

19 Prev:

21 new:

Package name: BOX0018

21 Prev:



=========================================

Here is remove duplicate packages.

=========================================

<h1>PACKAGES</h1>

<table class="table table-condensed" t-if="o.pack_operation_ids">

<thead>

<tr>

<th><strong>Package Name</strong></th>

</tr>

</thead>

<tbody>

<t t-set="package" t-value="list(set([ pack.result_package_id for pack in o.pack_operation_ids if pack.result_package_id]))"/>

<tr t-foreach="package" t-as="p">

<td><span t-esc="p.name"/></td>

</tr>

</tbody>

</table>

Avatar
Opusti
Nischal
Avtor

Dear jaydeep, I dont want to display the same package twice, for e.g BOX0018. the system does that because of the multiple operations performed with the same package(BOX) and reports it in sequence as performed. While reporting i want it to display the package once but the content inside should be shown below the BOX.

Nischal
Avtor

Thanks Jaydeep, using the your updated code i was able to achieve what i was looking for. comment updated

Avatar
Zbik
Best Answer

Try like this:

<t t-set="FOO" t-value="[1, 2, 3, 1, 2, 5, 1, 5, 6, 7, 8]"/>
<t t-foreach="o.loop_ids" t-as="n">
  ...
  <t t-esc="FOO.append(n.id)"/>
</t>
Result without duplicates: <t t-esc="list(set(FOO))"/>  

UPDATED:

<t t-set="FOOX" t-value="list(set(FOO))"/> 
<t t-foreach="FOOX" t-as="x">
<t t-esc="x"/>
</t>


If appended ids 328,329, result = [1, 2, 3, 5, 6, 7, 8, 328, 329]


Avatar
Opusti
Nischal
Avtor

Thanks Zbik, I tried the code below but it gives me same result Box0018 gets duplicated. Did i do something wrong. or should i use the output resulting id's in next iteration(but how) Also if you can please explain me the t-value used in this solution

Prev:

ops_ids:

new:

Package name:

Prev:


Result without duplicates:
Zbik

t-value is only for example. In the real solution you should use t-value="[]" and FOO ids in next iteration.

Nischal
Avtor

Thanks Zbik, But how to use the FOO ids as o.pack_operation_ids in next iteration? it gives me error if i use FOO insted of o.pack_operation_ids.

Zbik

Answer updated with example

Nischal
Avtor

Dear Zbik, I still fail to understand how to use the appended ids available(my apologies as i am not a developer).. The pack_operation_ids gives me value like "stock.pack.operation(id,)" but is just a number(i.e the id). i am not able to use it in the next iteration.

Related Posts Odgovori Prikazi Aktivnost
Selecting items for one2many relation Solved
odoo8
Avatar
Avatar
Avatar
2
dec. 22
15787
How to upload files automatically on attachments on button click ?
odoo8
Avatar
Avatar
1
nov. 21
5884
Field company_registry missing in partner table
odoo8
Avatar
0
jan. 21
3047
How I disable Import Button for certain model in odoo8? Solved
odoo8
Avatar
Avatar
Avatar
Avatar
Avatar
8
maj 20
8855
why blank page with top menu only visible after login? odoo 8
odoo8
Avatar
0
dec. 23
3604