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

CRM
e-Commerce
Contabilidad
Inventario
PoS
Proyectos
MRP

All apps

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Acerca de este foro

Ayuda

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

2 Respuestas

3658 Vistas

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 Mejor respuesta

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

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Registrarse

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!