Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Comptabilitat
Inventari
PoS
Projectes
MRP

All apps

All Posts People Badges

Etiquetes (View all)

odoo accounting v14 pos v15

About this forum

Ajuda

[SOLVED] [12] How to enable "reduce" function in odoo report?

2 Respostes

3649 Vistes

Paolo Subiaco

Hi all,
I'd like to use the following function to compute the total cost of goods in the transport document:

reduce(lambda x, y: x+y['product_id']['product_tmpl_id']['list_price']*y['product_uom_qty'], o.move_lines, 0)

With odoo 8 and python2, it worked perfectly.
Now, with odoo 12 and python 3, the report generation return the error
NameError: name 'reduce' is not defined

I believe that I have to import the reduce function

from functools import reduce

in some scripts, but I don't know which script is responsible for report generation. I'm including the python errors below.
Thanks in advance!!

Paolo

Traceback (most recent call last):
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/qweb.py", line 347, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_paolo_reports_report_ddt_39
  File "<template>", line 2, in body_call_content_38
NameError: name 'reduce' is not defined

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/web/controllers/main.py", line 1671, in report_download
    response = self.report_routes(reportname, docids=docids, converter=converter)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/http.py", line 519, in response_wrap
    response = f(*args, **kw)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/web/controllers/main.py", line 1612, in report_routes
    pdf = report.with_context(context).render_qweb_pdf(docids, data=data)[0]
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/ir_actions_report.py", line 713, in render_qweb_pdf
    html = self.with_context(context).render_qweb_html(res_ids, data=data)[0]
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/ir_actions_report.py", line 753, in render_qweb_html
    return self.render_template(self.report_name, data), 'html'
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/ir_actions_report.py", line 535, in render_template
    return view_obj.render_template(template, values)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/ir_ui_view.py", line 1305, in render_template
    return self.browse(self.get_view_id(template)).render(values, engine)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render
    return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/ir_ui_view.py", line 1314, in render
    return self.env[engine].render(self.id, qcontext)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/ir_qweb.py", line 60, in render
    result = super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/qweb.py", line 275, in render
    self.compile(template, options)(self, body.append, values or {})
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/qweb.py", line 349, in _compiled_fn
    raise e
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/qweb.py", line 347, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_1298_8
  File "<template>", line 2, in body_call_content_7
  File "<template>", line 3, in foreach_6
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/qweb.py", line 354, in _compiled_fn
    raise QWebException("Error to render compiling AST", e, path, node and etree.tostring(node[0], encoding='unicode'), name)
odoo.addons.base.models.qweb.QWebException: name 'reduce' is not defined
Traceback (most recent call last):
  File "/home/odoo12p/odoo/lib/python3.7/site-packages/odoo/addons/base/models/qweb.py", line 347, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_paolo_reports_report_ddt_39
  File "<template>", line 2, in body_call_content_38
NameError: name 'reduce' is not defined

Error to render compiling AST
NameError: name 'reduce' is not defined
Template: paolo_reports.report_ddt
Path: /templates/t/t/div/table[2]/tbody/tr[2]/td[7]/p/span
Node: <span t-esc="reduce(lambda x, y: x+y['product_id']['product_tmpl_id']['list_price']*y['product_uom_qty'], o.move_lines, 0)" t-esc-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: &quot;o.partner_id.company_id.currency_id&quot;, &quot;precision&quot;:&quot;-3&quot;}"/>

Paolo Subiaco

Autor Best Answer

Hi.

Thanks to Luca Subiaco suggestion, I changed the way to compute the total value of goods in the transfer document, using a variable that is updated for each line while the list of goods is loaded in the report.

In other words, instead of computing the total value in a shot, using the folllowing operation that does not work with odoo 12

reduce(lambda x, y: x+y['product_id']['product_tmpl_id']['list_price']*y['product_uom_qty'], o.move_lines, 0)

I have set a variable total_value that accumulate the total value of goods in the for cycle that prints the list of products:

<t t-set="total_value" t-value="0"/>
<tr t-foreach="o.line_ids" t-as="line">
....
  <t t-if="o.show_price">
    <t t-set="price" t-value="line.price_unit" />
    <t t-if="price==0"><t t-set="price" t-value="line.product_id.product_tmpl_id.list_price" /></t>
    <td class="text-right"><span t-esc="price" t-options='{"widget": "float", "precision": 5}'></span></td>
    <td class="text-right"><span t-esc="(price*line.product_uom_qty)" t-options='{"widget": "float", "precision": 4}'/></td>
    <t t-set="total_value" t-value="total_value + (price * line.product_uom_qty)"/>
 </t>
...
<td t-if="o.show_price">
 <small>Total without taxes</small><br/>
 <span t-esc="total_value" t-options='{"widget": "float", "precision": 2}'/>
</td>

Hope this solution can help anyone that needs this feature.

Paolo

Ravi Gadhia

Actually, in V8 qweb AST parser not implemented and every expression eval by safe_eval.
safe_eval provide reduce function as a python built-in explicitly but reduce is not true global built-in python3 it's part of functools lib so it's working in V8

ref:
Python 2.7.16 (default, Jun 19 2019, 07:40:37)
[GCC 4.2.1 Compatible Apple LLVM 10.0.1 (clang-1001.0.46.4)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> sum
<built-in function sum>
>>> reduce
<built-in function reduce>

Python 3.7.4 (default, Sep 7 2019, 18:27:02)
[Clang 10.0.1 (clang-1001.0.46.4)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> sum
<built-in function sum>
>>> reduce
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
NameError: name 'reduce' is not defined
>>>

here another workaround is you can create a helper function on the model and call it from qweb template

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrar-se

This question has been flagged

Enjoying the discussion? Don't just read, join in!